| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | AbsEntry | Internal ID | int | 11 | 0 | OUTX | | | Allow NULL? |
| 2 | LineSeq | Row Sequence | int | 11 | 0 | | | | Allow NULL? |
| 3 | SrcArrType | Source Array Type | int | 11 | 0 | | -1 | -1=Default, 12=Array1, 13=Array2, 14=Array3, 15=Array4, 16=Array5, 17=Array6, 18=Array7, 1=Main, 24=Array13 | Allow NULL? |
| 4 | SrcLineNum | Source Row Number | int | 11 | 0 | | -1 | | Allow NULL? |
| 5 | SrcGrpNum | Source Group Number | int | 11 | 0 | | -1 | -1=Default, 0=Group1, 1=Group2, 2=Group3 | Allow NULL? |
| 6 | TaxCode | Tax Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | StaCode | Tax Authority Code | nvarchar | 8 | 0 | OSTA | | | Allow NULL? |
| 8 | StaType | Tax Authority Type | int | 11 | 0 | OSTT | | | Allow NULL? |
| 9 | StaIndex | Tax Authority Seq Index | int | 11 | 0 | | | | Allow NULL? |
| 10 | IsLiable | Is Tax Liable | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 11 | TaxType | Tax Type | char | 1 | 0 | | Y | D=Deferred Tax Offset Transaction, N=No Tax, O=Tax Offset Transaction, P=DPM Request Tax Offset Transaction, R=Reverse Tax Offset Transaction, U=Use Tax, Y=Regular | Allow NULL? |
| 12 | IsAcq | Is Acquisition Tax | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 13 | Isdeferred | Deferred Tax [Yes/No] | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 14 | ValueDate | Due Date for Payment | date | 8 | 0 | | | | |
| 15 | VatPercent | VAT Percent | num | 19 | 6 | | | | Allow NULL? |
| 16 | NdPercent | Non Deductible % | num | 19 | 6 | | | | Allow NULL? |
| 17 | EqPercent | Equalization Percent | num | 19 | 6 | | | | Allow NULL? |
| 18 | BaseObjTyp | Base Object Type | nvarchar | 20 | 0 | | -1 | -1, 112=Document Draft, 123=Checks for Payment Drafts, 140=Payment Draft, 15=Delivery notes, 16=Revert Delivery Notes, 17=Sales Order, 20=Goods Receipt, 21=Goods Return, 22=Purchase order, 23=Sales Quotation, 28=Journal Batches, 540000006=Purchase Quotation, 59=Goods Receipt, 60=Goods Issue | Allow NULL? |
| 19 | BaseAbs | Base Document Internal No. | int | 11 | 0 | | -1 | | Allow NULL? |
| 20 | BaseArrTyp | Base Array Type | int | 11 | 0 | | -1 | -1=Default, 12=Array1, 13=Array2, 14=Array3, 15=Array4, 16=Array5, 17=Array6, 18=Array7, 1=Main, 24=Array13 | Allow NULL? |
| 21 | BaseLinNum | Base Row Number | int | 11 | 0 | | -1 | | Allow NULL? |
| 22 | BaseGrpNum | Base Group No. | int | 11 | 0 | | -1 | -1=Default, 0=Group1, 1=Group2, 2=Group3 | Allow NULL? |
| 23 | BaseSum | Base Sum | num | 19 | 6 | | | | Allow NULL? |
| 24 | BaseSumSc | Base Sum (SC) | num | 19 | 6 | | | | Allow NULL? |
| 25 | BaseSumFc | Base Sum (FC) | num | 19 | 6 | | | | Allow NULL? |
| 26 | VatSum | VAT Sum | num | 19 | 6 | | | | Allow NULL? |
| 27 | VatSumSc | VAT Sum (SC) | num | 19 | 6 | | | | Allow NULL? |
| 28 | VatSumFc | VAT Sum (FC) | num | 19 | 6 | | | | Allow NULL? |
| 29 | DeductSum | Deduct VAT Sum | num | 19 | 6 | | | | Allow NULL? |
| 30 | DedctSumSC | Deduct VAT Sum (SC) | num | 19 | 6 | | | | Allow NULL? |
| 31 | DedctSumFC | Deduct VAT Sum (FC) | num | 19 | 6 | | | | Allow NULL? |
| 32 | EqSum | Equalization Sum | num | 19 | 6 | | | | Allow NULL? |
| 33 | EqSumSC | Equalization Sum (SC) | num | 19 | 6 | | | | Allow NULL? |
| 34 | EqSumFC | Equalization Sum (FC) | num | 19 | 6 | | | | Allow NULL? |
| 35 | TaxAcct | Tax Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 36 | DefAcct | Deferred Tax Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 37 | NdAcct | Non Deduct. Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 38 | AcqAcct | Acquisition Tax Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 39 | ExpAcct | Expense Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 40 | CrditDebit | Credit Or Debit Transaction | char | 1 | 0 | | | C=Credit, D=DEBIT | Allow NULL? |
| 41 | PostingTyp | Sales or Purchasing | char | 1 | 0 | | N | N=None, P=Purchase, R=Sales | Allow NULL? |
| 42 | BasePaid | Applied Base Sum | num | 19 | 6 | | | | Allow NULL? |
| 43 | BasePaidSC | Applied Base Sum SC | num | 19 | 6 | | | | Allow NULL? |
| 44 | BasePaidFC | Applied Base Sum FC | num | 19 | 6 | | | | Allow NULL? |
| 45 | VatPaid | Applied VAT Sum | num | 19 | 6 | | | | Allow NULL? |
| 46 | VatPaidSC | Applied VAT Sum SC | num | 19 | 6 | | | | Allow NULL? |
| 47 | VatPaidFC | Applied VAT Sum FC | num | 19 | 6 | | | | Allow NULL? |
| 48 | DeductPaid | Applied Deduct Sum | num | 19 | 6 | | | | Allow NULL? |
| 49 | DdctPaidSC | Applied Deduct Sum SC | num | 19 | 6 | | | | Allow NULL? |
| 50 | DdctPaidFC | Applied Deduct Sum FC | num | 19 | 6 | | | | Allow NULL? |
| 51 | EqPaid | Applied Equalization Sum | num | 19 | 6 | | | | Allow NULL? |
| 52 | EqPaidSC | Applied Equalization Sum SC | num | 19 | 6 | | | | Allow NULL? |
| 53 | EqPaidFC | Applied Equalization Sum FC | num | 19 | 6 | | | | Allow NULL? |
| 54 | TransAcct | Transaction Acccount | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 55 | LnDataNum | Line Number in Tax Data | int | 11 | 0 | | -1 | | Allow NULL? |
| 56 | InPrice | Included in Price | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 57 | Exempt | Exempt | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 58 | InGrossRev | Included in Gross Revenue | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 59 | PostStatus | Posting Status | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 60 | IsItmLevel | Is Item Level Tax | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 61 | MinTAmt | Min. Taxable Amount | num | 19 | 6 | | | | Allow NULL? |
| 62 | MinTAmtSC | Min. Taxable Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 63 | MinTAmtFC | Min. Taxable Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 64 | MaxTAmt | Max. Taxable Amount | num | 19 | 6 | | | | Allow NULL? |
| 65 | MaxTAmtSC | Max. Taxable Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 66 | MaxTAmtFC | Max. Taxable Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 67 | FlatTAmt | Flat Tax Amount | num | 19 | 6 | | | | Allow NULL? |
| 68 | FlatTAmtSC | Flat Tax Amount (SC) | num | 19 | 6 | | | | Allow NULL? |
| 69 | FlatTAmtFC | Flat Tax Amount (FC) | num | 19 | 6 | | | | Allow NULL? |
| 70 | EqTaxAcct | Equalization Tax Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 71 | Reposted | Reposted in Transfer Wizard | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 72 | Unencumbrd | Unencumbered | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 73 | IsSplitPay | Split Payment | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 74 | SplitPayAc | Split Payment Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 75 | TaxOnRI | Tax On Reserve Invoice | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 76 | RvsChrgPrc | Reverse Charge % | num | 19 | 6 | | | | Allow NULL? |
| 77 | RvsChrgSum | Reverse Charge Sum | num | 19 | 6 | | | | Allow NULL? |
| 78 | RvsChrgSC | Reverse Charge Sum (SC) | num | 19 | 6 | | | | Allow NULL? |
| 79 | RvsChrgFC | Reverse Charge Sum (FC) | num | 19 | 6 | | | | Allow NULL? |
| 80 | GstPayAct | GST Payable Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 81 | RvsPaid | Applied Reverse Charge Sum | num | 19 | 6 | | | | Allow NULL? |
| 82 | RvsPaidSC | Applied Reverse Charge (SC) | num | 19 | 6 | | | | Allow NULL? |
| 83 | RvsPaidFC | Applied Reverse Charge (FC) | num | 19 | 6 | | | | Allow NULL? |
| 84 | InFirstIns | Included in First Installment | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 85 | GstRecvAct | GST Receivable Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 86 | IsCstmAct | Apply Customer Accounting Tax Rule | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |