Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: RECEIVED_ITEM

Description Contains received purchase order item information including packing slip, receiving method, carrier, received date, quantity received, and quantity rejected.
Key & Frequency One row per receiver document per packing slip per purchase order per item.
Recommended Search Columns RECEIVER_DOCUMENT, PURCHASE_ORDER, PACKING_SLIP_KEY, ITEM
PURCHASE_ORDER, ITEM
RECEIVED_DATE
COMMODITY
RETURN_DOCUMENT, PURCHASE_ORDER, ITEM, RETURN_SEQUENCE_NUMBER
RETURN_REASON

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ADJUSTED_IND Adjusted Indicator Indicates if the item received was adjusted. VARCHAR2(63)  

CALCULATION

DECODE(FPBRCDT_ADJUST_RECEIVE_IND)

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

BILL_OF_LADING Bill Of Lading Bill of lading number for the goods being received. VARCHAR2(63)  

FPBRCDT

FPBRCDT_BILL_OF_LADING

CARRIER_ENTITY_IND Carrier Entity Indicator Identifies if the carrier is a person or a non-person. VARCHAR2(1)  

FUNCTION

SPRIDEN

MFKFUNC.F_GET_VENDOR_FIELDS

SPRIDEN_ENTITY_IND

CARRIER_ID Carrier ID User-defined or system generated one-up number of the carrier. VARCHAR2(63)  

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

CARRIER_NAME Carrier Name Carrier's name. VARCHAR2(255)  

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

CARRIER_UID Carrier UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER  

FPBRCHD

FPBRCHD_CARR_PIDM

COMMODITY Commodity User-defined code associated with this commodity. VARCHAR2(63)  

FPRRCDT

FPRRCDT_COMM_CODE

COMMODITY_DESC Commodity Description Commodity description or title. VARCHAR2(255)  

FPRRCDT

FUNCTION

FPRRCDT_COMM_DESC

GOKODSF.F_GET_DESC

COMPLETE_IND Complete Indicator Indicates if the receiving document is complete. VARCHAR2(63)  

FPBRCHD

FPBRCHD_COMPLETE_IND

FINAL_RECEIPT_IND Final Receipt Indicator Determines if this is the last receipt for the purchase order item. VARCHAR2(63)  

CALCULATION

DECODE(FPRRCDT_PARTIAL_FINAL_IND)

ITEM Item System-generated item number associated with the purchase order commodity. NUMBER  

FPRRCDT

FPRRCDT_ITEM

MAKE Make Make for the fixed asset usually associated with a car. VARCHAR2(255)  

FPRRCDT

FPRRCDT_MAKE

MANUFACTURER Manufacturer Name of the manufacturer for the fixed asset. VARCHAR2(255)  

FPRRCDT

FPRRCDT_MANUFACTURER

MODEL Model Model number for the fixed asset. VARCHAR2(255)  

FPRRCDT

FPRRCDT_MODEL

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)  

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)  

NA

NA

PACKING_SLIP_KEY Packing Slip KEY Packing slip number generally found on the packing slip attached to goods received in the purchasing process. VARCHAR2(63)  

FPRRCDT

FPRRCDT_PACKING_SLIP

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

PURCHASE_ORDER Purchase Order User-defined or system assigned one-up purchase order number issued to this vendor. VARCHAR2(63)  

FPRRCDT

FPRRCDT_POHD_CODE

QUANTITY_RECEIVED Quantity Received Quantity received of an ordered commodity. NUMBER  

FPRRCDT

FPRRCDT_QTY_RCVD

QUANTITY_RECEIVED_REJECTED Quantity Received Rejected Quanity received less quantity rejected for a received item. NUMBER  

CALCULATION

SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REJD)

QUANTITY_REJECTED Quantity Rejected Quantity rejected of an ordered commodity. NUMBER  

FPRRCDT

FPRRCDT_QTY_REJD

QUANTITY_RETURNED Quantity Returned Quantity being returned on an ordered commodity. NUMBER  

FPRRTRN

FUNCTION

FPRRTRN_QTY

MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID

RECEIVED_AMOUNT Received Amount Amount received for the purchased item. Used for standing orders. NUMBER  

FPRRCDT

FPRRCDT_AMT_RCVD

RECEIVED_DATE Received Date Date the purchase order item was received. DATE  

FPRRCDT

FPRRCDT_RCVD_DATE

RECEIVED_USER_ID Received User ID Person who entered the received purchase order item. VARCHAR2(63)  

FPRRCDT

FPRRCDT_USER_ID

RECEIVER_DOCUMENT Receiver Document Unique user defined or system assigned one-up document number for the receiving document. VARCHAR2(63)  

FPRRCDT

FPRRCDT_RCHD_CODE

RECEIVING_METHOD Receiving Method Method used to ship from the vendor. VARCHAR2(63)  

FPBRCHD

FPBRCHD_RCMT_CODE

RECEIVING_METHOD_DESC Receiving Method Description Receiving method description or title. VARCHAR2(255)  

FTVRCMT

FTVRCMT_DESC

RETURN_DOCUMENT Return Document System-generated or user-specified number associated with this return to a vendor. VARCHAR2(63)  

FPRRTRN

FUNCTION

FPRRTRN_CODE

MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID

RETURN_REASON Return Reason User-specified code that defines the reason for the return such as damaged goods or wrong item. VARCHAR2(63)  

FPRRTRN

FUNCTION

FPRRTRN_RRSN_CODE

MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID

RETURN_REASON_DESC Return Reason Description Return reason description or title. VARCHAR2(255)  

FTVRRSN

FUNCTION

FTVRRSN_DESC

MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID

RETURN_SEQUENCE_NUMBER Return Sequence Number Numeric value of each accounting line item associated with the return document. NUMBER  

FPRRTRN

FUNCTION

FPRRTRN_SEQ_NUM

MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID

RETURN_UNIT_OF_MEASURE Return Unit Of Measure Unit-of-measure applicable to the returned commodity. VARCHAR2(63)  

FPRRTRN

FUNCTION

FPRRTRN_UOMS_CODE

MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID

RETURN_UNIT_OF_MEASURE_DESC Return Unit Of Measure Description Unit of measure description. VARCHAR2(255)  

FTVUOMS

FUNCTION

FTVUOMS_DESC

MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID

TERMS_OF_SALE Terms Of Sale Terms of sale regarding carrier charges, or used to determine when the seller has fullfilled his or her obligation to deliver the received item. VARCHAR2(63)  

FPRRCDT

FPRRCDT_FOB_CODE

TERMS_OF_SALE_DESC Terms Of Sale Description Terms of sale description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

TOLERANCE_OVERRIDE_IND Tolerance Override Indicator Determine if the user override tolerance checking limits. VARCHAR2(63)  

CALCULATION

NVL(FPRRCDT_TOL_OVERRIDE_IND)

TOLERANCE_SUSPENSE_IND Tolerance Suspense Indicator Inform the user that the received item is being held in suspense due to a failed tolerance check on limits. VARCHAR2(63)  

FPRRCDT

FPRRCDT_SUSP_IND



Ver: 9.0