| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| AbsEntry |
Internal Number |
Int |
11 |
OINV |
|
|
|
| WTCode |
WTax Code |
nVarChar |
4 |
OWHT |
|
|
|
| Rate |
Rate |
Num |
19.6 |
- |
|
|
|
| TaxbleAmnt |
Taxable Amount |
Num |
19.6 |
- |
|
|
|
| TxblAmntSC |
Taxable Amount (SC) |
Num |
19.6 |
- |
|
|
|
| TxblAmntFC |
Taxable Amount (FC) |
Num |
19.6 |
- |
|
|
|
| WTAmnt |
WTax Amount |
Num |
19.6 |
- |
|
|
|
| WTAmntSC |
WTax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| WTAmntFC |
WTax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| ApplAmnt |
Applied WTax Amount |
Num |
19.6 |
- |
|
|
|
| ApplAmntSC |
Applied WTax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| ApplAmntFC |
Applied WTax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| Category |
Category |
VarChar |
1 |
- |
|
P |
Payment |
| |
|
|
|
|
|
I |
Invoice |
| Criteria |
Criteria |
VarChar |
1 |
- |
|
Y |
Accrual |
| |
|
|
|
|
|
N |
Cash |
| Account |
G/L Account |
nVarChar |
15 |
OACT |
|
|
|
| Type |
Withholding Tax Type |
VarChar |
1 |
- |
|
V |
VAT Withholding |
| |
|
|
|
|
|
I |
Income Tax Withholding |
| RoundType |
Rounding Type |
VarChar |
1 |
- |
|
T |
Truncated |
| |
|
|
|
|
|
C |
Commercial Values |
| |
|
|
|
|
|
N |
No Rounding |
| BaseType |
Base Type |
VarChar |
1 |
- |
|
G |
Gross |
| |
|
|
|
|
|
N |
Net |
| |
|
|
|
|
|
V |
VAT |
| |
|
|
|
|
|
U |
UoM |
| BaseAbsEnt |
Base Document Internal No. |
Int |
11 |
- |
-1 |
|
|
| BaseLine |
Base Row |
Int |
11 |
- |
|
|
|
| BaseNum |
Base Document Type |
Int |
11 |
- |
-1 |
-1 |
|
| |
|
|
|
|
|
0 |
|
| |
|
|
|
|
|
23 |
Sales Quotation |
| |
|
|
|
|
|
17 |
Sales Order |
| |
|
|
|
|
|
15 |
Delivery |
| LineNum |
Row Number |
Int |
11 |
- |
|
|
|
| BaseRef |
Base Document Reference |
Int |
11 |
- |
|
|
|
| Status |
Status |
VarChar |
1 |
- |
O |
O |
Open |
| |
|
|
|
|
|
C |
Closed |
| TrgType |
Target Document Type |
Int |
11 |
- |
|
|
|
| TrgAbsEntr |
Target Doc. Internal No. |
Int |
11 |
- |
-1 |
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
13 |
|
|
| Doc1LineNo |
DOC1 Line Number |
Int |
11 |
- |
-1 |
|
|
| WtLineType |
WTax Row Type |
VarChar |
1 |
- |
D |
D |
Document Level WTax |
| |
|
|
|
|
|
L |
Row Level WTax |
| TxblCurr |
Taxable Currency from Doc Line |
nVarChar |
3 |
- |
|
|
|
| DtblCurr |
Deductible Currency |
nVarChar |
3 |
- |
|
|
|
| DtblRate |
Rate for Deductible Amount |
Num |
19.6 |
- |
|
|
|
| txblRate |
Rate for Taxable Amount |
Num |
19.6 |
- |
|
|
|
| DtblAmount |
Deductible Amount |
Num |
19.6 |
- |
|
|
|
| TdsAcc |
TDS Account |
nVarChar |
15 |
OACT |
|
|
|
| SurAcc |
Surcharge Account |
nVarChar |
15 |
OACT |
|
|
|
| CessAcc |
Cess Account |
nVarChar |
15 |
OACT |
|
|
|
| HscAcc |
HSC Account |
nVarChar |
15 |
OACT |
|
|
|
| TdsRate |
TDS Rate |
Num |
19.6 |
- |
|
|
|
| SurRate |
Surcharge Rate |
Num |
19.6 |
- |
|
|
|
| CessRate |
Cess Rate |
Num |
19.6 |
- |
|
|
|
| HscRate |
HSC Rate |
Num |
19.6 |
- |
|
|
|
| TdsBAmt |
TDS Base Amount |
Num |
19.6 |
- |
|
|
|
| TdsBAmtSC |
TDS Base Amount (SC) |
Num |
19.6 |
- |
|
|
|
| TdsBAmtFC |
TDS Base Amount (FC) |
Num |
19.6 |
- |
|
|
|
| SurBAmt |
Surcharge Base Amount |
Num |
19.6 |
- |
|
|
|
| SurBAmtSC |
Surcharge Base Amount (SC) |
Num |
19.6 |
- |
|
|
|
| SurBAmtFC |
Surcharge Base Amount (FC) |
Num |
19.6 |
- |
|
|
|
| CessBAmt |
Cess Base Amount |
Num |
19.6 |
- |
|
|
|
| CessBAmtSC |
Cess Base Amount (SC) |
Num |
19.6 |
- |
|
|
|
| CessBAmtFC |
Cess Base Amount (FC) |
Num |
19.6 |
- |
|
|
|
| HscBAmt |
HSC Base Amount |
Num |
19.6 |
- |
|
|
|
| HscBAmtSC |
HSC Base Amount (SC) |
Num |
19.6 |
- |
|
|
|
| HscBAmtFC |
HSC Base Amount (FC) |
Num |
19.6 |
- |
|
|
|
| TdsAmnt |
TDS Tax Amount |
Num |
19.6 |
- |
|
|
|
| TdsAmntSC |
TDS Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| TdsAmntFC |
TDS Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| SurAmnt |
Surcharge Tax Amount |
Num |
19.6 |
- |
|
|
|
| SurAmntSC |
Surcharge Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| SurAmntFC |
Surcharge Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| CessAmnt |
Cess Tax Amount |
Num |
19.6 |
- |
|
|
|
| CessAmntSC |
Cess Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| CessAmntFC |
Cess Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| HscAmnt |
HSC Tax Amount |
Num |
19.6 |
- |
|
|
|
| HscAmntSC |
HSC Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| HscAmntFC |
HSC Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| TdsAppl |
Applied TDS Amount |
Num |
19.6 |
- |
|
|
|
| TdsApplSC |
Applied TDS Amount (SC) |
Num |
19.6 |
- |
|
|
|
| TdsApplFC |
Applied TDS Amount (FC) |
Num |
19.6 |
- |
|
|
|
| SurAppl |
Applied Surcharge Amount |
Num |
19.6 |
- |
|
|
|
| SurApplSC |
Applied Surcharge Amount (SC) |
Num |
19.6 |
- |
|
|
|
| SurApplFC |
Applied Surcharge Amount (FC) |
Num |
19.6 |
- |
|
|
|
| CessAppl |
Applied Cess Amount |
Num |
19.6 |
- |
|
|
|
| CessApplSC |
Applied Cess Amount (SC) |
Num |
19.6 |
- |
|
|
|
| CessApplFC |
Applied Cess Amount (FC) |
Num |
19.6 |
- |
|
|
|
| HscAppl |
Applied HSC Amount |
Num |
19.6 |
- |
|
|
|
| HscApplSC |
Applied HSC Amount (SC) |
Num |
19.6 |
- |
|
|
|
| HscApplFC |
Applied HSC Amount (FC) |
Num |
19.6 |
- |
|
|
|
| BatchNum |
Journal Voucher No. |
Int |
11 |
- |
|
|
|
| InCSTCode |
CST Code Incoming |
nVarChar |
2 |
- |
|
|
|
| OutCSTCode |
CST Code Outgoing |
nVarChar |
2 |
- |
|
|
|
| DpmWTApl |
DPM WT Applied Amount |
Num |
19.6 |
- |
|
|
|
| DpmWTAplSC |
DPM WT Applied Amount (SC) |
Num |
19.6 |
- |
|
|
|
| DpmWTAplFC |
DPM WT Applied Amount (FC) |
Num |
19.6 |
- |
|
|
|
| WTTypeId |
WT Type Id |
Int |
11 |
OWTT |
|
|
|
| LnBsAmt |
BR Line WT Base Amount |
Num |
19.6 |
- |
|
|
|
| LnBsAmtSC |
BR Line WT Base Amount(SC) |
Num |
19.6 |
- |
|
|
|
| LnBsAmtFC |
BR Line WT Base Amount(FC) |
Num |
19.6 |
- |
|
|
|
| LnCmTAmt |
BR Line Cumulated Taxable Amount |
Num |
19.6 |
- |
|
|
|
| LnCmTAmtSC |
BR Line Cumulated Taxable Amount(SC) |
Num |
19.6 |
- |
|
|
|
| LnCmTAmtFC |
BR Line Cumulated Taxable Amount(FC) |
Num |
19.6 |
- |
|
|
|
| TDSType |
TDS Type |
VarChar |
1 |
- |
|
E |
eTDS |
| |
|
|
|
|
|
D |
GST TDS |
| |
|
|
|
|
|
C |
GST TCS |
| |
|
|
|
|
|
S |
SALES TCS |
| IgstAcc |
IGST Account |
nVarChar |
15 |
OACT |
|
|
|
| CgstAcc |
CGST Account |
nVarChar |
15 |
OACT |
|
|
|
| SgstAcc |
SGST Account |
nVarChar |
15 |
OACT |
|
|
|
| IgstAmnt |
IGST Tax Amount |
Num |
19.6 |
- |
|
|
|
| IgstAmntSC |
IGST Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| IgstAmntFC |
IGST Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| CgstAmnt |
CGST Tax Amount |
Num |
19.6 |
- |
|
|
|
| CgstAmntSC |
CGST Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| CgstAmntFC |
CGST Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| SgstAmnt |
SGST Tax Amount |
Num |
19.6 |
- |
|
|
|
| SgstAmntSC |
SGST Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| SgstAmntFC |
SGST Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| IgstRate |
IGST Rate |
Num |
19.6 |
- |
|
|
|
| CgstRate |
CGST Rate |
Num |
19.6 |
- |
|
|
|
| SgstRate |
SGST Rate |
Num |
19.6 |
- |
|
|
|
| IgstBAmt |
IGST Base Amount |
Num |
19.6 |
- |
|
|
|
| IgstBAmtSC |
IGST Base Amount (SC) |
Num |
19.6 |
- |
|
|
|
| IgstBAmtFC |
IGST Base Amount (FC) |
Num |
19.6 |
- |
|
|
|
| CgstBAmt |
CGST Base Amount |
Num |
19.6 |
- |
|
|
|
| CgstBAmtSC |
CGST Base Amount (SC) |
Num |
19.6 |
- |
|
|
|
| CgstBAmtFC |
CGST Base Amount (FC) |
Num |
19.6 |
- |
|
|
|
| SgstBAmt |
SGST Base Amount |
Num |
19.6 |
- |
|
|
|
| SgstBAmtSC |
SGST Base Amount (SC) |
Num |
19.6 |
- |
|
|
|
| SgstBAmtFC |
SGST Base Amount (FC) |
Num |
19.6 |
- |
|
|
|
| IgstAppl |
Applied IGST Amount |
Num |
19.6 |
- |
|
|
|
| IgstApplSC |
Applied IGST Amount (SC) |
Num |
19.6 |
- |
|
|
|
| IgstApplFC |
Applied IGST Amount (FC) |
Num |
19.6 |
- |
|
|
|
| CgstAppl |
Applied CGST Amount |
Num |
19.6 |
- |
|
|
|
| CgstApplSC |
Applied CGST Amount (SC) |
Num |
19.6 |
- |
|
|
|
| CgstApplFC |
Applied CGST Amount (FC) |
Num |
19.6 |
- |
|
|
|
| SgstAppl |
Applied SGST Amount |
Num |
19.6 |
- |
|
|
|
| SgstApplSC |
Applied SGST Amount (SC) |
Num |
19.6 |
- |
|
|
|
| SgstApplFC |
Applied SGST Amount (FC) |
Num |
19.6 |
- |
|
|
|
| UtgstAcc |
UTGST Account |
nVarChar |
15 |
OACT |
|
|
|
| CsgstAcc |
Cess GST Account |
nVarChar |
15 |
OACT |
|
|
|
| UtgstAmt |
UTGST Tax Amount |
Num |
19.6 |
- |
|
|
|
| UtgstAmtSC |
UTGST Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| UtgstAmtFC |
UTGST Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| CsgstAmt |
Cess GST Tax Amount |
Num |
19.6 |
- |
|
|
|
| CsgstAmtSC |
Cess GST Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| CsgstAmtFC |
Cess GST Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| UtgstRate |
UTGST Rate |
Num |
19.6 |
- |
|
|
|
| CsgstRate |
Cess GST Rate |
Num |
19.6 |
- |
|
|
|
| UtgstBAmt |
UTGST Base Amount |
Num |
19.6 |
- |
|
|
|
| UtgstBAmtS |
UTGST Base Amount (SC) |
Num |
19.6 |
- |
|
|
|
| UtgstBAmtF |
UTGST Base Amount (FC) |
Num |
19.6 |
- |
|
|
|
| CsgstBAmt |
Cess GST Base Amount |
Num |
19.6 |
- |
|
|
|
| CsgstBAmtS |
Cess GST Base Amount (SC) |
Num |
19.6 |
- |
|
|
|
| CsgstBAmtF |
Cess GST Base Amount (FC) |
Num |
19.6 |
- |
|
|
|
| UtgstAppl |
Applied UTGST Amount |
Num |
19.6 |
- |
|
|
|
| UtgstApplS |
Applied UTGST Amount (SC) |
Num |
19.6 |
- |
|
|
|
| UtgstApplF |
Applied UTGST Amount (FC) |
Num |
19.6 |
- |
|
|
|
| CsgstAppl |
Applied Cess GST Amount |
Num |
19.6 |
- |
|
|
|
| CsgstApplS |
Applied Cess GST Amount (SC) |
Num |
19.6 |
- |
|
|
|
| CsgstApplF |
Applied Cess GST Amount (FC) |
Num |
19.6 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| TcsIntAcct |
TCS Interim Account |
nVarChar |
15 |
OACT |
|
|
|
| SurIntAcct |
Surcharge Interim Account |
nVarChar |
15 |
OACT |
|
|
|
| CesIntAcct |
Cess Interim Account |
nVarChar |
15 |
OACT |
|
|
|
| HscIntAcct |
HSC interim Account |
nVarChar |
15 |
OACT |
|
|
|
| LnIntAcct |
Interim Account for Tax |
nVarChar |
15 |
OACT |
|
|
|
| FixedAmnt |
Fixed Amount |
Num |
19.6 |
- |
|
|
|
| FixedAmtSC |
Fixed Amount (SC) |
Num |
19.6 |
- |
|
|
|
| FixedAmtFC |
Fixed Amount (FC) |
Num |
19.6 |
- |
|
|
|
| BaseQty |
Base Quantity |
Num |
19.6 |
- |
|
|
|