| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| DocNum |
Document Number |
Int |
11 |
OVPM |
|
|
|
| InvoiceId |
Sequence No. |
Int |
11 |
- |
|
|
|
| DocEntry |
Invoice Key |
Int |
11 |
- |
|
|
|
| SumApplied |
Paid to Invoice |
Num |
19.6 |
- |
|
|
|
| AppliedFC |
Paid in FC |
Num |
19.6 |
- |
|
|
|
| AppliedSys |
Paid in SC |
Num |
19.6 |
- |
|
|
|
| InvType |
Invoice Category |
nVarChar |
20 |
- |
18 |
203 |
A/R Down Payment |
| |
|
|
|
|
|
13 |
A/R Invoice |
| |
|
|
|
|
|
14 |
A/R Credit Memo |
| |
|
|
|
|
|
204 |
A/P Down Payment |
| |
|
|
|
|
|
18 |
A/P Invoice |
| |
|
|
|
|
|
19 |
A/P Credit Memo |
| |
|
|
|
|
|
24 |
Incoming Payment |
| |
|
|
|
|
|
25 |
Deposit |
| |
|
|
|
|
|
46 |
Payment Advice |
| |
|
|
|
|
|
57 |
Checks for Payment |
| |
|
|
|
|
|
76 |
Postdated Deposit |
| |
|
|
|
|
|
-2 |
Opening Balance |
| |
|
|
|
|
|
-3 |
Closing Balance |
| |
|
|
|
|
|
30 |
Journal Entry |
| |
|
|
|
|
|
-1 |
All Transactions |
| |
|
|
|
|
|
163 |
A/P Correction Invoice |
| |
|
|
|
|
|
165 |
A/R Correction Invoice |
| |
|
|
|
|
|
0 |
|
| DocRate |
Document Rate |
Num |
19.6 |
- |
|
|
|
| Flags |
Flags |
Int |
11 |
- |
0 |
|
|
| IntrsStat |
Interest Letter Status |
VarChar |
1 |
- |
U |
U |
Not Sent |
| |
|
|
|
|
|
S |
Sent |
| |
|
|
|
|
|
C |
Closed |
| DocLine |
Row Key |
Int |
11 |
- |
0 |
|
|
| vatApplied |
Tax Definition |
Num |
19.6 |
- |
|
|
|
| vatAppldFC |
Tax Paid in FC |
Num |
19.6 |
- |
|
|
|
| vatAppldSy |
Tax Paid in SC |
Num |
19.6 |
- |
|
|
|
| selfInv |
Autom. Invoice |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
46 |
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| Dcount |
Discount Rate |
Num |
19.6 |
- |
|
|
|
| DcntSum |
Discount Amount |
Num |
19.6 |
- |
|
|
|
| DcntSumFC |
Discount Amount (FC) |
Num |
19.6 |
- |
|
|
|
| DcntSumSy |
Discount Amount (SC) |
Num |
19.6 |
- |
|
|
|
| BfDcntSum |
Amount Before Discount |
Num |
19.6 |
- |
|
|
|
| BfDcntSumF |
Amount Before Discount (FC) |
Num |
19.6 |
- |
|
|
|
| BfDcntSumS |
Amount Before Discount (SC) |
Num |
19.6 |
- |
|
|
|
| BfNetDcnt |
Net Amount Before Discount |
Num |
19.6 |
- |
|
|
|
| BfNetDcntF |
Net Amt Before Discount (FC) |
Num |
19.6 |
- |
|
|
|
| BfNetDcntS |
Net Amt Before Discount (SC) |
Num |
19.6 |
- |
|
|
|
| PaidSum |
Paid Amount (LC) |
Num |
19.6 |
- |
|
|
|
| ExpAppld |
Freight applied |
Num |
19.6 |
- |
|
|
|
| ExpAppldFC |
Freight applied FC |
Num |
19.6 |
- |
|
|
|
| ExpAppldSC |
Freight applied SC |
Num |
19.6 |
- |
|
|
|
| Rounddiff |
Rounding Diff. |
Num |
19.6 |
- |
|
|
|
| RounddifFc |
Rounding Diff. (FC) |
Num |
19.6 |
- |
|
|
|
| RounddifSc |
Rounding Diff. (SC) |
Num |
19.6 |
- |
|
|
|
| InstId |
Installment ID |
Int |
6 |
- |
1 |
|
|
| WtAppld |
Applied WTax |
Num |
19.6 |
- |
|
|
|
| WtAppldFC |
Applied WTax (FC) |
Num |
19.6 |
- |
|
|
|
| WtAppldSC |
Applied WTax (SC) |
Num |
19.6 |
- |
|
|
|
| LinkDate |
Link Date |
Date |
8 |
- |
|
|
|
| AmtDifPst |
Amount Diffs. Posting Date |
Date |
8 |
- |
|
|
|
| PaidDpm |
Paid Down Payment |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| DpmPosted |
Link Date |
VarChar |
1 |
- |
|
|
|
| ExpVatSum |
VAT on Freight Sum |
Num |
19.6 |
- |
|
|
|
| ExpVatSumF |
VAT on Freight Sum (FC) |
Num |
19.6 |
- |
|
|
|
| ExpVatSumS |
VAT on Freight Sum (SC) |
Num |
19.6 |
- |
|
|
|
| IsRateDiff |
Is Exchange Rate |
VarChar |
1 |
- |
N |
|
|
| WtInvCatS |
Withholding Tax Invoice Categ. |
Num |
19.6 |
- |
|
|
|
| WtInvCatSF |
Withholding Tax Invoice Categ. |
Num |
19.6 |
- |
|
|
|
| WtInvCatSS |
Withholding Tax Invoice Categ. |
Num |
19.6 |
- |
|
|
|
| OcrCode |
Distribution Rule |
nVarChar |
8 |
OOCR |
|
|
|
| DocTransId |
Trans. ID of Paid Document |
Int |
11 |
OJDT |
|
|
|
| MIEntry |
MI Entry Include this Payment |
Int |
11 |
- |
0 |
|
|
| OcrCode2 |
Distribution Rule2 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode3 |
Distribution Rule3 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode4 |
Distribution Rule4 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode5 |
Distribution Rule5 |
nVarChar |
8 |
OOCR |
|
|
|
| IsSelected |
Is Record Selected |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| WTOnHold |
Withholding Tax On Hold |
Num |
19.6 |
- |
|
|
|
| WTOnhldPst |
Withholding Tax Posted |
Num |
19.6 |
- |
|
|
|
| baseAbs |
Base Document Number |
Int |
11 |
- |
|
|
|
| MIType |
MI Type Include this Payment |
nVarChar |
20 |
- |
|
270 |
A/R Monthly Invoice |
| |
|
|
|
|
|
140000014 |
A/P Monthly Invoice |
| DocSubType |
Document Subtype |
nVarChar |
2 |
- |
-- |
|
|
| SpltPmtVAT |
Split Payment |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| WTSum |
WTax Amount |
Num |
19.6 |
- |
|
|
|
| WTSumFC |
WTax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| WTSumSC |
WTax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| SelOrder |
Select Order |
Int |
11 |
- |
|
|
|