JA India GSTR-2 Return
Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
Source: India GSTR-2 Return Report
Short Name: JAIGSTR2
DB package: JAI_GSTR2_EXTRACT_PKG
Source: India GSTR-2 Return Report
Short Name: JAIGSTR2
DB package: JAI_GSTR2_EXTRACT_PKG
select THIRD_PARTY_REG_NUM ctin, TAX_INVOICE_NUMBER boenum, to_char(TAX_INVOICE_DATE) boedt, -- TAX_INVOICE_VALUE, TAX_RATE rate, TAXABLE_AMT taxval, IGST igst, CESS cess, SGST sgst, CGST cgst, STATE pos, 'A' flag, INELIG_ITC_FLAG elig, ITC_IGST itc_igst, ITC_CESS itc_cess, ITC_CGST itc_cgst, ITC_SGST itc_sgst, INV_CHECK_SUM_VAL chksum, rownum num, REV_GSTIN revctin, REV_INV_NUM revinum, REV_INV_DATE revidt, REV_INV_VAL revinvval, NOTE_TYPE ntty, P_GST p_gst, RSN rsn, ATTRIBUTE1 from JAI_GST_REP_TRX_DETAIL_T where SECTION_CODE='CDN' and ATTRIBUTE12='GSTR2' |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Tax Regime |
|
LOV Oracle | |
Registration Number |
|
LOV Oracle | |
Return Period(MONYYYY) |
|
Char |