|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Outgoing Payments - Accounts
Table Name: VPM4
Table Description: Outgoing Payments - Accounts
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocNum | Document Number | Int | 11 | OVPM | Â | Â | Â |
| LineId | Row Number | Int | 11 | - | Â | Â | Â |
| AcctCode | Account | nVarChar | 15 | OACT | Â | Â | Â |
| SumApplied | Paid | Num | 19.6 | - | Â | Â | Â |
| AppliedFC | Paid in FC | Num | 19.6 | - | Â | Â | Â |
| AppliedSys | Paid in SC | Num | 19.6 | - | Â | Â | Â |
| Descrip | Description | nVarChar | 250 | - | Â | Â | Â |
| VatGroup | VAT Group | nVarChar | 8 | OVTG | Â | Â | Â |
| VatPrcnt | VAT Rate | Num | 19.6 | - | Â | Â | Â |
| AcctName | Account Name | nVarChar | 200 | - | Â | Â | Â |
| ObjType | Object Type | nVarChar | 20 | ADP1 | 46 | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR | Â | Â | Â |
| Project | Project Code | nVarChar | 20 | OPRJ | Â | Â | Â |
| GrossAmnt | Gross Amount | Num | 19.6 | - | Â | Â | Â |
| GrssAmntFC | Gross Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| GrssAmntSC | Gross Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| AmntBase | Base Amount | VarChar | 1 | - | Â | E | Exclude Tax |
| Â | Â | Â | Â | Â | Â | I | Include Tax |
| VatAmnt | VAT Amount | Num | 19.6 | - | Â | Â | Â |
| VatAmntFC | VAT Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| VatAmntSC | VAT Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| UserChaVat | User Changed VAT | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| TaxTypeID | Tax Type Component ID | Int | 11 | OSTT | Â | Â | Â |
| OcrCode2 | Distribution Rule2 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode3 | Distribution Rule3 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode4 | Distribution Rule4 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode5 | Distribution Rule5 | nVarChar | 8 | OOCR | Â | Â | Â |
| Section | Section | Int | 11 | OSEC | Â | Â | Â |
| AsseType | Assessee Type | VarChar | 1 | - | Â | C | Company |
| Â | Â | Â | Â | Â | Â | P | Others |
| LocCode | Location Code | Int | 11 | OLCT | Â | Â | Â |
| MatType | Material Type | Int | 11 | - | 0 | Â | Â |
| EquVatPer | Equalization Tax Rate | Num | 19.6 | - | Â | Â | Â |
| EquVatSum | Equalization VAT Amount | Num | 19.6 | - | Â | Â | Â |
| EquVatSumF | Equalization VAT Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| EquVatSumS | Equalization VAT Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocNum |
| Â | Â | LineId |