SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OPCH386A/P Invoice

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
Inventory and Production
ProductVersionTableColumnsIndexesDescriptionModule
1Business One9.3AITM3227Items - HistoryInventory and Production
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT ItemCode, ItemName, FrgnName, ItmsGrpCod, CstGrpCode, VatGourpSa, CodeBars, VATLiable, PrchseItem, SellItem, InvntItem, OnHand, IsCommited, OnOrder, IncomeAcct, ExmptIncom, MaxLevel, DfltWH, CardCode, SuppCatNum, BuyUnitMsr, NumInBuy, ReorderQty, MinLevel, LstEvlPric, LstEvlDate, CustomPer, Canceled, MnufctTime, WholSlsTax, RetilrTax, SpcialDisc, DscountCod, TrackSales, SalUnitMsr, NumInSale, Consig, QueryGroup, Counted, OpenBlnc, EvalSystem, UserSign, FREE, PicturName, Transfered, BlncTrnsfr, UserText, SerialNum, CommisPcnt, CommisSum, CommisGrp, TreeType, TreeQty, LastPurPrc, LastPurCur, LastPurDat, ExitCur, ExitPrice, ExitWH, AssetItem, WasCounted, ManSerNum, SHeight1, SHght1Unit, SHeight2, SHght2Unit, SWidth1, SWdth1Unit, SWidth2, SWdth2Unit, SLength1, SLen1Unit, Slength2, SLen2Unit, SVolume, SVolUnit, SWeight1, SWght1Unit, SWeight2, SWght2Unit, BHeight1, BHght1Unit, BHeight2, BHght2Unit, BWidth1, BWdth1Unit, BWidth2, BWdth2Unit, BLength1, BLen1Unit, Blength2, BLen2Unit, BVolume, BVolUnit, BWeight1, BWght1Unit, BWeight2, BWght2Unit, FixCurrCms, FirmCode, LstSalDate, QryGroup1, QryGroup2, QryGroup3, QryGroup4, QryGroup5, QryGroup6, QryGroup7, QryGroup8, QryGroup9, QryGroup10, QryGroup11, QryGroup12, QryGroup13, QryGroup14, QryGroup15, QryGroup16, QryGroup17, QryGroup18, QryGroup19, QryGroup20, QryGroup21, QryGroup22, QryGroup23, QryGroup24, QryGroup25, QryGroup26, QryGroup27, QryGroup28, QryGroup29, QryGroup30, QryGroup31, QryGroup32, QryGroup33, QryGroup34, QryGroup35, QryGroup36, QryGroup37, QryGroup38, QryGroup39, QryGroup40, QryGroup41, QryGroup42, QryGroup43, QryGroup44, QryGroup45, QryGroup46, QryGroup47, QryGroup48, QryGroup49, QryGroup50, QryGroup51, QryGroup52, QryGroup53, QryGroup54, QryGroup55, QryGroup56, QryGroup57, QryGroup58, QryGroup59, QryGroup60, QryGroup61, QryGroup62, QryGroup63, QryGroup64, CreateDate, UpdateDate, ExportCode, SalFactor1, SalFactor2, SalFactor3, SalFactor4, PurFactor1, PurFactor2, PurFactor3, PurFactor4, SalFormula, PurFormula, VatGroupPu, AvgPrice, PurPackMsr, PurPackUn, SalPackMsr, SalPackUn, SCNCounter, ManBtchNum, ManOutOnly, DataSource, validFor, validFrom, validTo, frozenFor, frozenFrom, frozenTo, BlockOut, ValidComm, FrozenComm, LogInstanc, ObjType, SWW, Deleted, DocEntry, ExpensAcct, FrgnInAcct, ShipType, GLMethod, ECInAcct, FrgnExpAcc, ECExpAcc, TaxType, ByWh, WTLiable, ItemType, WarrntTmpl, BaseUnit, CountryOrg, StockValue, Phantom, IssueMthd, FREE1, PricingPrc, MngMethod, ReorderPnt, InvntryUom, PlaningSys, PrcrmntMtd, OrdrIntrvl, OrdrMulti, MinOrdrQty, LeadTime, IndirctTax, TaxCodeAR, TaxCodeAP, OSvcCode, ISvcCode, ServiceGrp, NCMCode, MatType, MatGrp, ProductSrc, ServiceCtg, ItemClass, Excisable, ChapterID, NotifyASN, ProAssNum, AssblValue, DNFEntry, UserSign2, Spec, TaxCtg, Series, Number, FuelCode, BeverTblC, BeverGrpC, BeverTM, Attachment, AtcEntry, ToleranDay, UgpEntry, PUoMEntry, SUoMEntry, IUoMEntry, IssuePriBy, AssetClass, AssetGroup, InventryNo, Technician, Employee, Location, StatAsset, Cession, DeacAftUL, AsstStatus, CapDate, AcqDate, RetDate, GLPickMeth, NoDiscount, MgrByQty, AssetRmk1, AssetRmk2, AssetAmnt1, AssetAmnt2, DeprGroup, AssetSerNo, CntUnitMsr, NumInCnt, INUoMEntry, OneBOneRec, RuleCode, ScsCode, SpProdType, IWeight1, IWght1Unit, IWeight2, IWght2Unit, CompoWH, CreateTS, UpdateTS, VirtAstItm, SouVirAsst, InCostRoll, PrdStdCst, EnAstSeri, LinkRsc, OnHldPert, onHldLimt, PriceUnit, GSTRelevnt, SACEntry, GstTaxCtg, AssVal4WTR, ExcImpQUoM, ExcFixAmnt, ExcRate, SOIExc, TNVED, Imported, AutoBatch, CstmActing FROM AITM

