MSC_ATP_ALT_AVAIL_OPTIONS
This Table stores Alternate Availability payload data from GOP response
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_ATP_ALT_OPTION_PK |
UNIQUE_ORDER_NUMBER, FULFILLMENT_LINE_ID, SPLIT_LINE_IDENTIFIER, OPTION_RANK |
Columns
| Name | Datatype | Length | Not-null | Comments | Status |
|---|---|---|---|---|---|
| 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 | ||
| OPTION_SUMMARY | VARCHAR2 | 64 | A string that that indicates how the current set availability option is different from the default availability option | ||
| INSTANCE_NUMBER | VARCHAR2 | 64 | A string identifier for the source system from which the order promising service request originated. | ||
| INTERNAL_SUPPLY_IDENTIFIER | VARCHAR2 | 100 | Response attribute that indicates the source document number for the internal order fulfillment line request | ||
| INTERNAL_ORDER_TYPE | VARCHAR2 | 32 | Contains one of the following TO, ISO and SO. Response attribute that indicates the type of internal order. | ||
| FULFILLMENT_LINE_ID | VARCHAR2 | 32 | Yes | A string that represents the unique identifier for the fulfillment line | |
| PARENT_FULFILL_IDENTIFIER | VARCHAR2 | 32 | A string that indicates the immediate parent of the fulfillment line. This is applicable only for configured to order items | ||
| SALES_ORDER_NUMBER | VARCHAR2 | 64 | A string unique identifier for the sales order for which the fulfillment line is created | ||
| SPLIT_LINE_IDENTIFIER | VARCHAR2 | 64 | Yes | A string that uniquely identifies the fulfillment line split. A unique number is generated in case of split. | |
| PARENT_SPLIT_LINE_IDENTIFIER | VARCHAR2 | 64 | Response attribute that indicates the immediate parent of the fulfillment line. This is applicable only for configured to order items | ||
| CONFIG_ITEM | VARCHAR2 | 100 | A string that identifies the unique configuration item corresponding the configuration sent for promising. This is applicable only in the case of assemble to order demands only. | ||
| REQUESTED_DATE | DATE | The date on which the material is requested to be available. Depending on the request type this represents the requested ship date or request arrival date | |||
| REQUESTED_ITEM | VARCHAR2 | 100 | Unique identifier for the item that is being requested. | ||
| REQUESTED_QUANTITY | NUMBER | The quantity of the item requested on the fulfillment line | Obsolete | ||
| UNIT_PRICE | NUMBER | This represents the per unit price that needs to be considered by order promising to calculate the margin information | Obsolete | ||
| REQUESTED_ORG_IDENTIFIER | VARCHAR2 | 100 | Indicates the desired organization from which the material needs to be shipped to the customer ship-to site | Obsolete | |
| REQUESTED_TYPE | VARCHAR2 | 32 | Indicates whether the request is of arrival date or ship date type. Depending on the request type, the requested date represents the requested ship date and requested arrival date respectively. | Obsolete | |
| LATEST_ACCEPTABLE_DATE | DATE | A date beyond which the fulfillment line must not be promised | Obsolete | ||
| EARLIEST_ACCEPTABLE_DATE | DATE | A date attribute that indicates the date before which the fulfillment line must not be promised | Obsolete | ||
| SPLIT_ALLOWED | NUMBER | An attribute that determines whether splits of the fulfillment line are allowed or not | Obsolete | ||
| SUBSTITUTION_ALLOWED | NUMBER | An attribute that indicates whether the fulfillment line can be split based on supply availability dates in the case of order delays. | Obsolete | ||
| PARTY | VARCHAR2 | 100 | The value of the party identifier representing the customer name | ||
| PARTY_SITE | VARCHAR2 | 255 | The value of the party site identifier corresponding to the customer ship-to site. | ||
| REGION | VARCHAR2 | 100 | Unique identifier for the region from which material is to be shipped to the customer ship-to site. | Obsolete | |
| DESTINATION_ORG | VARCHAR2 | 100 | Code for the organization that represents the destination of supply, for transfer of supply | ||
| DROPSHIP_SUPPLIER | VARCHAR2 | 100 | Unique identifier for the drop supplier from which material is to be shipped to the customer ship-to site | Obsolete | |
| DROPSHIP_SUPPLIER_SITE | VARCHAR2 | 255 | Unique identifier for the drop supplier site from which material is to be shipped to the customer ship-to site. This indicates the drop ship supplier location from where material is shipped to the customer ship-to site. | Obsolete | |
| PROMISING_STATUS | VARCHAR2 | 100 | Whether it meets the request completely (by the requested arrival date) or not. | ||
| PROMISING_TYPE | VARCHAR2 | 32 | A string that indicates the type of promise. This can be either ship date or arrival date based promising | ||
| PRIORITY | NUMBER | A number that indicates the relative priority of the fulfillment line when multiple fulfillment lines are sent for promising. | Obsolete | ||
| DEMAND_CLASS | VARCHAR2 | 100 | A string that represents the identifier of the demand class that the order is associated with. | Obsolete | |
| IGNORE_RESERVATION_FLAG | NUMBER | Attribute that indicates whether the existing reservations can be ignored or not during rescheduling | Obsolete | ||
| IGNORE_DATE_RESERVATION_FLAG | NUMBER | Attribute that indicates whether the reserved supply dates can be rescheduled or not. This attribute is applicable only for drop ship requests | Obsolete | ||
| NUMBER_OF_ALT_OPTIONS | NUMBER | A number that indicates the total number of availability options generated for the fulfillment line service request. | Obsolete | ||
| TOTAL_PRICE | NUMBER | A number that indicates the total price for the fulfillment line availability option | |||
| PRICE | NUMBER | A number that indicates the per unit price associated with the availability option | |||
| TOTAL_PROFIT | NUMBER | A number that indicates the total profit for the fulfillment line availability option | |||
| PROFIT | NUMBER | The projected profit generated by this split line item | |||
| TOTAL_MARGIN | NUMBER | A number that indicates the total margin for the fulfillment line availability option | |||
| TOTAL_VALUE | NUMBER | A number that indicates the total value for the fulfillment line availability option | |||
| VALUE | NUMBER | A number that indicates the value associated with the fulfillment line availability response | |||
| NUMBER_OF_SPLITS | NUMBER | A number to indicate the number of split lines generated for the fulfillment line | |||
| NUMBER_OF_SUBSTITUTIONS | NUMBER | A number to indicate the number of end item substitutions generated for the fulfillment line | |||
| FILL_RATE | NUMBER | Fill rate represents the percentage of quantity that can be promised on the requested date | |||
| NUMBER_OF_ATP_ITEMS | NUMBER | A number to indicate the number of items for which available to promise inventory was used in the availability option | |||
| NUMBER_OF_CTP_ITEMS | NUMBER | A number to indicate the number of items for which capable to promise supplies was used in the availability option | |||
| SOURCING_RULE | VARCHAR2 | 100 | A string unique identifier for the sourcing rule used | ||
| EXPECTED_GROUP_SHIP_DATE | DATE | A date attribute that indicates the date on which the set of fulfillment lines are expected to be shipped together from the shipping organization | Obsolete | ||
| EXPECTED_GROUP_ARRIVAL_DATE | DATE | A date attribute that indicates the date on which the set of fulfillment lines are expected to arrive at the customer ship-to site | Obsolete | ||
| EXPECTED_ARRIVAL_DATE | DATE | The date on which the fulfillment line is expected to be available at the customer ship-to site | |||
| EXPECTED_SHIP_DATE | DATE | The date on which the requested item line is expected to be shipped from the ship-from organization to the customer ship-to site | |||
| EXPECTED_PICK_DATE | DATE | The date on which the shipment is expected to be picked at the pickup organization by the customer | |||
| EXPECTED_AVAILABLE_ITEM | VARCHAR2 | 100 | A string identifier for the item that is expected to be used for satisfying the customer demand. This can be either the requested item or substitute of the requested item | ||
| EXPECTED_AVAIL_ON_REQ_DATE | NUMBER | A number that indicates the available to promise inventory quantity on the requested date | |||
| EXPECTED_AVAILABLE_QUANTITY | NUMBER | A number that indicates the quantity of the material that can be promised on the expected shipment date. In the case of splits, this quantity can be less than the requested quantity | |||
| EXPECTED_AVAILABLE_QTY_UOM | VARCHAR2 | 64 | A string that indicates the identifier of the unit of measure used to represent the available quantity. | ||
| EXPECTED_SUPPLIER_SOURCE | VARCHAR2 | 32 | A string identifier to the source system to which the drop ship supplier and supplier belong to | ||
| EXPECTED_DROPSHIP_SUPPLIER | VARCHAR2 | 100 | A string identifier for the suggested drop supplier | ||
| EXPECTED_DROPSHIP_SUPLIER_SITE | VARCHAR2 | 255 | A string identifier for the suggested drop supplier site. This indicates the drop ship supplier location from where material is shipped to the customer ship-to site | ||
| EXPECTED_MODE | VARCHAR2 | 64 | A string that identifies the suggested transport mode from the source inventory organization to destination inventory organization. | ||
| EXPECTED_SERVICE | VARCHAR2 | 64 | A string that represents the expected service level used for shipping from the ship-from organization to the customer ship-to site for the fulfillment line availability option. | ||
| EXPECTED_CARRIER | VARCHAR2 | 64 | A string that represents the identifier of the suggested carrier from the ship-from organization to the customer ship-to site | ||
| EXPECTED_MARGIN | NUMBER | A number that indicates the expected margin for the fulfillment line availability option. Margin is calculated as the difference between the revenue and fulfillment cost associated with the availability option. | |||
| EXPECTED_DEMAND_CLASS | VARCHAR2 | 100 | A string that represents the identifier of the demand class that the order is associated with. | ||
| EXPECTED_TOTAL_FULFILMENT_COST | NUMBER | A number that represents the total expected cost associated with the fulfillment line availability option | |||
| EXPECTED_SHIPPING_COST | NUMBER | A number that represents the expected shipping cost associated with the fulfillment line availability option | |||
| LINE_FILL_RATE | NUMBER | A number that represents the percentage of quantity that can be promised by the requested date | |||
| EXPECTED_SHIP_FROM_ORG | VARCHAR2 | 100 | A string that represents the expected shipping organization to the customer ship-to site for the fulfillment line availability option | ||
| CARRIER_CALENDAR | VARCHAR2 | 64 | A string that indicates the suggested carrier calendar from the ship-from organization to the customer ship-to site | ||
| DESTINATION_RECEIVING_CALENDAR | VARCHAR2 | 64 | A string that represents the receiving calendar for the customer or destination organization in case in internal order | ||
| CUSTOMER_CLASS | VARCHAR2 | 64 | A string that indicates class of the customer | Obsolete | |
| SHIP_QTY | NUMBER | A number that represents the shipment quantity of the item | Obsolete | ||
| RESERVED_QTY | NUMBER | Quantity of the fulfillment line that has been reserved in the fulfillment system | Obsolete | ||
| RESERVATION_DATE | DATE | The date when the reservation between supply and the demand line is created | Obsolete | ||
| GET_AVAIL_FOR_SUBSTITUTE_ITEMS | VARCHAR2 | 10 | Attribute that determines whether availability of substitute items should be considered or not | Obsolete | |
| UPDATE_TIME | NUMBER | A date and time that represents when the result was updated. | Obsolete | ||
| 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_ALT_OPTIONS_U1 | Unique | Default | UNIQUE_ORDER_NUMBER, FULFILLMENT_LINE_ID, SPLIT_LINE_IDENTIFIER, OPTION_RANK |