biuan SAP® BUSINESS ONE SDK
SQL Payment Draft - Credit Vouchers
DTW Payment Draft - Credit Vouchers
API Payments Credit Cards / Additional Payment Sum
PDF3 - Payment Draft - Credit Vouchers Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument No.Int
11OPDF
Payment Draft		PRIMARYYes
LineIDRow No.Int
11
CreditCardCredit CardInt
6OCRC
Credit Cards		-1
CreditAcctCredit AmountnVarChar
15OACT
G/L Accounts
CrCardNumCredit Card No.nVarChar
64
CardValidCredit Card Valid UntilDate
8
VoucherNumCredit Voucher No.nVarChar
20
OwnerIdNumID NumbernVarChar
15
OwnerPhoneTelephonenVarChar
20
CrTypeCodePayment Method CodeInt
6OCRP
Payment Methods		-1
NumOfPmntsNo. of PaymentsInt
6
1
FirstDue1st Payment DateDate
8
FirstSumFirst Partial PaymentNum
20
AddPmntSumEach Additional PaymentNum
20
CreditSumCredit AmountNum
20
CreditCurCredit Voucher CurrencynVarChar
3OCRN
Currency Codes
CreditRateCredit Voucher RateNum
20
ConfNumConfirmation No.nVarChar
20
CreditTypeCredit Transaction TypeVarChar
U) Telephone Transaction
S) Regular
I) Internet Transaction
1
S
CredPmntsNo. of Credit PaymentsInt
6
1
PlCrdStatPelecard Debit StatusnVarChar
4
-1
MagnetStrMagnetic Stripe ContentnVarChar
40
SpiltCredSplit Credit Voucher PaymentVarChar
Y) Yes
N) No
1
N
ConsolNumVendor Credit CodeInt
11OPVL
Lender - Pelecard		-1
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT PDF3.DocNum AS 'Document No.', PDF3.LineID AS 'Row No.', PDF3.CreditCard AS 'Credit Card', PDF3.CreditAcct AS 'Credit Amount', PDF3.CrCardNum AS 'Credit Card No.', PDF3.CardValid AS 'Credit Card Valid Until', PDF3.VoucherNum AS 'Credit Voucher No.', PDF3.OwnerIdNum AS 'ID Number', PDF3.OwnerPhone AS 'Telephone', PDF3.CrTypeCode AS 'Payment Method Code', PDF3.NumOfPmnts AS 'No. of Payments', PDF3.FirstDue AS '1st Payment Date', PDF3.FirstSum AS 'First Partial Payment', PDF3.AddPmntSum AS 'Each Additional Payment', PDF3.CreditSum AS 'Credit Amount', PDF3.CreditCur AS 'Credit Voucher Currency', PDF3.CreditRate AS 'Credit Voucher Rate', PDF3.ConfNum AS 'Confirmation No.', PDF3.CreditType AS 'Credit Transaction Type', PDF3.CredPmnts AS 'No. of Credit Payments', PDF3.PlCrdStat AS 'Pelecard Debit Status', PDF3.MagnetStr AS 'Magnetic Stripe Content', PDF3.SpiltCred AS 'Split Credit Voucher Payment', PDF3.ConsolNum AS 'Vendor Credit Code', PDF3.ObjType AS 'Object Type', PDF3.LogInstanc AS 'Log Instance' FROM PDF3 AS PDF3

Related information


Additional Payment Sum AdditionalPaymentSum Property· Table: PDF3
Sets or returns the payment amount added to the first payment, due to rounding results. Field name: AddPmntSum.
· Table: RCT3 PDF3 VPM3    Parent: Payments Credit Cards Payments_CreditCards Object· Table: RCT3 PDF3 VPM3
Lender - Pelecard OPVL SQL Table

G/L Accounts OACT SQL Table

Credit Cards OCRC SQL Table

Currency Codes OCRN SQL Table

Payment Methods OCRP SQL Table

Payment Draft OPDF 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