📚 SAP Business One SDK Help

Table Name: AWHS

Table Description: Warehouses - History

Field Description Type Size Related Default Value Constraints
WhsCode Warehouse Code nVarChar 8 -      
WhsName Warehouse Name nVarChar 100 -      
IntrnalKey Internal Key Int 11 -      
Grp_Code Group Code nVarChar 4 -      
BalInvntAc Inventory Account nVarChar 15 OACT      
SaleCostAc Cost of Goods Sold Account nVarChar 15 OACT      
TransferAc Allocation Account nVarChar 15 OACT      
Locked Locked VarChar 1 - N N Changeable
            Y Locked
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
UserSign User Signature Int 6 OUSR      
RevenuesAc Revenue Account nVarChar 15 OACT      
VarianceAc Variance Account nVarChar 15 OACT      
DecreasAc Inventory Offset - Decrease Account nVarChar 15 OACT      
IncreasAc Inventory Offset - Increase Account nVarChar 15 OACT      
ReturnAc Sales Returns Account nVarChar 15 OACT      
ExpensesAc Expense Account nVarChar 15 OACT      
EURevenuAc Revenue Account - EU nVarChar 15 OACT      
EUExpensAc Expense Account - EU nVarChar 15 OACT      
FrRevenuAc Revenue Account - Foreign nVarChar 15 OACT      
FrExpensAc Expense Account - Foreign nVarChar 15 OACT      
VatGroup Tax Group nVarChar 8 OSTC      
Street Street nVarChar 100 -      
Block Block nVarChar 100 -      
ZipCode Zip Code nVarChar 20 -      
City City nVarChar 100 -      
County County nVarChar 100 OCNT      
Country Country/Region nVarChar 3 OCRY      
State Status nVarChar 3 OCST      
Location Location Int 11 OLCT      
DropShip Drop-Ship VarChar 1 - N N No
            Y Yes
ExmptIncom Exempt Revenue Account nVarChar 15 OACT      
UseTax Allow Use Tax VarChar 1 - N Y Yes
            N No
PriceDifAc Price Difference Account nVarChar 15 OACT      
ExchangeAc Exchange Rate Differences Account nVarChar 15 OACT      
BalanceAcc Goods Clearing Account nVarChar 15 OACT      
PurchaseAc Purchase Account nVarChar 15 OACT      
PAReturnAc Purchase Return Account nVarChar 15 OACT      
PurchOfsAc Purchase Offset Account nVarChar 15 OACT      
FedTaxID Federal Tax ID nVarChar 32 -      
Building Building/Floor/Room Text 16 -      
ShpdGdsAct Shipped Goods Account nVarChar 15 OACT      
VatRevAct VAT in Revenue Account nVarChar 15 OACT      
DecresGlAc G/L Decrease Account nVarChar 15 OACT      
IncresGlAc G/L Increase Account nVarChar 15 OACT      
Nettable Nettable VarChar 1 - Y Y Yes
            N No
StokRvlAct Inventory Revaluation Account nVarChar 15 OACT      
StkOffsAct Inventory Revaluation Offset Account nVarChar 15 OACT      
WipAcct WIP Inventory Account nVarChar 15 OACT      
WipVarAcct WIP Inventory Variance Account nVarChar 15 OACT      
CostRvlAct COGS Revaluation Account nVarChar 15 OACT      
CstOffsAct COGS Revaluation Offset Acct nVarChar 15 OACT      
ExpClrAct Expense Clearing Account nVarChar 15 OACT      
ExpOfstAct Expense Offset Account nVarChar 15 OACT      
objType Object Type - History nVarChar 20 - 64    
logInstanc Log Instance - History Int 11 -      
createDate Creation Date - History Date 8 -      
userSign2 Updating User - History Int 6 OUSR      
updateDate Date of Update - History Date 8 -      
ARCMAct Sales Credit Acct nVarChar 15 OACT      
ARCMFrnAct Sales Credit Foreign Acct nVarChar 15 OACT      
ARCMEUAct Sales Credit EU Acct nVarChar 15 OACT      
ARCMExpAct Exempted Credits nVarChar 15 OACT      
APCMAct Purchase Credit Acct nVarChar 15 OACT      
APCMFrnAct Foreign Purchase Credit Acct nVarChar 15 OACT      
APCMEUAct EU Purchase Credit Acct nVarChar 15 OACT      
RevRetAct Revenue Returns Account nVarChar 15 OACT      
BPLid Business Place ID Int 11 OBPL      
OwnerCode Owner Code VarChar 1 - 1 1 Company Item Property
            2 Third-Party Warehouse
            3 Third-Party Warehouse
NegStckAct Negative Stock Adjustment Acct nVarChar 15 OACT      
StkInTnAct Stock In Transit Acct nVarChar 15 OACT      
AddrType Address Type nVarChar 100 -      
StreetNo Street No. nVarChar 100 -      
PurBalAct Purchase Balance Account nVarChar 15 OACT      
Excisable Excisable [Yes/No] VarChar 1 - N Y Yes
            N No
WhICenAct Incoming CENVAT Account (WH) nVarChar 15 OACT      
WhOCenAct Outgoing CENVAT Account (WH) nVarChar 15 OACT      
WhShipTo Ship-to Name (WH) nVarChar 100 -      
WipOffset WIP Offset P&L Account nVarChar 15 OACT      
StockOffst Inventory Offset P&L Account nVarChar 15 OACT      
StorKeeper Storekeeper Int 11 OHEM      
Shipper Shipper nVarChar 15 OCRD      
BinActivat Bin Activated [Y/N] VarChar 1 - N Y Yes
            N No
BinSeptor Bin Separator nVarChar 5 - -    
DftBinAbs Default Bin Internal Number Int 11 OBIN      
DftBinEnfd Default Bin Enforced [Y/N] VarChar 1 - N Y Yes
            N No
AutoIssMtd Auto. Issue Method Int 6 - 0 0 Single Choice
            1 Bin Location Code Order
            2 Alternative Sort Code Order
            3 Descending Quantity
            4 Ascending Quantity
            7 Ascending Quantity - Single Bin Preferred
            5 FIFO
            6 LIFO
ManageSnB Drop-Ship Manage SnB VarChar 1 - N N No
            Y Yes
RecItemsBy Receiving Bin Locations Method Int 6 - 0 0 Bin Location Code Order
            1 Alternative Sort Code Order
RecBinEnab Enable Receiving Bin Locations VarChar 1 - N Y Yes
            N No
GlblLocNum Global Location Number nVarChar 50 -      
RecvEmpBin Restrict Receipts to Empty Bin VarChar 1 - Y Y Yes
            N No
Inactive Inactive VarChar 1 - N Y Yes
            N No
RecvMaxQty Recv. up to Max. Qty VarChar 1 - N Y Yes
            N No
AutoRecvMd Auto. Receipt Method Int 6 - 0 0 Default Bin Location
            1 Last Bin Location That Received Item
            2 Item's Current Bin Locations
            3 Item's Current and Historical Bin Locations
RecvMaxWT Recv. up to Max. Weight VarChar 1 - N Y Yes
            N No
RecvUpTo Receive up to nVarChar 6 - 0 0 Maximum Qty
            1 Maximum Weight
            2 Max. Qty and Weight
FreeChrgSA Free of Charge Sales Account nVarChar 15 -      
FreeChrgPU Free of Charge Purchase Account nVarChar 15 -      
TaxOffice Tax Office nVarChar 50 -      
Address2 Address Name 2 nVarChar 50 -      
Address3 Address Name 3 nVarChar 50 -      
External External VarChar 1 - N N No
            Y Yes
LegalText Legal Text nVarChar 250 -      
Key Unique Field
PRIMARY Yes WhsCode
    logInstanc