EGI_CONFIRMATION_GTIN_ERRORS
This table stores the errors for each GTIN received as part of the CIN.
Details
-
Schema: FUSION
-
Object owner: EGI
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
EGI_GTIN_ERRORS_PK |
ERROR_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
ERROR_ID | NUMBER | 18 | Yes | Unique identifier for the error that is associated with the acknowledgement. | |
GTIN_ID | NUMBER | 18 | Yes | The unique identifier (usually represented as a bar code printed on the packaging) assigned by the product brand owner or supplier. The GTIN is also used to identify inner packs, multi packs and shippers as it is a unique identifier for each level of a Trade Item Hierarchy. | |
ERROR_CODE | VARCHAR2 | 30 | Yes | Error code from the data pool that is associated with the acknowledgment. | |
CORRECTIVE_ACTION_CODE | VARCHAR2 | 30 | Yes | The code sent to the supplier via the data pool that indicates the type of correction that needs to be done by the supplier for the item data as described in the GDSN messaging choreography. | |
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 | 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. | ||
ERROR_DETAILS | VARCHAR2 | 2000 | Yes | Details of the error that is associated with the acknowledgement. | |
ADDITIONAL_ERROR_DETAIL | VARCHAR2 | 4000 | Additional details that provide more description regarding the error. | ||
CORRECTIVE_ACTION_DETAILS | VARCHAR2 | 4000 | Yes | The details sent to the supplier via the data pool that indicates the type of correction that needs to be done by the supplier for the item data as described in the GDSN messaging choreography. | |
INVENTORY_ITEM_ID | NUMBER | 18 | Attribute indicating the unique identifier of the item. | ||
ORGANIZATION_ID | NUMBER | 18 | The target market is the geographic location where the supplier makes the item available to Retailers. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
EGI_CONFIRMATION_GTIN_ERRORS | egi_confirmation_gtins | GTIN_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
EGI_CONFIRMATION_GTIN_ERR_N1 | Non Unique | Default | GTIN_ID |
EGI_CONFIRMATION_GTIN_ERR_U1 | Unique | Default | ERROR_ID |