	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

268 COLUMNS | 9 INDEXES | B1 8.8 | OPCH TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Marketing Documents
1	Business One	8.8	OPCH	268	9	A/P 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 FROM OPCH

TOP B1 8.8 | OPCH COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	DocEntry	Internal Number	int	11	0				Allow NULL?
2	DocNum	Document Number	int	11	0				Allow NULL?
3	DocType	Document Type	char	1	0		I	I=Item, S=Service	Allow NULL?
4	CANCELED	Cancelled	char	1	0		N	N=No, Y=Yes	Allow NULL?
5	Handwrtten	Manual Numbering	char	1	0		N	N=No, Y=Yes	Allow NULL?
6	Printed	Printed	char	1	0		N	A=Amended, N=Original, Y=Copy	Allow NULL?
7	DocStatus	Document Status	char	1	0		O	C=Closed, O=Open	Allow NULL?
8	InvntSttus	Warehouse Status	char	1	0		O	C=Closed, O=Open	Allow NULL?
9	Transfered	Transfer Year	char	1	0		N	N=No, Y=Yes	Allow NULL?
10	ObjType	Object Type	nvarchar	20	0		18	18=A/P Invoice	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	Shipping Type	int	6	0	OSHP	-1		Allow NULL?
41	PartSupply	Partial Delivery	char	1	0		Y	N=No, Y=Yes	Allow NULL?
42	Confirmed	Confirmed	char	1	0		Y	N=No, Y=Yes	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=No, Y=Yes	Allow NULL?
46	SummryType	Summary Method	char	1	0		N	D=By Documents, I=By Items, N=No Summary	Allow NULL?
47	UpdInvnt	Whse Update	char	1	0		N	C=Customer Orders, G=Consignment, I=Stock, N=No, O=Orders from Vendors	Allow NULL?
48	UpdCardBal	Update Balances	char	1	0		N	B=Bookkeeping, D=Delivery Notes, N=No, O=Orders	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=Receipt, X=Release	Allow NULL?
52	CntctCode	Contact Person	int	11	0	OCPR			Allow NULL?
53	ShowSCN	Display BP Catalog Number	char	1	0		N	N=No, Y=Yes	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=BP Currency, L=Local Currency, S=System Currency	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=Delivery Consolidation, P=Payment Consolidation	Allow NULL?
62	GrosProfSy	Gross Profit (SC)	num	19	6				Allow NULL?
63	UpdateDate	Update Date	date	8	0
64	IsICT	A/R Invoice + Payment	char	1	0		N	N=No, Y=Yes	Allow NULL?
65	CreateDate	Creation Date	date	8	0
66	Volume	Volume	num	19	6				Allow NULL?
67	VolUnit	Volume UoM	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=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade	Allow NULL?
74	StampNum	Stamp No.	nvarchar	16	0				Allow NULL?
75	isCrin	Corrected Invoice	char	1	0		N	N=No, Y=Yes	Allow NULL?
76	FinncPriod	Posting Period	int	11	0	OFPR			Allow NULL?
77	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
78	selfInv	Autom. Invoice	char	1	0		N	N=No, Y=Yes	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		-	-=Without, A=Generated by Authorizer, C=Cancelled, N=Rejected, P=Generated, W=Pending, Y=Approved	Allow NULL?
84	draftKey	Document Draft Internal ID	int	11	0	ODRF	-1		Allow NULL?
85	TotalExpns	Total Freight Charges	num	19	6				Allow NULL?
86	TotalExpFC	Total Freight Charges (FC)	num	19	6				Allow NULL?
87	TotalExpSC	Total Freight Charges (SC)	num	19	6				Allow NULL?
88	DunnLevel	Dunning Level	int	11	0				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=No, Y=Yes	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=No, Y=Yes	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	nvarchar	27	0				Allow NULL?
105	WTSum	WTax 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=No, Y=Yes	Allow NULL?
115	PoPrss	PO Process	char	1	0		N	N=No, Y=Yes	Allow NULL?
116	Rounding	Rounding	char	1	0		N	N=No, Y=Yes	Allow NULL?
117	RevisionPo	Split Purchase Order	char	1	0		N	N=No, Y=Yes	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=No, Y=Yes	Allow NULL?
122	Pick	Pick	char	1	0		N	N=No, Y=Yes	Allow NULL?
123	BlockDunn	Block Dunning	char	1	0		N	N=No, Y=Yes	Allow NULL?
124	PeyMethod	Payment Method	nvarchar	15	0	OPYM			Allow NULL?
125	PayBlock	Payment Block	char	1	0		N	N=No, Y=Yes	Allow NULL?
126	PayBlckRef	Payment Block Abs Entry	int	11	0	OPYB			Allow NULL?
127	MaxDscn	Maximum Discount	char	1	0		N	N=No, Y=Yes	Allow NULL?
128	Reserve	Reserve	char	1	0		N	N=No, Y=Yes	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	8	0	OPRJ			Allow NULL?
137	DeferrTax	Deferred Tax	char	1	0			N=No, Y=Yes	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 WTax	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=No, Y=Yes	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=No, Y=Yes	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	WTax Exempt Amount	num	19	6				Allow NULL?
155	ExepAmntSC	WTax Exempt Amount (SC)	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.ÌCorrExt	nvarchar	25	0				Allow NULL?
159	CorrInv	Internal Corrected Document No.ÌCorrInv	int	11	0				Allow NULL?
160	NCorrInv	Next Correcting Document	int	11	0				Allow NULL?
161	CEECFlag	A/P Correction Invoice	char	1	0		N	N=No, Y=Yes	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	BPL ID Assigned to Invoice	int	11	0				Allow NULL?
167	BPLName	BPL Name	nvarchar	20	0				Allow NULL?
168	VATRegNum	VAT Reg Number	nvarchar	12	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	WTax Details	nvarchar	100	0				Allow NULL?
173	SumAbsId	Summary VAT Abstract ID	int	11	0	OSRT	-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=No, Y=Yes	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 (FC)	num	19	6				Allow NULL?
184	ExptVAt	WTax Exempt VAT Amount	num	19	6				Allow NULL?
185	ExptVAtSC	WTax Exempt 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		--	--=A/P Invoice, DM=A/P Debit Memo, RP=A/P Reserve Invoice	Allow NULL?
194	DpmStatus	Summary VAT Abstract ID	char	1	0		O	C=Closed, O=Open	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=No, Y=Yes	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.ÌLPgFolioN	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=No, Y=Yes	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=No, Y=Yes	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=No, Y=Yes	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=No, Y=Yes	Allow NULL?
226	BillToOW	BILL_TO_OVERWRITTEN	char	1	0		N	N=No, Y=Yes	Allow NULL?
227	ShipToOW	SHIP_TO_OVERWRITTEN	char	1	0		N	N=No, Y=Yes	Allow NULL?
228	RetInvoice	Returning Invoice	char	1	0		N	N=No, Y=Yes	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	10	0		0	0, 10=Model 11, 11=Model 13, 12=Model 14, 13=Model 15, 14=Model 16, 15=Model 17, 16=Model 18, 17=Model 20, 18=Model 21, 19=Model 22, 1=Model 1, 20=Model 25, 21=Nota Fiscal Service, 22=NFFS, 23=RPA, 24=CF, 25=NFSS, 26=R, 27=EXTR, 28=FAT, 29=Model 1F, 2=Model 1-A, 30=Model 1AF, 31=Model 4F, 32=Model 7F, 33=Model 9, 34=Model 21F, 35=Model 22F	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 Expenses Applied (FC)	num	19	6				Allow NULL?
242	TaxOnExApS	Tax On Expenses Applied (SC)	num	19	6				Allow NULL?
243	LastPmnTyp	Last Payment Type	char	1	0			R=Receipt, V=Vendor Payment	Allow NULL?
244	LndCstNum	Landed Cost Number	int	11	0				Allow NULL?
245	UseCorrVat	Use Correction VAT Group	char	1	0		N	N=No, Y=Yes	Allow NULL?
246	BlkCredMmo	Block Creating Credit Memo Tgt	char	1	0		N	N=No, Y=Yes	Allow NULL?
247	OpenForLaC	Open For Landed Costs	char	1	0		Y	N=Closed for Landed Costs, Y=Open for Landed Costs	Allow NULL?
248	Excised	Excised	char	1	0		O	C=Close, O=Open	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		100		Allow NULL?
252	DepositNum	Deposit Number	int	11	0	OVPM			Allow NULL?
253	CertNum	Certificate Number	nvarchar	31	0				Allow NULL?
254	DutyStatus	Duty Status	char	1	0		Y	N=Without Payment of Duty, Y=With Payment of Duty	Allow NULL?
255	AutoCrtFlw	Auto Create Follow-up Document	char	1	0		N	N=No, Y=Yes	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=No, Y=Yes	Allow NULL?
266	IgnRelDoc	Ignore Relevant Doc on Archive	char	1	0		N	N=No, Y=Yes	Allow NULL?
267	BuildDesc	Build Descriptor	nvarchar	50	0				Allow NULL?
268	ResidenNum	Residence Number	char	1	0		1	1=Spanish Fiscal ID, 2=VAT Registration Number, 3=Passport, 4=Fiscal ID Issued by the Residence Country, 5=Certificate of Fiscal Residence, 6=Other Document	Allow NULL?

TOP B1 8.8 | OPCH 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

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

268 COLUMNS | 9 INDEXES | B1 8.8 | OPCH TABLE

TOP B1 8.8 | OPCH COLUMNS

TOP B1 8.8 | OPCH 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

268 COLUMNS | 9 INDEXES | B1 8.8 | OPCH TABLE

TOPB1 8.8 | OPCH COLUMNS

TOPB1 8.8 | OPCH INDEXES

TOP B1 8.8 | OPCH COLUMNS

TOP B1 8.8 | OPCH INDEXES