VCS_COLLAB_ENT_HIST
Identifies historical entries used for item collaboration.
Details
-
Schema: FUSION
-
Object owner: VCS
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
VCS_COLLAB_ENT_HIST_PK |
ENTRY_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
ENTRY_ID | NUMBER | 18 | Yes | Primary key indentifying a collaboration entry | Active | |
PUBLISHED_ON_HAND_QTY | NUMBER | The on-hand quantity published with the collaboration order forecast stored in the collaboration unit of measure (PRIMARY_UOM_CODE). | ||||
ORCH_CORRELATION_CODE | VARCHAR2 | 64 | Correlation code to keep track orchestration process instance | |||
ENTRY_TYPE_ID | NUMBER | 18 | Identifies the type of collaboration. | Active | ||
SHIP_FROM_ID | NUMBER | 18 | Yes | Identifies the participant where the goods will be shipped from | Active | |
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | ID of the inventory item to be used in collaboration | Active | |
INVENTORY_ITEM_ORG_ID | NUMBER | 18 | Yes | Org ID of the item to be used in collaboration process | ||
SHIP_TO_ID | NUMBER | 18 | Yes | Identifies the participant where the goods will be shipped to | Active | |
COLLAB_SOURCE_ID | NUMBER | 18 | Yes | ID of a collaboration source that this collaboration entry belongs to | Active | |
FORECAST_HORIZON_END_DATE | DATE | Identifies the date in the future we will be providing forecast data | ||||
TIME_LEVEL | VARCHAR2 | 32 | Identifies the granularity of the data being sent/displayed for the supplier. Could be day, week, month. | |||
SLA_DAYS | NUMBER | 18 | Identifies in days how long we should wait for a participant to respond | |||
COMMIT_HORIZON_END_DATE | DATE | Identifies the date in the future we have to look for commits | ||||
COLLAB_ENTRY_VERSION | NUMBER | 9 | Identifies the version of the collaboration entry based on number of times it's been included in collaboration | |||
SLA_PAST_DUE_ACTION_CODE | VARCHAR2 | 32 | Captures the past due action for SLA. Valid values are null or AUTO_COMMIT. | |||
AUTO_COMMIT_PERIOD_CODE | VARCHAR2 | 32 | The period of time for which commits will be provided. Valid values are COMMIT_HORIZON or DAYS. | |||
AUTO_COMMIT_PERIOD_FACTOR | NUMBER | 9 | If AUTO_COMMIT_PERIOD_CODE is not a predefined measurement, this field will capture the time range of schedule details to be committed. | |||
COMMIT_QUANTITY_PREF_CODE | VARCHAR2 | 32 | How the commit quantity will be determined: Percentage of Forecast or Previous Forecast Commit | |||
COMMIT_PERCENT_FACTOR | NUMBER | Whole number percentage of forecast qty value, populated if Previous Forecast Commit is the preference identified in COMMIT_QUANTITY_PREF. | ||||
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. | Active | |
STATUS_CODE | VARCHAR2 | 32 | Yes | Identifies the current state of the collaboration entry | Active | |
PUBLISHED_DATE | TIMESTAMP | The most recent date forecast information was published. | ||||
MAX_FORECAST_VERSION | NUMBER | 9 | Identifies the number of mid-cycle forecast updates performed on this collaboration entry. | |||
COMMIT_DATE | TIMESTAMP | The most recent date commit information was published. | ||||
COMMIT_DUE_DATE | TIMESTAMP | The latest commit due date for all the planning schedule details attached to the collaboration entry. | ||||
DETAIL_LAST_UPDATE_ENT | TIMESTAMP | Schedule Details enterprise last edit - last time any schedule details for an entry was updated by the enterprise user. | ||||
DETAIL_LAST_UPDATE_SUP | TIMESTAMP | Schedule Details supplier last edit - last time any schedule details for an entry was updated by the supplier user. | ||||
DETAIL_LAST_UPDATE_FRCST_ENT | TIMESTAMP | Schedule Details enterprise last edit - last time any forecast details for an entry was updated by the enterprise user. | ||||
DETAIL_LAST_UPDATE_FRCST_SUP | TIMESTAMP | Schedule Details supplier last edit - last time any forecast details for an entry was updated by the supplier user. | ||||
SUP_DRAFT_QTY_FLAG | VARCHAR2 | 1 | Yes | Schedule Details Supplier Active Draft Values - 'Y' if any schedule details is in supplier draft. | ||
ENT_DRAFT_QTY_FLAG | VARCHAR2 | 1 | Yes | Schedule Details Enterprise Active Draft Values - 'Y' if any schedule details is in enterprise draft. | ||
MAX_COMMIT_VERSION | NUMBER | 9 | Identifies the number of mid-cycle commit updates performed on this collaboration entry. | |||
PUBLISH_CYCLE_START_DATE | DATE | The calculated start date based on the plan scenario publish cycle. | ||||
PUBLISH_CYCLE_END_DATE | DATE | The calculated end date based on the plan scenario publish cycle. | ||||
FORECAST_HORIZON_FQTY | NUMBER | An aggregated value that shows the total of all forecast quantities for the collaboration entry within the Forecast Horizon. | ||||
COMMIT_HORIZON_FQTY | NUMBER | An aggregated value that shows the total of all forecast quantities for the collaboration entry within the Commit Horizon. | ||||
COMMIT_HORIZON_CQTY | NUMBER | An aggregated value that shows the total of all Commit quantities for the collaboration entry within the Commit Horizon. | ||||
COMMITTED_BY | NUMBER | 18 | The type of user that performed the commitment. | |||
COMMITTED_BY_PARTY | VARCHAR2 | 30 | The type of user that performed the commitment. | |||
LAST_PUBLISHED_PLAN_NAME | VARCHAR2 | 30 | The last supply plan used within the planning cycle to publish the collaboration order forecast. | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
PUBLISHED_BY | NUMBER | 18 | Person Id of Supply Plan Publisher. | |||
EXTERNAL_REFERENCE_FLAG | VARCHAR2 | 1 | Identifies if any of the data is externally referenced. | |||
COMMIT_MISMATCH_COUNT_WEEKLY | NUMBER | The count of weekly commit mismatch exceptions. | ||||
COMMIT_MISMATCH_COUNT_MONTHLY | NUMBER | The count of monthly commit mismatch exceptions. | ||||
FORECAST_CHANGE_COUNT_WEEKLY | NUMBER | The count of weekly forecast change exceptions. | ||||
FORECAST_CHANGE_COUNT_MONTHLY | NUMBER | The count of monthly forecast change exceptions. | ||||
BUCKET_COUNT_FH_WEEKLY | NUMBER | Number of weekly buckets within Forecast Horizon. | ||||
BUCKET_COUNT_FH_MONTHLY | NUMBER | Number of monthly buckets within Forecast Horizon. | ||||
BUCKET_COUNT_CH_WEEKLY | NUMBER | Number of weekly buckets within Commit Horizon. | ||||
BUCKET_COUNT_CH_MONTHLY | NUMBER | Number of monthly buckets within Commit Horizon. | ||||
CTF_MAPE_WEEKLY | NUMBER | Commit to Forecast MAPE Weekly. This will be stored as a decimal factor. | ||||
CTF_MAPE_MONTHLY | NUMBER | Commit to Forecast MAPE Monthly. This will be stored as a decimal factor. | ||||
FORECAST_CHANGE_MAPE_WEEKLY | NUMBER | Forecast Change MAPE Weekly. This will be stored as a decimal factor. | ||||
FORECAST_CHANGE_MAPE_MONTHLY | NUMBER | Forecast Change MAPE Monthly. This will be stored as a decimal factor. | ||||
COLLAB_IDENTITY_ID | NUMBER | 18 | Yes | Provides collab entry identification across multiple publish cycles. | ||
PRIMARY_UOM_CODE | VARCHAR2 | 3 | Identifies the unit of measure used during the collaboration cycle. Historical collaboration order forecast quantities are only stored in base unit of measure (BASE_UOM_CODE). | |||
DROP_SHIP_FLAG | VARCHAR2 | 1 | Yes | A column heading that identifies the collaboration entry as drop ship. | ||
COLLAB_UOM | VARCHAR2 | 3 | Identifies the supply chain collaboration unit of measure for supply planning collaboration. All collaboration order forecast historical quantities are stored in the item's primary unit of measure. | |||
SUPPLIER_ON_HAND_QTY | NUMBER | Quantity of the supplier on-hand inventory for the item, stored in the collaboration unit of measure (PRIMARY_UOM_CODE). | ||||
SUPPLIER_ON_HAND_PUB_BY | NUMBER | 18 | User who most recently published the supplier on-hand quantity. | |||
SUPPLIER_ON_HAND_PUB_DATE | TIMESTAMP | Date when the supplier on-hand quantity was published. | ||||
CM_ON_HAND_QTY | NUMBER | Quantity of the contract manufacturing on-hand inventory for the item, stored in the collaboration unit of measure (PRIMARY_UOM_CODE). | ||||
CM_ON_HAND_PUB_BY | NUMBER | 18 | User who most recently published the contract manufacturing on-hand quantity. | |||
CM_ON_HAND_PUB_DATE | TIMESTAMP | Date when the contract manufacturing on-hand quantity was published. | ||||
SUPPLIER_ON_HAND_PUB_BY_PARTY | VARCHAR2 | 30 | The type of user who published the supplier on-hand quantity. The allowed values in this column are 'ORA_VCS_ENTERPRISE_VAL' and 'ORA_VCS_SUPPLIER_VAL'. | |||
CM_ON_HAND_PUB_BY_PARTY | VARCHAR2 | 30 | The type of user who published the contract manufacturing on-hand quantity. The allowed values in this column are 'ORA_VCS_ENTERPRISE_VAL' and 'ORA_VCS_SUPPLIER_VAL'. | |||
PUBLISH_BY_PARTY | VARCHAR2 | 30 | The type of user who last published forecast information. The allowed values in this column are 'ORA_VCS_ENTERPRISE_VAL' and 'ORA_VCS_SUPPLIER_VAL'. | |||
MANUFACTURER_NAME | VARCHAR2 | 100 | Name of the manufacturer of the part number. | |||
MANUFACTURER_PART_NUMBER | VARCHAR2 | 100 | Number that identifies the item at the manufacturer. | |||
NOTE_TO_SUPPLIER | VARCHAR2 | 1000 | Note from the collaboration planner to the supplier. | |||
NOTE_TO_PLANNER | VARCHAR2 | 1000 | Note from the supplier to the collaboration planner. |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
VCS_COLLAB_ENT_HIST_N1 | Non Unique | Default | SHIP_FROM_ID, COLLAB_SOURCE_ID, INVENTORY_ITEM_ID, INVENTORY_ITEM_ORG_ID, SHIP_TO_ID, COLLAB_ENTRY_VERSION | |
VCS_COLLAB_ENT_HIST_N2 | Non Unique | Default | COLLAB_IDENTITY_ID | |
VCS_ITEM_COLLAB_ENT_U11 | Unique | FUSION_TS_TX_IDX | ENTRY_ID | Active |