| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| DocEntry |
Document Internal ID |
Int |
11 |
ORPD |
|
|
|
| LineNum |
Row Number |
Int |
11 |
- |
|
|
|
| GroupNum |
Group Number |
Int |
11 |
- |
|
|
|
| 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 |
- |
|
|
|
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
21 |
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| 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 |
| VatApplied |
Vat Applied |
Num |
19.6 |
- |
|
|
|
| VatAppldFC |
Vat Applied Frgn |
Num |
19.6 |
- |
|
|
|
| VatAppldSC |
Vat Applied Sys |
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 |
- |
|
|
|
| lineVatlF |
Net Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| lineVatS |
Net Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| WtLiable |
WTax Liable |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| 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 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BaseGroup |
Base Document Group |
Int |
11 |
- |
-1 |
-1 |
|
| |
|
|
|
|
|
0 |
|
| |
|
|
|
|
|
1 |
|
| |
|
|
|
|
|
2 |
|
| Status |
Status |
VarChar |
1 |
- |
O |
O |
Open |
| |
|
|
|
|
|
C |
Close |
| TrgGroup |
Target Group |
Int |
11 |
- |
-1 |
-1 |
|
| |
|
|
|
|
|
0 |
|
| |
|
|
|
|
|
1 |
|
| |
|
|
|
|
|
2 |
|
| VisOrder |
Visual Order |
Int |
11 |
- |
|
|
|
| FixCurr |
Fixation Currency |
nVarChar |
3 |
OCRN |
|
|
|
| VatDscntPr |
Tax Discount % |
Num |
19.6 |
- |
|
|
|
| OcrCode |
Distribution Rule |
nVarChar |
8 |
OOCR |
|
|
|
| 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 |
- |
|
|
|
| RetReqLC |
Return Request Amount |
Num |
19.6 |
- |
|
|
|
| RetReqFC |
Return Request Amount (FC) |
Num |
19.6 |
- |
|
|
|
| RetReqSC |
Return Request Amount (SC) |
Num |
19.6 |
- |
|
|
|
| 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 |