MSC_ATP_FULFILLMENT_LINES
This table store input and output fullfillmentline payload data of GOP
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_ATP_FULFILLMENT_LINE_PK |
UNIQUE_ORDER_NUMBER, FULFILLMENT_LINE_ID, SPLIT_LINE_IDENTIFIER |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| UNIQUE_ORDER_NUMBER | VARCHAR2 | 32 | Yes | A string that indicates the unique order identifier for the request. |
| SET_LINE_FLAG | NUMBER | Flag to convey if the line is for SET. | ||
| MODEL_LINE_FLAG | NUMBER | Flag to convey if the line is for MODEL. | ||
| ROUND_TO_NEAREST | NUMBER | Enable or disable rounding of items to the nearest planning multiple. Valid values are true or false.. | ||
| OPTION_RANK | NUMBER | A number that represents the unique identifier for the fulfillment line availability option | ||
| OPTION_SUMMARY | VARCHAR2 | 255 | Short description about the availability option. | |
| INSTANCE_NUMBER | VARCHAR2 | 32 | A string identifier for the source system from which the order promising service request originated. | |
| INTERNAL_SUPPLY_IDENTIFIER | VARCHAR2 | 100 | A string identifying the supply document in case of internal material transfer. | |
| 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. | |
| PROMISING_STATUS | VARCHAR2 | 100 | Whether it meets the request completely (by the requested arrival date) or not. | |
| 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 | ||
| REQUESTED_QUANTITY_UOM | VARCHAR2 | 64 | The unit of measure associated with the item requested on the fulfillment line. | |
| UNIT_PRICE | NUMBER | This represents the per unit price that needs to be considered by order promising to calculate the margin information | ||
| REQUESTED_ORG_IDENTIFIER | VARCHAR2 | 100 | Indicates the desired organization from which the material needs to be shipped to the customer ship-to site | |
| 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. | |
| LATEST_ACCEPTABLE_DATE | DATE | A date beyond which the fulfillment line must not be promised | ||
| EARLIEST_ACCEPTABLE_DATE | DATE | A date attribute that indicates the date before which the fulfillment line must not be promised | ||
| SPLIT_ALLOWED | NUMBER | A value flag that determines whether splits of the fulfillment line are allowed or not | ||
| SUBSTITUTIONS_ALLOWED | NUMBER | A value flag that indicates whether the fulfillment line can be split based on supply availability dates in the case of order delays. | ||
| 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 | |
| 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 | |
| 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. | |
| 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. | ||
| DEMAND_CLASS | VARCHAR2 | 100 | A string that represents the identifier of the demand class that the order is associated with. | |
| IGNORE_RESERVATION_FLAG | NUMBER | Attribute that indicates whether the existing reservations can be ignored or not during rescheduling | ||
| 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 | ||
| INCLUDED_ITEMS_FLAG | NUMBER | Used in case of ModelType=PTO-SMC/PTO-NSMC. Specifies whether the included items for PTO model are specified on the request (value: true), or need to be derived internally (value: false). Default value: true, applicable to orders coming from DOO and EBS | ||
| GENERATE_PEGGING | NUMBER | Contains one of the following values: Yes or No. If Yes, then the pegging information needs to be sent by Oracle Global Order Promising Cloud as a response to the request. If No, then pegging information doesn't need to be sent by Oracle Global Order Promising Cloud in addition to the promise information, which is always sent. The default value is No. | ||
| NUMBER_OF_ALT_OPTIONS | NUMBER | A number that indicates the total number of availability options generated for the fulfillment line service request | ||
| MIN_PROMISE_QUANTITY | NUMBER | Minimum availability required to create a promise. | ||
| MIN_PROMISE_PERCENTAGE | NUMBER | Minimum availability required to create a promise. If both MinPromiseQuantity and MinPromisePercentage are specified, calculate minimum promise quantity based on both criteria; the higher value becomes the constraint.If FillKillFlag=true, this is the min quantity that needs to be available on the RequestedDate. This is also associated with fillkill. Not used in V1 | ||
| GENERATE_ALT_AVAILABILITY | VARCHAR2 | 10 | Attribute that indicates whether alternate options should be generated or not | |
| AVAILABILITY_BASIS | VARCHAR2 | 32 | String to determine the basis of availability required picking ship method | |
| SHIPPING_PREFERENCE | VARCHAR2 | 32 | Value that indicates that Oracle Global Order Promising Cloud must consider the fastest or lowest cost shipping option from the source organization to customer. Valid values are FASTEST or LOWESTCOST. | |
| DELIVERY_COST | NUMBER | Attribute to determine delivery cost mentioned in fulfillment line | ||
| DELIVERY_LEAD_TIME | NUMBER | Attribute to determine delivery lead time mentioned in fulfillment line | ||
| PLANNING_MULTIPLE | NUMBER | Attribute to round off the result to nearest number | ||
| REQUESTED_CARRIER | VARCHAR2 | 64 | A string value to determine the carrier passed in fulfillment line | |
| REQUESTED_MODE | VARCHAR2 | 64 | A string value to determine transport mode passed in fulfillment line | |
| REQUESTED_SERVICE | VARCHAR2 | 64 | A string to determine service value passed in fulfillment line | |
| 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_ARRIVAL_DATE | DATE | The date on which the fulfillment line is expected to be available at the customer ship-to site | ||
| ERROR_CODE | VARCHAR2 | 10 | A string that indicates the error code returned by Oracle Fusion Global Order Promising for the fulfillment line availability request. | |
| ERROR_MESSAGE | VARCHAR2 | 255 | ErrorMessages of corresponding ErrorCode. | |
| 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. | ||
| 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. | ||
| 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 | ||
| SHIP_DATE | DATE | The date on which the requested item line is actually shipped from the ship-from organization to the customer ship-to site | ||
| ARRIVAL_DATE | DATE | The date on which the fulfillment line is actually available at the customer ship-to site | ||
| PICK_DATE | VARCHAR2 | 20 | The date on which the shipment is actually 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 to determine class of customer | |
| SHIP_QTY | NUMBER | A number that represents the shipment quantity of the item | ||
| RESERVED_QTY | NUMBER | Quantity of the fulfillment line that has been reserved in the fulfillment system | ||
| RESERVATION_DATE | DATE | The date when the reservation between supply and the demand line is created | ||
| GET_AVAIL_FOR_SUBSTITUTE_ITEMS | VARCHAR2 | 10 | Attribute that determines whether availability of substitute items should be considered or not | |
| UPDATE_TIME | DATE | A date and time that represents when the result was updated. | ||
| 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_FULFILLMENT_LINE_U1 | Unique | Default | UNIQUE_ORDER_NUMBER, FULFILLMENT_LINE_ID, SPLIT_LINE_IDENTIFIER |