JA India GSTR-3 Return
Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
Source: India GSTR-3 Return Report
Short Name: JAIGSTR3
DB package:
Source: India GSTR-3 Return Report
Short Name: JAIGSTR3
DB package:
SELECT NULL pdcash, TAX_LIABILITY_AMT tax_val, NULL txpd, lines.CREDIT_TO_BE_ADJUSTED itc FROM JAI_STL_TRX_HDRS_V hdr, JAI_STL_TRX_LINES_V lines WHERE hdr.STL_HDR_ID = lines.STL_HDR_ID AND TO_CHAR (TRUNC (hdr.settlement_date), 'MONYYYY') LIKE :P_PERIOD_NAME AND REGISTRATION_NUM = :P_FIRST_PTY_REG_NUM |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Tax Regime |
|
LOV Oracle | |
Registration Number |
|
LOV Oracle | |
Return Period(MONYYYY) |
|
Char | |
IGST Interest Paid |
|
Number | |
SGST Interest Paid |
|
Number | |
CGST Interest Paid |
|
Number | |
CESS Interest Paid |
|
Number | |
SGST LateFee Paid |
|
Number | |
CGST LateFee Paid |
|
Number |