|
|
SQL 
Banking / 
Credit Payments
API OCRV
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsId KEY | Seq. No. in Amount | Int | 11 | OCRH Credit Card Management | VOUCHER_ID | No |
|---|---|---|---|---|---|---|---|---|
| PayId | Payment No. | Int | 11 | 0 | ||||
| CreditCard | Credit Card | Int | 6 | OCRC Credit Cards | 0 | |||
| CrdCardNum | Credit Card No. | nVarChar | 64 | |||||
| CardValid | Credit Card Validity | Date | 8 | |||||
| VoucherNum KEY | Voucher Number | nVarChar | 20 | IS_VALID | No | |||
| OwnerIdNum | ID Number | nVarChar | 15 | |||||
| OwnerPhone | Telephone | nVarChar | 20 | |||||
| PayDate | Payment Date | Date | 8 | |||||
| PayAmount | Payment Amount | Num | 20 | |||||
| CreditCurr | Credit Currency | nVarChar | 3 | |||||
| CreditRate | Credit Rate | Num | 20 | |||||
| Deposited KEY | Paid | VarChar | C) Closed O) Open S) Postdated | 1 | O | DEPOSITED | No | |
| DepNum2 KEY | Postdated Deposit Key | Int | 11 | ODPT Postdated Deposit | 0 | DEP_ABS2 | No | |
| DepNum KEY | Payment Internal ID | Int | 11 | ODPS Deposit | DEP_ABS1 | No | ||
| AcctCode | Account for Payments | nVarChar | 15 | OACT G/L Accounts | ||||
| VouchAcct | Voucher Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CreditAcct KEY | Credit Account | nVarChar | 15 | CRED_ACCT | No | |||
| CardCode KEY | BP/Account Code | nVarChar | 15 | OCRD Business Partner | CUST_CODE | No | ||
| CrTypeCode | Payment Method Code | Int | 6 | OCRP Payment Methods | ||||
| NumOfPmnts | Number of Payments | Int | 6 | 1 | ||||
| Canceled | Canceled | VarChar | Y) Yes N) No | 1 | N | |||
| Storno | Cancel Transaction | VarChar | Y) Yes N) No | 1 | N | |||
| Transfered | Postponed to Next Year | VarChar | Y) Yes N) No | 1 | N | |||
| Instance | Instance | Int | 6 | OCRH Credit Card Management | 0 | |||
| DataSource | Data Source | VarChar | 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 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| TransRef | Trans. Reference | nVarChar | 20 | |||||
| CardName | BP/Account Name | nVarChar | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates