|
|
API Credit Lines / Credit Line
OCRH - Credit Card Management Table
Credit Line CreditLine Object· Table: OCRH
Parent: Credit Lines CreditLines Collection
Credit Lines Service CreditLinesService Service· Table: OCRH
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
Project Codes OPRJ SQL Table
Incoming Payment ORCT SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsId KEY UNIQUE | Seq. No. in Amount | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| 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 | |||||
| CrTypeCode | Payment Method Code | Int | 6 | OCRP Payment Methods | ||||
| NumOfPmnts | Number of Payments | Int | 6 | 1 | ||||
| PayDate | Payment Date | Date | 8 | |||||
| FirstSum | First Partial Payment | Num | 20 | |||||
| AddPmntSum | Each Additional Payment | Num | 20 | |||||
| CreditSum | Credit Amount | Num | 20 | |||||
| CreditCurr | Credit Currency | nVarChar | 3 | |||||
| CreditRate | Credit Rate | Num | 20 | |||||
| ConfNum | Confirmation Number | nVarChar | 20 | |||||
| CreditType KEY | Credit Transaction Type | VarChar | U) Telephone Transaction S) Regular I) Internet Transaction | 1 | S | CRED_TYPE | No | |
| CreditDps | Credit Deposit Type | VarChar | Y) Manual N) Automatic | 1 | Y | |||
| Deposited | Paid | VarChar | Y) Yes N) No | 1 | N | |||
| DeposDate | Payment Date | Date | 8 | |||||
| RctAbs KEY | Receipt No. | Int | 11 | ORCT Incoming Payment | RECEIPT | No | ||
| DepNum KEY | Payment Internal ID | Int | 11 | ODPS Deposit | DEP_ABS | No | ||
| AcctCode | Account for Payments | 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 | ||
| Canceled | Canceled | VarChar | Y) Yes N) No | 1 | N | |||
| Storno | Cancel Transaction | VarChar | Y) Yes N) No | 1 | N | |||
| RcptLineId | Row Number in Receipt | Int | 11 | |||||
| Recived | Received | Num | 20 | |||||
| Converted | Endorsed | VarChar | Y) Yes N) No | 1 | N | |||
| ConvertTo | Endorsed for | nVarChar | 15 | |||||
| Transfered | Postponed to Next Year | VarChar | Y) Yes N) No | 1 | N | |||
| Instance | Instance | Int | 6 | 0 | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| TransRef | Trans. Reference | nVarChar | 20 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| ConsolNum | Vendor Credit Code | Int | 11 | -1 | ||||
| Project | Project Code | nVarChar | 20 | OPRJ Project Codes | ||||
| CardName | BP/Account Name | nVarChar | 100 |
Table relationship map
SELECT statement
SELECT
OCRH.AbsId AS 'Seq. No. in Amount',
OCRH.CreditCard AS 'Credit Card',
OCRH.CrdCardNum AS 'Credit Card No.',
OCRH.CardValid AS 'Credit Card Validity',
OCRH.VoucherNum AS 'Voucher Number',
OCRH.OwnerIdNum AS 'ID Number',
OCRH.OwnerPhone AS 'Telephone',
OCRH.CrTypeCode AS 'Payment Method Code',
OCRH.NumOfPmnts AS 'Number of Payments',
OCRH.PayDate AS 'Payment Date',
OCRH.FirstSum AS 'First Partial Payment',
OCRH.AddPmntSum AS 'Each Additional Payment',
OCRH.CreditSum AS 'Credit Amount',
OCRH.CreditCurr AS 'Credit Currency',
OCRH.CreditRate AS 'Credit Rate',
OCRH.ConfNum AS 'Confirmation Number',
OCRH.CreditType AS 'Credit Transaction Type',
OCRH.CreditDps AS 'Credit Deposit Type',
OCRH.Deposited AS 'Paid',
OCRH.DeposDate AS 'Payment Date',
OCRH.RctAbs AS 'Receipt No.',
OCRH.DepNum AS 'Payment Internal ID',
OCRH.AcctCode AS 'Account for Payments',
OCRH.CreditAcct AS 'Credit Account',
OCRH.CardCode AS 'BP/Account Code',
OCRH.Canceled AS 'Canceled',
OCRH.Storno AS 'Cancel Transaction',
OCRH.RcptLineId AS 'Row Number in Receipt',
OCRH.Recived AS 'Received',
OCRH.Converted AS 'Endorsed',
OCRH.ConvertTo AS 'Endorsed for',
OCRH.Transfered AS 'Postponed to Next Year',
OCRH.Instance AS 'Instance',
OCRH.UserSign AS 'User Signature',
OCRH.TransRef AS 'Trans. Reference',
OCRH.CreateDate AS 'Creation Date',
OCRH.ConsolNum AS 'Vendor Credit Code',
OCRH.Project AS 'Project Code',
OCRH.CardName AS 'BP/Account Name'
FROM OCRH AS OCRH
Related information
Credit Line CreditLine Object· Table: OCRH
Represents the deposits for credit card vouchers.
Source table: OCRH.
Parent: Credit Lines CreditLines CollectionCredit Lines Service CreditLinesService Service· Table: OCRH
The CreditLinesService service enables you to get deposits for credit card vouchers.
Source table: OCRH.
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
Project Codes OPRJ SQL Table
Incoming Payment ORCT SQL Table
Users OUSR SQL Table
CreditLines
Object
CreditLine
Method
Property
AbsId
DB
CreditCard
DB
Customer
DB
Deposited
DB
PayDate
DB
Reference
DB
Total
DB
Transferred
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
