biuan SAP® BUSINESS ONE SDK
SQL Business Partners / Business Partner / BP Control Account
DTW Business Partners / Business Partner Master Data / BP Control Account
API Business Partners / BP Account Receivable Payble
CRD3 - BP Control Account 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
H) Cash Discount Interim
E) Exchange Rate Interim
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 CRD3.CardCode AS 'BP Code', CRD3.AcctType AS 'Account Type', CRD3.AcctCode AS 'Account Code', CRD3.LogInstane AS 'Log Instance', CRD3.ObjType AS 'Object Type' FROM CRD3 AS CRD3

Related information


BP Account Receivable Payble BPAccountReceivablePayble Object· Table: CRD3
BPAccountReceivablePayble is a child object of the BusinessPartners object and represents the Business Partner Account Receivable Payable table in the Business Partner module. This object enables you to add a business partner account. Source...
   Parent: Business Partners BusinessPartners Object· Table: OCRD
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