ASCP Legacy Collections

Hi All,

Need help to understand the process of collecting data from Legacy through Flat file to ASCP.

We have an requirement to collect Sales Orders through flat file to ASCP. I conducted the following test , but it is not working

1) Pushed Sales Order data directly into msc_st_sales_order table using insert statement ,data details

inventory_item_id,

   organization_id,

    primary_uom_quantity,

    completed_quantity,

    requirement_date,

    sales_order_number,

    line_num,

    sr_instance_id,

    reservation_type,

    customer_id,

    demand_priority,

    request_date,

    selling_price,

    Demand_visible,

    forecast_visible,

    CTO_flag,

    deleted_flag,

    demand_source_type,

    ship_to_site_use_id