ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 31BB3FFCE5C90AE3E06362FB090553AE with jai_party_reg as( select jprv.party_reg_id, jprlv.registration_number, jprv.party_name, jprv.operating_unit from jai_party_reg_lines_v jprlv, jai_party_regs_v jprv where 1=1 and jprlv.registration_number=:p_first_pty_reg_num and jprlv.party_reg_id=jprv.party_reg_id and jprv.party_type_code in ('IO','OU') and rownum=1) -- main query select jpr.registration_number "GSTIN", jpr.party_name registered_person, jpr.operating_unit, jgrtdt.period_name, jgrtdt.section_code, jgrtdt.rev_charge reverse_charge, jgrtdt.third_party_reg_num "GSTIN/UIN", jgrtdt.tax_invoice_number invoice_number, jgrtdt.tax_invoice_date invoice_date, jgrtdt.tax_invoice_value invoice_value, jgrtdt.tax_rate, jgrtdt.taxable_amt taxable_value, jgrtdt.igst, jgrtdt.cgst, jgrtdt.sgst, jgrtdt.cess cess_amount, jgrtdt.state, jgrtdt.shippable_bill_no "Shipping Bill/Bill of Export", jgrtdt.rev_inv_num, jgrtdt.flag, jgrtdt.supp_type supply_type, trunc(jgrtdt.rev_inv_date) rev_inv_date, jgrtdt.inv_check_sum_val, jgrtdt.ecom_operator, jgrtdt.inv_type, jgrtdt.trx_number, jgrtdt.trx_date, decode(jgrtdt.event_class_code,'CREDIT_MEMO','C','DEBIT_MEMO','D') event_class_code, jgrtdt.export_type, jgrtdt.nil_amount nil_rated_supplies_amt, jgrtdt.expt_amount exempted_amt, jgrtdt.ngsup_amount non_gst_supplies_amt, jgrtdt.adv_receipt_amt "Gross Advance Received/Adjusted", jgrtdt.hsn_code, jgrtdt.hsn_desc, jgrtdt.uom, jgrtdt.qty quantity, jgrtdt.attribute1 doc_issue, jgrtdt.attribute2 from_num, jgrtdt.attribute3 to_num, jgrtdt.attribute9 total_num, jgrtdt.attribute10 cancelled_num, jgrtdt.attribute11 net_issued from jai_party_reg jpr, jai_gst_rep_trx_detail_t jgrtdt where 2=2 and jpr.registration_number=jgrtdt.first_party_primary_reg_num Renamed columns as per the standard BIP report template. Fixed issue on duplicate records Y JA JAIGSTR1_XML JA JA インドGSTR-1申告レポート Imported from BI Publisher Description: インドGSTR-1申告レポート(XML形式) Application: Asia/Pacific Localizations Source: インドGSTR-1申告レポート(XML) Short Name: JAIGSTR1_XML DB package: JAI_GST_EXTRACT_PKG KO JA 인도 GSTR-1 환급 신고서 Imported from BI Publisher Description: XML 형식의 인도 GSTR-1 환급 신고서 Application: Asia/Pacific Localizations Source: 인도 GSTR-1 환급 신고서(XML) Short Name: JAIGSTR1_XML DB package: JAI_GST_EXTRACT_PKG US JA India GSTR-1 Return Imported from BI Publisher Description: India GSTR-1 Return Report in XML format Application: Asia/Pacific Localizations Source: India GSTR-1 Return Report(XML) Short Name: JAIGSTR1_XML DB package: JAI_GST_EXTRACT_PKG ZHS JA 印度 GSTR-1 报税单报表 (1) Imported from BI Publisher Description: 印度 GSTR-1 报税单报表（XML 格式） Application: 亚太地区本地化 Source: 印度 GSTR-1 报税单报表 (XML) Short Name: JAIGSTR1_XML DB package: JAI_GST_EXTRACT_PKG Enginatics R12 only 1=1 2=2 :p_first_pty_reg_num 1 10 :p_tax_regime LOV custom Y select regime_id id, regime_name value, null description from jai_regimes order by regime_code Y US Tax Regime Tax Regime 2 20 :p_first_pty_reg_num LOV custom Y select distinct reg_line.registration_number id, reg_line.registration_number value, null description from jai_party_regs_v reg,jai_party_reg_lines_v reg_line where reg.party_reg_id=reg_line.party_reg_id and reg.reg_class_code='FIRST_PARTY' and reg_line.regime_id=:$flex$.tax_regime order by reg_line.registration_number Y US Registration Number Registration Number 3 30 :p_period_name Char Y US Return Period(MONYYYY) Return Period 4 40 :p_gt_previous_year Number US Aggregate Turnover in Preceding year Gross Turn Over in Preceding Financial Year 5 50 :aggregate turnover-apr to jun Number US Aggregate Turnover April to June :$flex$.tax_regime Tax Regime Registration Number