|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Purchase Tax Invoice - Linked Down Payments
Table Name: TPI4
Table Description: Purchase Tax Invoice - Linked Down Payments
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| ObjType | Object Type | Int | 11 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| LineNum | Line Number | Int | 11 | - | Â | Â | Â |
| DpmObjType | Down Payment Type | Int | 11 | - | Â | Â | Â |
| DpmDocEntr | Down Payment Entry | Int | 11 | - | Â | Â | Â |
| DpmDocNum | Down Payment No. | Int | 11 | - | Â | Â | Â |
| PmnObjType | Payment Type | Int | 11 | - | Â | Â | Â |
| PmnDocEntr | Payment Entry | Int | 11 | - | Â | Â | Â |
| PmnDocNum | Payment Number | Int | 11 | - | Â | Â | Â |
| PmnTaxDate | Payment Date | Date | 8 | - | Â | Â | Â |
| TrsfrDate | Transfer Date | Date | 8 | - | Â | Â | Â |
| TrsfrRef | Intended Purpose | nVarChar | 27 | - | Â | Â | Â |
| DrawnSum | Drawn Amount | Num | 19.6 | - | Â | Â | Â |
| DrawnSumFc | Drawn Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| DrawnSumSc | Drawn Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| DocCur | Document Currency | nVarChar | 3 | - | Â | Â | Â |
| Vat | Tax Amount | Num | 19.6 | - | Â | Â | Â |
| VatFc | Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| VatSc | Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| Gross | Gross Amount | Num | 19.6 | - | Â | Â | Â |
| GrossFc | Gross Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| GrossSc | Gross Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LineNum |
| DOC_ENTRY | No | DocEntry |