MSC_BM_SET_HEADERS
This table has records of Set Headers for BM
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
MSC_BM_SET_HEADERS_PK |
SET_HEADER_NAME |
Columns
Name | Datatype | Length | Not-null | Comments |
---|---|---|---|---|
SET_HEADER_NAME | VARCHAR2 | 280 | Yes | This value indicates the records belongs to a set. Will hold combination of Order Number and Set Name |
SET_NAME | VARCHAR2 | 50 | Yes | Name of the lines that are part of a ship_set or arrival_set. |
SET_TYPE | NUMBER | Yes | For sales Order if type is Ship or Arrival | |
SALES_ORDER_NUMBER | VARCHAR2 | 240 | Yes | This value indicates the order number of a Sales Order. |
ORCH_ORDER_HEADER_ID | NUMBER | This value indicates Order orchestration header id for a set | ||
ORGANIZATION_ID | NUMBER | Field indicates identifier for organization | ||
DEMAND_ID | NUMBER | Field indicates identifier of Demand | ||
CUSTOMER_ID | NUMBER | Unique Partner identifier generated by the collection program | ||
CUSTOMER_SITE_ID | NUMBER | Customer site unique identifier | ||
SUPPLIER_ID | NUMBER | ship from supplier id in case of drop ship | ||
SUPPLIER_SITE_ID | NUMBER | Ship from supplier site id in case of drop ship | ||
REQUEST_DATE | DATE | Request date of the demand record. | ||
SCHEDULE_DATE | DATE | Schedule date of the demand record. | ||
ORDER_TYPE | VARCHAR2 | 4000 | Origination type of the demands being collected over. | |
DEMAND_SOURCE_TYPE | NUMBER | Forecast billing address identifier | ||
SOURCE_DOCUMENT_LINE_NUMBER | VARCHAR2 | 150 | Source side value of the document line, like PO/PR, that is linked to the set. | |
SOURCE_DOCUMENT_NUMBER | VARCHAR2 | 240 | Source side value of the document, like PO/PR, that is linked to the set. | |
ORDERED_DATE | DATE | This value indicates the ordered date on the set. | ||
ORDER_REVENUE | NUMBER | Field contains value of revenue for the set | ||
ORDER_MARGIN | NUMBER | Field contains value of margin for the set | ||
PROMISED_SHIP_DATE | DATE | Promised Ship Date of the set record. | ||
PROMISED_ARRIVAL_DATE | DATE | Promised Ship Date of the set record. | ||
SCHEDULED_SHIP_FROM_ORG_ID | NUMBER | Field indicates identifier for Scheduled Ship From organization | ||
SCHEDULE_ARRIVAL_DATE | DATE | Scheduled Arrival Date of the set record. | ||
SCHEDULE_SHIP_DATE | DATE | Scheduled Ship Date of the set record. | ||
RELEASE_STATUS | NUMBER | This value indicates the release error description. | ||
ORDER_DATE_TYPE_CODE | NUMBER | For sales Order if type is Ship or Arrival | ||
CARRIER_ID | NUMBER | Field indicates identifier for carrier | ||
MODE_OF_TRANSPORT | NUMBER | Field indicates value of mode of transport for bm demand | ||
SERVICE_LEVEL | NUMBER | Field contains value of service level of bm demand | ||
USING_ASSEMBLY_DEMAND_DATE | DATE | Using assembly demand date (due date) of the demand. | ||
ORDER_TYPE_CODE | NUMBER | For an Order if type is Ship or Arrival | ||
PROMISE_DATE | DATE | Promised Date of the set record. | ||
FULFILLMENT_COST | NUMBER | The estimated cost it will take to deliver a fulfillment line to a customer. The figure includes item cost as well as shipping cost. | ||
REQUESTED_ARRIVAL_DATE | DATE | Requested Arrival Date of the set record. | ||
REQUEST_SHIP_DATE | DATE | Requested Ship Date of the set record. | ||
SCHEDULED_DAYS_OF_DELAYS | NUMBER | Scheduled Days of Delays of the set | ||
DAYS_LATE | NUMBER | Number of days the demand is delayed by. | ||
DEMAND_LEAD_TIME_DATE | DATE | Field indicates the lead time date value calculated using ordered date and demand lead time | ||
REASON_CODE | NUMBER | Field indicates Reason Code for bm run demand | ||
DEMAND_PRIORITY | NUMBER | Field indicates priority of the demand | ||
ECC_FLAG | NUMBER | This column contains value of Enforce Current Commit Flag | ||
PULL_IN_FLAG | NUMBER | Field indicates flag whether pullin enabled | ||
MANUAL_OVERRIDE_FLAG | NUMBER | Field indicates status manual override flag | ||
SOURCE_ORGANIZATION_ID | NUMBER | Field indicates identifier for the source organization | ||
EXPECTED_SHIP_DATE | DATE | This column contains value of Planned Ship Date associated with the set | ||
EXPECTED_ARRIVAL_DATE | DATE | This column contains value of Planned Arrival Date associated with the set | ||
EXPECTED_SHIP_METHOD_ID | VARCHAR2 | 30 | This column contains value of Planned Shipping Method associated with the set | |
EXPECTED_CARRIER_ID | NUMBER | This column contains value of Planned Carrier associated with the set | ||
EXPECTED_SERVICE_LEVEL_ID | NUMBER | This column contains value of Planned Service Level associated with the set | ||
EXPECTED_MODE_OF_TRANSPORT_ID | NUMBER | This column contains value of Planned Mode of Transport associated with the set | ||
EXPECTED_SUPPLIER_ID | NUMBER | Field indicates identifier of expected supplier for bm run demand | ||
EXPECTED_SUPPLIER_SITE_ID | NUMBER | Field indicates identifier of expected supplier Site for bm run demand | ||
FIRM_SALES_ORDER | NUMBER | Indicates Locked Status associated with the set | ||
SCHEDULING_STATUS_CODE | NUMBER | Indicates whether the order is scheduled or unscheduled | ||
SCHEDULED_SUPPLIER_ID | NUMBER | Indicates Scheduled Supplier of the set | ||
SCHEDULED_SUPPLIER_SITE_ID | NUMBER | Indicates Scheduled Supplier Site of the set | ||
SALES_ORDER_HEADER_ID | VARCHAR2 | 50 | Indicates the Sales Order Header Id of the set | |
BM_RUN_ID | NUMBER | Field indicates unique identifier for a BM Run | ||
RELEASE_STATUS_ORIG | NUMBER | Indicates the Original Release Status of the Set | ||
OVERRIDE_PRIORITY | NUMBER | Field indicates overriden priority value for bm run demand | ||
INQUIRY_DEMAND | NUMBER | Field indicates if a demand is Simulation Demand or not | ||
DEMAND_FULFILLMENT_LEAD_TIME | NUMBER | Field indicates Fullfillment Lead Time of an order | ||
DEMAND_CLASS | VARCHAR2 | 34 | Field indicates demand class of an order | |
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
MSC_BM_SET_HEADERS_U1 | Unique | Default | SET_HEADER_NAME |