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

Ver: 9.1