JA India GSTR-1 Return

➜ Back to Library

Description
Categories: BI Publisher Application: Asia/Pacific Localizations Source: India GSTR-1 Return Report Short Name: JAIGSTR1 DB package: JAI_GST_EXTRACT_PKG more less

Copy

 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

Aggregate Turnover-Apr to Jun

Number

Aggregate Turnover April to June

Number

Return Period(MONYYYY)

Registration Number

LOV Oracle

Tax Regime

LOV Oracle

Download

Related Blitz Reports
JA India GSTR-2 Return (1) JA India GSTR-1 Return (1) JA India GSTR-2 Return JA India - RG1 Register Report(XML Publisher) JA India - RG23D Register Report(XML Publisher) JA India - Inward Stock Register Report(XML Publisher) JA India - Tax Liability Register Report(XML Publisher) JA India - Tax Register Report(XML Publisher) JA India - Tax Exemptions Report(XML Publisher)