📚 SAP Business One SDK Help

Table Name: AITW

Table Description: Items - Warehouse - History

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 WH 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 Min. Stock Num 19.6 -      
MaxStock Max. Stock 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 Acc. nVarChar 15 OACT      
SaleCostAc Cost Acc. nVarChar 15 OACT      
TransferAc Transfers Acc. nVarChar 15 OACT      
RevenuesAc Revenues Acct nVarChar 15 OACT      
VarianceAc Variance Acc. nVarChar 15 OACT      
DecreasAc Inventory Offset - Decrease Account nVarChar 15 OACT      
IncreasAc Inventory Offset - Increase Account nVarChar 15 OACT      
ReturnAc Sales Returns nVarChar 15 OACT      
ExpensesAc Expenses Acct. nVarChar 15 OACT      
EURevenuAc Sales Revenue - EU nVarChar 15 OACT      
EUExpensAc EU Expenses Acc. nVarChar 15 OACT      
FrRevenuAc Sales Revenue - Foreign nVarChar 15 OACT      
FrExpensAc Foreign Expenses Acc. nVarChar 15 OACT      
ExmptIncom Exempt Revenues Account nVarChar 15 OACT      
PriceDifAc Price Differences Acc. nVarChar 15 -      
ExchangeAc Exchange Rate Differences Acc. nVarChar 15 -      
BalanceAcc Goods Clearing Acc. nVarChar 15 -      
PurchaseAc Purchase Acc. nVarChar 15 -      
PAReturnAc PA Return Acc. nVarChar 15 -      
PurchOfsAc Purchase Offset Acc. nVarChar 15 -      
ShpdGdsAct Shipped Goods Account nVarChar 15 -      
VatRevAct VAT in Revenue Account nVarChar 15 -      
StockValue Stock Value Num 19.6 -      
DecresGlAc Decrease GL Acc. nVarChar 15 -      
IncresGlAc Increase GL Acc. nVarChar 15 -      
StokRvlAct Stock Inflation Adjust Account nVarChar 15 -      
StkOffsAct Stock Inflation Offset Account nVarChar 15 -      
WipAcct WIP Material Account nVarChar 15 -      
WipVarAcct WIP Material Variance Account nVarChar 15 -      
CostRvlAct Cost Inflation Account nVarChar 15 -      
CstOffsAct Cost Inflation Offset Account nVarChar 15 -      
ExpClrAct Expenses Clearing Account nVarChar 15 OACT      
ExpOfstAct Expense Offsetting 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 Update Date - History Date 8 -      
ARCMAct Sales Credit Acct nVarChar 15 -      
ARCMFrnAct Sales Credit Foreign Acct nVarChar 15 -      
ARCMEUAct Sales Credit EU Acct nVarChar 15 -      
ARCMExpAct Exempted Credits nVarChar 15 -      
APCMAct Purchase Credit Acct nVarChar 15 -      
APCMFrnAct Foreign Purchase Credit Acct nVarChar 15 -      
APCMEUAct EU Purchase Credit Acct nVarChar 15 -      
RevRetAct Revenue Returns Account nVarChar 15 -      
NegStckAct Negative Stock Adjustment Acct nVarChar 15 OACT      
StkInTnAct Stock In Transit Acct 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
    logInstanc
ITEM No ItemCode
WHS No WhsCode
COUNTED No WasCounted