ControlArea Identifier 
Base Entity  Inventory Control Area 
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 Area
ControlArea Identifier 		 NO     
INVT (Oracle)
INVT_CTRL_AREA
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 

Storage Identifier 
Base Entity  Inventory Control Area 
Attribute Name  Storage Identifier 
Logical Rolename   
ColumnName  STOR_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Storage Identifier Logical Attribute Properties 
Logical Attribute Name  Storage Identifier 
Datatype  VARCHAR(50) 
Nullable  YES 

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

Storage Identifier Security Types 
Name  Current Value 

Storage Identifier Bound Attachments 
Name  Current Value 

Storage Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Storage Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Inventory Control Area
Storage Identifier 		 NO     
INVT (Oracle)
INVT_CTRL_AREA
STOR_ID 		 NO     

Storage Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Storage Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Storage Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Storage Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

DataStream Location Description 
Base Entity  Inventory Control Area 
Attribute Name  DataStream Location Description 
Logical Rolename   
ColumnName  DS_LOC_DESC 
RoleName   
Domain  Description 
Logical Only  NO 
Definition  
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Note 
 

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

DataStream Location Description Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

DataStream Location Description Security Types 
Name  Current Value 

DataStream Location Description Bound Attachments 
Name  Current Value 

DataStream Location Description Data Movement Rules 
Name  Type  Rule Text/Value 

DataStream Location Description Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Inventory Control Area
DataStream Location Description 		 NO     
INVT (Oracle)
INVT_CTRL_AREA
DS_LOC_DESC 		 NO     

DataStream Location Description Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DataStream Location Description Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DataStream Location Description Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DataStream Location Description Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

DataStream Location Identifier 
Base Entity  Inventory Control Area 
Attribute Name  DataStream Location Identifier 
Logical Rolename   
ColumnName  DS_LOC_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

DataStream Location Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

DataStream Location Identifier Security Types 
Name  Current Value 

DataStream Location Identifier Bound Attachments 
Name  Current Value 

DataStream Location Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

DataStream Location Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Inventory Control Area
DataStream Location Identifier 		 NO     
INVT (Oracle)
INVT_CTRL_AREA
DS_LOC_ID 		 NO     

DataStream Location Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DataStream Location Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DataStream Location Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DataStream Location Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Building 
Base Entity  Inventory Control Area 
Attribute Name  Building 
Logical Rolename   
ColumnName  BUILDING 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Building Logical Attribute Properties 
Logical Attribute Name  Building 
Datatype  CHAR(8) 
Nullable  YES 

Building Domain Restrictions 

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

Building Bound Attachments 
Name  Current Value 

Building Data Movement Rules 
Name  Type  Rule Text/Value 

Building Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Inventory Control Area
Building 		 NO     
INVT (Oracle)
INVT_CTRL_AREA
BUILDING 		 NO     

Building Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Building Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Building Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Building Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Room 
Base Entity  Inventory Control Area 
Attribute Name  Room 
Logical Rolename   
ColumnName  ROOM 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Room Logical Attribute Properties 
Logical Attribute Name  Room 
Datatype  CHAR(8) 
Nullable  YES 

Room Domain Restrictions 

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

Room Bound Attachments 
Name  Current Value 

Room Data Movement Rules 
Name  Type  Rule Text/Value 

Room Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Inventory Control Area
Room 		 NO     
INVT (Oracle)
INVT_CTRL_AREA
ROOM 		 NO     

Room Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Room Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Room Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Room Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description