Tabel SAP B1 - JDT1 - Journal Entry - Rows
List \ JDT1
Berikut ini adalah kolom yang terdapat pada tabel JDT1 di SAP B1
Update: 2026-07-24
| No | Nama Kolom | Tipe Data | Keterangan | Referensi |
|---|---|---|---|---|
| 1. | TransId | Integer | ||
| 2. | Line_ID | Integer | ||
| 3. | Account | NVarchar (15) | ||
| 4. | Debit | Decimal (21, 6) | ||
| 5. | Credit | Decimal (21, 6) | ||
| 6. | SYSCred | Decimal (21, 6) | ||
| 7. | SYSDeb | Decimal (21, 6) | ||
| 8. | FCDebit | Decimal (21, 6) | ||
| 9. | FCCredit | Decimal (21, 6) | ||
| 10. | FCCurrency | NVarchar (3) | ||
| 11. | DueDate | Time Stamp | ||
| 12. | SourceID | Integer | ||
| 13. | SourceLine | Smallint | ||
| 14. | ShortName | NVarchar (15) | ||
| 15. | IntrnMatch | Integer | ||
| 16. | ExtrMatch | Integer | ||
| 17. | ContraAct | NVarchar (15) | ||
| 18. | LineMemo | NVarchar (254) | ||
| 19. | Ref3Line | NVarchar (100) | ||
| 20. | TransType | NVarchar (20) | ||
| 21. | RefDate | Time Stamp | ||
| 22. | Ref2Date | Time Stamp | ||
| 23. | Ref1 | NVarchar (100) | ||
| 24. | Ref2 | NVarchar (100) | ||
| 25. | CreatedBy | Integer | ||
| 26. | BaseRef | NVarchar (11) | ||
| 27. | Project | NVarchar (20) | ||
| 28. | TransCode | NVarchar (4) | ||
| 29. | ProfitCode | NVarchar (8) | ||
| 30. | TaxDate | Time Stamp | ||
| 31. | SystemRate | Decimal (21, 6) | ||
| 32. | MthDate | Time Stamp | ||
| 33. | ToMthSum | Decimal (21, 6) | ||
| 34. | UserSign | Smallint | ||
| 35. | BatchNum | Integer | ||
| 36. | FinncPriod | Integer | ||
| 37. | RelTransId | Integer | ||
| 38. | RelLineID | Integer | ||
| 39. | RelType | NVarchar (1) | ||
| 40. | LogInstanc | Integer | ||
| 41. | VatGroup | NVarchar (8) | ||
| 42. | BaseSum | Decimal (21, 6) | ||
| 43. | VatRate | Decimal (21, 6) | ||
| 44. | Indicator | NVarchar (2) | ||
| 45. | AdjTran | NVarchar (1) | ||
| 46. | RevSource | NVarchar (1) | ||
| 47. | ObjType | NVarchar (20) | ||
| 48. | VatDate | Time Stamp | ||
| 49. | PaymentRef | NVarchar (27) | ||
| 50. | SYSBaseSum | Decimal (21, 6) | ||
| 51. | MultMatch | Integer | ||
| 52. | VatLine | NVarchar (1) | ||
| 53. | VatAmount | Decimal (21, 6) | ||
| 54. | SYSVatSum | Decimal (21, 6) | ||
| 55. | Closed | NVarchar (1) | ||
| 56. | GrossValue | Decimal (21, 6) | ||
| 57. | CheckAbs | Integer | ||
| 58. | LineType | Integer | ||
| 59. | DebCred | NVarchar (1) | ||
| 60. | SequenceNr | Integer | ||
| 61. | StornoAcc | NVarchar (15) | ||
| 62. | BalDueDeb | Decimal (21, 6) | ||
| 63. | BalDueCred | Decimal (21, 6) | ||
| 64. | BalFcDeb | Decimal (21, 6) | ||
| 65. | BalFcCred | Decimal (21, 6) | ||
| 66. | BalScDeb | Decimal (21, 6) | ||
| 67. | BalScCred | Decimal (21, 6) | ||
| 68. | IsNet | NVarchar (1) | ||
| 69. | DunWizBlck | NVarchar (1) | ||
| 70. | DunnLevel | Integer | ||
| 71. | DunDate | Time Stamp | ||
| 72. | TaxType | Smallint | ||
| 73. | TaxPostAcc | NVarchar (1) | ||
| 74. | StaCode | NVarchar (8) | ||
| 75. | StaType | Integer | ||
| 76. | TaxCode | NVarchar (8) | ||
| 77. | ValidFrom | Time Stamp | ||
| 78. | GrossValFc | Decimal (21, 6) | ||
| 79. | LvlUpdDate | Time Stamp | ||
| 80. | OcrCode2 | NVarchar (8) | ||
| 81. | OcrCode3 | NVarchar (8) | ||
| 82. | OcrCode4 | NVarchar (8) | ||
| 83. | OcrCode5 | NVarchar (8) | ||
| 84. | MIEntry | Integer | ||
| 85. | MIVEntry | Integer | ||
| 86. | ClsInTP | Integer | ||
| 87. | CenVatCom | Integer | ||
| 88. | MatType | Integer | ||
| 89. | PstngType | Integer | ||
| 90. | ValidFrom2 | Time Stamp | ||
| 91. | ValidFrom3 | Time Stamp | ||
| 92. | ValidFrom4 | Time Stamp | ||
| 93. | ValidFrom5 | Time Stamp | ||
| 94. | Location | Integer | ||
| 95. | WTaxCode | NVarchar (4) | ||
| 96. | EquVatRate | Decimal (21, 6) | ||
| 97. | EquVatSum | Decimal (21, 6) | ||
| 98. | SYSEquSum | Decimal (21, 6) | ||
| 99. | TotalVat | Decimal (21, 6) | ||
| 100. | SYSTVat | Decimal (21, 6) | ||
| 101. | WTLiable | NVarchar (1) | ||
| 102. | WTLine | NVarchar (1) | ||
| 103. | WTApplied | Decimal (21, 6) | ||
| 104. | WTAppliedS | Decimal (21, 6) | ||
| 105. | WTAppliedF | Decimal (21, 6) | ||
| 106. | WTSum | Decimal (21, 6) | ||
| 107. | WTSumFC | Decimal (21, 6) | ||
| 108. | WTSumSC | Decimal (21, 6) | ||
| 109. | PayBlock | NVarchar (1) | ||
| 110. | PayBlckRef | Integer | ||
| 111. | LicTradNum | NVarchar (32) | ||
| 112. | InterimTyp | Integer | ||
| 113. | DprId | Integer | ||
| 114. | MatchRef | NVarchar (20) | ||
| 115. | Ordered | NVarchar (1) | ||
| 116. | CUP | Integer | ||
| 117. | CIG | Integer | ||
| 118. | BPLId | Integer | ||
| 119. | BPLName | NVarchar (100) | ||
| 120. | VatRegNum | NVarchar (32) | ||
| 121. | SLEDGERF | NVarchar (1) | ||
| 122. | InitRef2 | NVarchar (100) | ||
| 123. | InitRef3Ln | NVarchar (27) | ||
| 124. | ExpUUID | NVarchar (50) | ||
| 125. | ExpOPType | NVarchar (1) | ||
| 126. | ExTransId | Integer | ||
| 127. | DocArr | Smallint | ||
| 128. | DocLine | Integer | ||
| 129. | MYFtype | NVarchar (2) | ||
| 130. | DocEntry | Integer | ||
| 131. | DocNum | Integer | ||
| 132. | DocType | NVarchar (20) | ||
| 133. | DocSubType | NVarchar (2) | ||
| 134. | RmrkTmpt | Integer | ||
| 135. | CemCode | NVarchar (20) | ||
| 136. | InClassCat | Integer | ||
| 137. | InClassTyp | Integer | ||
| 138. | ExClassCat | Integer | ||
| 139. | ExClassTyp | Integer | ||
| 140. | VATClassCa | Integer | ||
| 141. | VATClassTy | Integer | ||
| 142. | EVatCate | Integer | ||
| 143. | EWtPercCat | Integer | ||
| 144. | EWtAmount | Decimal (21, 6) | ||
| 145. | EBVatExCau | Integer |
