VCS_COLLAB_HEADER_INT
VCS_COLLAB_HEADER_INT contains the ship to, ship from and item information for an order within a plan.
Details
-
Schema: FUSION
-
Object owner: VCS
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
VCS_COLLAB_HEADER_INT_PK |
COLLAB_SOURCE_ID, HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COLLAB_SOURCE_ID | NUMBER | 18 | Yes | Used to tie back to a VCS_COLLAB_SOURCE_INT record | |
| PUBLISHED_UOM_CODE | VARCHAR2 | 3 | The published unit of measure for the collaboration header. All measures are assumed to be in this unit of measure. | ||
| COLLAB_SOURCE_KEY | VARCHAR2 | 64 | Used only during import transaction to link VCS_COLLAB_HEADER data to a VCS_COLLAB_SOURCE. This must be unique within the VCS_COLLAB_SOURCE_INT import collection. | ||
| HEADER_KEY | VARCHAR2 | 64 | Used only during import transaction to link VCS_COLLAB_HEADER data to a VCS_COLLAB_DETAILS. This must be unique within the VCS_COLLAB_HEADER_INT import collection. | ||
| HEADER_ID | NUMBER | 18 | Yes | Used as a reference in VCS_COLLAB_DETAILS_INT | |
| SHIP_TO_ORGANIZATION_ID | NUMBER | 18 | Identifies the supplier site where the goods will be shipped to. | ||
| SHIP_TO_ORGANIZATION_CODE | VARCHAR2 | 49 | Alternatively identifies organization where the goods will be shipped to | ||
| SHIP_TO_CUSTOMER_ID | NUMBER | 18 | Identifies the customer site where the goods will be shipped to. Mutually exclusive with SHIP_TO_ORGANIZATION_ID. | ||
| SHIP_TO_CUSTOMER_NAME | VARCHAR2 | 360 | Identifies the customer where the goods will be shipped to. Used where internal ID is not known. | ||
| SHIP_TO_CUSTOMER_SITE_ID | NUMBER | 18 | Identifies the customer site where the goods will be shipped to. Mutually exclusive with SHIP_TO_ORGANIZATION_ID. | ||
| SHIP_TO_CUSTOMER_SITE_CODE | VARCHAR2 | 240 | Identifies the customer site where the goods will be shipped to. Used where internal site ID is not known. | ||
| SHIP_TO_CUSTOMER_SITE_NUMBER | VARCHAR2 | 30 | Identifies the customer site number where the goods will be shipped to. Used where internal site ID is not known. | ||
| SHIP_FROM_SUPPLIER_ID | NUMBER | 18 | Identifies the supplier where the goods will be shipped from. | ||
| SHIP_FROM_SUPPLIER_NAME | VARCHAR2 | 360 | Identifies the supplier where the goods will be shipped from. Used where internal ID is not known. | ||
| SHIP_FROM_SUPPLIER_SITE_CODE | VARCHAR2 | 240 | Identifies the supplier site where the goods will be shipped from. Used where internal supplier site ID is not known. | ||
| SHIP_FROM_SUPPLIER_SITE_ID | NUMBER | 18 | Identifies the supplier site where the goods will be shipped from. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifies the item that can be matched for a collaboration. | ||
| ITEM_NUMBER | VARCHAR2 | 300 | Uniquely Identifies item that will be used in collaboration. This number will have a cross-reference to the internal item. | ||
| STATUS_CODE | VARCHAR2 | 30 | Identifies the status of the header data | ||
| AGGR_TARGET_HEADER_ID | NUMBER | 18 | Stores the header record identification the details were aggregated into. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Yes | Identifies the instance that loads the data | |
| OWNING_APP_ID | VARCHAR2 | 4 | Yes | Identifies the application that will handle the data | |
| 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. | ||
| EXTERNAL_REFERENCE_FLAG | VARCHAR2 | 1 | Identifies if any of the data is externally referenced. | ||
| PRC_BU_NAME | VARCHAR2 | 240 | Identifies the supplier's procurement business unit name. | ||
| ORIGINAL_COLLAB_SOURCE_ID | NUMBER | 18 | Identifies the original collab_source_id value prior to splitting the plan by supplier and supplier site. This is referenced by the vcs_collab_details_int record processing during decomposition. | ||
| 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. | ||
| BASE_CONVERSION_RATE | NUMBER | Stores unit of measure conversion rate between published unit of measure and item base unit of measure to be used during decomposition process. | |||
| PRIMARY_CONVERSION_RATE | NUMBER | Stores unit of measure conversion rate between published unit of measure and collaboration unit of measure to be used during decomposition process. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VCS_COLLAB_HEADER_INT_N1 | Non Unique | Default | COLLAB_SOURCE_ID, ORIGINAL_COLLAB_SOURCE_ID |
| VCS_COLLAB_HEADER_INT_N10 | Non Unique | Default | COLLAB_SOURCE_ID, OWNING_APP_ID, STATUS_CODE, INVENTORY_ITEM_ID, SHIP_TO_ORGANIZATION_ID |
| VCS_COLLAB_HEADER_INT_N2 | Non Unique | Default | LOAD_REQUEST_ID, HEADER_KEY, COLLAB_SOURCE_KEY, STATUS_CODE |
| VCS_COLLAB_HEADER_INT_N3 | Non Unique | Default | COLLAB_SOURCE_ID, OWNING_APP_ID, SHIP_FROM_SUPPLIER_ID, SHIP_FROM_SUPPLIER_SITE_ID, SHIP_FROM_SUPPLIER_SITE_CODE, SHIP_TO_CUSTOMER_SITE_CODE |
| VCS_COLLAB_HEADER_INT_U2 | Unique | Default | COLLAB_SOURCE_ID, HEADER_ID |