VCS_CSTMR_DMND_PUBLISH_INT
VCS_CSTMR_DMND_PUBLISH_INT tracks the Customer Demand Indentities that have been published into Demand Planning.
Details
-
Schema: FUSION
-
Object owner: VCS
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
VCS_CSTMR_DMND_PUBLISH_INT_PK |
DMND_PUBLISH_INT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DMND_PUBLISH_INT_ID | NUMBER | 18 | Yes | Primary key identifying a customer demand interface entry. | |
| SYNC_PROFILE_ID | NUMBER | 18 | Value that uniquely identifies the synchronization profile. | ||
| CUSTOMER_ID | NUMBER | 18 | Yes | Identifies the customer associated to the demand. | |
| CUSTOMER_NUMBER | VARCHAR2 | 360 | Yes | Identifies the customer number associated to the demand. | |
| CUSTOMER_NAME | VARCHAR2 | 360 | Yes | Identifies the customer name associated to the demand. | |
| CUSTOMER_SITE_ID | VARCHAR2 | 240 | Yes | Identifies the customer site associated to the demand. | |
| CUSTOMER_SITE_NUMBER | VARCHAR2 | 30 | Identifies the customer site number associated to the demand. | ||
| ITEM_LVL_ID | NUMBER | 18 | Identifies the item associated to the demand. | ||
| ITEM_LVL_CODE | VARCHAR2 | 30 | Indicates item level intended to be used for demand collaboration. | ||
| ITEM_LVL_VALUE | VARCHAR2 | 300 | Indicates item level value intended to be used for demand collaboration. | ||
| ORGANIZATION_LVL_ID | NUMBER | 18 | Yes | Identifies the organization associated to the demand. | |
| ORGANIZATION_LVL_CODE | VARCHAR2 | 30 | Abbreviation that indicates organization level intended to be used for the demand collaboration. | ||
| ORGANIZATION_LVL_VALUE | VARCHAR2 | 49 | Indicates organization level value intended to be used for the demand collaboration. | ||
| SCC_MEASURE_ID | NUMBER | 18 | Yes | Value that uniquely identifies the collaboration document measure. | |
| SCP_MEASURE_ID | NUMBER | 18 | Yes | Value that uniquely identifies the measure in supply chain planning. | |
| SCP_PLAN_ID | NUMBER | 18 | Value that uniquely identifies the plan in supply chain planning. | ||
| SCC_MEASURE_CODE | VARCHAR2 | 30 | Abbreviation that uniquely identifies the collaboration document measure. | ||
| SCC_DOCUMENT_ID | NUMBER | 18 | Yes | Value that uniquely identifies the collaboration document. | |
| DOCUMENT_TYPE_CODE | VARCHAR2 | 60 | Yes | Indicates document type code to be used for demand collaboration. | |
| LAST_RECEIVE_DATE | TIMESTAMP | The date this collaboration measure was last published the specified target. | |||
| RECEIVE_START_DATE | DATE | The collaboration measure START_DATE, when this collaboration measure was last published. | |||
| RECEIVE_END_DATE | DATE | The collaboration measure END_DATE, when this collaboration measure was last published. | |||
| REFRESH_NUMBER | NUMBER | 18 | The refresh number used when this data was collected. | ||
| PREV_REFRESH_NUMBER | NUMBER | 18 | The refresh number used the last time this combination was collected. | ||
| COLLECTION_PROCESS_ID | NUMBER | 18 | Identifies the subsequent process that collects the published data. | ||
| COLLECTION_STATUS_CODE | VARCHAR2 | 32 | Identifies the status of the subsequent process that collects the published data. | ||
| PREV_RECEIVE_DATE | DATE | The date this collaboration measure was previously published the specified target. | |||
| PREV_START_DATE | DATE | The collaboration measure START_DATE, when this collaboration measure was previously published. | |||
| PREV_EDIT_START_DATE | DATE | The collaboration measure EDIT_START_DATE, when this collaboration measure was previously published. | |||
| RECEIVE_EDIT_START_DATE | DATE | The collaboration measure EDIT_START_DATE, when this collaboration measure was last published. | |||
| LOCKED_FENCE_FLAG | VARCHAR2 | 1 | Yes | Indicates the collaboration measure locked fence setting when the collaboration measure was last received by supply planning. | |
| PREV_END_DATE | DATE | The collaboration measure END_DATE, when this collaboration measure was previously published. | |||
| PUBLISH_PROCESS_ID | NUMBER | 18 | Value that uniquely identifies the process used to publish the data. | ||
| PREV_PUBLISH_PROCESS_ID | NUMBER | 18 | Value that uniquely identifies the previous process used to publish the data. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| COLLABORATION_UOM_CODE | VARCHAR2 | 3 | Yes | The unit of measure code to be used during collaboration. | |
| SOURCE_SYSTEM | VARCHAR2 | 30 | The source system used for the product data model. If Oracle, item and organizations are defined in Oracle. If External, item and organizations are defined in Supply Chain Planning Cloud as an external planning source system. | ||
| IDENTITY_DELETED_DATE | TIMESTAMP | Indicates the date and time the document was deleted. | |||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Identifies the supply chain collaboration primary unit of measure for supply planning collaboration. This collaboration unit of measure is determined by the collaboration relationship. All collaboration order forecast quantities are stored in this unit of measure. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VCS_CSTMR_DMND_PUBLISH_INT_N2 | Non Unique | Default | CUSTOMER_ID, CUSTOMER_SITE_ID, ITEM_LVL_ID, ORGANIZATION_LVL_ID, DOCUMENT_TYPE_CODE |
| VCS_CSTMR_DMND_PUB_INT_N1 | Non Unique | Default | SCC_MEASURE_ID, DOCUMENT_TYPE_CODE, SCP_MEASURE_ID, REFRESH_NUMBER |
| VCS_CSTMR_DMND_PUB_INT_U1 | Unique | Default | DMND_PUBLISH_INT_ID |