	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

316 COLUMNS | 10 INDEXES | B1 8.82 | OCSI TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Marketing Documents
1	Business One	8.82	OCSI	316	10	A/R Correction Invoice	Marketing Documents

SQL: selectupdate insert create

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

SELECT DocEntry, DocNum, DocType, CANCELED, Handwrtten, Printed, DocStatus, InvntSttus, Transfered, ObjType, DocDate, DocDueDate, CardCode, CardName, Address, NumAtCard, VatPercent, VatSum, VatSumFC, DiscPrcnt, DiscSum, DiscSumFC, DocCur, DocRate, DocTotal, DocTotalFC, PaidToDate, PaidFC, GrosProfit, GrosProfFC, Ref1, Ref2, Comments, JrnlMemo, TransId, ReceiptNum, GroupNum, DocTime, SlpCode, TrnspCode, PartSupply, Confirmed, GrossBase, ImportEnt, CreateTran, SummryType, UpdInvnt, UpdCardBal, Instance, Flags, InvntDirec, CntctCode, ShowSCN, FatherCard, SysRate, CurSource, VatSumSy, DiscSumSy, DocTotalSy, PaidSys, FatherType, GrosProfSy, UpdateDate, IsICT, CreateDate, Volume, VolUnit, Weight, WeightUnit, Series, TaxDate, Filler, DataSource, StampNum, isCrin, FinncPriod, UserSign, selfInv, VatPaid, VatPaidFC, VatPaidSys, UserSign2, WddStatus, draftKey, TotalExpns, TotalExpFC, TotalExpSC, DunnLevel, Address2, LogInstanc, Exported, StationID, Indicator, NetProc, AqcsTax, AqcsTaxFC, AqcsTaxSC, CashDiscPr, CashDiscnt, CashDiscFC, CashDiscSC, ShipToCode, LicTradNum, PaymentRef, WTSum, WTSumFC, WTSumSC, RoundDif, RoundDifFC, RoundDifSy, CheckDigit, Form1099, Box1099, submitted, PoPrss, Rounding, RevisionPo, Segment, ReqDate, CancelDate, PickStatus, Pick, BlockDunn, PeyMethod, PayBlock, PayBlckRef, MaxDscn, Reserve, Max1099, CntrlBnk, PickRmrk, ISRCodLine, ExpAppl, ExpApplFC, ExpApplSC, Project, DeferrTax, LetterNum, FromDate, ToDate, WTApplied, WTAppliedF, BoeReserev, AgentCode, WTAppliedS, EquVatSum, EquVatSumF, EquVatSumS, Installmnt, VATFirst, NnSbAmnt, NnSbAmntSC, NbSbAmntFC, ExepAmnt, ExepAmntSC, ExepAmntFC, VatDate, CorrExt, CorrInv, NCorrInv, CEECFlag, BaseAmnt, BaseAmntSC, BaseAmntFC, CtlAccount, BPLId, BPLName, VATRegNum, TxInvRptNo, TxInvRptDt, KVVATCode, WTDetails, SumAbsId, SumRptDate, PIndicator, ManualNum, UseShpdGd, BaseVtAt, BaseVtAtSC, BaseVtAtFC, NnSbVAt, NnSbVAtSC, NbSbVAtFC, ExptVAt, ExptVAtSC, ExptVAtFC, LYPmtAt, LYPmtAtSC, LYPmtAtFC, ExpAnSum, ExpAnSys, ExpAnFrgn, DocSubType, DpmStatus, DpmAmnt, DpmAmntSC, DpmAmntFC, DpmDrawn, DpmPrcnt, PaidSum, PaidSumFc, PaidSumSc, FolioPref, FolioNum, DpmAppl, DpmApplFc, DpmApplSc, LPgFolioN, Header, Footer, Posted, OwnerCode, BPChCode, BPChCntc, PayToCode, IsPaytoBnk, BnkCntry, BankCode, BnkAccount, BnkBranch, isIns, TrackNo, VersionNum, LangCode, BPNameOW, BillToOW, ShipToOW, RetInvoice, ClsDate, MInvNum, MInvDate, SeqCode, Serial, SeriesStr, SubStr, Model, TaxOnExp, TaxOnExpFc, TaxOnExpSc, TaxOnExAp, TaxOnExApF, TaxOnExApS, LastPmnTyp, LndCstNum, UseCorrVat, BlkCredMmo, OpenForLaC, Excised, ExcRefDate, ExcRmvTime, SrvGpPrcnt, DepositNum, CertNum, DutyStatus, AutoCrtFlw, FlwRefDate, FlwRefNum, VatJENum, DpmVat, DpmVatFc, DpmVatSc, DpmAppVat, DpmAppVatF, DpmAppVatS, InsurOp347, IgnRelDoc, BuildDesc, ResidenNum, Checker, Payee, CopyNumber, SSIExmpt, PQTGrpSer, PQTGrpNum, PQTGrpHW, ReopOriDoc, ReopManCls, DocManClsd, ClosingOpt, SpecDate, Ordered, NTSApprov, NTSWebSite, NTSeTaxNo, NTSApprNo, PayDuMonth, ExtraMonth, ExtraDays, CdcOffset, SignMsg, SignDigest, CertifNum, KeyVersion, EDocGenTyp, ESeries, EDocNum, EDocExpFrm, OnlineQuo, POSEqNum, POSManufSN, POSCashN, EDocStatus, EDocCntnt, EDocProces, EDocErrCod, EDocErrMsg, EDocCancel, EDocTest, EDocPrefix, CUP, CIG, DpmAsDscnt, Attachment, AtcEntry, SupplCode, GTSRlvnt FROM OCSI

TOP B1 8.82 | OCSI COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	DocEntry	Numerator	int	11	0				Allow NULL?
2	DocNum	Document Number	int	11	0				Allow NULL?
3	DocType	Document Type	char	1	0		I	I, S	Allow NULL?
4	CANCELED	Cancelled	char	1	0		N	N, Y	Allow NULL?
5	Handwrtten	Manual Numbering	char	1	0		N	N, Y	Allow NULL?
6	Printed	Printed	char	1	0		N	A, N, Y	Allow NULL?
7	DocStatus	Document Status	char	1	0		O	C, O	Allow NULL?
8	InvntSttus	Inventory Direction	char	1	0		O	C, O	Allow NULL?
9	Transfered	Year Transfer	char	1	0		N	N, Y	Allow NULL?
10	ObjType	Object Type	nvarchar	20	0		165	165	Allow NULL?
11	DocDate	Posting Date	date	8	0
12	DocDueDate	Due Date	date	8	0
13	CardCode	Customer/Vendor Code	nvarchar	15	0	OCRD			Allow NULL?
14	CardName	Customer/Vendor Name	nvarchar	100	0				Allow NULL?
15	Address	Bill to	nvarchar	254	0				Allow NULL?
16	NumAtCard	Customer/Vendor Ref. No.	nvarchar	100	0				Allow NULL?
17	VatPercent	Tax Rate	num	19	6				Allow NULL?
18	VatSum	Total Tax	num	19	6				Allow NULL?
19	VatSumFC	Tax Amount (FC)	num	19	6				Allow NULL?
20	DiscPrcnt	Discount % for Document	num	19	6				Allow NULL?
21	DiscSum	Total Discount	num	19	6				Allow NULL?
22	DiscSumFC	Total Discount (FC)	num	19	6				Allow NULL?
23	DocCur	Document Currency	nvarchar	3	0	OCRN			Allow NULL?
24	DocRate	Document Rate	num	19	6				Allow NULL?
25	DocTotal	Document Total	num	19	6				Allow NULL?
26	DocTotalFC	Document Total (FC)	num	19	6				Allow NULL?
27	PaidToDate	Paid to Date	num	19	6				Allow NULL?
28	PaidFC	Paid (FC)	num	19	6				Allow NULL?
29	GrosProfit	Gross Profit	num	19	6				Allow NULL?
30	GrosProfFC	Gross Profit (FC)	num	19	6				Allow NULL?
31	Ref1	Reference 1	nvarchar	11	0				Allow NULL?
32	Ref2	Reference 2	nvarchar	11	0				Allow NULL?
33	Comments	Remarks	nvarchar	254	0				Allow NULL?
34	JrnlMemo	Journal Remarks	nvarchar	50	0				Allow NULL?
35	TransId	Transaction Number	int	11	0	OJDT			Allow NULL?
36	ReceiptNum	Receipt Number	int	11	0				Allow NULL?
37	GroupNum	Payment Terms Code	int	6	0	OCTG			Allow NULL?
38	DocTime	Generation Time	int	6	0				Allow NULL?
39	SlpCode	Sales Employee	int	6	0	OSLP	-1		Allow NULL?
40	TrnspCode	Delivery Method	int	6	0	OSHP	-1		Allow NULL?
41	PartSupply	Partial Delivery	char	1	0		Y	N, Y	Allow NULL?
42	Confirmed	Confirmed	char	1	0		Y	N, Y	Allow NULL?
43	GrossBase	Price List for Gross Profit	int	6	0		0		Allow NULL?
44	ImportEnt	Landed Costs Internal ID	int	11	0				Allow NULL?
45	CreateTran	Create Journal Entry	char	1	0		N	N, Y	Allow NULL?
46	SummryType	Summary Method	char	1	0		N	D, I, N	Allow NULL?
47	UpdInvnt	Inventory Update	char	1	0		N	C, G, I, N, O	Allow NULL?
48	UpdCardBal	Update Balances	char	1	0		N	B, D, N, O	Allow NULL?
49	Instance	Instance	int	6	0		0		Allow NULL?
50	Flags	Flags	int	11	0		0		Allow NULL?
51	InvntDirec	Warehouse Direction	char	1	0		X	E, X	Allow NULL?
52	CntctCode	Contact Person	int	11	0	OCPR			Allow NULL?
53	ShowSCN	Display BP Catalog Number	char	1	0		N	N, Y	Allow NULL?
54	FatherCard	BP Consolidation	nvarchar	15	0	OCRD			Allow NULL?
55	SysRate	System Price	num	19	6				Allow NULL?
56	CurSource	Base Currency	char	1	0		C	C, L, S	Allow NULL?
57	VatSumSy	Tax Amount (SC)	num	19	6				Allow NULL?
58	DiscSumSy	Total Discount (SC)	num	19	6				Allow NULL?
59	DocTotalSy	Document Total (SC)	num	19	6				Allow NULL?
60	PaidSys	Paid (SC)	num	19	6				Allow NULL?
61	FatherType	Parent Summary Type	char	1	0		P	D, P	Allow NULL?
62	GrosProfSy	Gross Profit (SC)	num	19	6				Allow NULL?
63	UpdateDate	Date of Update	date	8	0
64	IsICT	A/R Invoice + Payment	char	1	0		N	N, Y	Allow NULL?
65	CreateDate	Creation Date	date	8	0
66	Volume	Volume	num	19	6				Allow NULL?
67	VolUnit	Volume Unit of Measure	int	6	0				Allow NULL?
68	Weight	Weight	num	19	6				Allow NULL?
69	WeightUnit	Weight UoM	int	6	0				Allow NULL?
70	Series	Series	int	6	0	NNM1			Allow NULL?
71	TaxDate	Document Date	date	8	0
72	Filler	Filter	nvarchar	8	0	OWHS			Allow NULL?
73	DataSource	Data Source	char	1	0		N	A, D, I, M, N, O, P, T, U	Allow NULL?
74	StampNum	Stamp No.	nvarchar	16	0				Allow NULL?
75	isCrin	Corrected Invoice	char	1	0		N	N, Y	Allow NULL?
76	FinncPriod	Posting Period	int	11	0	OFPR			Allow NULL?
77	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
78	selfInv	Auto. Invoice	char	1	0		N	N, Y	Allow NULL?
79	VatPaid	Tax Paid to Date	num	19	6				Allow NULL?
80	VatPaidFC	Tax Paid (FC)	num	19	6				Allow NULL?
81	VatPaidSys	Tax Paid (SC)	num	19	6				Allow NULL?
82	UserSign2	Updating User	int	6	0	OUSR			Allow NULL?
83	WddStatus	Authorization Status	char	1	0		-	-, A, C, N, P, W, Y	Allow NULL?
84	draftKey	Document Draft Internal ID	int	11	0	ODRF	-1		Allow NULL?
85	TotalExpns	Total Expenses	num	19	6				Allow NULL?
86	TotalExpFC	Total Expenses (FC)	num	19	6				Allow NULL?
87	TotalExpSC	Total Expenses (SC)	num	19	6				Allow NULL?
88	DunnLevel	Dunning Level	int	11	0	ODUN			Allow NULL?
89	Address2	Ship to	nvarchar	254	0				Allow NULL?
90	LogInstanc	Log Instance	int	6	0		0		Allow NULL?
91	Exported	Exported	char	1	0		N	N, Y	Allow NULL?
92	StationID	Workstation ID	int	11	0	CSTN			Allow NULL?
93	Indicator	Indicator	nvarchar	2	0	OIDC			Allow NULL?
94	NetProc	Net Procedure	char	1	0		N	N, Y	Allow NULL?
95	AqcsTax	Acquisition Tax	num	19	6				Allow NULL?
96	AqcsTaxFC	Acquisition Tax (FC)	num	19	6				Allow NULL?
97	AqcsTaxSC	Acquisition Tax (SC)	num	19	6				Allow NULL?
98	CashDiscPr	Cash Discount Percentage	num	19	6				Allow NULL?
99	CashDiscnt	Cash Discount	num	19	6				Allow NULL?
100	CashDiscFC	Cash Discount (FC)	num	19	6				Allow NULL?
101	CashDiscSC	Cash Discount (SC)	num	19	6				Allow NULL?
102	ShipToCode	Ship-to Code	nvarchar	50	0				Allow NULL?
103	LicTradNum	Licensed Dealer No.	nvarchar	32	0				Allow NULL?
104	PaymentRef	Payment Reference No.	nvarchar	27	0				Allow NULL?
105	WTSum	Withholding Tax Amount	num	19	6				Allow NULL?
106	WTSumFC	WTax Amount (FC)	num	19	6				Allow NULL?
107	WTSumSC	WTax Amount (SC)	num	19	6				Allow NULL?
108	RoundDif	Rounding Diff. Amount	num	19	6				Allow NULL?
109	RoundDifFC	Rounding Diff. Amount (FC)	num	19	6				Allow NULL?
110	RoundDifSy	Rounding Diff. Amount (SC)	num	19	6				Allow NULL?
111	CheckDigit	Control Digit	char	1	0				Allow NULL?
112	Form1099	1099 Form	int	11	0	OTNN			Allow NULL?
113	Box1099	1099 Box	nvarchar	20	0				Allow NULL?
114	submitted	Submitted	char	1	0		N	N, Y	Allow NULL?
115	PoPrss	PO Process	char	1	0		N	N, Y	Allow NULL?
116	Rounding	Rounding	char	1	0		N	N, Y	Allow NULL?
117	RevisionPo	Split PO	char	1	0		N	N, Y	Allow NULL?
118	Segment	Segment	int	6	0		0		Allow NULL?
119	ReqDate	Required Date	date	8	0
120	CancelDate	Cancellation Date	date	8	0
121	PickStatus	Pick Status	char	1	0		N	N, Y	Allow NULL?
122	Pick	Pick	char	1	0		N	N, Y	Allow NULL?
123	BlockDunn	Block Dunning	char	1	0		N	N, Y	Allow NULL?
124	PeyMethod	Payment Method	nvarchar	15	0	OPYM			Allow NULL?
125	PayBlock	Payment Block	char	1	0		N	N, Y	Allow NULL?
126	PayBlckRef	Payment Block Abs Entry	int	11	0	OPYB			Allow NULL?
127	MaxDscn	Maximum Discount	char	1	0		N	N, Y	Allow NULL?
128	Reserve	Reserved	char	1	0		N	N, Y	Allow NULL?
129	Max1099	Max. 1099 Amount	num	19	6				Allow NULL?
130	CntrlBnk	Central Bank Indicator	nvarchar	15	0	OCBI			Allow NULL?
131	PickRmrk	Pick Remarks	nvarchar	254	0				Allow NULL?
132	ISRCodLine	ISR Coding Line	nvarchar	53	0				Allow NULL?
133	ExpAppl	Exp applied	num	19	6				Allow NULL?
134	ExpApplFC	Exp applied FC	num	19	6				Allow NULL?
135	ExpApplSC	Exp applied DC	num	19	6				Allow NULL?
136	Project	Project Code	nvarchar	20	0	OPRJ			Allow NULL?
137	DeferrTax	Deferred Tax	char	1	0			N, Y	Allow NULL?
138	LetterNum	Tax Exemption Letter No.	nvarchar	20	0				Allow NULL?
139	FromDate	Exemption Validity Date From	date	8	0
140	ToDate	Exemption Validity Date To	date	8	0
141	WTApplied	Applied Withholding Tax	num	19	6				Allow NULL?
142	WTAppliedF	Applied WTax (FC)	num	19	6				Allow NULL?
143	BoeReserev	Bill of Exchange Reserved	char	1	0		N	N, Y	Allow NULL?
144	AgentCode	Agent Code	nvarchar	32	0	OAGP			Allow NULL?
145	WTAppliedS	Applied WTax (SC)	num	19	6				Allow NULL?
146	EquVatSum	Total Equalization Tax	num	19	6				Allow NULL?
147	EquVatSumF	Total Equalization Tax (FC)	num	19	6				Allow NULL?
148	EquVatSumS	Total Equalization Tax (SC)	num	19	6				Allow NULL?
149	Installmnt	No. of Installments	int	6	0		1		Allow NULL?
150	VATFirst	Apply Tax on 1st Installment	char	1	0			N, Y	Allow NULL?
151	NnSbAmnt	WTax Non-Subject Amount	num	19	6				Allow NULL?
152	NnSbAmntSC	WTax Non-Subject Amount (SC)	num	19	6				Allow NULL?
153	NbSbAmntFC	WTax Non-Subject Amount (FC)	num	19	6				Allow NULL?
154	ExepAmnt	Withholding Tax Exempt Amount	num	19	6				Allow NULL?
155	ExepAmntSC	WTax Exempt Amount (FC)	num	19	6				Allow NULL?
156	ExepAmntFC	WTax Exempt Amount (FC)	num	19	6				Allow NULL?
157	VatDate	VAT Date	date	8	0
158	CorrExt	External Corrected Document No.	nvarchar	25	0				Allow NULL?
159	CorrInv	Internal Corrected Document No.	int	11	0				Allow NULL?
160	NCorrInv	Next Correcting Document	int	11	0				Allow NULL?
161	CEECFlag	Block Creation Target Corr Inv	char	1	0		N	N, Y	Allow NULL?
162	BaseAmnt	Base Amount	num	19	6				Allow NULL?
163	BaseAmntSC	Base Amount (SC)	num	19	6				Allow NULL?
164	BaseAmntFC	Base Amount (FC)	num	19	6				Allow NULL?
165	CtlAccount	Control Account	nvarchar	15	0	OACT			Allow NULL?
166	BPLId	Branch	int	11	0	OBPL			Allow NULL?
167	BPLName	Branch Name	nvarchar	100	0				Allow NULL?
168	VATRegNum	VAT Registration Number	nvarchar	32	0				Allow NULL?
169	TxInvRptNo	Tax Invoice Rpt Number	nvarchar	10	0				Allow NULL?
170	TxInvRptDt	Tax Invoice Rpt Date	date	8	0
171	KVVATCode	VAT Code for Tax Invoice Rpt	text	16	0
172	WTDetails	Withholding Tax Details	nvarchar	100	0				Allow NULL?
173	SumAbsId	Summary VAT Abstract ID	int	11	0		-1		Allow NULL?
174	SumRptDate	Summary VAT Report Date	date	8	0
175	PIndicator	Period Indicator	nvarchar	10	0	OPID			Allow NULL?
176	ManualNum	Manual Number	nvarchar	20	0				Allow NULL?
177	UseShpdGd	Use Shipped Goods Account	char	1	0		N	N, Y	Allow NULL?
178	BaseVtAt	BPL ID Assigned to Invoice	num	19	6				Allow NULL?
179	BaseVtAtSC	BPL Name	num	19	6				Allow NULL?
180	BaseVtAtFC	Tax Reg. Number	num	19	6				Allow NULL?
181	NnSbVAt	Tax Invoice Rpt Number	num	19	6				Allow NULL?
182	NnSbVAtSC	Tax Invoice Rpt Date	num	19	6				Allow NULL?
183	NbSbVAtFC	WTax Amount - VAT-exempt	num	19	6				Allow NULL?
184	ExptVAt	WTax Amount - VAT-exempt	num	19	6				Allow NULL?
185	ExptVAtSC	WTax Exempted VAT Amount (SC)	num	19	6				Allow NULL?
186	ExptVAtFC	Withholding Tax Details	num	19	6				Allow NULL?
187	LYPmtAt	Last Year's Payments	num	19	6				Allow NULL?
188	LYPmtAtSC	Last Years Payments (SC)	num	19	6				Allow NULL?
189	LYPmtAtFC	Summary Tax Report Date	num	19	6				Allow NULL?
190	ExpAnSum	Period Indicator	num	19	6				Allow NULL?
191	ExpAnSys	Manual Number	num	19	6				Allow NULL?
192	ExpAnFrgn	Use Shipped Goods Account	num	19	6				Allow NULL?
193	DocSubType	VAT Code for Tax Invoice Rpt	nvarchar	2	0		--	--	Allow NULL?
194	DpmStatus	Summary VAT Abstract ID	char	1	0		O	C, O	Allow NULL?
195	DpmAmnt	Down Payment Amount LC	num	19	6				Allow NULL?
196	DpmAmntSC	Down Payment Amount SC	num	19	6				Allow NULL?
197	DpmAmntFC	Down Payment Amount FC	num	19	6				Allow NULL?
198	DpmDrawn	Drawn to Down Payment	char	1	0		N	N, Y	Allow NULL?
199	DpmPrcnt	Down Payment Percent	num	19	6				Allow NULL?
200	PaidSum	Total Paid Sum	num	19	6				Allow NULL?
201	PaidSumFc	Total Paid Sum (FC)	num	19	6				Allow NULL?
202	PaidSumSc	Total Paid Sum (SC)	num	19	6				Allow NULL?
203	FolioPref	Folio Prefix String	nvarchar	2	0				Allow NULL?
204	FolioNum	Folio Number	int	11	0				Allow NULL?
205	DpmAppl	Down Payment Applied LC	num	19	6				Allow NULL?
206	DpmApplFc	Down Payment Applied FC	num	19	6				Allow NULL?
207	DpmApplSc	Down Payment Applied SC	num	19	6				Allow NULL?
208	LPgFolioN	Folio No. for Last Page in Doc.	int	11	0				Allow NULL?
209	Header	Header	text	16	0
210	Footer	Footer	text	16	0
211	Posted	Down Payment Was Posted	char	1	0		Y	N, Y	Allow NULL?
212	OwnerCode	Document Owner	int	11	0	OHEM			Allow NULL?
213	BPChCode	BP Channel Code	nvarchar	15	0	OCRD			Allow NULL?
214	BPChCntc	BP Channel Contact Person	int	11	0	OCPR			Allow NULL?
215	PayToCode	Pay to	nvarchar	50	0				Allow NULL?
216	IsPaytoBnk	Is Pay to Bank	char	1	0			N, Y	Allow NULL?
217	BnkCntry	Pay to Bank Country	nvarchar	3	0	OCRY			Allow NULL?
218	BankCode	Pay to Bank Code	nvarchar	30	0				Allow NULL?
219	BnkAccount	Pay to Bank Account No.	nvarchar	50	0				Allow NULL?
220	BnkBranch	Pay to Bank Branch	nvarchar	50	0				Allow NULL?
221	isIns	Reserve Invoice	char	1	0		N	N, Y	Allow NULL?
222	TrackNo	Tracking Number	nvarchar	30	0				Allow NULL?
223	VersionNum	Version Number	nvarchar	11	0				Allow NULL?
224	LangCode	Language Code	int	11	0	OLNG			Allow NULL?
225	BPNameOW	BP_NAME_OVERWRITTEN	char	1	0		N	N, Y	Allow NULL?
226	BillToOW	BILL_TO_OVERWRITTEN	char	1	0		N	N, Y	Allow NULL?
227	ShipToOW	SHIP_TO_OVERWRITTEN	char	1	0		N	N, Y	Allow NULL?
228	RetInvoice	Credit Memo	char	1	0		N	N, Y	Allow NULL?
229	ClsDate	Document Closing Date	date	8	0
230	MInvNum	Monthly Invoice No.	int	11	0				Allow NULL?
231	MInvDate	Monthly Invoice Date	date	8	0
232	SeqCode	Sequence Code	int	6	0				Allow NULL?
233	Serial	Serial Number	int	11	0				Allow NULL?
234	SeriesStr	Series String	nvarchar	3	0				Allow NULL?
235	SubStr	Subseries String	nvarchar	3	0				Allow NULL?
236	Model	Nota Fiscal Model	nvarchar	6	0	ONFM	0		Allow NULL?
237	TaxOnExp	Tax On Expenses Sum	num	19	6				Allow NULL?
238	TaxOnExpFc	Tax On Expenses Sum (FC)	num	19	6				Allow NULL?
239	TaxOnExpSc	Tax On Expenses Sum (SC)	num	19	6				Allow NULL?
240	TaxOnExAp	Tax On Expenses Applied	num	19	6				Allow NULL?
241	TaxOnExApF	Tax on Freight Applied (FC)	num	19	6				Allow NULL?
242	TaxOnExApS	Tax on Freight Applied (SC)	num	19	6				Allow NULL?
243	LastPmnTyp	Last Payment Type	char	1	0			R, V	Allow NULL?
244	LndCstNum	Landed Cost Number	int	11	0				Allow NULL?
245	UseCorrVat	Use Correction VAT Group	char	1	0		N	N, Y	Allow NULL?
246	BlkCredMmo	Block Creating Credit Memo Tgt	char	1	0		N	N, Y	Allow NULL?
247	OpenForLaC	Open for Landed Costs	char	1	0		Y	N, Y	Allow NULL?
248	Excised	Excised	char	1	0		O	C, O	Allow NULL?
249	ExcRefDate	Excise Ref. Date	date	8	0
250	ExcRmvTime	Excise Removal Time	nvarchar	8	0				Allow NULL?
251	SrvGpPrcnt	Gross Profit Prcnt of Service	num	19	6				Allow NULL?
252	DepositNum	Deposit Number	int	11	0				Allow NULL?
253	CertNum	Certificate Number	nvarchar	31	0				Allow NULL?
254	DutyStatus	Duty Status	char	1	0		Y	N, Y	Allow NULL?
255	AutoCrtFlw	Auto Create Follow-up Document	char	1	0		N	N, Y	Allow NULL?
256	FlwRefDate	Follow-up Document Ref. Date	date	8	0
257	FlwRefNum	Follow-up Document Ref. Number	nvarchar	100	0				Allow NULL?
258	VatJENum	VAT Journal Entry Number	int	11	0		-1		Allow NULL?
259	DpmVat	Down Payment Tax LC	num	19	6				Allow NULL?
260	DpmVatFc	Down Payment Tax FC	num	19	6				Allow NULL?
261	DpmVatSc	Down Payment Tax SC	num	19	6				Allow NULL?
262	DpmAppVat	Down Payment Applied Tax LC	num	19	6				Allow NULL?
263	DpmAppVatF	Down Payment Applied Tax FC	num	19	6				Allow NULL?
264	DpmAppVatS	Down Payment Applied Tax SC	num	19	6				Allow NULL?
265	InsurOp347	347 Insurance Operation	char	1	0		N	N, Y	Allow NULL?
266	IgnRelDoc	Ignore Relevant Doc on Archive	char	1	0		N	N, Y	Allow NULL?
267	BuildDesc	Build Descriptor	nvarchar	50	0				Allow NULL?
268	ResidenNum	Residence Number	char	1	0		1	1, 2, 3, 4, 5, 6	Allow NULL?
269	Checker	Checker	int	11	0	OHEM			Allow NULL?
270	Payee	Payee	int	11	0	OHEM			Allow NULL?
271	CopyNumber	Copy Number	int	11	0		0		Allow NULL?
272	SSIExmpt	SSI Exemption	char	1	0			N, Y	Allow NULL?
273	PQTGrpSer	Pur Quotation Group Series	int	6	0				Allow NULL?
274	PQTGrpNum	Pur Quotation Group Number	int	11	0				Allow NULL?
275	PQTGrpHW	Pur Quotation Group Manual	char	1	0		N	N, Y	Allow NULL?
276	ReopOriDoc	Reopen Origin. Order by Return	char	1	0			N, Y	Allow NULL?
277	ReopManCls	Reop. Man. Closed/Canc. Orders	char	1	0			N, Y	Allow NULL?
278	DocManClsd	Document Was Closed Manually	char	1	0		N	N, U, Y	Allow NULL?
279	ClosingOpt	Closing Option	int	6	0		1		Allow NULL?
280	SpecDate	Posting Date Specified by User	date	8	0
281	Ordered	Payment Ordered	char	1	0		N	N, Y	Allow NULL?
282	NTSApprov	NTS Approved	char	1	0		N	N, Y	Allow NULL?
283	NTSWebSite	E-Tax Web Site	int	6	0	OTWS			Allow NULL?
284	NTSeTaxNo	E-Tax Number	nvarchar	50	0				Allow NULL?
285	NTSApprNo	NTS Approval Number	nvarchar	50	0				Allow NULL?
286	PayDuMonth	Start From	char	1	0			E, H, N, Y	Allow NULL?
287	ExtraMonth	Number of Additional Months	int	6	0				Allow NULL?
288	ExtraDays	Number of Additional Days	int	6	0				Allow NULL?
289	CdcOffset	Cash Discount Offset	int	6	0		0		Allow NULL?
290	SignMsg	Signature Input Message	text	16	0
291	SignDigest	Signature Digest	text	16	0
292	CertifNum	Certification Number	nvarchar	50	0				Allow NULL?
293	KeyVersion	Private Key Version	int	11	0				Allow NULL?
294	EDocGenTyp	Electr. Doc. Generation Type	char	1	0		N	G, L, N	Allow NULL?
295	ESeries	Electronic Series	int	6	0	NNM4			Allow NULL?
296	EDocNum	Electronic Document Number	nvarchar	50	0				Allow NULL?
297	EDocExpFrm	Electronic Doc. Export Format	int	11	0				Allow NULL?
298	OnlineQuo	Create Online Quotation	char	1	0		N	N, Y	Allow NULL?
299	POSEqNum	POS Equipment Number	nvarchar	20	0				Allow NULL?
300	POSManufSN	POS Manufacturer Serial Number	nvarchar	20	0				Allow NULL?
301	POSCashN	POS Cashier Number	int	11	0				Allow NULL?
302	EDocStatus	Electronic Document Status	char	1	0		C	C, E, N, P, S	Allow NULL?
303	EDocCntnt	Electronic Document Content	text	16	0
304	EDocProces	Electronic Document Process	char	1	0		C	C, I	Allow NULL?
305	EDocErrCod	Electronic Document Error Code	nvarchar	50	0				Allow NULL?
306	EDocErrMsg	Electronic Document Error Msg	text	16	0
307	EDocCancel	Electronic Document - Canceled	char	1	0		N	N, Y	Allow NULL?
308	EDocTest	Electronic Document - Testing	char	1	0		N	N, Y	Allow NULL?
309	EDocPrefix	Electronic Document - Prefix	nvarchar	10	0				Allow NULL?
310	CUP	Unique Code of Project	int	11	0	OCUP			Allow NULL?
311	CIG	Contract Code Identification	int	11	0	OCIG			Allow NULL?
312	DpmAsDscnt	Discount Document with Dpm	char	1	0		N	N, Y	Allow NULL?
313	Attachment	Attachment	text	16	0
314	AtcEntry	Attachment Entry	int	11	0				Allow NULL?
315	SupplCode	Supplementary Code	nvarchar	254	0				Allow NULL?
316	GTSRlvnt	Relevant To GTS	char	1	0		N	N, Y	Allow NULL?

TOP B1 8.82 | OCSI INDEXES

Name	Primary	Unique	Columns
PRIMARY	No	Yes	DocEntry
AT_CARD	No	No	NumAtCard, CardCode
CUSTOMER	No	No	CardCode
NUM	No	Yes	DocNum, Instance, Segment, DocSubType, PIndicator
DOC_STATUS	No	No	DocStatus, CANCELED
FTHR_CARD	No	No	FatherCard, FatherType
SERIES	No	No	Series
OWNER_CODE	No	No	OwnerCode
DATE_PIND	No	No	DocDate, PIndicator
ESERIES	No	No	ESeries, EDocNum

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

316 COLUMNS | 10 INDEXES | B1 8.82 | OCSI TABLE

TOP B1 8.82 | OCSI COLUMNS

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

316 COLUMNS | 10 INDEXES | B1 8.82 | OCSI TABLE

TOPB1 8.82 | OCSI COLUMNS

TOPB1 8.82 | OCSI INDEXES

TOP B1 8.82 | OCSI COLUMNS

TOP B1 8.82 | OCSI INDEXES