Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADJUSTED_IND	Indicates if the item received was adjusted.	VARCHAR2(1)	CALCULATION	DECODE(FPBRCDT_ADJUST_RECEIVE_IND)
BILL_OF_LADING	Bill of lading number for the goods being received.	VARCHAR2(10)	FPBRCDT	FPBRCDT_BILL_OF_LADING
CARRIER_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	FPBRCHD	FPBRCHD_CARR_PIDM
COMMODITY	User-defined code associated with this commodity.	VARCHAR2(10)	FPRRCDT	FPRRCDT_COMM_CODE
COMMODITY_DESC	Commodity description or title.	VARCHAR2(50)	FUNCTION	GOKODSF.F_GET_DESC
COMPLETE_IND	Indicates if the receiving document is complete.	VARCHAR2(1)	FPBRCHD	FPBRCHD_COMPLETE_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
FINAL_RECEIPT_IND	Determines if this is the last receipt for the purchase order item.	VARCHAR2(1)	CALCULATION	DECODE(FPRRCDT_PARTIAL_FINAL_IND)
ITEM	System-generated item number associated with the purchase order commodity.	NUMBER	FPRRCDT	FPRRCDT_ITEM
MAKE	Make for the fixed asset usually associated with a car.	VARCHAR2(30)	FPRRCDT	FPRRCDT_MAKE
MANUFACTURER	Name of the manufacturer for the fixed asset.	VARCHAR2(30)	FPRRCDT	FPRRCDT_MANUFACTURER
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
MODEL	Model number for the fixed asset.	VARCHAR2(35)	FPRRCDT	FPRRCDT_MODEL
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
PURCHASE_ORDER	User-defined or system assigned one-up purchase order number issued to this vendor.	VARCHAR2(8)	FPRRCDT	FPRRCDT_POHD_CODE
QUANTITY_RECEIVED	Quantity received of an ordered commodity.	NUMBER	FPRRCDT	FPRRCDT_QTY_RCVD
QUANTITY_RECEIVED_REJECTED	Quanity received less quantity rejected for a received item.	NUMBER	CALCULATION	SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REJD)
QUANTITY_REJECTED	Quantity rejected of an ordered commodity.	NUMBER	FPRRCDT	FPRRCDT_QTY_REJD
RECEIVED_ACTIVITY_DATE	Date record was created or last updated.	DATE	FPRRCDT	FPRRCDT_ACTIVITY_DATE
RECEIVED_AMOUNT	Amount received for the purchased item. Used for standing orders.	NUMBER	FPRRCDT	FPRRCDT_QTY_RCVD
RECEIVED_DATE	Date the purchase order item was received.	DATE	FPRRCDT	FPRRCDT_RCVD_DATE
RECEIVED_USER_ID	Person who entered the received purchase order item.	VARCHAR2(30)	FPRRCDT	FPRRCDT_USER_ID
RECEIVER_DOCUMENT	Unique user defined or system assigned one-up document number for the receiving document.	VARCHAR2(8)	FPRRCDT	FPRRCDT_RCHD_CODE
RECEIVING_METHOD	Method used to ship from the vendor.	VARCHAR2(4)	FPBRCHD	FPBRCHD_RCMT_CODE
RECEIVING_METHOD_DESC	Description or title of the receiving method.	VARCHAR2(35)	FTVRCMT	FTVRCMT_DESC
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
TERMS_OF_SALE_DESC	Description of the terms of sale.	VARCHAR2(50)	FTVFOBS	FTVFOBS_DESC
TOLERANCE_OVERRIDE_IND	Determines if the user overrode tolerance checking limits.	VARCHAR2(1)
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
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: