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
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
Download
Related Blitz Reports
JA India GSTR-2 Return JA India - RG1 Register Report(XML Publisher) JA India - Tax Exemptions 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)
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™