EQUIP_RCPT_ID |
Base Object | RCPT_ITEM |
Attribute Name | Equip Rcpt Id |
ColumnName | EQUIP_RCPT_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Equipment Receipt Identifier: The unique identifier for an equipment receipt transaction. |
Note |
EQUIP_RCPT_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
EQUIP_RCPT_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
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 |
EQUIP (Oracle) RCPT_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 Object | RCPT_ITEM |
Attribute Name | Equip Rcpt Ver |
ColumnName | EQUIP_RCPT_VER |
Logical Rolename | |
RoleName | |
Domain | |
Physical 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 Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
EQUIP_RCPT_VER Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
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 |
EQUIP (Oracle) RCPT_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 Object | RCPT_ITEM |
Attribute Name | Rcpt Item Id |
ColumnName | RCPT_ITEM_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical 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 Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
RCPT_ITEM_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
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 |
EQUIP (Oracle) RCPT_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 Object | RCPT_ITEM |
Attribute Name | Item Desc |
ColumnName | ITEM_DESC |
Logical Rolename | |
RoleName | |
Domain | Description |
Physical Only | NO |
Definition | Item Description: A free form text field used identify the item received. |
Note |
ITEM_DESC Column Properties |
Datatype | VARCHAR2(255) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
ITEM_DESC Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
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 |
EQUIP (Oracle) RCPT_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 Object | RCPT_ITEM |
Attribute Name | Qty Rcvd |
ColumnName | QTY_RCVD |
Logical Rolename | |
RoleName | |
Domain | Quantity |
Physical Only | NO |
Definition | Quantity Received: The number of units received for a specific item. |
Note |
QTY_RCVD Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
QTY_RCVD Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
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 |
EQUIP (Oracle) RCPT_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 Object | RCPT_ITEM |
Attribute Name | Qty Reject |
ColumnName | QTY_REJECT |
Logical Rolename | |
RoleName | |
Domain | Quantity Rejected |
Physical Only | NO |
Definition | Quantity Rejected: The number of units for a particular item that were rejected. The default value is 0. |
Note |
QTY_REJECT Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | YES |
QTY_REJECT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
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 |
EQUIP (Oracle) RCPT_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 Object | RCPT_ITEM |
Attribute Name | Accpt Test Req Ind |
ColumnName | ACCPT_TEST_REQ_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical 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 Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
ACCPT_TEST_REQ_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
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 |
EQUIP (Oracle) RCPT_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 Object | RCPT_ITEM |
Attribute Name | Test Inspect Stat |
ColumnName | TEST_INSPECT_STAT |
Logical Rolename | |
RoleName | |
Domain | |
Physical 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 Column Properties |
Datatype | CHAR(4) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
TEST_INSPECT_STAT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4 |
Percent Null | 0 |
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 |
EQUIP (Oracle) RCPT_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 Object | RCPT_ITEM |
Attribute Name | Cert Rcvd Ind |
ColumnName | CERT_RCVD_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical 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 Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
CERT_RCVD_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
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 |
EQUIP (Oracle) RCPT_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 Object | RCPT_ITEM |
Attribute Name | Item Cmnt |
ColumnName | ITEM_CMNT |
Logical Rolename | |
RoleName | |
Domain | Comment |
Physical 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 Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
ITEM_CMNT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2000 |
Percent Null | 0 |
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 |
EQUIP (Oracle) RCPT_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 Object | RCPT_ITEM |
Attribute Name | Bldg Id |
ColumnName | BLDG_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Building Code: The unique identifier for a building. |
Note |
BLDG_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
BLDG_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
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 |
EQUIP (Oracle) RCPT_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 Object | RCPT_ITEM |
Attribute Name | Area Id |
ColumnName | AREA_ID |
Logical Rolename | |
RoleName | |
Domain | Default Text |
Physical Only | NO |
Definition | Area Identifier: The unique identifier for a location within a building. |
Note |
AREA_ID Column Properties |
Datatype | VARCHAR2(50) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
AREA_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
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 |
EQUIP (Oracle) RCPT_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 Object | RCPT_ITEM |
Attribute Name | Equip Id |
ColumnName | EQUIP_ID |
Logical Rolename | |
RoleName | |
Domain | Asset Identifier |
Physical Only | NO |
Definition | Barcode Identifier: The barcode number associated with the item. This field is validated manually against the Equipment table. |
Note |
EQUIP_ID Column Properties |
Datatype | VARCHAR2(30) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
EQUIP_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 11 |
Percent Null | 0 |
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 |
EQUIP (Oracle) RCPT_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 |
MOD_DTE |
Base Object | RCPT_ITEM |
Attribute Name | Modify Date |
ColumnName | MOD_DTE |
Logical Rolename | |
RoleName | |
Domain | Modify Date |
Physical Only | NO |
Definition | Modify Date: The date the Receipt Item record was modified. |
Note |
MOD_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
MOD_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
MOD_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MOD_DTE Security Types |
Name | Current Value |
MOD_DTE Bound Attachments |
Name | Current Value |
MOD_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
MOD_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EQUIP (Oracle) RCPT_ITEM MOD_DTE |
NO |
MOD_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_UID |
Base Object | RCPT_ITEM |
Attribute Name | Mod By Uid |
ColumnName | MOD_BY_UID |
Logical Rolename | |
RoleName | |
Domain | Userid |
Physical Only | NO |
Definition | Modified By Userid: The userid of the person who last made changes to the Receipt Item record. |
Note |
MOD_BY_UID Column Properties |
Datatype | VARCHAR2(64) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
MOD_BY_UID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 64 |
Percent Null | 0 |
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 |
EQUIP (Oracle) RCPT_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 |