|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Incoming Pmt - Credit Vouchers
Table Name: RCT3
Table Description: Incoming Pmt - Credit Vouchers
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocNum | Document No. | Int | 11 | ORCT | Â | Â | Â |
| LineID | Row No. | Int | 11 | - | Â | Â | Â |
| CreditCard | Credit Card | Int | 6 | OCRC | -1 | Â | Â |
| CreditAcct | Credit Account | nVarChar | 15 | OACT | Â | Â | Â |
| CrCardNum | Credit Card No. | nVarChar | 254 | - | Â | Â | Â |
| CardValid | Credit Card Valid Until | Date | 8 | - | Â | Â | Â |
| VoucherNum | Credit Voucher No. | nVarChar | 20 | - | Â | Â | Â |
| OwnerIdNum | ID Number | nVarChar | 15 | - | Â | Â | Â |
| OwnerPhone | Telephone | nVarChar | 50 | - | Â | Â | Â |
| CrTypeCode | Payment Method Code | Int | 6 | OCRP | -1 | Â | Â |
| NumOfPmnts | No. of Payments | Int | 6 | - | 1 | Â | Â |
| FirstDue | 1st Payment Date | Date | 8 | - | Â | Â | Â |
| FirstSum | 1st Partial Payment | Num | 19.6 | - | Â | Â | Â |
| AddPmntSum | Each Additional Payment | Num | 19.6 | - | Â | Â | Â |
| CreditSum | Credit Amount | Num | 19.6 | - | Â | Â | Â |
| CreditCur | Credit Currency | nVarChar | 3 | OCRN | Â | Â | Â |
| CreditRate | Credit Rate | Num | 19.6 | - | Â | Â | Â |
| ConfNum | Confirmation No. | nVarChar | 20 | - | Â | Â | Â |
| CreditType | Credit Transaction Type | VarChar | 1 | - | S | U | Telephone Transaction |
| Â | Â | Â | Â | Â | Â | S | Regular |
| Â | Â | Â | Â | Â | Â | I | Internet Transaction |
| CredPmnts | No. of Credit Payments | Int | 6 | - | 1 | Â | Â |
| PlCrdStat | Pelecard Debit Status | nVarChar | 4 | - | -1 | Â | Â |
| MagnetStr | Magnetic Stripe Content | nVarChar | 40 | - | Â | Â | Â |
| SpiltCred | Split Credit Voucher Payment | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ConsolNum | Vendor Credit Code | Int | 11 | OPVL | -1 | Â | Â |
| ObjType | Object Type | nVarChar | 20 | ADP1 | 24 | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| EnOwnerId | Encryption of ID Number | Text | 16 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocNum |
| Â | Â | LineID |