RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

SGHE 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 Definition Database Data Type Source Name Source Column
ADJUSTED_IND Indicates if the item received was adjusted. VARCHAR2(1)

CALCULATION

DECODE(FPBRCDT_ADJUST_RECEIVE_IND)

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 number for the goods being received. VARCHAR2(63)

FPBRCDT

FPBRCDT_BILL_OF_LADING

CARRIER_ENTITY_IND 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 User-defined or system generated one-up number of the carrier. VARCHAR2(63)

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

CARRIER_NAME Carrier's name. VARCHAR2(255)

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

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

FPBRCHD

FPBRCHD_CARR_PIDM

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

FPRRCDT

FPRRCDT_COMM_CODE

COMMODITY_DESC Commodity description or title. VARCHAR2(255)

CALCULATION

NVL(FPRRCDT_COMM_DESC)

COMPLETE_IND Indicates if the receiving document is complete. VARCHAR2(1)

FPBRCHD

FPBRCHD_COMPLETE_IND

FINAL_RECEIPT_IND Determines if this is the last receipt for the purchase order item. VARCHAR2(1)

CALCULATION

DECODE(FPRRCDT_PARTIAL_FINAL_IND)

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

FPRRCDT

FPRRCDT_ITEM

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

FPRRCDT

FPRRCDT_MAKE

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

FPRRCDT

FPRRCDT_MANUFACTURER

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

FPRRCDT

FPRRCDT_MODEL

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

NA

NA

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

NA

NA

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-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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 of an ordered commodity. NUMBER

FPRRCDT

FPRRCDT_QTY_RCVD

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 of an ordered commodity. NUMBER

FPRRCDT

FPRRCDT_QTY_REJD

QUANTITY_RETURNED Quantity being returned on an ordered commodity. NUMBER

FPRRTRN

FUNCTION

FPRRTRN_QTY

MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID

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

FPRRCDT

FPRRCDT_AMT_RCVD

RECEIVED_DATE Date the purchase order item was received. DATE

FPRRCDT

FPRRCDT_RCVD_DATE

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

FPRRCDT

FPRRCDT_USER_ID

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

FPRRCDT

FPRRCDT_RCHD_CODE

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

FPBRCHD

FPBRCHD_RCMT_CODE

RECEIVING_METHOD_DESC Receiving method description or title. VARCHAR2(255)

FTVRCMT

FTVRCMT_DESC

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 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 or title. VARCHAR2(255)

FTVRRSN

FUNCTION

FTVRRSN_DESC

MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID

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 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 Unit of measure description. VARCHAR2(255)

FTVUOMS

FUNCTION

FTVUOMS_DESC

MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID

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. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TOLERANCE_OVERRIDE_IND Determine if the user override tolerance checking limits. VARCHAR2(1)

CALCULATION

NVL(FPRRCDT_TOL_OVERRIDE_IND)

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

FPRRCDT

FPRRCDT_SUSP_IND



Ver: 3.1