Tabel SAP B1 - OITW - Items - Warehouse
List \ OITW
Berikut ini adalah kolom yang terdapat pada tabel OITW di SAP B1
Update: 2026-07-24
| No | Nama Kolom | Tipe Data | Keterangan | Referensi |
|---|---|---|---|---|
| 1. | ItemCode | NVarchar (50) | ||
| 2. | WhsCode | NVarchar (8) | ||
| 3. | OnHand | Decimal (21, 6) | ||
| 4. | IsCommited | Decimal (21, 6) | ||
| 5. | OnOrder | Decimal (21, 6) | ||
| 6. | Consig | Decimal (21, 6) | ||
| 7. | Counted | Decimal (21, 6) | ||
| 8. | WasCounted | NVarchar (1) | ||
| 9. | UserSign | Smallint | ||
| 10. | MinStock | Decimal (21, 6) | ||
| 11. | MaxStock | Decimal (21, 6) | ||
| 12. | MinOrder | Decimal (21, 6) | ||
| 13. | AvgPrice | Decimal (21, 6) | ||
| 14. | Locked | NVarchar (1) | ||
| 15. | BalInvntAc | NVarchar (15) | ||
| 16. | SaleCostAc | NVarchar (15) | ||
| 17. | TransferAc | NVarchar (15) | ||
| 18. | RevenuesAc | NVarchar (15) | ||
| 19. | VarianceAc | NVarchar (15) | ||
| 20. | DecreasAc | NVarchar (15) | ||
| 21. | IncreasAc | NVarchar (15) | ||
| 22. | ReturnAc | NVarchar (15) | ||
| 23. | ExpensesAc | NVarchar (15) | ||
| 24. | EURevenuAc | NVarchar (15) | ||
| 25. | EUExpensAc | NVarchar (15) | ||
| 26. | FrRevenuAc | NVarchar (15) | ||
| 27. | FrExpensAc | NVarchar (15) | ||
| 28. | ExmptIncom | NVarchar (15) | ||
| 29. | PriceDifAc | NVarchar (15) | ||
| 30. | ExchangeAc | NVarchar (15) | ||
| 31. | BalanceAcc | NVarchar (15) | ||
| 32. | PurchaseAc | NVarchar (15) | ||
| 33. | PAReturnAc | NVarchar (15) | ||
| 34. | PurchOfsAc | NVarchar (15) | ||
| 35. | ShpdGdsAct | NVarchar (15) | ||
| 36. | VatRevAct | NVarchar (15) | ||
| 37. | StockValue | Decimal (21, 6) | ||
| 38. | DecresGlAc | NVarchar (15) | ||
| 39. | IncresGlAc | NVarchar (15) | ||
| 40. | StokRvlAct | NVarchar (15) | ||
| 41. | StkOffsAct | NVarchar (15) | ||
| 42. | WipAcct | NVarchar (15) | ||
| 43. | WipVarAcct | NVarchar (15) | ||
| 44. | CostRvlAct | NVarchar (15) | ||
| 45. | CstOffsAct | NVarchar (15) | ||
| 46. | ExpClrAct | NVarchar (15) | ||
| 47. | ExpOfstAct | NVarchar (15) | ||
| 48. | Object | NVarchar (20) | ||
| 49. | logInstanc | Integer | ||
| 50. | createDate | Time Stamp | ||
| 51. | userSign2 | Smallint | ||
| 52. | updateDate | Time Stamp | ||
| 53. | ARCMAct | NVarchar (15) | ||
| 54. | ARCMFrnAct | NVarchar (15) | ||
| 55. | ARCMEUAct | NVarchar (15) | ||
| 56. | ARCMExpAct | NVarchar (15) | ||
| 57. | APCMAct | NVarchar (15) | ||
| 58. | APCMFrnAct | NVarchar (15) | ||
| 59. | APCMEUAct | NVarchar (15) | ||
| 60. | RevRetAct | NVarchar (15) | ||
| 61. | NegStckAct | NVarchar (15) | ||
| 62. | StkInTnAct | NVarchar (15) | ||
| 63. | PurBalAct | NVarchar (15) | ||
| 64. | WhICenAct | NVarchar (15) | ||
| 65. | WhOCenAct | NVarchar (15) | ||
| 66. | WipOffset | NVarchar (15) | ||
| 67. | StockOffst | NVarchar (15) | ||
| 68. | DftBinAbs | Integer | ||
| 69. | DftBinEnfd | NVarchar (1) | ||
| 70. | Freezed | NVarchar (1) | ||
| 71. | FreezeDoc | Integer | ||
| 72. | FreeChrgSA | NVarchar (15) | ||
| 73. | FreeChrgPU | NVarchar (15) | ||
| 74. | IndEscala | NVarchar (1) | ||
| 75. | CNJPMan | NVarchar (14) |
