magritton
6/9/2014 - 1:22 PM

SQL North American sales filter for SQL fact table

SQL North American sales filter for SQL fact table

SQL NA sales filter
content_copyfile_download
AND fbc.COMPANY_CODE LIKE '2%'
AND fbc.SALES_REGION <> 'LATIN AMERICA-L BARRIGA'
AND fbc.SALES_REGION <> 'ASIA PACIFIC-RICHARD CHEN'
AND fbc.SHIP_TO_COUNTRY <> 'PL'
AND fbc.COMPANY_CODE <> '210'
AND fbc.COMPANY_CODE <> '220'
AND fbc.COMPANY_CODE <> '230'
AND fbc.COMPANY_CODE <> '280'
AND fbc.DOVER_COMPANY = 'N'
AND (fbc.SHIP_TO_COUNTRY = 'CA' OR fbc.SHIP_TO_COUNTRY = 'US')
AND fbc.ITEM_FAMILY <> 'CLEANENERGY FUELING PRODUCTS'