|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Outgoing Payments - Check Rows
Table Name: VPM1
Table Description: Outgoing Payments - Check Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocNum | Document Number | Int | 11 | OVPM | Â | Â | Â |
| LineID | Row Number | Int | 11 | - | Â | Â | Â |
| DueDate | Check Date | Date | 8 | - | Â | Â | Â |
| CheckNum | Check Number | Int | 11 | - | Â | Â | Â |
| BankCode | Account No. | nVarChar | 30 | - | -1 | Â | Â |
| Branch | Branch Number | nVarChar | 50 | - | Â | Â | Â |
| AcctNum | Account Number | nVarChar | 50 | - | Â | Â | Â |
| Details | Details | nVarChar | 254 | - | Â | Â | Â |
| Trnsfrable | Negotiable | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CheckSum | Check Amount | Num | 19.6 | - | Â | Â | Â |
| Currency | Check Currency | nVarChar | 3 | OCRN | Â | Â | Â |
| Flags | Flags | Int | 11 | - | 0 | Â | Â |
| ObjType | Object Type | nVarChar | 20 | ADP1 | 46 | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| CountryCod | Country/Region Code | nVarChar | 3 | OCRY | Â | Â | Â |
| CheckAct | Checking Account | nVarChar | 15 | OACT | Â | Â | Â |
| CheckAbs | Internal Check Number | Int | 11 | OCHO | Â | Â | Â |
| BnkActKey | Bank Account No. | Int | 11 | DSC1 | Â | Â | Â |
| ManualChk | Manual Check | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| FiscalID | Fiscal ID | nVarChar | 100 | - | Â | Â | Â |
| OrigIssdBy | Orginally Issued By | nVarChar | 254 | - | Â | Â | Â |
| Endorse | Endorse | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EndorsChNo | Endorsable Check No. | Int | 11 | OCHH | Â | Â | Â |
| EnAcctNum | Encryption of Account Number | Text | 16 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| ECheck | E-Check | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | DocNum |
| Â | Â | LineID |