TOPB1 9.3  | AITM COLUMNS

ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1ItemCodeItem Numbernvarchar500 Allow NULL? 
2ItemNameItem Descriptionnvarchar1000 Allow NULL? 
3FrgnNameForeign Namenvarchar1000 Allow NULL? 
4ItmsGrpCodItem Groupint60OITB100 Allow NULL? 
5CstGrpCodeCustoms Groupint60OARG-1 Allow NULL? 
6VatGourpSaTax Definitionnvarchar80OVTG Allow NULL? 
7CodeBarsBar Codenvarchar2540 Allow NULL? 
8VATLiableTax Liablechar10YN=No, Y=Yes Allow NULL? 
9PrchseItemPurchase Itemchar10YN=No, Y=Yes Allow NULL? 
10SellItemSales Itemchar10YN=No, Y=Yes Allow NULL? 
11InvntItemInventory Itemchar10YN=No, Y=Yes Allow NULL? 
12OnHandIn Stocknum196 Allow NULL? 
13IsCommitedQty Ordered by Customersnum196 Allow NULL? 
14OnOrderQty Ordered from Vendorsnum196 Allow NULL? 
15IncomeAcctRevenue Accountnvarchar150OACT Allow NULL? 
16ExmptIncomExempt Revenue Accountnvarchar150OACT Allow NULL? 
17MaxLevelFree1num196 Allow NULL? 
18DfltWHDefault Whsenvarchar80 Allow NULL? 
19CardCodePreferred Vendornvarchar150OCRD Allow NULL? 
20SuppCatNumMfr Catalog No.nvarchar500 Allow NULL? 
21BuyUnitMsrPurchasing UoMnvarchar1000Unit Allow NULL? 
22NumInBuyNo. of Items per Purchase Unitnum196 Allow NULL? 
23ReorderQtyRequired (Purchasing UoM)num196 Allow NULL? 
24MinLevelMinimum Inventory Levelnum196 Allow NULL? 
25LstEvlPricLast Evaluated Pricenum196 Allow NULL? 
26LstEvlDateDate of Last Revaluation Pricedate80
27CustomPerCustoms Ratenum196 Allow NULL? 
28CanceledCanceled Item [Yes/No]char10NN=No, Y=Yes Allow NULL? 
29MnufctTimeProduction Dateint110 Allow NULL? 
30WholSlsTaxTax Rate for Wholesalerchar10 Allow NULL? 
31RetilrTaxSales Tax %char10 Allow NULL? 
32SpcialDiscSpecial Discount %num196 Allow NULL? 
33DscountCodDiscount Codeint60 Allow NULL? 
34TrackSalesFollow-Up [Yes/No]char10NN=No, Y=Yes Allow NULL? 
35SalUnitMsrSales UoMnvarchar1000Unit Allow NULL? 
36NumInSaleNo. of Items per Sales Unitnum196 Allow NULL? 
37ConsigConsignment Goods Whsenum196 Allow NULL? 
38QueryGroupPropertiesint1100 Allow NULL? 
39CountedCounted Qtynum196 Allow NULL? 
40OpenBlncOpening Stocknum196 Allow NULL? 
41EvalSystemValuation Methodchar10A=Moving Average, B=Serial/Batch, F=FIFO, S=Standard Allow NULL? 
42UserSignUser Signatureint60OUSR Allow NULL? 
43FREEFree Item [Y/N]char10NN=No, Y=Yes Allow NULL? 
44PicturNamePicturenvarchar2000 Allow NULL? 
45TransferedYear Transferred [Y/N]char10NN=No, Y=Yes Allow NULL? 
46BlncTrnsfrBalances Transferred [Y/N]char10NN=No, Y=Yes Allow NULL? 
47UserTextItem Remarkstext160
48SerialNumSerial Numbernvarchar170 Allow NULL? 
49CommisPcntCommission % for Itemnum196 Allow NULL? 
50CommisSumTotal Commission for Itemnum196 Allow NULL? 
51CommisGrpCommission Groupint60OCOG0 Allow NULL? 
52TreeTypeBill of Materials Typechar10NA=Assembly, N=Not a BOM, P=Production, S=Sales, T=Template Allow NULL? 
53TreeQtyNo. of Unitsnum196 Allow NULL? 
54LastPurPrcLast Purchase Pricenum196 Allow NULL? 
55LastPurCurLast Purchase Currencynvarchar30 Allow NULL? 
56LastPurDatLast Purchase Datedate80
57ExitCurRelease Currencynvarchar30 Allow NULL? 
58ExitPriceRelease Pricenum196 Allow NULL? 
59ExitWHRelease Warehousenvarchar80 Allow NULL? 
60AssetItemFixed Asset Indicatorchar10NN=No, Y=Yes Allow NULL? 
61WasCountedCountedchar10NN=No, Y=Yes Allow NULL? 
62ManSerNumSerial No. Managementchar10NN=No, Y=Yes Allow NULL? 
63SHeight1Height 1 - Sales Unitnum196 Allow NULL? 
64SHght1UnitHeight 1 - UoM for Salesint60 Allow NULL? 
65SHeight2Height 2 - Sales Unitnum196 Allow NULL? 
66SHght2UnitHeight 2 - UoM for Salesint60 Allow NULL? 
67SWidth1Width 1 - Sales Unitnum196 Allow NULL? 
68SWdth1UnitWidth 1 - UoM for Salesint60 Allow NULL? 
69SWidth2Width 2 - Sales Unitnum196 Allow NULL? 
70SWdth2UnitWidth 2 - UoM for Salesint60 Allow NULL? 
71SLength1Length 1 - Sales Unitnum196 Allow NULL? 
72SLen1UnitLength 1 - UoM for Salesint60 Allow NULL? 
73Slength2Length 2 - Sales Unitnum196 Allow NULL? 
74SLen2UnitLength 2 - UoM for Salesint60 Allow NULL? 
75SVolumeVolume - Sales Unitnum196 Allow NULL? 
76SVolUnitVolume - UoM for Salesint60 Allow NULL? 
77SWeight1Weight 1 - Sales Unitnum196 Allow NULL? 
78SWght1UnitWeight 1 - UoM for Salesint60 Allow NULL? 
79SWeight2Weight 2 - Sales Unitnum196 Allow NULL? 
80SWght2UnitWeight 2 - UoM for Salesint60 Allow NULL? 
81BHeight1Height 1 - Purchasing Unitnum196 Allow NULL? 
82BHght1UnitHeight 1 - UoM for Purchasingint60 Allow NULL? 
83BHeight2Height 2 - Purchasing Unitnum196 Allow NULL? 
84BHght2UnitHeight 2 - UoM for Purchasingint60 Allow NULL? 
85BWidth1Width 1 - Purchasing Unitnum196 Allow NULL? 
86BWdth1UnitWidth 1 - UoM for Purchasingint60 Allow NULL? 
87BWidth2Width 2 - Purchasing Unitnum196 Allow NULL? 
88BWdth2UnitWidth 2 - UoM for Purchasingint60 Allow NULL? 
89BLength1Length 1 - Purchase Unitnum196 Allow NULL? 
90BLen1UnitLength 1 - UoM for Purchasingint60 Allow NULL? 
91Blength2Length 2 - Purchase Unitnum196 Allow NULL? 
92BLen2UnitLength 2 - UoM for Purchasingint60 Allow NULL? 
93BVolumeVolume - Purchasing Unitnum196 Allow NULL? 
94BVolUnitVolume - UoM for Purchasingint60 Allow NULL? 
95BWeight1Weight 1 - Purchasing Unitnum196 Allow NULL? 
96BWght1UnitWeight 1 - UoM for Purchasingint60 Allow NULL? 
97BWeight2Weight 2 - Purchasing Unitnum196 Allow NULL? 
98BWght2UnitWeight 2 - UoM for Purchasingint60 Allow NULL? 
99FixCurrCmsCurrency of Fixed Commissionnvarchar30 Allow NULL? 
100FirmCodeManufacturerint60OMRC-1 Allow NULL? 
101LstSalDateLast Sale Datedate80
102QryGroup1Property 1char10NN=No, Y=Yes Allow NULL? 
103QryGroup2Property 2char10NN=No, Y=Yes Allow NULL? 
104QryGroup3Property 3char10NN=No, Y=Yes Allow NULL? 
105QryGroup4Property 4char10NN=No, Y=Yes Allow NULL? 
106QryGroup5Property 5char10NN=No, Y=Yes Allow NULL? 
107QryGroup6Property 6char10NN=No, Y=Yes Allow NULL? 
108QryGroup7Property 7char10NN=No, Y=Yes Allow NULL? 
109QryGroup8Property 8char10NN=No, Y=Yes Allow NULL? 
110QryGroup9Property 9char10NN=No, Y=Yes Allow NULL? 
111QryGroup10Property 10char10NN=No, Y=Yes Allow NULL? 
112QryGroup11Property 11char10NN=No, Y=Yes Allow NULL? 
113QryGroup12Property 12char10NN=No, Y=Yes Allow NULL? 
114QryGroup13Property 13char10NN=No, Y=Yes Allow NULL? 
115QryGroup14Property 14char10NN=No, Y=Yes Allow NULL? 
116QryGroup15Property 15char10NN=No, Y=Yes Allow NULL? 
117QryGroup16Property 16char10NN=No, Y=Yes Allow NULL? 
118QryGroup17Property 17char10NN=No, Y=Yes Allow NULL? 
119QryGroup18Property 18char10NN=No, Y=Yes Allow NULL? 
120QryGroup19Property 19char10NN=No, Y=Yes Allow NULL? 
121QryGroup20Property 20char10NN=No, Y=Yes Allow NULL? 
122QryGroup21Property 21char10NN=No, Y=Yes Allow NULL? 
123QryGroup22Property 22char10NN=No, Y=Yes Allow NULL? 
124QryGroup23Property 23char10NN=No, Y=Yes Allow NULL? 
125QryGroup24Property 24char10NN=No, Y=Yes Allow NULL? 
126QryGroup25Property 25char10NN=No, Y=Yes Allow NULL? 
127QryGroup26Property 26char10NN=No, Y=Yes Allow NULL? 
128QryGroup27Property 27char10NN=No, Y=Yes Allow NULL? 
129QryGroup28Property 28char10NN=No, Y=Yes Allow NULL? 
130QryGroup29Property 29char10NN=No, Y=Yes Allow NULL? 
131QryGroup30Property 30char10NN=No, Y=Yes Allow NULL? 
132QryGroup31Property 31char10NN=No, Y=Yes Allow NULL? 
133QryGroup32Property 32char10NN=No, Y=Yes Allow NULL? 
134QryGroup33Property 33char10NN=No, Y=Yes Allow NULL? 
135QryGroup34Property 34char10NN=No, Y=Yes Allow NULL? 
136QryGroup35Property 35char10NN=No, Y=Yes Allow NULL? 
137QryGroup36Property 36char10NN=No, Y=Yes Allow NULL? 
138QryGroup37Property 37char10NN=No, Y=Yes Allow NULL? 
139QryGroup38Property 38char10NN=No, Y=Yes Allow NULL? 
140QryGroup39Property 39char10NN=No, Y=Yes Allow NULL? 
141QryGroup40Property 40char10NN=No, Y=Yes Allow NULL? 
142QryGroup41Property 41char10NN=No, Y=Yes Allow NULL? 
143QryGroup42Property 42char10NN=No, Y=Yes Allow NULL? 
144QryGroup43Property 43char10NN=No, Y=Yes Allow NULL? 
145QryGroup44Property 44char10NN=No, Y=Yes Allow NULL? 
146QryGroup45Property 45char10NN=No, Y=Yes Allow NULL? 
147QryGroup46Property 46char10NN=No, Y=Yes Allow NULL? 
148QryGroup47Property 47char10NN=No, Y=Yes Allow NULL? 
149QryGroup48Property 48char10NN=No, Y=Yes Allow NULL? 
150QryGroup49Property 49char10NN=No, Y=Yes Allow NULL? 
151QryGroup50Property 50char10NN=No, Y=Yes Allow NULL? 
152QryGroup51Property 51char10NN=No, Y=Yes Allow NULL? 
153QryGroup52Property 52char10NN=No, Y=Yes Allow NULL? 
154QryGroup53Property 53char10NN=No, Y=Yes Allow NULL? 
155QryGroup54Property 54char10NN=No, Y=Yes Allow NULL? 
156QryGroup55Property 55char10NN=No, Y=Yes Allow NULL? 
157QryGroup56Property 56char10NN=No, Y=Yes Allow NULL? 
158QryGroup57Property 57char10NN=No, Y=Yes Allow NULL? 
159QryGroup58Property 58char10NN=No, Y=Yes Allow NULL? 
160QryGroup59Property 59char10NN=No, Y=Yes Allow NULL? 
161QryGroup60Property 60char10NN=No, Y=Yes Allow NULL? 
162QryGroup61Property 61char10NN=No, Y=Yes Allow NULL? 
163QryGroup62Property 62char10NN=No, Y=Yes Allow NULL? 
164QryGroup63Property 63char10NN=No, Y=Yes Allow NULL? 
165QryGroup64Property 64char10NN=No, Y=Yes Allow NULL? 
166CreateDateProduction Datedate80
167UpdateDateDate of Updatedate80
168ExportCodeData Export Codenvarchar200 Allow NULL? 
169SalFactor1Sales Factor 1num196 Allow NULL? 
170SalFactor2Sales Factor 2num196 Allow NULL? 
171SalFactor3Sales Factor 3num196 Allow NULL? 
172SalFactor4Sales Factor 4num196 Allow NULL? 
173PurFactor1Purchasing Factor 1num196 Allow NULL? 
174PurFactor2Purchasing Factor 2num196 Allow NULL? 
175PurFactor3Purchasing Factor 3num196 Allow NULL? 
176PurFactor4Purchasing Factor 4num196 Allow NULL? 
177SalFormulaSales Formulanvarchar400 Allow NULL? 
178PurFormulaPurchasing Formulanvarchar400 Allow NULL? 
179VatGroupPuTax Definitionnvarchar80OVTG Allow NULL? 
180AvgPriceItem Costnum196 Allow NULL? 
181PurPackMsrPackaging UoM (Purchasing)nvarchar300Box Allow NULL? 
182PurPackUnQuantity per Package (Purchasing)num196 Allow NULL? 
183SalPackMsrPackaging UoM (Sales)nvarchar300Box Allow NULL? 
184SalPackUnQuantity per Package (Sales)num196 Allow NULL? 
185SCNCounterSCN Counterint60 Allow NULL? 
186ManBtchNumManage Batch No. [Yes/No]char10NN=No, Y=Yes Allow NULL? 
187ManOutOnlyManage SN on Release Onlychar10NN=No, Y=Yes Allow NULL? 
188DataSourceData Sourcechar10NA=Doc. Generation Wizard, D=Restore Wizard, G=Fixed Assets Migration, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update Allow NULL? 
189validForActivechar10NN=No, Y=Yes Allow NULL? 
190validFromActive Fromdate80
191validToActive Todate80
192frozenForInactivechar10NN=No, Y=Yes Allow NULL? 
193frozenFromInactive Fromdate80
194frozenToInactive Todate80
195BlockOutForce Selection of Serial No. or Batch No.char10YN=No, Y=Yes Allow NULL? 
196ValidCommActive Remarksnvarchar300 Allow NULL? 
197FrozenCommInactive Remarksnvarchar300 Allow NULL? 
198LogInstancLog Instanceint1100 Allow NULL? 
199ObjTypeObject Typenvarchar200ADP1 Allow NULL? 
200SWWAdditional Identifiernvarchar160 Allow NULL? 
201DeletedDeletedchar10NN=No, Y=Yes Allow NULL? 
202DocEntryNumeratorint110 Allow NULL? 
203ExpensAcctExpense Accountnvarchar150OACT Allow NULL? 
204FrgnInAcctRevenue Account - Foreignnvarchar150OACT Allow NULL? 
205ShipTypeShipping Typeint60OSHP Allow NULL? 
206GLMethodSet G/L Accounts Bychar10WC=Item Group, L=Item Level, W=Warehouse Allow NULL? 
207ECInAcctRevenue Account - EUnvarchar150 Allow NULL? 
208FrgnExpAccExpense Account - Foreignnvarchar150 Allow NULL? 
209ECExpAccExpense Account - EUnvarchar150 Allow NULL? 
210TaxTypeTax Typechar10YN=No Tax, U=Use Tax, Y=Regular Tax Allow NULL? 
211ByWhManage Inventory by Warehousechar10 Allow NULL? 
212WTLiableWithholding Tax Liablechar10YN=No, Y=Yes Allow NULL? 
213ItemTypeItem Typechar10IF=Fixed Assets, I=Items, L=Labor, T=Travel Allow NULL? 
214WarrntTmplWarranty Templatenvarchar200OCTT Allow NULL? 
215BaseUnitBase Unit Namenvarchar200 Allow NULL? 
216CountryOrgCountry of Originnvarchar30 Allow NULL? 
217StockValueInventory Valuenum196 Allow NULL? 
218PhantomPhantom Itemchar10NN=No, Y=Yes Allow NULL? 
219IssueMthdIssue Methodchar10BB=Backflush, M=Manual Allow NULL? 
220FREE1Yield in %char10 Allow NULL? 
221PricingPrcPricing Percentagenum196 Allow NULL? 
222MngMethodManagement Methodchar10RA=On Every Transaction, R=On Release Only Allow NULL? 
223ReorderPntReorder Pointnum196 Allow NULL? 
224InvntryUomInventory UoMnvarchar1000 Allow NULL? 
225PlaningSysPlanning Methodchar10NM=MRP, N=None Allow NULL? 
226PrcrmntMtdProcurement Methodchar10BB=Buy, M=Make Allow NULL? 
227OrdrIntrvlOrder Intervalint60OCYC Allow NULL? 
228OrdrMultiOrder Multiplenum196 Allow NULL? 
229MinOrdrQtyMinimum Order Quantitynum196 Allow NULL? 
230LeadTimeLead Timeint110 Allow NULL? 
231IndirctTaxIndirect Taxchar10NN=No, Y=Yes Allow NULL? 
232TaxCodeARSales Tax Codenvarchar80OSTC Allow NULL? 
233TaxCodeAPPurchasing Tax Codenvarchar80OSTC Allow NULL? 
234OSvcCodeOutgoing Service Codeint110OSCD Allow NULL? 
235ISvcCodeIncoming Service Codeint110OSCD Allow NULL? 
236ServiceGrpService Groupint110OSGP Allow NULL? 
237NCMCodeNCM Codeint110ONCM Allow NULL? 
238MatTypeMaterial Typenvarchar30OMTP1 Allow NULL? 
239MatGrpMaterial Groupint110OMGP-1 Allow NULL? 
240ProductSrcProduct Sourcenvarchar20OPSC0 Allow NULL? 
241ServiceCtgService Categoryint110OSCG-1-1 Allow NULL? 
242ItemClassService or Materialchar1021=Service, 2=Material Allow NULL? 
243ExcisableExcisable [Yes/No]char10NN=No, Y=Yes Allow NULL? 
244ChapterIDChapter IDint110OCHP-1 Allow NULL? 
245NotifyASNNotification Availed SN.nvarchar400 Allow NULL? 
246ProAssNumProvisional Assessment No.nvarchar200 Allow NULL? 
247AssblValueAssessable Valuenum196 Allow NULL? 
248DNFEntryDNF Code Entryint110ODNF-1 Allow NULL? 
249UserSign2Updating Userint60OUSR Allow NULL? 
250SpecItem Specificationnvarchar300 Allow NULL? 
251TaxCtgTax Categorynvarchar40 Allow NULL? 
252SeriesSeriesint110NNM1 Allow NULL? 
253NumberNumberint110 Allow NULL? 
254FuelCodeFuelint110OBFI-1 Allow NULL? 
255BeverTblCBeverage Tablenvarchar20OBSI Allow NULL? 
256BeverGrpCBeverage Groupnvarchar20OBSI Allow NULL? 
257BeverTMBeverage Brandint110OBNI-1 Allow NULL? 
258AttachmentAttachmenttext160
259AtcEntryAttachment Entryint110 Allow NULL? 
260ToleranDayTolerance Daysint110 Allow NULL? 
261UgpEntryUoM Groupint110OUGP Allow NULL? 
262PUoMEntryDefault Purchase UoMint110OUOM Allow NULL? 
263SUoMEntryDefault Sales UoMint110OUOM Allow NULL? 
264IUoMEntryInventory UoMint110OUOM Allow NULL? 
265IssuePriByIssue Primarily By SnB or Binint600=Issue Primarily by Serial/Batch Number, 1=Issue Primarily by Bin Location Allow NULL? 
266AssetClassAsset Classnvarchar200OACS Allow NULL? 
267AssetGroupAsset Groupnvarchar150OAGS Allow NULL? 
268InventryNoInventory Number of Assetnvarchar120 Allow NULL? 
269TechnicianTechnician of Fixed Assetint110OHEM Allow NULL? 
270EmployeeEmployee of Fixed Assetint110OHEM Allow NULL? 
271LocationLocationint110OLCT Allow NULL? 
272StatAssetOwned by Companychar10NN=No, Y=Yes Allow NULL? 
273CessionCessionchar10NN=No, Y=Yes Allow NULL? 
274DeacAftULDeactivate After Useful Lifechar10NN=No, Y=Yes Allow NULL? 
275AsstStatusAsset Statuschar10NA=Active, I=Inactive, N=New Allow NULL? 
276CapDateCapitalization Datedate80
277AcqDateAcquisition Datedate80
278RetDateRetirement Datedate80
279GLPickMethG/L Account Pick Methodchar10AA=General, C=Item Group, W=Warehouse Allow NULL? 
280NoDiscountNo Discountschar10NN=No, Y=Yes Allow NULL? 
281MgrByQtyManage Asset by Quantitychar10NN=No, Y=Yes Allow NULL? 
282AssetRmk1Asset Remark 1nvarchar1000 Allow NULL? 
283AssetRmk2Asset Remark 2nvarchar1000 Allow NULL? 
284AssetAmnt1Asset Amount 1num196 Allow NULL? 
285AssetAmnt2Asset Amount 2num196 Allow NULL? 
286DeprGroupDepreciation Groupnvarchar150OADG Allow NULL? 
287AssetSerNoAsset Serial Numbernvarchar320 Allow NULL? 
288CntUnitMsrInventory Counting UoM Namenvarchar1000 Allow NULL? 
289NumInCntNo. of Items per Counting Unitnum196 Allow NULL? 
290INUoMEntryInventory Counting UoM Entryint110OUOM Allow NULL? 
291OneBOneRecOne Batch One Receiptchar10NN=No, Y=Yes Allow NULL? 
292RuleCodeChecking Rule Codenvarchar20ODCR Allow NULL? 
293ScsCodeScs Codenvarchar100 Allow NULL? 
294SpProdTypeSpecial Product Typenvarchar20IO=Integrated Circuits, MT=Cellular Phones Allow NULL? 
295IWeight1Weight 1 - Inventorynum196 Allow NULL? 
296IWght1UnitWeight 1 - Inventory Unitint60 Allow NULL? 
297IWeight2Weight 2 - Inventorynum196 Allow NULL? 
298IWght2UnitWeight 2 - Inventory Unitint60 Allow NULL? 
299CompoWHComponent Warehousechar10BB=From Bill of Materials Line, P=From Parent Item Document Line Allow NULL? 
300CreateTSCreatn Time - Incl. Secsint110 Allow NULL? 
301UpdateTSUpdate Full Timeint110 Allow NULL? 
302VirtAstItmVirtual Asset Itemchar10NN=No, Y=Yes Allow NULL? 
303SouVirAsstSource Virtual Asset Itemnvarchar500OITM Allow NULL? 
304InCostRollInclude in Prod. Cost Rollupchar10YN=No, Y=Yes Allow NULL? 
305PrdStdCstProduction Std Costnum196 Allow NULL? 
306EnAstSeriEnforce Asset Serial Numberschar10NN=No, Y=Yes Allow NULL? 
307LinkRscLinked Resourcenvarchar500ORSC Allow NULL? 
308OnHldPertCapital Goods On Hold Percentnum196 Allow NULL? 
309onHldLimtCapital Goods on Hold Limitnum196 Allow NULL? 
310PriceUnitPricing Unitint110OUOM Allow NULL? 
311GSTRelevntGST Relevantchar10NN=No, Y=Yes Allow NULL? 
312SACEntrySAC Entryint110OSAC-1 Allow NULL? 
313GstTaxCtgGST Tax Categorychar10RE=Exempt, N=Nil Rated, R=Regular Allow NULL? 
314AssVal4WTRAssessable Value for WTRnum196 Allow NULL? 
315ExcImpQUoMDefault Excise Imported Quantity UoMint110112=Liters, m3, 168=Tonne, metric ton (1000 kg), 251=Horsepower (1 hp = 0.75 kW), 831=Liters of anhydrous (pure) alcohol Allow NULL? 
316ExcFixAmntDefault Excise Fixed Amountnum196 Allow NULL? 
317ExcRateDefault Excise Ratenum196 Allow NULL? 
318SOIExcSOI Excisablechar1041=Excisable, 2=Exemption of excises, 3=Excises are paid to another authority, 4=Not Excisable Allow NULL? 
319TNVEDTNVED Codenvarchar100 Allow NULL? 
320ImportedImported Itemchar10NN=No, Y=Yes Allow NULL? 
321AutoBatchAutomatic Batch Creationchar10NN=No, Y=Yes Allow NULL? 
322CstmActingCustomer Accountingchar10NN=No, Y=Yes Allow NULL? 

TOPB1 9.3  | AITM INDEXES

NamePrimaryUniqueTypeColumns
PRIMARYNoYesItemCode, LogInstanc
ITEM_NAMENoNoItemName
TREE_TYPENoNoTreeType
COM_GROUPNoNoCommisGrp
SALENoNoSellItem
PURCHASENoNoPrchseItem
INVENTORYNoNoInvntItem