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