biuan SAP® BUSINESS ONE SDK
SQL Incoming Pmt - Credit Vouchers
DTW Incoming Pmt - Credit Vouchers
API Payments Credit Cards / Additional Payment Sum
RCT3 - Incoming Pmt - Credit Vouchers Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument No.Int
11ORCT
Incoming Payment		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
FirstSum1st Partial PaymentNum
20
AddPmntSumEach Additional PaymentNum
20
CreditSumCredit AmountNum
20
CreditCurCredit CurrencynVarChar
3OCRN
Currency Codes
CreditRateCredit 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		24
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

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

Related information


Additional Payment Sum AdditionalPaymentSum Property· Table: RCT3
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

Incoming Payment ORCT 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