JA India GSTR-2 Return

➜ Back to Library
Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
Source: India GSTR-2 Return Report
Short Name: JAIGSTR2
DB package: JAI_GSTR2_EXTRACT_PKG
Run JA India GSTR-2 Return and other Oracle EBS reports with Blitz Report™ on our demo environment
                                   select    THIRD_PARTY_REG_NUM ctin,
                                             TAX_INVOICE_NUMBER boenum,
                                             to_char(TAX_INVOICE_DATE) boedt,
                                            -- TAX_INVOICE_VALUE,
                                             TAX_RATE rate,
                                             TAXABLE_AMT taxval,
                                             IGST igst,
                                             CESS cess,
                                             SGST sgst,
                                             CGST cgst,
                                             STATE pos,
											 'A' flag,
                                             INELIG_ITC_FLAG elig,
                                             ITC_IGST itc_igst,
                                             ITC_CESS itc_cess,
                                             ITC_CGST itc_cgst,
                                             ITC_SGST itc_sgst,
                                             INV_CHECK_SUM_VAL chksum,
                                             rownum num,
                                             REV_GSTIN revctin,
                                             REV_INV_NUM revinum,
                                             REV_INV_DATE revidt,
                                             REV_INV_VAL revinvval,
                                             NOTE_TYPE ntty,
                                             P_GST p_gst,
                                             RSN rsn,
											 ATTRIBUTE1
                                     from JAI_GST_REP_TRX_DETAIL_T
                                     where SECTION_CODE='CDN'
									 and ATTRIBUTE12='GSTR2'
Parameter Name SQL text Validation
Tax Regime 
 
 LOV Oracle
Registration Number 
 
 LOV Oracle
Return Period(MONYYYY) 
 
 Char
Download
Related Blitz Reports
JA India GSTR-1 Return JA India - RG1 Register Report(XML Publisher) JA India - Tax Recovery Register Report(XML Publisher) JA India - ST Forms Report(XML Publisher) JA India - Inward Stock Register Report(XML Publisher) JA India - Tax Liability Register Report(XML Publisher) JA India - Settlement Detail Report (XML Publisher) JA India - Tax Register Report(XML Publisher) JA India - Tax Exemptions Report(XML Publisher)
Blitz Report™

Blitz Report™ provides multiple benefits: