📚 SAP Business One SDK Help

Table Name: OITB

Table Description: Item Groups

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 Account nVarChar 15 OACT      
TransferAc Allocation Account 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      
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 Account nVarChar 15 OACT      
PurchaseAc Purchase Account nVarChar 15 OACT      
PAReturnAc Purchase Return Account nVarChar 15 OACT      
PurchOfsAc Purchase Offset Account nVarChar 15 OACT      
ShpdGdsAct Shipped Goods Account nVarChar 15 OACT      
VatRevAct VAT in Revenue Account nVarChar 15 OACT      
DecresGlAc G/L Decrease Account nVarChar 15 OACT      
IncresGlAc G/L Increase Account 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 Inventory Account nVarChar 15 OACT      
WipVarAcct WIP Inventory Variance Account nVarChar 15 OACT      
CostRvlAct COGS Revaluation Account nVarChar 15 OACT      
CstOffsAct COGS Revaluation Offset Acct nVarChar 15 OACT      
ExpClrAct Expense 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 Date of Update - History Date 8 -      
ARCMAct Sales Credit Account nVarChar 15 OACT      
ARCMFrnAct Sales Credit Account - Foreign nVarChar 15 OACT      
ARCMEUAct Sales Credit Account - EU nVarChar 15 OACT      
ARCMExpAct Tax Exempt Credit Account nVarChar 15 OACT      
APCMAct Purchase Credit Account nVarChar 15 OACT      
APCMFrnAct Purchase Credit Account - Foreign nVarChar 15 OACT      
APCMEUAct Purchase Credit Account - EU 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 Acct nVarChar 15 OACT      
StkInTnAct Stock In Transit Account 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 OACT      
FreeChrgPU Free of Charge Purchase Account nVarChar 15 OACT      
RawMtrl Raw Material VarChar 1 - N N No
            Y Yes
Key Unique Field
PRIMARY Yes ItmsGrpCod
GROUP_NAME Yes ItmsGrpNam