biuan SAP® BUSINESS ONE SDK
SQL Administration / Payment Methods
DTW Administration / Setup / Banking / Credit Card Payment Methods
API OCRP / Credit Payment Methods
OCRP - Payment Methods Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CrTypeCode KEY UNIQUEPayment Method CodeInt
6
PRIMARYYes
CrTypeName KEY UNIQUENamenVarChar
30
NAMEYes
CreditCard KEYAssigned to Credit CardInt
6OCRC
Credit Cards		CRED_CODENo
DueTermsPayment CodenVarChar
8OCDT
Credit Card Payment
MinCreditMinimum Credit AmountNum
20
MinToPayMinimum Payment AmountNum
20
MaxValidMax. Qty Without ApprovalNum
20
InstalMent KEYInstallment Payments PossibleVarChar
Y) Yes
N) No
C) Cr
L) Rd
1
NINSTALMENTNo
LockedLockedVarChar
Y) Yes
N) No
1
N
DataSourceData SourceVarChar
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
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OCRP.CrTypeCode AS 'Payment Method Code', OCRP.CrTypeName AS 'Name', OCRP.CreditCard AS 'Assigned to Credit Card', OCRP.DueTerms AS 'Payment Code', OCRP.MinCredit AS 'Minimum Credit Amount', OCRP.MinToPay AS 'Minimum Payment Amount', OCRP.MaxValid AS 'Max. Qty Without Approval', OCRP.InstalMent AS 'Installment Payments Possible', OCRP.Locked AS 'Locked', OCRP.DataSource AS 'Data Source', OCRP.UserSign AS 'User Signature' FROM OCRP AS OCRP

Related information


Credit Payment Methods CreditPaymentMethods Object· Table: OCRP
The CreditPaymentMethods object enables to define payment methods by credit cards. Source table: OCRP.

OCRP SQL Table

Credit Cards OCRC SQL Table

Credit Card Payment OCDT SQL Table

Users OUSR 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