Tabel SAP B1 - OACT - G/L Accounts
List \ OACT
Berikut ini adalah kolom yang terdapat pada tabel OACT di SAP B1
Update: 2026-07-23
| No | Nama Kolom | Tipe Data | Keterangan | Referensi |
|---|---|---|---|---|
| 1. | AcctCode | NVarchar (15) | ||
| 2. | AcctName | NVarchar (100) | ||
| 3. | CurrTotal | Decimal (21, 6) | ||
| 4. | EndTotal | Decimal (21, 6) | ||
| 5. | Finanse | NVarchar (1) | ||
| 6. | Groups | NVarchar (8) | ||
| 7. | Budget | NVarchar (1) | ||
| 8. | Frozen | NVarchar (1) | ||
| 9. | Free_2 | NVarchar (1) | ||
| 10. | Postable | NVarchar (1) | ||
| 11. | Fixed | NVarchar (1) | ||
| 12. | Levels | Smallint | ||
| 13. | ExportCode | NVarchar (10) | ||
| 14. | GrpLine | Integer | ||
| 15. | FatherNum | NVarchar (15) | ||
| 16. | AccntntCod | NVarchar (15) | ||
| 17. | CashBox | NVarchar (1) | ||
| 18. | GroupMask | Smallint | ||
| 19. | RateTrans | NVarchar (1) | ||
| 20. | TaxIncome | NVarchar (1) | ||
| 21. | ExmIncome | NVarchar (1) | ||
| 22. | ExtrMatch | Integer | ||
| 23. | IntrMatch | Integer | ||
| 24. | ActType | NVarchar (1) | ||
| 25. | Transfered | NVarchar (1) | ||
| 26. | BlncTrnsfr | NVarchar (1) | ||
| 27. | OverType | NVarchar (1) | ||
| 28. | OverCode | NVarchar (8) | OOCR | |
| 29. | SysMatch | Integer | ||
| 30. | PrevYear | NVarchar (1) | ||
| 31. | ActCurr | NVarchar (3) | ||
| 32. | RateDifAct | NVarchar (15) | ||
| 33. | SysTotal | Decimal (21, 6) | ||
| 34. | FcTotal | Decimal (21, 6) | ||
| 35. | Protected | NVarchar (1) | ||
| 36. | RealAcct | NVarchar (1) | ||
| 37. | Advance | NVarchar (1) | ||
| 38. | CreateDate | Time Stamp | ||
| 39. | UpdateDate | Time Stamp | ||
| 40. | FrgnName | NVarchar (100) | ||
| 41. | Details | NVarchar (254) | ||
| 42. | ExtraSum | Decimal (21, 6) | ||
| 43. | Project | NVarchar (20) | OPRJ | |
| 44. | RevalMatch | NVarchar (1) | ||
| 45. | DataSource | NVarchar (1) | ||
| 46. | LocMth | NVarchar (1) | ||
| 47. | MTHCounter | Integer | ||
| 48. | BNKCounter | Integer | ||
| 49. | UserSign | Smallint | OUSR | |
| 50. | LocManTran | NVarchar (1) | ||
| 51. | LogInstanc | Integer | ||
| 52. | ObjType | NVarchar (20) | ||
| 53. | ValidFor | NVarchar (1) | ||
| 54. | ValidFrom | Time Stamp | ||
| 55. | ValidTo | Time Stamp | ||
| 56. | ValidComm | NVarchar (30) | ||
| 57. | FrozenFor | NVarchar (1) | ||
| 58. | FrozenFrom | Time Stamp | ||
| 59. | FrozenTo | Time Stamp | ||
| 60. | FrozenComm | NVarchar (30) | ||
| 61. | Counter | Integer | ||
| 62. | Segment_0 | NVarchar (20) | ||
| 63. | Segment_1 | NVarchar (20) | ||
| 64. | Segment_2 | NVarchar (20) | ||
| 65. | Segment_3 | NVarchar (20) | ||
| 66. | Segment_4 | NVarchar (20) | ||
| 67. | Segment_5 | NVarchar (20) | ||
| 68. | Segment_6 | NVarchar (20) | ||
| 69. | Segment_7 | NVarchar (20) | ||
| 70. | Segment_8 | NVarchar (20) | ||
| 71. | Segment_9 | NVarchar (20) | ||
| 72. | FormatCode | NVarchar (210) | ||
| 73. | CfwRlvnt | NVarchar (1) | ||
| 74. | ExchRate | NVarchar (1) | ||
| 75. | RevalAcct | NVarchar (15) | ||
| 76. | LastRevBal | Decimal (21, 6) | ||
| 77. | LastRevDat | Time Stamp | ||
| 78. | DfltVat | NVarchar (8) | OVTG | |
| 79. | VatChange | NVarchar (1) | ||
| 80. | Category | Integer | ||
| 81. | TransCode | NVarchar (4) | ||
| 82. | OverCode5 | NVarchar (8) | OOCR | |
| 83. | OverCode2 | NVarchar (8) | OOCR | |
| 84. | OverCode3 | NVarchar (8) | OOCR | |
| 85. | OverCode4 | NVarchar (8) | OOCR | |
| 86. | DfltTax | NVarchar (8) | ||
| 87. | TaxPostAcc | NVarchar (1) | ||
| 88. | AcctStrLe | NVarchar (2) | ||
| 89. | MeaUnit | NVarchar (10) | ||
| 90. | BalDirect | NVarchar (4) | ||
| 91. | UserSign2 | Smallint | OUSR | |
| 92. | PlngLevel | NVarchar (2) | ||
| 93. | MultiLink | NVarchar (1) | ||
| 94. | PrjRelvnt | NVarchar (1) | ||
| 95. | Dim1Relvnt | NVarchar (1) | ||
| 96. | Dim2Relvnt | NVarchar (1) | ||
| 97. | Dim3Relvnt | NVarchar (1) | ||
| 98. | Dim4Relvnt | NVarchar (1) | ||
| 99. | Dim5Relvnt | NVarchar (1) | ||
| 100. | AccrualTyp | NVarchar (1) | ||
| 101. | DatevAcct | NVarchar (8) | ||
| 102. | DatevAutoA | NVarchar (1) | ||
| 103. | DatevFirst | NVarchar (1) | ||
| 104. | SnapShotId | Integer | ||
| 105. | PCN874Rpt | NVarchar (1) | ||
| 106. | SCAdjust | NVarchar (1) | ||
| 107. | BPLId | Integer | ||
| 108. | BPLName | NVarchar (100) | ||
| 109. | SubLedgerN | NVarchar (60) | ||
| 110. | VATRegNum | NVarchar (32) | ||
| 111. | ActId | NVarchar (210) | ||
| 112. | ClosingAcc | NVarchar (15) | ||
| 113. | PurpCode | NVarchar (2) | ||
| 114. | RefCode | NVarchar (30) | ||
| 115. | BlocManPos | NVarchar (1) | ||
| 116. | PriAccCode | NVarchar (15) | ||
| 117. | CstAccOnly | NVarchar (1) | ||
| 118. | AlloweFrom | Decimal (21, 6) | ||
| 119. | AllowedTo | Decimal (21, 6) | ||
| 120. | BalanceA | NVarchar (1) | ||
| 121. | RmrkTmpt | Integer | ||
| 122. | CemRelvnt | NVarchar (1) | ||
| 123. | CemCode | NVarchar (20) | ||
| 124. | StdActCode | NVarchar (35) | ||
| 125. | TaxonCode | NVarchar (15) | ||
| 126. | InClassTyp | Integer | ||
| 127. | InClassCat | Integer | ||
| 128. | ExClassTyp | Integer | ||
| 129. | ExClassCat | Integer |
