	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

287 COLUMNS | 8 INDEXES | B1 9.3 | DPI1 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Marketing Documents
1	Business One	9.3	DPI1	287	8	A/R Down Payment - Rows	Marketing Documents

SQL: selectupdate insert create

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

SELECT DocEntry, LineNum, TargetType, TrgetEntry, BaseRef, BaseType, BaseEntry, BaseLine, LineStatus, ItemCode, Dscription, Quantity, ShipDate, OpenQty, Price, Currency, Rate, DiscPrcnt, LineTotal, TotalFrgn, OpenSum, OpenSumFC, VendorNum, SerialNum, WhsCode, SlpCode, Commission, TreeType, AcctCode, TaxStatus, GrossBuyPr, PriceBefDi, DocDate, Flags, OpenCreQty, UseBaseUn, SubCatNum, BaseCard, TotalSumSy, OpenSumSys, InvntSttus, OcrCode, Project, CodeBars, VatPrcnt, VatGroup, PriceAfVAT, Height1, Hght1Unit, Height2, Hght2Unit, Width1, Wdth1Unit, Width2, Wdth2Unit, Length1, Len1Unit, length2, Len2Unit, Volume, VolUnit, Weight1, Wght1Unit, Weight2, Wght2Unit, Factor1, Factor2, Factor3, Factor4, PackQty, UpdInvntry, BaseDocNum, BaseAtCard, SWW, VatSum, VatSumFrgn, VatSumSy, FinncPriod, ObjType, LogInstanc, BlockNum, ImportLog, DedVatSum, DedVatSumF, DedVatSumS, IsAqcuistn, DistribSum, DstrbSumFC, DstrbSumSC, GrssProfit, GrssProfSC, GrssProfFC, VisOrder, INMPrice, PoTrgNum, PoTrgEntry, DropShip, PoLineNum, Address, TaxCode, TaxType, OrigItem, BackOrdr, FreeTxt, PickStatus, PickOty, PickIdNo, TrnsCode, VatAppld, VatAppldFC, VatAppldSC, BaseQty, BaseOpnQty, VatDscntPr, WtLiable, DeferrTax, EquVatPer, EquVatSum, EquVatSumF, EquVatSumS, LineVat, LineVatlF, LineVatS, unitMsr, NumPerMsr, CEECFlag, ToStock, ToDiff, ExciseAmt, TaxPerUnit, TotInclTax, CountryOrg, StckDstSum, ReleasQtty, LineType, TranType, Text, OwnerCode, StockPrice, ConsumeFCT, LstByDsSum, StckINMPr, LstBINMPr, StckDstFc, StckDstSc, LstByDsFc, LstByDsSc, StockSum, StockSumFc, StockSumSc, StckSumApp, StckAppFc, StckAppSc, ShipToCode, ShipToDesc, StckAppD, StckAppDFC, StckAppDSC, BasePrice, GTotal, GTotalFC, GTotalSC, DistribExp, DescOW, DetailsOW, GrossBase, VatWoDpm, VatWoDpmFc, VatWoDpmSc, CFOPCode, CSTCode, Usage, TaxOnly, WtCalced, QtyToShip, DelivrdQty, OrderedQty, CogsOcrCod, CiOppLineN, CogsAcct, ChgAsmBoMW, ActDelDate, OcrCode2, OcrCode3, OcrCode4, OcrCode5, TaxDistSum, TaxDistSFC, TaxDistSSC, PostTax, Excisable, AssblValue, RG23APart1, RG23APart2, RG23CPart1, RG23CPart2, CogsOcrCo2, CogsOcrCo3, CogsOcrCo4, CogsOcrCo5, LnExcised, LocCode, StockValue, GPTtlBasPr, unitMsr2, NumPerMsr2, SpecPrice, CSTfIPI, CSTfPIS, CSTfCOFINS, ExLineNo, isSrvCall, PQTReqQty, PQTReqDate, PcDocType, PcQuantity, LinManClsd, VatGrpSrc, NoInvtryMv, ActBaseEnt, ActBaseLn, ActBaseNum, OpenRtnQty, AgrNo, AgrLnNum, CredOrigin, Surpluses, DefBreak, Shortages, UomEntry, UomEntry2, UomCode, UomCode2, FromWhsCod, NeedQty, PartRetire, RetireQty, RetireAPC, RetirAPCFC, RetirAPCSC, InvQty, OpenInvQty, EnSetCost, RetCost, Incoterms, TransMod, LineVendor, DistribIS, ISDistrb, ISDistrbFC, ISDistrbSC, IsByPrdct, ItemType, PriceEdit, PrntLnNum, LinePoPrss, FreeChrgBP, TaxRelev, LegalText, ThirdParty, LicTradNum, InvQtyOnly, UnencReasn, ShipFromCo, ShipFromDe, FisrtBin, AllocBinC, ExpType, ExpUUID, ExpOpType, DIOTNat, MYFtype, GPBefDisc, ReturnRsn, ReturnAct, StgSeqNum, StgEntry, StgDesc, ItmTaxType, SacEntry, NCMCode, HsnEntry, OriBAbsEnt, OriBLinNum, OriBDocTyp, IsPrscGood, IsCstmAct FROM DPI1

