SELECT OAADK1 as ADDR_KEY,
OACONM as ADDR_DESC,
CASE WHEN OAADK1 like 'N/E%' THEN SUBSTRING(OAADK1,0,7)
WHEN OAADK1 like 'C/E%' THEN SUBSTRING(OAADK1,0,7)
WHEN OAADK1 like 'C/S%' THEN SUBSTRING(OAADK1,0,7)
WHEN OAADK1 like 'NE%' THEN 'N/E'+SUBSTRING(OAADK1,3,3)
WHEN OAADK1 like 'CE%' THEN 'C/E'+SUBSTRING(OAADK1,3,3)
WHEN OAADK1 like 'CS%' THEN 'C/S'+SUBSTRING(OAADK1,3,3)
WHEN OAADK1 like 'PC721%' THEN 'B501'
WHEN OAADK1 like 'PC722%' THEN 'B502'
WHEN OAADK1 like 'PC731%' THEN 'N501'
WHEN OAADK1 like 'PC732%' THEN 'N502'
WHEN OAADK1 like 'PC741%' THEN 'E501'
WHEN OAADK1 like 'PC742%' THEN 'E502'
WHEN OAADK1 like 'PC751%' THEN 'C501'
WHEN OAADK1 like 'PC752%' THEN 'C502'
WHEN OAADK1 like 'PC761%' THEN 'S501'
WHEN OAADK1 like 'PC762%' THEN 'S502'
WHEN OAADK1 like 'PC771%' THEN 'N/E501'
WHEN OAADK1 like 'PC772%' THEN 'N/E502'
ELSE SUBSTRING(OAADK1,0,5) END AS AREA,
case WHEN OACONM like N'%รับของเอง' THEN 'T04' ELSE 'T05' END AS ZTYPE,
OAPONO as ROUT,
OAADR3 as WH,
OARGDT as CREATE_DATE,
OALMDT as MODIFY_DATE
FROM MVXJDTA.CIADDR as ad
where ((OAADK1 like 'B2%') or (OAADK1 like 'N/E2%') or (OAADK1 like 'C/S2%')or (OAADK1 like 'N2%')or (OAADK1 like 'C/E2%')
or (OAADK1 like 'PC7%') or (OAADK1 like 'NE2%'))
and ((OAADR1 not like 'NO%') AND (OAADR1 not like N'เลิกพัก%'))
and OAADK1 not in('BE211','BE212','BE214','BE213','BE221','BE222','BE223','BE224','BE225','CT211','CT212','CT213','CT216','CT214','CT215','CT217','CT224','CT222','CT225','CT223','CT226','NH211','NH212','NH213','NH214','NH226','NH221','NH222','NH223','NH224','NH225','NE212','NE222','NE211','NE213','NE221','NE224','NE215','NE214','NE225','NE216','NE223','NE231','NE232','NE233','NE234','NE235','NE236','SH211','SH212','SH213','SH214','SH215','SH221','SH222','SH223','SH224','SH225','CT221','BE215','BE216','BE226','NS211','NS212','NS213','NS214','NS221','NS222','NS223','NS224','BE211-1','BE212-1','BE212-2','BE214-1','BE215-1','BE216-1','BE221-1','BE222-1','BE222-2','BE222-3','BE223-1','BE223-2','BE224-1','BE225-1','BE226-1','BE226-2','BE226-3','CT211-1','CT212-1','CT213-1','CT214-1','CT215-1','CT216-1','CT216-2','CT217-1','CT217-2','CT217-3','CT221-1','CT222-1','CT223-1','CT224-1','CT225-1','CT225-2','CT226-1','CT226-2','CT226-3','NS211-1','NS211-2','NS212-1','NS213-1','NS213-2','NS214-1','NS214-2','NS221-1','NS221-2','NS222-1','NS223-1','NS223-2','NS224-1','NS224-2','NH211-1','NH212-1','NH212-2','NH212-3','NH213-1','NH213-2','NH213-3','NH213-4','NH213-5','NH213-6','NH214-1','NH221-1','NH221-2','NH221-3','NH222-1','NH223-1','NH223-3','NH223-2','NH223-4','NH224-1','NH224-2','NH224-3','NH225-1','NH225-2','NH225-3','NH225-4','NH225-5','NH226-1','NH226-2','NH226-3','NH226-4','NH226-5','NE211-1','NE211-2','NE211-3','NE211-4','NE212-1','NE213-1','NE213-2','NE214-1','NE214-2','NE215-1','NE215-2','NE215-3','NE216-1','NE216-2','NE216-3','NE221-1','NE221-2','NE221-3','NE222-1','NE222-2','NE223-1','NE223-2','NE224-1','NE224-2','NE225-1','NE231-1','NE231-2','NE232-1','NE232-2','NE233-1','NE233-2','NE233-3','NE234-1','NE234-2','NE235-1','NE235-2','NE236-1','SH211-1','SH211-2','SH211-3','SH211-4','SH212-1','SH213-1','SH214-1','SH215-1','SH221-1','SH221-2','SH221-3','SH221-4','SH222-1','SH223-1','SH224-1','SH225-1','NS222-2','NS222-3','PC721-R','PC721-R1','PC721-R2','PC721-R3','PC722-11','PC722-R','PC722-01','PC731-03','PC731-04','PC731-05','PC731-06','PC731-12','PC731-13','PC731-14','PC731-15','PC731-17','PC731-18','PC731-20','PC731-21','PC731-22','PC731-23','PC731-24','PC731-25','PC731-26','PC731-R','PC731-R1','PC741-12','PC741-13','PC741-16','PC741-17','PC741-18','PC741-19','PC741-20','PC741-21','PC741-22','PC741-23','PC741-24','PC741-25','PC741-26','PC741-27','PC741-R','PC751-02','PC751-03','PC751-04','PC751-05','PC751-06','PC751-10','PC751-22','PC751-24','PC751-25','PC751-26','PC751-27','PC751-28','PC751-29','PC751-31','PC751-32','PC751-33','PC751-34','PC751-35','PC751-R','PC751-R1','PC761-05','PC761-06','PC761-15','PC761-R1','PC761-R','PC761-25','PC761-24','PC761-21','PC761-20','PC761-19','PC761-22','PC761-18','PC761-16','PC761-14','PC761-13','PC761-23','PC761-07','PC761-09','PC761-12','PC761-10','PC761-11','PC771-6','PC771-7','PC771-8','PC771-12','PC771-9','PC771-R1','PC771-R','PC771-21','PC771-5','PC771-4','PC771-3','PC771-18','PC771-17','PC771-16','PC771-15','PC771-14','PC771-13','PC771-11','PC771-10','PC771-2','PC771-20','PC771-29','PC771-28','PC771-27','PC771-26','PC771-25','PC771-24','PC771-23','PC771-22','PC771-1','PC791-R','EV791-R1','EV792-R2','EV793-R5','FT781-R5','PC722-R1','PC731-R2','PC741-R1','PC741-R2','PC751-R2','PC761-R2','PC771-30','PC771-31','PC771-R2','PC772-1','PC772-2','PC772-3','PC772-R','PC772-R1','PC772-R2','BE224-2','NE214-3','FT761-R1','FT761-R2','NE224-3','BE223-3','BE211-2','NE215-4','BE812-1','BE814-1','BE813-1','BE811-1')
order by OAADK1 asc
นำข้อมูลเข้า รายการ
อัพเดทเรียบร้อย
