biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Inventory / Warehouses
API OWHS / Warehouses
OWHS - Warehouses Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WhsCode KEY UNIQUEWarehouse CodenVarChar
8
PRIMARYYes
WhsNameWarehouse NamenVarChar
100
IntrnalKeyInternal KeyInt
11
Grp_CodeGroup CodenVarChar
4
BalInvntAcInventory AccountnVarChar
15OACT
G/L Accounts
SaleCostAcCost of Goods Sold AccountnVarChar
15OACT
G/L Accounts
TransferAcAllocation AccountnVarChar
15OACT
G/L Accounts
LockedLockedVarChar
N) Changeable
Y) Locked
1
N
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
RevenuesAcRevenue AccountnVarChar
15OACT
G/L Accounts
VarianceAcVariance AccountnVarChar
15OACT
G/L Accounts
DecreasAcInventory Offset - Decrease AccountnVarChar
15OACT
G/L Accounts
IncreasAcInventory Offset - Increase AccountnVarChar
15OACT
G/L Accounts
ReturnAcSales Returns AccountnVarChar
15OACT
G/L Accounts
ExpensesAcExpense AccountnVarChar
15OACT
G/L Accounts
EURevenuAcRevenue Account - EUnVarChar
15OACT
G/L Accounts
EUExpensAcExpense Account - EUnVarChar
15OACT
G/L Accounts
FrRevenuAcRevenue Account - ForeignnVarChar
15OACT
G/L Accounts
FrExpensAcExpense Account - ForeignnVarChar
15OACT
G/L Accounts
VatGroupTax GroupnVarChar
8OSTC
Sales Tax Codes
StreetStreetnVarChar
100
BlockBlocknVarChar
100
ZipCodeZip CodenVarChar
20
CityCitynVarChar
100
CountyCountynVarChar
100OCNT
Counties
CountryCountrynVarChar
3OCRY
Countries
StateStatenVarChar
3
LocationLocationInt
11OLCT
Location
DropShipDrop-ShipVarChar
N) No
Y) Yes
1
N
ExmptIncomExempt Revenue AccountnVarChar
15OACT
G/L Accounts
UseTaxAllow Use TaxVarChar
Y) Yes
N) No
1
N
PriceDifAcPrice Difference AccountnVarChar
15OACT
G/L Accounts
ExchangeAcExchange Rate Differences AccountnVarChar
15OACT
G/L Accounts
BalanceAccGoods Clearing AccountnVarChar
15OACT
G/L Accounts
PurchaseAcPurchase AccountnVarChar
15OACT
G/L Accounts
PAReturnAcPurchase Return AccountnVarChar
15OACT
G/L Accounts
PurchOfsAcPurchase Offset AccountnVarChar
15OACT
G/L Accounts
FedTaxIDFederal Tax IDnVarChar
32
BuildingBuilding/Floor/RoomText
16
ShpdGdsActShipped Goods AccountnVarChar
15OACT
G/L Accounts
VatRevActVAT in Revenue AccountnVarChar
15OACT
G/L Accounts
DecresGlAcG/L Decrease AccountnVarChar
15OACT
G/L Accounts
IncresGlAcG/L Increase AccountnVarChar
15OACT
G/L Accounts
NettableNettableVarChar
Y) Yes
N) No
1
Y
StokRvlActInventory Revaluation AccountnVarChar
15OACT
G/L Accounts
StkOffsActInventory Revaluation Offset AccountnVarChar
15OACT
G/L Accounts
WipAcctWIP Inventory AccountnVarChar
15OACT
G/L Accounts
WipVarAcctWIP Inventory Variance AccountnVarChar
15OACT
G/L Accounts
CostRvlActCOGS Revaluation AccountnVarChar
15OACT
G/L Accounts
CstOffsActCOGS Revaluation Offset AcctnVarChar
15OACT
G/L Accounts
ExpClrActExpense Clearing AccountnVarChar
15OACT
G/L Accounts
ExpOfstActExpense Offset AccountnVarChar
15OACT
G/L Accounts
objTypeObject Type - HistorynVarChar
20
64
logInstancLog Instance - HistoryInt
11
createDateCreation Date - HistoryDate
8
userSign2Updating User - HistoryInt
6OUSR
Users
updateDateDate of Update - HistoryDate
8
ARCMActSales Credit AccountnVarChar
15OACT
G/L Accounts
ARCMFrnActSales Credit Account - ForeignnVarChar
15OACT
G/L Accounts
ARCMEUActSales Credit Account - EUnVarChar
15OACT
G/L Accounts
ARCMExpActTax Exempt Credit AccountnVarChar
15OACT
G/L Accounts
APCMActPurchase Credit AccountnVarChar
15OACT
G/L Accounts
APCMFrnActPurchase Credit Account - ForeignnVarChar
15OACT
G/L Accounts
APCMEUActPurchase Credit Account - EUnVarChar
15OACT
G/L Accounts
RevRetActRevenue Returns AccountnVarChar
15OACT
G/L Accounts
BPLidBusiness Place IDInt
11OBPL
Business Place
OwnerCodeOwner CodeVarChar
1) Company Item Property
2) Third-Party Warehouse
3) Third-Party Item in my Property
1
1
NegStckActNegative Inventory Adjustment AcctnVarChar
15OACT
G/L Accounts
StkInTnActStock In Transit AccountnVarChar
15OACT
G/L Accounts
AddrTypeAddress TypenVarChar
100
StreetNoStreet No.nVarChar
100
PurBalActPurchase Balance AccountnVarChar
15OACT
G/L Accounts
ExcisableExcisable [Yes/No]VarChar
Y) Yes
N) No
1
N
WhICenActIncoming CENVAT Account (WH)nVarChar
15OACT
G/L Accounts
WhOCenActOutgoing CENVAT Account (WH)nVarChar
15OACT
G/L Accounts
WhShipToShip-to Name (WH)nVarChar
100
WipOffsetWIP Offset P&L AccountnVarChar
15OACT
G/L Accounts
StockOffstInventory Offset P&L AccountnVarChar
15OACT
G/L Accounts
StorKeeperStorekeeperInt
11OHEM
Employees
ShipperShippernVarChar
15OCRD
Business Partner
BinActivatBin Activated [Y/N]VarChar
Y) Yes
N) No
1
N
BinSeptorBin SeparatornVarChar
5
DftBinAbs KEYDefault Bin Internal NumberInt
11OBIN
Bin Location
DFT_BINNo
DftBinEnfdDefault Bin Enforced [Y/N]VarChar
Y) Yes
N) No
1
N
AutoIssMtdAuto. Issue MethodInt
0
1) Bin Location Code Order
2) Alternative Sort Code Order
3) Descending Quantity
4) Ascending Quantity
5) FIFO
6) LIFO
6
0
ManageSnBDrop-Ship Manage SnBVarChar
N) No
Y) Yes
1
N
RecItemsByReceiving Bin Locations MethodInt
0
1) Alternative Sort Code Order
6
0
RecBinEnabEnable Receiving Bin LocationsVarChar
Y) Yes
N) No
1
N
GlblLocNumGlobal Location NumbernVarChar
50
RecvEmpBinRestrict Receipts to Empty BinVarChar
Y) Yes
N) No
1
Y
InactiveInactive [Y/N]VarChar
Y) Yes
N) No
1
N
RecvMaxQtyRecv. up to Max. QtyVarChar
Y) Yes
N) No
1
N
AutoRecvMdAuto. Receipt MethodInt
0
1) Last Bin Location That Received Item
2) Item's Current Bin Locations
3) Item's Current and Historical Bin Locations
6
0
RecvMaxWTRecv. up to Max. WeightVarChar
Y) Yes
N) No
1
N
RecvUpToReceive up tonVarChar
0
1) Maximum Weight
2) Max. Qty and Weight
6
0
FreeChrgSAFree of Charge Sales AccountnVarChar
15OACT
G/L Accounts
FreeChrgPUFree of Charge Purchase AccountnVarChar
15OACT
G/L Accounts

Table relationship map

SELECT statement

SELECT OWHS.WhsCode AS 'Warehouse Code', OWHS.WhsName AS 'Warehouse Name', OWHS.IntrnalKey AS 'Internal Key', OWHS.Grp_Code AS 'Group Code', OWHS.BalInvntAc AS 'Inventory Account', OWHS.SaleCostAc AS 'Cost of Goods Sold Account', OWHS.TransferAc AS 'Allocation Account', OWHS.Locked AS 'Locked', OWHS.DataSource AS 'Data Source', OWHS.UserSign AS 'User Signature', OWHS.RevenuesAc AS 'Revenue Account', OWHS.VarianceAc AS 'Variance Account', OWHS.DecreasAc AS 'Inventory Offset - Decrease Account', OWHS.IncreasAc AS 'Inventory Offset - Increase Account', OWHS.ReturnAc AS 'Sales Returns Account', OWHS.ExpensesAc AS 'Expense Account', OWHS.EURevenuAc AS 'Revenue Account - EU', OWHS.EUExpensAc AS 'Expense Account - EU', OWHS.FrRevenuAc AS 'Revenue Account - Foreign', OWHS.FrExpensAc AS 'Expense Account - Foreign', OWHS.VatGroup AS 'Tax Group', OWHS.Street AS 'Street', OWHS.Block AS 'Block', OWHS.ZipCode AS 'Zip Code', OWHS.City AS 'City', OWHS.County AS 'County', OWHS.Country AS 'Country', OWHS.State AS 'State', OWHS.Location AS 'Location', OWHS.DropShip AS 'Drop-Ship', OWHS.ExmptIncom AS 'Exempt Revenue Account', OWHS.UseTax AS 'Allow Use Tax', OWHS.PriceDifAc AS 'Price Difference Account', OWHS.ExchangeAc AS 'Exchange Rate Differences Account', OWHS.BalanceAcc AS 'Goods Clearing Account', OWHS.PurchaseAc AS 'Purchase Account', OWHS.PAReturnAc AS 'Purchase Return Account', OWHS.PurchOfsAc AS 'Purchase Offset Account', OWHS.FedTaxID AS 'Federal Tax ID', OWHS.Building AS 'Building/Floor/Room', OWHS.ShpdGdsAct AS 'Shipped Goods Account', OWHS.VatRevAct AS 'VAT in Revenue Account', OWHS.DecresGlAc AS 'G/L Decrease Account', OWHS.IncresGlAc AS 'G/L Increase Account', OWHS.Nettable AS 'Nettable', OWHS.StokRvlAct AS 'Inventory Revaluation Account', OWHS.StkOffsAct AS 'Inventory Revaluation Offset Account', OWHS.WipAcct AS 'WIP Inventory Account', OWHS.WipVarAcct AS 'WIP Inventory Variance Account', OWHS.CostRvlAct AS 'COGS Revaluation Account', OWHS.CstOffsAct AS 'COGS Revaluation Offset Acct', OWHS.ExpClrAct AS 'Expense Clearing Account', OWHS.ExpOfstAct AS 'Expense Offset Account', OWHS.objType AS 'Object Type - History', OWHS.logInstanc AS 'Log Instance - History', OWHS.createDate AS 'Creation Date - History', OWHS.userSign2 AS 'Updating User - History', OWHS.updateDate AS 'Date of Update - History', OWHS.ARCMAct AS 'Sales Credit Account', OWHS.ARCMFrnAct AS 'Sales Credit Account - Foreign', OWHS.ARCMEUAct AS 'Sales Credit Account - EU', OWHS.ARCMExpAct AS 'Tax Exempt Credit Account', OWHS.APCMAct AS 'Purchase Credit Account', OWHS.APCMFrnAct AS 'Purchase Credit Account - Foreign', OWHS.APCMEUAct AS 'Purchase Credit Account - EU', OWHS.RevRetAct AS 'Revenue Returns Account', OWHS.BPLid AS 'Business Place ID', OWHS.OwnerCode AS 'Owner Code', OWHS.NegStckAct AS 'Negative Inventory Adjustment Acct', OWHS.StkInTnAct AS 'Stock In Transit Account', OWHS.AddrType AS 'Address Type', OWHS.StreetNo AS 'Street No.', OWHS.PurBalAct AS 'Purchase Balance Account', OWHS.Excisable AS 'Excisable [Yes/No]', OWHS.WhICenAct AS 'Incoming CENVAT Account (WH)', OWHS.WhOCenAct AS 'Outgoing CENVAT Account (WH)', OWHS.WhShipTo AS 'Ship-to Name (WH)', OWHS.WipOffset AS 'WIP Offset P&L Account', OWHS.StockOffst AS 'Inventory Offset P&L Account', OWHS.StorKeeper AS 'Storekeeper', OWHS.Shipper AS 'Shipper', OWHS.BinActivat AS 'Bin Activated [Y/N]', OWHS.BinSeptor AS 'Bin Separator', OWHS.DftBinAbs AS 'Default Bin Internal Number', OWHS.DftBinEnfd AS 'Default Bin Enforced [Y/N]', OWHS.AutoIssMtd AS 'Auto. Issue Method', OWHS.ManageSnB AS 'Drop-Ship Manage SnB', OWHS.RecItemsBy AS 'Receiving Bin Locations Method', OWHS.RecBinEnab AS 'Enable Receiving Bin Locations', OWHS.GlblLocNum AS 'Global Location Number', OWHS.RecvEmpBin AS 'Restrict Receipts to Empty Bin', OWHS.Inactive AS 'Inactive [Y/N]', OWHS.RecvMaxQty AS 'Recv. up to Max. Qty', OWHS.AutoRecvMd AS 'Auto. Receipt Method', OWHS.RecvMaxWT AS 'Recv. up to Max. Weight', OWHS.RecvUpTo AS 'Receive up to', OWHS.FreeChrgSA AS 'Free of Charge Sales Account', OWHS.FreeChrgPU AS 'Free of Charge Purchase Account' FROM OWHS AS OWHS

Related information


Warehouses Warehouses Object· Table: OWHS
Warehouses is a business object that represents the warehouses information in the Inventory module. This object enables you to: Add a warehouse. Retrieve a warehouse by its key. Update a warehouse details. Remove a warehouse. Save the...

OWHS SQL Table

G/L Accounts OACT SQL Table

Countries OCRY SQL Table

Counties OCNT SQL Table

Location OLCT SQL Table

Business Partner OCRD SQL Table

Employees OHEM SQL Table

Users OUSR SQL Table

Sales Tax Codes OSTC SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates