Purchase Order Number |
Base Entity | Purchase Order |
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 Purchase Order Number |
NO | ||
INVT (Oracle) PO 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 | Purchase Order |
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 Purchase Order Item Number |
NO | ||
INVT (Oracle) PO 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 |
Description |
Base Entity | Purchase Order |
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 Description |
NO | ||
INVT (Oracle) PO 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 |
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 Purchase Order Item Quantity |
NO | ||
INVT (Oracle) PO 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 |
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 Purchase Request Number |
NO | ||
INVT (Oracle) PO 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 |
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 Purchase Request Item Number |
NO | ||
INVT (Oracle) PO 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 |
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 Technical Project Officer Badge Number |
NO | ||
INVT (Oracle) PO 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 |
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 Goods Recipient Badge Number |
NO | ||
INVT (Oracle) PO 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 |
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 Building Identifier |
NO | ||
INVT (Oracle) PO 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 |
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 Location |
NO | ||
INVT (Oracle) PO 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 |
Modify Date |
Base Entity | Purchase Order |
Attribute Name | Modify Date |
Logical Rolename | |
ColumnName | MOD_DATE |
RoleName | |
Domain | Modify Date |
Logical Only | NO |
Definition | Modify Date: The date the entity values were were created or modified. |
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 | |
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 Purchase Order Modify Date |
NO | ||
INVT (Oracle) PO MOD_DATE |
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 |
Closed Indicator |
Base Entity | Purchase Order |
Attribute Name | Closed Indicator |
Logical Rolename | |
ColumnName | CLOSED_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Closed Indicator Logical Attribute Properties |
Logical Attribute Name | Closed Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Closed Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Closed 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 |
Closed Indicator Security Types |
Name | Current Value |
Closed Indicator Bound Attachments |
Name | Current Value |
Closed Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Closed Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Purchase Order Closed Indicator |
NO | ||
INVT (Oracle) PO CLOSED_IND |
NO |
Closed Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Closed Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Closed Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Closed Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |