ACRD - biuan.com SDK Developer - SAP® Business ONE (SBO)

API SB Obob / Get Table List

ACRD - Business Partners - History Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
CardCode ^KEY ^UNIQUE	BP Code	nVarChar		15			PRIMARY	Yes
CardName	BP Name	nVarChar		100
CardType	BP Type	VarChar	C) Customer S) Vendor L) Lead	1		C
GroupCode	Group Code	Int		6	OCRG Card Groups
CmpPrivate	Company/Private/Government	VarChar	C) Company I) Private G) Government	1		C
Address	Bill-to Street	nVarChar		100
ZipCode	Bill-to Zip Code	nVarChar		20
MailAddres	Ship-to Street	nVarChar		100
MailZipCod	Ship-to Zip Code	nVarChar		20
Phone1	Telephone 1	nVarChar		20
Phone2	Telephone 2	nVarChar		20
Fax	Fax Number	nVarChar		20
CntctPrsn	Contact Person	nVarChar		90
Notes	Remarks	nVarChar		100
Balance	Account Balance	Num		20
ChecksBal	Open Checks Balance	Num		20
DNotesBal	Open Del. Notes\GRPO Balance	Num		20
OrdersBal	Open Orders Balance	Num		20
GroupNum	Payment Terms Code	Int		6	OCTG Payment Terms	-1
CreditLine	Credit Limit	Num		20
DebtLine	Commitment Limit	Num		20
Discount	Discount %	Num		20
VatStatus	Tax Definition	VarChar	Y) Liable N) Exempted E) EU	1		Y
LicTradNum	Federal Tax ID	nVarChar		32
DdctStatus	Liable for Ded. at Source	VarChar	Y) Yes N) No	1		N
DdctPrcnt	% Withholding Tax Deduction	Num		20
ValidUntil	Expiration Date for -% of Deduction	Date		8
Chrctrstcs	Properties	Int		11
ExMatchNum	Last Ext. Reconciliation No.	Int		11
InMatchNum	Last Int. Reconciliation No.	Int		11
ListNum	Price List No.	Int		6	OPLN Price Lists
DNoteBalFC	Open DN Balance (BP Currency)	Num		20
OrderBalFC	Open Orders Balance (BP Crcy)	Num		20
DNoteBalSy	Open DN Balance (SC)	Num		20
OrderBalSy	Open Orders Balance (SC)	Num		20
Transfered	Year Transfer	VarChar	Y) Yes N) No	1		N
BalTrnsfrd	Balances Transferred	VarChar	Y) Yes N) No	1		N
IntrstRate	Interest % on Liabilities	Num		20
Commission	Commission % for Customer	Num		20
CommGrCode	Commission Group	Int		6	OCOG Commission Groups	0
Free_Text	Free Text	Text		16
SlpCode	Sales Employee Code	Int		11	OSLP Sales Employee	-1
PrevYearAc	Previous Year Balance	VarChar	Y) Yes N) No	1		N
Currency	BP Currency	nVarChar		3	OCRN Currency Codes
RateDifAct	Rate Differences Account	nVarChar		15	OACT G/L Accounts
BalanceSys	Balance (Account Currency)	Num		20
BalanceFC	BP Balance in FC	Num		20
Protected	Protected BP	VarChar	Y) Yes N) No	1		N
Cellular	Mobile Phone Number	nVarChar		50
AvrageLate	Average Payment Delay in Days	Int		6
City	Bill-to City	nVarChar		100
County	Bill-to County	nVarChar		100
Country	Bill-to Country	nVarChar		3
MailCity	Ship-to City	nVarChar		100
MailCounty	Ship-to County	nVarChar		100
MailCountr	Ship-to Country	nVarChar		3
E_Mail	E-Mail	nVarChar		100
Picture	Picture	nVarChar		127
DflAccount	Default Account	nVarChar		50
DflBranch	Default Branch	nVarChar		50
BankCode	Default Bank	nVarChar		30		-1
AddID	Additional ID No.	nVarChar		64
Pager	Pager No.	nVarChar		30
FatherCard	Consolidating BP	nVarChar		15	OCRD Business Partner
CardFName	Foreign Name	nVarChar		100
FatherType	Parent Summary Type	VarChar	P) Payment Consolidation D) Delivery Consolidation	1		P
QryGroup1	Property 1	VarChar	Y) Yes N) No	1		N
QryGroup2	Property 2	VarChar	Y) Yes N) No	1		N
QryGroup3	Property 3	VarChar	Y) Yes N) No	1		N
QryGroup4	Property 4	VarChar	Y) Yes N) No	1		N
QryGroup5	Property 5	VarChar	Y) Yes N) No	1		N
QryGroup6	Property 6	VarChar	Y) Yes N) No	1		N
QryGroup7	Property 7	VarChar	Y) Yes N) No	1		N
QryGroup8	Property 8	VarChar	Y) Yes N) No	1		N
QryGroup9	Property 9	VarChar	Y) Yes N) No	1		N
QryGroup10	Property 10	VarChar	Y) Yes N) No	1		N
QryGroup11	Property 11	VarChar	Y) Yes N) No	1		N
QryGroup12	Property 12	VarChar	Y) Yes N) No	1		N
QryGroup13	Property 13	VarChar	Y) Yes N) No	1		N
QryGroup14	Property 14	VarChar	Y) Yes N) No	1		N
QryGroup15	Property 15	VarChar	Y) Yes N) No	1		N
QryGroup16	Property 16	VarChar	Y) Yes N) No	1		N
QryGroup17	Property 17	VarChar	Y) Yes N) No	1		N
QryGroup18	Property 18	VarChar	Y) Yes N) No	1		N
QryGroup19	Property 19	VarChar	Y) Yes N) No	1		N
QryGroup20	Property 20	VarChar	Y) Yes N) No	1		N
QryGroup21	Property 21	VarChar	Y) Yes N) No	1		N
QryGroup22	Property 22	VarChar	Y) Yes N) No	1		N
QryGroup23	Property 23	VarChar	Y) Yes N) No	1		N
QryGroup24	Property 24	VarChar	Y) Yes N) No	1		N
QryGroup25	Property 25	VarChar	Y) Yes N) No	1		N
QryGroup26	Property 26	VarChar	Y) Yes N) No	1		N
QryGroup27	Property 27	VarChar	Y) Yes N) No	1		N
QryGroup28	Property 28	VarChar	Y) Yes N) No	1		N
QryGroup29	Property 29	VarChar	Y) Yes N) No	1		N
QryGroup30	Property 30	VarChar	Y) Yes N) No	1		N
QryGroup31	Property 31	VarChar	Y) Yes N) No	1		N
QryGroup32	Property 32	VarChar	Y) Yes N) No	1		N
QryGroup33	Property 33	VarChar	Y) Yes N) No	1		N
QryGroup34	Property 34	VarChar	Y) Yes N) No	1		N
QryGroup35	Property 35	VarChar	Y) Yes N) No	1		N
QryGroup36	Property 36	VarChar	Y) Yes N) No	1		N
QryGroup37	Property 37	VarChar	Y) Yes N) No	1		N
QryGroup38	Property 38	VarChar	Y) Yes N) No	1		N
QryGroup39	Property 39	VarChar	Y) Yes N) No	1		N
QryGroup40	Property 40	VarChar	Y) Yes N) No	1		N
QryGroup41	Property 41	VarChar	Y) Yes N) No	1		N
QryGroup42	Property 42	VarChar	Y) Yes N) No	1		N
QryGroup43	Property 43	VarChar	Y) Yes N) No	1		N
QryGroup44	Property 44	VarChar	Y) Yes N) No	1		N
QryGroup45	Property 45	VarChar	Y) Yes N) No	1		N
QryGroup46	Property 46	VarChar	Y) Yes N) No	1		N
QryGroup47	Property 47	VarChar	Y) Yes N) No	1		N
QryGroup48	Property 48	VarChar	Y) Yes N) No	1		N
QryGroup49	Property 49	VarChar	Y) Yes N) No	1		N
QryGroup50	Property 50	VarChar	Y) Yes N) No	1		N
QryGroup51	Property 51	VarChar	Y) Yes N) No	1		N
QryGroup52	Property 52	VarChar	Y) Yes N) No	1		N
QryGroup53	Property 53	VarChar	Y) Yes N) No	1		N
QryGroup54	Property 54	VarChar	Y) Yes N) No	1		N
QryGroup55	Property 55	VarChar	Y) Yes N) No	1		N
QryGroup56	Property 56	VarChar	Y) Yes N) No	1		N
QryGroup57	Property 57	VarChar	Y) Yes N) No	1		N
QryGroup58	Property 58	VarChar	Y) Yes N) No	1		N
QryGroup59	Property 59	VarChar	Y) Yes N) No	1		N
QryGroup60	Property 60	VarChar	Y) Yes N) No	1		N
QryGroup61	Property 61	VarChar	Y) Yes N) No	1		N
QryGroup62	Property 62	VarChar	Y) Yes N) No	1		N
QryGroup63	Property 63	VarChar	Y) Yes N) No	1		N
QryGroup64	Property 64	VarChar	Y) Yes N) No	1		N
DdctOffice	Deduction Approval Office	nVarChar		10
CreateDate	Creation Date	Date		8
UpdateDate	Date of Update	Date		8
ExportCode	Data Export Code	nVarChar		8
DscntObjct	Subject for Discount	Int	-1) 52) Groups 8) Properties 43) Companies 4) Items	6		-1
DscntRel	Discounts Ratio	VarChar	L) Lowest Discount H) Highest Discount A) Average Disc. S) Discount Totals M) Discount Multiples	1		L
SPGCounter	SPG Counter	Int		6
SPPCounter	SPP Counter	Int		11
DdctFileNo	Tax Deduction File No.	nVarChar		9
SCNCounter	SCN Counter	Int		6
MinIntrst	Min. Interest Letter Amount	Num		20
DataSource	Data Source	VarChar	N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer	1		N
OprCount	Open Opportunities	Int		11
ExemptNo	Exempt No.	nVarChar		50
Priority	Priority	Int		11	OBPP BP Priorities	-1
CreditCard	Credit Cards	Int		6	OCRC Credit Cards	-1
CrCardNum	Credit Card No.	nVarChar		64
CardValid	Credit Card Validity	Date		8
UserSign	User Signature	Int		6	OUSR Users
LocMth	Reconciliation (LC)	VarChar	Y) Yes N) No	1		Y
validFor	Active	VarChar	Y) Yes N) No	1		N
validFrom	Active From	Date		8
validTo	Active To	Date		8
frozenFor	Inactive	VarChar	Y) Yes N) No	1		N
frozenFrom	Inactive From	Date		8
frozenTo	Inactive To	Date		8
sEmployed	Self-Employed	VarChar	Y) Yes N) No	1		N
MTHCounter	Match History Counter	Int		11
BNKCounter	BNK Counter	Int		11
DdgKey	WTax Deduction - Group	Int		11	ODDG Withholding Tax Deduction Groups	-1
DdtKey	Current Deduction Hierarchy	Int		11		-1
ValidComm	Active Remarks	nVarChar		30
FrozenComm	Inactive Remarks	nVarChar		30
chainStore	Belongs to Retail Store	VarChar	Y) Yes N) No	1		N
DiscInRet	Allow Doc Discount in Returns	VarChar	Y) Yes N) No	1		N
State1	Bill-to State	nVarChar		3	OCST States
State2	Ship-to State	nVarChar		3	OCST States
VatGroup	Tax Code	nVarChar		8	OSTC Sales Tax Codes
LogInstanc	Log Instance	Int		11		0
ObjType	Object Type	nVarChar		20	ADP1 Object Settings - History	2
Indicator	Indicator	nVarChar		2	OIDC Indicator
ShipType	Shipping Type	Int		6	OSHP Delivery Types
DebPayAcct	Control Account	nVarChar		15	OACT G/L Accounts
ShipToDef	Ship to - Default	nVarChar		50
Block	Block	nVarChar		100
MailBlock	Delivery Block	nVarChar		100
Password	Password	nVarChar		32
ECVatGroup	Tax Group	nVarChar		8	OVTG Tax Definition
Deleted	Deleted	VarChar	Y) Yes N) No	1		N
IBAN	IBAN	nVarChar		50
DocEntry ^KEY ^UNIQUE	Numerator	Int		11			ABS_ENTRY	Yes
FormCode	1099 Form Code	Int		11	OTNN 1099 Forms
Box1099	1099 Box	nVarChar		20
PymCode	Payment Method Code	nVarChar		15	OPYM Payment Methods for Payment Wizard	-1
BackOrder	Backorder	VarChar	Y) Yes N) No	1		Y
PartDelivr	Partial Delivery	VarChar	Y) Yes N) No	1		Y
DunnLevel	Dunning Level	Int		11	ODUN Dunning Letters
DunnDate	Dunning Date	Date		8
BlockDunn	Block Dunning	VarChar	Y) Yes N) No	1		N
BankCountr	Bank Country	nVarChar		3	OCRY Countries
CollecAuth	Collection Authorization	VarChar	N) No Y) Yes	1		N
DME	DME Identification	nVarChar		5
InstrucKey	Instruction Key	nVarChar		30
SinglePaym	Single Payment	VarChar	N) No Y) Yes	1		N
ISRBillId	ISR Biller ID	nVarChar		9
PaymBlock	Payment Block	VarChar	N) No Y) Yes	1		N
RefDetails	Reference Details	nVarChar		20
HouseBank	House Bank	nVarChar		30		-1
OwnerIdNum	ID Number	nVarChar		15
PyBlckDesc	Payment Block Description	Int		11	OPYB Payment Block	-1
HousBnkCry	House Bank Country	nVarChar		3
HousBnkAct	House Bank Account	nVarChar		50
HousBnkBrn	House Bank Branch	nVarChar		50
ProjectCod	Project Code	nVarChar		20	OPRJ Project Codes
SysMatchNo	Last Sys. Reconciliation No.	Int		11		-1
VatIdUnCmp	VAT ID for Unified Company	nVarChar		32
AgentCode	Agent Code	nVarChar		32	OAGP Agent Name
TolrncDays	Tolerance Days	Int		6
SelfInvoic	Self Invoice	VarChar		1
DeferrTax	Deferred Tax	VarChar	Y) Yes N) No	1
LetterNum	Tax Exemption Letter No.	nVarChar		20
MaxAmount	Max. Exemption Amount	Num		20
FromDate	Exemption Validity Date From	Date		8
ToDate	Exemption Validity Date To	Date		8
WTLiable	Subject to Withholding Tax	VarChar	Y) Yes N) No	1
CrtfcateNO	Certificate Number	nVarChar		20
ExpireDate	Expiration Date	Date		8
NINum	Registration No.	nVarChar		20
AccCritria	Accrued Criteria	VarChar	Y) Yes N) No	1		N
WTCode	Withholding Tax Code	nVarChar		4	OWHT Withholding Tax
Equ	Equalization Tax	VarChar	Y) Yes N) No	1		N
HldCode	Holiday Set Name	nVarChar		20	OHLD Holiday Table
ConnBP	Linked Business Partner	nVarChar		15	OCRD Business Partner
MltMthNum	Last Multi. Reconciliation No.	Int		11
TypWTReprt	BP Type for WTax Report	VarChar	C) Company P) Person	1		C
VATRegNum	VAT Reg. Number	nVarChar		32
RepName	Representative Name	nVarChar		15
Industry	Industry	Text		16
Business	Business	Text		16
WTTaxCat	Withholding Tax Cat.	Text		16
IsDomestic	Is Domestic	VarChar	Y) Domestic N) Foreign	1		Y
IsResident	Is Resident	VarChar	Y) Resident N) Non-Resident	1		Y
AutoCalBCG	Auto Calculated Bank Charges	VarChar	N) No Y) Yes	1		N
OtrCtlAcct	Other Receivable/Payable	nVarChar		15	OACT G/L Accounts
AliasName	Alias Name	Text		16
Building	Bill-to Building/Floor/Room	Text		16
MailBuildi	Ship to Building/Floor/Room	Text		16
BoEPrsnt	Customer BoE Presentation	nVarChar		15	OACT G/L Accounts
BoEDiscnt	Customer BoE Discounted	nVarChar		15	OACT G/L Accounts
BoEOnClct	Bill of Exchange on Collection	nVarChar		15	OACT G/L Accounts
UnpaidBoE	Unpaid Bill of Exchange	nVarChar		15	OACT G/L Accounts
ITWTCode	Income Tax WTax Code	nVarChar		4	OWHT Withholding Tax
DunTerm	Dunning Term	nVarChar		25	ODUT Dunning Terms
ChannlBP	Channel BP	nVarChar		15	OCRD Business Partner
DfTcnician	Default Technician	Int		11	OHEM Employees
Territory	Territory	Int		11	OTER Territories
BillToDef	Bill-to Default	nVarChar		50
DpmClear	Payment Advances	nVarChar		15	OACT G/L Accounts
IntrntSite	Web Site	nVarChar		100
LangCode	Language Code	Int		11	OLNG User Language Table
HousActKey	House Bank Account Key	Int		11	DSC1 House Bank Accounts
Profession	Profession	nVarChar		50
CDPNum	Closing Date Procedure No.	Int		6	OCDP Closing Date Procedure
DflBankKey	Default Bank ID	Int		11	ODSC Bank Codes
BCACode	Bank Charges Allocation Codes	nVarChar		3	OBCA Bank Charges Allocation Codes
UseShpdGd	Use Shipped Goods Account	VarChar	Y) Yes N) No	1		Y
RegNum	Company Reg. No. (CRN)	nVarChar		32
VerifNum	Verification No.	nVarChar		32
BankCtlKey	Default Bank Internal ID	nVarChar		2
HousCtlKey	House Bank Control Number	nVarChar		2
AddrType	Bill-to Address Type	nVarChar		100
InsurOp347	347 Insurance Operation	VarChar	N) No Y) Yes	1		N
MailAddrTy	Ship-to Address Type	nVarChar		100
StreetNo	Bill-to Street No.	nVarChar		100
MailStrNo	Ship-to Street No.	nVarChar		100
TaxRndRule	Tax Rounding Rule	VarChar	D) Company Default R) Round Off C) Round Up F) Round Down	1		D
VendTID	Vender Type ID	Int		11	OVTP Vendor Type
ThreshOver	Threshold Overlook	VarChar	Y) Yes N) No	1		N
SurOver	Surcharge Overlook	VarChar	Y) Yes N) No	1		N
VendorOcup	Vendor Occupation	nVarChar		15
OpCode347	347 Operation Code	VarChar	A) Goods or Services Acquisitions D) Public Entities Acquisitions G) Travel Agent Purchases B) Sales or Services Revenues E) Public Subsidies F) Travel Agent Sales	1		A
DpmIntAct	DPM Interim Account	nVarChar		15	OACT G/L Accounts
ResidenNum	Residence Number	VarChar	1) Spanish Fiscal ID 2) VAT Registration Number 3) Passport 4) Fiscal ID Issued by the Country of Residence 5) Certificate of Fiscal Residence 6) Other Document	1		1
UserSign2	Updating User	Int		6	OUSR Users
PlngGroup	Planning Group	nVarChar		10
VatIDNum	VAT ID Number	nVarChar		32
Affiliate	Affiliate	VarChar	Y) Yes N) No	1		N
MivzExpSts	Mivzak Export Status	VarChar	B) Not Exported U) Exported D) Deleted	1		B
HierchDdct	Hierarchical Deduction	VarChar	Y) Yes N) No	1		Y
CertWHT	Withholding Tax Certified	VarChar	Y) Yes N) No	1		N
CertBKeep	Bookkeeping Certified	VarChar	Y) Yes N) No	1		N
WHShaamGrp	Withholding Shaam Group	VarChar	1) Services and Asset 2) Agricultural Products 3) Insurance Commissions 4) Withholding Tax Instructions 5) Interest Exchange Rate Differences	1		1
IndustryC	Industry	Int		11	OOND Industries
DatevAcct	DATEV Account	Int		11
DatevFirst	First Data Entry	VarChar	Y) Yes N) No	1		Y
GTSRegNum	GTS Registration Number	nVarChar		20
GTSBankAct	GTS Bank Account	nVarChar		80
GTSBilAddr	GTS Billing Address	nVarChar		80
HsBnkSwift	House Bank BIC/SWIFT Code	nVarChar		50
HsBnkIBAN	House Bank IBAN	nVarChar		50
DflSwift	Default Bank BIC/SWIFT Code	nVarChar		50
AutoPost	Automatic Posting	VarChar		1		N
IntrAcc	Interest Account	nVarChar		15
FeeAcc	Fee Account	nVarChar		15
CpnNo	Campaign No.	Int		11	OCPN Campaign
NTSWebSite	E-Tax Web Site	Int		6	OTWS E-Tax Web Site
DflIBAN	Default Bank IBAN	nVarChar		50
Series	Series	Int		6	NNM1 Documents Numbering - Series
Number	Number	Int		11
EDocExpFrm	Electronic Doc. Export Format	Int		11
TaxIdIdent	Tax ID Category	VarChar	1) Self-Employed 2) Company 3) Registered Business 5) International Company	1		3
Attachment	Attachment	Text		16
AtcEntry	Attachment Entry	Int		11
DiscRel	Disc. Relations	VarChar	L) Lowest Discount H) Highest Discount A) Average S) Total M) Discount Multiples	1		L
NoDiscount	No Discounts	VarChar	Y) Yes N) No	1		N
SCAdjust	SC Adjustment	VarChar	Y) Yes N) No	1		N
DflAgrmnt	Default Blanket Agreement No.	Int		11	OOAT Blanket Agreement
GlblLocNum	Global Location Number	nVarChar		50
SenderID	EDI Message Sender ID	nVarChar		50
RcpntID	EDI Message Recipient ID	nVarChar		50
MainUsage	Main Usage	Int		11
SefazCheck	Check BP Status on SEFAZ	VarChar	Y) Yes N) No	1		N
free312	Reply from SEFAZ	VarChar		1
free313	Date of Update from SEFAZ	VarChar		1
DateFrom	Relationship Initial Date	Date		8
DateTill	Relationship Final Date	Date		8
RelCode	Relationship Code	nVarChar		2
OKATO	OKATO	nVarChar		11
OKTMO	OKTMO	nVarChar		12
KBKCode	KBK Budget Classification Code	nVarChar		20
TypeOfOp	Type of Operation	VarChar	P) Professional Services R) Renting Assets O) Others	1
OwnerCode	Document Owner	Int		11	OHEM Employees
MandateID	Mandate ID	nVarChar		35
SignDate	Date of Signature	Date		8
Remark1	Remark 1	Int		11	ORMK Remark 1
ConCerti	Concessional Certificate	nVarChar		20
TpCusPres	Type of End-User Presence	Int		11	OBNI Brazil Numeric Indexer	9
RoleTypCod	Role Type Code	nVarChar		2
BlockComm	Block Sending Marketing	VarChar	N) No Y) Yes	1		N
EmplymntCt	Employment Category	nVarChar		2
ExcptnlEvt	Exceptional Event	VarChar		1
ExpnPrfFnd	Professional Funds Expenses	Num		20

