	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

283 COLUMNS | 10 INDEXES | B1 8.8 | OCRD TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Business Partners
1	Business One	8.8	OCRD	283	10	Business Partner	Business Partners

SQL: selectupdate insert create

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

SELECT CardCode, CardName, CardType, GroupCode, CmpPrivate, Address, ZipCode, MailAddres, MailZipCod, Phone1, Phone2, Fax, CntctPrsn, Notes, Balance, ChecksBal, DNotesBal, OrdersBal, GroupNum, CreditLine, DebtLine, Discount, VatStatus, LicTradNum, DdctStatus, DdctPrcnt, ValidUntil, Chrctrstcs, ExMatchNum, InMatchNum, ListNum, DNoteBalFC, OrderBalFC, DNoteBalSy, OrderBalSy, Transfered, BalTrnsfrd, IntrstRate, Commission, CommGrCode, Free_Text, SlpCode, PrevYearAc, Currency, RateDifAct, BalanceSys, BalanceFC, Protected, Cellular, AvrageLate, City, County, Country, MailCity, MailCounty, MailCountr, E_Mail, Picture, DflAccount, DflBranch, BankCode, AddID, Pager, FatherCard, CardFName, FatherType, QryGroup1, QryGroup2, QryGroup3, QryGroup4, QryGroup5, QryGroup6, QryGroup7, QryGroup8, QryGroup9, QryGroup10, QryGroup11, QryGroup12, QryGroup13, QryGroup14, QryGroup15, QryGroup16, QryGroup17, QryGroup18, QryGroup19, QryGroup20, QryGroup21, QryGroup22, QryGroup23, QryGroup24, QryGroup25, QryGroup26, QryGroup27, QryGroup28, QryGroup29, QryGroup30, QryGroup31, QryGroup32, QryGroup33, QryGroup34, QryGroup35, QryGroup36, QryGroup37, QryGroup38, QryGroup39, QryGroup40, QryGroup41, QryGroup42, QryGroup43, QryGroup44, QryGroup45, QryGroup46, QryGroup47, QryGroup48, QryGroup49, QryGroup50, QryGroup51, QryGroup52, QryGroup53, QryGroup54, QryGroup55, QryGroup56, QryGroup57, QryGroup58, QryGroup59, QryGroup60, QryGroup61, QryGroup62, QryGroup63, QryGroup64, DdctOffice, CreateDate, UpdateDate, ExportCode, DscntObjct, DscntRel, SPGCounter, SPPCounter, DdctFileNo, SCNCounter, MinIntrst, DataSource, OprCount, ExemptNo, Priority, CreditCard, CrCardNum, CardValid, UserSign, LocMth, validFor, validFrom, validTo, frozenFor, frozenFrom, frozenTo, sEmployed, MTHCounter, BNKCounter, DdgKey, DdtKey, ValidComm, FrozenComm, chainStore, DiscInRet, State1, State2, VatGroup, LogInstanc, ObjType, Indicator, ShipType, DebPayAcct, ShipToDef, Block, MailBlock, Password, ECVatGroup, Deleted, IBAN, DocEntry, FormCode, Box1099, PymCode, BackOrder, PartDelivr, DunnLevel, DunnDate, BlockDunn, BankCountr, CollecAuth, DME, InstrucKey, SinglePaym, ISRBillId, PaymBlock, RefDetails, HouseBank, OwnerIdNum, PyBlckDesc, HousBnkCry, HousBnkAct, HousBnkBrn, ProjectCod, SysMatchNo, VatIdUnCmp, AgentCode, TolrncDays, SelfInvoic, DeferrTax, LetterNum, MaxAmount, FromDate, ToDate, WTLiable, CrtfcateNO, ExpireDate, NINum, AccCritria, WTCode, Equ, HldCode, ConnBP, MltMthNum, TypWTReprt, VATRegNum, RepName, Industry, Business, WTTaxCat, IsDomestic, IsResident, AutoCalBCG, OtrCtlAcct, AliasName, Building, MailBuildi, BoEPrsnt, BoEDiscnt, BoEOnClct, UnpaidBoE, ITWTCode, DunTerm, ChannlBP, DfTcnician, Territory, BillToDef, DpmClear, IntrntSite, LangCode, HousActKey, Profession, CDPNum, DflBankKey, BCACode, UseShpdGd, RegNum, VerifNum, BankCtlKey, HousCtlKey, AddrType, InsurOp347, MailAddrTy, StreetNo, MailStrNo, TaxRndRule, VendTID, ThreshOver, SurOver, VendorOcup, OpCode347, DpmIntAct, ResidenNum, UserSign2, PlngGroup, VatIDNum, Affiliate, MivzExpSts, HierchDdct, CertWHT, CertBKeep, WHShaamGrp, IndustryC FROM OCRD

TOP B1 8.8 | OCRD COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	CardCode	BP Code	nvarchar	15	0				Allow NULL?
2	CardName	BP Name	nvarchar	100	0				Allow NULL?
3	CardType	BP Type	char	1	0		C	C=Customer, L=Lead, S=Vendor	Allow NULL?
4	GroupCode	Group Code	int	6	0	OCRG			Allow NULL?
5	CmpPrivate	Company/Private	char	1	0		C	C=Company, I=Private	Allow NULL?
6	Address	Bill-to Street	nvarchar	100	0				Allow NULL?
7	ZipCode	Bill-to Zip Code	nvarchar	20	0				Allow NULL?
8	MailAddres	Ship-to Street	nvarchar	100	0				Allow NULL?
9	MailZipCod	Ship-to Zip Code	nvarchar	20	0				Allow NULL?
10	Phone1	Telephone 1	nvarchar	20	0				Allow NULL?
11	Phone2	Telephone 2	nvarchar	20	0				Allow NULL?
12	Fax	Fax Number	nvarchar	20	0				Allow NULL?
13	CntctPrsn	Contact Person	nvarchar	90	0				Allow NULL?
14	Notes	Remarks	nvarchar	100	0				Allow NULL?
15	Balance	Account Balance	num	19	6				Allow NULL?
16	ChecksBal	Open Checks Balance	num	19	6				Allow NULL?
17	DNotesBal	Open Del. Notes Balance	num	19	6				Allow NULL?
18	OrdersBal	Open Orders Balance	num	19	6				Allow NULL?
19	GroupNum	Payment Terms Code	int	6	0	OCTG	-1		Allow NULL?
20	CreditLine	Credit Limit	num	19	6				Allow NULL?
21	DebtLine	Payable Limit	num	19	6				Allow NULL?
22	Discount	Discount %	num	19	6				Allow NULL?
23	VatStatus	Tax Definition	char	1	0		Y	E=EU, N=Exempted, Y=Liable	Allow NULL?
24	LicTradNum	Federal Tax ID	nvarchar	32	0				Allow NULL?
25	DdctStatus	Liable for Ded. at Source	char	1	0		N	N=No, Y=Yes	Allow NULL?
26	DdctPrcnt	Withholding Tax Deduction %	num	19	6				Allow NULL?
27	ValidUntil	Expiration Date for -% of DeducÌValidUntil	date	8	0
28	Chrctrstcs	Properties	int	11	0				Allow NULL?
29	ExMatchNum	Last Ext. Reconciliation No.	int	11	0				Allow NULL?
30	InMatchNum	Last Int. Reconciliation No.	int	11	0				Allow NULL?
31	ListNum	Price List No.	int	6	0	OPLN			Allow NULL?
32	DNoteBalFC	Open DN Balance in BP Curr.	num	19	6				Allow NULL?
33	OrderBalFC	Open orders bal. in BP curr.	num	19	6				Allow NULL?
34	DNoteBalSy	Open DN Balance in SC	num	19	6				Allow NULL?
35	OrderBalSy	Open Orders Bal. in SC	num	19	6				Allow NULL?
36	Transfered	Year Transfer	char	1	0		N	N=No, Y=Yes	Allow NULL?
37	BalTrnsfrd	Balances transferred	char	1	0		N	N=No, Y=Yes	Allow NULL?
38	IntrstRate	Interest % on Liabilities	num	19	6				Allow NULL?
39	Commission	Commission % for Customer	num	19	6				Allow NULL?
40	CommGrCode	Commission Group	int	6	0	OCOG	0		Allow NULL?
41	Free_Text	Free Text	text	16	0
42	SlpCode	Sales Employee Code	int	6	0	OSLP	-1		Allow NULL?
43	PrevYearAc	Previous Year Balance	char	1	0		N	N=No, Y=Yes	Allow NULL?
44	Currency	BP Currency	nvarchar	3	0				Allow NULL?
45	RateDifAct	Rate Differences Account	nvarchar	15	0	OACT			Allow NULL?
46	BalanceSys	Balance in Account Currency	num	19	6				Allow NULL?
47	BalanceFC	Balance in BP Currency	num	19	6				Allow NULL?
48	Protected	Protected BP	char	1	0		N	N=No, Y=Yes	Allow NULL?
49	Cellular	Mobile Phone	nvarchar	50	0				Allow NULL?
50	AvrageLate	Average Payment Delay in Days	int	6	0				Allow NULL?
51	City	Bill-to City	nvarchar	100	0				Allow NULL?
52	County	Bill-to County	nvarchar	100	0				Allow NULL?
53	Country	Bill-to Country	nvarchar	3	0	OCRY			Allow NULL?
54	MailCity	Ship-to City	nvarchar	100	0				Allow NULL?
55	MailCounty	Ship-to County	nvarchar	100	0				Allow NULL?
56	MailCountr	Ship-to Country	nvarchar	3	0	OCRY			Allow NULL?
57	E_Mail	E-Mail	nvarchar	100	0				Allow NULL?
58	Picture	Picture	nvarchar	200	0				Allow NULL?
59	DflAccount	Default Account	nvarchar	50	0				Allow NULL?
60	DflBranch	Default Branch	nvarchar	50	0				Allow NULL?
61	BankCode	Default Bank	nvarchar	30	0		-1		Allow NULL?
62	AddID	Additional ID No.	nvarchar	18	0				Allow NULL?
63	Pager	Pager	nvarchar	30	0				Allow NULL?
64	FatherCard	BP Summary	nvarchar	15	0				Allow NULL?
65	CardFName	Foreign Name	nvarchar	100	0				Allow NULL?
66	FatherType	Parent Summary Type	char	1	0		P	D=Delivery Consolidation, P=Payments Summary	Allow NULL?
67	QryGroup1	Property 1	char	1	0		N	N=No, Y=Yes	Allow NULL?
68	QryGroup2	Property 2	char	1	0		N	N=No, Y=Yes	Allow NULL?
69	QryGroup3	Property 3	char	1	0		N	N=No, Y=Yes	Allow NULL?
70	QryGroup4	Property 4	char	1	0		N	N=No, Y=Yes	Allow NULL?
71	QryGroup5	Property 5	char	1	0		N	N=No, Y=Yes	Allow NULL?
72	QryGroup6	Property 6	char	1	0		N	N=No, Y=Yes	Allow NULL?
73	QryGroup7	Property 7	char	1	0		N	N=No, Y=Yes	Allow NULL?
74	QryGroup8	Property 8	char	1	0		N	N=No, Y=Yes	Allow NULL?
75	QryGroup9	Property 9	char	1	0		N	N=No, Y=Yes	Allow NULL?
76	QryGroup10	Property 10	char	1	0		N	N=No, Y=Yes	Allow NULL?
77	QryGroup11	Property 11	char	1	0		N	N=No, Y=Yes	Allow NULL?
78	QryGroup12	Property 12	char	1	0		N	N=No, Y=Yes	Allow NULL?
79	QryGroup13	Property 13	char	1	0		N	N=No, Y=Yes	Allow NULL?
80	QryGroup14	Property 14	char	1	0		N	N=No, Y=Yes	Allow NULL?
81	QryGroup15	Property 15	char	1	0		N	N=No, Y=Yes	Allow NULL?
82	QryGroup16	Property 16	char	1	0		N	N=No, Y=Yes	Allow NULL?
83	QryGroup17	Property 17	char	1	0		N	N=No, Y=Yes	Allow NULL?
84	QryGroup18	Property 18	char	1	0		N	N=No, Y=Yes	Allow NULL?
85	QryGroup19	Property 19	char	1	0		N	N=No, Y=Yes	Allow NULL?
86	QryGroup20	Property 20	char	1	0		N	N=No, Y=Yes	Allow NULL?
87	QryGroup21	Property 21	char	1	0		N	N=No, Y=Yes	Allow NULL?
88	QryGroup22	Property 22	char	1	0		N	N=No, Y=Yes	Allow NULL?
89	QryGroup23	Property 23	char	1	0		N	N=No, Y=Yes	Allow NULL?
90	QryGroup24	Property 24	char	1	0		N	N=No, Y=Yes	Allow NULL?
91	QryGroup25	Property 25	char	1	0		N	N=No, Y=Yes	Allow NULL?
92	QryGroup26	Property 26	char	1	0		N	N=No, Y=Yes	Allow NULL?
93	QryGroup27	Property 27	char	1	0		N	N=No, Y=Yes	Allow NULL?
94	QryGroup28	Property 28	char	1	0		N	N=No, Y=Yes	Allow NULL?
95	QryGroup29	Property 29	char	1	0		N	N=No, Y=Yes	Allow NULL?
96	QryGroup30	Property 30	char	1	0		N	N=No, Y=Yes	Allow NULL?
97	QryGroup31	Property 31	char	1	0		N	N=No, Y=Yes	Allow NULL?
98	QryGroup32	Property 32	char	1	0		N	N=No, Y=Yes	Allow NULL?
99	QryGroup33	Property 33	char	1	0		N	N=No, Y=Yes	Allow NULL?
100	QryGroup34	Property 34	char	1	0		N	N=No, Y=Yes	Allow NULL?
101	QryGroup35	Property 35	char	1	0		N	N=No, Y=Yes	Allow NULL?
102	QryGroup36	Property 36	char	1	0		N	N=No, Y=Yes	Allow NULL?
103	QryGroup37	Property 37	char	1	0		N	N=No, Y=Yes	Allow NULL?
104	QryGroup38	Property 38	char	1	0		N	N=No, Y=Yes	Allow NULL?
105	QryGroup39	Property 39	char	1	0		N	N=No, Y=Yes	Allow NULL?
106	QryGroup40	Property 40	char	1	0		N	N=No, Y=Yes	Allow NULL?
107	QryGroup41	Property 41	char	1	0		N	N=No, Y=Yes	Allow NULL?
108	QryGroup42	Property 42	char	1	0		N	N=No, Y=Yes	Allow NULL?
109	QryGroup43	Property 43	char	1	0		N	N=No, Y=Yes	Allow NULL?
110	QryGroup44	Property 44	char	1	0		N	N=No, Y=Yes	Allow NULL?
111	QryGroup45	Property 45	char	1	0		N	N=No, Y=Yes	Allow NULL?
112	QryGroup46	Property 46	char	1	0		N	N=No, Y=Yes	Allow NULL?
113	QryGroup47	Property 47	char	1	0		N	N=No, Y=Yes	Allow NULL?
114	QryGroup48	Property 48	char	1	0		N	N=No, Y=Yes	Allow NULL?
115	QryGroup49	Property 49	char	1	0		N	N=No, Y=Yes	Allow NULL?
116	QryGroup50	Property 50	char	1	0		N	N=No, Y=Yes	Allow NULL?
117	QryGroup51	Property 51	char	1	0		N	N=No, Y=Yes	Allow NULL?
118	QryGroup52	Property 52	char	1	0		N	N=No, Y=Yes	Allow NULL?
119	QryGroup53	Property 53	char	1	0		N	N=No, Y=Yes	Allow NULL?
120	QryGroup54	Property 54	char	1	0		N	N=No, Y=Yes	Allow NULL?
121	QryGroup55	Property 55	char	1	0		N	N=No, Y=Yes	Allow NULL?
122	QryGroup56	Property 56	char	1	0		N	N=No, Y=Yes	Allow NULL?
123	QryGroup57	Property 57	char	1	0		N	N=No, Y=Yes	Allow NULL?
124	QryGroup58	Property 58	char	1	0		N	N=No, Y=Yes	Allow NULL?
125	QryGroup59	Property 59	char	1	0		N	N=No, Y=Yes	Allow NULL?
126	QryGroup60	Property 60	char	1	0		N	N=No, Y=Yes	Allow NULL?
127	QryGroup61	Property 61	char	1	0		N	N=No, Y=Yes	Allow NULL?
128	QryGroup62	Property 62	char	1	0		N	N=No, Y=Yes	Allow NULL?
129	QryGroup63	Property 63	char	1	0		N	N=No, Y=Yes	Allow NULL?
130	QryGroup64	Property 64	char	1	0		N	N=No, Y=Yes	Allow NULL?
131	DdctOffice	Deduction Approval Office	nvarchar	10	0				Allow NULL?
132	CreateDate	Creation Date	date	8	0
133	UpdateDate	Date of Update	date	8	0
134	ExportCode	Data Export Code	nvarchar	8	0				Allow NULL?
135	DscntObjct	Object for Discounts	int	6	0		-1	-1, 43=Companies, 52=Groups, 8=Properties	Allow NULL?
136	DscntRel	Discounts Ratio	char	1	0		L	A=Average Disc., H=Highest Discount, L=Lowest Discount, S=Discount Totals	Allow NULL?
137	SPGCounter	SPG Counter	int	6	0		0		Allow NULL?
138	SPPCounter	SPP Counter	int	11	0		0		Allow NULL?
139	DdctFileNo	Tax Deduction File Number	nvarchar	9	0				Allow NULL?
140	SCNCounter	SCN Counter	int	6	0				Allow NULL?
141	MinIntrst	Min. Interest Letter Amount	num	19	6				Allow NULL?
142	DataSource	Data Source	char	1	0		N	A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update	Allow NULL?
143	OprCount	Open Opportunities	int	11	0				Allow NULL?
144	ExemptNo	Exempt No.	nvarchar	50	0				Allow NULL?
145	Priority	Priority	int	11	0	OBPP	-1		Allow NULL?
146	CreditCard	Credit Cards	int	6	0	OCRC	-1		Allow NULL?
147	CrCardNum	Credit Card No.	nvarchar	20	0				Allow NULL?
148	CardValid	Credit Card Validity	date	8	0
149	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
150	LocMth	LC Reconciliation	char	1	0		Y	N=No, Y=Yes	Allow NULL?
151	validFor	Active	char	1	0		N	N=No, Y=Yes	Allow NULL?
152	validFrom	Active From	date	8	0
153	validTo	Active To	date	8	0
154	frozenFor	Inactive	char	1	0		N	N=No, Y=Yes	Allow NULL?
155	frozenFrom	Inactive From	date	8	0
156	frozenTo	Inactive To	date	8	0
157	sEmployed	Self-Employed	char	1	0		N	N=No, Y=Yes	Allow NULL?
158	MTHCounter	MTH Counter	int	11	0				Allow NULL?
159	BNKCounter	BNK Counter	int	11	0				Allow NULL?
160	DdgKey	Withholding Tax Deduction Grp	int	11	0	ODDG	-1		Allow NULL?
161	DdtKey	Current Deduction Hierarchy	int	11	0	ODDT	-1		Allow NULL?
162	ValidComm	Active Remarks	nvarchar	30	0				Allow NULL?
163	FrozenComm	Inactive Remarks	nvarchar	30	0				Allow NULL?
164	chainStore	Belongs to Retail Store	char	1	0		N	N=No, Y=Yes	Allow NULL?
165	DiscInRet	Allow Doc Discount in Returns	char	1	0		N	N=No, Y=Yes	Allow NULL?
166	State1	Bill-to State	nvarchar	3	0	OCST			Allow NULL?
167	State2	Ship-to State	nvarchar	3	0	OCST			Allow NULL?
168	VatGroup	Tax Group	nvarchar	8	0	OSTC			Allow NULL?
169	LogInstanc	Log Instance	int	6	0		0		Allow NULL?
170	ObjType	Object Type	nvarchar	20	0		2		Allow NULL?
171	Indicator	Indicator	nvarchar	2	0	OIDC			Allow NULL?
172	ShipType	Shipping Type	int	6	0	OSHP			Allow NULL?
173	DebPayAcct	Accounts Receivable/Payable	nvarchar	15	0	OACT			Allow NULL?
174	ShipToDef	Ship-to-Default	nvarchar	50	0				Allow NULL?
175	Block	Bill-to Block	nvarchar	100	0				Allow NULL?
176	MailBlock	Ship-to Block	nvarchar	100	0				Allow NULL?
177	Password	Password	nvarchar	32	0				Allow NULL?
178	ECVatGroup	Tax Group	nvarchar	8	0	OVTG			Allow NULL?
179	Deleted	Deleted	char	1	0		N	N=No, Y=Yes	Allow NULL?
180	IBAN	IBAN	nvarchar	50	0				Allow NULL?
181	DocEntry	Internal Number	int	11	0				Allow NULL?
182	FormCode	1099 Form Code	int	11	0	OTNN			Allow NULL?
183	Box1099	1099 Box	nvarchar	20	0				Allow NULL?
184	PymCode	Peyment Method Code	nvarchar	15	0	OPYM	-1		Allow NULL?
185	BackOrder	Backorder	char	1	0		Y	N=No, Y=Yes	Allow NULL?
186	PartDelivr	Partial Delivery	char	1	0		Y	N=No, Y=Yes	Allow NULL?
187	DunnLevel	Dunning Level	int	11	0	ODUN			Allow NULL?
188	DunnDate	Dunning Date	date	8	0
189	BlockDunn	Block Dunning	char	1	0		N	N=No, Y=Yes	Allow NULL?
190	BankCountr	Bank Country	nvarchar	3	0	OCRY			Allow NULL?
191	CollecAuth	Collection Authorization	char	1	0		N	N=No, Y=Yes	Allow NULL?
192	DME	DME Identification	nvarchar	5	0				Allow NULL?
193	InstrucKey	Instruction Key	nvarchar	30	0				Allow NULL?
194	SinglePaym	Single Payment	char	1	0		N	N=No, Y=Yes	Allow NULL?
195	ISRBillId	ISR Biller ID	nvarchar	9	0				Allow NULL?
196	PaymBlock	Payment Block	char	1	0		N	N=No, Y=Yes	Allow NULL?
197	RefDetails	Reference Details	nvarchar	20	0				Allow NULL?
198	HouseBank	House Bank	nvarchar	30	0		-1		Allow NULL?
199	OwnerIdNum	ID Number	nvarchar	15	0				Allow NULL?
200	PyBlckDesc	Payment Block Description	int	11	0	OPYB	-1		Allow NULL?
201	HousBnkCry	House Bank Country	nvarchar	3	0				Allow NULL?
202	HousBnkAct	House Bank Account	nvarchar	50	0				Allow NULL?
203	HousBnkBrn	House Bank Branch	nvarchar	50	0				Allow NULL?
204	ProjectCod	Project Code	nvarchar	8	0	OPRJ			Allow NULL?
205	SysMatchNo	Last Sys. Reconciliation No.	int	11	0		-1		Allow NULL?
206	VatIdUnCmp	Unified Federal Tax ID	nvarchar	32	0				Allow NULL?
207	AgentCode	Agent Code	nvarchar	32	0	OAGP			Allow NULL?
208	TolrncDays	Tolerance Days	int	6	0				Allow NULL?
209	SelfInvoic	Self Invoice	char	1	0				Allow NULL?
210	DeferrTax	Deferred Tax	char	1	0			N=No, Y=Yes	Allow NULL?
211	LetterNum	Tax Exemption Letter No.	nvarchar	20	0				Allow NULL?
212	MaxAmount	Max. Exemption Amount	num	19	6				Allow NULL?
213	FromDate	Exemption Validity Date From	date	8	0
214	ToDate	Exemption Validity Date To	date	8	0
215	WTLiable	Subject to Withholding Tax	char	1	0			N=No, Y=Yes	Allow NULL?
216	CrtfcateNO	Certificate No.	nvarchar	20	0				Allow NULL?
217	ExpireDate	Expiration Date	date	8	0
218	NINum	Registration No.	nvarchar	20	0				Allow NULL?
219	AccCritria	Accrual	char	1	0		N	N=No, Y=Yes	Allow NULL?
220	WTCode	WTax Code	nvarchar	4	0	OWHT			Allow NULL?
221	Equ	Equalization Tax	char	1	0		N	N=No, Y=Yes	Allow NULL?
222	HldCode	Holidays Name	nvarchar	20	0	OHLD			Allow NULL?
223	ConnBP	Linked Business Partner	nvarchar	15	0				Allow NULL?
224	MltMthNum	Last Multi. Reconciliation No.	int	11	0				Allow NULL?
225	TypWTReprt	BP Type for WTax Report	char	1	0		C	C=Company, P=Person	Allow NULL?
226	VATRegNum	VAT Reg. Number	nvarchar	12	0				Allow NULL?
227	RepName	Representative Name	nvarchar	15	0				Allow NULL?
228	Industry	Industry	text	16	0
229	Business	Business	text	16	0
230	WTTaxCat	Withholding Tax Cat.	text	16	0
231	IsDomestic	Is Domestic	char	1	0		Y	N=Foreign, Y=Domestic	Allow NULL?
232	IsResident	Is Resident	char	1	0		Y	N=Non-resident, Y=Resident	Allow NULL?
233	AutoCalBCG	Auto Calculated Bank Charges	char	1	0		N	N=No, Y=Yes	Allow NULL?
234	OtrCtlAcct	Other Receivable/Payable	nvarchar	15	0	OACT			Allow NULL?
235	AliasName	Alias Name	text	16	0
236	Building	Bill to Building/Floor/Room	text	16	0
237	MailBuildi	Ship to Building/Floor/Room	text	16	0
238	BoEPrsnt	Customer Bill of Exchang Pres	nvarchar	15	0	OACT			Allow NULL?
239	BoEDiscnt	Customer BoE Discounted	nvarchar	15	0	OACT			Allow NULL?
240	BoEOnClct	Bill of Exchange on Collection	nvarchar	15	0	OACT			Allow NULL?
241	UnpaidBoE	Unpaid Bill of Exchange	nvarchar	15	0	OACT			Allow NULL?
242	ITWTCode	Income Tax WTax Code	nvarchar	4	0	OWHT			Allow NULL?
243	DunTerm	Dunning Term	nvarchar	25	0	ODUT			Allow NULL?
244	ChannlBP	Channel BP	nvarchar	15	0	OCRD			Allow NULL?
245	DfTcnician	Default Technician	int	11	0	OHEM			Allow NULL?
246	Territory	Territory	int	11	0	OTER			Allow NULL?
247	BillToDef	Bill-to Default	nvarchar	50	0				Allow NULL?
248	DpmClear	Payment Advances	nvarchar	15	0	OACT			Allow NULL?
249	IntrntSite	Web Site	nvarchar	100	0				Allow NULL?
250	LangCode	Language Code	int	11	0	OLNG			Allow NULL?
251	HousActKey	House Bank Account Key	int	11	0	DSC1			Allow NULL?
252	Profession	Profession	nvarchar	50	0				Allow NULL?
253	CDPNum	Closing Date Procedure Number	int	6	0	OCDP			Allow NULL?
254	DflBankKey	Default Bank Key	int	11	0	ODSC			Allow NULL?
255	BCACode	Bank Charges Allocation Codes	nvarchar	3	0	OBCA			Allow NULL?
256	UseShpdGd	Use Shipped Goods Account	char	1	0		Y	N=No, Y=Yes	Allow NULL?
257	RegNum	Company Reg. No. (CRN)	nvarchar	32	0				Allow NULL?
258	VerifNum	WTax Verification No.	nvarchar	32	0				Allow NULL?
259	BankCtlKey	Default Bank Internal ID	nvarchar	2	0				Allow NULL?
260	HousCtlKey	House Bank Control Number	nvarchar	2	0				Allow NULL?
261	AddrType	Bill-to Address Type	nvarchar	100	0				Allow NULL?
262	InsurOp347	347 Insurance Operation	char	1	0		N	N=No, Y=Yes	Allow NULL?
263	MailAddrTy	Ship-to Address Type	nvarchar	100	0				Allow NULL?
264	StreetNo	Bill-to Street No.	nvarchar	100	0				Allow NULL?
265	MailStrNo	Ship-to Street No.	nvarchar	100	0				Allow NULL?
266	TaxRndRule	Tax Rounding Rule	char	1	0		D	C=Round Up, D=Company Default, F=Round Down, R=Round Off	Allow NULL?
267	VendTID	Vender Type ID	int	11	0				Allow NULL?
268	ThreshOver	Threshold Overlook	char	1	0		N	N=No, Y=Yes	Allow NULL?
269	SurOver	Surcharge Overlook	char	1	0		N	N=No, Y=Yes	Allow NULL?
270	VendorOcup	Vendor Occupation	nvarchar	15	0				Allow NULL?
271	OpCode347	347 Operation Code	char	1	0		A	A=Goods or Services Acquisitions, B=Sales or Services Revenues, D=Public Entities Acquisitions, E=Public Subsidies, F=Travel Agent Sales, G=Travel Agent Purchases	Allow NULL?
272	DpmIntAct	Dpm Interim Account	nvarchar	15	0	OACT			Allow NULL?
273	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?
274	UserSign2	Updating User	int	6	0	OUSR			Allow NULL?
275	PlngGroup	B1i Info for Integration	nvarchar	10	0				Allow NULL?
276	VatIDNum	VAT ID Number	nvarchar	32	0				Allow NULL?
277	Affiliate	B1i Info for Integration	char	1	0		N	N=No, Y=Yes	Allow NULL?
278	MivzExpSts	Mivzak Export Status	char	1	0		B	B=Not exported, D=Deleted, U=Exported	Allow NULL?
279	HierchDdct	Hierarchical Deduction	char	1	0		Y	N=No, Y=Yes	Allow NULL?
280	CertWHT	Withholding Tax Certified	char	1	0		N	N=No, Y=Yes	Allow NULL?
281	CertBKeep	Bookkeeping Certified	char	1	0		N	N=No, Y=Yes	Allow NULL?
282	WHShaamGrp	Withholding Shaam Group	char	1	0		1	1=Services and Asset, 2=Agricultural Products, 3=Insurance Commissions, 4=Withholding Tax Instructions, 5=Interest, Exchange Rate Differences	Allow NULL?
283	IndustryC	Industry	int	11	0	OOND			Allow NULL?

TOP B1 8.8 | OCRD INDEXES

Name	Primary	Unique	Columns
PRIMARY	No	Yes	CardCode
CARD_NAME	No	No	CardName
CARD_TYPE	No	No	CardType
FATHER	No	No	FatherCard
TERMS	No	No	GroupNum
CURRENCY	No	No	Currency
COM_GROUP	No	No	CommGrCode
PRICE_LIST	No	No	ListNum
PAY_ACCT	No	No	DebPayAcct
ABS_ENTRY	No	Yes	DocEntry

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

283 COLUMNS | 10 INDEXES | B1 8.8 | OCRD TABLE

TOP B1 8.8 | OCRD COLUMNS

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

283 COLUMNS | 10 INDEXES | B1 8.8 | OCRD TABLE

TOPB1 8.8 | OCRD COLUMNS

TOPB1 8.8 | OCRD INDEXES

TOP B1 8.8 | OCRD COLUMNS

TOP B1 8.8 | OCRD INDEXES