biuan SAP® BUSINESS ONE SDK
API OCRV
OCRV - Credit Payments Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEYSeq. No. in AmountInt
11OCRH
Credit Card Management
VOUCHER_IDNo
PayIdPayment No.Int
11
0
CreditCardCredit CardInt
6OCRC
Credit Cards
0
CrdCardNumCredit Card No.nVarChar
64
CardValidCredit Card ValidityDate
8
VoucherNum KEYVoucher NumbernVarChar
20
IS_VALIDNo
OwnerIdNumID NumbernVarChar
15
OwnerPhoneTelephonenVarChar
20
PayDatePayment DateDate
8
PayAmountPayment AmountNum
20
CreditCurrCredit CurrencynVarChar
3
CreditRateCredit RateNum
20
Deposited KEYPaidVarChar
C) Closed
O) Open
S) Postdated
1
ODEPOSITEDNo
DepNum2 KEYPostdated Deposit KeyInt
11ODPT
Postdated Deposit
0DEP_ABS2No
DepNum KEYPayment Internal IDInt
11ODPS
Deposit
DEP_ABS1No
AcctCodeAccount for PaymentsnVarChar
15OACT
G/L Accounts
VouchAcctVoucher AccountnVarChar
15OACT
G/L Accounts
CreditAcct KEYCredit AccountnVarChar
15
CRED_ACCTNo
CardCode KEYBP/Account CodenVarChar
15OCRD
Business Partner
CUST_CODENo
CrTypeCodePayment Method CodeInt
6OCRP
Payment Methods
NumOfPmntsNumber of PaymentsInt
6
1
CanceledCanceledVarChar
Y) Yes
N) No
1
N
StornoCancel TransactionVarChar
Y) Yes
N) No
1
N
TransferedPostponed to Next YearVarChar
Y) Yes
N) No
1
N
InstanceInstanceInt
6OCRH
Credit Card Management
0
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
TransRefTrans. ReferencenVarChar
20
CardNameBP/Account NamenVarChar
100

Table relationship map

SELECT statement

SELECT OCRV.AbsId AS 'Seq. No. in Amount', OCRV.PayId AS 'Payment No.', OCRV.CreditCard AS 'Credit Card', OCRV.CrdCardNum AS 'Credit Card No.', OCRV.CardValid AS 'Credit Card Validity', OCRV.VoucherNum AS 'Voucher Number', OCRV.OwnerIdNum AS 'ID Number', OCRV.OwnerPhone AS 'Telephone', OCRV.PayDate AS 'Payment Date', OCRV.PayAmount AS 'Payment Amount', OCRV.CreditCurr AS 'Credit Currency', OCRV.CreditRate AS 'Credit Rate', OCRV.Deposited AS 'Paid', OCRV.DepNum2 AS 'Postdated Deposit Key', OCRV.DepNum AS 'Payment Internal ID', OCRV.AcctCode AS 'Account for Payments', OCRV.VouchAcct AS 'Voucher Account', OCRV.CreditAcct AS 'Credit Account', OCRV.CardCode AS 'BP/Account Code', OCRV.CrTypeCode AS 'Payment Method Code', OCRV.NumOfPmnts AS 'Number of Payments', OCRV.Canceled AS 'Canceled', OCRV.Storno AS 'Cancel Transaction', OCRV.Transfered AS 'Postponed to Next Year', OCRV.Instance AS 'Instance', OCRV.DataSource AS 'Data Source', OCRV.UserSign AS 'User Signature', OCRV.TransRef AS 'Trans. Reference', OCRV.CardName AS 'BP/Account Name' FROM OCRV AS OCRV

Related information


Credit Card Management OCRH SQL Table

G/L Accounts OACT SQL Table

Business Partner OCRD SQL Table

Credit Cards OCRC SQL Table

Payment Methods OCRP SQL Table

Deposit ODPS SQL Table

Postdated Deposit ODPT 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates