Receipt Item 
EntityType  Dependent 
Logical Entity Name  Receipt Item 
Default Table Name  Rcpt_Item 
Logical Only  NO 
Owner  EQUIP 
Definition 
Receipt Item:  Contains information regarding the quantity and test status for each item received.
 
Note 
Full Name:  Receipt Item

Contains information regarding the quantity and test status for each item received.
 

Receipt Item Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
Equip Rcpt Id(PK)(FK)    INTEGER  NO 
Equipment Receipt Identifier:  The unique identifier for an equipment receipt transaction.
 
Equip Rcpt Ver(PK)(FK)    INTEGER  NO 
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.
 
Rcpt Item Id(PK)    INTEGER  NO 
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.
 
Item Desc  Description  VARCHAR(255)  NO 
Item Description: A free form text field used identify the item received.
 
Qty Rcvd  Quantity  INTEGER  NO 
Quantity Received: The number of units received for a specific item.
 
Qty Reject  Quantity Rejected  INTEGER  YES 
Quantity Rejected: The number of units for a particular item that were rejected.  The default value is 0.
 
Accpt Test Req Ind  Indicator  CHAR(1)  NO 
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."
 
Test Inspect Stat    CHAR(4)  YES 
Test Inspection Status: Used to document whether the item inspected passed or failed the inspection.  Valid values include "pass" and "fail."
 
Cert Rcvd Ind  Indicator  CHAR(1)  NO 
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."
 
Item Cmnt  Comment  VARCHAR(2000)  YES 
Item Comment:  A free form text field used to record notes for a specific item within a receipt transaction.
 
Bldg Id(FK)    VARCHAR(10)  NO 
Building Code: The unique identifier for a building. 
 
Area Id(FK)  Default Text  VARCHAR(50)  NO 
 Area Identifier: The unique identifier for a location within a building.
 
Equip Id  Asset Identifier  VARCHAR(30)  YES 
Barcode Identifier: The barcode number associated with the item.  This field is validated manually against the Equipment table.
 
Modify Date  Modify Date  DATE  NO 
Modify Date: The date the Receipt Item record was modified.
 
Mod By Uid  Userid  VARCHAR(64)  NO 
Modified By Userid: The userid of the person who last made changes to the Receipt Item record.
 

Receipt Item Keys 
Key Name  Key Type  Keys 
recpt_item_pk  PrimaryKey  Equip Rcpt Id, Equip Rcpt Ver, Rcpt Item Id 

Receipt Item Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Equipment Receipt  Identifying  One to One or More        Equip Rcpt Id, Equip Rcpt Ver  NO 
Building Area  Non-Identifying  One To Zero or More        Bldg Id, Area Id  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

Receipt Item Check Constraints 
Check Constraint Name  CheckConstraint 

Receipt Item Object Permissions 

User/Role Name  Grantee Type  Permission Type  Action Type  Is Action Extended  Is System 
Receipt Item Security Types 
Name  Current Value 

Receipt Item Bound Attachments 
Name  Current Value 

Receipt Item Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
EQUIP.Receipt Item 
NO       
ALARM_MYSQL (MySQL)
Does Not Exist 
NO       
ALARM_ORACLE (Oracle)
Does Not Exist 
NO       
BICS (Oracle)
Does Not Exist 
NO       
BLM (Oracle)
Does Not Exist 
NO       
BYPASS_REQ (Oracle)
Does Not Exist 
NO       
CHAN_ARCH (Oracle)
Does Not Exist 
NO       
CNMS_PRPSL (Oracle)
Does Not Exist 
NO       
DIAG (Oracle)
Does Not Exist 
NO       
DIAG_MPS (Oracle)
Does Not Exist 
NO       
ENGA (Oracle)
Does Not Exist 
NO       
EPICS (Oracle)
Does Not Exist 
NO       
EQUIP (Oracle)
Does Not Exist 
NO       
EXPRESS (Oracle)
Does Not Exist 
NO       
ICS_SFTW_APPL (Oracle)
Does Not Exist 
NO       
INSTR (Oracle)
Does Not Exist 
NO       
Instrument Logbook (Oracle)
Does Not Exist 
NO       
INVT (Oracle)
Does Not Exist 
NO       
IONSRC (Oracle)
Does Not Exist 
NO       
IONSRC1 (Oracle)
Does Not Exist 
NO       
IPTSv5 (Oracle)
Does Not Exist 
NO       
IRMISBase (Oracle)
Does Not Exist 
NO       
Logbook (Oracle)
Does Not Exist 
NO       
Magnet (Oracle)
Does Not Exist 
NO       
MPS (Oracle)
Does Not Exist 
NO       
NS_OPER (Oracle)
Does Not Exist 
NO       
OPER (Oracle)
Does Not Exist 
NO       
PART (Oracle)
Does Not Exist 
NO       
PRINT (Oracle)
Does Not Exist 
NO       
PROC (Oracle)
Does Not Exist 
NO       
PRPSL (Oracle)
Does Not Exist 
NO       
PUBL (Oracle)
Does Not Exist 
NO       
PUBL_V1 (Oracle)
Does Not Exist 
NO       
PV_LOGGER (Oracle)
Does Not Exist 
NO       
SCORE (Oracle)
Does Not Exist 
NO       
SICAT (Oracle)
Does Not Exist 
NO       
SMPL (Oracle)
Does Not Exist 
NO       
SMPLACT (Oracle)
Does Not Exist 
NO       
SURVEY (Oracle)
Does Not Exist 
NO       
Watchman (Oracle)
Does Not Exist 
NO       
XAL_OPTICS (Oracle)
Does Not Exist 
NO       
XF_ADMIN (Oracle)
Does Not Exist 
NO       

Receipt Item Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Equipment 
Logical  Equipment - Equip Rcpt 

Receipt Item Data Movement Rules 
Name  Type  Rule Text/Value