ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
APPROVED_ITEM_AMOUNT	Calculation to determine the actual cost of an item			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.			FPBPOHD	FPBPOHD_BUYR_CODE
BUYER_NAME	Buyer name.			FTVBUYR	FTVBUYR_NAME
COMMODITY	User-defined code associated with this commodity.			FPRPODT	FPRPODT_COMM_CODE
COMMODITY_DESC	Commodity description or title.			FUNCTION	GOKODSF.F_GET_DESC
ITEM	System-generated item number associated with the purchase order commodity.			FPRPODT	FPRPODT_ITEM
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
PURCHASE_ORDER	User-defined or system assigned one-up purchase order number issued to this vendor.			FPRPODT	FPRPODT_POHD_CODE
QTY_RECEIVED_REJECTED_TO_DATE	Total of all quantities received and rejected on an ordered commodity as of today.			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.			CALCULATION FUNCTION	SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REDJ) - SUM(FPRRTRN_QTY) MFKFUNC.F_QTY_ACCEPTED
QUANTITY_ORDERED	Number of units ordered			FPRPODT	FPRPODT_QTY
QUANTITY_RECEIVED_TO_DATE	Total of all quantities received on an ordered commodity as of today.			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.			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.			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.			CALCULATION FUNCTION	SUM(FPRRCDT_AMT_RCVD) MFKFUNC.F_RECEIVED_AMOUNT
REQUIRED_DATE	Date given to the vendors as a required deliver by date.			FPBPOHD	FPBPOHD_REQD_DATE
VENDOR_ENTITY_IND	Identifies if the vendor is a person or a non-person.			FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS
VENDOR_ID	User-defined or system generated one-up number of the vendor.			FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS
VENDOR_NAME	Vendor name.			FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS
VENDOR_UID	System-generated unique internal indentification number used to access the vendor.			FPBPOHD	FPBPOHD_VEND_PIDM

Ver: 8.3