📚 SAP Business One SDK Help

Table Name: AITM

Table Description: Items - History

Field Description Type Size Related Default Value Constraints
ItemCode Item Number nVarChar 50 -      
ItemName Item Description nVarChar 200 -      
FrgnName Foreign Name nVarChar 200 -      
ItmsGrpCod Item Group Int 6 OITB 100    
CstGrpCode Customs Group Int 6 OARG -1    
VatGourpSa Tax Definition nVarChar 8 OVTG      
CodeBars Bar Code nVarChar 254 -      
VATLiable Tax Liable VarChar 1 - Y Y Yes
            N No
PrchseItem Purchasing Item VarChar 1 - Y Y Yes
            N No
SellItem Sales Item VarChar 1 - Y Y Yes
            N No
InvntItem Inventory Item VarChar 1 - Y Y Yes
            N No
OnHand In Stock Num 19.6 -      
IsCommited Qty Ordered by Customers Num 19.6 -      
OnOrder Qty Ordered from Vendors Num 19.6 -      
IncomeAcct Revenue Account nVarChar 15 OACT      
ExmptIncom Exempt Revenue Account nVarChar 15 OACT      
MaxLevel Free1 Num 19.6 -      
DfltWH Default Whse nVarChar 8 -      
CardCode Preferred Vendor nVarChar 15 OCRD      
SuppCatNum Mfr Catalog No. nVarChar 50 -      
BuyUnitMsr Purchasing UoM nVarChar 100 - Unit    
NumInBuy Items per Purchasing Unit Num 19.6 -      
ReorderQty Required (Purchasing UoM) Num 19.6 -      
MinLevel Minimum Inventory Level Num 19.6 -      
LstEvlPric Last Evaluated Price Num 19.6 -      
LstEvlDate Date of Last Revaluation Price Date 8 -      
CustomPer Customs Rate Num 19.6 -      
Canceled Canceled Item [Yes/No] VarChar 1 - N Y Yes
            N No
MnufctTime Production Date Int 11 -      
WholSlsTax Tax Rate for Wholesaler VarChar 1 -      
RetilrTax Sales Tax % VarChar 1 -      
SpcialDisc Special Discount % Num 19.6 -      
DscountCod Discount Code Int 6 -      
TrackSales Follow-Up [Yes/No] VarChar 1 - N Y Yes
            N No
SalUnitMsr Sales UoM nVarChar 100 - Unit    
NumInSale No. of Items per Sales Unit Num 19.6 -      
Consig Consignment Goods Whse Num 19.6 -      
QueryGroup Properties Int 11 - 0    
Counted Counted Qty Num 19.6 -      
OpenBlnc Opening Stock Num 19.6 -      
EvalSystem Valuation Method VarChar 1 -   A Moving Average
            S Standard
            F FIFO
            B Serial/Batch
UserSign User Signature Int 6 OUSR      
FREE Free Item [Y/N] VarChar 1 - N Y Yes
            N No
PicturName Picture nVarChar 200 -      
Transfered Year Transferred [Y/N] VarChar 1 - N Y Yes
            N No
BlncTrnsfr Balances Transferred [Y/N] VarChar 1 - N Y Yes
            N No
UserText Item Remarks Text 16 -      
SerialNum Serial Number nVarChar 17 -      
CommisPcnt Commission % for Item Num 19.6 -      
CommisSum Total Commission for Item Num 19.6 -      
CommisGrp Commission Group Int 6 OCOG 0    
TreeType Bill of Materials Type VarChar 1 - N N Not a BOM
            A Assembly
            S Sales
            P Production
            T Template
TreeQty No. of Units Num 19.6 -      
LastPurPrc Last Purchase Price Num 19.6 -      
LastPurCur Last Purchase Currency nVarChar 3 -      
LastPurDat Last Purchase Date Date 8 -      
ExitCur Release Currency nVarChar 3 -      
ExitPrice Release Price Num 19.6 -      
ExitWH Release Warehouse nVarChar 8 -      
AssetItem Fixed Asset Indicator VarChar 1 - N Y Yes
            N No
WasCounted Counted VarChar 1 - N Y Yes
            N No
ManSerNum Serial No. Management VarChar 1 - N Y Yes
            N No
SHeight1 Height 1 - Sales Unit Num 19.6 -      
SHght1Unit Height 1 - UoM for Sales Int 6 -      
SHeight2 Height 2 - Sales Unit Num 19.6 -      
SHght2Unit Height 2 - UoM for Sales Int 6 -      
SWidth1 Width 1 - Sales Unit Num 19.6 -      
SWdth1Unit Width 1 - UoM for Sales Int 6 -      
SWidth2 Width 2 - Sales Unit Num 19.6 -      
SWdth2Unit Width 2 - UoM for Sales Int 6 -      
SLength1 Length 1 - Sales Unit Num 19.6 -      
SLen1Unit Length 1 - UoM for Sales Int 6 -      
Slength2 Length 2 - Sales Unit Num 19.6 -      
SLen2Unit Length 2 - UoM for Sales Int 6 -      
SVolume Volume - Sales Unit Num 19.6 -      
SVolUnit Volume - UoM for Sales Int 6 -      
SWeight1 Weight 1 - Sales Unit Num 19.6 -      
SWght1Unit Weight 1 - UoM for Sales Int 6 -      
SWeight2 Weight 2 - Sales Unit Num 19.6 -      
SWght2Unit Weight 2 - UoM for Sales Int 6 -      
BHeight1 Height 1 - Purchasing Unit Num 19.6 -      
BHght1Unit Height 1 - UoM for Purchasing Int 6 -      
BHeight2 Height 2 - Purchasing Unit Num 19.6 -      
BHght2Unit Height 2 - UoM for Purchasing Int 6 -      
BWidth1 Width 1 - Purchasing Unit Num 19.6 -      
BWdth1Unit Width 1 - UoM for Purchasing Int 6 -      
BWidth2 Width 2 - Purchasing Unit Num 19.6 -      
BWdth2Unit Width 2 - UoM for Purchasing Int 6 -      
BLength1 Length 1 - Purchase Unit Num 19.6 -      
BLen1Unit Length 1 - UoM for Purchasing Int 6 -      
Blength2 Length 2 - Purchasing Unit Num 19.6 -      
BLen2Unit Length 2 - UoM for Purchasing Int 6 -      
BVolume Volume - Purchasing Unit Num 19.6 -      
BVolUnit Volume - UoM for Purchasing Int 6 -      
BWeight1 Weight 1 - Purchasing Unit Num 19.6 -      
BWght1Unit Weight 1 - UoM for Purchasing Int 6 -      
BWeight2 Weight 2 - Purchasing Unit Num 19.6 -      
BWght2Unit Weight 2 - UoM for Purchasing Int 6 -      
FixCurrCms Currency of Fixed Commission nVarChar 3 -      
FirmCode Manufacturer Int 6 OMRC -1    
LstSalDate Last Sale Date Date 8 -      
QryGroup1 Property 1 VarChar 1 - N Y Yes
            N No
QryGroup2 Property 2 VarChar 1 - N Y Yes
            N No
QryGroup3 Property 3 VarChar 1 - N Y Yes
            N No
QryGroup4 Property 4 VarChar 1 - N Y Yes
            N No
QryGroup5 Property 5 VarChar 1 - N Y Yes
            N No
QryGroup6 Property 6 VarChar 1 - N Y Yes
            N No
QryGroup7 Property 7 VarChar 1 - N Y Yes
            N No
QryGroup8 Property 8 VarChar 1 - N Y Yes
            N No
QryGroup9 Property 9 VarChar 1 - N Y Yes
            N No
QryGroup10 Property 10 VarChar 1 - N Y Yes
            N No
QryGroup11 Property 11 VarChar 1 - N Y Yes
            N No
QryGroup12 Property 12 VarChar 1 - N Y Yes
            N No
QryGroup13 Property 13 VarChar 1 - N Y Yes
            N No
QryGroup14 Property 14 VarChar 1 - N Y Yes
            N No
QryGroup15 Property 15 VarChar 1 - N Y Yes
            N No
