| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | WTCode | WTax Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 2 | WTName | WTax 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 | | P | I=Invoice, P=Payment | Allow NULL? |
| 6 | BaseType | Base Type | char | 1 | 0 | | N | G=Gross, N=Net, V=VAT | Allow NULL? |
| 7 | PrctBsAmnt | % Base Amount | num | 19 | 6 | | | | Allow NULL? |
| 8 | OffclCode | Official Code | nvarchar | 15 | 0 | | | | Allow NULL? |
| 9 | Account | Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 10 | MinTaxAmt | Minimum Taxable Amount | num | 19 | 6 | | | | Allow NULL? |
| 11 | IsPrgrss | Progressive Tax | char | 1 | 0 | | N | N=Not Progressive Tax, Y=Progressive Tax | Allow NULL? |
| 12 | Type | Withholding Type | char | 1 | 0 | | V | I=Income Tax Withholding, V=VAT Withholding | Allow NULL? |
| 13 | RoundType | Rounding Type | char | 1 | 0 | | C | C=Commercial Values, T=Truncated AU | Allow NULL? |
| 14 | WTTypeId | Type | int | 11 | 0 | OWTT | | | Allow NULL? |
| 15 | WTCurrency | Currency | nvarchar | 3 | 0 | OCRN | | | Allow NULL? |
| 16 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 17 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 18 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 19 | Section | Section | int | 11 | 0 | OSEC | | | Allow NULL? |
| 20 | Threshold | Threshold | num | 19 | 6 | | | | Allow NULL? |
| 21 | Surcharge | Surcharge | num | 19 | 6 | | | | Allow NULL? |
| 22 | Concess | Concessional | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 23 | Assessee | Assessee | int | 11 | 0 | ONOA | | | Allow NULL? |
| 24 | ApTdsAcc | A/P TDS Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 25 | ApSurAcc | A/P Surcharge Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 26 | ApCessAcc | A/P Cess Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 27 | ApHscAcc | A/P HSC Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 28 | ArTdsAcc | A/R TDS Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 29 | ArSurAcc | A/R Surcharge Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 30 | ArCessAcc | A/R Cess Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 31 | ArHscAcc | A/R HSC Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 32 | Location | Location | int | 11 | 0 | OLCT | | | Allow NULL? |
| 33 | ReturnType | Return Type | char | 1 | 0 | | | A=26, B=27 | Allow NULL? |
| 34 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 35 | Inactive | Inactive | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 36 | InCSTCode | CST Code Incoming | int | 11 | 0 | OTSC | -1 | | Allow NULL? |
| 37 | OutCSTCode | CST Code Outgoing | int | 11 | 0 | OTSC | -1 | | Allow NULL? |
| 38 | CalBaseN | Nature of Calculation Base | nvarchar | 2 | 0 | OBSI | | | Allow NULL? |
| 39 | PymntRsnCd | Payment Reason Code | nvarchar | 2 | 0 | OSWA | | A=A, B=B, C=C, D=D, E=E, G=G, H=H, I=I, L1=L1, L=L, M1=M1, M2=M2, M=M, N=N, O1=O1, O=O, P=P, Q=Q, R=R, S=S, T=T, U=U, V1=V1, V2=V2, V=V, W=W, X=X, Y=Y, ZO=ZO | Allow NULL? |
| 40 | DIOTRpt | DIOT Report | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 41 | TDSType | TDS Type | char | 1 | 0 | | | C=GST TCS, D=GST TDS, E=eTDS | Allow NULL? |
| 42 | ApIgstAcc | A/P IGST Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 43 | ApCgstAcc | A/P CGST Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 44 | ApSgstAcc | A/P SGST Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 45 | ArIgstAcc | A/R IGST Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 46 | ArCgstAcc | A/R CGST Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 47 | ArSgstAcc | A/R SGST Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 48 | ApUtgstAcc | A/P UTGST Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 49 | ApCsgstAcc | A/P Cess GST Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 50 | ArUtgstAcc | A/R UTGST Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 51 | ArCsgstAcc | A/R Cess GST Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
