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