Tabel SAP B1 - IPF1 - Landed Costs - Rows
List \ IPF1
Berikut ini adalah kolom yang terdapat pada tabel IPF1 di SAP B1
Update: 2026-07-24
| No | Nama Kolom | Tipe Data | Keterangan | Referensi |
|---|---|---|---|---|
| 1. | DocEntry | Integer | OIPF | |
| 2. | LineNum | Integer | ||
| 3. | BaseType | Integer | ||
| 4. | BaseEntry | Integer | ||
| 5. | ItemCode | NVarchar (50) | OITM | |
| 6. | Dscription | NVarchar (200) | ||
| 7. | Quantity | Decimal (21, 6) | ||
| 8. | PriceFOB | Decimal (21, 6) | ||
| 9. | Currency | NVarchar (3) | ||
| 10. | Rate | Decimal (21, 6) | ||
| 11. | Custom | Decimal (21, 6) | ||
| 12. | CustomFC | Decimal (21, 6) | ||
| 13. | Cost | Decimal (21, 6) | ||
| 14. | CostFC | Decimal (21, 6) | ||
| 15. | PriceAtWH | Decimal (21, 6) | ||
| 16. | PricAtWHFC | Decimal (21, 6) | ||
| 17. | LineTotal | Decimal (21, 6) | ||
| 18. | TotalFrgn | Decimal (21, 6) | ||
| 19. | Volume | Decimal (21, 6) | ||
| 20. | UnitCode | Smallint | ||
| 21. | Weight1 | Decimal (21, 6) | ||
| 22. | UnitCode1 | Smallint | ||
| 23. | Weight2 | Decimal (21, 6) | ||
| 24. | UnitCode2 | Smallint | ||
| 25. | CardCode | NVarchar (15) | ||
| 26. | Reference | NVarchar (16) | ||
| 27. | OrigLine | Integer | ||
| 28. | FactNoCust | Decimal (21, 6) | ||
| 29. | FacWthCust | Decimal (21, 6) | ||
| 30. | PriceList | Smallint | OPLN | |
| 31. | CostOH | NVarchar (1) | ||
| 32. | StockEval | NVarchar (1) | ||
| 33. | UseBaseUn | NVarchar (1) | ||
| 34. | BlockNum | NVarchar (100) | ||
| 35. | ImportLog | NVarchar (20) | ||
| 36. | WhsCode | NVarchar (8) | OWHS | |
| 37. | OrigRow | Integer | ||
| 38. | Locked | NVarchar (1) | ||
| 39. | OrigWhs | NVarchar (8) | OWHS | |
| 40. | ReleaseNum | Integer | ||
| 41. | VarCosts | Decimal (21, 6) | ||
| 42. | ConstCosts | Decimal (21, 6) | ||
| 43. | VarCostsFR | Decimal (21, 6) | ||
| 44. | CnstCostFR | Decimal (21, 6) | ||
| 45. | UserCustom | Decimal (21, 6) | ||
| 46. | UsrCusomFC | Decimal (21, 6) | ||
| 47. | FobValue | Decimal (21, 6) | ||
| 48. | FobValueFC | Decimal (21, 6) | ||
| 49. | TtlExpndLC | Decimal (21, 6) | ||
| 50. | TtlExpndFC | Decimal (21, 6) | ||
| 51. | TtlCustLC | Decimal (21, 6) | ||
| 52. | TtlCustFC | Decimal (21, 6) | ||
| 53. | TtlCostLC | Decimal (21, 6) | ||
| 54. | TtlCostFC | Decimal (21, 6) | ||
| 55. | TtlVolume | Decimal (21, 6) | ||
| 56. | TtlWeight | Decimal (21, 6) | ||
| 57. | BaseRowNum | Integer | ||
| 58. | TtlCustSC | Decimal (21, 6) | ||
| 59. | TtlExpndSC | Decimal (21, 6) | ||
| 60. | OriBAbsEnt | Integer | ||
| 61. | OriBLinNum | Integer | ||
| 62. | TargetDoc | Integer | ||
| 63. | FobValCurr | NVarchar (3) | ||
| 64. | FobnLaC | Decimal (21, 6) | ||
| 65. | FobnLaCFC | Decimal (21, 6) | ||
| 66. | NumPerMsr | Decimal (21, 6) | ||
| 67. | Project | NVarchar (20) | OPRJ | |
| 68. | OcrCode | NVarchar (8) | ||
| 69. | OcrCode2 | NVarchar (8) | ||
| 70. | OcrCode3 | NVarchar (8) | ||
| 71. | OcrCode4 | NVarchar (8) | ||
| 72. | OcrCode5 | NVarchar (8) | ||
| 73. | OriBDocTyp | NVarchar (11) | ||
| 74. | CustRate | Decimal (21, 6) | ||
| 75. | LFixCost | Decimal (21, 6) | ||
| 76. | LFixCostFC | Decimal (21, 6) | ||
| 77. | LVarCost | Decimal (21, 6) | ||
| 78. | LVarCostFC | Decimal (21, 6) | ||
| 79. | CstmsRate | Decimal (21, 6) | ||
| 80. | VatGroup | NVarchar (8) | ||
| 81. | VatPrcnt | Decimal (21, 6) | ||
| 82. | VatSum | Decimal (21, 6) | ||
| 83. | SnbType | NVarchar (20) | ||
| 84. | SnbAbsEnt | Integer | ||
| 85. | SysNumber | Integer | ||
| 86. | DistNumber | NVarchar (36) | ||
| 87. | ExciseSum | Decimal (21, 6) | ||
| 88. | ExcisSumFC | Decimal (21, 6) | ||
| 89. | ExcInStk | NVarchar (1) | ||
| 90. | CustomSum | Decimal (21, 6) | ||
| 91. | CustSumFC | Decimal (21, 6) | ||
| 92. | CstmInStk | NVarchar (1) | ||
| 93. | CstmVatSum | Decimal (21, 6) | ||
| 94. | CstmVatFC | Decimal (21, 6) | ||
| 95. | CstmVatStk | NVarchar (1) | ||
| 96. | CCDEntry | Integer | ||
| 97. | CCDNumber | NVarchar (20) | ||
| 98. | ExcisSumSC | Decimal (21, 6) | ||
| 99. | CustSumSC | Decimal (21, 6) | ||
| 100. | CstmVatSC | Decimal (21, 6) | ||
| 101. | InvQty | Decimal (21, 6) | ||
| 102. | CCDLineNum | Integer | ||
| 103. | TtlVolCCM | Decimal (21, 6) | ||
| 104. | ExcImpQty | Decimal (21, 6) | ||
| 105. | ExcFixAmnt | Decimal (21, 6) | ||
| 106. | ExcRate | Decimal (21, 6) | ||
| 107. | ExcAmntUoM | Decimal (21, 6) | ||
| 108. | ExcAmntAdV | Decimal (21, 6) | ||
| 109. | ExcImpQUoM | Integer | ||
| 110. | ExcBasAmnt | Decimal (21, 6) | ||
| 111. | LineNumV3 | Integer | ||
| 112. | FobVal2 | Decimal (21, 6) | ||
| 113. | FobVal2FC | Decimal (21, 6) | ||
| 114. | EncryptIV | NVarchar (100) |
