SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7OOCR9Loading Factors
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Inventory and Production
ProductVersionTableColumnsIndexesDescriptionModule
1Business One9.2OITM2997ItemsInventory 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 FROM OITM

TOPB1 9.2  | OITM COLUMNS

ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1ItemCodeItem No.nvarchar200 Allow NULL? 
2ItemNameItem Descriptionnvarchar1000 Allow NULL? 
3FrgnNameDescription in Foreign Lang.nvarchar1000 Allow NULL? 
4ItmsGrpCodItem Groupint60100 Allow NULL? 
5CstGrpCodeCustoms Groupint60-1 Allow NULL? 
6VatGourpSaSales Tax Definitionnvarchar80 Allow NULL? 
7CodeBarsBar Codenvarchar2540 Allow NULL? 
8VATLiableTax Definitionchar10YN=No, Y=Yes Allow NULL? 
9PrchseItemPurchase Item [Yes/No]char10YN=No, Y=Yes Allow NULL? 
10SellItemSales Item [Yes/No]char10YN=No, Y=Yes Allow NULL? 
11InvntItemInventory Item [Yes/No]char10YN=No, Y=Yes Allow NULL? 
12OnHandIn Stocknum196 Allow NULL? 
13IsCommitedQty Ordered by Customersnum196 Allow NULL? 
14OnOrderQty Ordered from Vendorsnum196 Allow NULL? 
15IncomeAcctRevenue Accountnvarchar150 Allow NULL? 
16ExmptIncomExempt Revenue Accountnvarchar150 Allow NULL? 
17MaxLevelMaximum Inventory Levelnum196 Allow NULL? 
18DfltWHDefault Warehousenvarchar80 Allow NULL? 
19CardCodePreferred Vendornvarchar150 Allow NULL? 
20SuppCatNumMfr Catalog No.nvarchar170 Allow NULL? 
21BuyUnitMsrPurchasing UoMnvarchar1000 Allow NULL? 
22NumInBuyNo. of Items per Purchase Unitnum196 Allow NULL? 
23ReorderQtyPref. Qty in Purchase Unitsnum196 Allow NULL? 
24MinLevelMinimum Inventory Levelnum196 Allow NULL? 
25LstEvlPricLast Evaluated Pricenum196 Allow NULL? 
26LstEvlDateDate of Last Reval. Pricedate80
27CustomPerCustoms Ratenum196 Allow NULL? 
28CanceledCanceled Item [Yes/No]char10NN=No, Y=Yes Allow NULL? 
29MnufctTimeProduction Date in Daysint110 Allow NULL? 
30WholSlsTaxTax Rate for Wholesalerchar10 Allow NULL? 
31RetilrTaxSales Tax in %char10 Allow NULL? 
32SpcialDiscSpecial Discount %num196 Allow NULL? 
33DscountCodDiscount Codeint60 Allow NULL? 
34TrackSalesFollow-Up [Yes/No]char10NN=No, Y=Yes Allow NULL? 
35SalUnitMsrSales UoMnvarchar1000 Allow NULL? 
36NumInSaleNo. of Items per Sales Unitnum196 Allow NULL? 
37ConsigConsignment Goods Whsenum196 Allow NULL? 
38QueryGroupPropertiesint1100 Allow NULL? 
39CountedQuantity Counted in Inventorynum196 Allow NULL? 
40OpenBlncInitial Stocknum196 Allow NULL? 
41EvalSystemValuation Methodchar10A=Moving Average, B=Serial/Batch, F=FIFO, S=Standard Allow NULL? 
42UserSignUser Signatureint60 Allow NULL? 
43FREEFree [Yes/No]char10NN=No, Y=Yes Allow NULL? 
44PicturNamePicturenvarchar2000 Allow NULL? 
45TransferedYear Transfer [Y/N]char10NN=No, Y=Yes Allow NULL? 
46BlncTrnsfrBalances transferred [Yes/No]char10NN=No, Y=Yes Allow NULL? 
47UserTextItem Remarkstext160
48SerialNumSerial Numbernvarchar170 Allow NULL? 
49CommisPcnt% Commission for Itemnum196 Allow NULL? 
50CommisSumTotal Commission for Itemnum196 Allow NULL? 
51CommisGrpCommission Groupint600 Allow NULL? 
52TreeTypeBOM 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
57ExitCurIssue Currencynvarchar30 Allow NULL? 
58ExitPriceIssue Pricenum196 Allow NULL? 
59ExitWHRelease Warehousenvarchar80 Allow NULL? 
60AssetItemFixed Assetschar10NN=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? 
93BVolumeQuantity - 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? 
100FirmCodeManufacturerint60-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? 
179VatGroupPuPurchase Tax Definitionnvarchar80 Allow NULL? 
180AvgPriceItem Costnum196 Allow NULL? 
181PurPackMsrPackaging UoM (Purchasing)nvarchar300 Allow NULL? 
182PurPackUnQty per Packaging (Purchasing)num196 Allow NULL? 
183SalPackMsrPackaging UoM (Sales)nvarchar300 Allow NULL? 
184SalPackUnQty per Packaging (Sales)num196 Allow NULL? 
185SCNCounterSCN Counterint60 Allow NULL? 
186ManBtchNumManage Batch No. [Yes/No]char10NN=No, Y=Yes Allow NULL? 
187ManOutOnlyManage SN Only on Exitchar10NN=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.char10YN=No, Y=Yes Allow NULL? 
196ValidCommActive Remarksnvarchar300 Allow NULL? 
197FrozenCommInactive Remarksnvarchar300 Allow NULL? 
198LogInstancLog Instanceint1100 Allow NULL? 
199ObjTypeObject Typenvarchar2004 Allow NULL? 
200SWWAdditional Identifiernvarchar160 Allow NULL? 
201DeletedDeletedchar10NN=No, Y=Yes Allow NULL? 
202DocEntryInternal Numberint110 Allow NULL? 
203ExpensAcctExpense Accountnvarchar150 Allow NULL? 
204FrgnInAcctRevenue Account - Foreignnvarchar150 Allow NULL? 
205ShipTypeShipping Typeint60 Allow NULL? 
206GLMethodSet G/L Account 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? 
211ByWhInventory Management by Whsechar10 Allow NULL? 
212WTLiableWTax Liablechar10YN=No, Y=Yes Allow NULL? 
213ItemTypeItem Typechar10IF=Fixed Assets, I=Items, L=Labor, T=Travel Allow NULL? 
214WarrntTmplWarranty Templatenvarchar200 Allow NULL? 
215BaseUnitBase Unit Namenvarchar200 Allow NULL? 
216CountryOrgCountry of Originnvarchar30 Allow NULL? 
217StockValueInventory Valuenum196 Allow NULL? 
218PhantomPhantom Itemchar10NN=No, Y=Yes Allow NULL? 
219IssueMthdIssue Methodchar10B=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 Intervalsint60 Allow NULL? 
228OrdrMultiOrder Multiplenum196 Allow NULL? 
229MinOrdrQtyMinimum Order Quantitynum196 Allow NULL? 
230LeadTimeLead Timeint110 Allow NULL? 
231IndirctTaxIndirect Taxchar10NN=No, Y=Yes Allow NULL? 
232TaxCodeARTax Code (A/R)nvarchar80 Allow NULL? 
233TaxCodeAPTax Code (A/P)nvarchar80 Allow NULL? 
234OSvcCodeOutgoing Service Codeint110-1 Allow NULL? 
235ISvcCodeIncoming Service Codeint110-1 Allow NULL? 
236ServiceGrpService Groupint110-1 Allow NULL? 
237NCMCodeNCM Codeint110-1 Allow NULL? 
238MatTypeMaterial Typenvarchar301 Allow NULL? 
239MatGrpMaterial Groupint110-1 Allow NULL? 
240ProductSrcProduct Sourcenvarchar200 Allow NULL? 
241ServiceCtgService Categoryint110-1-1 Allow NULL? 
242ItemClassService or Materialchar1021=Service, 2=Material Allow NULL? 
243ExcisableExcisable [Yes/No]char10NN=No, Y=Yes Allow NULL? 
244ChapterIDChapter IDint110-1 Allow NULL? 
245NotifyASNNotification Availed SN.nvarchar400 Allow NULL? 
246ProAssNumProvisional Assessment No.nvarchar200 Allow NULL? 
247AssblValueAssessable Valuenum196 Allow NULL? 
248DNFEntryDNF Code Entryint110-1 Allow NULL? 
249UserSign2Updating Userint60 Allow NULL? 
250SpecItem Specificationnvarchar300 Allow NULL? 
251TaxCtgTax Categorynvarchar40 Allow NULL? 
252SeriesSeriesint60 Allow NULL? 
253NumberNumberint110 Allow NULL? 
254FuelCodeFuelint110-1 Allow NULL? 
255BeverTblCBeverage Tablenvarchar20 Allow NULL? 
256BeverGrpCBeverage Groupnvarchar20 Allow NULL? 
257BeverTMBeverage Brandint110-1 Allow NULL? 
258AttachmentAttachmenttext160
259AtcEntryAttachment Entryint110 Allow NULL? 
260ToleranDayTolerance Daysint110 Allow NULL? 
261UgpEntryUoM Groupint110 Allow NULL? 
262PUoMEntryDefault Purchase UoMint110 Allow NULL? 
263SUoMEntryDefault Sales UoMint110 Allow NULL? 
264IUoMEntryInventory UoMint110 Allow NULL? 
265IssuePriByIssue Primarily By SnB or Binint600=Issue Primarily by Serial/Batch Number, 1=Issue Primarily by Bin Location Allow NULL? 
266AssetClassAsset Classnvarchar200 Allow NULL? 
267AssetGroupAsset Groupnvarchar150 Allow NULL? 
268InventryNoInventory Number of Assetnvarchar120 Allow NULL? 
269TechnicianTechnician of Fixed Assetint110 Allow NULL? 
270EmployeeEmployee of Fixed Assetint110 Allow NULL? 
271LocationLocationint110 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 Groupnvarchar150 Allow NULL? 
287AssetSerNoAsset Serial Numbernvarchar320 Allow NULL? 
288CntUnitMsrInventory Counting UoM Namenvarchar1000 Allow NULL? 
289NumInCntNo. of Items per Counting Unitnum196 Allow NULL? 
290INUoMEntryInventory Counting UoM Entryint110 Allow NULL? 
291OneBOneRecOne Batch One Receiptchar10NN=No, Y=Yes Allow NULL? 
292RuleCodeChecking Rule Codenvarchar20 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? 

TOPB1 9.2  | OITM INDEXES

NamePrimaryUniqueTypeColumns
PRIMARYNoYesItemCode
ITEM_NAMENoNoItemName
TREE_TYPENoNoTreeType
COM_GROUPNoNoCommisGrp
SALENoNoSellItem
PURCHASENoNoPrchseItem
INVENTORYNoNoInvntItem