| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| DocEntry |
Document Internal ID |
Int |
11 |
OPCH |
|
|
|
| InstlmntID |
Installment ID |
Int |
6 |
- |
1 |
|
|
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
18 |
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| DueDate |
Due Date |
Date |
8 |
- |
|
|
|
| Status |
Installment Status |
VarChar |
1 |
- |
O |
O |
Open |
| |
|
|
|
|
|
C |
Closed |
| DunnLevel |
Dunning Level |
Int |
11 |
- |
0 |
|
|
| InsTotal |
Total Installment |
Num |
19.6 |
- |
|
|
|
| InsTotalFC |
Total Installment (FC) |
Num |
19.6 |
- |
|
|
|
| InsTotalSy |
Total Installment (SC) |
Num |
19.6 |
- |
|
|
|
| PaidToDate |
Paid to Date |
Num |
19.6 |
- |
|
|
|
| PaidFC |
Paid (FC) |
Num |
19.6 |
- |
|
|
|
| PaidSys |
Paid (SC) |
Num |
19.6 |
- |
|
|
|
| VatSum |
Total Tax |
Num |
19.6 |
- |
|
|
|
| VatSumFC |
Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| VatSumSy |
Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| VatPaid |
Tax Paid to Date |
Num |
19.6 |
- |
|
|
|
| VatPaidFC |
Tax Paid (FC) |
Num |
19.6 |
- |
|
|
|
| VatPaidSys |
Tax Paid (SC) |
Num |
19.6 |
- |
|
|
|
| TotalExpns |
Total Freight Charges |
Num |
19.6 |
- |
|
|
|
| TotalExpFC |
Total Freight Charges (FC) |
Num |
19.6 |
- |
|
|
|
| TotalExpSC |
Total Freight Charges (SC) |
Num |
19.6 |
- |
|
|
|
| ExpAppl |
Applied Freight Charges |
Num |
19.6 |
- |
|
|
|
| ExpApplFC |
Applied Freight Charges (FC) |
Num |
19.6 |
- |
|
|
|
| ExpApplSC |
Applied Freight Charges (SC) |
Num |
19.6 |
- |
|
|
|
| WTSum |
WTax Amount |
Num |
19.6 |
- |
|
|
|
| WTSumFC |
WTax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| WTSumSC |
WTax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| WTApplied |
Applied WTax |
Num |
19.6 |
- |
|
|
|
| WTAppliedF |
Applied WTax (FC) |
Num |
19.6 |
- |
|
|
|
| WTAppliedS |
Applied WTax (SC) |
Num |
19.6 |
- |
|
|
|
| TotalBlck |
Total Reserved Amount |
Num |
19.6 |
- |
|
|
|
| TotalBlckF |
Total Reserved Amount (FC) |
Num |
19.6 |
- |
|
|
|
| TotalBlckS |
Total Reserved Amount (SC) |
Num |
19.6 |
- |
|
|
|
| VATBlck |
Reserved Tax |
Num |
19.6 |
- |
|
|
|
| VATBlckFC |
Reserved Tax (FC) |
Num |
19.6 |
- |
|
|
|
| VATBlckSC |
Reserved Tax (SC) |
Num |
19.6 |
- |
|
|
|
| ExpnsBlck |
Reserved Freight Charges |
Num |
19.6 |
- |
|
|
|
| ExpnsBlckF |
Reserved Freight Charges (FC) |
Num |
19.6 |
- |
|
|
|
| ExpnsBlckS |
Reserved Freight Charges (SC) |
Num |
19.6 |
- |
|
|
|
| WTBlocked |
Reserved WTax Amount |
Num |
19.6 |
- |
|
|
|
| WTBlockedF |
Reserved WTax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| WTBlockedS |
Reserved WTax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| InstPrcnt |
Installment % |
Num |
19.6 |
- |
|
|
|
| DunWizBlck |
Wizard dunning block |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| DunDate |
Last Dunning Date |
Date |
8 |
- |
|
|
|
| Paid |
Paid |
Num |
19.6 |
- |
|
|
|
| PaidFrgn |
Paid (FC) |
Num |
19.6 |
- |
|
|
|
| PaidSc |
Paid (SC) |
Num |
19.6 |
- |
|
|
|
| reserved |
Reserved |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| TaxOnExp |
Tax on Expenses |
Num |
19.6 |
- |
|
|
|
| TaxOnExpFc |
Tax on Expenses (FC) |
Num |
19.6 |
- |
|
|
|
| TaxOnExpSc |
Tax on Expenses (SC) |
Num |
19.6 |
- |
|
|
|
| TaxOnExpAp |
Applied Tax on Expenses |
Num |
19.6 |
- |
|
|
|
| TaxOnExApF |
Applied Tax on Expenses (FC) |
Num |
19.6 |
- |
|
|
|
| TaxOnExApS |
Applied Tax on Expenses (SC) |
Num |
19.6 |
- |
|
|
|
| TaxOnExBlo |
Reserved Tax on Freight Amount |
Num |
19.6 |
- |
|
|
|
| TaxOnExBlF |
Reserved Tax on Freight Amt FC |
Num |
19.6 |
- |
|
|
|
| TaxOnExBlS |
Reserved Tax on Freight Amt SC |
Num |
19.6 |
- |
|
|
|
| LvlUpdDate |
Dunning Level Update Date |
Date |
8 |
- |
|
|
|
| Ordered |
Payment Ordered |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PaidDpm |
Paid by Down Payment |
Num |
19.6 |
- |
|
|
|
| PaidDpmFc |
Paid by Down Payment (FC) |
Num |
19.6 |
- |
|
|
|
| PaidDpmSc |
Paid by Down Payment (SC) |
Num |
19.6 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|