Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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)	NO	NO
BUYER	Identifies a purchasing buyer.	VARCHAR2(63)	FPBPOHD	FPBPOHD_BUYR_CODE	NO	NO
BUYER_NAME	Buyer name.	VARCHAR2(255)	FTVBUYR	FTVBUYR_NAME	NO	NO
COMMODITY	User-defined code associated with this commodity.	VARCHAR2(63)	FPRPODT	FPRPODT_COMM_CODE	NO	NO
COMMODITY_DESC	Commodity description or title.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ITEM	System-generated item number associated with the purchase order commodity.	NUMBER	FPRPODT	FPRPODT_ITEM	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
PURCHASE_ORDER	User-defined or system assigned one-up purchase order number issued to this vendor.	VARCHAR2(63)	FPRPODT	FPRPODT_POHD_CODE	NO	NO
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	NO NO	NO
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	NO NO	NO
QUANTITY_ORDERED	Number of units ordered.	NUMBER	FPRPODT	FPRPODT_QTY	NO	NO
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	NO NO	NO
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	NO NO	NO
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	NO NO	NO
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	NO NO	NO
REQUIRED_DATE	Date given to the vendors as a required deliver by date.	DATE	FPBPOHD	FPBPOHD_REQD_DATE	NO	NO
VENDOR_ENTITY_IND	Identifies if the vendor is a person or a non-person.	VARCHAR2(1)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS	NO	NO
VENDOR_ID	User-defined or system generated one-up number of the vendor.	VARCHAR2(63)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS	NO	NO
VENDOR_NAME	Vendor name.	VARCHAR2(255)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS	NO	NO
VENDOR_UID	System-generated unique internal indentification number used to access the vendor.	NUMBER	FPBPOHD	FPBPOHD_VEND_PIDM	NO	NO

Ver: 9.2