JA India GSTR-1 Return

Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
Source: India GSTR-1 Return Report
Short Name: JAIGSTR1
DB package: JAI_GST_EXTRACT_PKG
Run JA India GSTR-1 Return and other Oracle EBS reports with Blitz Report™ on our demo environment
 SELECT A.THIRD_PARTY_REG_NUM,
                               A.rev_inv_num isnum,
                               A.FLAG flag,
                               A.SUPP_TYPE sply_ty,
                               TRUNC(A.rev_inv_date) isdt,
                               A.INV_CHECK_SUM_VAL chksum,
                               A.THIRD_PARTY_REG_NUM ctin,
                               A.TAX_INVOICE_NUMBER inum,
                               TO_CHAR(A.TAX_INVOICE_DATE,'DD/MM/YYYY') idt,
                               A.TAX_INVOICE_VALUE val,
                               A.TAX_RATE rt,
                               A.TAXABLE_AMT txval,
                               A.IGST iamt,
                               A.CESS csamt,
                               A.STATE pos,
                               A.TRX_NUMBER nt_num,
                               A.TRX_DATE nt_dt,
                               DECODE(A.EVENT_CLASS_CODE,'CREDIT_MEMO','C','DEBIT_MEMO','D') ntty,
							   A.EXPORT_TYPE typ,
                              'N' p_gst,
					           NULL rsn,
					           rownum num							   
                        FROM 
                        JAI_GST_REP_TRX_DETAIL_T A
                        WHERE SECTION_CODE='CDNUR'
Parameter Name SQL text Validation
Tax Regime
 
LOV Oracle
Registration Number
 
LOV Oracle
Return Period(MONYYYY)
 
Char
Aggregate Turnover April to June
 
Number
Aggregate Turnover-Apr to Jun
 
Number