JA India GSTR-3 Return

Description
Categories: BI Publisher
Columns: Pdcash, Tax Val, Txpd, Itc ...
Application: Asia/Pacific Localizations
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
CGST LateFee Paid
 
Number
SGST LateFee Paid
 
Number
CESS Interest Paid
 
Number
CGST Interest Paid
 
Number
SGST Interest Paid
 
Number
IGST Interest Paid
 
Number
Return Period(MONYYYY)
 
Registration Number
 
LOV Oracle
Tax Regime
 
LOV Oracle