Tabel SAP B1 - OJDT - Journal Entry
List \ OJDT
Berikut ini adalah kolom yang terdapat pada tabel OJDT di SAP B1
Update: 2026-07-24
| No | Nama Kolom | Tipe Data | Keterangan | Referensi |
|---|---|---|---|---|
| 1. | BatchNum | Integer | ||
| 2. | TransId | Integer | ||
| 3. | BtfStatus | NVarchar (1) | ||
| 4. | TransType | NVarchar (20) | ||
| 5. | BaseRef | NVarchar (11) | ||
| 6. | RefDate | Time Stamp | ||
| 7. | Memo | NVarchar (254) | ||
| 8. | Ref1 | NVarchar (100) | ||
| 9. | Ref2 | NVarchar (100) | ||
| 10. | CreatedBy | Integer | ||
| 11. | LocTotal | Decimal (21, 6) | ||
| 12. | FcTotal | Decimal (21, 6) | ||
| 13. | SysTotal | Decimal (21, 6) | ||
| 14. | TransCode | NVarchar (4) | ||
| 15. | OrignCurr | NVarchar (3) | ||
| 16. | TransRate | Decimal (21, 6) | ||
| 17. | BtfLine | Integer | ||
| 18. | TransCurr | NVarchar (3) | ||
| 19. | Project | NVarchar (20) | ||
| 20. | DueDate | Time Stamp | ||
| 21. | TaxDate | Time Stamp | ||
| 22. | PCAddition | NVarchar (1) | ||
| 23. | FinncPriod | Integer | ||
| 24. | DataSource | NVarchar (1) | ||
| 25. | UpdateDate | Time Stamp | ||
| 26. | CreateDate | Time Stamp | ||
| 27. | UserSign | Smallint | ||
| 28. | UserSign2 | Smallint | ||
| 29. | RefndRprt | NVarchar (1) | ||
| 30. | LogInstanc | Integer | ||
| 31. | ObjType | NVarchar (20) | ||
| 32. | Indicator | NVarchar (2) | ||
| 33. | AdjTran | NVarchar (1) | ||
| 34. | RevSource | NVarchar (1) | ||
| 35. | StornoDate | Time Stamp | ||
| 36. | StornoToTr | Integer | ||
| 37. | AutoStorno | NVarchar (1) | ||
| 38. | Corisptivi | NVarchar (1) | ||
| 39. | VatDate | Time Stamp | ||
| 40. | StampTax | NVarchar (1) | ||
| 41. | Series | Integer | ||
| 42. | Number | Integer | ||
| 43. | AutoVAT | NVarchar (1) | ||
| 44. | DocSeries | Integer | ||
| 45. | FolioPref | NVarchar (4) | ||
| 46. | FolioNum | Integer | ||
| 47. | CreateTime | Smallint | ||
| 48. | BlockDunn | NVarchar (1) | ||
| 49. | ReportEU | NVarchar (1) | ||
| 50. | Report347 | NVarchar (1) | ||
| 51. | Printed | NVarchar (1) | ||
| 52. | DocType | NVarchar (60) | ||
| 53. | AttNum | Integer | ||
| 54. | GenRegNo | NVarchar (1) | ||
| 55. | RG23APart2 | Integer | ||
| 56. | RG23CPart2 | Integer | ||
| 57. | MatType | Integer | ||
| 58. | Creator | NVarchar (155) | ||
| 59. | Approver | NVarchar (155) | ||
| 60. | Location | Integer | ||
| 61. | SeqCode | Smallint | ||
| 62. | Serial | Integer | ||
| 63. | SeriesStr | NVarchar (3) | ||
| 64. | SubStr | NVarchar (3) | ||
| 65. | AutoWT | NVarchar (1) | ||
| 66. | WTSum | Decimal (21, 6) | ||
| 67. | WTSumSC | Decimal (21, 6) | ||
| 68. | WTSumFC | Decimal (21, 6) | ||
| 69. | WTApplied | Decimal (21, 6) | ||
| 70. | WTAppliedS | Decimal (21, 6) | ||
| 71. | WTAppliedF | Decimal (21, 6) | ||
| 72. | BaseAmnt | Decimal (21, 6) | ||
| 73. | BaseAmntSC | Decimal (21, 6) | ||
| 74. | BaseAmntFC | Decimal (21, 6) | ||
| 75. | BaseVtAt | Decimal (21, 6) | ||
| 76. | BaseVtAtSC | Decimal (21, 6) | ||
| 77. | BaseVtAtFC | Decimal (21, 6) | ||
| 78. | VersionNum | NVarchar (13) | ||
| 79. | BaseTrans | Integer | ||
| 80. | ResidenNum | NVarchar (1) | ||
| 81. | OperatCode | NVarchar (1) | ||
| 82. | Ref3 | NVarchar (100) | ||
| 83. | SSIExmpt | NVarchar (1) | ||
| 84. | SignMsg | NClob | ||
| 85. | SignDigest | NClob | ||
| 86. | CertifNum | NVarchar (50) | ||
| 87. | KeyVersion | Integer | ||
| 88. | CUP | Integer | ||
| 89. | CIG | Integer | ||
| 90. | SupplCode | NVarchar (254) | ||
| 91. | SPSrcType | Integer | ||
| 92. | SPSrcID | Integer | ||
| 93. | SPSrcDLN | Integer | ||
| 94. | DeferedTax | NVarchar (1) | ||
| 95. | AgrNo | Integer | ||
| 96. | SeqNum | Integer | ||
| 97. | ECDPosTyp | NVarchar (1) | ||
| 98. | RptPeriod | NVarchar (5) | ||
| 99. | RptMonth | Time Stamp | ||
| 100. | ExTransId | Integer | ||
| 101. | PrlLinked | NVarchar (1) | ||
| 102. | PTICode | NVarchar (5) | ||
| 103. | Letter | NVarchar (1) | ||
| 104. | FolNumFrom | Integer | ||
| 105. | FolNumTo | Integer | ||
| 106. | RepSection | NVarchar (3) | ||
| 107. | ExclTaxRep | NVarchar (1) | ||
| 108. | IsCoEntry | NVarchar (1) | ||
| 109. | SAPPassprt | NClob | ||
| 110. | AtcEntry | Integer | ||
| 111. | Attachment | NClob | ||
| 112. | EBookable | NVarchar (1) | ||
| 113. | DataVers | Integer |
