Tabel SAP B1 - OIPF - Landed Costs
List \ OIPF
Berikut ini adalah kolom yang terdapat pada tabel OIPF di SAP B1
Update: 2026-07-24
| No | Nama Kolom | Tipe Data | Keterangan | Referensi |
|---|---|---|---|---|
| 1. | DocEntry | Integer | ||
| 2. | DocNum | Integer | ||
| 3. | DocDate | Time Stamp | ||
| 4. | DocDueDate | Time Stamp | ||
| 5. | CardCode | NVarchar (15) | OCRD | |
| 6. | SuppName | NVarchar (100) | ||
| 7. | AgentCode | NVarchar (15) | ||
| 8. | AgentName | NVarchar (100) | ||
| 9. | DocStatus | NVarchar (1) | ||
| 10. | AgentNum | NVarchar (16) | ||
| 11. | Descr | NVarchar (250) | ||
| 12. | Ref1 | NVarchar (11) | ||
| 13. | Ref2 | NVarchar (11) | ||
| 14. | DocCur | NVarchar (3) | ||
| 15. | DocRate | Decimal (21, 6) | ||
| 16. | ExpCustom | Decimal (21, 6) | ||
| 17. | ActCustom | Decimal (21, 6) | ||
| 18. | Vat1 | Decimal (21, 6) | ||
| 19. | Vat2 | Decimal (21, 6) | ||
| 20. | BeforeVat | Decimal (21, 6) | ||
| 21. | DocTotal | Decimal (21, 6) | ||
| 22. | CostSum | Decimal (21, 6) | ||
| 23. | DocTime | Smallint | ||
| 24. | Canceled | NVarchar (1) | ||
| 25. | ExCustomFC | Decimal (21, 6) | ||
| 26. | AcCustomFC | Decimal (21, 6) | ||
| 27. | Vat1FC | Decimal (21, 6) | ||
| 28. | Vat2FC | Decimal (21, 6) | ||
| 29. | BeforVatFC | Decimal (21, 6) | ||
| 30. | DocTotalFC | Decimal (21, 6) | ||
| 31. | CostSumFC | Decimal (21, 6) | ||
| 32. | CloseDate | Time Stamp | ||
| 33. | Cost_Match | Decimal (21, 6) | ||
| 34. | C_Match_FC | Decimal (21, 6) | ||
| 35. | BillOfLad | NVarchar (20) | ||
| 36. | TrnspCode | Smallint | ||
| 37. | CostFactor | Decimal (21, 6) | ||
| 38. | UpdateDate | Time Stamp | ||
| 39. | CreateDate | Time Stamp | ||
| 40. | Transfered | NVarchar (1) | ||
| 41. | Instance | Smallint | ||
| 42. | TaxDate | Time Stamp | ||
| 43. | Series | Integer | ||
| 44. | JdtNum | Integer | OJDT | |
| 45. | JdtMemo | NVarchar (254) | ||
| 46. | DataSource | NVarchar (1) | ||
| 47. | UserSign | Smallint | OUSR | |
| 48. | ObjType | NVarchar (20) | ||
| 49. | ExCustomSC | Decimal (21, 6) | ||
| 50. | ActCustSC | Decimal (21, 6) | ||
| 51. | TtlCostSC | Decimal (21, 6) | ||
| 52. | VersionNum | NVarchar (13) | ||
| 53. | OpenForLaC | NVarchar (1) | ||
| 54. | incCustom | NVarchar (1) | ||
| 55. | SeqCode | Smallint | ||
| 56. | Serial | Integer | ||
| 57. | SeriesStr | NVarchar (3) | ||
| 58. | SubStr | NVarchar (3) | ||
| 59. | BuildDesc | NVarchar (50) | ||
| 60. | SupplCode | NVarchar (254) | ||
| 61. | AtcEntry | Integer | ||
| 62. | CustDate | Time Stamp | ||
| 63. | BPLId | Integer | ||
| 64. | DPPStatus | NVarchar (1) | ||
| 65. | EncryptIV | NVarchar (100) |
