| 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 | 100 | 0 | | | | Allow NULL? |
| 3 | Rate | Rate | num | 19 | 6 | | | | Allow NULL? |
| 4 | SalesTax | Sales Tax Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 5 | UseTax | Use Tax Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 6 | Type | Type | int | 11 | 0 | OSTT | | | Allow NULL? |
| 7 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 8 | PurchTax | Purchasing Tax Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 9 | deferrAcct | Deferred Tax Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 10 | NonDdctPrc | Non Deductible % | num | 19 | 6 | | | | Allow NULL? |
| 11 | NonDdctAct | Non Deductible Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 12 | TaxInPrice | Included in Price | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 13 | Exempt | Exempt | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 14 | APExpAct | Purchasing Tax Expense Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 15 | ARExpAct | Sales Tax Expense Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 16 | CredBala | Credit Balance: Raw Material | num | 19 | 6 | | | | Allow NULL? |
| 17 | CredFG | Credit for Finished Goods | num | 19 | 6 | | | | Allow NULL? |
| 18 | CredCG | Credit for Capital Goods | num | 19 | 6 | | | | Allow NULL? |
| 19 | InGrossRev | Included in Gross Revenue | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 20 | EfctDate | Effective From | date | 8 | 0 | | | | |
| 21 | SvcTaxCr | Credit for Service Tax | num | 19 | 6 | | | | Allow NULL? |
| 22 | MinAmount | Min. Taxable Amount | num | 19 | 6 | | | | Allow NULL? |
| 23 | MaxAmount | Max. Taxable Amount | num | 19 | 6 | | | | Allow NULL? |
| 24 | FlatAmount | Flat Tax Amount | num | 19 | 6 | | | | Allow NULL? |
| 25 | TextCode | Text Code | int | 6 | 0 | | | | Allow NULL? |
| 26 | UnencumTax | Unencumbered Tax | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 27 | TaxOnRI | Tax On Reserve Invoice | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 28 | DIOTRptTyp | DIOT Report Type | char | 1 | 0 | | | A=15% or 16% VAT, B=15% or 16% VAT on Import, C=Exempt on Import, D=0% VAT, E=Exempt, F=VAT on Returns, Discounts, and Rebates | Allow NULL? |
| 29 | IsSystem | Is System Tax Jurisdiction | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 30 | RvsCrgPrc | Reverse Charge % | num | 19 | 6 | | | | Allow NULL? |
| 31 | InFirstIns | Included in First Installment | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 32 | SaleTaxRCM | Sales Tax RCM Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 33 | SaleRCMClr | Sales Tax RCM Clearing Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