QryGroup16 Property 16 VarChar 1 - N Y Yes
            N No
QryGroup17 Property 17 VarChar 1 - N Y Yes
            N No
QryGroup18 Property 18 VarChar 1 - N Y Yes
            N No
QryGroup19 Property 19 VarChar 1 - N Y Yes
            N No
QryGroup20 Property 20 VarChar 1 - N Y Yes
            N No
QryGroup21 Property 21 VarChar 1 - N Y Yes
            N No
QryGroup22 Property 22 VarChar 1 - N Y Yes
            N No
QryGroup23 Property 23 VarChar 1 - N Y Yes
            N No
QryGroup24 Property 24 VarChar 1 - N Y Yes
            N No
QryGroup25 Property 25 VarChar 1 - N Y Yes
            N No
QryGroup26 Property 26 VarChar 1 - N Y Yes
            N No
QryGroup27 Property 27 VarChar 1 - N Y Yes
            N No
QryGroup28 Property 28 VarChar 1 - N Y Yes
            N No
QryGroup29 Property 29 VarChar 1 - N Y Yes
            N No
QryGroup30 Property 30 VarChar 1 - N Y Yes
            N No
QryGroup31 Property 31 VarChar 1 - N Y Yes
            N No
QryGroup32 Property 32 VarChar 1 - N Y Yes
            N No
QryGroup33 Property 33 VarChar 1 - N Y Yes
            N No
QryGroup34 Property 34 VarChar 1 - N Y Yes
            N No
QryGroup35 Property 35 VarChar 1 - N Y Yes
            N No
QryGroup36 Property 36 VarChar 1 - N Y Yes
            N No
QryGroup37 Property 37 VarChar 1 - N Y Yes
            N No
QryGroup38 Property 38 VarChar 1 - N Y Yes
            N No
QryGroup39 Property 39 VarChar 1 - N Y Yes
            N No
QryGroup40 Property 40 VarChar 1 - N Y Yes
            N No
QryGroup41 Property 41 VarChar 1 - N Y Yes
            N No
QryGroup42 Property 42 VarChar 1 - N Y Yes
            N No
QryGroup43 Property 43 VarChar 1 - N Y Yes
            N No
QryGroup44 Property 44 VarChar 1 - N Y Yes
            N No
QryGroup45 Property 45 VarChar 1 - N Y Yes
            N No
QryGroup46 Property 46 VarChar 1 - N Y Yes
            N No
QryGroup47 Property 47 VarChar 1 - N Y Yes
            N No
QryGroup48 Property 48 VarChar 1 - N Y Yes
            N No
QryGroup49 Property 49 VarChar 1 - N Y Yes
            N No
QryGroup50 Property 50 VarChar 1 - N Y Yes
            N No
QryGroup51 Property 51 VarChar 1 - N Y Yes
            N No
QryGroup52 Property 52 VarChar 1 - N Y Yes
            N No
QryGroup53 Property 53 VarChar 1 - N Y Yes
            N No
QryGroup54 Property 54 VarChar 1 - N Y Yes
            N No
QryGroup55 Property 55 VarChar 1 - N Y Yes
            N No
QryGroup56 Property 56 VarChar 1 - N Y Yes
            N No
QryGroup57 Property 57 VarChar 1 - N Y Yes
            N No
QryGroup58 Property 58 VarChar 1 - N Y Yes
            N No
QryGroup59 Property 59 VarChar 1 - N Y Yes
            N No
QryGroup60 Property 60 VarChar 1 - N Y Yes
            N No
QryGroup61 Property 61 VarChar 1 - N Y Yes
            N No
QryGroup62 Property 62 VarChar 1 - N Y Yes
            N No
QryGroup63 Property 63 VarChar 1 - N Y Yes
            N No
QryGroup64 Property 64 VarChar 1 - N Y Yes
            N No
