VIEW: MSC.MSC_SALES_ORDER_INTERFACE#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, SR_INSTANCE_ID SR_INSTANCE_ID, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE, EARLIEST_SHIP_DATE EARLIEST_SHIP_DATE, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE, HEADER_ID HEADER_ID, LINE_ID LINE_ID, SHIP_METHOD SHIP_METHOD, ORG_ID ORG_ID, OPERATING_UNIT OPERATING_UNIT, DELIVERY_LEAD_TIME DELIVERY_LEAD_TIME, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, PLAN_ID PLAN_ID, DEMAND_ID DEMAND_ID, RETURN_STATUS RETURN_STATUS, FIRM_FLAG FIRM_FLAG, LINE_NUMBER LINE_NUMBER, ORIG_SCHEDULE_SHIP_DATE ORIG_SCHEDULE_SHIP_DATE, ORIG_SCHEDULE_ARRIVAL_DATE ORIG_SCHEDULE_ARRIVAL_DATE, ORIG_ORG_ID ORIG_ORG_ID, ORIG_SHIP_METHOD ORIG_SHIP_METHOD, ORIG_LEAD_TIME ORIG_LEAD_TIME, QUANTITY QUANTITY, SOURCE_TYPE SOURCE_TYPE, ORDER_NUMBER ORDER_NUMBER, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORIG_ITEM_ID ORIG_ITEM_ID from "MSC"."MSC_SALES_ORDER_INTERFACE"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE
, EARLIEST_SHIP_DATE EARLIEST_SHIP_DATE
, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE
, HEADER_ID HEADER_ID
, LINE_ID LINE_ID
, SHIP_METHOD SHIP_METHOD
, ORG_ID ORG_ID
, OPERATING_UNIT OPERATING_UNIT
, DELIVERY_LEAD_TIME DELIVERY_LEAD_TIME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, PLAN_ID PLAN_ID
, DEMAND_ID DEMAND_ID
, RETURN_STATUS RETURN_STATUS
, FIRM_FLAG FIRM_FLAG
, LINE_NUMBER LINE_NUMBER
, ORIG_SCHEDULE_SHIP_DATE ORIG_SCHEDULE_SHIP_DATE
, ORIG_SCHEDULE_ARRIVAL_DATE ORIG_SCHEDULE_ARRIVAL_DATE
, ORIG_ORG_ID ORIG_ORG_ID
, ORIG_SHIP_METHOD ORIG_SHIP_METHOD
, ORIG_LEAD_TIME ORIG_LEAD_TIME
, QUANTITY QUANTITY
, SOURCE_TYPE SOURCE_TYPE
, ORDER_NUMBER ORDER_NUMBER
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORIG_ITEM_ID ORIG_ITEM_ID
FROM "MSC"."MSC_SALES_ORDER_INTERFACE"