ITEM_ID |
Base Object | INVT_CTRL_INFOR_ITEM |
Attribute Name | Item Identifier |
ColumnName | ITEM_ID |
Logical Rolename | |
RoleName | ITEM_ID |
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 Infor Item Item Identifier |
NO | ||
INVT (Oracle) INVT_CTRL_INFOR_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 |
ASSET_ID |
Base Object | INVT_CTRL_INFOR_ITEM |
Attribute Name | Asset Identifier |
ColumnName | ASSET_ID |
Logical Rolename | |
RoleName | |
Domain | Asset Identifier |
Physical Only | NO |
Definition | |
Note |
ASSET_ID Column Properties |
Datatype | VARCHAR2(30) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ASSET_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 11 |
Percent Null | 0 |
ASSET_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ASSET_ID Security Types |
Name | Current Value |
ASSET_ID Bound Attachments |
Name | Current Value |
ASSET_ID Data Movement Rules |
Name | Type | Rule Text/Value |
ASSET_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Inventory Control Infor Item Asset Identifier |
NO | ||
INVT (Oracle) INVT_CTRL_INFOR_ITEM ASSET_ID |
NO |
ASSET_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ASSET_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ASSET_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ASSET_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DEPT |
Base Object | INVT_CTRL_INFOR_ITEM |
Attribute Name | Department |
ColumnName | DEPT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
DEPT Column Properties |
Datatype | VARCHAR2(45) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DEPT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 45 |
Percent Null | 0 |
DEPT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DEPT Security Types |
Name | Current Value |
DEPT Bound Attachments |
Name | Current Value |
DEPT Data Movement Rules |
Name | Type | Rule Text/Value |
DEPT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Inventory Control Infor Item Department |
NO | ||
INVT (Oracle) INVT_CTRL_INFOR_ITEM DEPT |
NO |
DEPT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DEPT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DEPT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DEPT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
STAT_ID |
Base Object | INVT_CTRL_INFOR_ITEM |
Attribute Name | Status Identifier |
ColumnName | STAT_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
STAT_ID Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
STAT_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
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 Infor Item Status Identifier |
NO | ||
INVT (Oracle) INVT_CTRL_INFOR_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 |