	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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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

229 COLUMNS | 8 INDEXES | B1 8.82 | CPI1 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Marketing Documents
1	Business One	8.82	CPI1	229	8	A/P Correction Invoice - 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, FREE01, FREE02, FREE03 FROM CPI1

TOP B1 8.82 | CPI1 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	DocEntry	Document Internal ID	int	11	0	OCPI			Allow NULL?
2	LineNum	Row Number	int	11	0				Allow NULL?
3	TargetType	Target Document Type	int	11	0		-1	-1, 0, 163, 164, 20	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, 163, 18	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, O	Allow NULL?
10	ItemCode	Item No.	nvarchar	20	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	17	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	6	0	OSLP	-1		Allow NULL?
27	Commission	Commission Percentage	num	19	6				Allow NULL?
28	TreeType	BOM Type	char	1	0		N	A, I, N, P, S, T	Allow NULL?
29	AcctCode	Account Code	nvarchar	15	0	OACT			Allow NULL?
30	TaxStatus	Tax Definition	char	1	0			N, Y	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, Y	Allow NULL?
37	SubCatNum	Customer/Vendor Cat. No.	nvarchar	20	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	Inventory Direction	char	1	0		O	C, O	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	16	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	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	Quantity	num	19	6				Allow NULL?
61	VolUnit	Volume UoM	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	Inventory Update	char	1	0		Y	N, Y	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	Additional Identifier	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		163		Allow NULL?
80	LogInstanc	Log Instance	int	6	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, Y	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, Y	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, U, Y	Allow NULL?
102	OrigItem	Original Item	nvarchar	20	0	OITM			Allow NULL?
103	BackOrdr	Allow Backorder	char	1	0			N, Y	Allow NULL?
104	FreeTxt	Free Text	nvarchar	100	0				Allow NULL?
105	PickStatus	Pick Status	char	1	0		N	N, P, R, Y	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, Y	Allow NULL?
116	DeferrTax	Deferred Tax	char	1	0		N	N, Y	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	20	0				Allow NULL?
125	NumPerMsr	UoM Value	num	19	6				Allow NULL?
126	CEECFlag	Correction Invoice Was/Should Be	char	1	0		S	S, W	Allow NULL?
127	ToStock	Corr. Invoice Amt to Inventory	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	Allow NULL?
136	TranType	Transaction Type	char	1	0			C, R	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, Y	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, I	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 Charges	char	1	0			N, Y	Allow NULL?
164	DescOW	Description Overwritten	char	1	0		N	N, Y	Allow NULL?
165	DetailsOW	Details Overwritten	char	1	0		N	N, Y	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, Y	Allow NULL?
174	WtCalced	Withholding Tax Calculated	char	1	0		N	N, Y	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, Y	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, Y	Allow NULL?
191	Excisable	Excisable [Yes/No]	char	1	0			N, Y	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, O, P	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	20	0				Allow NULL?
206	NumPerMsr2	Pur/Sal UoM Value if BaseUnit	num	19	6				Allow NULL?
207	SpecPrice	Is Special Price for BP	char	1	0		N	N, Y	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, Y	Allow NULL?
213	PQTReqQty	Pur. Quotation: Required Qty	num	19	6				Allow NULL?
214	PQTReqDate	Pur. Quotation: Required Date	date	8	0
215	PcDocType	Pur. Confirmation Doc. Type	int	11	0		-1	-1, 22, 540000006	Allow NULL?
216	PcQuantity	Purchase Confirmation Quantity	num	19	6				Allow NULL?
217	LinManClsd	Line Was Closed Manually	char	1	0		N	N, U, Y	Allow NULL?
218	VatGrpSrc	VAT Group Source	char	1	0		N	D, M, N	Allow NULL?
219	NoInvtryMv	Without Inventory Movement	char	1	0		N	N, Y	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	FREE01	FREE01	nvarchar	20	0				Allow NULL?
228	FREE02	FREE02	nvarchar	20	0				Allow NULL?
229	FREE03	FREE03	int	11	0				Allow NULL?

TOP B1 8.82 | CPI1 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

229 COLUMNS | 8 INDEXES | B1 8.82 | CPI1 TABLE

TOP B1 8.82 | CPI1 COLUMNS

TOP B1 8.82 | CPI1 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

229 COLUMNS | 8 INDEXES | B1 8.82 | CPI1 TABLE

TOPB1 8.82 | CPI1 COLUMNS

TOPB1 8.82 | CPI1 INDEXES

TOP B1 8.82 | CPI1 COLUMNS

TOP B1 8.82 | CPI1 INDEXES