| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| WTCode |
WTax Code |
nVarChar |
4 |
- |
|
|
|
| WTName |
WTax Name |
nVarChar |
50 |
- |
|
|
|
| Rate |
Rate |
Num |
19.6 |
- |
|
|
|
| EffecDate |
Effective From |
Date |
8 |
- |
|
|
|
| Category |
Category |
VarChar |
1 |
- |
P |
I |
Invoice |
| |
|
|
|
|
|
P |
Payment |
| BaseType |
Base Type |
VarChar |
1 |
- |
N |
G |
Gross |
| |
|
|
|
|
|
N |
Net |
| |
|
|
|
|
|
V |
VAT |
| |
|
|
|
|
|
U |
UoM |
| PrctBsAmnt |
% Base Amount |
Num |
19.6 |
- |
|
|
|
| OffclCode |
Official Code |
nVarChar |
15 |
- |
|
|
|
| Account |
Account |
nVarChar |
15 |
OACT |
|
|
|
| MinTaxAmt |
Minimum Taxable Amount |
Num |
19.6 |
- |
|
|
|
| IsPrgrss |
Progressive Tax |
VarChar |
1 |
- |
N |
Y |
Progressive Tax |
| |
|
|
|
|
|
N |
Not Progressive Tax |
| Type |
Withholding Type |
VarChar |
1 |
- |
V |
V |
VAT Withholding |
| |
|
|
|
|
|
I |
Income Tax Withholding |
| RoundType |
Rounding Type |
VarChar |
1 |
- |
C |
T |
Truncated AU |
| |
|
|
|
|
|
C |
Commercial Values |
| |
|
|
|
|
|
N |
No Rounding |
| WTTypeId |
Type |
Int |
11 |
OWTT |
|
|
|
| WTCurrency |
Currency |
nVarChar |
3 |
OCRN |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| Section |
Section |
Int |
11 |
OSEC |
|
|
|
| Threshold |
Cumulative Threshold |
Num |
19.6 |
- |
|
|
|
| Surcharge |
Surcharge |
Num |
19.6 |
- |
|
|
|
| Concess |
Concessional |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Assessee |
Assessee |
Int |
11 |
ONOA |
|
|
|
| ApTdsAcc |
A/P TDS Account |
nVarChar |
15 |
OACT |
|
|
|
| ApSurAcc |
A/P Surcharge Account |
nVarChar |
15 |
OACT |
|
|
|
| ApCessAcc |
A/P Cess Account |
nVarChar |
15 |
OACT |
|
|
|
| ApHscAcc |
A/P HSC Account |
nVarChar |
15 |
OACT |
|
|
|
| ArTdsAcc |
A/R TDS Account |
nVarChar |
15 |
OACT |
|
|
|
| ArSurAcc |
A/R Surcharge Account |
nVarChar |
15 |
OACT |
|
|
|
| ArCessAcc |
A/R Cess Account |
nVarChar |
15 |
OACT |
|
|
|
| ArHscAcc |
A/R HSC Account |
nVarChar |
15 |
OACT |
|
|
|
| Location |
Location |
Int |
11 |
OLCT |
|
|
|
| ReturnType |
Return Type |
VarChar |
1 |
- |
|
A |
26 |
| |
|
|
|
|
|
B |
27 |
| |
|
|
|
|
|
C |
27EQ |
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| Inactive |
Inactive |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| InCSTCode |
CST Code Incoming |
Int |
11 |
OTSC |
-1 |
|
|
| OutCSTCode |
CST Code Outgoing |
Int |
11 |
OTSC |
-1 |
|
|
| CalBaseN |
Nature of Calculation Base |
nVarChar |
2 |
OBSI |
|
|
|
| PymntRsnCd |
Payment Reason Code |
nVarChar |
3 |
OSWA |
|
|
|
| DIOTRpt |
DIOT Report |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| TDSType |
TDS Type |
VarChar |
1 |
- |
|
E |
eTDS |
| |
|
|
|
|
|
D |
GST TDS |
| |
|
|
|
|
|
C |
GST TCS |
| |
|
|
|
|
|
S |
TCS |
| ApIgstAcc |
A/P IGST Account |
nVarChar |
15 |
OACT |
|
|
|
| ApCgstAcc |
A/P CGST Account |
nVarChar |
15 |
OACT |
|
|
|
| ApSgstAcc |
A/P SGST Account |
nVarChar |
15 |
OACT |
|
|
|
| ArIgstAcc |
A/R IGST Account |
nVarChar |
15 |
OACT |
|
|
|
| ArCgstAcc |
A/R CGST Account |
nVarChar |
15 |
OACT |
|
|
|
| ArSgstAcc |
A/R SGST Account |
nVarChar |
15 |
OACT |
|
|
|
| ApUtgstAcc |
A/P UTGST Account |
nVarChar |
15 |
OACT |
|
|
|
| ApCsgstAcc |
A/P Cess GST Account |
nVarChar |
15 |
OACT |
|
|
|
| ArUtgstAcc |
A/R UTGST Account |
nVarChar |
15 |
OACT |
|
|
|
| ArCsgstAcc |
A/R Cess GST Account |
nVarChar |
15 |
OACT |
|
|
|
| TransThres |
Transaction Threshold |
Num |
19.6 |
- |
0 |
|
|
| EBWTaxCate |
Withholding Tax Category |
Int |
11 |
OWHC |
|
|
|
| ArTcsInAcc |
A/R TCS Interim Account |
nVarChar |
15 |
OACT |
|
|
|
| ArSurInAcc |
A/R Surcharge Interim Account |
nVarChar |
15 |
OACT |
|
|
|
| ArCesInAcc |
A/R Cess Interim Account |
nVarChar |
15 |
OACT |
|
|
|
| ArHscInAcc |
A/R HSC Interim Account |
nVarChar |
15 |
OACT |
|
|
|
| ApTcsInAcc |
A/P TCS Interim Account |
nVarChar |
15 |
OACT |
|
|
|
| ApSurInAcc |
A/P Surcharge Interim Account |
nVarChar |
15 |
OACT |
|
|
|
| ApCesInAcc |
A/P Cess Interim Account |
nVarChar |
15 |
OACT |
|
|
|
| ApHscInAcc |
A/P HSC Interim Account |
nVarChar |
15 |
OACT |
|
|
|
| LnWTInAcc |
Interim Account for Tax |
nVarChar |
15 |
OACT |
|
|
|
| NoDedThrsh |
Apply Tax Exemption After Threshold |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| UseInAPDPR |
Use in A/P Down Payment Requests |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |