Item Identifier 
Base Entity  Inventory Control 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 Item
Item Identifier 		 NO     
INVT (Oracle)
INVT_CTRL_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 

Parent Item Identifier 
Base Entity  Inventory Control Item 
Attribute Name  Item Identifier 
Logical Rolename  Parent Item Identifier 
ColumnName  PARENT_ITEM_ID 
RoleName  PARENT_ITEM_ID 
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Parent Item Identifier Logical Attribute Properties 
Logical Attribute Name  Item Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  YES 

Parent Item Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Parent Item Identifier Security Types 
Name  Current Value 

Parent Item Identifier Bound Attachments 
Name  Current Value 

Parent Item Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Parent Item Identifier 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 Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Parent Item Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Parent Item Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Parent Item Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Item Name 
Base Entity  Inventory Control Item 
Attribute Name  Item Name 
Logical Rolename   
ColumnName  ITEM_NM 
RoleName   
Domain  Name 
Logical Only  NO 
Definition 
 
Note 
 

Item Name Logical Attribute Properties 
Logical Attribute Name  Item Name 
Datatype  VARCHAR(120) 
Nullable  NO 

Item Name Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Item Name Security Types 
Name  Current Value 

Item Name Bound Attachments 
Name  Current Value 

Item Name Data Movement Rules 
Name  Type  Rule Text/Value 

Item Name 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 Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Item Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Item Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Item Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

ControlArea Identifier 
Base Entity  Inventory Control Item 
Attribute Name  ControlArea Identifier 
Logical Rolename   
ColumnName  CTRL_AREA_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

ControlArea Identifier Logical Attribute Properties 
Logical Attribute Name  ControlArea Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  NO 

ControlArea Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ControlArea Identifier Security Types 
Name  Current Value 

ControlArea Identifier Bound Attachments 
Name  Current Value 

ControlArea Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

ControlArea Identifier 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     

ControlArea Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ControlArea Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ControlArea Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ControlArea Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

SubArea Identifier 
Base Entity  Inventory Control Item 
Attribute Name  SubArea Identifier 
Logical Rolename   
ColumnName  SUBAREA_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

SubArea Identifier Logical Attribute Properties 
Logical Attribute Name  SubArea Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  YES 

SubArea Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SubArea Identifier Security Types 
Name  Current Value 

SubArea Identifier Bound Attachments 
Name  Current Value 

SubArea Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

SubArea Identifier 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 Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SubArea Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SubArea Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SubArea Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Item Description 
Base Entity  Inventory Control Item 
Attribute Name  Item Description 
Logical Rolename   
ColumnName  ITEM_DESCR 
RoleName   
Domain  Description 
Logical Only  NO 
Definition 
 
Note 
 

Item Description Logical Attribute Properties 
Logical Attribute Name  Item Description 
Datatype  VARCHAR(255) 
Nullable  YES 

Item Description Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Item Description Security Types 
Name  Current Value 

Item Description Bound Attachments 
Name  Current Value 

Item Description Data Movement Rules 
Name  Type  Rule Text/Value 

Item Description 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 Description Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Item Description Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Item Description Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Item Description Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Inventory Type Identifier 
Base Entity  Inventory Control Item 
Attribute Name  Inventory Type Identifier 
Logical Rolename   
ColumnName  INVT_TYPE_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Inventory Type Identifier Logical Attribute Properties 
Logical Attribute Name  Inventory Type Identifier 
Datatype  VARCHAR(25) 
Nullable  NO 

Inventory Type Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Inventory Type Identifier Security Types 
Name  Current Value 

Inventory Type Identifier Bound Attachments 
Name  Current Value 

Inventory Type Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Inventory Type Identifier 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     

Inventory Type Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Inventory Type Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Inventory Type Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Inventory Type Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Status Identifier 
Base Entity  Inventory Control Item 
Attribute Name  Status Identifier 
Logical Rolename   
ColumnName  STAT_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Status Identifier Logical Attribute Properties 
Logical Attribute Name  Status Identifier 
Datatype  VARCHAR(25) 
Nullable  NO 

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 Item
Status Identifier 		 NO     
INVT (Oracle)
INVT_CTRL_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 

Group Identifier 
Base Entity  Inventory Control Item 
Attribute Name  Group Identifier 
Logical Rolename   
ColumnName  GRP_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Group Identifier Logical Attribute Properties 
Logical Attribute Name  Group Identifier 
Datatype  VARCHAR(128) 
Nullable  YES 

Group Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Group Identifier Security Types 
Name  Current Value 

Group Identifier Bound Attachments 
Name  Current Value 

Group Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Group Identifier 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     

Group Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Group Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Group Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Group Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Comment 
Base Entity  Inventory Control Item 
Attribute Name  Comment 
Logical Rolename   
ColumnName  CMNT 
RoleName   
Domain  Comment 
Logical Only  NO 
Definition 
 
Note 
 

Comment Logical Attribute Properties 
Logical Attribute Name  Comment 
Datatype  VARCHAR(2000) 
Nullable  YES 

Comment Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Comment Security Types 
Name  Current Value 

Comment Bound Attachments 
Name  Current Value 

Comment Data Movement Rules 
Name  Type  Rule Text/Value 

Comment Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Inventory Control Item
Comment 		 NO     
INVT (Oracle)
INVT_CTRL_ITEM
CMNT 		 NO     

Comment Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number 
Base Entity  Inventory Control Item 
Attribute Name  Badge Number 
Logical Rolename   
ColumnName  CUST_BN 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Badge Number Logical Attribute Properties 
Logical Attribute Name  Badge Number 
Datatype  VARCHAR(10) 
Nullable  NO 

Badge Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Badge Number Security Types 
Name  Current Value 

Badge Number Bound Attachments 
Name  Current Value 

Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Badge Number 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     

Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Serial Number 
Base Entity  Inventory Control Item 
Attribute Name  Serial Number 
Logical Rolename   
ColumnName  SERIAL_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Serial Number Logical Attribute Properties 
Logical Attribute Name  Serial Number 
Datatype  VARCHAR(50) 
Nullable  YES 

Serial Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Serial Number Security Types 
Name  Current Value 

Serial Number Bound Attachments 
Name  Current Value 

Serial Number Data Movement Rules 
Name  Type  Rule Text/Value 

Serial Number 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 Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Serial Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Serial Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Serial Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

ORNL Property Number 
Base Entity  Inventory Control Item 
Attribute Name  ORNL Property Number 
Logical Rolename   
ColumnName  ORNL_PROP_NBR 
RoleName   
Domain  ORNL Property Number 
Logical Only  NO 
Definition  
ORNL Property Number: The ORNL property number from the eProp system.
 
Note 
 

ORNL Property Number Logical Attribute Properties 
Logical Attribute Name  ORNL Property Number 
Datatype  VARCHAR(25) 
Nullable  YES 

ORNL Property Number Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ORNL Property Number Security Types 
Name  Current Value 

ORNL Property Number Bound Attachments 
Name  Current Value 

ORNL Property Number Data Movement Rules 
Name  Type  Rule Text/Value 

ORNL Property Number 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 Property Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORNL Property Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORNL Property Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ORNL Property Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Infor Asset Identifier 
Base Entity  Inventory Control Item 
Attribute Name  Infor Asset Identifier 
Logical Rolename   
ColumnName  INFOR_ASSET_ID 
RoleName   
Domain  Asset Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Infor Asset Identifier Logical Attribute Properties 
Logical Attribute Name  Infor Asset Identifier 
Datatype  VARCHAR(30) 
Nullable  YES 

Infor Asset Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Infor Asset Identifier Security Types 
Name  Current Value 

Infor Asset Identifier Bound Attachments 
Name  Current Value 

Infor Asset Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Infor Asset Identifier 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 Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Infor Asset Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Infor Asset Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Infor Asset Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date 
Base Entity  Inventory Control Item 
Attribute Name  Modify Date 
Logical Rolename   
ColumnName  MOD_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
 
Note 
 

Modify Date Logical Attribute Properties 
Logical Attribute Name  Modify Date 
Datatype  DATE 
Nullable  NO 

Modify Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Modify Date Security Types 
Name  Current Value 

Modify Date Bound Attachments 
Name  Current Value 

Modify Date Data Movement Rules 
Name  Type  Rule Text/Value 

Modify Date 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     

Modify Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Modify By Userid 
Base Entity  Inventory Control Item 
Attribute Name  Modify By Userid 
Logical Rolename   
ColumnName  MOD_BY_USERID 
RoleName   
Domain  Userid 
Logical Only  NO 
Definition 
 
Note 
 

Modify By Userid Logical Attribute Properties 
Logical Attribute Name  Modify By Userid 
Datatype  VARCHAR(64) 
Nullable  NO 

Modify By Userid Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Modify By Userid Security Types 
Name  Current Value 

Modify By Userid Bound Attachments 
Name  Current Value 

Modify By Userid Data Movement Rules 
Name  Type  Rule Text/Value 

Modify 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     

Modify By Userid Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modify By Userid Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modify By Userid Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Modify By Userid Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Purchase Order Number 
Base Entity  Inventory Control Item 
Attribute Name  Purchase Order Number 
Logical Rolename   
ColumnName  PO_NBR 
RoleName   
Domain  Purchase Order Number 
Logical Only  NO 
Definition 
 
Note 
 

Purchase Order Number Logical Attribute Properties 
Logical Attribute Name  Purchase Order Number 
Datatype  VARCHAR(20) 
Nullable  NO 

Purchase Order Number Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Purchase Order Number Security Types 
Name  Current Value 

Purchase Order Number Bound Attachments 
Name  Current Value 

Purchase Order Number Data Movement Rules 
Name  Type  Rule Text/Value 

Purchase Order Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Inventory Control Item
Purchase Order Number 		 NO     
INVT (Oracle)
INVT_CTRL_ITEM
PO_NBR 		 NO     

Purchase Order Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Purchase Order Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Purchase Order Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Purchase Order Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Purchase Order Item Number 
Base Entity  Inventory Control Item 
Attribute Name  Purchase Order Item Number 
Logical Rolename   
ColumnName  PO_ITEM_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Purchase Order Item Number Logical Attribute Properties 
Logical Attribute Name  Purchase Order Item Number 
Datatype  INTEGER 
Nullable  NO 

Purchase Order Item Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Purchase Order Item Number Security Types 
Name  Current Value 

Purchase Order Item Number Bound Attachments 
Name  Current Value 

Purchase Order Item Number Data Movement Rules 
Name  Type  Rule Text/Value 

Purchase Order Item Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Inventory Control Item
Purchase Order Item Number 		 NO     
INVT (Oracle)
INVT_CTRL_ITEM
PO_ITEM_NBR 		 NO     

Purchase Order Item Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Purchase Order Item Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Purchase Order Item Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Purchase Order Item Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description