| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| DocEntry |
Document Internal ID |
Int |
11 |
OQUT |
|
|
|
| ExpnsCode |
Freight Code |
Int |
11 |
OEXD |
|
|
|
| LineTotal |
Total |
Num |
19.6 |
- |
|
|
|
| TotalFrgn |
Total (FC) |
Num |
19.6 |
- |
|
|
|
| TotalSumSy |
Total (SC) |
Num |
19.6 |
- |
|
|
|
| PaidToDate |
Paid to Date |
Num |
19.6 |
- |
|
|
|
| PaidFC |
Paid (FC) |
Num |
19.6 |
- |
|
|
|
| PaidSys |
Paid (SC) |
Num |
19.6 |
- |
|
|
|
| Comments |
Remarks |
nVarChar |
100 |
- |
|
|
|
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
23 |
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| DistrbMthd |
Distribution Method |
VarChar |
1 |
- |
|
N |
None |
| |
|
|
|
|
|
Q |
Quantity |
| |
|
|
|
|
|
V |
Volume |
| |
|
|
|
|
|
W |
Weight |
| |
|
|
|
|
|
E |
Equally |
| |
|
|
|
|
|
T |
Row Total |
| TaxStatus |
Tax Liable |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| VatGroup |
Tax Group |
nVarChar |
8 |
OVTG |
|
|
|
| VatPrcnt |
Row Tax % |
Num |
19.6 |
- |
|
|
|
| VatSum |
Tax Amount |
Num |
19.6 |
- |
|
|
|
| VatSumFrgn |
Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| VatSumSy |
Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| DedVatSum |
Deductible Tax Amount |
Num |
19.6 |
- |
|
|
|
| DedVatSumF |
Deductible Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| DedVatSumS |
Deductible Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| IsAcquistn |
Acquisition Tax |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| TaxCode |
Tax Code |
nVarChar |
8 |
OSTC |
|
|
|
| TaxType |
Tax Type |
VarChar |
1 |
- |
Y |
Y |
Regular Tax |
| |
|
|
|
|
|
N |
No Tax |
| |
|
|
|
|
|
U |
Use Tax |
| WTLiable |
WTax Liable |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| VatApplied |
Vat Applied |
Num |
19.6 |
- |
|
|
|
| VatAppldFC |
Applied Tax (FC) |
Num |
19.6 |
- |
|
|
|
| VatAppldSC |
Applied Tax (SC) |
Num |
19.6 |
- |
|
|
|
| EquVatPer |
Equalization Tax % |
Num |
19.6 |
- |
|
|
|
| EquVatSum |
Total Equalization Tax |
Num |
19.6 |
- |
|
|
|
| EquVatSumF |
Total Equalization Tax (FC) |
Num |
19.6 |
- |
|
|
|
| EquVatSumS |
Total Equalization Tax (SC) |
Num |
19.6 |
- |
|
|
|
| LineVat |
Net Tax Amount |
Num |
19.6 |
- |
|
|
|
| LineVatF |
Net Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| LineVatS |
Net Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| BaseMethod |
Drawing Method |
VarChar |
1 |
- |
|
N |
None |
| |
|
|
|
|
|
Q |
Quantity |
| |
|
|
|
|
|
V |
Volume |
| |
|
|
|
|
|
W |
Weight |
| |
|
|
|
|
|
T |
Total |
| |
|
|
|
|
|
A |
All |
| Stock |
Stock |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| LstPchPrce |
Last Purchase Price |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AnalysRpt |
Analysis Report |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BaseAbsEnt |
Base Abs Entry |
Int |
11 |
- |
-1 |
|
|
| BaseType |
Base Document Type |
Int |
11 |
- |
-1 |
-1 |
|
| |
|
|
|
|
|
0 |
|
| BaseRef |
Base Document Reference |
Int |
11 |
- |
|
|
|
| BaseLnNum |
Base Document Row No. |
Int |
11 |
- |
|
|
|
| LineNum |
line num |
Int |
11 |
- |
-1 |
|
|
| Status |
Status |
VarChar |
1 |
- |
O |
O |
Open |
| |
|
|
|
|
|
C |
Closed |
| TrgType |
Target Type |
Int |
11 |
- |
|
|
|
| TrgAbsEnt |
Target Doc. Internal No. |
Int |
11 |
- |
-1 |
|
|
| StDstr |
Stock Distributed Sum |
Num |
19.6 |
- |
|
|
|
| StDstrSC |
Stock Distributed Sum (SC) |
Num |
19.6 |
- |
|
|
|
| StDstrFC |
Stock Distributed Sum (FC) |
Num |
19.6 |
- |
|
|
|
| FixCurr |
Fixation Currency |
nVarChar |
3 |
OCRN |
|
|
|
| VatDscntPr |
Tax Discount % |
Num |
19.6 |
- |
|
|
|
| OcrCode |
Distribution Rule |
nVarChar |
8 |
OOCR |
|
|
|
| TaxDistMtd |
Tax Distribution Method |
VarChar |
1 |
- |
|
N |
None |
| |
|
|
|
|
|
Q |
Quantity |
| |
|
|
|
|
|
V |
Volume |
| |
|
|
|
|
|
W |
Weight |
| |
|
|
|
|
|
E |
Equally |
| |
|
|
|
|
|
T |
Row Total |
| OcrCode2 |
Distribution Rule2 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode3 |
Distribution Rule3 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode4 |
Distribution Rule4 |
nVarChar |
8 |
OOCR |
|
|
|
| OcrCode5 |
Distribution Rule5 |
nVarChar |
8 |
OOCR |
|
|
|
| Project |
Project Code |
nVarChar |
20 |
OPRJ |
|
|
|
| VatGrpSrc |
VAT Group Source |
VarChar |
1 |
- |
N |
N |
Not Defined |
| |
|
|
|
|
|
M |
Manually Entered |
| |
|
|
|
|
|
D |
Determined |
| DrawnTotal |
Drawn Total |
Num |
19.6 |
- |
|
|
|
| DrawnFC |
Drawn Total (FC) |
Num |
19.6 |
- |
|
|
|
| DrawnSC |
Drawn Total (SC) |
Num |
19.6 |
- |
|
|
|
| GrsAmount |
Gross Amount |
Num |
19.6 |
- |
|
|
|
| GrsFC |
Gross Amount (FC) |
Num |
19.6 |
- |
|
|
|
| GrsSC |
Gross Amount (SC) |
Num |
19.6 |
- |
|
|
|
| BaseTotal |
Base Total for Calculation |
VarChar |
1 |
- |
N |
N |
Net Total |
| |
|
|
|
|
|
G |
Gross Total |
| RetReqLC |
Return Request Amount |
Num |
19.6 |
- |
|
|
|
| RetReqFC |
Return Request Amount (FC) |
Num |
19.6 |
- |
|
|
|
| RetReqSC |
Return Request Amount (SC) |
Num |
19.6 |
- |
|
|
|
| RRVatLC |
Return Request VAT Amount |
Num |
19.6 |
- |
|
|
|
| RRVatFC |
Return Request VAT Amount (FC) |
Num |
19.6 |
- |
|
|
|
| RRVatSC |
Return Request VAT Amount (SC) |
Num |
19.6 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| ExtTaxRate |
External Tax Rate |
Num |
19.6 |
- |
|
|
|
| ExtTaxSum |
External Tax Amount |
Num |
19.6 |
- |
|
|
|
| TaxAmtSrc |
Tax Amount Source |
VarChar |
1 |
- |
S |
S |
Internal System Calculation |
| |
|
|
|
|
|
E |
External Calculation |
| ExtTaxSumF |
External Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| ExtTaxSumS |
External Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| CUSplit |
CU Split |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |