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
BILL_OF_LADING	Bill of lading number for the goods being received.	VARCHAR2(63)	FPBRTRN	FPBRTRN_BILL_OF_LADING	NO	NO
CARRIER_ENTITY_IND	Identifies if the carrier is a person or a non-person.	VARCHAR2(1)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS	NO	NO
CARRIER_ID	User-defined or system generated one-up number of the carrier.	VARCHAR2(63)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS	NO	NO
CARRIER_NAME	Name of the carrier.	VARCHAR2(255)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS	NO	NO
CARRIER_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	FPBRTRN	FPBRTRN_CARR_PIDM	NO	NO
COMMODITY	User-defined code associated with this commodity.	VARCHAR2(63)	FPRRTRN	FPRRTRN_COMM_CODE	NO	NO
COMMODITY_DESC	Commodity description or title.	VARCHAR2(255)	FPRRTRN	FPRRTRN_COMM_DESC	NO	NO
COMMODITY_DESC_CHANGED_IND	Determines if the ordered system commodity description was changed.	VARCHAR2(63)	FPRRTRN	FPRRTRN_DESC_CHGE_IND	NO	NO
ITEM	System-generated item number associated with the purchase order commodity.	NUMBER	FPRRTRN	FPRRTRN_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)	FPRRTRN	FPRRTRN_POHD_CODE	NO	NO
QUANTITY_RETURNED	Quantity being returned on an ordered commodity.	NUMBER	FPRRTRN	FPRRTRN_QTY	NO	NO
RETURN_CARRIER_ROUTE	Address carrier route.	VARCHAR2(4)	SPRADDR	SPRADDR_CARRIER_ROUTE	NO	NO
RETURN_CITY	City, town or municipality associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY	NO	NO
RETURN_CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.	NUMBER	SPRADDR	SPRADDR_CORRECTION_DIGIT	NO	NO
RETURN_COUNTY	County for this address record.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE	NO	NO
RETURN_COUNTY_DESC	Name of the county in the address.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
RETURN_DELIVERY_POINT	Delivery point associated with the address for barcode mailings.	NUMBER	SPRADDR	SPRADDR_DELIVERY_POINT	NO	NO
RETURN_DOCUMENT	System-generated or user-specified number associated with this return to a vendor.	VARCHAR2(63)	FPRRTRN	FPRRTRN_CODE	NO	NO
RETURN_NATION	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE	NO	NO
RETURN_NATION_DESC	Description for the nation/country associated with the address.	VARCHAR2(255)	STVNATN	STVNATN_NATION	NO	NO
RETURN_POSTAL_CODE	Postal code associated with the order from address.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP	NO	NO
RETURN_REASON	User-specified code that defines the reason for the return such as damaged goods or wrong item.	VARCHAR2(63)	FPRRTRN	FPRRTRN_RRSN_CODE	NO	NO
RETURN_REASON_DESC	Return reason description or title.	VARCHAR2(255)	FTVRRSN	FTVRRSN_DESC	NO	NO
RETURN_SEQUENCE_NUMBER	Sysetm-generated one up number within return document assigned to each item returned.	NUMBER	FPRRTRN	FPRRTRN_SEQ_NUM	NO	NO
RETURN_STATE_PROVINCE	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE	NO	NO
RETURN_STATE_PROVINCE_DESC	Name of the state/province.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
RETURN_STREET_LINE1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1	NO	NO
RETURN_STREET_LINE2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2	NO	NO
RETURN_STREET_LINE3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3	NO	NO
RETURN_STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4	NO	NO
RETURN_UNIT_OF_MEASURE	Unit-of-measure applicable to the returned commodity.	VARCHAR2(63)	FPRRTRN	FPRRTRN_UOMS_CODE	NO	NO
RETURN_UNIT_OF_MEASURE_DESC	Unit of measure description or title.	VARCHAR2(255)	FTVUOMS	FTVUOMS_DESC	NO	NO
RETURN_USER_ID	Person that entered the returned purchase order item.	VARCHAR2(63)	FPRRTRN	FPRRTRN_USER_ID	NO	NO
UNIT_PRICE	Unit price for goods and or services.	NUMBER	FPRRTRN	FPRRTRN_UNIT_PRICE	NO	NO
VENDOR_ENTITY_IND	This field identifiesif 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	Name of the vendor.	VARCHAR2(255)	FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS	NO	NO
VENDOR_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	FPBRTRN	FPBRTRN_VEND_PIDM	NO	NO

Ver: 9.2