biuan SAP® BUSINESS ONE SDK
API AITW
AITW - Items - Warehouse - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEYItem No.nVarChar
20OITM
Items
ITEMNo
WhsCode KEYWarehouse CodenVarChar
8OWHS
Warehouses
WHSNo
OnHandIn StockNum
20
IsCommitedDefinedNum
20
OnOrderOrderedNum
20
ConsigConsignment Goods WHNum
20
CountedCounted QuantityNum
20
WasCounted KEYCounted Yes/NoVarChar
Y) Yes
N) No
1
NCOUNTEDNo
UserSignUser SignatureInt
6OUSR
Users
MinStockMin. StockNum
20
MaxStockMax. StockNum
20
MinOrderMin. OrderNum
20
AvgPriceAverage PriceNum
20
LockedLockedVarChar
Y) Yes
N) No
1
N
BalInvntAcInventory Acc.nVarChar
15OACT
G/L Accounts
SaleCostAcCost Acc.nVarChar
15OACT
G/L Accounts
TransferAcTransfers Acc.nVarChar
15OACT
G/L Accounts
RevenuesAcRevenues AcctnVarChar
15OACT
G/L Accounts
VarianceAcVariance Acc.nVarChar
15OACT
G/L Accounts
DecreasAcInventory Offset - Decrease AccountnVarChar
15OACT
G/L Accounts
IncreasAcInventory Offset - Increase AccountnVarChar
15OACT
G/L Accounts
ReturnAcSales ReturnsnVarChar
15OACT
G/L Accounts
ExpensesAcExpenses Acct.nVarChar
15OACT
G/L Accounts
EURevenuAcSales Revenue - EUnVarChar
15OACT
G/L Accounts
EUExpensAcEU Expenses Acc.nVarChar
15OACT
G/L Accounts
FrRevenuAcSales Revenue - ForeignnVarChar
15OACT
G/L Accounts
FrExpensAcForeign Expenses Acc.nVarChar
15OACT
G/L Accounts
ExmptIncomExempt Revenues AccountnVarChar
15OACT
G/L Accounts
PriceDifAcPrice Differences Acc.nVarChar
15
ExchangeAcExchange Rate Differences Acc.nVarChar
15
BalanceAccGoods Clearing Acc.nVarChar
15
PurchaseAcPurchase Acc.nVarChar
15
PAReturnAcPA Return Acc.nVarChar
15
PurchOfsAcPurchase Offset Acc.nVarChar
15
ShpdGdsActShipped Goods AccountnVarChar
15
VatRevActVAT in Revenue AccountnVarChar
15
StockValueStock ValueNum
20
DecresGlAcDecrease GL Acc.nVarChar
15
IncresGlAcIncrease GL Acc.nVarChar
15
StokRvlActStock Inflation Adjust AccountnVarChar
15
StkOffsActStock Inflation Offset AccountnVarChar
15
WipAcctWIP Material AccountnVarChar
15
WipVarAcctWIP Material Variance AccountnVarChar
15
CostRvlActCost Inflation AccountnVarChar
15
CstOffsActCost Inflation Offset AccountnVarChar
15
ExpClrActExpenses Clearing AccountnVarChar
15OACT
G/L Accounts
ExpOfstActExpense Offsetting AccountnVarChar
15OACT
G/L Accounts
ObjectObject Type - HistorynVarChar
20
31
logInstancLog Instance - HistoryInt
11
createDateCreation Date - HistoryDate
8
userSign2Updating User - HistoryInt
6OUSR
Users
updateDateUpdate Date - HistoryDate
8
ARCMActSales Credit AcctnVarChar
15
ARCMFrnActSales Credit Foreign AcctnVarChar
15
ARCMEUActSales Credit EU AcctnVarChar
15
ARCMExpActExempted CreditsnVarChar
15
APCMActPurchase Credit AcctnVarChar
15
APCMFrnActForeign Purchase Credit AcctnVarChar
15
APCMEUActEU Purchase Credit AcctnVarChar
15
RevRetActRevenue Returns AccountnVarChar
15
NegStckActNegative Stock Adjustment AcctnVarChar
15OACT
G/L Accounts
StkInTnActStock In Transit AcctnVarChar
15
PurBalActPurchase Balance AccountnVarChar
15
WhICenActIncoming CENVAT Account (WH)nVarChar
15OACT
G/L Accounts
WhOCenActOutgoing CENVAT Account (WH)nVarChar
15OACT
G/L Accounts
WipOffsetWIP Offset P&L AccountnVarChar
15OACT
G/L Accounts
StockOffstInventory Offset P&L AccountnVarChar
15OACT
G/L Accounts
DftBinAbsDefault Bin Internal NumberInt
11OBIN
Bin Location
DftBinEnfdDefault Bin Enforced [Y/N]VarChar
Y) Yes
N) No
1
N
FreezedItem Frozen in WarehouseVarChar
Y) Yes
N) No
1
N
FreezeDocINC Document Frozen ByInt
11OINC
Inventory Counting
FreeChrgSAFree of Charge Sales AccountnVarChar
15
FreeChrgPUFree of Charge Purchase AccountnVarChar
15