Table relationship map

SELECT statement

SELECT
   ACRD.CardCode AS 'BP Code', 
   ACRD.CardName AS 'BP Name', 
   ACRD.CardType AS 'BP Type', 
   ACRD.GroupCode AS 'Group Code', 
   ACRD.CmpPrivate AS 'Company/Private/Government', 
   ACRD.Address AS 'Bill-to Street', 
   ACRD.ZipCode AS 'Bill-to Zip Code', 
   ACRD.MailAddres AS 'Ship-to Street', 
   ACRD.MailZipCod AS 'Ship-to Zip Code', 
   ACRD.Phone1 AS 'Telephone 1', 
   ACRD.Phone2 AS 'Telephone 2', 
   ACRD.Fax AS 'Fax Number', 
   ACRD.CntctPrsn AS 'Contact Person', 
   ACRD.Notes AS 'Remarks', 
   ACRD.Balance AS 'Account Balance', 
   ACRD.ChecksBal AS 'Open Checks Balance', 
   ACRD.DNotesBal AS 'Open Del. Notes\GRPO Balance', 
   ACRD.OrdersBal AS 'Open Orders Balance', 
   ACRD.GroupNum AS 'Payment Terms Code', 
   ACRD.CreditLine AS 'Credit Limit', 
   ACRD.DebtLine AS 'Commitment Limit', 
   ACRD.Discount AS 'Discount %', 
   ACRD.VatStatus AS 'Tax Definition', 
   ACRD.LicTradNum AS 'Federal Tax ID', 
   ACRD.DdctStatus AS 'Liable for Ded. at Source', 
   ACRD.DdctPrcnt AS '% Withholding Tax Deduction', 
   ACRD.ValidUntil AS 'Expiration Date for -% of Deduction', 
   ACRD.Chrctrstcs AS 'Properties', 
   ACRD.ExMatchNum AS 'Last Ext. Reconciliation No.', 
   ACRD.InMatchNum AS 'Last Int. Reconciliation No.', 
   ACRD.ListNum AS 'Price List No.', 
   ACRD.DNoteBalFC AS 'Open DN Balance (BP Currency)', 
   ACRD.OrderBalFC AS 'Open Orders Balance (BP Crcy)', 
   ACRD.DNoteBalSy AS 'Open DN Balance (SC)', 
   ACRD.OrderBalSy AS 'Open Orders Balance (SC)', 
   ACRD.Transfered AS 'Year Transfer', 
   ACRD.BalTrnsfrd AS 'Balances Transferred', 
   ACRD.IntrstRate AS 'Interest % on Liabilities', 
   ACRD.Commission AS 'Commission % for Customer', 
   ACRD.CommGrCode AS 'Commission Group', 
   ACRD.Free_Text AS 'Free Text', 
   ACRD.SlpCode AS 'Sales Employee Code', 
   ACRD.PrevYearAc AS 'Previous Year Balance', 
   ACRD.Currency AS 'BP Currency', 
   ACRD.RateDifAct AS 'Rate Differences Account', 
   ACRD.BalanceSys AS 'Balance (Account Currency)', 
   ACRD.BalanceFC AS 'BP Balance in FC', 
   ACRD.Protected AS 'Protected BP', 
   ACRD.Cellular AS 'Mobile Phone Number', 
   ACRD.AvrageLate AS 'Average Payment Delay in Days', 
   ACRD.City AS 'Bill-to City', 
   ACRD.County AS 'Bill-to County', 
   ACRD.Country AS 'Bill-to Country', 
   ACRD.MailCity AS 'Ship-to City', 
   ACRD.MailCounty AS 'Ship-to County', 
   ACRD.MailCountr AS 'Ship-to Country', 
   ACRD.E_Mail AS 'E-Mail', 
   ACRD.Picture AS 'Picture', 
   ACRD.DflAccount AS 'Default Account', 
   ACRD.DflBranch AS 'Default Branch', 
   ACRD.BankCode AS 'Default Bank', 
   ACRD.AddID AS 'Additional ID No.', 
   ACRD.Pager AS 'Pager No.', 
   ACRD.FatherCard AS 'Consolidating BP', 
   ACRD.CardFName AS 'Foreign Name', 
   ACRD.FatherType AS 'Parent Summary Type', 
   ACRD.QryGroup1 AS 'Property 1', 
   ACRD.QryGroup2 AS 'Property 2', 
   ACRD.QryGroup3 AS 'Property 3', 
   ACRD.QryGroup4 AS 'Property 4', 
   ACRD.QryGroup5 AS 'Property 5', 
   ACRD.QryGroup6 AS 'Property 6', 
   ACRD.QryGroup7 AS 'Property 7', 
   ACRD.QryGroup8 AS 'Property 8', 
   ACRD.QryGroup9 AS 'Property 9', 
   ACRD.QryGroup10 AS 'Property 10', 
   ACRD.QryGroup11 AS 'Property 11', 
   ACRD.QryGroup12 AS 'Property 12', 
   ACRD.QryGroup13 AS 'Property 13', 
   ACRD.QryGroup14 AS 'Property 14', 
   ACRD.QryGroup15 AS 'Property 15', 
   ACRD.QryGroup16 AS 'Property 16', 
   ACRD.QryGroup17 AS 'Property 17', 
   ACRD.QryGroup18 AS 'Property 18', 
   ACRD.QryGroup19 AS 'Property 19', 
   ACRD.QryGroup20 AS 'Property 20', 
   ACRD.QryGroup21 AS 'Property 21', 
   ACRD.QryGroup22 AS 'Property 22', 
   ACRD.QryGroup23 AS 'Property 23', 
   ACRD.QryGroup24 AS 'Property 24', 
   ACRD.QryGroup25 AS 'Property 25', 
   ACRD.QryGroup26 AS 'Property 26', 
   ACRD.QryGroup27 AS 'Property 27', 
   ACRD.QryGroup28 AS 'Property 28', 
   ACRD.QryGroup29 AS 'Property 29', 
   ACRD.QryGroup30 AS 'Property 30', 
   ACRD.QryGroup31 AS 'Property 31', 
   ACRD.QryGroup32 AS 'Property 32', 
   ACRD.QryGroup33 AS 'Property 33', 
   ACRD.QryGroup34 AS 'Property 34', 
   ACRD.QryGroup35 AS 'Property 35', 
   ACRD.QryGroup36 AS 'Property 36', 
   ACRD.QryGroup37 AS 'Property 37', 
   ACRD.QryGroup38 AS 'Property 38', 
   ACRD.QryGroup39 AS 'Property 39', 
   ACRD.QryGroup40 AS 'Property 40', 
   ACRD.QryGroup41 AS 'Property 41', 
   ACRD.QryGroup42 AS 'Property 42', 
   ACRD.QryGroup43 AS 'Property 43', 
   ACRD.QryGroup44 AS 'Property 44', 
   ACRD.QryGroup45 AS 'Property 45', 
   ACRD.QryGroup46 AS 'Property 46', 
   ACRD.QryGroup47 AS 'Property 47', 
   ACRD.QryGroup48 AS 'Property 48', 
   ACRD.QryGroup49 AS 'Property 49', 
   ACRD.QryGroup50 AS 'Property 50', 
   ACRD.QryGroup51 AS 'Property 51', 
   ACRD.QryGroup52 AS 'Property 52', 
   ACRD.QryGroup53 AS 'Property 53', 
   ACRD.QryGroup54 AS 'Property 54', 
   ACRD.QryGroup55 AS 'Property 55', 
   ACRD.QryGroup56 AS 'Property 56', 
   ACRD.QryGroup57 AS 'Property 57', 
   ACRD.QryGroup58 AS 'Property 58', 
   ACRD.QryGroup59 AS 'Property 59', 
   ACRD.QryGroup60 AS 'Property 60', 
   ACRD.QryGroup61 AS 'Property 61', 
   ACRD.QryGroup62 AS 'Property 62', 
   ACRD.QryGroup63 AS 'Property 63', 
   ACRD.QryGroup64 AS 'Property 64', 
   ACRD.DdctOffice AS 'Deduction Approval Office', 
   ACRD.CreateDate AS 'Creation Date', 
   ACRD.UpdateDate AS 'Date of Update', 
   ACRD.ExportCode AS 'Data Export Code', 
   ACRD.DscntObjct AS 'Subject for Discount', 
   ACRD.DscntRel AS 'Discounts Ratio', 
   ACRD.SPGCounter AS 'SPG Counter', 
   ACRD.SPPCounter AS 'SPP Counter', 
   ACRD.DdctFileNo AS 'Tax Deduction File No.', 
   ACRD.SCNCounter AS 'SCN Counter', 
   ACRD.MinIntrst AS 'Min. Interest Letter Amount', 
   ACRD.DataSource AS 'Data Source', 
   ACRD.OprCount AS 'Open Opportunities', 
   ACRD.ExemptNo AS 'Exempt No.', 
   ACRD.Priority AS 'Priority', 
   ACRD.CreditCard AS 'Credit Cards', 
   ACRD.CrCardNum AS 'Credit Card No.', 
   ACRD.CardValid AS 'Credit Card Validity', 
   ACRD.UserSign AS 'User Signature', 
   ACRD.LocMth AS 'Reconciliation (LC)', 
   ACRD.validFor AS 'Active', 
   ACRD.validFrom AS 'Active From', 
   ACRD.validTo AS 'Active To', 
   ACRD.frozenFor AS 'Inactive', 
   ACRD.frozenFrom AS 'Inactive From', 
   ACRD.frozenTo AS 'Inactive To', 
   ACRD.sEmployed AS 'Self-Employed', 
   ACRD.MTHCounter AS 'Match History Counter', 
   ACRD.BNKCounter AS 'BNK Counter', 
   ACRD.DdgKey AS 'WTax Deduction - Group', 
   ACRD.DdtKey AS 'Current Deduction Hierarchy', 
   ACRD.ValidComm AS 'Active Remarks', 
   ACRD.FrozenComm AS 'Inactive Remarks', 
   ACRD.chainStore AS 'Belongs to Retail Store', 
   ACRD.DiscInRet AS 'Allow Doc Discount in Returns', 
   ACRD.State1 AS 'Bill-to State', 
   ACRD.State2 AS 'Ship-to State', 
   ACRD.VatGroup AS 'Tax Code', 
   ACRD.LogInstanc AS 'Log Instance', 
   ACRD.ObjType AS 'Object Type', 
   ACRD.Indicator AS 'Indicator', 
   ACRD.ShipType AS 'Shipping Type', 
   ACRD.DebPayAcct AS 'Control Account', 
   ACRD.ShipToDef AS 'Ship to - Default', 
   ACRD.Block AS 'Block', 
   ACRD.MailBlock AS 'Delivery Block', 
   ACRD.Password AS 'Password', 
   ACRD.ECVatGroup AS 'Tax Group', 
   ACRD.Deleted AS 'Deleted', 
   ACRD.IBAN AS 'IBAN', 
   ACRD.DocEntry AS 'Numerator', 
   ACRD.FormCode AS '1099 Form Code', 
   ACRD.Box1099 AS '1099 Box', 
   ACRD.PymCode AS 'Payment Method Code', 
   ACRD.BackOrder AS 'Backorder', 
   ACRD.PartDelivr AS 'Partial Delivery', 
   ACRD.DunnLevel AS 'Dunning Level', 
   ACRD.DunnDate AS 'Dunning Date', 
   ACRD.BlockDunn AS 'Block Dunning', 
   ACRD.BankCountr AS 'Bank Country', 
   ACRD.CollecAuth AS 'Collection Authorization', 
   ACRD.DME AS 'DME Identification', 
   ACRD.InstrucKey AS 'Instruction Key', 
   ACRD.SinglePaym AS 'Single Payment', 
   ACRD.ISRBillId AS 'ISR Biller ID', 
   ACRD.PaymBlock AS 'Payment Block', 
   ACRD.RefDetails AS 'Reference Details', 
   ACRD.HouseBank AS 'House Bank', 
   ACRD.OwnerIdNum AS 'ID Number', 
   ACRD.PyBlckDesc AS 'Payment Block Description', 
   ACRD.HousBnkCry AS 'House Bank Country', 
   ACRD.HousBnkAct AS 'House Bank Account', 
   ACRD.HousBnkBrn AS 'House Bank Branch', 
   ACRD.ProjectCod AS 'Project Code', 
   ACRD.SysMatchNo AS 'Last Sys. Reconciliation No.', 
   ACRD.VatIdUnCmp AS 'VAT ID for Unified Company', 
   ACRD.AgentCode AS 'Agent Code', 
   ACRD.TolrncDays AS 'Tolerance Days', 
   ACRD.SelfInvoic AS 'Self Invoice', 
   ACRD.DeferrTax AS 'Deferred Tax', 
   ACRD.LetterNum AS 'Tax Exemption Letter No.', 
   ACRD.MaxAmount AS 'Max. Exemption Amount', 
   ACRD.FromDate AS 'Exemption Validity Date From', 
   ACRD.ToDate AS 'Exemption Validity Date To', 
   ACRD.WTLiable AS 'Subject to Withholding Tax', 
   ACRD.CrtfcateNO AS 'Certificate Number', 
   ACRD.ExpireDate AS 'Expiration Date', 
   ACRD.NINum AS 'Registration No.', 
   ACRD.AccCritria AS 'Accrued Criteria', 
   ACRD.WTCode AS 'Withholding Tax Code', 
   ACRD.Equ AS 'Equalization Tax', 
   ACRD.HldCode AS 'Holiday Set Name', 
   ACRD.ConnBP AS 'Linked Business Partner', 
   ACRD.MltMthNum AS 'Last Multi. Reconciliation No.', 
   ACRD.TypWTReprt AS 'BP Type for WTax Report', 
   ACRD.VATRegNum AS 'VAT Reg. Number', 
   ACRD.RepName AS 'Representative Name', 
   ACRD.Industry AS 'Industry', 
   ACRD.Business AS 'Business', 
   ACRD.WTTaxCat AS 'Withholding Tax Cat.', 
   ACRD.IsDomestic AS 'Is Domestic', 
   ACRD.IsResident AS 'Is Resident', 
   ACRD.AutoCalBCG AS 'Auto Calculated Bank Charges', 
   ACRD.OtrCtlAcct AS 'Other Receivable/Payable', 
   ACRD.AliasName AS 'Alias Name', 
   ACRD.Building AS 'Bill-to Building/Floor/Room', 
   ACRD.MailBuildi AS 'Ship to Building/Floor/Room', 
   ACRD.BoEPrsnt AS 'Customer BoE Presentation', 
   ACRD.BoEDiscnt AS 'Customer BoE Discounted', 
   ACRD.BoEOnClct AS 'Bill of Exchange on Collection', 
   ACRD.UnpaidBoE AS 'Unpaid Bill of Exchange', 
   ACRD.ITWTCode AS 'Income Tax WTax Code', 
   ACRD.DunTerm AS 'Dunning Term', 
   ACRD.ChannlBP AS 'Channel BP', 
   ACRD.DfTcnician AS 'Default Technician', 
   ACRD.Territory AS 'Territory', 
   ACRD.BillToDef AS 'Bill-to Default', 
   ACRD.DpmClear AS 'Payment Advances', 
   ACRD.IntrntSite AS 'Web Site', 
   ACRD.LangCode AS 'Language Code', 
   ACRD.HousActKey AS 'House Bank Account Key', 
   ACRD.Profession AS 'Profession', 
   ACRD.CDPNum AS 'Closing Date Procedure No.', 
   ACRD.DflBankKey AS 'Default Bank ID', 
   ACRD.BCACode AS 'Bank Charges Allocation Codes', 
   ACRD.UseShpdGd AS 'Use Shipped Goods Account', 
   ACRD.RegNum AS 'Company Reg. No. (CRN)', 
   ACRD.VerifNum AS 'Verification No.', 
   ACRD.BankCtlKey AS 'Default Bank Internal ID', 
   ACRD.HousCtlKey AS 'House Bank Control Number', 
   ACRD.AddrType AS 'Bill-to Address Type', 
   ACRD.InsurOp347 AS '347 Insurance Operation', 
   ACRD.MailAddrTy AS 'Ship-to Address Type', 
   ACRD.StreetNo AS 'Bill-to Street No.', 
   ACRD.MailStrNo AS 'Ship-to Street No.', 
   ACRD.TaxRndRule AS 'Tax Rounding Rule', 
   ACRD.VendTID AS 'Vender Type ID', 
   ACRD.ThreshOver AS 'Threshold Overlook', 
   ACRD.SurOver AS 'Surcharge Overlook', 
   ACRD.VendorOcup AS 'Vendor Occupation', 
   ACRD.OpCode347 AS '347 Operation Code', 
   ACRD.DpmIntAct AS 'DPM Interim Account', 
   ACRD.ResidenNum AS 'Residence Number', 
   ACRD.UserSign2 AS 'Updating User', 
   ACRD.PlngGroup AS 'Planning Group', 
   ACRD.VatIDNum AS 'VAT ID Number', 
   ACRD.Affiliate AS 'Affiliate', 
   ACRD.MivzExpSts AS 'Mivzak Export Status', 
   ACRD.HierchDdct AS 'Hierarchical Deduction', 
   ACRD.CertWHT AS 'Withholding Tax Certified', 
   ACRD.CertBKeep AS 'Bookkeeping Certified', 
   ACRD.WHShaamGrp AS 'Withholding Shaam Group', 
   ACRD.IndustryC AS 'Industry', 
   ACRD.DatevAcct AS 'DATEV Account', 
   ACRD.DatevFirst AS 'First Data Entry', 
   ACRD.GTSRegNum AS 'GTS Registration Number', 
   ACRD.GTSBankAct AS 'GTS Bank Account', 
   ACRD.GTSBilAddr AS 'GTS Billing Address', 
   ACRD.HsBnkSwift AS 'House Bank BIC/SWIFT Code', 
   ACRD.HsBnkIBAN AS 'House Bank IBAN', 
   ACRD.DflSwift AS 'Default Bank BIC/SWIFT Code', 
   ACRD.AutoPost AS 'Automatic Posting', 
   ACRD.IntrAcc AS 'Interest Account', 
   ACRD.FeeAcc AS 'Fee Account', 
   ACRD.CpnNo AS 'Campaign No.', 
   ACRD.NTSWebSite AS 'E-Tax Web Site', 
   ACRD.DflIBAN AS 'Default Bank IBAN', 
   ACRD.Series AS 'Series', 
   ACRD.Number AS 'Number', 
   ACRD.EDocExpFrm AS 'Electronic Doc. Export Format', 
   ACRD.TaxIdIdent AS 'Tax ID Category', 
   ACRD.Attachment AS 'Attachment', 
   ACRD.AtcEntry AS 'Attachment Entry', 
   ACRD.DiscRel AS 'Disc. Relations', 
   ACRD.NoDiscount AS 'No Discounts', 
   ACRD.SCAdjust AS 'SC Adjustment', 
   ACRD.DflAgrmnt AS 'Default Blanket Agreement No.', 
   ACRD.GlblLocNum AS 'Global Location Number', 
   ACRD.SenderID AS 'EDI Message Sender ID', 
   ACRD.RcpntID AS 'EDI Message Recipient ID', 
   ACRD.MainUsage AS 'Main Usage', 
   ACRD.SefazCheck AS 'Check BP Status on SEFAZ', 
   ACRD.free312 AS 'Reply from SEFAZ', 
   ACRD.free313 AS 'Date of Update from SEFAZ', 
   ACRD.DateFrom AS 'Relationship Initial Date', 
   ACRD.DateTill AS 'Relationship Final Date', 
   ACRD.RelCode AS 'Relationship Code', 
   ACRD.OKATO AS 'OKATO', 
   ACRD.OKTMO AS 'OKTMO', 
   ACRD.KBKCode AS 'KBK Budget Classification Code', 
   ACRD.TypeOfOp AS 'Type of Operation', 
   ACRD.OwnerCode AS 'Document Owner', 
   ACRD.MandateID AS 'Mandate ID', 
   ACRD.SignDate AS 'Date of Signature', 
   ACRD.Remark1 AS 'Remark 1', 
   ACRD.ConCerti AS 'Concessional Certificate', 
   ACRD.TpCusPres AS 'Type of End-User Presence', 
   ACRD.RoleTypCod AS 'Role Type Code', 
   ACRD.BlockComm AS 'Block Sending Marketing', 
   ACRD.EmplymntCt AS 'Employment Category', 
   ACRD.ExcptnlEvt AS 'Exceptional Event', 
   ACRD.ExpnPrfFnd AS 'Professional Funds Expenses'
