| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | Code | Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 2 | Name | Name | nvarchar | 50 | 0 | | | | Allow NULL? |
| 3 | Rate | Rate % | num | 19 | 6 | | | | Allow NULL? |
| 4 | EffecDate | Effective from | date | 8 | 0 | | | | |
| 5 | Category | Category | char | 1 | 0 | | O | I=Input Tax, O=Output Tax | Allow NULL? |
| 6 | Account | Tax Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 7 | Locked | Locked | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 8 | DataSource | Data Source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update | Allow NULL? |
| 9 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 10 | IsEC | EU | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 11 | Indicator | Triangular Deal | char | 1 | 0 | OIND | | | Allow NULL? |
| 12 | AcqstnRvrs | Acquisition/Reverse | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 13 | NonDedct | Non-Deductible % | num | 19 | 6 | | | | Allow NULL? |
| 14 | AcqsTax | Acquisition Tax Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 15 | GoddsShip | Goods Shipment | char | 1 | 0 | OGSP | | | Allow NULL? |
| 16 | NonDedAcc | Non-Deductible Acct | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 17 | DeferrAcc | Deferred Tax Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 18 | EquVatPr | Equalization Tax % | num | 19 | 6 | | | | Allow NULL? |
| 19 | ReportCode | Group Description | nvarchar | 100 | 0 | | | | Allow NULL? |
| 20 | FixdAssts | Fixed Assets Flag | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 21 | CalcMethod | Calculation Method | char | 1 | 0 | | R | F=Fixed, R=Rate | Allow NULL? |
| 22 | TaxType | Tax Type (VAT or Stamp) | char | 1 | 0 | | V | S=Stamp, V=VAT | Allow NULL? |
| 23 | FixedAmnt | Fixed Amount (LC) | num | 19 | 6 | | | | Allow NULL? |
| 24 | ExtCode | External Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | Correction | Correction | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 26 | VatCrctn | VAT Correction | nvarchar | 8 | 0 | OVTG | | | Allow NULL? |
| 27 | RetVatCode | Returning VAT Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | RepType | Report Type | int | 11 | 0 | OKRT | | | Allow NULL? |
| 29 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 30 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 31 | TaxCtgr | Tax Type (Annual List) | char | 1 | 0 | | E | A=Taxable - Article 162, B=Taxable - Article 173 point 5, C=Taxable - Construction, D=Taxable - Expected Confirmation, E=Excluded, F=Taxable - Gross, G=Gross Profit, I=Taxable - Import, L=Taxable - Late Export, M=Taxable - Article 151 point 1, N=Not Taxable, O=Taxable - Not Confirmed, P=Taxable - Article 170 point 3, R=Reverse Charge, S=Ta | Allow NULL? |
| 32 | EquAccount | Equalization Tax Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 33 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 34 | IsIGIC | IGIC | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 35 | ServSupply | Service Supply | char | 1 | 0 | OSSP | | | Allow NULL? |
| 36 | Inactive | Inactive | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 37 | TaxCtgrBL | Tax Type (Black List) | char | 1 | 0 | | E | E=Excluded, N=Not Taxable, S=Non-Subject, T=Taxable, X=Exempt | Allow NULL? |
| 38 | R349Code | Report 349 Code | int | 11 | 0 | | 0 | 0, 1=E, 2=A, 3=T, 4=S, 5=I, 6=M, 7=H | Allow NULL? |
| 39 | VatRevAcc | VAT in Revenue Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 40 | CashDisAcc | Cash Discount Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 41 | DpmTaxOAcc | Down Paymnt Tax Offset Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 42 | VatDedAcc | VAT Deductible Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 43 | CstmExpAcc | Customs VAT Expense Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 44 | CstmAlcAcc | Customs VAT Allocation Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 45 | TaxRegion | Tax Country Region | nvarchar | 5 | 0 | | PT | PT-AC=Azores Islands, PT-MA=Madeira Islands, PT=Continental Portugal | Allow NULL? |
| 46 | ExemReason | Tax Exemption Reason | nvarchar | 3 | 0 | | | M01=Article 16th No. 6 of CIVA, M02=Article 6th Law 198/90 June 19th, M03=Cash Liabilities, M04=Exempt Article 13th of CIVA, M05=Exempt Article 14th of CIVA, M06=Exempt Article 15th of CIVA, M07=Exempt Article 9th of CIVA, M08=VAT - Self-Liquidation, M09=VAT - Non-Deductible, M10=VAT - Exempted Company, M11=VAT - Exempted (Tobacco), M12=VA | Allow NULL? |
| 47 | Agent | Agent | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 48 | OpCode | Tax Operation Code | nvarchar | 7 | 0 | | | | Allow NULL? |
| 49 | Export | Export | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 50 | Section | VAT Section | nvarchar | 3 | 0 | | | | Allow NULL? |
| 51 | SplitPaymt | Split Payment | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 52 | SplitPayAc | Split Payment Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 53 | TaxAgent | Tax Agent (Section 3) | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 54 | SectionLim | VAT Section (under limit) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 55 | VatSubjCod | VAT Subject Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 56 | VatType | Type of VAT | int | 11 | 0 | | -1 | | Allow NULL? |
| 57 | VatCategor | VAT Category | int | 11 | 0 | | -1 | | Allow NULL? |
| 58 | Parag44 | Paragraph 44 | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 59 | ProrataDed | Pro-rata deductible | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 60 | ExcFrmTaxS | Exclude from Tax Summary Report Total A/R or A/P Net Amounts | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 61 | CstmActing | Customer Accounting | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 62 | CstmActOut | Corresponding Tax Code | nvarchar | 8 | 0 | | | | Allow NULL? |
