📚 SAP Business One SDK Help

Table Name: AITB

Table Description: Item Groups - History

Field Description Type Size Related Default Value Constraints
ItmsGrpCod Number Int 6 -      
ItmsGrpNam Group Name nVarChar 100 -      
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      
BalInvntAc Inventory Account nVarChar 15 OACT      
SaleCostAc Cost Of Goods Sold nVarChar 15 OACT      
TransferAc Allocation Acct nVarChar 15 OACT      
RevenuesAc Revenue Account nVarChar 15 OACT      
VarianceAc Variance Acct nVarChar 15 OACT      
DecreasAc Inventory Offset - Decrease nVarChar 15 OACT      
IncreasAc Inventory Offset - Increase nVarChar 15 OACT      
ReturnAc Sales Returns nVarChar 15 OACT      
ExpensesAc Expense Account nVarChar 15 OACT      
EURevenuAc Sales Revenue - EU nVarChar 15 OACT      
EUExpensAc EU Expense Acct nVarChar 15 OACT      
FrRevenuAc Sales Revenue - Foreign nVarChar 15 OACT      
FrExpensAc Foreign Expense Acct nVarChar 15 OACT      
ExmptIncom Exempt Revenue Account nVarChar 15 OACT      
CycleCode Cycle Code Int 6 OCYC      
Alert Alert VarChar 1 - N N No
            Y Yes
PriceDifAc Price Difference Account nVarChar 15 OACT      
ExchangeAc Exchange Rate Differences Account nVarChar 15 OACT      
BalanceAcc Goods Clearing Acct nVarChar 15 OACT      
PurchaseAc Purchase Acct nVarChar 15 OACT      
PAReturnAc PA Return Acct nVarChar 15 OACT      
PurchOfsAc Purchase Offset Acct nVarChar 15 OACT      
ShpdGdsAct Shipped Goods Account nVarChar 15 OACT      
VatRevAct VAT in Revenue Account nVarChar 15 OACT      
DecresGlAc G/L Decrease Acct nVarChar 15 OACT      
IncresGlAc G/L Increase Acct nVarChar 15 OACT      
InvntSys Inventory System VarChar 1 -   A Moving Average
            S Standard
            F FIFO
PlaningSys Planning Method VarChar 1 - N M MRP
            N None
PrcrmntMtd Procurement Method VarChar 1 - B B Buy
            M Make
OrdrIntrvl Order Interval Int 6 OCYC      
OrdrMulti Order Multiple Num 19.6 -      
MinOrdrQty Minimum Order Quantity Num 19.6 -      
LeadTime Lead Time Int 11 -      
StokRvlAct Inventory Revaluation Account nVarChar 15 OACT      
StkOffsAct Inventory Revaluation Offset Account nVarChar 15 OACT      
WipAcct WIP Material Account nVarChar 15 OACT      
WipVarAcct WIP Material Variance Account nVarChar 15 OACT      
CostRvlAct Cost of Sale Revaluation Acct nVarChar 15 OACT      
CstOffsAct Cost of Sales Reval. Offs. Acct nVarChar 15 OACT      
ExpClrAct Expenses Clearing Account nVarChar 15 OACT      
ExpOfstAct Expense Offset Account nVarChar 15 OACT      
Object Object Type - History nVarChar 20 - 52    
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 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      
ItemClass Service or Material VarChar 1 - 2 1 Service
            2 Material
OSvcCode Outgoing Service Code Int 11 OSCD -1    
ISvcCode Incoming Service Code Int 11 OSCD -1    
ServiceGrp Service Group Int 11 OSGP -1    
NCMCode NCM Code Int 11 ONCM -1    
MatType Material Type nVarChar 3 OMTP 1    
MatGrp Material Group Int 11 OMGP -1    
ProductSrc Product Source nVarChar 2 OPSC 0    
NegStckAct Negative Inventory Adjustment nVarChar 15 OACT      
StkInTnAct Stock In Transit Acct nVarChar 15 OACT      
PurBalAct Purchase Balance Account nVarChar 15 OACT      
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      
UgpEntry Default UoM Group Entry Int 11 OUGP      
IUoMEntry Default Inventory UoM Int 11 OUOM      
ToleranDay Tolerance Days Int 11 -      
RuleCode Checking Rule Code nVarChar 2 ODCR      
CompoWH Component Warehouse VarChar 1 - B B From Bill of Materials Line
            P From Parent Item Document Line
FreeChrgSA Free of Charge Sales Account nVarChar 15 -      
FreeChrgPU Free of Charge Purchase Account nVarChar 15 -      
RawMtrl Raw Material VarChar 1 - N N No
            Y Yes
Key Unique Field
PRIMARY Yes ItmsGrpCod
    logInstanc
GROUP_NAME No ItmsGrpNam
    logInstanc