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 One8.8OITM2497ItemsInventory 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 FROM OITM

TOPB1 8.8  | OITM COLUMNS

ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1ItemCodeItem No.nvarchar200 Allow NULL? 
2ItemNameItem Descriptionnvarchar1000 Allow NULL? 
3FrgnNameDescription in Foreign Lang.nvarchar1000 Allow NULL? 
4ItmsGrpCodItem Groupint60OITB100 Allow NULL? 
5CstGrpCodeCustoms Groupint60OARG-1 Allow NULL? 
6VatGourpSaSales Tax Definitionnvarchar80OVTG Allow NULL? 
7CodeBarsBar Codenvarchar160 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 Accountnvarchar150OACT Allow NULL? 
16ExmptIncomExempt Revenue Accountnvarchar150OACT Allow NULL? 
17MaxLevelMaximum Inventory Levelnum196 Allow NULL? 
18DfltWHDefault Warehousenvarchar80 Allow NULL? 
19CardCodePreferred Vendornvarchar150OCRD Allow NULL? 
20SuppCatNumMfr Catalog No.nvarchar170 Allow NULL? 
21BuyUnitMsrPurchasing UoMnvarchar200 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 UoMnvarchar200 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, F=FIFO, S=Standard Allow NULL? 
42UserSignUser Signatureint60OUSR 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? 
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? 
179VatGroupPuPurchase Tax Definitionnvarchar80OVTG Allow NULL? 
180AvgPriceItem Costnum196 Allow NULL? 
181PurPackMsrPackaging UoM (Purchasing)nvarchar80 Allow NULL? 
182PurPackUnQuantity per Packaging UoMnum196 Allow NULL? 
183SalPackMsrSales Packnvarchar80 Allow NULL? 
184SalPackUnPackaging UoM (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, 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 Instanceint600 Allow NULL? 
199ObjTypeObject Typenvarchar2004 Allow NULL? 
200SWWAdditional Identifiernvarchar160 Allow NULL? 
201DeletedDeletedchar10NN=No, Y=Yes Allow NULL? 
202DocEntryInternal Numberint110 Allow NULL? 
203ExpensAcctExpense Accountnvarchar150OACT Allow NULL? 
204FrgnInAcctRevenue Account - Foreignnvarchar150OACT Allow NULL? 
205ShipTypeShipping Typeint60OSHP 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 Typechar10II=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 UoMnvarchar200 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)nvarchar80OSTC Allow NULL? 
233TaxCodeAPTax Code (A/P)nvarchar80OSTC Allow NULL? 
234OSvcCodeOutgoing Service Codeint110OSCD-1 Allow NULL? 
235ISvcCodeIncoming Service Codeint110OSCD-1 Allow NULL? 
236ServiceGrpService Groupint110OSGP-1 Allow NULL? 
237NCMCodeNCM Codeint110ONCM-1 Allow NULL? 
238MatTypeMaterial Typenvarchar30OMTP1 Allow NULL? 
239MatGrpMaterial Groupint110OMGP-1 Allow NULL? 
240ProductSrcProduct Sourcechar1011=Purchased from the domestic vendor, 2=Imported by company, 3=Imported goods purchased from the domestic vendor, 4=Produced by the Company 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? 

TOPB1 8.8  | OITM INDEXES

NamePrimaryUniqueTypeColumns
PRIMARYNoYesItemCode
ITEM_NAMENoNoItemName
TREE_TYPENoNoTreeType
COM_GROUPNoNoCommisGrp
SALENoNoSellItem
PURCHASENoNoPrchseItem
INVENTORYNoNoInvntItem