biuan SAP® BUSINESS ONE SDK
API ACR3
ACR3 - Business Partner Control Accounts - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CardCode KEY UNIQUEBP CodenVarChar
15OCRD
Business Partner
PRIMARYYes
AcctTypeAccount TypeVarChar
M) Domestic
F) Foreign
D) Down Payment
A) Assets Account
R) Bill of Exchange Accounts Receivable
P) Bill of Exchange Accounts Payable
C) Bill of Exchange on Collection
S) Bill of Exchange Presentation
Y) Assets Bill of Exchange Acct Payable
I) Bill of Exchange Discounted
U) Unpaid Bill of Exchange
O) Open Debts
1
M
AcctCodeAccount CodenVarChar
15OACT
G/L Accounts
LogInstaneLog InstanceInt
11
0
ObjTypeObject TypeInt
6ADP1
Object Settings - History
2

Table relationship map

SELECT statement

SELECT ACR3.CardCode AS 'BP Code', ACR3.AcctType AS 'Account Type', ACR3.AcctCode AS 'Account Code', ACR3.LogInstane AS 'Log Instance', ACR3.ObjType AS 'Object Type' FROM ACR3 AS ACR3

Related information


G/L Accounts OACT SQL Table

Business Partner OCRD SQL Table

Object Settings - History ADP1 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