MSC_ATP_SUPPLY_AVAIL_DETAILS
This table is used to store output payload of quick availability and supply availability
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_ATP_SUPPLY_AVAIL_DETA_PK |
LINE_ID, UNIQUE_ORDER_NUMBER |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| LINE_ID | NUMBER | Yes | Unique ID,This column uniquely identifies record in this Table | |
| UNIQUE_ORDER_NUMBER | VARCHAR2 | 32 | Yes | A string that indicates the unique order identifier for the request. |
| EFFECTIVE_DATE | DATE | Date attribute to detemine the date from which resource/supply is effective | ||
| CONSUMED_QUANTITY | NUMBER | Number attribute to determine the quantity consumed on particular date | ||
| NET_QUANTITY | NUMBER | Number attribute to determine the net quantity available on particular date | ||
| SUPPLY_QUANTITY | NUMBER | Number attribute to determine the supply quantity on particular date | ||
| CUMULATIVE_QUANTITY | NUMBER | Number attribute to determine the cumulative quantity on particular date | ||
| SHELF_QUANTITY | NUMBER | Number attribute to determine the shelf quantity on particular date | ||
| AVAILABLE_QUANTITY | NUMBER | Number attribute to determine the available quantity on particular date | ||
| ITEM_ID | VARCHAR2 | 100 | Unique identifier for the item that is being requested for report. | |
| ORGANIZATION_ID | VARCHAR2 | 100 | Unique identifier for the organization that is being requested for report. | |
| SUPPLIER_ID | VARCHAR2 | 100 | Unique identifier for the dropship supplier that is being requested for report. | |
| SUPPLIER_SITE_ID | VARCHAR2 | 255 | Unique identifier for the dropship supplier site that is being requested for report. | |
| WORK_CENTER | VARCHAR2 | 100 | Attribute to determine work center of the resource | |
| WORK_AREA | VARCHAR2 | 100 | Attribute to determine the work area of the work center | |
| RESOURCE_NAME | VARCHAR2 | 100 | Unique attribute to determine the resource | |
| PARTY_ID | VARCHAR2 | 100 | The value of the party identifier representing the customer name | |
| PARTY_SITE_ID | 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. | |
| 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 | ||
| GET_AVAIL_FOR_SUBSTITUTE_ITEMS | VARCHAR2 | 10 | Attribute that determines whether availability of substitute items should be considered or not | |
| GET_AVAIL_FOR_DROPSHIP_SUPP | VARCHAR2 | 10 | Attribute that determines whether availability from dropship supplier should be considered or not | |
| 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. | |
| INTERNAL_SALES_ORDER_DEST_ORG | VARCHAR2 | 100 | Abbreviation that identifies the organization that represents the destination of supply for the transfer of supply. | |
| 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_SUPPLY_AVAIL_DETAIL_U1 | Unique | Default | LINE_ID, UNIQUE_ORDER_NUMBER |