| Equip Rcpt Id |
| Base Entity | Receipt Item |
| Attribute Name | Equip Rcpt Id |
| Logical Rolename | |
| ColumnName | Equip Rcpt Id |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Equipment Receipt Identifier: The unique identifier for an equipment receipt transaction. |
| Note |
| Equip Rcpt Id Logical Attribute Properties |
| Logical Attribute Name | Equip Rcpt Id |
| Datatype | INTEGER |
| Nullable | NO |
| Equip Rcpt Id Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Equip Rcpt Id Security Types |
| Name | Current Value |
| Equip Rcpt Id Bound Attachments |
| Name | Current Value |
| Equip Rcpt Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Equip Rcpt Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Receipt Item Equip Rcpt Id |
NO |
| Equip Rcpt Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Rcpt Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Rcpt Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Rcpt Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Rcpt Ver |
| Base Entity | Receipt Item |
| Attribute Name | Equip Rcpt Ver |
| Logical Rolename | |
| ColumnName | Equip Rcpt Ver |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Equipment Receipt Version: Indicates the version of the equipment receipt. If a receipt is changed the original information is saved and a new version is created. |
| Note |
| Equip Rcpt Ver Logical Attribute Properties |
| Logical Attribute Name | Equip Rcpt Ver |
| Datatype | INTEGER |
| Nullable | NO |
| Equip Rcpt Ver Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Equip Rcpt Ver Security Types |
| Name | Current Value |
| Equip Rcpt Ver Bound Attachments |
| Name | Current Value |
| Equip Rcpt Ver Data Movement Rules |
| Name | Type | Rule Text/Value |
| Equip Rcpt Ver Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Receipt Item Equip Rcpt Ver |
NO |
| Equip Rcpt Ver Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Rcpt Ver Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Rcpt Ver Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Rcpt Ver Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rcpt Item Id |
| Base Entity | Receipt Item |
| Attribute Name | Rcpt Item Id |
| Logical Rolename | |
| ColumnName | Rcpt Item Id |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Receipt Item Identifier: A numeric field used to represent each line item within a receipt. A line item exists for each type of equipment received. The system automatically generates this number and increments it by 1 for each line item for a given receipt. |
| Note |
| Rcpt Item Id Logical Attribute Properties |
| Logical Attribute Name | Rcpt Item Id |
| Datatype | INTEGER |
| Nullable | NO |
| Rcpt Item Id Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Rcpt Item Id Security Types |
| Name | Current Value |
| Rcpt Item Id Bound Attachments |
| Name | Current Value |
| Rcpt Item Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Rcpt Item Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Receipt Item Rcpt Item Id |
NO |
| Rcpt Item Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rcpt Item Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rcpt Item Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rcpt Item Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Item Desc |
| Base Entity | Receipt Item |
| Attribute Name | Item Desc |
| Logical Rolename | |
| ColumnName | Item Desc |
| RoleName | |
| Domain | Description |
| Logical Only | NO |
| Definition | Item Description: A free form text field used identify the item received. |
| Note |
| Item Desc Logical Attribute Properties |
| Logical Attribute Name | Item Desc |
| Datatype | VARCHAR(255) |
| Nullable | NO |
| Item Desc Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Item Desc Security Types |
| Name | Current Value |
| Item Desc Bound Attachments |
| Name | Current Value |
| Item Desc Data Movement Rules |
| Name | Type | Rule Text/Value |
| Item Desc Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Receipt Item Item Desc |
NO |
| Item Desc Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Item Desc Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Item Desc Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Item Desc Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Qty Rcvd |
| Base Entity | Receipt Item |
| Attribute Name | Qty Rcvd |
| Logical Rolename | |
| ColumnName | Qty Rcvd |
| RoleName | |
| Domain | Quantity |
| Logical Only | NO |
| Definition | Quantity Received: The number of units received for a specific item. |
| Note |
| Qty Rcvd Logical Attribute Properties |
| Logical Attribute Name | Qty Rcvd |
| Datatype | INTEGER |
| Nullable | NO |
| Qty Rcvd Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 1 |
| Bound Default |
| Qty Rcvd Security Types |
| Name | Current Value |
| Qty Rcvd Bound Attachments |
| Name | Current Value |
| Qty Rcvd Data Movement Rules |
| Name | Type | Rule Text/Value |
| Qty Rcvd Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Receipt Item Qty Rcvd |
NO |
| Qty Rcvd Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Qty Rcvd Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Qty Rcvd Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Qty Rcvd Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Qty Reject |
| Base Entity | Receipt Item |
| Attribute Name | Qty Reject |
| Logical Rolename | |
| ColumnName | Qty Reject |
| RoleName | |
| Domain | Quantity Rejected |
| Logical Only | NO |
| Definition | Quantity Rejected: The number of units for a particular item that were rejected. The default value is 0. |
| Note |
| Qty Reject Logical Attribute Properties |
| Logical Attribute Name | Qty Reject |
| Datatype | INTEGER |
| Nullable | YES |
| Qty Reject Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 0 |
| Bound Default |
| Qty Reject Security Types |
| Name | Current Value |
| Qty Reject Bound Attachments |
| Name | Current Value |
| Qty Reject Data Movement Rules |
| Name | Type | Rule Text/Value |
| Qty Reject Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Receipt Item Qty Reject |
NO |
| Qty Reject Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Qty Reject Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Qty Reject Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Qty Reject Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Accpt Test Req Ind |
| Base Entity | Receipt Item |
| Attribute Name | Accpt Test Req Ind |
| Logical Rolename | |
| ColumnName | Accpt Test Req Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Acceptance Test Required Indicator: Used to indicate if an acceptance test must be performed on the item received. Valid values include "Y" and "N." Default value is "N." |
| Note |
| Accpt Test Req Ind Logical Attribute Properties |
| Logical Attribute Name | Accpt Test Req Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| Accpt Test Req Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Accpt Test Req Ind 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 |
| Accpt Test Req Ind Security Types |
| Name | Current Value |
| Accpt Test Req Ind Bound Attachments |
| Name | Current Value |
| Accpt Test Req Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Accpt Test Req Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Receipt Item Accpt Test Req Ind |
NO |
| Accpt Test Req Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Accpt Test Req Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Accpt Test Req Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Accpt Test Req Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Test Inspect Stat |
| Base Entity | Receipt Item |
| Attribute Name | Test Inspect Stat |
| Logical Rolename | |
| ColumnName | Test Inspect Stat |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Test Inspection Status: Used to document whether the item inspected passed or failed the inspection. Valid values include "pass" and "fail." |
| Note |
| Test Inspect Stat Logical Attribute Properties |
| Logical Attribute Name | Test Inspect Stat |
| Datatype | CHAR(4) |
| Nullable | YES |
| Test Inspect Stat Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | 'N' | ||
| Bound Default |
| Test Inspect Stat Security Types |
| Name | Current Value |
| Test Inspect Stat Bound Attachments |
| Name | Current Value |
| Test Inspect Stat Data Movement Rules |
| Name | Type | Rule Text/Value |
| Test Inspect Stat Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Receipt Item Test Inspect Stat |
NO |
| Test Inspect Stat Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Test Inspect Stat Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Test Inspect Stat Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Test Inspect Stat Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cert Rcvd Ind |
| Base Entity | Receipt Item |
| Attribute Name | Cert Rcvd Ind |
| Logical Rolename | |
| ColumnName | Cert Rcvd Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Certification Received Indicator: Used to document if certification papers associated with the item received were received. Valid values are "Y' and "N." Default value is "Y." |
| Note |
| Cert Rcvd Ind Logical Attribute Properties |
| Logical Attribute Name | Cert Rcvd Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| Cert Rcvd Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Cert Rcvd Ind 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 |
| Cert Rcvd Ind Security Types |
| Name | Current Value |
| Cert Rcvd Ind Bound Attachments |
| Name | Current Value |
| Cert Rcvd Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Cert Rcvd Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Receipt Item Cert Rcvd Ind |
NO |
| Cert Rcvd Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cert Rcvd Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cert Rcvd Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cert Rcvd Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Item Cmnt |
| Base Entity | Receipt Item |
| Attribute Name | Item Cmnt |
| Logical Rolename | |
| ColumnName | Item Cmnt |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Item Comment: A free form text field used to record notes for a specific item within a receipt transaction. |
| Note |
| Item Cmnt Logical Attribute Properties |
| Logical Attribute Name | Item Cmnt |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Item Cmnt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Item Cmnt Security Types |
| Name | Current Value |
| Item Cmnt Bound Attachments |
| Name | Current Value |
| Item Cmnt Data Movement Rules |
| Name | Type | Rule Text/Value |
| Item Cmnt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Receipt Item Item Cmnt |
NO |
| Item Cmnt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Item Cmnt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Item Cmnt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Item Cmnt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Bldg Id |
| Base Entity | Receipt Item |
| Attribute Name | Bldg Id |
| Logical Rolename | |
| ColumnName | Bldg Id |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Building Code: The unique identifier for a building. |
| Note |
| Bldg Id Logical Attribute Properties |
| Logical Attribute Name | Bldg Id |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Bldg Id Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Bldg Id Security Types |
| Name | Current Value |
| Bldg Id Bound Attachments |
| Name | Current Value |
| Bldg Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Bldg Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Receipt Item Bldg Id |
NO |
| Bldg Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Bldg Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Bldg Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Bldg Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Area Id |
| Base Entity | Receipt Item |
| Attribute Name | Area Id |
| Logical Rolename | |
| ColumnName | Area Id |
| RoleName | |
| Domain | Default Text |
| Logical Only | NO |
| Definition | Area Identifier: The unique identifier for a location within a building. |
| Note |
| Area Id Logical Attribute Properties |
| Logical Attribute Name | Area Id |
| Datatype | VARCHAR(50) |
| Nullable | NO |
| Area Id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Area Id Security Types |
| Name | Current Value |
| Area Id Bound Attachments |
| Name | Current Value |
| Area Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Area Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Receipt Item Area Id |
NO |
| Area Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Area Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Area Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Area Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Id |
| Base Entity | Receipt Item |
| Attribute Name | Equip Id |
| Logical Rolename | |
| ColumnName | Equip Id |
| RoleName | |
| Domain | Asset Identifier |
| Logical Only | NO |
| Definition | Barcode Identifier: The barcode number associated with the item. This field is validated manually against the Equipment table. |
| Note |
| Equip Id Logical Attribute Properties |
| Logical Attribute Name | Equip Id |
| Datatype | VARCHAR(30) |
| Nullable | YES |
| Equip Id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Equip Id Security Types |
| Name | Current Value |
| Equip Id Bound Attachments |
| Name | Current Value |
| Equip Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Equip Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Receipt Item Equip Id |
NO |
| Equip Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date |
| Base Entity | Receipt Item |
| Attribute Name | Modify Date |
| Logical Rolename | |
| ColumnName | MOD_DATE |
| RoleName | |
| Domain | Modify Date |
| Logical Only | NO |
| Definition | Modify Date: The date the Receipt Item record was 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 Receipt Item Modify 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 |
| Mod By Uid |
| Base Entity | Receipt Item |
| Attribute Name | Mod By Uid |
| Logical Rolename | |
| ColumnName | Mod By Uid |
| RoleName | |
| Domain | Userid |
| Logical Only | NO |
| Definition | Modified By Userid: The userid of the person who last made changes to the Receipt Item record. |
| Note |
| Mod By Uid Logical Attribute Properties |
| Logical Attribute Name | Mod By Uid |
| Datatype | VARCHAR(64) |
| Nullable | NO |
| Mod By Uid Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Mod By Uid Security Types |
| Name | Current Value |
| Mod By Uid Bound Attachments |
| Name | Current Value |
| Mod By Uid Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mod By Uid Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Receipt Item Mod By Uid |
NO |
| Mod By Uid Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod By Uid Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod By Uid Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod By Uid Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |