MSC_ATP_PEGGING_DETAILS
This Table Contains Pegging Details information from GOP payload.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_ATP_PEGGING_DETAILS_PK |
LINE_ID, UNIQUE_ORDER_NUMBER, FULFILLMENT_LINE_ID, OPTION_RANK |
Columns
| Name | Datatype | Length | Not-null | Comments | Status |
|---|---|---|---|---|---|
| LINE_ID | NUMBER | Yes | Unique ID,This column uniquely identifies record in this Table | ||
| FULFILLMENT_LINE_ID | VARCHAR2 | 32 | Yes | A string that represents the unique identifier for the fulfillment line | |
| UNIQUE_ORDER_NUMBER | VARCHAR2 | 32 | Yes | A string that indicates the unique order identifier for the request. | |
| OPTION_RANK | NUMBER | Yes | A number that represents the unique identifier for the fulfillment line availability option | ||
| AVAILABILITY_OPTION | VARCHAR2 | 32 | A value that represents a position in the chronological order of the availability options. | ||
| ITEM | VARCHAR2 | 100 | A string that represents the unique identifier of the item that is requested | ||
| AVAILABLE_ITEM | VARCHAR2 | 100 | A string that represents the unique identifier of the item that is available | ||
| QUANTITY | NUMBER | A number that indicates the quantity of the available item | |||
| QUANTITY_UOM | VARCHAR2 | 64 | A string that represents the unit of measure used for quantity | ||
| ATP_COST | NUMBER | A number that represents the cost associated with the available-to-promise inventory used for promising the fulfillment line | |||
| PEGGED_ATP_TYPE | VARCHAR2 | 10 | A string that represents the type of supply type used to promise the order. Valid values are ATP,PURCHASE,TRANSFER and MAKE | ||
| ATP_MODE | VARCHAR2 | 10 | A string that represents the mode of order promising used to promise the order. Valid values are infinite, lead-time and supply chain search | ||
| LEAD_TIME | NUMBER | A number that indicates the lead time in number of days | |||
| REQUIRED_QUANTITY | NUMBER | The number that indicates the quantity required for promising the fulfillment line | |||
| SOURCE_ORG | VARCHAR2 | 100 | Code for the organization that represents the source of supply. | Obsolete | |
| SUPPLIER_INFO | VARCHAR2 | 255 | Drop Ship Supplier Information storng concatenation of supplier and supplier site | Obsolete | |
| DESTINATION_ORG_INFO | VARCHAR2 | 100 | Code for the organization that represents the destination of supply, for transfer of supply | Obsolete | |
| BACK_TO_BACK_FLAG | NUMBER | Attribute that indicates whether the order is back to back enable or not | |||
| ORGANIZATION_ID | VARCHAR2 | 100 | Value that uniquely identifies the organization associated with the item. | ||
| SOURCE_ORG_ID | VARCHAR2 | 100 | Code for the organization that represents the source of supply. | ||
| SUPPLIER_ID | VARCHAR2 | 255 | Drop Ship Supplier Information of supplier | ||
| SUPPLIER_SITE_ID | VARCHAR2 | 255 | Drop Ship Supplier Information of supplier site | ||
| DROPSHIP_SUPPLIER | VARCHAR2 | 255 | Drop Ship Supplier Information of supplier | ||
| DROPSHIP_SUPPLIER_SITE | VARCHAR2 | 255 | Drop Ship Supplier Information of supplier site | ||
| DESTINATION_ORG_ID | VARCHAR2 | 100 | Code for the organization that represents the destination of supply, for transfer of supply | ||
| SHIP_DATE | DATE | The date on which the supply will be shipped from the supplier site or source organization | |||
| ARRIVAL_DATE | DATE | The date on which the purchased supply will be available at the destination organization. | |||
| REQUIRED_DATE | DATE | The date on which material is required | |||
| ALLOCATION_RULE | VARCHAR2 | 100 | A string that represents the identifier of the allocation rule applicable to the demand class associated with the order. | ||
| DEMAND_CLASS | VARCHAR2 | 100 | A string that represents the identifier of the demand class that the order is associated with. | ||
| PEGGING_DOC_ID | VARCHAR2 | 100 | A string that represents the pegging identifier. | ||
| ROUTING_CODE | VARCHAR2 | 64 | Code for the routing used in the capable to promise calculations for the fulfillment line request | ||
| BOM_CODE | VARCHAR2 | 64 | A string that represents the identifier of the bill of material used in the capable to promise calculations for the fulfillment line request | ||
| EXPECTED_MODE | VARCHAR2 | 64 | A string that indicates the suggested mode of transport mode for shipping material from the source inventory organization to destination inventory organization | ||
| EXPECTED_SERVICE | VARCHAR2 | 64 | A string identifier for the suggested service level used for shipping material from the source inventory organization to destination inventory organization | ||
| EXPECTED_CARRIER | VARCHAR2 | 64 | A string that identifies the suggested carrier from the source inventory organization to destination inventory organization. | ||
| SHIPPING_CALENDAR | VARCHAR2 | 255 | A string that represents the identifier of the suggested shipping calendar used for shipping material from supplier site to the inventory organization or the customer ship-to site | ||
| RECEIVING_CALENDAR | VARCHAR2 | 255 | A string that represents the identifier of the suggested receiving calendar used for receiving material at the inventory organization or customer ship-to site. | ||
| MANUFACTURING_CALENDAR | VARCHAR2 | 255 | A string that represents the identifier of the suggested manufacturing calendar used for manufacturing material at the inventory organization or customer ship-to site. | ||
| START_DATE | DATE | A date that indicates the expected manufacturing start date | |||
| END_DATE | DATE | The date and time attribute that indicates when the manufacturing ends for the item. | |||
| VARIABLE_LEAD_TIME | NUMBER | A number that represents the portion of manufacturing lead time that is dependent on order quantity | |||
| FIXED_LEAD_TIME | NUMBER | The number of days of manufacturing lead time that is independent of the order quantity | |||
| CONSUMPTION_DATE | DATE | A date identifier that indicates the date from which resource availability information needs to be returned | |||
| DEPT_ID | VARCHAR2 | 100 | A string that identifies the department to which a resource belongs | ||
| RESOURCE_ID | VARCHAR2 | 100 | A string that ifdentifies a manufacturing resource. | ||
| ALTERNATE_RESOURCE | VARCHAR2 | 10 | A value that indicates whether an alternate resources was considered or not | ||
| RESOURCE_CALENDAR | VARCHAR2 | 64 | Code of the resource used to determine the resource availability | ||
| PRE_PROCESSING_LEAD_TIME | NUMBER | A number that represents the number of days required to release a purchase order or create a job from the time the requirement is identified | |||
| POST_PROCESSING_LEAD_TIME | NUMBER | A number that represents the number of days required to make an item available in inventory from the time it received | |||
| PROCESSING_LEAD_TIME | NUMBER | A number that represents the number of days required to procure or manufacture an item | |||
| CARRIER_CALENDAR | VARCHAR2 | 64 | A string that identifies the suggested carrier calendar from the source inventory organization to destination the inventory organization | ||
| TRANSIT_LEAD_TIME | NUMBER | A number that indicates the number of days required for transporting the requested item from source organization to the destination organization | |||
| PARENT_LINE_ID | NUMBER | This column stores parent line identifier used in pegging. | |||
| RESERVED_ARRIVE_DATE | DATE | This column stores the supply dock date of ordered item with reservation after rescheduling. | |||
| RESERVED_JOB_END_DATE | DATE | This column stores the WIP job end date of ordered item with reservation after rescheduling. | |||
| ALLOCATION_NODE_ID | VARCHAR2 | 255 | This column stores the unique identifier of the allocation node. | ||
| REDEPLOYED_FLAG | VARCHAR2 | 1 | This column indicates whether promising can redeploy quantity from allocation node. | ||
| CONSUMED_ALLOCATION | NUMBER | This column stores quantity that promising consumed for the allocation. | |||
| ALLOC_CONSUMPTION_WEEK | DATE | This column stores the start of the week when promising consumed the allocation. | |||
| PICK_DATE | DATE | This column stores the date on which the shipment is expected to be picked at the pickup organization by the customer. | |||
| TIMEZONE_CODE | VARCHAR2 | 64 | This column stores the time zone code for the shipping or receiving partners. | ||
| CUSTOMER_NAME | VARCHAR2 | 360 | This column stores unique partner identifier for customer. | ||
| CUSTOMER_SITE_CODE | VARCHAR2 | 30 | This column stores unique identifier for customer site. | ||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | This column stores the description of the inventory item. | ||
| 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_ATP_PEGGING_DETAILS_N1 | Non Unique | Default | CREATION_DATE |
| MSC_ATP_PEGGING_DETAILS_N2 | Non Unique | Default | UNIQUE_ORDER_NUMBER, FULFILLMENT_LINE_ID, OPTION_RANK |
| MSC_ATP_PEGGING_DETAILS_U1 | Unique | Default | LINE_ID, UNIQUE_ORDER_NUMBER, FULFILLMENT_LINE_ID, OPTION_RANK |