SAP Business One SDK 10.0 - Database Tables Reference
-
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 |
64 |
- |
|
|
|
| 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 |