Use the look-up table to build the logic for flag_usage, flag_receipt and flag_shipment fields

Introduction: In inventory movement, the terms flag usage, flag receipt, and flag shipment are indicators or markers used to classify and track the status or type of specific inventory transactions. These flags are used to help systems and stakeholders monitor and manage inventory more efficiently.

 

Requirement: Develop SQL logic for deriving the flag fields flag_usage, flag_receipt, and flag_shipment in the f_inv_movmnt table. The mappings for these flags are provided in the movement_conditionstable of movement_cdcolumn joins with logic of dwart column from “psek_1” table. The SQL logic should populate the flag_usage, flag_receipt, and flag_shipment fields in f_inv_movmnt based on logic by looking up the corresponding values from the “inv_lkup” in the attached excel sheet.

 

Source table: psek_1, movement_controls

 

Target table: f_inv_movmnt

 

Output: Display the Results with all columns.