|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Credit Card Management
Table Name: OCRH
Table Description: Credit Card Management
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsId | Seq. No. in Amount | Int | 11 | - | Â | Â | Â |
| CreditCard | Credit Card | Int | 6 | OCRC | 0 | Â | Â |
| CrdCardNum | Credit Card No. | nVarChar | 254 | - | Â | Â | Â |
| CardValid | Credit Card Validity | Date | 8 | - | Â | Â | Â |
| VoucherNum | Voucher Number | nVarChar | 27 | - | Â | Â | Â |
| OwnerIdNum | ID Number | nVarChar | 15 | - | Â | Â | Â |
| OwnerPhone | Telephone | nVarChar | 50 | - | Â | Â | Â |
| CrTypeCode | Payment Method Code | Int | 6 | OCRP | Â | Â | Â |
| NumOfPmnts | Number of Payments | Int | 6 | - | 1 | Â | Â |
| PayDate | Payment Date | Date | 8 | - | Â | Â | Â |
| FirstSum | First Partial Payment | Num | 19.6 | - | Â | Â | Â |
| AddPmntSum | Each Additional Payment | Num | 19.6 | - | Â | Â | Â |
| CreditSum | Credit Amount | Num | 19.6 | - | Â | Â | Â |
| CreditCurr | Credit Currency | nVarChar | 3 | - | Â | Â | Â |
| CreditRate | Credit Rate | Num | 19.6 | - | Â | Â | Â |
| ConfNum | Confirmation Number | nVarChar | 20 | - | Â | Â | Â |
| CreditType | Credit Transaction Type | VarChar | 1 | - | S | U | Telephone Transaction |
| Â | Â | Â | Â | Â | Â | S | Regular |
| Â | Â | Â | Â | Â | Â | I | Internet Transaction |
| CreditDps | Credit Deposit Type | VarChar | 1 | - | Y | Y | Manual |
| Â | Â | Â | Â | Â | Â | N | Automatic |
| Deposited | Paid | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DeposDate | Payment Date | Date | 8 | - | Â | Â | Â |
| RctAbs | Receipt No. | Int | 11 | ORCT | Â | Â | Â |
| DepNum | Payment Internal ID | Int | 11 | ODPS | Â | Â | Â |
| AcctCode | Account for Payments | nVarChar | 15 | OACT | Â | Â | Â |
| CreditAcct | Credit Account | nVarChar | 15 | - | Â | Â | Â |
| CardCode | BP/Account Code | nVarChar | 15 | OCRD | Â | Â | Â |
| Canceled | Canceled | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Storno | Cancel Transaction | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RcptLineId | Row Number in Receipt | Int | 11 | - | Â | Â | Â |
| Recived | Received | Num | 19.6 | - | Â | Â | Â |
| Converted | Endorsed | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ConvertTo | Endorsed for | nVarChar | 15 | - | Â | Â | Â |
| Transfered | Postponed to Next Year | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Instance | Instance | Int | 6 | - | 0 | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| TransRef | Trans. Reference | nVarChar | 20 | - | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| ConsolNum | Vendor Credit Code | Int | 11 | - | -1 | Â | Â |
| Project | Project Code | nVarChar | 20 | OPRJ | Â | Â | Â |
| CardName | BP/Account Name | nVarChar | 200 | - | Â | Â | Â |
| EnOwnerId | Encryption of ID Number | Text | 16 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| VersionNum | Version Number | nVarChar | 13 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsId |
| Â | Â | Instance |
| CRED_CARD | No | CreditCard |
| CRED_TYPE | No | CreditType |
| RECEIPT | No | RctAbs |
| Â | Â | RcptLineId |
| Â | Â | Storno |
| CUST_CODE | No | CardCode |
| DEP_ABS | No | DepNum |
| IS_VALID | No | VoucherNum |
| Â | Â | CreditCard |
| Â | Â | Storno |
| CRED_ACCT | No | CreditAcct |