Target Column	Business Definition	Database Data Type	Source Name	Source Column
BILL_OF_LADING	Bill of lading number for the goods being received.	VARCHAR2(10)	FPBRTRN	FPBRTRN_BILL_OF_LADING
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(10)	FPRRTRN	FPRRTRN_COMM_CODE
COMMODITY_DESC	Commodity description or title.	VARCHAR2(50)	FPRRTRN FTVCOMM	FPRRTRN_COMM_DESC FTVCOMM_DESC
COMMODITY_DESC_CHANGED_IND	Determines if the ordered system commodity description was changed.	VARCHAR2(1)	FPRRTRN	FPRRTRN_DESC_CHGE_IND
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
ITEM	System-generated item number associated with the purchase order commodity.	NUMBER	FPRRTRN	FPRRTRN_ITEM
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
PURCHASE_ORDER	User-defined or system assigned one-up purchase order number issued to this vendor.	VARCHAR2(8)	FPRRTRN	FPRRTRN_POHD_CODE
QUANTITY_RETURNED	Quantity being returned on an ordered commodity.	NUMBER	FPRRTRN	FPRRTRN_QTY
RETURN_ACTIVITY_DATE	Date returned item record was created or last updated.	DATE	FPRRTRN	FPRRTRN_ACTIVITY_DATE
RETURN_ADDRESS_TYPE	Address type of the destination address for the vendor.	VARCHAR2(2)	FPBRTRN	FPBRTRN_ATYP_CODE_DEST
RETURN_ADDRESS_TYPE_NUMBER	Sequence number of the destination address for the vendor.	NUMBER	FPBRTRN	FPBRTRN_ATYP_SEQNO
RETURN_DOCUMENT	System-generated or user-specified number associated with this return to a vendor.	VARCHAR2(8)	FPRRTRN	FPRRTRN_CODE
RETURN_REASON	User-specified code that defines the reason for the return such as damaged goods or wrong item.	VARCHAR2(4)	FPRRTRN	FPRRTRN_RRSN_CODE
RETURN_REASON_DESC	return reason description or title.	VARCHAR2(35)	FTVRRSN	FTVRRSN_DESC
RETURN_SEQUENCE_NUMBER	System-generated one-up number within the return document assigned to each item returned.	NUMBER	FPRRTRN	FPRRTRN_SEQ_NUM
RETURN_UNIT_OF_MEASURE	Unit-of-measure applicable tothe returned commodity.	VARCHAR2(3)	FPRRTRN	FPRRTRN_UOMS_CODE
RETURN_UNIT_OF_MEASURE_DESC	Unit of measure description or title.	VARCHAR2(35)	FTVUOMS	FTVUOMS_DESC
RETURN_USER_ID	Person who entered the returned purchase order item.	VARCHAR2(30)	FPRRTRN	FPRRTRN_USER_ID
UNIT_PRICE	Unit price for goods and or services.	NUMBER	FPRRTRN	FPRRTRN_UNIT_PRICE
VENDOR_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	FPBRTRN	FPBRTRN_VEND_PIDM
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: