biuan SAP® BUSINESS ONE SDK
API AITB
AITB - Item Groups - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItmsGrpCod KEY UNIQUENumberInt
6
PRIMARYYes
ItmsGrpNam KEY UNIQUEGroup NamenVarChar
20
GROUP_NAMEYes
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
BalInvntAcInventory AccountnVarChar
15OACT
G/L Accounts
SaleCostAcCost Of Goods SoldnVarChar
15OACT
G/L Accounts
TransferAcAllocation AcctnVarChar
15OACT
G/L Accounts
RevenuesAcRevenue AccountnVarChar
15OACT
G/L Accounts
VarianceAcVariance AcctnVarChar
15OACT
G/L Accounts
DecreasAcInventory Offset - DecreasenVarChar
15OACT
G/L Accounts
IncreasAcInventory Offset - IncreasenVarChar
15OACT
G/L Accounts
ReturnAcSales ReturnsnVarChar
15OACT
G/L Accounts
ExpensesAcExpense AccountnVarChar
15OACT
G/L Accounts
EURevenuAcSales Revenue - EUnVarChar
15OACT
G/L Accounts
EUExpensAcEU Expense AcctnVarChar
15OACT
G/L Accounts
FrRevenuAcSales Revenue - ForeignnVarChar
15OACT
G/L Accounts
FrExpensAcForeign Expense AcctnVarChar
15OACT
G/L Accounts
ExmptIncomExempt Revenue AccountnVarChar
15OACT
G/L Accounts
CycleCodeCycle CodeInt
6OCYC
Cycle
AlertAlertVarChar
N) No
Y) Yes
1
N
PriceDifAcPrice Difference AccountnVarChar
15OACT
G/L Accounts
ExchangeAcExchange Rate Differences AccountnVarChar
15OACT
G/L Accounts
BalanceAccGoods Clearing AcctnVarChar
15OACT
G/L Accounts
PurchaseAcPurchase AcctnVarChar
15OACT
G/L Accounts
PAReturnAcPA Return AcctnVarChar
15OACT
G/L Accounts
PurchOfsAcPurchase Offset AcctnVarChar
15OACT
G/L Accounts
ShpdGdsActShipped Goods AccountnVarChar
15OACT
G/L Accounts
VatRevActVAT in Revenue AccountnVarChar
15OACT
G/L Accounts
DecresGlAcG/L Decrease AcctnVarChar
15OACT
G/L Accounts
IncresGlAcG/L Increase AcctnVarChar
15OACT
G/L Accounts
InvntSysInventory SystemVarChar
A) Moving Average
S) Standard
F) FIFO
1
PlaningSysPlanning MethodVarChar
M) MRP
N) None
1
N
PrcrmntMtdProcurement MethodVarChar
B) Buy
M) Make
1
B
OrdrIntrvlOrder IntervalInt
6OCYC
Cycle
OrdrMultiOrder MultipleNum
20
MinOrdrQtyMinimum Order QuantityNum
20
LeadTimeLead TimeInt
11
StokRvlActInventory Revaluation AccountnVarChar
15OACT
G/L Accounts
StkOffsActInventory Revaluation Offset AccountnVarChar
15OACT
G/L Accounts
WipAcctWIP Material AccountnVarChar
15OACT
G/L Accounts
WipVarAcctWIP Material Variance AccountnVarChar
15OACT
G/L Accounts
CostRvlActCost of Sale Revaluation AcctnVarChar
15OACT
G/L Accounts
CstOffsActCost of Sales Reval. Offs. AcctnVarChar
15OACT
G/L Accounts
ExpClrActExpenses Clearing AccountnVarChar
15OACT
G/L Accounts
ExpOfstActExpense Offset AccountnVarChar
15OACT
G/L Accounts
ObjectObject Type - HistorynVarChar
20
52
logInstancLog Instance - HistoryInt
11
createDateCreation Date - HistoryDate
8
userSign2Updating User - HistoryInt
6OUSR
Users
updateDateUpdate Date - HistoryDate
8
ARCMActSales Credit AcctnVarChar
15OACT
G/L Accounts
ARCMFrnActSales Credit Foreign AcctnVarChar
15OACT
G/L Accounts
ARCMEUActSales Credit EU AcctnVarChar
15OACT
G/L Accounts
ARCMExpActExempted CreditsnVarChar
15OACT
G/L Accounts
APCMActPurchase Credit AcctnVarChar
15OACT
G/L Accounts
APCMFrnActForeign Purchase Credit AcctnVarChar
15OACT
G/L Accounts
APCMEUActEU Purchase Credit AcctnVarChar
15OACT
G/L Accounts
RevRetActRevenue Returns AccountnVarChar
15OACT
G/L Accounts
ItemClassService or MaterialVarChar
1) Service
2) Material
1
2
OSvcCodeOutgoing Service CodeInt
11OSCD
Service Code Table
-1
ISvcCodeIncoming Service CodeInt
11OSCD
Service Code Table
-1
ServiceGrpService GroupInt
11OSGP
Service Group for Brazil
-1
NCMCodeNCM CodeInt
11ONCM
NCM Code
-1
MatTypeMaterial TypenVarChar
3OMTP
Material Type
1
MatGrpMaterial GroupInt
11OMGP
Material Group
-1
ProductSrcProduct SourcenVarChar
2OPSC
Product Source Code
0
NegStckActNegative Inventory AdjustmentnVarChar
15OACT
G/L Accounts
StkInTnActStock In Transit AcctnVarChar
15OACT
G/L Accounts
PurBalActPurchase Balance AccountnVarChar
15OACT
G/L Accounts
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
UgpEntryDefault UoM Group EntryInt
11OUGP
UoM Group
IUoMEntryDefault Inventory UoMInt
11OUOM
UoM Master Data
ToleranDayTolerance DaysInt
11
RuleCodeChecking Rule CodenVarChar
2ODCR
Checking Rule
CompoWHComponent WarehouseVarChar
B) From Bill of Materials Line
P) From Parent Item Document Line
1
B
FreeChrgSAFree of Charge Sales AccountnVarChar
15
FreeChrgPUFree of Charge Purchase AccountnVarChar
15

Table relationship map

SELECT statement

SELECT AITB.ItmsGrpCod AS 'Number', AITB.ItmsGrpNam AS 'Group Name', AITB.Locked AS 'Locked', AITB.DataSource AS 'Data Source', AITB.UserSign AS 'User Signature', AITB.BalInvntAc AS 'Inventory Account', AITB.SaleCostAc AS 'Cost Of Goods Sold', AITB.TransferAc AS 'Allocation Acct', AITB.RevenuesAc AS 'Revenue Account', AITB.VarianceAc AS 'Variance Acct', AITB.DecreasAc AS 'Inventory Offset - Decrease', AITB.IncreasAc AS 'Inventory Offset - Increase', AITB.ReturnAc AS 'Sales Returns', AITB.ExpensesAc AS 'Expense Account', AITB.EURevenuAc AS 'Sales Revenue - EU', AITB.EUExpensAc AS 'EU Expense Acct', AITB.FrRevenuAc AS 'Sales Revenue - Foreign', AITB.FrExpensAc AS 'Foreign Expense Acct', AITB.ExmptIncom AS 'Exempt Revenue Account', AITB.CycleCode AS 'Cycle Code', AITB.Alert AS 'Alert', AITB.PriceDifAc AS 'Price Difference Account', AITB.ExchangeAc AS 'Exchange Rate Differences Account', AITB.BalanceAcc AS 'Goods Clearing Acct', AITB.PurchaseAc AS 'Purchase Acct', AITB.PAReturnAc AS 'PA Return Acct', AITB.PurchOfsAc AS 'Purchase Offset Acct', AITB.ShpdGdsAct AS 'Shipped Goods Account', AITB.VatRevAct AS 'VAT in Revenue Account', AITB.DecresGlAc AS 'G/L Decrease Acct', AITB.IncresGlAc AS 'G/L Increase Acct', AITB.InvntSys AS 'Inventory System', AITB.PlaningSys AS 'Planning Method', AITB.PrcrmntMtd AS 'Procurement Method', AITB.OrdrIntrvl AS 'Order Interval', AITB.OrdrMulti AS 'Order Multiple', AITB.MinOrdrQty AS 'Minimum Order Quantity', AITB.LeadTime AS 'Lead Time', AITB.StokRvlAct AS 'Inventory Revaluation Account', AITB.StkOffsAct AS 'Inventory Revaluation Offset Account', AITB.WipAcct AS 'WIP Material Account', AITB.WipVarAcct AS 'WIP Material Variance Account', AITB.CostRvlAct AS 'Cost of Sale Revaluation Acct', AITB.CstOffsAct AS 'Cost of Sales Reval. Offs. Acct', AITB.ExpClrAct AS 'Expenses Clearing Account', AITB.ExpOfstAct AS 'Expense Offset Account', AITB.Object AS 'Object Type - History', AITB.logInstanc AS 'Log Instance - History', AITB.createDate AS 'Creation Date - History', AITB.userSign2 AS 'Updating User - History', AITB.updateDate AS 'Update Date - History', AITB.ARCMAct AS 'Sales Credit Acct', AITB.ARCMFrnAct AS 'Sales Credit Foreign Acct', AITB.ARCMEUAct AS 'Sales Credit EU Acct', AITB.ARCMExpAct AS 'Exempted Credits', AITB.APCMAct AS 'Purchase Credit Acct', AITB.APCMFrnAct AS 'Foreign Purchase Credit Acct', AITB.APCMEUAct AS 'EU Purchase Credit Acct', AITB.RevRetAct AS 'Revenue Returns Account', AITB.ItemClass AS 'Service or Material', AITB.OSvcCode AS 'Outgoing Service Code', AITB.ISvcCode AS 'Incoming Service Code', AITB.ServiceGrp AS 'Service Group', AITB.NCMCode AS 'NCM Code', AITB.MatType AS 'Material Type', AITB.MatGrp AS 'Material Group', AITB.ProductSrc AS 'Product Source', AITB.NegStckAct AS 'Negative Inventory Adjustment', AITB.StkInTnAct AS 'Stock In Transit Acct', AITB.PurBalAct AS 'Purchase Balance Account', AITB.WhICenAct AS 'Incoming CENVAT Account (WH)', AITB.WhOCenAct AS 'Outgoing CENVAT Account (WH)', AITB.WipOffset AS 'WIP Offset P&L Account', AITB.StockOffst AS 'Inventory Offset P&L Account', AITB.UgpEntry AS 'Default UoM Group Entry', AITB.IUoMEntry AS 'Default Inventory UoM', AITB.ToleranDay AS 'Tolerance Days', AITB.RuleCode AS 'Checking Rule Code', AITB.CompoWH AS 'Component Warehouse', AITB.FreeChrgSA AS 'Free of Charge Sales Account', AITB.FreeChrgPU AS 'Free of Charge Purchase Account' FROM AITB AS AITB

Related information


G/L Accounts OACT SQL Table

Cycle OCYC SQL Table

Service Code Table OSCD SQL Table

UoM Master Data OUOM SQL Table

Material Group OMGP SQL Table

Material Type OMTP SQL Table

NCM Code ONCM SQL Table

Product Source Code OPSC SQL Table

Checking Rule ODCR SQL Table

Service Group for Brazil OSGP SQL Table

UoM Group OUGP SQL Table

Users OUSR 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