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

SGHE Banner Operational Data Store
Reporting View Target: PURCHASE_ORDER_ITEM_SUMMARY

Description Contains received purchase order item summary information.
Key & Frequency One row per purchase order per item received.
Recommended Search Columns PURCHASE_ORDER, ITEM

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

APPROVED_ITEM_AMOUNT Calculation to determine the actual cost of an item. NUMBER

CALCULATION

(NVL(FPRPODT_QTY,0)*NVL(FPRPODT_UNIT_PRICE,0))+NVL(FPRPODT_ADDL_CHRG_AMT,0)+NVL(FPRPODT_TAX_AMT,0)-NVL(FPRPODT_DISC_AMT,0)

BUYER Identifies a purchasing buyer. VARCHAR2(63)

FPBPOHD

FPBPOHD_BUYR_CODE

BUYER_NAME Buyer name. VARCHAR2(255)

FTVBUYR

FTVBUYR_NAME

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

FPRPODT

FPRPODT_COMM_CODE

COMMODITY_DESC Commodity description or title. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FPRPODT

FPRPODT_ITEM

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

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)

FPRPODT

FPRPODT_POHD_CODE

QTY_RECEIVED_REJECTED_TO_DATE Total of all quantities received and rejected on an ordered commodity as of today. NUMBER

CALCULATION

FUNCTION

SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REJD)

MFKFUNC.F_QTY_RECEIVED_REJECTED

QUANTITY_ACCEPTED_TO_DATE Total of all quantities being received, rejected and returned on a purchase order item as of today. NUMBER

CALCULATION

FUNCTION

SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REDJ) - SUM(FPRRTRN_QTY)

MFKFUNC.F_QTY_ACCEPTED

QUANTITY_ORDERED Number of units ordered. NUMBER

FPRPODT

FPRPODT_QTY

QUANTITY_RECEIVED_TO_DATE Total of all quantities received on an ordered commodity as of today. NUMBER

CALCULATION

FUNCTION

SUM(FPRRCDT_QTY_RCVD)

MFKFUNC.F_QTY_RECEIVED

QUANTITY_REJECTED_TO_DATE Total of all quantities rejected on an ordered commodity as of today. NUMBER

CALCULATION

FUNCTION

SUM(FPRRCDT_QTY_RCVD)

MFKFUNC.F_QTY_REJECTED

QUANTITY_RETURNED_TO_DATE Total of all quantities being returned on an ordered commodity as of today. NUMBER

CALCULATION

FUNCTION

SUM(FPRRTRN_QTY)

MFKFUNC.F_QTY_RETURNED

RECEIVED_AMOUNT_TO_DATE Total amount received for the purchased item as of today. Used for standing orders. NUMBER

CALCULATION

FUNCTION

SUM(FPRRCDT_AMT_RCVD)

MFKFUNC.F_RECEIVED_AMOUNT

REQUIRED_DATE Date given to the vendors as a required deliver by date. DATE

FPBPOHD

FPBPOHD_REQD_DATE

VENDOR_ENTITY_IND Identifies if the vendor is a person or a non-person. VARCHAR2(1)

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

VENDOR_ID User-defined or system generated one-up number of the vendor. VARCHAR2(63)

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

VENDOR_NAME Vendor name. VARCHAR2(255)

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

VENDOR_UID System-generated unique internal indentification number used to access the vendor. NUMBER

FPBPOHD

FPBPOHD_VEND_PIDM



Ver: 8.5