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
Source: India GSTR-1 Return Report
Short Name: JAIGSTR1
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 | |
---|---|---|---|
Tax Regime |
|
LOV Oracle | |
Registration Number |
|
LOV Oracle | |
Return Period(MONYYYY) |
|
Char | |
Aggregate Turnover April to June |
|
Number | |
Aggregate Turnover-Apr to Jun |
|
Number |