TOP B1 9.3 | DPI1 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	DocEntry	Document Internal ID	int	11	0	ODPI			Allow NULL?
2	LineNum	Row Number	int	11	0				Allow NULL?
3	TargetType	Target Document Type	int	11	0		-1	-1, 0, 18=A/P Invoice, 203=A/R Down Payment, 20=Goods Receipt	Allow NULL?
4	TrgetEntry	Target Document Internal ID	int	11	0				Allow NULL?
5	BaseRef	Base Document Reference	nvarchar	16	0				Allow NULL?
6	BaseType	Base Document Type	int	11	0		-1	-1, 0, 15=Delivery, 17=Sales Order, 203=A/R Down Payment, 23=Quotation	Allow NULL?
7	BaseEntry	Base Document Internal ID	int	11	0				Allow NULL?
8	BaseLine	Base Row	int	11	0				Allow NULL?
9	LineStatus	Row Status	char	1	0		O	C=Closed, O=Open	Allow NULL?
10	ItemCode	Item No.	nvarchar	50	0	OITM			Allow NULL?
11	Dscription	Item/Service Description	nvarchar	100	0				Allow NULL?
12	Quantity	Quantity	num	19	6				Allow NULL?
13	ShipDate	Row Delivery Date	date	8	0
14	OpenQty	Remaining Open Quantity	num	19	6				Allow NULL?
15	Price	Price	num	19	6				Allow NULL?
16	Currency	Price Currency	nvarchar	3	0	OCRN			Allow NULL?
17	Rate	Currency Rate	num	19	6				Allow NULL?
18	DiscPrcnt	Discount % per Row	num	19	6				Allow NULL?
19	LineTotal	Row Total	num	19	6				Allow NULL?
20	TotalFrgn	Row Total (FC)	num	19	6				Allow NULL?
21	OpenSum	Open Amount	num	19	6				Allow NULL?
22	OpenSumFC	Open Amount (FC)	num	19	6				Allow NULL?
23	VendorNum	Vendor Catalog No.	nvarchar	50	0				Allow NULL?
24	SerialNum	Serial Number	nvarchar	17	0				Allow NULL?
25	WhsCode	Warehouse Code	nvarchar	8	0	OWHS			Allow NULL?
26	SlpCode	Sales Employee Code	int	11	0	OSLP	-1		Allow NULL?
27	Commission	Commission Percentage	num	19	6				Allow NULL?
28	TreeType	BOM Type	char	1	0		N	A=Assembly, I=Sales BOM Component, N=Not a BOM, P=Production, S=Sales, T=Template	Allow NULL?
29	AcctCode	Account Code	nvarchar	15	0	OACT			Allow NULL?
30	TaxStatus	Tax Definition	char	1	0			N=No, Y=Yes	Allow NULL?
31	GrossBuyPr	Base Price for Gross Profit	num	19	6				Allow NULL?
32	PriceBefDi	Unit Price	num	19	6				Allow NULL?
33	DocDate	Posting Date	date	8	0
34	Flags	Flags	int	11	0		0		Allow NULL?
35	OpenCreQty	Credit Memo Amount	num	19	6				Allow NULL?
36	UseBaseUn	Inventory UoM	char	1	0		N	N=No, Y=Yes	Allow NULL?
37	SubCatNum	Customer/Vendor Cat. No.	nvarchar	50	0	OSCN			Allow NULL?
38	BaseCard	Base BP Code	nvarchar	15	0	OCRD			Allow NULL?
39	TotalSumSy	Row Total (SC)	num	19	6				Allow NULL?
40	OpenSumSys	Open Amount (SC)	num	19	6				Allow NULL?
41	InvntSttus	Warehouse Status	char	1	0		O	C=Closed, O=Open	Allow NULL?
42	OcrCode	Distribution Rule	nvarchar	8	0	OOCR			Allow NULL?
43	Project	Project Code	nvarchar	20	0	OPRJ			Allow NULL?
44	CodeBars	Bar Code	nvarchar	254	0				Allow NULL?
45	VatPrcnt	Tax Rate per Row	num	19	6				Allow NULL?
46	VatGroup	Tax Definition	nvarchar	8	0	OVTG			Allow NULL?
47	PriceAfVAT	Gross Price after Discount	num	19	6				Allow NULL?
48	Height1	Height 1	num	19	6				Allow NULL?
49	Hght1Unit	Unit of Height 1	int	6	0				Allow NULL?
50	Height2	Height 2	num	19	6				Allow NULL?
51	Hght2Unit	Unit of Height 2	int	6	0				Allow NULL?
52	Width1	Width 1	num	19	6				Allow NULL?
53	Wdth1Unit	Unit of Width 1	int	6	0				Allow NULL?
54	Width2	Width 2	num	19	6				Allow NULL?
55	Wdth2Unit	Unit of Width 2	int	6	0				Allow NULL?
56	Length1	Length 1	num	19	6				Allow NULL?
57	Len1Unit	Unit of Length 1	int	6	0				Allow NULL?
58	length2	Length 2	num	19	6				Allow NULL?
59	Len2Unit	Unit of Length 2	int	6	0				Allow NULL?
60	Volume	Volume	num	19	6				Allow NULL?
61	VolUnit	Unit of Measure for Volume	int	6	0				Allow NULL?
62	Weight1	Weight 1	num	19	6				Allow NULL?
63	Wght1Unit	Unit of Weight 1	int	6	0				Allow NULL?
64	Weight2	Weight 2	num	19	6				Allow NULL?
65	Wght2Unit	Unit of Weight 2	int	6	0				Allow NULL?
66	Factor1	Factor 1	num	19	6				Allow NULL?
67	Factor2	Factor 2	num	19	6				Allow NULL?
68	Factor3	Factor 3	num	19	6				Allow NULL?
69	Factor4	Factor 4	num	19	6				Allow NULL?
70	PackQty	Packing Quantity	num	19	6				Allow NULL?
71	UpdInvntry	Warehouse Update	char	1	0		N	N=No, Y=Yes	Allow NULL?
72	BaseDocNum	Base Document No.	int	11	0				Allow NULL?
73	BaseAtCard	Customer/Vendor Base Document	nvarchar	100	0				Allow NULL?
74	SWW	SWW	nvarchar	16	0				Allow NULL?
75	VatSum	Total Tax	num	19	6				Allow NULL?
76	VatSumFrgn	Tax Amount (FC)	num	19	6				Allow NULL?
77	VatSumSy	Tax Amount (SC)	num	19	6				Allow NULL?
78	FinncPriod	Posting Period	int	11	0	OFPR			Allow NULL?
79	ObjType	Object Type	nvarchar	20	0	ADP1	203		Allow NULL?
80	LogInstanc	Log Instance	int	11	0		0		Allow NULL?
81	BlockNum	Block Number	nvarchar	100	0				Allow NULL?
82	ImportLog	Import Log	nvarchar	20	0				Allow NULL?
83	DedVatSum	Deductible Tax Amount	num	19	6				Allow NULL?
84	DedVatSumF	Deductible Tax Amount (FC)	num	19	6				Allow NULL?
85	DedVatSumS	Deductible Tax Amount (SC)	num	19	6				Allow NULL?
86	IsAqcuistn	Acquisition Tax	char	1	0		N	N=No, Y=Yes	Allow NULL?
87	DistribSum	Distributed Amount	num	19	6				Allow NULL?
88	DstrbSumFC	Distributed Amount (FC)	num	19	6				Allow NULL?
89	DstrbSumSC	Distributed Amount (SC)	num	19	6				Allow NULL?
90	GrssProfit	Row Gross Profit	num	19	6				Allow NULL?
91	GrssProfSC	Row Gross Profit (SC)	num	19	6				Allow NULL?
92	GrssProfFC	Row Gross Profit (FC)	num	19	6				Allow NULL?
93	VisOrder	Visual Order	int	11	0				Allow NULL?
94	INMPrice	Item's Last Sales Price (OINM)	num	19	6				Allow NULL?
95	PoTrgNum	PO Target No.	int	11	0				Allow NULL?
96	PoTrgEntry	PO Target Internal ID	nvarchar	11	0				Allow NULL?
97	DropShip	Drop-Ship	char	1	0		N	N=No, Y=Yes	Allow NULL?
98	PoLineNum	PO Target Row No.	int	11	0				Allow NULL?
99	Address	Address	nvarchar	254	0				Allow NULL?
100	TaxCode	Tax Code	nvarchar	8	0	OSTC			Allow NULL?
101	TaxType	Tax Type	char	1	0			N=No Tax, O=Offset Tax, U=Use Tax, Y=Regular Tax	Allow NULL?
102	OrigItem	Original Item	nvarchar	50	0	OITM			Allow NULL?
103	BackOrdr	Allow Backorder	char	1	0			N=No, Y=Yes	Allow NULL?
104	FreeTxt	Free Text	nvarchar	100	0				Allow NULL?
105	PickStatus	Pick Status	char	1	0		N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked	Allow NULL?
106	PickOty	Pick Quantity	num	19	6				Allow NULL?
107	PickIdNo	Pick List ID Number	int	11	0				Allow NULL?
108	TrnsCode	Shipping Method	int	6	0	OSHP	-1		Allow NULL?
109	VatAppld	Applied Tax	num	19	6				Allow NULL?
110	VatAppldFC	Applied Tax (FC)	num	19	6				Allow NULL?
111	VatAppldSC	Applied Tax (SC)	num	19	6				Allow NULL?
112	BaseQty	Base Quantity	num	19	6				Allow NULL?
113	BaseOpnQty	Base Open Quantity	num	19	6				Allow NULL?
114	VatDscntPr	Tax Discount %	num	19	6				Allow NULL?
115	WtLiable	Withholding Tax Liable	char	1	0			N=No, Y=Yes	Allow NULL?
116	DeferrTax	Deferred Tax	char	1	0		N	N=No, Y=Yes	Allow NULL?
117	EquVatPer	Equalization Tax %	num	19	6				Allow NULL?
118	EquVatSum	Total Equalization Tax	num	19	6				Allow NULL?
119	EquVatSumF	Total Equalization Tax (FC)	num	19	6				Allow NULL?
120	EquVatSumS	Total Equalization Tax (SC)	num	19	6				Allow NULL?
121	LineVat	Net Tax Amount	num	19	6				Allow NULL?
122	LineVatlF	Net Tax Amount	num	19	6				Allow NULL?
123	LineVatS	Net Tax Amount	num	19	6				Allow NULL?
124	unitMsr	Unit	nvarchar	100	0				Allow NULL?
125	NumPerMsr	UoM Value	num	19	6				Allow NULL?
126	CEECFlag	Correction Invoice Was/Should Be	char	1	0		S	S=Should be, W=Was	Allow NULL?
127	ToStock	Corr. Invoice Amount to Stock	num	19	6				Allow NULL?
128	ToDiff	Corr. Invoice Amount to Diff.	num	19	6				Allow NULL?
129	ExciseAmt	Excise Amount	num	19	6				Allow NULL?
130	TaxPerUnit	Tax per Unit	num	19	6				Allow NULL?
131	TotInclTax	Total Including Tax	num	19	6				Allow NULL?
132	CountryOrg	Country of Origin	nvarchar	3	0				Allow NULL?
133	StckDstSum	Stock Distribution Sum	num	19	6				Allow NULL?
134	ReleasQtty	Released Quantity	num	19	6				Allow NULL?
135	LineType	Row Type	char	1	0		R	R=Regular	Allow NULL?
136	TranType	Transaction Type	char	1	0			C=Complete, R=Reject	Allow NULL?
137	Text	Text	text	16	0
138	OwnerCode	Document Owner	int	11	0				Allow NULL?
139	StockPrice	Inventory Price	num	19	6				Allow NULL?
140	ConsumeFCT	Consumer Sales Forecast	char	1	0			N=No, Y=Yes	Allow NULL?
141	LstByDsSum	Last Buy Distribute Sum	num	19	6				Allow NULL?
142	StckINMPr	Stock Inm Price	num	19	6				Allow NULL?
143	LstBINMPr	Last Buy Inventory Journal Pr.	num	19	6				Allow NULL?
144	StckDstFc	Stock Distributed Sum (FC)	num	19	6				Allow NULL?
145	StckDstSc	Stock Distributed Sum (SC)	num	19	6				Allow NULL?
146	LstByDsFc	Last Buy Distribute Sum (FC)	num	19	6				Allow NULL?
147	LstByDsSc	Last Buy Distribute Sum (SC)	num	19	6				Allow NULL?
148	StockSum	Stock Sum	num	19	6				Allow NULL?
149	StockSumFc	Stock Sum FC	num	19	6				Allow NULL?
150	StockSumSc	Stock Sum SC	num	19	6				Allow NULL?
151	StckSumApp	Stock Sum Applied	num	19	6				Allow NULL?
152	StckAppFc	Stock Sum Applied FC	num	19	6				Allow NULL?
153	StckAppSc	Stock Sum Applied SC	num	19	6				Allow NULL?
154	ShipToCode	Ship-to Code	nvarchar	50	0				Allow NULL?
155	ShipToDesc	Ship-to Description	nvarchar	254	0				Allow NULL?
156	StckAppD	Stock Distrib. - Applied Sum	num	19	6				Allow NULL?
157	StckAppDFC	Stock Dist. - Applied Sum (FC)	num	19	6				Allow NULL?
158	StckAppDSC	Stock Dist. - Applied Sum (SC)	num	19	6				Allow NULL?
159	BasePrice	Price for Total Calculation	char	1	0		E	E=Exclude Tax, I=Include Tax	Allow NULL?
160	GTotal	Gross Total	num	19	6				Allow NULL?
161	GTotalFC	Gross Total (FC)	num	19	6				Allow NULL?
162	GTotalSC	Gross Total (SC)	num	19	6				Allow NULL?
163	DistribExp	Distribute Freight	char	1	0			N=No, Y=Yes	Allow NULL?
164	DescOW	Description Overwritten	char	1	0		N	N=No, Y=Yes	Allow NULL?
165	DetailsOW	Details Overwritten	char	1	0		N	N=No, Y=Yes	Allow NULL?
166	GrossBase	Base Method for Gross Profit	int	6	0				Allow NULL?
167	VatWoDpm	Tax Before DPM Applied	num	19	6				Allow NULL?
168	VatWoDpmFc	Tax Before DPM Applied (FC)	num	19	6				Allow NULL?
169	VatWoDpmSc	Tax Before DPM Applied (SC)	num	19	6				Allow NULL?
170	CFOPCode	CFOP Code for Document	nvarchar	6	0	OCFP			Allow NULL?
171	CSTCode	CST Code for ICMS	nvarchar	6	0				Allow NULL?
172	Usage	Usage Code for Document	int	11	0	OUSG			Allow NULL?
173	TaxOnly	Tax Only	char	1	0			N=No, Y=Yes	Allow NULL?
174	WtCalced	Withholding Tax Calculated	char	1	0		N	N=No, Y=Yes	Allow NULL?
175	QtyToShip	Quantity to Ship	num	19	6				Allow NULL?
176	DelivrdQty	Delivered Quantity	num	19	6				Allow NULL?
177	OrderedQty	Ordered Quantity	num	19	6				Allow NULL?
178	CogsOcrCod	COGS Distribution Rule Code	nvarchar	8	0	OOCR			Allow NULL?
179	CiOppLineN	Line Number of Opposite Line	int	11	0		-1		Allow NULL?
180	CogsAcct	COGS Account Code	nvarchar	15	0	OACT			Allow NULL?
181	ChgAsmBoMW	Change Whs for Asm BoM Child	char	1	0			N=No, Y=Yes	Allow NULL?
182	ActDelDate	Actual Delivery Date	date	8	0
183	OcrCode2	Costing Code 2	nvarchar	8	0	OOCR			Allow NULL?
184	OcrCode3	Costing Code 3	nvarchar	8	0	OOCR			Allow NULL?
185	OcrCode4	Costing Code 4	nvarchar	8	0	OOCR			Allow NULL?
186	OcrCode5	Costing Code 5	nvarchar	8	0	OOCR			Allow NULL?
187	TaxDistSum	Tax Distributed Amount	num	19	6				Allow NULL?
188	TaxDistSFC	Tax Distributed Amount (FC)	num	19	6				Allow NULL?
189	TaxDistSSC	Tax Distributed Amount (SC)	num	19	6				Allow NULL?
190	PostTax	Post Tax in Price to Stock	char	1	0		Y	N=No, Y=Yes	Allow NULL?
191	Excisable	Excisable [Yes/No]	char	1	0			N=No, Y=Yes	Allow NULL?
192	AssblValue	Assessable Value	num	19	6				Allow NULL?
193	RG23APart1	RG23A Part1 Number	int	11	0				Allow NULL?
194	RG23APart2	RG23A Part2 Number	int	11	0				Allow NULL?
195	RG23CPart1	RG23C Part1 Number	int	11	0				Allow NULL?
196	RG23CPart2	RG23C Part2 Number	int	11	0				Allow NULL?
197	CogsOcrCo2	COGS Distribution Rule Code2	nvarchar	8	0	OOCR			Allow NULL?
198	CogsOcrCo3	COGS Distribution Rule Code3	nvarchar	8	0	OOCR			Allow NULL?
199	CogsOcrCo4	COGS Distribution Rule Code4	nvarchar	8	0	OOCR			Allow NULL?
200	CogsOcrCo5	COGS Distribution Rule Code5	nvarchar	8	0	OOCR			Allow NULL?
201	LnExcised	Line Excised	char	1	0			C=Closed, O=Open, P=Copied to OEI	Allow NULL?
202	LocCode	Location Code	int	11	0	OLCT			Allow NULL?
203	StockValue	Total COGS Value	num	19	6				Allow NULL?
204	GPTtlBasPr	Total Base Price for Profit	num	19	6				Allow NULL?
205	unitMsr2	Pur/Sal UoM if BaseUnit	nvarchar	100	0				Allow NULL?
206	NumPerMsr2	Pur/Sal UoM Value if Base Unit	num	19	6				Allow NULL?
207	SpecPrice	Price Source Type	char	1	0		N	!=Blanket Agreement, 0=Period and Volume Discounts, 1=Period and Volume Discounts, Discount Groups, 2=Active Price List, 5=Inactive Price List, 6=Inactive Price List, Discount Groups, 7=Active Price List, Discount Groups, 9=Special Prices for Business Partner, A=Blanket Agreement, N=Manual, P=Period and Volume Discounts, Q=Period and Volum	Allow NULL?
208	CSTfIPI	CST for IPI Code	nvarchar	2	0				Allow NULL?
209	CSTfPIS	CST for PIS Code	nvarchar	2	0				Allow NULL?
210	CSTfCOFINS	CST for COFINS Code	nvarchar	2	0				Allow NULL?
211	ExLineNo	ExLineNo	nvarchar	10	0				Allow NULL?
212	isSrvCall	Created from Service Call	char	1	0		N	N=No, Y=Yes	Allow NULL?
213	PQTReqQty	Pur Quotation: Required Qty	num	19	6				Allow NULL?
214	PQTReqDate	Pur Quotation: Required Date	date	8	0
215	PcDocType	Purchase Confirmation Doc Type	int	11	0		-1	-1=No Type, 22=Purchase Order, 540000006=Purchase Quotation	Allow NULL?
216	PcQuantity	Purchase Confirmation Quantity	num	19	6				Allow NULL?
217	LinManClsd	Line Was Closed Manually	char	1	0		N	N=No, U=Unknown, Y=Yes	Allow NULL?
218	VatGrpSrc	VAT Group Source	char	1	0		N	D=Determined, M=Manually Entered, N=Not Defined	Allow NULL?
219	NoInvtryMv	Without Inventory Movement	char	1	0		N	N=No, Y=Yes	Allow NULL?
220	ActBaseEnt	Actual Base Document Entry	int	11	0				Allow NULL?
221	ActBaseLn	Actual Base Line Number	int	11	0				Allow NULL?
222	ActBaseNum	Actual Base Document No.	int	11	0				Allow NULL?
223	OpenRtnQty	Quantity Open for Return	num	19	6				Allow NULL?
224	AgrNo	Agreement No.	int	11	0	OOAT			Allow NULL?
225	AgrLnNum	Agreement Row Number	int	11	0				Allow NULL?
226	CredOrigin	Credit Origin	char	1	0	OBSI			Allow NULL?
227	Surpluses	Surpluses	num	19	6				Allow NULL?
228	DefBreak	Defect and Breakup	num	19	6				Allow NULL?
229	Shortages	Shortages	num	19	6				Allow NULL?
230	UomEntry	UoM Entry	int	11	0	OUOM	0		Allow NULL?
231	UomEntry2	UoM Entry if Base Unit	int	11	0	OUOM	0		Allow NULL?
232	UomCode	UoM Code	nvarchar	20	0				Allow NULL?
233	UomCode2	UoM Code if Base Unit	nvarchar	20	0				Allow NULL?
234	FromWhsCod	From Warehouse Code	nvarchar	8	0	OWHS			Allow NULL?
235	NeedQty	Consider Quantity of Items	char	1	0		N	N=No, Y=Yes	Allow NULL?
236	PartRetire	Partial Retirement	char	1	0		N	N=No, Y=Yes	Allow NULL?
237	RetireQty	Retirement Quantity	num	19	6				Allow NULL?
238	RetireAPC	Retirement APC	num	19	6				Allow NULL?
239	RetirAPCFC	Retirement APC FC	num	19	6				Allow NULL?
240	RetirAPCSC	Retirement APC SC	num	19	6				Allow NULL?
241	InvQty	Quantity - Inventory UoM	num	19	6				Allow NULL?
242	OpenInvQty	Open Quantity (Inventory UoM)	num	19	6				Allow NULL?
243	EnSetCost	Enable Set Item Cost in Return	char	1	0		N	N=No, Y=Yes	Allow NULL?
244	RetCost	Return Cost in A/R Return	num	19	6				Allow NULL?
245	Incoterms	Incoterms	int	11	0	ODCI	0		Allow NULL?
246	TransMod	Transport Mode	int	11	0	ODCI	0		Allow NULL?
247	LineVendor	Line Vendor Code	nvarchar	15	0	OCRD			Allow NULL?
248	DistribIS	Distribute Intrastat Freight	char	1	0		N	N=No, Y=Yes	Allow NULL?
249	ISDistrb	Intrastat Distrib. Amount	num	19	6				Allow NULL?
250	ISDistrbFC	Intrastat Distrib. Amount (FC)	num	19	6				Allow NULL?
251	ISDistrbSC	Intrastat Distrib. Amount (SC)	num	19	6				Allow NULL?
252	IsByPrdct	Item Is By-Product	char	1	0		N	N=No, Y=Yes	Allow NULL?
253	ItemType	Item Type	int	11	0		4	4=Item	Allow NULL?
254	PriceEdit	Price Was Edited by User	char	1	0		N	N=No, Y=Yes	Allow NULL?
255	PrntLnNum	Parent Line Number	int	11	0				Allow NULL?
256	LinePoPrss	Line PO Process	char	1	0		N	N=No, Y=Yes	Allow NULL?
257	FreeChrgBP	Free of Charge (BP)	char	1	0		N	N=No, Y=Yes	Allow NULL?
258	TaxRelev	Tax Relevant Row	char	1	0		Y	N=No, Y=Yes	Allow NULL?
259	LegalText	Legal Text	nvarchar	254	0				Allow NULL?
260	ThirdParty	Third Party	char	1	0		N	N=No, Y=Yes	Allow NULL?
261	LicTradNum	Federal Tax ID	nvarchar	32	0				Allow NULL?
262	InvQtyOnly	Change Qty (Inv. UoM) Only	char	1	0		N	N=No, Y=Yes	Allow NULL?
263	UnencReasn	Reason for Unencumbered ICMS	int	11	0				Allow NULL?
264	ShipFromCo	Ship-From Code	nvarchar	50	0				Allow NULL?
265	ShipFromDe	Ship-From Description	nvarchar	254	0				Allow NULL?
266	FisrtBin	First Bin Location	nvarchar	228	0				Allow NULL?
267	AllocBinC	Allocated Bin Location Count	nvarchar	11	0				Allow NULL?
268	ExpType	Expense Type	nvarchar	4	0	OEXD			Allow NULL?
269	ExpUUID	Expense UUID	nvarchar	50	0				Allow NULL?
270	ExpOpType	Expense Operation Type	char	1	0			, O=Others, P=Professional Services, R=Renting Assets	Allow NULL?
271	DIOTNat	DIOT Nationality	nvarchar	3	0	OCRY			Allow NULL?
272	MYFtype	MYF type	nvarchar	2	0			P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales	Allow NULL?
273	GPBefDisc	Gross Price	num	19	6				Allow NULL?
274	ReturnRsn	Return Reason	int	6	0		-1		Allow NULL?
275	ReturnAct	Return Action	int	6	0		-1		Allow NULL?
276	StgSeqNum	Stage Sequence Number	int	11	0				Allow NULL?
277	StgEntry	Stage Entry	int	11	0	ORST			Allow NULL?
278	StgDesc	Stage Description	nvarchar	100	0				Allow NULL?
279	ItmTaxType	Item GST Tax Category	nvarchar	2	0			GE=GST Exempt, GN=GST Nil Rated, GR=GST Regular, NE=Excisable, NN=Non-GST Non-Excisable	Allow NULL?
280	SacEntry	SAC Entry	int	11	0	OSAC			Allow NULL?
281	NCMCode	NCM Code	int	11	0	ONCM	-1		Allow NULL?
282	HsnEntry	HSN Entry	int	11	0				Allow NULL?
283	OriBAbsEnt	Original Base Document Internal ID	int	11	0				Allow NULL?
284	OriBLinNum	Original Base Document Line Number	int	11	0				Allow NULL?
285	OriBDocTyp	Original Base Document Type	int	11	0				Allow NULL?
286	IsPrscGood	Is Prescribed Goods	char	1	0		N	N=No, Y=Yes	Allow NULL?
287	IsCstmAct	Apply Customer Accounting Tax Rule	char	1	0		N	N=No, Y=Yes	Allow NULL?

TOP B1 9.3 | DPI1 INDEXES

Name	Primary	Unique	Columns
PRIMARY	No	Yes	DocEntry, LineNum
STATUS	No	No	LineStatus
CURRENCY	No	No	Currency
ACCOUNT	No	No	AcctCode
BASE_ENTRY	No	No	BaseEntry, BaseType, BaseLine
VIS_ORDER	No	No	DocEntry, VisOrder
OWNER_CODE	No	No	OwnerCode
ITM_WHS_OQ	No	No	ItemCode, WhsCode, OpenQty

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

287 COLUMNS | 8 INDEXES | B1 9.3 | DPI1 TABLE

TOP B1 9.3 | DPI1 COLUMNS

TOP B1 9.3 | DPI1 INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

287 COLUMNS | 8 INDEXES | B1 9.3 | DPI1 TABLE

TOPB1 9.3 | DPI1 COLUMNS

TOPB1 9.3 | DPI1 INDEXES

TOP B1 9.3 | DPI1 COLUMNS

TOP B1 9.3 | DPI1 INDEXES