	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

303 COLUMNS | 9 INDEXES | B1 8.82 | ACRD TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Business Partners
1	Business One	8.82	ACRD	303	9	Business Partners - History	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, DatevAcct, DatevFirst, GTSRegNum, GTSBankAct, GTSBilAddr, HsBnkSwift, HsBnkIBAN, DflSwift, AutoPost, IntrAcc, FeeAcc, CpnNo, NTSWebSite, DflIBAN, Series, Number, EDocExpFrm, TaxIdIdent, Attachment, AtcEntry FROM ACRD

TOP B1 8.82 | ACRD 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, L, S	Allow NULL?
4	GroupCode	Group Code	int	6	0	OCRG			Allow NULL?
5	CmpPrivate	Company/ Private	char	1	0		C	C, I	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	Commitment Limit	num	19	6				Allow NULL?
22	Discount	Discount %	num	19	6				Allow NULL?
23	VatStatus	Tax Definition	char	1	0		Y	E, N, Y	Allow NULL?
24	LicTradNum	Federal Tax ID	nvarchar	32	0				Allow NULL?
25	DdctStatus	Liable for Ded. at Source	char	1	0		N	N, Y	Allow NULL?
26	DdctPrcnt	% Withholding Tax Deduction	num	19	6				Allow NULL?
27	ValidUntil	Expiration Date for -% of Deduction	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 (BP Currency)	num	19	6				Allow NULL?
33	OrderBalFC	Open Orders Balance (BP Crcy)	num	19	6				Allow NULL?
34	DNoteBalSy	Open DN Balance (SC)	num	19	6				Allow NULL?
35	OrderBalSy	Open Orders Balance (SC)	num	19	6				Allow NULL?
36	Transfered	Year Transfer	char	1	0		N	N, Y	Allow NULL?
37	BalTrnsfrd	Balances Transferred	char	1	0		N	N, Y	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, Y	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 (Account Currency)	num	19	6				Allow NULL?
47	BalanceFC	BP Balance in FC	num	19	6				Allow NULL?
48	Protected	Protected BP	char	1	0		N	N, Y	Allow NULL?
49	Cellular	Mobile Phone Number	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 No.	nvarchar	30	0				Allow NULL?
64	FatherCard	Consolidating BP	nvarchar	15	0				Allow NULL?
65	CardFName	Foreign Name	nvarchar	100	0				Allow NULL?
66	FatherType	Parent Summary Type	char	1	0		P	D, P	Allow NULL?
67	QryGroup1	Property 1	char	1	0		N	N, Y	Allow NULL?
68	QryGroup2	Property 2	char	1	0		N	N, Y	Allow NULL?
69	QryGroup3	Property 3	char	1	0		N	N, Y	Allow NULL?
70	QryGroup4	Property 4	char	1	0		N	N, Y	Allow NULL?
71	QryGroup5	Property 5	char	1	0		N	N, Y	Allow NULL?
72	QryGroup6	Property 6	char	1	0		N	N, Y	Allow NULL?
73	QryGroup7	Property 7	char	1	0		N	N, Y	Allow NULL?
74	QryGroup8	Property 8	char	1	0		N	N, Y	Allow NULL?
75	QryGroup9	Property 9	char	1	0		N	N, Y	Allow NULL?
76	QryGroup10	Property 10	char	1	0		N	N, Y	Allow NULL?
77	QryGroup11	Property 11	char	1	0		N	N, Y	Allow NULL?
78	QryGroup12	Property 12	char	1	0		N	N, Y	Allow NULL?
79	QryGroup13	Property 13	char	1	0		N	N, Y	Allow NULL?
80	QryGroup14	Property 14	char	1	0		N	N, Y	Allow NULL?
81	QryGroup15	Property 15	char	1	0		N	N, Y	Allow NULL?
82	QryGroup16	Property 16	char	1	0		N	N, Y	Allow NULL?
83	QryGroup17	Property 17	char	1	0		N	N, Y	Allow NULL?
84	QryGroup18	Property 18	char	1	0		N	N, Y	Allow NULL?
85	QryGroup19	Property 19	char	1	0		N	N, Y	Allow NULL?
86	QryGroup20	Property 20	char	1	0		N	N, Y	Allow NULL?
87	QryGroup21	Property 21	char	1	0		N	N, Y	Allow NULL?
88	QryGroup22	Property 22	char	1	0		N	N, Y	Allow NULL?
89	QryGroup23	Property 23	char	1	0		N	N, Y	Allow NULL?
90	QryGroup24	Property 24	char	1	0		N	N, Y	Allow NULL?
91	QryGroup25	Property 25	char	1	0		N	N, Y	Allow NULL?
92	QryGroup26	Property 26	char	1	0		N	N, Y	Allow NULL?
93	QryGroup27	Property 27	char	1	0		N	N, Y	Allow NULL?
94	QryGroup28	Property 28	char	1	0		N	N, Y	Allow NULL?
95	QryGroup29	Property 29	char	1	0		N	N, Y	Allow NULL?
96	QryGroup30	Property 30	char	1	0		N	N, Y	Allow NULL?
97	QryGroup31	Property 31	char	1	0		N	N, Y	Allow NULL?
98	QryGroup32	Property 32	char	1	0		N	N, Y	Allow NULL?
99	QryGroup33	Property 33	char	1	0		N	N, Y	Allow NULL?
100	QryGroup34	Property 34	char	1	0		N	N, Y	Allow NULL?
101	QryGroup35	Property 35	char	1	0		N	N, Y	Allow NULL?
102	QryGroup36	Property 36	char	1	0		N	N, Y	Allow NULL?
103	QryGroup37	Property 37	char	1	0		N	N, Y	Allow NULL?
104	QryGroup38	Property 38	char	1	0		N	N, Y	Allow NULL?
105	QryGroup39	Property 39	char	1	0		N	N, Y	Allow NULL?
106	QryGroup40	Property 40	char	1	0		N	N, Y	Allow NULL?
107	QryGroup41	Property 41	char	1	0		N	N, Y	Allow NULL?
108	QryGroup42	Property 42	char	1	0		N	N, Y	Allow NULL?
109	QryGroup43	Property 43	char	1	0		N	N, Y	Allow NULL?
110	QryGroup44	Property 44	char	1	0		N	N, Y	Allow NULL?
111	QryGroup45	Property 45	char	1	0		N	N, Y	Allow NULL?
112	QryGroup46	Property 46	char	1	0		N	N, Y	Allow NULL?
113	QryGroup47	Property 47	char	1	0		N	N, Y	Allow NULL?
114	QryGroup48	Property 48	char	1	0		N	N, Y	Allow NULL?
115	QryGroup49	Property 49	char	1	0		N	N, Y	Allow NULL?
116	QryGroup50	Property 50	char	1	0		N	N, Y	Allow NULL?
117	QryGroup51	Property 51	char	1	0		N	N, Y	Allow NULL?
118	QryGroup52	Property 52	char	1	0		N	N, Y	Allow NULL?
119	QryGroup53	Property 53	char	1	0		N	N, Y	Allow NULL?
120	QryGroup54	Property 54	char	1	0		N	N, Y	Allow NULL?
121	QryGroup55	Property 55	char	1	0		N	N, Y	Allow NULL?
122	QryGroup56	Property 56	char	1	0		N	N, Y	Allow NULL?
123	QryGroup57	Property 57	char	1	0		N	N, Y	Allow NULL?
124	QryGroup58	Property 58	char	1	0		N	N, Y	Allow NULL?
125	QryGroup59	Property 59	char	1	0		N	N, Y	Allow NULL?
126	QryGroup60	Property 60	char	1	0		N	N, Y	Allow NULL?
127	QryGroup61	Property 61	char	1	0		N	N, Y	Allow NULL?
128	QryGroup62	Property 62	char	1	0		N	N, Y	Allow NULL?
129	QryGroup63	Property 63	char	1	0		N	N, Y	Allow NULL?
130	QryGroup64	Property 64	char	1	0		N	N, Y	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	Subject for Discount	int	6	0		-1	-1, 43, 52, 8	Allow NULL?
136	DscntRel	Discounts Ratio	char	1	0		L	A, H, L, S	Allow NULL?
137	SPGCounter	SPG Counter	int	6	0				Allow NULL?
138	SPPCounter	SPP Counter	int	11	0				Allow NULL?
139	DdctFileNo	Tax Deduction File No.	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, D, I, M, N, O, P, T, U	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	64	0				Allow NULL?
148	CardValid	Credit Card Validity	date	8	0
149	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
150	LocMth	Reconciliation (LC)	char	1	0		Y	N, Y	Allow NULL?
151	validFor	Active	char	1	0		N	N, Y	Allow NULL?
152	validFrom	Active From	date	8	0
153	validTo	Active To	date	8	0
154	frozenFor	Inactive	char	1	0		N	N, Y	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, Y	Allow NULL?
158	MTHCounter	Match History Counter	int	11	0				Allow NULL?
159	BNKCounter	BNK Counter	int	11	0				Allow NULL?
160	DdgKey	WTax Deduction - Group	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, Y	Allow NULL?
165	DiscInRet	Allow Doc Discount in Returns	char	1	0		N	N, Y	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 Code	nvarchar	8	0	OSTC			Allow NULL?
169	LogInstanc	Log Instance	int	11	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	Control Account	nvarchar	15	0	OACT			Allow NULL?
174	ShipToDef	Ship to - Default	nvarchar	50	0				Allow NULL?
175	Block	Block	nvarchar	100	0				Allow NULL?
176	MailBlock	Delivery 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, Y	Allow NULL?
180	IBAN	IBAN	nvarchar	50	0				Allow NULL?
181	DocEntry	Numerator	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	Payment Method Code	nvarchar	15	0	OPYM	-1		Allow NULL?
185	BackOrder	Backorder	char	1	0		Y	N, Y	Allow NULL?
186	PartDelivr	Partial Delivery	char	1	0		Y	N, Y	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, Y	Allow NULL?
190	BankCountr	Bank Country	nvarchar	3	0	OCRY			Allow NULL?
191	CollecAuth	Collection Authorization	char	1	0		N	N, Y	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, Y	Allow NULL?
195	ISRBillId	ISR Biller ID	nvarchar	9	0				Allow NULL?
196	PaymBlock	Payment Block	char	1	0		N	N, Y	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	20	0	OPRJ			Allow NULL?
205	SysMatchNo	Last Sys. Reconciliation No.	int	11	0		-1		Allow NULL?
206	VatIdUnCmp	VAT ID for Unified Company	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, Y	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, Y	Allow NULL?
216	CrtfcateNO	Certificate Number	nvarchar	20	0				Allow NULL?
217	ExpireDate	Expiration Date	date	8	0
218	NINum	Registration No.	nvarchar	20	0				Allow NULL?
219	AccCritria	Accrued Criteria	char	1	0		N	N, Y	Allow NULL?
220	WTCode	Withholding Tax Code	nvarchar	4	0	OWHT			Allow NULL?
221	Equ	Equalization Tax	char	1	0		N	N, Y	Allow NULL?
222	HldCode	Holiday Set 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, P	Allow NULL?
226	VATRegNum	VAT Reg. Number	nvarchar	32	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, Y	Allow NULL?
232	IsResident	Is Resident	char	1	0		Y	N, Y	Allow NULL?
233	AutoCalBCG	Auto Calculated Bank Charges	char	1	0		N	N, Y	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 BoE Presentation	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 No.	int	6	0	OCDP			Allow NULL?
254	DflBankKey	Default Bank ID	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, Y	Allow NULL?
257	RegNum	Company Reg. No. (CRN)	nvarchar	32	0				Allow NULL?
258	VerifNum	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, Y	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, D, F, R	Allow NULL?
267	VendTID	Vender Type ID	int	11	0				Allow NULL?
268	ThreshOver	Threshold Overlook	char	1	0		N	N, Y	Allow NULL?
269	SurOver	Surcharge Overlook	char	1	0		N	N, Y	Allow NULL?
270	VendorOcup	Vendor Occupation	nvarchar	15	0				Allow NULL?
271	OpCode347	347 Operation Code	char	1	0		A	A, B, D, E, F, G	Allow NULL?
272	DpmIntAct	DPM Interim Account	nvarchar	15	0	OACT			Allow NULL?
273	ResidenNum	Residence Number	char	1	0		1	1, 2, 3, 4, 5, 6	Allow NULL?
274	UserSign2	Updating User	int	6	0	OUSR			Allow NULL?
275	PlngGroup	Planning Group	nvarchar	10	0				Allow NULL?
276	VatIDNum	VAT ID Number	nvarchar	32	0				Allow NULL?
277	Affiliate	Affiliate	char	1	0		N	N, Y	Allow NULL?
278	MivzExpSts	Mivzak Export Status	char	1	0		B	B, D, U	Allow NULL?
279	HierchDdct	Hierarchical Deduction	char	1	0		Y	N, Y	Allow NULL?
280	CertWHT	Withholding Tax Certified	char	1	0		N	N, Y	Allow NULL?
281	CertBKeep	Bookkeeping Certified	char	1	0		N	N, Y	Allow NULL?
282	WHShaamGrp	Withholding Shaam Group	char	1	0		1	1, 2, 3, 4, 5	Allow NULL?
283	IndustryC	Industry	int	11	0	OOND			Allow NULL?
284	DatevAcct	DATEV Account	int	11	0				Allow NULL?
285	DatevFirst	First Data Entry	char	1	0		Y	N, Y	Allow NULL?
286	GTSRegNum	GTS Registration Number	nvarchar	15	0				Allow NULL?
287	GTSBankAct	GTS Bank Account	nvarchar	80	0				Allow NULL?
288	GTSBilAddr	GTS Billing Address	nvarchar	80	0				Allow NULL?
289	HsBnkSwift	House Bank BIC/SWIFT Code	nvarchar	50	0				Allow NULL?
290	HsBnkIBAN	House Bank IBAN	nvarchar	50	0				Allow NULL?
291	DflSwift	Default Bank BIC/SWIFT Code	nvarchar	50	0				Allow NULL?
292	AutoPost	Automatic Posting	char	1	0		N		Allow NULL?
293	IntrAcc	Interest Account	nvarchar	15	0				Allow NULL?
294	FeeAcc	Fee Account	nvarchar	15	0				Allow NULL?
295	CpnNo	Campaign No.	int	11	0	OCPN			Allow NULL?
296	NTSWebSite	E-Tax Web Site	int	6	0	OTWS			Allow NULL?
297	DflIBAN	Default Bank IBAN	nvarchar	50	0				Allow NULL?
298	Series	Series	int	6	0	NNM1			Allow NULL?
299	Number	Number	int	11	0				Allow NULL?
300	EDocExpFrm	Electronic Doc. Export Format	int	11	0				Allow NULL?
301	TaxIdIdent	Tax ID Category	char	1	0		3	1, 2, 3, 5	Allow NULL?
302	Attachment	Attachment	text	16	0
303	AtcEntry	Attachment Entry	int	11	0				Allow NULL?

TOP B1 8.82 | ACRD INDEXES

Name	Primary	Unique	Columns
PRIMARY	No	Yes	CardCode, LogInstanc
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

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

303 COLUMNS | 9 INDEXES | B1 8.82 | ACRD TABLE

TOP B1 8.82 | ACRD COLUMNS

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

303 COLUMNS | 9 INDEXES | B1 8.82 | ACRD TABLE

TOPB1 8.82 | ACRD COLUMNS

TOPB1 8.82 | ACRD INDEXES

TOP B1 8.82 | ACRD COLUMNS

TOP B1 8.82 | ACRD INDEXES