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

Ver: 9.2