Link Inventory Export Query

Link Inventory Export Query

SELECT
store.full_name AS "Store",
inv.link_type AS "Link Type",
item_group.full_name AS "Item Group",
item.full_name AS "Item",
dr_coa.full_name AS "Dr Chart Of Account",
dr_sub_led.full_name AS "DR Subledger",
dr_cc.cost_center_name AS "Cost Center DR",
cr_coa.full_name AS "CR Chart Of Account",
cr_sub_led.full_name AS "CR Subledger",
cr_cc.cost_center_name AS "Cost Center CR"

FROM ac.tbl_link_inventory AS inv
LEFT JOIN inv.tbl_store_item_group AS item_group ON inv.store_item_group_id = item_group.id
LEFT JOIN app.tbl_cost_center AS dr_cc ON inv.pur_cc_id = dr_cc.id
LEFT JOIN app.tbl_cost_center AS cr_cc ON inv.con_cc_id = cr_cc.id
LEFT JOIN ac.tbl_chart_of_account AS dr_coa ON inv.pur_account_id = dr_coa.id
LEFT JOIN ac.tbl_sub_ledger AS dr_sub_led ON inv.pur_sl_id = dr_sub_led.id
LEFT JOIN ac.tbl_chart_of_account AS cr_coa ON inv.con_account_id = cr_coa.id
LEFT JOIN ac.tbl_sub_ledger AS cr_sub_led ON inv.pur_sl_id = cr_sub_led.id
LEFT JOIN inv.tbl_store AS store ON inv. store_id = store.id
LEFT JOIN inv.tbl_item AS item ON inv.item_id = item.id
WHERE inv.is_active = TRUE AND inv.is_deleted = FALSE;