SELECT docid, soptype,
CASE
WHEN soptype = 1 THEN null
WHEN soptype = 2 THEN SOPALLOW_1
WHEN soptype = 3 THEN null
WHEN soptype = 4 THEN null
WHEN soptype = 5 THEN null
END AS Allow_Invoicing_of_Unfulfilled,
CASE
WHEN soptype = 1 THEN SOPALLOW_1
WHEN soptype = 2 THEN SOPALLOW_2
WHEN soptype = 3 THEN SOPALLOW_1
WHEN soptype = 4 THEN SOPALLOW_1
WHEN soptype = 5 THEN SOPALLOW_1
END AS Delete_Documents,
CASE
WHEN soptype = 1 THEN SOPALLOW_2
WHEN soptype = 2 THEN SOPALLOW_3
WHEN soptype = 3 THEN SOPALLOW_2
WHEN soptype = 4 THEN SOPALLOW_2
WHEN soptype = 5 THEN SOPALLOW_2
END AS Edit_Printed_Documents,
CASE
WHEN soptype = 1 THEN SOPALLOW_3
WHEN soptype = 2 THEN SOPALLOW_4
WHEN soptype = 3 THEN SOPALLOW_3
WHEN soptype = 4 THEN SOPALLOW_3
WHEN soptype = 5 THEN SOPALLOW_3
END AS Override_Document_Numbers,
CASE
WHEN soptype = 1 THEN SOPALLOW_4
WHEN soptype = 2 THEN SOPALLOW_5
WHEN soptype = 3 THEN SOPALLOW_4
WHEN soptype = 4 THEN SOPALLOW_5
WHEN soptype = 5 THEN SOPALLOW_4
END AS Void_Documents,
CASE
WHEN soptype = 1 THEN null
WHEN soptype = 2 THEN null
WHEN soptype = 3 THEN null
WHEN soptype = 4 THEN SOPALLOW_4
WHEN soptype = 5 THEN null
END AS Override_Item_Unit_Cost
FROM sop40200
ORDER BY 2,1