Tabel SAP B1 - OWHS - Warehouses
List \ OWHS
Berikut ini adalah kolom yang terdapat pada tabel OWHS di SAP B1
Update: 2026-07-22
| No | Nama Kolom | Tipe Data | Keterangan | Referensi |
|---|---|---|---|---|
| 1. | WhsCode | NVarchar (8) | ||
| 2. | WhsName | NVarchar (100) | ||
| 3. | IntrnalKey | Integer | ||
| 4. | Grp_Code | NVarchar (4) | ||
| 5. | BalInvntAc | NVarchar (15) | ||
| 6. | SaleCostAc | NVarchar (15) | ||
| 7. | TransferAc | NVarchar (15) | ||
| 8. | Locked | NVarchar (1) | ||
| 9. | DataSource | NVarchar (1) | ||
| 10. | UserSign | Smallint | ||
| 11. | RevenuesAc | NVarchar (15) | ||
| 12. | VarianceAc | NVarchar (15) | ||
| 13. | DecreasAc | NVarchar (15) | ||
| 14. | IncreasAc | NVarchar (15) | ||
| 15. | ReturnAc | NVarchar (15) | ||
| 16. | ExpensesAc | NVarchar (15) | ||
| 17. | EURevenuAc | NVarchar (15) | ||
| 18. | EUExpensAc | NVarchar (15) | ||
| 19. | FrRevenuAc | NVarchar (15) | ||
| 20. | FrExpensAc | NVarchar (15) | ||
| 21. | VatGroup | NVarchar (8) | ||
| 22. | Street | NVarchar (100) | ||
| 23. | Block | NVarchar (100) | ||
| 24. | ZipCode | NVarchar (20) | ||
| 25. | City | NVarchar (100) | ||
| 26. | County | NVarchar (100) | ||
| 27. | Country | NVarchar (3) | ||
| 28. | State | NVarchar (3) | ||
| 29. | Location | Integer | ||
| 30. | DropShip | NVarchar (1) | ||
| 31. | ExmptIncom | NVarchar (15) | ||
| 32. | UseTax | NVarchar (1) | ||
| 33. | PriceDifAc | NVarchar (15) | ||
| 34. | ExchangeAc | NVarchar (15) | ||
| 35. | BalanceAcc | NVarchar (15) | ||
| 36. | PurchaseAc | NVarchar (15) | ||
| 37. | PAReturnAc | NVarchar (15) | ||
| 38. | PurchOfsAc | NVarchar (15) | ||
| 39. | FedTaxID | NVarchar (32) | ||
| 40. | Building | NClob | ||
| 41. | ShpdGdsAct | NVarchar (15) | ||
| 42. | VatRevAct | NVarchar (15) | ||
| 43. | DecresGlAc | NVarchar (15) | ||
| 44. | IncresGlAc | NVarchar (15) | ||
| 45. | Nettable | NVarchar (1) | ||
| 46. | StokRvlAct | NVarchar (15) | ||
| 47. | StkOffsAct | NVarchar (15) | ||
| 48. | WipAcct | NVarchar (15) | ||
| 49. | WipVarAcct | NVarchar (15) | ||
| 50. | CostRvlAct | NVarchar (15) | ||
| 51. | CstOffsAct | NVarchar (15) | ||
| 52. | ExpClrAct | NVarchar (15) | ||
| 53. | ExpOfstAct | NVarchar (15) | ||
| 54. | objType | NVarchar (20) | ||
| 55. | logInstanc | Integer | ||
| 56. | createDate | Time Stamp | ||
| 57. | userSign2 | Smallint | ||
| 58. | updateDate | Time Stamp | ||
| 59. | ARCMAct | NVarchar (15) | ||
| 60. | ARCMFrnAct | NVarchar (15) | ||
| 61. | ARCMEUAct | NVarchar (15) | ||
| 62. | ARCMExpAct | NVarchar (15) | ||
| 63. | APCMAct | NVarchar (15) | ||
| 64. | APCMFrnAct | NVarchar (15) | ||
| 65. | APCMEUAct | NVarchar (15) | ||
| 66. | RevRetAct | NVarchar (15) | ||
| 67. | BPLid | Integer | ||
| 68. | OwnerCode | NVarchar (1) | ||
| 69. | NegStckAct | NVarchar (15) | ||
| 70. | StkInTnAct | NVarchar (15) | ||
| 71. | AddrType | NVarchar (100) | ||
| 72. | StreetNo | NVarchar (100) | ||
| 73. | PurBalAct | NVarchar (15) | ||
| 74. | Excisable | NVarchar (1) | ||
| 75. | WhICenAct | NVarchar (15) | ||
| 76. | WhOCenAct | NVarchar (15) | ||
| 77. | WhShipTo | NVarchar (100) | ||
| 78. | WipOffset | NVarchar (15) | ||
| 79. | StockOffst | NVarchar (15) | ||
| 80. | StorKeeper | Integer | ||
| 81. | Shipper | NVarchar (15) | ||
| 82. | BinActivat | NVarchar (1) | ||
| 83. | BinSeptor | NVarchar (5) | ||
| 84. | DftBinAbs | Integer | ||
| 85. | DftBinEnfd | NVarchar (1) | ||
| 86. | AutoIssMtd | Smallint | ||
| 87. | ManageSnB | NVarchar (1) | ||
| 88. | RecItemsBy | Smallint | ||
| 89. | RecBinEnab | NVarchar (1) | ||
| 90. | GlblLocNum | NVarchar (50) | ||
| 91. | RecvEmpBin | NVarchar (1) | ||
| 92. | Inactive | NVarchar (1) | ||
| 93. | RecvMaxQty | NVarchar (1) | ||
| 94. | AutoRecvMd | Smallint | ||
| 95. | RecvMaxWT | NVarchar (1) | ||
| 96. | RecvUpTo | NVarchar (6) | ||
| 97. | FreeChrgSA | NVarchar (15) | ||
| 98. | FreeChrgPU | NVarchar (15) | ||
| 99. | TaxOffice | NVarchar (50) | ||
| 100. | Address2 | NVarchar (50) | ||
| 101. | Address3 | NVarchar (50) | ||
| 102. | External | NVarchar (1) | ||
| 103. | LegalText | NVarchar (250) | ||
| 104. | U_TYPE | NVarchar (1) | ||
| 105. | U_SOL_WHS_TYPE | NVarchar (2) |
