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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECredit Card Payment CodenVarChar
8
PRIMARYYes
NameCredit Card Payment NamenVarChar
30
TERM_TYPECredit Card Payment TypesVarChar
D) By Dates
F) After Time Period
1
F
After_DaysPayment After DaysInt
6
After_MnthPayment After MonthsInt
6
Day_From1From Day 1Int
6
Day_To1To Day 1Int
6
Pay_Day1Payment Date 1Int
6
Pay_Month1No. of Months 1Int
6
Day_From2From Day 2Int
6
Day_To2To Day 2Int
6
Pay_Day2Payment Date 2Int
6
Pay_Month2No. of Months 2Int
6
Day_From3From Day 3Int
6
Day_To3To Day 3Int
6
Pay_Day3Payment Date 3Int
6
Pay_Month3No. of Months 3Int
6
Day_From4From Day 4Int
6
Day_To4To Day 4Int
6
Pay_Day4Payment Date 4Int
6
Pay_Month4No. of Months 4Int
6
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 OCDT.Code AS 'Credit Card Payment Code', OCDT.Name AS 'Credit Card Payment Name', OCDT.TERM_TYPE AS 'Credit Card Payment Types', OCDT.After_Days AS 'Payment After Days', OCDT.After_Mnth AS 'Payment After Months', OCDT.Day_From1 AS 'From Day 1', OCDT.Day_To1 AS 'To Day 1', OCDT.Pay_Day1 AS 'Payment Date 1', OCDT.Pay_Month1 AS 'No. of Months 1', OCDT.Day_From2 AS 'From Day 2', OCDT.Day_To2 AS 'To Day 2', OCDT.Pay_Day2 AS 'Payment Date 2', OCDT.Pay_Month2 AS 'No. of Months 2', OCDT.Day_From3 AS 'From Day 3', OCDT.Day_To3 AS 'To Day 3', OCDT.Pay_Day3 AS 'Payment Date 3', OCDT.Pay_Month3 AS 'No. of Months 3', OCDT.Day_From4 AS 'From Day 4', OCDT.Day_To4 AS 'To Day 4', OCDT.Pay_Day4 AS 'Payment Date 4', OCDT.Pay_Month4 AS 'No. of Months 4', OCDT.DataSource AS 'Data Source', OCDT.UserSign AS 'User Signature' FROM OCDT AS OCDT

Related information


Credit Card Payments CreditCardPayments Object· Table: OCDT
The CreditCardPayments object enables to define dates for incoming payments from the credit card company. Source table: OCDT.

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