biuan SAP® BUSINESS ONE SDK
DTW Business Partners / Business Partner Master Data / Bussiness Partners - Payment Methods
API Business Partners / BP Payment Methods
CRD2 - Bussiness Partners - Payment Methods Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CardCode KEYBP CodenVarChar
15OCRD
Business Partner
CRD_PYMNo
LineNumRow NumberInt
11
PymCodePayment Method CodenVarChar
15OPYM
Payment Methods for Payment Wizard
LogInstancLog InstanceInt
11
0
ObjTypeObject TypeInt
6ADP1
Object Settings - History
2

Table relationship map

SELECT statement

SELECT CRD2.CardCode AS 'BP Code', CRD2.LineNum AS 'Row Number', CRD2.PymCode AS 'Payment Method Code', CRD2.LogInstanc AS 'Log Instance', CRD2.ObjType AS 'Object Type' FROM CRD2 AS CRD2

Related information


BP Payment Methods BPPaymentMethods Object· Table: CRD2
BPPaymentMethods is a child object of the BusinessPartners object that represents the payment methods related to the business partner. Source table: CRD2.
   Parent: Business Partners BusinessPartners Object· Table: OCRD
Business Partner OCRD SQL Table

Object Settings - History ADP1 SQL Table

Payment Methods for Payment Wizard OPYM 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