The following table shows the columns in the EGO_ITM_USR_ATTR_INTRFC database table. For more details about the columns in EGO_ITM_USR_ATTR_INTRFC, see EGO_ITM_USR_ATTR_INTRFC Details.
EGO_ITM_USR_ATTR_INTRFC table
| Column Name | Data Type | Required? |
|---|---|---|
| EGO_ITM_USR_ATTR_INTRFC | ||
| TRANSACTION_ID | NUMBER | Yes |
| PROCESS_STATUS | NUMBER | Yes |
| DATA_SET_ID | NUMBER | Yes |
| ORGANIZATION_CODE | VARCHAR2(3) | Yes |
| ITEM_NUMBER | VARCHAR2(81) | Yes |
| REVISION | VARCHAR2(30) | |
| ROW_IDENTIFIER | NUMBER | Yes |
| ATTR_GROUP_INT_NAME | VARCHAR2(30) | Yes |
| ATTR_INT_NAME | VARCHAR2(30) | Yes |
| ATTR_VALUE_STR | VARCHAR2(150) | |
| ATTR_VALUE_NUM | NUMBER | |
| ATTR_VALUE_DATE | DATE | |
| ATTR_DISP_VALUE | VARCHAR2(150) | |
| ATTR_UOM_DISP_VALUE | VARCHAR2(25) | |
| ATTR_VALUE_UOM | VARCHAR2(3) | |
| TRANSACTION_TYPE | VARCHAR2 | Yes |
| ORGANIZATION_ID | NUMBER | |
| INVENTORY_ITEM_ID | NUMBER | |
| ITEM_CATALOG_GROUP_ID | NUMBER | |
| REVISION_ID | NUMBER | |
| ATTR_GROUP_ID | NUMBER | |
| REQUEST_ID | NUMBER | |
| PROGRAM_APPLICATION_ID | NUMBER | |
| PROGRAM_ID | NUMBER | |
| PROGRAM_UPDATE_DATE | Date | |
| CREATED_BY | NUMBER(15) | Yes |
| CREATION_DATE | DATE | Yes |
| LAST_UPDATED_BY | NUMBER(15) | Yes |
| LAST_UPDATE_DATE | DATE | Yes |
| LAST_UPDATE_LOGIN | NUMBER(15) |