Reports2017-11-18T12:27:27+00:00

JA India GSTR-1 Return (1)

Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
Source: India GSTR-1 Return Report(XML)
Short Name: JAIGSTR1_XML
DB package: JAI_GST_EXTRACT_PKG
 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 April to June
 
Number
Aggregate Turnover in Preceding year
 
Number
Return Period(MONYYYY)
 
Registration Number
 
LOV Oracle
Tax Regime
 
LOV Oracle
By continuing to use the site, you agree to the use of cookies. Accept