Need to derive hardware and software items lines. Not able to find software line in JAI_IRN_TABLE.
we are able to see only hardware item details..software item line is missing in the JAI_IRN_TABLE.
could you please help to find the right table to derive software and hardware items.
Developing GSTR1 Return Detail Report.
SELECT hsn_code, quantity, decode( uom, 'EA', 'PCS', '', 'PCS' ) uom, unit_price, cgst_rate, sgst_rate, igst_rate, cess_rate, state_cess_rate, cess_nonadv_amount, assessable_amount, cgst_amount, sgst_amount, igst_amount, cess_amount, state_cess_amount, state_cess_nonadvl_amt, nvl( other_charges, 0 ) othchrg, total_item_value, det_factor_id, discount FROM apps.jai_irn_details WHERE entity_code = ps_entity_code AND trx_id = pn_trx_id ORDER BY item_serial_number;