Purchase Order Item Number |
Base Entity | Purchase Order History |
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 History Purchase Order Item Number |
NO | ||
INVT (Oracle) PO_HIST 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 |
Purchase Order Number |
Base Entity | Purchase Order History |
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 History Purchase Order Number |
NO | ||
INVT (Oracle) PO_HIST 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 |
Current Date |
Base Entity | Purchase Order History |
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 History Current Date |
NO | ||
INVT (Oracle) PO_HIST CUR_DTE |
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 |
Description |
Base Entity | Purchase Order History |
Attribute Name | Description |
Logical Rolename | |
ColumnName | DESCR |
RoleName | |
Domain | Description |
Logical Only | NO |
Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
Note |
Description Logical Attribute Properties |
Logical Attribute Name | Description |
Datatype | VARCHAR(255) |
Nullable | YES |
Description Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Description Security Types |
Name | Current Value |
Description Bound Attachments |
Name | Current Value |
Description Data Movement Rules |
Name | Type | Rule Text/Value |
Description Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Purchase Order History Description |
NO | ||
INVT (Oracle) PO_HIST DESCR |
NO |
Description Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Description Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Description Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Description Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Purchase Order Item Quantity |
Base Entity | Purchase Order History |
Attribute Name | Purchase Order Item Quantity |
Logical Rolename | |
ColumnName | PO_ITEM_QTY |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Purchase Order Item Quantity Logical Attribute Properties |
Logical Attribute Name | Purchase Order Item Quantity |
Datatype | INTEGER |
Nullable | YES |
Purchase Order Item Quantity Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Purchase Order Item Quantity Security Types |
Name | Current Value |
Purchase Order Item Quantity Bound Attachments |
Name | Current Value |
Purchase Order Item Quantity Data Movement Rules |
Name | Type | Rule Text/Value |
Purchase Order Item Quantity Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Purchase Order History Purchase Order Item Quantity |
NO | ||
INVT (Oracle) PO_HIST PO_ITEM_QTY |
NO |
Purchase Order Item Quantity Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Purchase Order Item Quantity Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Purchase Order Item Quantity Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Purchase Order Item Quantity Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Purchase Request Number |
Base Entity | Purchase Order History |
Attribute Name | Purchase Request Number |
Logical Rolename | |
ColumnName | PR_NBR |
RoleName | |
Domain | Purchase Request Number |
Logical Only | NO |
Definition | |
Note |
Purchase Request Number Logical Attribute Properties |
Logical Attribute Name | Purchase Request Number |
Datatype | VARCHAR(25) |
Nullable | NO |
Purchase Request Number Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Purchase Request Number Security Types |
Name | Current Value |
Purchase Request Number Bound Attachments |
Name | Current Value |
Purchase Request Number Data Movement Rules |
Name | Type | Rule Text/Value |
Purchase Request Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Purchase Order History Purchase Request Number |
NO | ||
INVT (Oracle) PO_HIST PR_NBR |
NO |
Purchase Request Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Purchase Request Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Purchase Request Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Purchase Request Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Purchase Request Item Number |
Base Entity | Purchase Order History |
Attribute Name | Purchase Request Item Number |
Logical Rolename | |
ColumnName | PR_ITEM_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Purchase Request Item Number Logical Attribute Properties |
Logical Attribute Name | Purchase Request Item Number |
Datatype | INTEGER |
Nullable | YES |
Purchase Request Item Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Purchase Request Item Number Security Types |
Name | Current Value |
Purchase Request Item Number Bound Attachments |
Name | Current Value |
Purchase Request Item Number Data Movement Rules |
Name | Type | Rule Text/Value |
Purchase Request Item Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Purchase Order History Purchase Request Item Number |
NO | ||
INVT (Oracle) PO_HIST PR_ITEM_NBR |
NO |
Purchase Request Item Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Purchase Request Item Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Purchase Request Item Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Purchase Request Item Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Technical Project Officer Badge Number |
Base Entity | Purchase Order History |
Attribute Name | Technical Project Officer Badge Number |
Logical Rolename | |
ColumnName | TPO_BN |
RoleName | |
Domain | Badge Number |
Logical Only | NO |
Definition | |
Note |
Technical Project Officer Badge Number Logical Attribute Properties |
Logical Attribute Name | Technical Project Officer Badge Number |
Datatype | VARCHAR(10) |
Nullable | YES |
Technical Project Officer Badge Number Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Technical Project Officer Badge Number Security Types |
Name | Current Value |
Technical Project Officer Badge Number Bound Attachments |
Name | Current Value |
Technical Project Officer Badge Number Data Movement Rules |
Name | Type | Rule Text/Value |
Technical Project Officer Badge Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Purchase Order History Technical Project Officer Badge Number |
NO | ||
INVT (Oracle) PO_HIST TPO_BN |
NO |
Technical Project Officer Badge Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Technical Project Officer Badge Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Technical Project Officer Badge Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Technical Project Officer Badge Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Goods Recipient Badge Number |
Base Entity | Purchase Order History |
Attribute Name | Goods Recipient Badge Number |
Logical Rolename | |
ColumnName | GOOD_RECPT_BN |
RoleName | |
Domain | Badge Number |
Logical Only | NO |
Definition | |
Note |
Goods Recipient Badge Number Logical Attribute Properties |
Logical Attribute Name | Goods Recipient Badge Number |
Datatype | VARCHAR(10) |
Nullable | YES |
Goods Recipient Badge Number Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Goods Recipient Badge Number Security Types |
Name | Current Value |
Goods Recipient Badge Number Bound Attachments |
Name | Current Value |
Goods Recipient Badge Number Data Movement Rules |
Name | Type | Rule Text/Value |
Goods Recipient Badge Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Purchase Order History Goods Recipient Badge Number |
NO | ||
INVT (Oracle) PO_HIST GOOD_RECPT_BN |
NO |
Goods Recipient Badge Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Goods Recipient Badge Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Goods Recipient Badge Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Goods Recipient Badge Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Building Identifier |
Base Entity | Purchase Order History |
Attribute Name | Building Identifier |
Logical Rolename | |
ColumnName | BLDG_ID |
RoleName | |
Domain | Building |
Logical Only | NO |
Definition | Building: The building number. |
Note |
Building Identifier Logical Attribute Properties |
Logical Attribute Name | Building Identifier |
Datatype | VARCHAR(10) |
Nullable | YES |
Building Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Building Identifier Security Types |
Name | Current Value |
Building Identifier Bound Attachments |
Name | Current Value |
Building Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Building Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Purchase Order History Building Identifier |
NO | ||
INVT (Oracle) PO_HIST BLDG_ID |
NO |
Building Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Building Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Building Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Building Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Location |
Base Entity | Purchase Order History |
Attribute Name | Location |
Logical Rolename | |
ColumnName | LOC |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Location Logical Attribute Properties |
Logical Attribute Name | Location |
Datatype | VARCHAR(100) |
Nullable | YES |
Location Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Location Security Types |
Name | Current Value |
Location Bound Attachments |
Name | Current Value |
Location Data Movement Rules |
Name | Type | Rule Text/Value |
Location Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Purchase Order History Location |
NO | ||
INVT (Oracle) PO_HIST LOC |
NO |
Location Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Location Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Location Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Location Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |