📚 SAP Business One SDK Help

Table Name: SITW

Table Description: Items - Warehouse

Field Description Type Size Related Default Value Constraints
ItemCode Item No. nVarChar 50 OITM      
WhsCode Warehouse Code nVarChar 8 OWHS      
OnHand In Stock Num 19.6 -      
IsCommited Defined Num 19.6 -      
OnOrder Ordered Num 19.6 -      
Consig Consignment Goods Whse Num 19.6 -      
Counted Counted Quantity Num 19.6 -      
WasCounted Counted Yes/No VarChar 1 - N Y Yes
            N No
UserSign User Signature Int 6 OUSR      
MinStock Minimum Inventory Num 19.6 -      
MaxStock Maximum Inventory Num 19.6 -      
MinOrder Min. Order Num 19.6 -      
AvgPrice Average Price Num 19.6 -      
Locked Locked VarChar 1 - N Y Yes
            N No
BalInvntAc Inventory Account nVarChar 15 OACT      
SaleCostAc Cost of Goods Sold Account nVarChar 15 OACT      
TransferAc Transfer Acct nVarChar 15 OACT      
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      
ExmptIncom Exempt Revenue Account nVarChar 15 OACT      
PriceDifAc Price Differences Account nVarChar 15 -      
ExchangeAc Exchange Rate Differences Account nVarChar 15 -      
BalanceAcc Goods Clearing Account nVarChar 15 -      
PurchaseAc Purchase Account nVarChar 15 -      
PAReturnAc Purchase Return Account nVarChar 15 -      
PurchOfsAc Purchase Offset Account nVarChar 15 -      
ShpdGdsAct Shipped Goods Account nVarChar 15 -      
VatRevAct VAT in Revenue Account nVarChar 15 -      
StockValue Inventory Value Num 19.6 -      
DecresGlAc G/L Decrease Account nVarChar 15 -      
IncresGlAc G/L Increase Account nVarChar 15 -      
StokRvlAct Stock Inflation Adjust Account nVarChar 15 -      
StkOffsAct Stock Inflation Offset Account nVarChar 15 -      
WipAcct WIP Inventory Account nVarChar 15 -      
WipVarAcct WIP Inventory Variance Account nVarChar 15 -      
CostRvlAct Cost Inflation Account nVarChar 15 -      
CstOffsAct Cost Inflation Offset Account nVarChar 15 -      
ExpClrAct Expense Clearing Account nVarChar 15 OACT      
ExpOfstAct Expense Offset Account nVarChar 15 OACT      
Object Object Type - History nVarChar 20 - 31    
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 Account nVarChar 15 -      
ARCMFrnAct Sales Credit Account - Foreign nVarChar 15 -      
ARCMEUAct Sales Credit Account - EU nVarChar 15 -      
ARCMExpAct Tax Exempt Credit Account nVarChar 15 -      
APCMAct Purchase Credit Account nVarChar 15 -      
APCMFrnAct Purchase Credit Account - Foreign nVarChar 15 -      
APCMEUAct Purchase Credit Account - EU nVarChar 15 -      
RevRetAct Revenue Returns Account nVarChar 15 -      
NegStckAct Negative Inventory Adj. Acct nVarChar 15 OACT      
StkInTnAct Stock In Transit Account nVarChar 15 -      
PurBalAct Purchase Balance Account nVarChar 15 -      
WhICenAct Incoming CENVAT Account (WH) nVarChar 15 OACT      
WhOCenAct Outgoing CENVAT Account (WH) nVarChar 15 OACT      
WipOffset WIP Offset P&L Account nVarChar 15 OACT      
StockOffst Inventory Offset P&L Account nVarChar 15 OACT      
DftBinAbs Default Bin Internal Number Int 11 OBIN      
DftBinEnfd Default Bin Enforced [Y/N] VarChar 1 - N Y Yes
            N No
Freezed Item Frozen in Warehouse VarChar 1 - N Y Yes
            N No
FreezeDoc INC Document Frozen By Int 11 OINC      
FreeChrgSA Free of Charge Sales Account nVarChar 15 -      
FreeChrgPU Free of Charge Purchase Account nVarChar 15 -      
IndEscala Indicator for Relevant Scale VarChar 1 - Y Y Yes
            N No
CNJPMan CNPJ of Manufacturer nVarChar 14 -      
Key Unique Field
PRIMARY Yes ItemCode
    WhsCode
WHS No WhsCode