| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | DocEntry | Document Internal ID | int | 11 | 0 | OPDN | | | Allow NULL? |
| 2 | ExpnsCode | Freight Code | int | 11 | 0 | OEXD | | | Allow NULL? |
| 3 | LineTotal | Total | num | 19 | 6 | | | | Allow NULL? |
| 4 | TotalFrgn | Total (FC) | num | 19 | 6 | | | | Allow NULL? |
| 5 | TotalSumSy | Total (SC) | num | 19 | 6 | | | | Allow NULL? |
| 6 | PaidToDate | Paid to Date | num | 19 | 6 | | | | Allow NULL? |
| 7 | PaidFC | Paid (FC) | num | 19 | 6 | | | | Allow NULL? |
| 8 | PaidSys | Paid (SC) | num | 19 | 6 | | | | Allow NULL? |
| 9 | Comments | Remarks | nvarchar | 100 | 0 | | | | Allow NULL? |
| 10 | ObjType | Object Type | nvarchar | 20 | 0 | ADP1 | 20 | | Allow NULL? |
| 11 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 12 | DistrbMthd | Distribution Method | char | 1 | 0 | | | E=Equally, N=None, Q=Quantity, T=Row Total, V=Volume, W=Weight | Allow NULL? |
| 13 | TaxStatus | Tax Liable | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 14 | VatGroup | Tax Group | nvarchar | 8 | 0 | OVTG | | | Allow NULL? |
| 15 | VatPrcnt | Row Tax % | num | 19 | 6 | | | | Allow NULL? |
| 16 | VatSum | Tax Amount | num | 19 | 6 | | | | Allow NULL? |
| 17 | VatSumFrgn | Tax Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 18 | VatSumSy | Tax Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 19 | DedVatSum | Deductible Tax Amount | num | 19 | 6 | | | | Allow NULL? |
| 20 | DedVatSumF | Deductible Tax Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 21 | DedVatSumS | Deductible Tax Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 22 | IsAcquistn | Acquisition Tax | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 23 | TaxCode | Tax Code | nvarchar | 8 | 0 | OSTC | | | Allow NULL? |
| 24 | TaxType | Tax Type | char | 1 | 0 | | Y | N=No Tax, U=Use Tax, Y=Regular Tax | Allow NULL? |
| 25 | WTLiable | WTax Liable | char | 1 | 0 | | | N=No, Y=Yes | Allow NULL? |
| 26 | VatApplied | Vat Applied | num | 19 | 6 | | | | Allow NULL? |
| 27 | VatAppldFC | Applied Tax (FC) | num | 19 | 6 | | | | Allow NULL? |
| 28 | VatAppldSC | Applied Tax (SC) | num | 19 | 6 | | | | Allow NULL? |
| 29 | EquVatPer | Equalization Tax % | num | 19 | 6 | | | | Allow NULL? |
| 30 | EquVatSum | Total Equalization Tax | num | 19 | 6 | | | | Allow NULL? |
| 31 | EquVatSumF | Total Equalization Tax (FC) | num | 19 | 6 | | | | Allow NULL? |
| 32 | EquVatSumS | Total Equalization Tax (SC) | num | 19 | 6 | | | | Allow NULL? |
| 33 | LineVat | Net Tax Amount | num | 19 | 6 | | | | Allow NULL? |
| 34 | LineVatF | Net Tax Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 35 | LineVatS | Net Tax Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 36 | BaseMethod | Drawing Method | char | 1 | 0 | | | A=All, N=None, Q=Quantity, T=Total, V=Volume, W=Weight | Allow NULL? |
| 37 | Stock | Stock | char | 1 | 0 | | | N=No, Y=Yes | Allow NULL? |
| 38 | LstPchPrce | Last Purchase Price | char | 1 | 0 | | | N=No, Y=Yes | Allow NULL? |
| 39 | AnalysRpt | Analysis Report | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 40 | BaseAbsEnt | Base Abs Entry | int | 11 | 0 | | -1 | | Allow NULL? |
| 41 | BaseType | Base Document Type | int | 11 | 0 | | -1 | -1, 0, 18=A/P Invoice, 21=Goods Return, 22=Purchase orders | Allow NULL? |
| 42 | BaseRef | Base Document Reference | int | 11 | 0 | | | | Allow NULL? |
| 43 | BaseLnNum | Base Document Row No. | int | 11 | 0 | | | | Allow NULL? |
| 44 | LineNum | line num | int | 11 | 0 | | -1 | | Allow NULL? |
| 45 | Status | Status | char | 1 | 0 | | O | C=Closed, O=Open | Allow NULL? |
| 46 | TrgType | Target Type | int | 11 | 0 | | | | Allow NULL? |
| 47 | TrgAbsEnt | Target Doc. Internal No. | int | 11 | 0 | | -1 | | Allow NULL? |
| 48 | StDstr | Stock Distributed Sum | num | 19 | 6 | | | | Allow NULL? |
| 49 | StDstrSC | Stock Distributed Sum (SC) | num | 19 | 6 | | | | Allow NULL? |
| 50 | StDstrFC | Stock Distributed Sum (FC) | num | 19 | 6 | | | | Allow NULL? |
| 51 | FixCurr | Fixation Currency | nvarchar | 3 | 0 | OCRN | | | Allow NULL? |
| 52 | VatDscntPr | Tax Discount % | num | 19 | 6 | | | | Allow NULL? |
| 53 | OcrCode | Distribution Rule | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 54 | TaxDistMtd | Tax Distribution Method | char | 1 | 0 | | | E=Equally, N=None, Q=Quantity, T=Row Total, V=Volume, W=Weight | Allow NULL? |
| 55 | OcrCode2 | Distribution Rule2 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 56 | OcrCode3 | Distribution Rule3 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 57 | OcrCode4 | Distribution Rule4 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 58 | OcrCode5 | Distribution Rule5 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 59 | Project | Project Code | nvarchar | 20 | 0 | OPRJ | | | Allow NULL? |
| 60 | VatGrpSrc | VAT Group Source | char | 1 | 0 | | N | D=Determined, M=Manually Entered, N=Not Defined | Allow NULL? |
| 61 | DrawnTotal | Drawn Total | num | 19 | 6 | | | | Allow NULL? |
| 62 | DrawnFC | Drawn Total (FC) | num | 19 | 6 | | | | Allow NULL? |
| 63 | DrawnSC | Drawn Total (SC) | num | 19 | 6 | | | | Allow NULL? |
| 64 | GrsAmount | Gross Amount | num | 19 | 6 | | | | Allow NULL? |
| 65 | GrsFC | Gross Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 66 | GrsSC | Gross Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 67 | BaseTotal | Base Total for Calculation | char | 1 | 0 | | N | G=Gross Total, N=Net Total | Allow NULL? |
| 68 | RetReqLC | Return Request Amount | num | 19 | 6 | | | | Allow NULL? |
| 69 | RetReqFC | Return Request Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 70 | RetReqSC | Return Request Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 71 | RRVatLC | Return Request VAT Amount | num | 19 | 6 | | | | Allow NULL? |
| 72 | RRVatFC | Return Request VAT Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 73 | RRVatSC | Return Request VAT Amount (SC) | num | 19 | 6 | | | | Allow NULL? |