Tabel SAP B1 - OITB - Item Groups
List \ OITB
Berikut ini adalah kolom yang terdapat pada tabel OITB di SAP B1
Update: 2026-07-23
| No | Nama Kolom | Tipe Data | Keterangan | Referensi |
|---|---|---|---|---|
| 1. | ItmsGrpCod | Smallint | ||
| 2. | ItmsGrpNam | NVarchar (100) | ||
| 3. | Locked | NVarchar (1) | ||
| 4. | DataSource | NVarchar (1) | ||
| 5. | UserSign | Smallint | ||
| 6. | BalInvntAc | NVarchar (15) | ||
| 7. | SaleCostAc | NVarchar (15) | ||
| 8. | TransferAc | NVarchar (15) | ||
| 9. | RevenuesAc | NVarchar (15) | ||
| 10. | VarianceAc | NVarchar (15) | ||
| 11. | DecreasAc | NVarchar (15) | ||
| 12. | IncreasAc | NVarchar (15) | ||
| 13. | ReturnAc | NVarchar (15) | ||
| 14. | ExpensesAc | NVarchar (15) | ||
| 15. | EURevenuAc | NVarchar (15) | ||
| 16. | EUExpensAc | NVarchar (15) | ||
| 17. | FrRevenuAc | NVarchar (15) | ||
| 18. | FrExpensAc | NVarchar (15) | ||
| 19. | ExmptIncom | NVarchar (15) | ||
| 20. | CycleCode | Smallint | ||
| 21. | Alert | NVarchar (1) | ||
| 22. | PriceDifAc | NVarchar (15) | ||
| 23. | ExchangeAc | NVarchar (15) | ||
| 24. | BalanceAcc | NVarchar (15) | ||
| 25. | PurchaseAc | NVarchar (15) | ||
| 26. | PAReturnAc | NVarchar (15) | ||
| 27. | PurchOfsAc | NVarchar (15) | ||
| 28. | ShpdGdsAct | NVarchar (15) | ||
| 29. | VatRevAct | NVarchar (15) | ||
| 30. | DecresGlAc | NVarchar (15) | ||
| 31. | IncresGlAc | NVarchar (15) | ||
| 32. | InvntSys | NVarchar (1) | ||
| 33. | PlaningSys | NVarchar (1) | ||
| 34. | PrcrmntMtd | NVarchar (1) | ||
| 35. | OrdrIntrvl | Smallint | ||
| 36. | OrdrMulti | Decimal (21, 6) | ||
| 37. | MinOrdrQty | Decimal (21, 6) | ||
| 38. | LeadTime | Integer | ||
| 39. | StokRvlAct | NVarchar (15) | ||
| 40. | StkOffsAct | NVarchar (15) | ||
| 41. | WipAcct | NVarchar (15) | ||
| 42. | WipVarAcct | NVarchar (15) | ||
| 43. | CostRvlAct | NVarchar (15) | ||
| 44. | CstOffsAct | NVarchar (15) | ||
| 45. | ExpClrAct | NVarchar (15) | ||
| 46. | ExpOfstAct | NVarchar (15) | ||
| 47. | Object | NVarchar (20) | ||
| 48. | logInstanc | Integer | ||
| 49. | createDate | Time Stamp | ||
| 50. | userSign2 | Smallint | ||
| 51. | updateDate | Time Stamp | ||
| 52. | ARCMAct | NVarchar (15) | ||
| 53. | ARCMFrnAct | NVarchar (15) | ||
| 54. | ARCMEUAct | NVarchar (15) | ||
| 55. | ARCMExpAct | NVarchar (15) | ||
| 56. | APCMAct | NVarchar (15) | ||
| 57. | APCMFrnAct | NVarchar (15) | ||
| 58. | APCMEUAct | NVarchar (15) | ||
| 59. | RevRetAct | NVarchar (15) | ||
| 60. | ItemClass | NVarchar (1) | ||
| 61. | OSvcCode | Integer | ||
| 62. | ISvcCode | Integer | ||
| 63. | ServiceGrp | Integer | ||
| 64. | NCMCode | Integer | ||
| 65. | MatType | NVarchar (3) | ||
| 66. | MatGrp | Integer | ||
| 67. | ProductSrc | NVarchar (2) | ||
| 68. | NegStckAct | NVarchar (15) | ||
| 69. | StkInTnAct | NVarchar (15) | ||
| 70. | PurBalAct | NVarchar (15) | ||
| 71. | WhICenAct | NVarchar (15) | ||
| 72. | WhOCenAct | NVarchar (15) | ||
| 73. | WipOffset | NVarchar (15) | ||
| 74. | StockOffst | NVarchar (15) | ||
| 75. | UgpEntry | Integer | ||
| 76. | IUoMEntry | Integer | ||
| 77. | ToleranDay | Integer | ||
| 78. | RuleCode | NVarchar (2) | ||
| 79. | CompoWH | NVarchar (1) | ||
| 80. | FreeChrgSA | NVarchar (15) | ||
| 81. | FreeChrgPU | NVarchar (15) | ||
| 82. | RawMtrl | NVarchar (1) | ||
| 83. | U_ALIAS | NVarchar (50) |
