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

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OCRD332Business Partner
3OINV386A/R Invoice
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OPOR386Purchase Order
7OJDT100Journal Entry
8OUSR101Users
9OWTR386Inventory Transfer
10OSHP5Delivery Types

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OIVL77Whse Journal
4OPCH268A/P Invoice
5OSRN20Serial Numbers Master Data
6OVPM154Outgoing Payments
7ORCT154Incoming Payment
8OOCR9Loading Factors
9OBOT10Bill Of Exchang Transaction
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool
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 Definitionchar10YY=Yes, N=No Allow NULL? 
9PrchseItemPurchase Item [Yes/No]char10YY=Yes, N=No Allow NULL? 
10SellItemSales Item [Yes/No]char10YY=Yes, N=No Allow NULL? 
11InvntItemInventory Item [Yes/No]char10YY=Yes, N=No 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]char10NY=Yes, N=No 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]char10NY=Yes, N=No 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, S=Standard, F=FIFO, B=Serial/Batch Allow NULL? 
42UserSignUser Signatureint60 Allow NULL? 
43FREEFree [Yes/No]char10NY=Yes, N=No Allow NULL? 
44PicturNamePicturenvarchar2000 Allow NULL? 
45TransferedYear Transfer [Y/N]char10NY=Yes, N=No Allow NULL? 
46BlncTrnsfrBalances transferred [Yes/No]char10NY=Yes, N=No 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 Typechar10NN=Not a BOM, A=Assembly, S=Sales, P=Production, 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 Assetschar10NY=Yes, N=No Allow NULL? 
61WasCountedCountedchar10NY=Yes, N=No Allow NULL? 
62ManSerNumSerial No. Managementchar10NY=Yes, N=No 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 1char10NY=Yes, N=No Allow NULL? 
103QryGroup2Property 2char10NY=Yes, N=No Allow NULL? 
104QryGroup3Property 3char10NY=Yes, N=No Allow NULL? 
105QryGroup4Property 4char10NY=Yes, N=No Allow NULL? 
106QryGroup5Property 5char10NY=Yes, N=No Allow NULL? 
107QryGroup6Property 6char10NY=Yes, N=No Allow NULL? 
108QryGroup7Property 7char10NY=Yes, N=No Allow NULL? 
109QryGroup8Property 8char10NY=Yes, N=No Allow NULL? 
110QryGroup9Property 9char10NY=Yes, N=No Allow NULL? 
111QryGroup10Property 10char10NY=Yes, N=No Allow NULL? 
112QryGroup11Property 11char10NY=Yes, N=No Allow NULL? 
113QryGroup12Property 12char10NY=Yes, N=No Allow NULL? 
114QryGroup13Property 13char10NY=Yes, N=No Allow NULL? 
115QryGroup14Property 14char10NY=Yes, N=No Allow NULL? 
116QryGroup15Property 15char10NY=Yes, N=No Allow NULL? 
117QryGroup16Property 16char10NY=Yes, N=No Allow NULL? 
118QryGroup17Property 17char10NY=Yes, N=No Allow NULL? 
119QryGroup18Property 18char10NY=Yes, N=No Allow NULL? 
120QryGroup19Property 19char10NY=Yes, N=No Allow NULL? 
121QryGroup20Property 20char10NY=Yes, N=No Allow NULL? 
122QryGroup21Property 21char10NY=Yes, N=No Allow NULL? 
123QryGroup22Property 22char10NY=Yes, N=No Allow NULL? 
124QryGroup23Property 23char10NY=Yes, N=No Allow NULL? 
125QryGroup24Property 24char10NY=Yes, N=No Allow NULL? 
126QryGroup25Property 25char10NY=Yes, N=No Allow NULL? 
127QryGroup26Property 26char10NY=Yes, N=No Allow NULL? 
128QryGroup27Property 27char10NY=Yes, N=No Allow NULL? 
129QryGroup28Property 28char10NY=Yes, N=No Allow NULL? 
130QryGroup29Property 29char10NY=Yes, N=No Allow NULL? 
131QryGroup30Property 30char10NY=Yes, N=No Allow NULL? 
132QryGroup31Property 31char10NY=Yes, N=No Allow NULL? 
133QryGroup32Property 32char10NY=Yes, N=No Allow NULL? 
134QryGroup33Property 33char10NY=Yes, N=No Allow NULL? 
135QryGroup34Property 34char10NY=Yes, N=No Allow NULL? 
136QryGroup35Property 35char10NY=Yes, N=No Allow NULL? 
137QryGroup36Property 36char10NY=Yes, N=No Allow NULL? 
138QryGroup37Property 37char10NY=Yes, N=No Allow NULL? 
139QryGroup38Property 38char10NY=Yes, N=No Allow NULL? 
140QryGroup39Property 39char10NY=Yes, N=No Allow NULL? 
141QryGroup40Property 40char10NY=Yes, N=No Allow NULL? 
142QryGroup41Property 41char10NY=Yes, N=No Allow NULL? 
143QryGroup42Property 42char10NY=Yes, N=No Allow NULL? 
144QryGroup43Property 43char10NY=Yes, N=No Allow NULL? 
145QryGroup44Property 44char10NY=Yes, N=No Allow NULL? 
146QryGroup45Property 45char10NY=Yes, N=No Allow NULL? 
147QryGroup46Property 46char10NY=Yes, N=No Allow NULL? 
148QryGroup47Property 47char10NY=Yes, N=No Allow NULL? 
149QryGroup48Property 48char10NY=Yes, N=No Allow NULL? 
150QryGroup49Property 49char10NY=Yes, N=No Allow NULL? 
151QryGroup50Property 50char10NY=Yes, N=No Allow NULL? 
152QryGroup51Property 51char10NY=Yes, N=No Allow NULL? 
153QryGroup52Property 52char10NY=Yes, N=No Allow NULL? 
154QryGroup53Property 53char10NY=Yes, N=No Allow NULL? 
155QryGroup54Property 54char10NY=Yes, N=No Allow NULL? 
156QryGroup55Property 55char10NY=Yes, N=No Allow NULL? 
157QryGroup56Property 56char10NY=Yes, N=No Allow NULL? 
158QryGroup57Property 57char10NY=Yes, N=No Allow NULL? 
159QryGroup58Property 58char10NY=Yes, N=No Allow NULL? 
160QryGroup59Property 59char10NY=Yes, N=No Allow NULL? 
161QryGroup60Property 60char10NY=Yes, N=No Allow NULL? 
162QryGroup61Property 61char10NY=Yes, N=No Allow NULL? 
163QryGroup62Property 62char10NY=Yes, N=No Allow NULL? 
164QryGroup63Property 63char10NY=Yes, N=No Allow NULL? 
165QryGroup64Property 64char10NY=Yes, N=No 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]char10NY=Yes, N=No Allow NULL? 
187ManOutOnlyManage SN Only on Exitchar10NY=Yes, N=No Allow NULL? 
188DataSourceData Sourcechar10NN=Unknown, I=Interface, U=Update, M=Import, O=DI API, A=Doc. Generation Wizard, D=Restore Wizard, P=Partner Implementation, T=Year Transfer, G=Fixed Assets Migration Allow NULL? 
189validForActivechar10NY=Yes, N=No Allow NULL? 
190validFromActive Fromdate80
191validToActive Todate80
192frozenForInactivechar10NY=Yes, N=No Allow NULL? 
193frozenFromInactive Fromdate80
194frozenToInactive Todate80
195BlockOutForce selection of serial no.char10YY=Yes, N=No Allow NULL? 
196ValidCommActive Remarksnvarchar300 Allow NULL? 
197FrozenCommInactive Remarksnvarchar300 Allow NULL? 
198LogInstancLog Instanceint1100 Allow NULL? 
199ObjTypeObject Typenvarchar2004 Allow NULL? 
200SWWAdditional Identifiernvarchar160 Allow NULL? 
201DeletedDeletedchar10NY=Yes, N=No Allow NULL? 
202DocEntryInternal Numberint110 Allow NULL? 
203ExpensAcctExpense Accountnvarchar150 Allow NULL? 
204FrgnInAcctRevenue Account - Foreignnvarchar150 Allow NULL? 
205ShipTypeShipping Typeint60 Allow NULL? 
206GLMethodSet G/L Account bychar10WW=Warehouse, C=Item Group, L=Item Level Allow NULL? 
207ECInAcctRevenue Account - EUnvarchar150 Allow NULL? 
208FrgnExpAccExpense Account - Foreignnvarchar150 Allow NULL? 
209ECExpAccExpense Account - EUnvarchar150 Allow NULL? 
210TaxTypeTax Typechar10YY=Regular Tax, U=Use Tax, N=No Tax Allow NULL? 
211ByWhInventory Management by Whsechar10 Allow NULL? 
212WTLiableWTax Liablechar10YY=Yes, N=No Allow NULL? 
213ItemTypeItem Typechar10II=Items, L=Labor, T=Travel, F=Fixed Assets Allow NULL? 
214WarrntTmplWarranty Templatenvarchar200 Allow NULL? 
215BaseUnitBase Unit Namenvarchar200 Allow NULL? 
216CountryOrgCountry of Originnvarchar30 Allow NULL? 
217StockValueInventory Valuenum196 Allow NULL? 
218PhantomPhantom Itemchar10NY=Yes, N=No 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 Taxchar10NY=Yes, N=No 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 Materialchar1022=Material, 1=Service Allow NULL? 
243ExcisableExcisable [Yes/No]char10NY=Yes, N=No 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 Companychar10NY=Yes, N=No Allow NULL? 
273CessionCessionchar10NY=Yes, N=No Allow NULL? 
274DeacAftULDeactivate After Useful Lifechar10NY=Yes, N=No Allow NULL? 
275AsstStatusAsset Statuschar10NN=New, A=Active, I=Inactive Allow NULL? 
276CapDateCapitalization Datedate80
277AcqDateAcquisition Datedate80
278RetDateRetirement Datedate80
279GLPickMethG/L Account Pick Methodchar10AA=General, W=Warehouse, C=Item Group Allow NULL? 
280NoDiscountNo Discountschar10NY=Yes, N=No Allow NULL? 
281MgrByQtyManage Asset by Quantitychar10NY=Yes, N=No 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 Receiptchar10NY=Yes, N=No Allow NULL? 
292RuleCodeChecking Rule Codenvarchar20 Allow NULL? 
293ScsCodeSCS Codenvarchar100 Allow NULL? 
294SpProdTypeSpecial Product Typenvarchar20MT=Cellular Phones, IO=Integrated Circuits 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