Item Identifier |
Base Entity | Inventory Control Infor Item |
Attribute Name | Item Identifier |
Logical Rolename | |
ColumnName | ITEM_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Item Identifier Logical Attribute Properties |
Logical Attribute Name | Item Identifier |
Datatype | NUMERIC(38, 0) |
Nullable | NO |
Item Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Item Identifier Security Types |
Name | Current Value |
Item Identifier Bound Attachments |
Name | Current Value |
Item Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Item Identifier 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 Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Item Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Item Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Item Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Department |
Base Entity | Inventory Control Infor Item |
Attribute Name | Department |
Logical Rolename | |
ColumnName | DEPT |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Department Logical Attribute Properties |
Logical Attribute Name | Department |
Datatype | VARCHAR(45) |
Nullable | NO |
Department Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Department Security Types |
Name | Current Value |
Department Bound Attachments |
Name | Current Value |
Department Data Movement Rules |
Name | Type | Rule Text/Value |
Department 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 |
Department Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Department Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Department Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Department Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier |
Base Entity | Inventory Control Infor Item |
Attribute Name | Status Identifier |
Logical Rolename | |
ColumnName | STAT_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Status Identifier Logical Attribute Properties |
Logical Attribute Name | Status Identifier |
Datatype | VARCHAR(50) |
Nullable | YES |
Status Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Status Identifier Security Types |
Name | Current Value |
Status Identifier Bound Attachments |
Name | Current Value |
Status Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Status Identifier 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 |
Status Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |