	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

424 COLUMNS | 10 INDEXES | B1 9.3 | OPQT TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Marketing Documents
1	Business One	9.3	OPQT	424	10	Purchase Quotation	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, BaseDisc, BaseDiscSc, BaseDiscFc, BaseDiscPr, CreateTS, UpdateTS, SrvTaxRule, AnnInvDecR, Supplier, Releaser, Receiver, ToWhsCode, AssetDate, Requester, ReqName, Branch, Department, Email, Notify, ReqType, OriginType, IsReuseNum, IsReuseNFN, DocDlvry, PaidDpm, PaidDpmF, PaidDpmS, EnvTypeNFe, AgrNo, IsAlt, AltBaseTyp, AltBaseEnt, AuthCode, StDlvDate, StDlvTime, EndDlvDate, EndDlvTime, VclPlate, ElCoStatus, AtDocType, ElCoMsg, PrintSEPA, FreeChrg, FreeChrgFC, FreeChrgSC, NfeValue, FiscDocNum, RelatedTyp, RelatedEnt, CCDEntry, NfePrntFo, ZrdAbs, POSRcptNo, FoCTax, FoCTaxFC, FoCTaxSC, TpCusPres, ExcDocDate, FoCFrght, FoCFrghtFC, FoCFrghtSC, InterimTyp, PTICode, Letter, FolNumFrom, FolNumTo, FolSeries, SplitTax, SplitTaxFC, SplitTaxSC, ToBinCode, PriceMode, PoDropPrss, PermitNo, MYFtype, DocTaxID, DateReport, RepSection, ExclTaxRep, PosCashReg, DmpTransID, ECommerBP, EComerGSTN, Revision, RevRefNo, RevRefDate, RevCreRefN, RevCreRefD, TaxInvNo, FrmBpDate, GSTTranTyp, BaseType, BaseEntry, ComTrade, UseBilAddr, IssReason, ComTradeRt, SplitPmnt, SOIWizId, SelfPosted, EnBnkAcct, EncryptIV, DPPStatus, EWBGenType, SAPPassprt, CtActTax, CtActTaxFC, CtActTaxSC FROM OPQT

TOP B1 9.3 | OPQT 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=Item, S=Service	Allow NULL?
4	CANCELED	Canceled	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	Year Transfer	char	1	0		N	N=No, Y=Yes	Allow NULL?
10	ObjType	Object Type	nvarchar	20	0	ADP1	540000006	540000006=Purchase Quotation	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 in 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				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	11	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	Warehouse 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 in SC	num	19	6				Allow NULL?
59	DocTotalSy	Document Total in SC	num	19	6				Allow NULL?
60	PaidSys	Paid in 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 in 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=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	11	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 in 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=Canceled, 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 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				Allow NULL?
89	Address2	Ship To	nvarchar	254	0				Allow NULL?
90	LogInstanc	Log Instance	int	11	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 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=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 PO	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	Cancelation 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	20	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 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=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	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=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	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=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		--	--=Purchase Order	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	4	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=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	Credit Memo	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	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=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				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=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, 7=Not Registered	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=No, Y=Yes	Allow NULL?
273	PQTGrpSer	Pur Quotation Group Series	int	11	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=No, Y=Yes	Allow NULL?
276	ReopOriDoc	Reopen Origin. Order by Return	char	1	0			N=No, Y=Yes	Allow NULL?
277	ReopManCls	Reop. Man. Closed/Canc. Orders	char	1	0			N=No, Y=Yes	Allow NULL?
278	DocManClsd	Document Was Closed Manually	char	1	0		N	N=No, U=Unknown, Y=Yes	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=No, Y=Yes	Allow NULL?
282	NTSApprov	NTS Approved	char	1	0		N	N=No, Y=Yes	Allow NULL?
283	NTSWebSite	NTS Web Site	int	6	0	OTWS			Allow NULL?
284	NTSeTaxNo	NTS 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=Month End, H=Half Month, N, Y=Month Start	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=Generate, L=Generate - Later, N=Not Relevant, R=Send - Later, S=Send	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=No, Y=Yes	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=OK, E=Error, N=New, P=Pending, S=Sent	Allow NULL?
303	EDocCntnt	Electronic Document Content	text	16	0
304	EDocProces	Electronic Document Process	char	1	0		C	C=CFD, I=CFDI	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=No, Y=Yes	Allow NULL?
308	EDocTest	Electronic Document - Testing	char	1	0		N	N=No, Y=Yes	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=No, Y=Yes	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=No, Y=Yes	Allow NULL?
317	BaseDisc	Base Discount LC	num	19	6				Allow NULL?
318	BaseDiscSc	Base Discount SC	num	19	6				Allow NULL?
319	BaseDiscFc	Base Discount FC	num	19	6				Allow NULL?
320	BaseDiscPr	Base Discount Percentage	num	19	6				Allow NULL?
321	CreateTS	Creatn Time - Incl. Secs	int	11	0				Allow NULL?
322	UpdateTS	Update Full Time	int	11	0				Allow NULL?
323	SrvTaxRule	Apply Service Tax Rule	char	1	0		N	N=No, Y=Yes	Allow NULL?
324	AnnInvDecR	Annual Inv. Declaration Ref.	int	11	0				Allow NULL?
325	Supplier	Supplier	nvarchar	15	0	OCRD			Allow NULL?
326	Releaser	Goods Distribution Approver	int	11	0	OHEM			Allow NULL?
327	Receiver	Goods Release Approver	int	11	0	OHEM			Allow NULL?
328	ToWhsCode	To Warehouse Code	nvarchar	8	0	OWHS			Allow NULL?
329	AssetDate	Fixed Asset Value Date	date	8	0
330	Requester	User Requesting Goods	nvarchar	25	0				Allow NULL?
331	ReqName	User Name	nvarchar	155	0				Allow NULL?
332	Branch	Branch	int	6	0	OUBR			Allow NULL?
333	Department	Department	int	6	0	OUDP			Allow NULL?
334	Email	E-Mail	nvarchar	100	0				Allow NULL?
335	Notify	Send Notification Needed	char	1	0			N=No, Y=Yes	Allow NULL?
336	ReqType	Requester Type User/Employee	int	11	0		12	12=User, 171=Employee	Allow NULL?
337	OriginType	Document Origin	char	1	0		M	D=Document Generation Wizard, M=Manual, R=MRP, S=Sales Order	Allow NULL?
338	IsReuseNum	Is Reusing Document Number	char	1	0		N	N=No, Y=Yes	Allow NULL?
339	IsReuseNFN	Is Reusing Nota Fiscal Number	char	1	0		N	N=No, Y=Yes	Allow NULL?
340	DocDlvry	Document Delivery	char	1	0			0=None, 1=Create Online Document, 2=Post to Ariba Network	Allow NULL?
341	PaidDpm	Paid by Down Payment	num	19	6				Allow NULL?
342	PaidDpmF	Paid by Down Payment (FC)	num	19	6				Allow NULL?
343	PaidDpmS	Paid by Down Payment (SC)	num	19	6				Allow NULL?
344	EnvTypeNFe	Environment Type NF-e	int	11	0	OBNI	-1		Allow NULL?
345	AgrNo	Agreement No.	int	11	0				Allow NULL?
346	IsAlt	Is Alteration	char	1	0		N	N=No, Y=Yes	Allow NULL?
347	AltBaseTyp	Alteration Base Type	int	11	0		-1	-1, 13, 163, 165, 18	Allow NULL?
348	AltBaseEnt	Alteration Base Entry	int	11	0				Allow NULL?
349	AuthCode	Authorization Code	nvarchar	250	0				Allow NULL?
350	StDlvDate	Start Delivery Date	date	8	0
351	StDlvTime	Start Delivery Time	int	11	0				Allow NULL?
352	EndDlvDate	End Delivery Date	date	8	0
353	EndDlvTime	End Delivery Time	int	11	0				Allow NULL?
354	VclPlate	Vehicle Plate	nvarchar	20	0				Allow NULL?
355	ElCoStatus	Elec. Comm. Status	nvarchar	10	0			0=Approved, 1=Pending Approval, 2=Rejected	Allow NULL?
356	AtDocType	AT Document Type	nvarchar	2	0			FR=FR, FS=FS, FT=FT, GA=GA, GC=GC, GD=GD, GR=GR, GT=GT, NC=NC, ND=ND	Allow NULL?
357	ElCoMsg	Elec. Comm. Message	nvarchar	254	0				Allow NULL?
358	PrintSEPA	Print SEPA Direct Debit Prenotification	char	1	0		N	N=No, Y=Yes	Allow NULL?
359	FreeChrg	Free of Charge BP	num	19	6				Allow NULL?
360	FreeChrgFC	Free of Charge BP FC	num	19	6				Allow NULL?
361	FreeChrgSC	Free of Charge BP SC	num	19	6				Allow NULL?
362	NfeValue	NF-e Value	num	19	6				Allow NULL?
363	FiscDocNum	Fiscal Document Number	nvarchar	100	0				Allow NULL?
364	RelatedTyp	Related Type	int	11	0		-1	-1	Allow NULL?
365	RelatedEnt	Related Entry	int	11	0				Allow NULL?
366	CCDEntry	CCD Abs. Entry	int	11	0				Allow NULL?
367	NfePrntFo	NF-e Printing Format	int	11	0		0	0=No DANFE, 1=Portrait, 2=Landscape, 3=Simplified, 4=DANFE NFC-e, 5=Mail	Allow NULL?
368	ZrdAbs	POS Daily Summary Number	int	11	0	OZRD			Allow NULL?
369	POSRcptNo	POS Receipt Number	int	11	0				Allow NULL?
370	FoCTax	Free of Charge BP Tax	num	19	6				Allow NULL?
371	FoCTaxFC	Free of Charge BP Tax FC	num	19	6				Allow NULL?
372	FoCTaxSC	Free of Charge BP Tax SC	num	19	6				Allow NULL?
373	TpCusPres	Type of End-User Presence	int	11	0	OBNI			Allow NULL?
374	ExcDocDate	Excise Doc. Date	date	8	0
375	FoCFrght	Free of Charge Freight	num	19	6				Allow NULL?
376	FoCFrghtFC	Free of Charge Freight FC	num	19	6				Allow NULL?
377	FoCFrghtSC	Free of Charge Freight SC	num	19	6				Allow NULL?
378	InterimTyp	Interim Type	int	6	0		0	0=None	Allow NULL?
379	PTICode	POI Code	nvarchar	5	0	OPTI			Allow NULL?
380	Letter	Letter	char	1	0				Allow NULL?
381	FolNumFrom	Folio Number From	int	11	0				Allow NULL?
382	FolNumTo	Folio Number To	int	11	0				Allow NULL?
383	FolSeries	Folio Series	int	11	0	OFNS			Allow NULL?
384	SplitTax	Split Payment Tax	num	19	6				Allow NULL?
385	SplitTaxFC	Split Payment Tax FC	num	19	6				Allow NULL?
386	SplitTaxSC	Split Payment Tax SC	num	19	6				Allow NULL?
387	ToBinCode	To Bin Location	nvarchar	228	0				Allow NULL?
388	PriceMode	Price Mode	char	1	0			G=Gross, M=Net and Gross, N=Net	Allow NULL?
389	PoDropPrss	PO Drop-Ship Process	char	1	0		N	N=No, Y=Yes	Allow NULL?
390	PermitNo	Permit Number	nvarchar	20	0				Allow NULL?
391	MYFtype	MYF type	nvarchar	2	0			P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales	Allow NULL?
392	DocTaxID	Document Tax ID	nvarchar	32	0				Allow NULL?
393	DateReport	Date of Reporting	date	8	0
394	RepSection	Reporting Section	nvarchar	3	0				Allow NULL?
395	ExclTaxRep	Exclude from Control Statement	char	1	0		N	N=No, Y=Yes	Allow NULL?
396	PosCashReg	POS/Cash Register	int	11	0				Allow NULL?
397	DmpTransID	Trans ID for Down Payment	nvarchar	20	0				Allow NULL?
398	ECommerBP	E-Commerce Operator	nvarchar	15	0	OCRD			Allow NULL?
399	EComerGSTN	GST Regn No of E-Commerce	nvarchar	15	0				Allow NULL?
400	Revision	Revision	char	1	0		N	N=No, Y=Yes	Allow NULL?
401	RevRefNo	Original Ref. No.	nvarchar	100	0				Allow NULL?
402	RevRefDate	Original Ref. Date	date	8	0
403	RevCreRefN	Original Credit/Debit Ref. No.	nvarchar	100	0				Allow NULL?
404	RevCreRefD	Orign Credit/Debit Ref. Date	date	8	0
405	TaxInvNo	Tax Invoice No.	nvarchar	100	0				Allow NULL?
406	FrmBpDate	From Vendor Date	date	8	0
407	GSTTranTyp	GST Transaction Type	nvarchar	2	0			--=Bill of Supply, GA=GST Tax Invoice, GD=GST Debit Memo	Allow NULL?
408	BaseType	Base Document Type	int	11	0		-1	-1	Allow NULL?
409	BaseEntry	Base Document Internal Key	int	11	0				Allow NULL?
410	ComTrade	Commission Trade	char	1	0		E	C=Consignor, E, P=Purchase Agent, S=Sales Agent	Allow NULL?
411	UseBilAddr	Determine GST by Using Bill to	char	1	0			N=No, Y=Yes	Allow NULL?
412	IssReason	Reason for issuing note	int	6	0		1	1=Sales Return, 2=Post sale discount, 3=Deficiency in service, 4=Correction in invoice, 5=Change in POS, 6=Finalization of Provisional Assessment, 7=Others	Allow NULL?
413	ComTradeRt	Commission Trade Return	char	1	0		N	N=No, Y=Yes	Allow NULL?
414	SplitPmnt	A/P Split Payment	char	1	0		N	N=No, Y=Yes	Allow NULL?
415	SOIWizId	SOI Wizard ID	int	11	0	OSOI			Allow NULL?
416	SelfPosted	Self Invoice Created [Yes/No]	char	1	0		N	N=No, Y=Yes	Allow NULL?
417	EnBnkAcct	Encryption of Pay to Bank Acct	text	16	0
418	EncryptIV	Encrypt IV	nvarchar	100	0				Allow NULL?
419	DPPStatus	Data Protection Status	char	1	0		N	D=Erased, N=None	Allow NULL?
420	EWBGenType	E-Way Bill Generation Type	char	1	0		N	G=Generate, L=Generate - Later, N=Not Relevant	Allow NULL?
421	SAPPassprt	Extended SAP Passport	text	16	0
422	CtActTax	Customer Accounting Tax	num	19	6				Allow NULL?
423	CtActTaxFC	Customer Accounting Tax (FC)	num	19	6				Allow NULL?
424	CtActTaxSC	Customer Accounting Tax (SC)	num	19	6				Allow NULL?

TOP B1 9.3 | OPQT 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

424 COLUMNS | 10 INDEXES | B1 9.3 | OPQT TABLE

TOP B1 9.3 | OPQT COLUMNS

TOP B1 9.3 | OPQT 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

424 COLUMNS | 10 INDEXES | B1 9.3 | OPQT TABLE

TOPB1 9.3 | OPQT COLUMNS

TOPB1 9.3 | OPQT INDEXES

TOP B1 9.3 | OPQT COLUMNS

TOP B1 9.3 | OPQT INDEXES