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 |