QSC_IMP_PROD_GROUP_ITEMS
Interface table for product group item associations. The WHO column in this table, just reflects when the data was loaded into the interface table or when it was processed. These columns are for information purpose only and it will not be used during actual import into fusion.
Details
-
Schema: FUSION
-
Object owner: QSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
QSC_IMP_PROD_GROUP_ITEMS_PK |
BATCH_ID, INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | Primary Key. Batch Identifier. Identifier that groups data into a batch. | |
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | Primary Key. Interface Row Id. Will be used to link this row with rows in the error table. | |
| IMPORT_STATUS_CODE | VARCHAR2 | 30 | Indicates the status of the row to be processed. | ||
| ACTION_CODE | VARCHAR2 | 30 | Indicates the operation to be performed on a row such as Insert, Update etc. | ||
| INTERNAL_ACTION_CODE | VARCHAR2 | 30 | For Internal Use. Used to evaluate the operation to be performed on a row such as Insert, Update etc. | ||
| ITEM_NUMBER | VARCHAR2 | 300 | Item Number | ||
| ITEM_NAME | VARCHAR2 | 1995 | Item Name | ||
| ITEM_ORIG_SYSTEM_REFERENCE | VARCHAR2 | 255 | Original Item System Reference | ||
| INV_ORG_CODE | VARCHAR2 | 30 | Inventory Organization Code for the organization that the item belongs to. | ||
| PG_REF_NUMBER | VARCHAR2 | 50 | Reference Number. Used for integration with external systems. Stores the unique identifier of the product group in the source system. | ||
| PG_INTERNAL_NAME | VARCHAR2 | 150 | Internal name for product groups. | ||
| ITEM_ORIG_SYSTEM | VARCHAR2 | 30 | Name of the source system, the item was imported from. | ||
| FILE_NAME_SYSTASK_ID | NUMBER | 18 | Individual System Task Id for each input csv file. | ||
| PROD_GROUP_ID | NUMBER | 18 | Used for internal processing. Product group identifier in fusion base table. | ||
| PROD_GROUP_ITEM_ID | NUMBER | 18 | Used for internal processing Product group item identifier in fusion. | ||
| ADMIN_REVISION_NUM | NUMBER | 18 | Used for internal processing. The revision number of the workspace version. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Used for internal processing. Inventory Item Identifier in fusion. | ||
| INV_ORG_ID | NUMBER | 18 | Used for internal processing. Item organization identifier in fusion. | ||
| ITEM_ORIG_SYSTEM_ID | NUMBER | 18 | Used for internal processing. Stores the original system reference identifier of the item. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or 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. | |
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | 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. | ||
| ACTIVE_FLAG | VARCHAR2 | 1 | Indicates whether the item is active in the group. | ||
| START_DATE | TIMESTAMP | Date from which the item is active in the product group | |||
| END_DATE | TIMESTAMP | Date from which item is not active in the product group | |||
| DISPLAY_ORDER_NUM | NUMBER | 18 | Manually set display order for items in a product group. | ||
| FILE_RECORD_NUM | NUMBER | Used by the file import wizard to relate a row in the interface table to the data file that was uploaded. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QSC_IMP_PROD_GROUP_ITEMS_N1 | Non Unique | Default | BATCH_ID, PG_REF_NUMBER, ITEM_NUMBER, INV_ORG_CODE |
| QSC_IMP_PROD_GROUP_ITEMS_N2 | Non Unique | Default | BATCH_ID, PG_INTERNAL_NAME, ITEM_NUMBER, INV_ORG_CODE |
| QSC_IMP_PROD_GROUP_ITEMS_N3 | Non Unique | Default | BATCH_ID, INTERNAL_ACTION_CODE, IMPORT_STATUS_CODE |
| QSC_IMP_PROD_GROUP_ITEMS_N4 | Non Unique | Default | BATCH_ID, ACTION_CODE, IMPORT_STATUS_CODE |
| QSC_IMP_PROD_GROUP_ITEMS_PK | Unique | Default | BATCH_ID, INTERFACE_ROW_ID |