Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
APPROVED_ITEM_AMOUNT	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	Buyer	Identifies a purchasing buyer.	VARCHAR2(63)		FPBPOHD	FPBPOHD_BUYR_CODE
BUYER_NAME	Buyer Name	Buyer name.	VARCHAR2(255)		FTVBUYR	FTVBUYR_NAME
COMMODITY	Commodity	User-defined code associated with this commodity.	VARCHAR2(63)		FPRPODT	FPRPODT_COMM_CODE
COMMODITY_DESC	Commodity Description	Commodity description or title.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
ITEM	Item	System-generated item number associated with the purchase order commodity.	NUMBER		FPRPODT	FPRPODT_ITEM
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
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)		FPRPODT	FPRPODT_POHD_CODE
QTY_RECEIVED_REJECTED_TO_DATE	Quantity 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	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	Quantity Ordered	Number of units ordered	NUMBER		FPRPODT	FPRPODT_QTY
QUANTITY_RECEIVED_TO_DATE	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	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	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	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	Required Date	Date given to the vendors as a required deliver by date.	DATE		FPBPOHD	FPBPOHD_REQD_DATE
VENDOR_ENTITY_IND	Vendor Entity Ind	Identifies if the vendor is a person or a non-person.	VARCHAR2(1)		FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS
VENDOR_ID	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	Vendor name.	VARCHAR2(255)		FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS
VENDOR_UID	Vendor UID	System-generated unique internal indentification number used to access the vendor.	NUMBER		FPBPOHD	FPBPOHD_VEND_PIDM

Ver: 9.0