FROM ACRD AS ACRD

Related information

GetTableList Method· Table: ORTT

Returns a Recordset object that contains a list of all the tables in the database. Each table includes its name and description (for example: OCRD, Business Partner.

Parent: SB Obob SBObob Object
ACRD SQL Table

OAGP SQL Table

OCRY SQL Table

OBCA SQL Table

OACT SQL Table

OCDP SQL Table

OCRD SQL Table

OCOG SQL Table

OCPN SQL Table

OCRC SQL Table

OCRN SQL Table

ODDG SQL Table

OOAT SQL Table

ODSC SQL Table

OHEM SQL Table

ODUN SQL Table

ODUT SQL Table

OVTG SQL Table

OTNN SQL Table

OCRG SQL Table

OCTG SQL Table

OHLD SQL Table

DSC1 SQL Table

OIDC SQL Table

OOND SQL Table

OWHT SQL Table

OLNG SQL Table

OPLN SQL Table

OTWS SQL Table

ADP1 SQL Table

OBPP SQL Table

OPRJ SQL Table

OPYB SQL Table

OPYM SQL Table

ORMK SQL Table

NNM1 SQL Table

OSHP SQL Table

OSLP SQL Table

OCST SQL Table

OTER SQL Table

OBNI SQL Table

OUSR SQL Table

OSTC SQL Table

OVTP SQL Table

SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates