using System;

public class Program

{

    public static void Main()

    {

        var dynamicSqlQuery = @"WAREHOUSEID,        

         Product_ID,        

          selling_unit,

         Description,

         Additional_Description,

         Status,

         Product_Status_Description,

        UNITOFMEASURE as UNIT_OF_MEASURE,

        OZPERCASE as OZ_PER_CASE,

        MLPERBTL as ML_Per_Bottle,

        FOREIGNDOMESTIC as Foreign_Dom,

        ALLOWREDELIVER AS Redelivery,

        BYPASSINVENTORY as BYPASS_INVENTORY ,

        COMMISSIONCATEGORY as Driver_COMMISSION_CATEGORY,

        COMMISSIONRATE as Sales_COMMISSION_RATE,

        COMMISSIONMULTIPLIER as Driver_COMMISSION_MULTIPLIER,

        I.TERRITORY as Sales_territory,

        T.Territory_name as Territory_Description,

        SUB,

        SUBDESCRIPTION AS Sub_description,

        CUBEVALUE as Load_or_Cube_Value,

        SALESTAXABLE as Taxable,

        TAXAMOUNT as TAX_AMOUNT,

        SAMPLESALLOWED as Eligible_For_Samples,

        RETAILUPC as RETAIL_UPC,

        CASEUPC as CASE_UPC,

        BOTTLEUPC as eaches_upc,

        SALESMANPOINTER as sales_pointer,

        UNITSPERCASE as Units_per_case,

        ALCOHOLPCT as ALCOHOL_PCT,

        I.SUPPLIER,

        S.SUPPLIER_NAME AS SUPPLIER_DESCRIPTION,

        WEIGHT as Unit_Weight,

        COOPERAGEGROUP as COOPERAGE_GROUP,

        SUBSTITUTE1 as SUBSTITUTE_Item_1,

        SUBSTITUTE2 as SUBSTITUTE_item_2,

        DRIVERSTATCATEGORY as DRIVER_STAT_CATEGORY,

        DRIVERDIFFFACTOR as DRIVER_stat_DIFFiculty_FACTOR,

        CIVILIANMILITARY as CIVILIAN_MILITARY,

        RECEIVINGCASESPERPALLET as CASES_PER_PALLET_RECEIVING,

        NARROWCASESPERPALLET as cases_per_narrow_pallet,

        WIDECASESPERPALLET as cases_per_wide_pallet,

        CASESPERCART as CASES_PER_CART,

        NARROWWIDEPALLET as pallet_type_NARROW_wide,

        LOADINGSIZE as LOADING_SIZE,

        L.DESCRIPTION AS LOADING_SIZE_DESCRIPTION,

        CRINCCODE as CRINC_CODE,

        RETURNCATEGORY as RETURN_CATEGORY,

        CASESPERTIER as CASES_PER_TIER,

        BASEITEM as eligible_as_base_item,

        ROUNDTONEXTTIER as ROUND_TO_NEXT_TIER,

        HANDLINGCHARGE as HANDLING_CHARGE,

        DEPOSITORIGIN as deposit_origin,

        CONTAINERTYPE as container_type,

        CONTAINERNAME AS CONTAINER_TYPE_DESCRIPTION,

        I.BRAND,

        BRAND_Name as brand_Description,

        PRODUCTTYPEPOINTER as product_type,

        PTYPE.Description as product_type_description,

        BOTTLEPRODUCTPOINTER as eaches_product_type,

        ETYPE.Description as eaches_product_type_description,

        SUPPLIERITEMCODE as Supplier_Product_code,

        SELLINGUNITSPERCASE as selling_units_per_case,

        PRODUCTCLASS as product_class,

        CLS.Description as product_class_description,

        BORNONOREXPIRATON as production_or_expiration_code_date,

        SHELFLIFEDAYS as shelf_life_days,

        PULLDAYS as warehouse_warning_days,

        CODEDATEFORMAT as code_date_format,

        SUPPLIERMULTIPLIER as supplier_multiplier,

        USERALPHAFIELD1 as product_user_field_1,

        U1.Description as user_alpha_1_description,

        USERALPHAFIELD2 as product_user_field_2,

        U2.Description as user_alpha_2_description,

        USERALPHAFIELD3 as product_user_field_3,

        U3.Description as user_alpha_3_description,

        USERALPHAFIELD4 as product_user_field_4,

        U4.Description as user_alpha_4_description,

        USERALPHAFIELD5 as product_user_field_5,

        U5.Description as user_alpha_5_description,

        USERDEFINEDFIELD1 as warehouse_user_field_1,

        USERDEFINEDFIELD2 as warehouse_user_field_2,

        USERDEFINEDFIELD3 as warehouse_user_field_3,

        USERNUMERICFIELD1 as numeric_user_field_1,

        USERNUMERICFIELD2 as numeric_user_field_2,

        RETAILWARNINGDAYS as RETAIL_WARNING_DAYS ,

        RETAILPROBLEMDAYS as retail_problem_days,

        SIZEDESCRIPTION as size_description,

        MOBILITYPACKAGECODE as mobility_package_code,

        MERCHCATEGORY as merchandiser_category,

        mc.Description as merchandiser_category_description,

        CASEGTIN as CASE_GTIN ,

        RETAILGTIN as retail_gtin,

        BOTTLEGTIN as eaches_gtin,

        CASEHEIGHT as case_height_inches,

        CASEWIDTH as case_width_inches,

        CASELENGTH as case_length_inches,

        PACKHEIGHT as retail_unit_height_inches,

        PACKWIDTH as retail_unit_width_inches,

        PACKLENGTH as retail_unit_length_inches,

        SHIPPINGCONTAINERCODE as shipping_container_code_scc,

        POSTOFFCASEBOTTLE as discount_case_eaches,

        WINECROSSREFERENCE as varietal_cross_reference,

        vcr.description as varietal_cross_reference_description,

        DRIVERSELLINVOICETYPE as driver_sell_invoice_type,

        BOTTLESSP as eaches_ssp,

        WINEPROOFCODE as proof_code,

        pc.description as proof_code_description,

        SUPPLIERSKU as supplier_sku,

        WAREHOUSEPOINTER as warehouse_pointer,

        BOTTLEWAREHOUSEPOINTER as warehouse_pointer_eaches,

        BOTTLELOCATION as warehouse_location_eaches,

        CASELOCATION as warehouse_location_cases,

        PALLETLOCATION as warehouse_location_pallet,

        TARGETDAYSSUPPLY as target_days_inventory,

        MINIMUMDAYSSUPPLY as minimum_days_supply,

        MAXIMUMDAYSSUPPLY as maximum_days_supply,

        PHYSICALCOUNTCYCLE as physical_count_cycle,

        RECEIPTTRIGGERSCOUNT as trigger_count_if_received,

        REPLENTRIGGERSCOUNT as trigger_count_if_replenished,

        LOADVARIANCETRIGGERSCOUNT as trigger_count_if_load_variance,

        PUTAWAYZONE as putaway_zone,

        MINQTYFORBASELAYER as minimum_qty_for_base,

        ITEMREQUIRESAUDIT as    item_requirs_audit,

        SEASONALITEM as seasonal,

        PROOFAMT as proof_amount,

        FSVPRODUCTGROUP as fsv_product_group,

        fsv.product_group_name as fsv_product_group_description,

        LEADTIME as lead_time ,

        TRANSFERINCREMENT as transfer_increment,

        RECEIVINGINCREMENT as receiving_increment,

        ORDERVENDOR as order_vendor,

        VINTAGE ,

        PRINTVINTAGE as print_vintage,

        UPCFORSCANNING as override_scan_option_voice_pick";

    }

}