CreateDate Production Date Date 8 -      
UpdateDate Date of Update Date 8 -      
ExportCode Data Export Code nVarChar 20 -      
SalFactor1 Sales Factor 1 Num 19.6 -      
SalFactor2 Sales Factor 2 Num 19.6 -      
SalFactor3 Sales Factor 3 Num 19.6 -      
SalFactor4 Sales Factor 4 Num 19.6 -      
PurFactor1 Purchasing Factor 1 Num 19.6 -      
PurFactor2 Purchasing Factor 2 Num 19.6 -      
PurFactor3 Purchasing Factor 3 Num 19.6 -      
PurFactor4 Purchasing Factor 4 Num 19.6 -      
SalFormula Sales Formula nVarChar 40 -      
PurFormula Purchasing Formula nVarChar 40 -      
VatGroupPu Purchasing Tax Definition nVarChar 8 OVTG      
AvgPrice Item Cost Num 19.6 -      
PurPackMsr Packaging UoM (Purchasing) nVarChar 30 - Box    
PurPackUn Quantity per Package (Purchasing) Num 19.6 -      
SalPackMsr Packaging UoM (Sales) nVarChar 30 - Box    
SalPackUn Quantity per Package (Sales) Num 19.6 -      
SCNCounter SCN Counter Int 6 -      
ManBtchNum Manage Batch No. [Yes/No] VarChar 1 - N Y Yes
            N No
ManOutOnly Manage SN on Release Only VarChar 1 - N Y Yes
            N No
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
            G Fixed Assets Migration
validFor Active VarChar 1 - N Y Yes
            N No
validFrom Active From Date 8 -      
validTo Active To Date 8 -      
frozenFor Inactive VarChar 1 - N Y Yes
            N No
frozenFrom Inactive From Date 8 -      
frozenTo Inactive To Date 8 -      
BlockOut Force Selection of Serial No. or Batch No. VarChar 1 - Y Y Yes
            N No
ValidComm Active Remarks nVarChar 30 -      
FrozenComm Inactive Remarks nVarChar 30 -      
LogInstanc Log Instance Int 11 - 0    
ObjType Object Type nVarChar 20 ADP1      
SWW Additional Identifier nVarChar 16 -      
Deleted Deleted VarChar 1 - N Y Yes
            N No
DocEntry Numerator Int 11 -      
ExpensAcct Expense Account nVarChar 15 OACT      
FrgnInAcct Revenue Account - Foreign nVarChar 15 OACT      
ShipType Shipping Type Int 6 OSHP      
GLMethod Set G/L Accounts By VarChar 1 - W W Warehouse
            C Item Group
            L Item Level
ECInAcct Revenue Account - EU nVarChar 15 -      
FrgnExpAcc Expense Account - Foreign nVarChar 15 -      
ECExpAcc Expense Account - EU nVarChar 15 -      
TaxType Tax Type VarChar 1 - Y Y Regular Tax
            U Use Tax
            N No Tax
ByWh Manage Inventory by Warehouse VarChar 1 -      
WTLiable Withholding Tax Liable VarChar 1 - Y Y Yes
            N No
ItemType Item Type VarChar 1 - I I Items
            L Labor
            T Travel
            F Fixed Assets
WarrntTmpl Warranty Template nVarChar 20 OCTT      
BaseUnit Base Unit Name nVarChar 20 -      
CountryOrg Country/Region of Origin nVarChar 3 -      
StockValue Inventory Value Num 19.6 -      
Phantom Phantom Item VarChar 1 - N Y Yes
            N No
IssueMthd Issue Method VarChar 1 - B B Backflush
            M Manual
FREE1 Yield in % VarChar 1 -      
PricingPrc Pricing Percentage Num 19.6 -      
MngMethod Management Method VarChar 1 - R A On Every Transaction
            R On Release Only
ReorderPnt Reorder Point Num 19.6 -      
InvntryUom Inventory UoM nVarChar 100 -      
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 -      
IndirctTax Indirect Tax VarChar 1 - N Y Yes
            N No
TaxCodeAR Sales Tax Code nVarChar 8 OSTC      
TaxCodeAP Purchasing Tax Code nVarChar 8 OSTC      
OSvcCode Outgoing Service Code Int 11 OSCD      
ISvcCode Incoming Service Code Int 11 OSCD      
ServiceGrp Service Group Int 11 OSGP      
NCMCode NCM Code Int 11 ONCM      
MatType Material Type nVarChar 3 OMTP 1    
MatGrp Material Group Int 11 OMGP -1    
ProductSrc Product Source nVarChar 2 OPSC 0    
ServiceCtg Service Category Int 11 OSCG -1 -1  
ItemClass Service or Material VarChar 1 - 2 2 Material
            1 Service
Excisable Excisable [Yes/No] VarChar 1 - N Y Yes
            N No
ChapterID Chapter ID Int 11 OCHP -1    
NotifyASN Notification Availed SN. nVarChar 40 -      
ProAssNum Provisional Assessment No. nVarChar 20 -      
AssblValue Assessable Value Num 19.6 -      
DNFEntry DNF Code Entry Int 11 ODNF -1    
UserSign2 Updating User Int 6 OUSR      
Spec Item Specification nVarChar 30 -      
TaxCtg Tax Category nVarChar 4 -      
Series Series Int 11 NNM1      
Number Number Int 11 -      
FuelCode Fuel Int 11 OBFI -1    
BeverTblC Beverage Table nVarChar 2 OBSI      
BeverGrpC Beverage Group nVarChar 2 OBSI      
BeverTM Beverage Brand Int 11 OBNI -1    
Attachment Attachment Text 16 -      
AtcEntry Attachment Entry Int 11 -      
ToleranDay Tolerance Days Int 11 -      
UgpEntry UoM Group Int 11 OUGP      
PUoMEntry Default Purchasing UoM Int 11 OUOM      
SUoMEntry Default Sales UoM Int 11 OUOM      
IUoMEntry Inventory UoM Int 11 OUOM      
IssuePriBy Issue Primarily By SnB or Bin Int 6 -   0 Issue Primarily by Serial/Batch Number
            1 Issue Primarily by Bin Location
AssetClass Asset Class nVarChar 20 OACS      
AssetGroup Asset Group nVarChar 15 OAGS      
InventryNo Inventory Number of Asset nVarChar 12 -      
Technician Technician of Fixed Asset Int 11 OHEM      
Employee Employee of Fixed Asset Int 11 OHEM      
Location Location Int 11 OLCT      
StatAsset Owned by Company VarChar 1 - N Y Yes
            N No
Cession Cession VarChar 1 - N Y Yes
            N No
DeacAftUL Deactivate After Useful Life VarChar 1 - N Y Yes
            N No
AsstStatus Asset Status VarChar 1 - N N New
            A Active
            I Inactive
CapDate Capitalization Date Date 8 -      
AcqDate Acquisition Date Date 8 -      
RetDate Retirement Date Date 8 -      
GLPickMeth G/L Account Pick Method VarChar 1 - A A General
            W Warehouse
            C Item Group
NoDiscount No Discounts VarChar 1 - N Y Yes
            N No
MgrByQty Manage Asset by Quantity VarChar 1 - N Y Yes
            N No
AssetRmk1 Asset Remark 1 nVarChar 100 -      
AssetRmk2 Asset Remark 2 nVarChar 100 -      
AssetAmnt1 Asset Amount 1 Num 19.6 -      
AssetAmnt2 Asset Amount 2 Num 19.6 -      
DeprGroup Depreciation Group nVarChar 15 OADG      
AssetSerNo Asset Serial Number nVarChar 32 -      
CntUnitMsr Inventory Counting UoM Name nVarChar 100 -      
NumInCnt No. of Items per Counting Unit Num 19.6 -      
INUoMEntry Inventory Counting UoM Entry Int 11 OUOM      
OneBOneRec One Batch One Receipt VarChar 1 - N Y Yes
            N No
RuleCode Checking Rule Code nVarChar 2 ODCR      
ScsCode Scs Code nVarChar 10 -      
SpProdType Special Product Type nVarChar 2 -   MT Cellular Phones
            IO Integrated Circuits
IWeight1 Weight 1 - Inventory Num 19.6 -      
IWght1Unit Weight 1 - Inventory Unit Int 6 -      
IWeight2 Weight 2 - Inventory Num 19.6 -      
IWght2Unit Weight 2 - Inventory Unit Int 6 -      
CompoWH Component Warehouse VarChar 1 - B B From Bill of Materials Line
            P From Parent Item Document Line
CreateTS Creatn Time - Incl. Secs Int 11 -      
UpdateTS Update Full Time Int 11 -      
VirtAstItm Virtual Asset Item VarChar 1 - N N No
            Y Yes
SouVirAsst Source Virtual Asset Item nVarChar 50 OITM      
InCostRoll Include in Prod. Cost Rollup VarChar 1 - Y Y Yes
            N No
PrdStdCst Production Std Cost Num 19.6 -      
EnAstSeri Enforce Asset Serial Numbers VarChar 1 - N Y Yes
            N No
LinkRsc Linked Resource nVarChar 50 ORSC      
OnHldPert Capital Goods On Hold Percent Num 19.6 -      
onHldLimt Capital Goods on Hold Limit Num 19.6 -      
PriceUnit Pricing Unit Int 11 OUOM      
GSTRelevnt GST Relevant VarChar 1 - N Y Yes
            N No
SACEntry SAC Entry Int 11 OSAC -1    
GstTaxCtg GST Tax Category VarChar 1 - R R Regular
            N Nil Rated
            E Exempt
AssVal4WTR Assessable Value for WTR Num 19.6 -      
ExcImpQUoM Default Excise Imported Quantity UoM Int 11 -      
            112 Liters, m3
            168 Tonne, metric ton (1000 kg)
            251 Horsepower (1 hp = 0.75 kW)
            831 Liters of anhydrous (pure) alcohol
ExcFixAmnt Default Excise Fixed Amount Num 19.6 -      
ExcRate Default Excise Rate Num 19.6 -      
SOIExc SOI Excisable VarChar 1 - 4 1 Excisable
            2 Exemption of excises
            3 Excises are paid to another authority
            4 Not Excisable
TNVED TNVED Code nVarChar 10 -      
Imported Imported Item VarChar 1 - N Y Yes
            N No
AutoBatch Automatic Batch Creation VarChar 1 - N Y Yes
            N No
CstmActing Customer Accounting VarChar 1 - N N No
            Y Yes
StdItemId Standard Item Identification Int 11 OUNCL      
CommClass Commodity Classification Int 11 OUNCL      
TaxCatCode Tax Category Code for GTS nVarChar 50 OTCC      
DataVers Data Version Int 11 - 1    
NVECode NVE Code nVarChar 6 -      
CESTCode CEST Code Int 11 OCEST -1    
CtrSealQty Control Seal Qty Num 19.6 -      
LegalText Legal Text nVarChar 250 -      
QRCodeSrc QR Code Source Text 16 -      
Traceable Traceable VarChar 1 - N Y Yes
            N No
IfrsPsRev IFRS Posting for Revaluation VarChar 1 - N N No
            Y Yes
PlPaTaxCat Plastic Packaging Tax Category nVarChar 2 -      
PlPaWght Plastic Packaging Weight Num 19.6 -      
PPTExReSa Plastic Packaging Tax Exemption Reason for A/P or A/R nVarChar 2 -      
PPTExRePr Plastic Package Tax Exemption Reason for Production nVarChar 2 -      
ProdctType SAF-T Product Type VarChar 1 - P P Products
            S Services
            O Other
            I Taxes
ProdTypeEx SAF-T Product Type nVarChar 10 OSPT P    
SalUomNum Sales UoM Numerator Num 19.6 -      
SalUomDen Sales UoM Denominator Num 19.6 -      
BuyUomNum Buy UoM Numerator Num 19.6 -      
BuyUomDen Buy UoM Denominator Num 19.6 -      
IncUomNum Counting UoM Numerator Num 19.6 -      
IncUomDen Counting UoM Denominator Num 19.6 -      
NoApDisc Do Not Apply Discount VarChar 1 - N Y Yes
            N No
Key Unique Field
PRIMARY Yes ItemCode
    LogInstanc
ITEM_NAME No ItemName
TREE_TYPE No TreeType
COM_GROUP No CommisGrp
SALE No SellItem
PURCHASE No PrchseItem
INVENTORY No InvntItem