| ITEM_ID |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | Item Identifier |
| ColumnName | ITEM_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| ITEM_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ITEM_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| ITEM_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ITEM_ID Security Types |
| Name | Current Value |
| ITEM_ID Bound Attachments |
| Name | Current Value |
| ITEM_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| ITEM_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item Item Identifier |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM ITEM_ID |
NO |
| ITEM_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PARENT_ITEM_ID |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | Item Identifier |
| ColumnName | PARENT_ITEM_ID |
| Logical Rolename | Parent Item Identifier |
| RoleName | PARENT_ITEM_ID |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| PARENT_ITEM_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PARENT_ITEM_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| PARENT_ITEM_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PARENT_ITEM_ID Security Types |
| Name | Current Value |
| PARENT_ITEM_ID Bound Attachments |
| Name | Current Value |
| PARENT_ITEM_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| PARENT_ITEM_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item Item Identifier |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM PARENT_ITEM_ID |
NO |
| PARENT_ITEM_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PARENT_ITEM_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PARENT_ITEM_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PARENT_ITEM_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_NM |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | Item Name |
| ColumnName | ITEM_NM |
| Logical Rolename | |
| RoleName | |
| Domain | Name |
| Physical Only | NO |
| Definition | |
| Note |
| ITEM_NM Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ITEM_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| ITEM_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ITEM_NM Security Types |
| Name | Current Value |
| ITEM_NM Bound Attachments |
| Name | Current Value |
| ITEM_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| ITEM_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item Item Name |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM ITEM_NM |
NO |
| ITEM_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CTRL_AREA_ID |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | ControlArea Identifier |
| ColumnName | CTRL_AREA_ID |
| Logical Rolename | ControlArea Identifier |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| CTRL_AREA_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CTRL_AREA_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| CTRL_AREA_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CTRL_AREA_ID Security Types |
| Name | Current Value |
| CTRL_AREA_ID Bound Attachments |
| Name | Current Value |
| CTRL_AREA_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| CTRL_AREA_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item ControlArea Identifier |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM CTRL_AREA_ID |
NO |
| CTRL_AREA_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CTRL_AREA_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CTRL_AREA_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CTRL_AREA_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBAREA_ID |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | SubArea Identifier |
| ColumnName | SUBAREA_ID |
| Logical Rolename | SubArea Identifier |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| SUBAREA_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SUBAREA_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| SUBAREA_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SUBAREA_ID Security Types |
| Name | Current Value |
| SUBAREA_ID Bound Attachments |
| Name | Current Value |
| SUBAREA_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| SUBAREA_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item SubArea Identifier |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM SUBAREA_ID |
NO |
| SUBAREA_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBAREA_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBAREA_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBAREA_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_DESCR |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | Item Description |
| ColumnName | ITEM_DESCR |
| Logical Rolename | |
| RoleName | |
| Domain | Description |
| Physical Only | NO |
| Definition | |
| Note |
| ITEM_DESCR Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ITEM_DESCR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| ITEM_DESCR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ITEM_DESCR Security Types |
| Name | Current Value |
| ITEM_DESCR Bound Attachments |
| Name | Current Value |
| ITEM_DESCR Data Movement Rules |
| Name | Type | Rule Text/Value |
| ITEM_DESCR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item Item Description |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM ITEM_DESCR |
NO |
| ITEM_DESCR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_DESCR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_DESCR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ITEM_DESCR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INVT_TYPE_ID |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | Inventory Type Identifier |
| ColumnName | INVT_TYPE_ID |
| Logical Rolename | Inventory Type Identifier |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| INVT_TYPE_ID Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| INVT_TYPE_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| INVT_TYPE_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| INVT_TYPE_ID Security Types |
| Name | Current Value |
| INVT_TYPE_ID Bound Attachments |
| Name | Current Value |
| INVT_TYPE_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| INVT_TYPE_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item Inventory Type Identifier |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM INVT_TYPE_ID |
NO |
| INVT_TYPE_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INVT_TYPE_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INVT_TYPE_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INVT_TYPE_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | Status Identifier |
| ColumnName | STAT_ID |
| Logical Rolename | Status Identifier |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| STAT_ID Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| STAT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| STAT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| STAT_ID Security Types |
| Name | Current Value |
| STAT_ID Bound Attachments |
| Name | Current Value |
| STAT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| STAT_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item Status Identifier |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM STAT_ID |
NO |
| STAT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GRP_ID |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | Group Identifier |
| ColumnName | GRP_ID |
| Logical Rolename | Group Identifier |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| GRP_ID Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| GRP_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 128 |
| Percent Null | 0 |
| GRP_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| GRP_ID Security Types |
| Name | Current Value |
| GRP_ID Bound Attachments |
| Name | Current Value |
| GRP_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| GRP_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item Group Identifier |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM GRP_ID |
NO |
| GRP_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GRP_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GRP_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GRP_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | Comment |
| ColumnName | CMNT |
| Logical Rolename | |
| RoleName | |
| Domain | Comment |
| Physical Only | NO |
| Definition | |
| Note |
| CMNT Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CMNT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| CMNT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CMNT Security Types |
| Name | Current Value |
| CMNT Bound Attachments |
| Name | Current Value |
| CMNT Data Movement Rules |
| Name | Type | Rule Text/Value |
| CMNT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item Comment |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM CMNT |
NO |
| CMNT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CUST_BN |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | Badge Number |
| ColumnName | CUST_BN |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| CUST_BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CUST_BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| CUST_BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CUST_BN Security Types |
| Name | Current Value |
| CUST_BN Bound Attachments |
| Name | Current Value |
| CUST_BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| CUST_BN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item Badge Number |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM CUST_BN |
NO |
| CUST_BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CUST_BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CUST_BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CUST_BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TPO_BN |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | TPO_BN |
| ColumnName | TPO_BN |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| TPO_BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TPO_BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| TPO_BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TPO_BN Security Types |
| Name | Current Value |
| TPO_BN Bound Attachments |
| Name | Current Value |
| TPO_BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| TPO_BN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item TPO_BN |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM TPO_BN |
NO |
| TPO_BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TPO_BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TPO_BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TPO_BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SERIAL_NBR |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | SERIAL_NBR |
| ColumnName | SERIAL_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SERIAL_NBR Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SERIAL_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| SERIAL_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SERIAL_NBR Security Types |
| Name | Current Value |
| SERIAL_NBR Bound Attachments |
| Name | Current Value |
| SERIAL_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| SERIAL_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item Serial Number |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM SERIAL_NBR |
NO |
| SERIAL_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SERIAL_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SERIAL_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SERIAL_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_PROP_NBR |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | ORNL_PROP_NBR |
| ColumnName | ORNL_PROP_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| ORNL_PROP_NBR Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ORNL_PROP_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| ORNL_PROP_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ORNL_PROP_NBR Security Types |
| Name | Current Value |
| ORNL_PROP_NBR Bound Attachments |
| Name | Current Value |
| ORNL_PROP_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| ORNL_PROP_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item ORNL Property Number |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM ORNL_PROP_NBR |
NO |
| ORNL_PROP_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_PROP_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_PROP_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_PROP_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INFOR_ASSET_ID |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | Infor Asset Identifier |
| ColumnName | INFOR_ASSET_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Asset Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| INFOR_ASSET_ID Column Properties |
| Datatype | VARCHAR2(30) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| INFOR_ASSET_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 30 |
| Percent Null | 0 |
| INFOR_ASSET_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| INFOR_ASSET_ID Security Types |
| Name | Current Value |
| INFOR_ASSET_ID Bound Attachments |
| Name | Current Value |
| INFOR_ASSET_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| INFOR_ASSET_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item Infor Asset Identifier |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM INFOR_ASSET_ID |
NO |
| INFOR_ASSET_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INFOR_ASSET_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INFOR_ASSET_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INFOR_ASSET_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | Modify Date |
| ColumnName | MOD_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | |
| Note |
| MOD_DTE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MOD_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| MOD_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| MOD_DTE Security Types |
| Name | Current Value |
| MOD_DTE Bound Attachments |
| Name | Current Value |
| MOD_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| MOD_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item Modify Date |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM MOD_DTE |
NO |
| MOD_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_USERID |
| Base Object | INVT_CTRL_ITEM |
| Attribute Name | Modify By Userid |
| ColumnName | MOD_BY_USERID |
| Logical Rolename | |
| RoleName | |
| Domain | Userid |
| Physical Only | NO |
| Definition | |
| Note |
| MOD_BY_USERID Column Properties |
| Datatype | VARCHAR2(64) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MOD_BY_USERID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 64 |
| Percent Null | 0 |
| MOD_BY_USERID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MOD_BY_USERID Security Types |
| Name | Current Value |
| MOD_BY_USERID Bound Attachments |
| Name | Current Value |
| MOD_BY_USERID Data Movement Rules |
| Name | Type | Rule Text/Value |
| MOD_BY_USERID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Inventory Control Item Modify By Userid |
NO | ||
| INVT (Oracle) INVT_CTRL_ITEM MOD_BY_USERID |
NO |
| MOD_BY_USERID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_USERID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_USERID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_USERID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |