| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | DocEntry | Document Internal ID | int | 11 | 0 | OPCH | | | Allow NULL? |
| 2 | LineNum | Row Number | int | 11 | 0 | | -1 | | Allow NULL? |
| 3 | GroupNum | Group Number | int | 11 | 0 | | -1 | | Allow NULL? |
| 4 | ExpnsCode | Expense Code | int | 11 | 0 | OEXD | -1 | | Allow NULL? |
| 5 | RelateType | Relation Type | int | 11 | 0 | | 1 | 13=Distributed Freights, 1=Row, 2=Row Freight Charges, 3=Document Expenses | Allow NULL? |
| 6 | StcCode | Tax Code | nvarchar | 8 | 0 | OSTC | | | Allow NULL? |
| 7 | StaCode | Authority Code | nvarchar | 8 | 0 | OSTA | | | Allow NULL? |
| 8 | staType | Authority Type | int | 11 | 0 | OSTT | | | Allow NULL? |
| 9 | TaxRate | Tax Rate | num | 19 | 6 | | | | Allow NULL? |
| 10 | TaxAcct | Tax Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 11 | TaxSum | Tax Amount | num | 19 | 6 | | | | Allow NULL? |
| 12 | TaxSumFrgn | Tax Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 13 | TaxSumSys | Tax Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 14 | BaseSum | Base Amount | num | 19 | 6 | | | | Allow NULL? |
| 15 | BaseSumFrg | Base Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 16 | BaseSumSys | Base Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 17 | ObjectType | Object Type | nvarchar | 20 | 0 | ADP1 | 18 | | Allow NULL? |
| 18 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 19 | TaxStatus | Tax Status | char | 1 | 0 | | Y | N=No Tax, U=Use Tax, Y=Regular Tax | Allow NULL? |
| 20 | VatApplied | VAT Applied | num | 19 | 6 | | | | Allow NULL? |
| 21 | VatAppldFC | Applied Tax (FC) | num | 19 | 6 | | | | Allow NULL? |
| 22 | VatAppldSC | Applied Tax (SC) | num | 19 | 6 | | | | Allow NULL? |
| 23 | LineSeq | Line Sequence | int | 11 | 0 | | | | Allow NULL? |
| 24 | DeferrAcct | Deferred Tax Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 25 | BaseType | Base Document Type | int | 11 | 0 | | -1 | | Allow NULL? |
| 26 | BaseAbs | Base Doc Abs Entry | int | 11 | 0 | | -1 | | Allow NULL? |
| 27 | BaseSeq | Base Doc. Line Sequence | int | 11 | 0 | | | | Allow NULL? |
| 28 | DeductTax | Deductible Tax Amount | num | 19 | 6 | | | | Allow NULL? |
| 29 | DdctTaxFrg | Deductible Tax Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 30 | DdctTaxSys | Deductible Tax Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 31 | BaseAppld | Applied Base Amount | num | 19 | 6 | | | | Allow NULL? |
| 32 | BaseApldFC | Applied Base Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 33 | BaseApldSC | Applied Base Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 34 | NonDdctPrc | Non Deductible % | num | 19 | 6 | | | | Allow NULL? |
| 35 | NonDdctAct | Non Deductible Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 36 | TaxInPrice | Tax Included in Price? | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 37 | Exempt | Exempt? | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 38 | TaxExpAct | Expense Account for Tax | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 39 | OnHoldTax | On Hold Tax Amount | num | 19 | 6 | | | | Allow NULL? |
| 40 | OnHoldTaxF | On Hold Tax Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 41 | OnHoldTaxS | On Hold Tax Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 42 | InGrossRev | Included in Gross Revenue | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 43 | TaxSumOrg | Tax Amount Original | num | 19 | 6 | | | | Allow NULL? |
| 44 | TaxSumOrgF | Tax Amount Original (FC) | num | 19 | 6 | | | | Allow NULL? |
| 45 | TaxSumOrgS | Tax Amount Original (SC) | num | 19 | 6 | | | | Allow NULL? |
| 46 | OpenTax | Open Service Tax | num | 19 | 6 | | | | Allow NULL? |
| 47 | OpenTaxFC | Open Service Tax (FC) | num | 19 | 6 | | | | Allow NULL? |
| 48 | OpenTaxSC | Open Service Tax (SC) | num | 19 | 6 | | | | Allow NULL? |
| 49 | Unencumbrd | Unencumbered | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 50 | TaxOnRI | Tax On Reserve Invoice | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 51 | RvsChrgPrc | Reverse Charge % | num | 19 | 6 | | | | Allow NULL? |
| 52 | RvsChrgTax | Reverse Charge Tax Amount | num | 19 | 6 | | | | Allow NULL? |
| 53 | RvsChrgSC | Reverse Charge Tax Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 54 | RvsChrgFC | Reverse Charge Tax Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 55 | InFirstIns | Included in First Installment | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
