Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADJUSTED_IND	Indicates if the item received was adjusted.	VARCHAR2(1)	CALCULATION	DECODE(FPBRCDT_ADJUST_RECEIVE_IND)	NO	NO
BILL_OF_LADING	Bill of lading number for the goods being received.	VARCHAR2(10)	FPBRCDT	FPBRCDT_BILL_OF_LADING	NO	NO
CARRIER_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	FPBRCHD	FPBRCHD_CARR_PIDM	NO	NO
COMMODITY	User-defined code associated with this commodity.	VARCHAR2(10)	FPRRCDT	FPRRCDT_COMM_CODE	NO	NO
COMMODITY_DESC	Commodity description or title.	VARCHAR2(50)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
COMPLETE_IND	Indicates if the receiving document is complete.	VARCHAR2(1)	FPBRCHD	FPBRCHD_COMPLETE_IND	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
FINAL_RECEIPT_IND	Determines if this is the last receipt for the purchase order item.	VARCHAR2(1)	CALCULATION	DECODE(FPRRCDT_PARTIAL_FINAL_IND)	NO	NO
ITEM	System-generated item number associated with the purchase order commodity.	NUMBER	FPRRCDT	FPRRCDT_ITEM	NO	NO
MAKE	Make for the fixed asset usually associated with a car.	VARCHAR2(30)	FPRRCDT	FPRRCDT_MAKE	NO	NO
MANUFACTURER	Name of the manufacturer for the fixed asset.	VARCHAR2(30)	FPRRCDT	FPRRCDT_MANUFACTURER	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
MODEL	Model number for the fixed asset.	VARCHAR2(35)	FPRRCDT	FPRRCDT_MODEL	NO	NO
PACKING_SLIP_KEY	Packing slip number generally found on the packing slip attached to goods received in the purchasing process.	VARCHAR2(15)	FPRRCDT	FPRRCDT_PACKING_SLIP	NO	NO
PURCHASE_ORDER	User-defined or system assigned one-up purchase order number issued to this vendor.	VARCHAR2(8)	FPRRCDT	FPRRCDT_POHD_CODE	NO	NO
QUANTITY_RECEIVED	Quantity received of an ordered commodity.	NUMBER	FPRRCDT	FPRRCDT_QTY_RCVD	NO	NO
QUANTITY_RECEIVED_REJECTED	Quanity received less quantity rejected for a received item.	NUMBER	CALCULATION	SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REJD)	NO	NO
QUANTITY_REJECTED	Quantity rejected of an ordered commodity.	NUMBER	FPRRCDT	FPRRCDT_QTY_REJD	NO	NO
RECEIVED_ACTIVITY_DATE	Date record was created or last updated.	DATE	FPRRCDT	FPRRCDT_ACTIVITY_DATE	NO	NO
RECEIVED_AMOUNT	Amount received for the purchased item. Used for standing orders.	NUMBER	FPRRCDT	FPRRCDT_QTY_RCVD	NO	NO
RECEIVED_DATE	Date the purchase order item was received.	DATE	FPRRCDT	FPRRCDT_RCVD_DATE	NO	NO
RECEIVED_USER_ID	Person who entered the received purchase order item.	VARCHAR2(30)	FPRRCDT	FPRRCDT_USER_ID	NO	NO
RECEIVER_DOCUMENT	Unique user defined or system assigned one-up document number for the receiving document.	VARCHAR2(8)	FPRRCDT	FPRRCDT_RCHD_CODE	NO	NO
RECEIVING_METHOD	Method used to ship from the vendor.	VARCHAR2(4)	FPBRCHD	FPBRCHD_RCMT_CODE	NO	NO
RECEIVING_METHOD_DESC	Description or title of the receiving method.	VARCHAR2(35)	FTVRCMT	FTVRCMT_DESC	NO	NO
TERMS_OF_SALE	Terms of sale regarding carrier charges, or used to determine when the seller has fullfilled his or her obligation to deliver the received item.	VARCHAR2(2)	FPRRCDT	FPRRCDT_FOB_CODE	NO	NO
TERMS_OF_SALE_DESC	Description of the terms of sale.	VARCHAR2(50)	FTVFOBS	FTVFOBS_DESC	NO	NO
TOLERANCE_OVERRIDE_IND	Determines if the user overrode tolerance checking limits.	VARCHAR2(1)				NO
TOLERANCE_SUSPENSE_IND	Indicator informing the user that the received item is being held in suspense due to a failed tolerance check on limits.	VARCHAR2(1)	FPRRCDT	FPRRCDT_SUSP_IND	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: