Purchase Order Number 
Base Entity  Purchase Order Item Receipt 
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
Purchase Order Item Receipt
Purchase Order Number 
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  Purchase Order Item Receipt 
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
Purchase Order Item Receipt
Purchase Order Item Number 
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 


Current Date 
Base Entity  Purchase Order Item Receipt 
Attribute Name  Current Date 
Logical Rolename   
ColumnName  CUR_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

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

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

Current Date Security Types 
Name  Current Value 

Current Date Bound Attachments 
Name  Current Value 

Current Date Data Movement Rules 
Name  Type  Rule Text/Value 

Current Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Purchase Order Item Receipt
Current Date 
NO     

Current Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Quantity Received Number 
Base Entity  Purchase Order Item Receipt 
Attribute Name  Quantity Received Number 
Logical Rolename   
ColumnName  QTY_RECD_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Quantity Received Number Logical Attribute Properties 
Logical Attribute Name  Quantity Received Number 
Datatype  INTEGER 
Nullable  YES 

Quantity Received Number Domain Restrictions 

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

Quantity Received Number Bound Attachments 
Name  Current Value 

Quantity Received Number Data Movement Rules 
Name  Type  Rule Text/Value 

Quantity Received Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Purchase Order Item Receipt
Quantity Received Number 
NO     

Quantity Received Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Quantity Received Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Quantity Received Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Quantity Received Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Unit Of Measure 
Base Entity  Purchase Order Item Receipt 
Attribute Name  Unit Of Measure 
Logical Rolename   
ColumnName  UOM_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Unit of Measure:  A field used to define a unique unit of measure.
 
Note 
 

Unit Of Measure Logical Attribute Properties 
Logical Attribute Name  Unit Of Measure 
Datatype  VARCHAR(20) 
Nullable  YES 

Unit Of Measure Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Unit Of Measure Security Types 
Name  Current Value 

Unit Of Measure Bound Attachments 
Name  Current Value 

Unit Of Measure Data Movement Rules 
Name  Type  Rule Text/Value 

Unit Of Measure Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Purchase Order Item Receipt
Unit Of Measure 
NO     

Unit Of Measure Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Unit Of Measure Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Unit Of Measure Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Unit Of Measure Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Receipt Date 
Base Entity  Purchase Order Item Receipt 
Attribute Name  Receipt Date 
Logical Rolename   
ColumnName  RECPT_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

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

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

Receipt Date Security Types 
Name  Current Value 

Receipt Date Bound Attachments 
Name  Current Value 

Receipt Date Data Movement Rules 
Name  Type  Rule Text/Value 

Receipt Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Purchase Order Item Receipt
Receipt Date 
NO     

Receipt Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Receipt Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Receipt Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Receipt Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Delivery Badge Number 
Base Entity  Purchase Order Item Receipt 
Attribute Name  Delivery Badge Number 
Logical Rolename   
ColumnName  DEVLIV_BN 
RoleName   
Domain  Badge Number 
Logical Only  NO 
Definition 
Delivery Badge Number: The person who delivered the IC item.
 
Note 
 

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

Delivery Badge Number Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Delivery Badge Number Security Types 
Name  Current Value 

Delivery Badge Number Bound Attachments 
Name  Current Value 

Delivery Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Delivery Badge Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Purchase Order Item Receipt
Delivery Badge Number 
NO     

Delivery Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Delivery Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Delivery Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Delivery Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Receipt Generator Badge Number 
Base Entity  Purchase Order Item Receipt 
Attribute Name  Receipt Generator Badge Number 
Logical Rolename   
ColumnName  RECPT_EN_BN 
RoleName   
Domain  Badge Number 
Logical Only  NO 
Definition 
 
Note 
 

Receipt Generator Badge Number Logical Attribute Properties 
Logical Attribute Name  Receipt Generator Badge Number 
Datatype  VARCHAR(10) 
Nullable  YES 

Receipt Generator Badge Number Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Receipt Generator Badge Number Security Types 
Name  Current Value 

Receipt Generator Badge Number Bound Attachments 
Name  Current Value 

Receipt Generator Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Receipt Generator Badge Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Purchase Order Item Receipt
Receipt Generator Badge Number 
NO     

Receipt Generator Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Receipt Generator Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Receipt Generator Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Receipt Generator Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Import Indicator 
Base Entity  Purchase Order Item Receipt 
Attribute Name  Import Indicator 
Logical Rolename   
ColumnName  IMP_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
Import Indicator: Indicates the item record has been imported into Inventory Control.
 
Note 
 

Import Indicator Logical Attribute Properties 
Logical Attribute Name  Import Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Import Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Import Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

Import Indicator Security Types 
Name  Current Value 

Import Indicator Bound Attachments 
Name  Current Value 

Import Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Import Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Purchase Order Item Receipt
Import Indicator 
NO     

Import Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Import Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Import Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Import Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Goods Receipt Number 
Base Entity  Purchase Order Item Receipt 
Attribute Name  Goods Receipt Number 
Logical Rolename   
ColumnName  GOOD_REC_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Goods Receipt Number Logical Attribute Properties 
Logical Attribute Name  Goods Receipt Number 
Datatype  INTEGER 
Nullable  YES 

Goods Receipt Number Domain Restrictions 

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

Goods Receipt Number Bound Attachments 
Name  Current Value 

Goods Receipt Number Data Movement Rules 
Name  Type  Rule Text/Value 

Goods Receipt Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Purchase Order Item Receipt
Goods Receipt Number 
NO     

Goods Receipt Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Goods Receipt Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Goods Receipt Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Goods Receipt Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Goods Receipt Item Number 
Base Entity  Purchase Order Item Receipt 
Attribute Name  Goods Receipt Item Number 
Logical Rolename   
ColumnName  GOOD_REC_ITEM_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Goods Receipt Item Number Logical Attribute Properties 
Logical Attribute Name  Goods Receipt Item Number 
Datatype  INTEGER 
Nullable  YES 

Goods Receipt Item Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Goods Receipt Item Number Security Types 
Name  Current Value 

Goods Receipt Item Number Bound Attachments 
Name  Current Value 

Goods Receipt Item Number Data Movement Rules 
Name  Type  Rule Text/Value 

Goods Receipt Item Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Purchase Order Item Receipt
Goods Receipt Item Number 
NO     

Goods Receipt Item Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Goods Receipt Item Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Goods Receipt Item Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Goods Receipt Item Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description