JA India GSTR-3 Return

Description
Categories: India Localization
Imported from BI Publisher
Description: India GSTR-3 Return Report with XML format
Application: Asia/Pacific Localizations
Source: India GSTR-3 Return Report(XML)
Short Name: JAIGSTR3_XML
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 
1=1 and
hdr.stl_hdr_id = lines.stl_hdr_id
Parameter NameSQL textValidation
Tax Regime
 
LOV Oracle
Registration Number
registration_num=:p_first_pty_reg_num
LOV Oracle
Return Period(MONYYYY)
to_char (trunc (hdr.settlement_date), 'MONYYYY') like :p_period_name
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