Table relationship map

SELECT statement

SELECT AITW.ItemCode AS 'Item No.', AITW.WhsCode AS 'Warehouse Code', AITW.OnHand AS 'In Stock', AITW.IsCommited AS 'Defined', AITW.OnOrder AS 'Ordered', AITW.Consig AS 'Consignment Goods WH', AITW.Counted AS 'Counted Quantity', AITW.WasCounted AS 'Counted Yes/No', AITW.UserSign AS 'User Signature', AITW.MinStock AS 'Min. Stock', AITW.MaxStock AS 'Max. Stock', AITW.MinOrder AS 'Min. Order', AITW.AvgPrice AS 'Average Price', AITW.Locked AS 'Locked', AITW.BalInvntAc AS 'Inventory Acc.', AITW.SaleCostAc AS 'Cost Acc.', AITW.TransferAc AS 'Transfers Acc.', AITW.RevenuesAc AS 'Revenues Acct', AITW.VarianceAc AS 'Variance Acc.', AITW.DecreasAc AS 'Inventory Offset - Decrease Account', AITW.IncreasAc AS 'Inventory Offset - Increase Account', AITW.ReturnAc AS 'Sales Returns', AITW.ExpensesAc AS 'Expenses Acct.', AITW.EURevenuAc AS 'Sales Revenue - EU', AITW.EUExpensAc AS 'EU Expenses Acc.', AITW.FrRevenuAc AS 'Sales Revenue - Foreign', AITW.FrExpensAc AS 'Foreign Expenses Acc.', AITW.ExmptIncom AS 'Exempt Revenues Account', AITW.PriceDifAc AS 'Price Differences Acc.', AITW.ExchangeAc AS 'Exchange Rate Differences Acc.', AITW.BalanceAcc AS 'Goods Clearing Acc.', AITW.PurchaseAc AS 'Purchase Acc.', AITW.PAReturnAc AS 'PA Return Acc.', AITW.PurchOfsAc AS 'Purchase Offset Acc.', AITW.ShpdGdsAct AS 'Shipped Goods Account', AITW.VatRevAct AS 'VAT in Revenue Account', AITW.StockValue AS 'Stock Value', AITW.DecresGlAc AS 'Decrease GL Acc.', AITW.IncresGlAc AS 'Increase GL Acc.', AITW.StokRvlAct AS 'Stock Inflation Adjust Account', AITW.StkOffsAct AS 'Stock Inflation Offset Account', AITW.WipAcct AS 'WIP Material Account', AITW.WipVarAcct AS 'WIP Material Variance Account', AITW.CostRvlAct AS 'Cost Inflation Account', AITW.CstOffsAct AS 'Cost Inflation Offset Account', AITW.ExpClrAct AS 'Expenses Clearing Account', AITW.ExpOfstAct AS 'Expense Offsetting Account', AITW.Object AS 'Object Type - History', AITW.logInstanc AS 'Log Instance - History', AITW.createDate AS 'Creation Date - History', AITW.userSign2 AS 'Updating User - History', AITW.updateDate AS 'Update Date - History', AITW.ARCMAct AS 'Sales Credit Acct', AITW.ARCMFrnAct AS 'Sales Credit Foreign Acct', AITW.ARCMEUAct AS 'Sales Credit EU Acct', AITW.ARCMExpAct AS 'Exempted Credits', AITW.APCMAct AS 'Purchase Credit Acct', AITW.APCMFrnAct AS 'Foreign Purchase Credit Acct', AITW.APCMEUAct AS 'EU Purchase Credit Acct', AITW.RevRetAct AS 'Revenue Returns Account', AITW.NegStckAct AS 'Negative Stock Adjustment Acct', AITW.StkInTnAct AS 'Stock In Transit Acct', AITW.PurBalAct AS 'Purchase Balance Account', AITW.WhICenAct AS 'Incoming CENVAT Account (WH)', AITW.WhOCenAct AS 'Outgoing CENVAT Account (WH)', AITW.WipOffset AS 'WIP Offset P&L Account', AITW.StockOffst AS 'Inventory Offset P&L Account', AITW.DftBinAbs AS 'Default Bin Internal Number', AITW.DftBinEnfd AS 'Default Bin Enforced [Y/N]', AITW.Freezed AS 'Item Frozen in Warehouse', AITW.FreezeDoc AS 'INC Document Frozen By', AITW.FreeChrgSA AS 'Free of Charge Sales Account', AITW.FreeChrgPU AS 'Free of Charge Purchase Account' FROM AITW AS AITW

Related information


G/L Accounts OACT SQL Table

Bin Location OBIN SQL Table

Inventory Counting OINC SQL Table

Items OITM SQL Table

Users OUSR SQL Table

Warehouses OWHS 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