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 |
Y | Yes |
N | 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 |