JA India GSTR-1 Return

Description

Categories: BI Publisher
Columns: Third Party Reg Num, Isnum, Flag, Sply Ty, Isdt, Chksum, Ctin, Inum, Idt, Val ...

Application: Asia/Pacific Localizations
Source: India GSTR-1 Return Report
Short Name: JAIGSTR1
DB package: JAI_GST_EXTRACT_PKG

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'