Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADJUSTED_IND	Adjusted Indicator	Indicates if the item received was adjusted.	VARCHAR2(63)	CALCULATION	DECODE(FPBRCDT_ADJUST_RECEIVE_IND)
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)	FPBRCDT	FPBRCDT_BILL_OF_LADING
CARRIER_ENTITY_IND	Carrier Entity Indicator	Identifies if the carrier is a person or a non-person.	VARCHAR2(1)	FUNCTION SPRIDEN	MFKFUNC.F_GET_VENDOR_FIELDS SPRIDEN_ENTITY_IND
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	Carrier's name.	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	FPBRCHD	FPBRCHD_CARR_PIDM
COMMODITY	Commodity	User-defined code associated with this commodity.	VARCHAR2(63)	FPRRCDT	FPRRCDT_COMM_CODE
COMMODITY_DESC	Commodity Description	Commodity description or title.	VARCHAR2(255)	FPRRCDT FUNCTION	FPRRCDT_COMM_DESC GOKODSF.F_GET_DESC
COMPLETE_IND	Complete Indicator	Indicates if the receiving document is complete.	VARCHAR2(63)	FPBRCHD	FPBRCHD_COMPLETE_IND
FINAL_RECEIPT_IND	Final Receipt Indicator	Determines if this is the last receipt for the purchase order item.	VARCHAR2(63)	CALCULATION	DECODE(FPRRCDT_PARTIAL_FINAL_IND)
ITEM	Item	System-generated item number associated with the purchase order commodity.	NUMBER	FPRRCDT	FPRRCDT_ITEM
MAKE	Make	Make for the fixed asset usually associated with a car.	VARCHAR2(255)	FPRRCDT	FPRRCDT_MAKE
MANUFACTURER	Manufacturer	Name of the manufacturer for the fixed asset.	VARCHAR2(255)	FPRRCDT	FPRRCDT_MANUFACTURER
MODEL	Model	Model number for the fixed asset.	VARCHAR2(255)	FPRRCDT	FPRRCDT_MODEL
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
PACKING_SLIP_KEY	Packing Slip KEY	Packing slip number generally found on the packing slip attached to goods received in the purchasing process.	VARCHAR2(63)	FPRRCDT	FPRRCDT_PACKING_SLIP
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)	FPRRCDT	FPRRCDT_POHD_CODE
QUANTITY_RECEIVED	Quantity Received	Quantity received of an ordered commodity.	NUMBER	FPRRCDT	FPRRCDT_QTY_RCVD
QUANTITY_RECEIVED_REJECTED	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	Quantity rejected of an ordered commodity.	NUMBER	FPRRCDT	FPRRCDT_QTY_REJD
QUANTITY_RETURNED	Quantity Returned	Quantity being returned on an ordered commodity.	NUMBER	FPRRTRN FUNCTION	FPRRTRN_QTY MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID
RECEIVED_AMOUNT	Received Amount	Amount received for the purchased item. Used for standing orders.	NUMBER	FPRRCDT	FPRRCDT_AMT_RCVD
RECEIVED_DATE	Received Date	Date the purchase order item was received.	DATE	FPRRCDT	FPRRCDT_RCVD_DATE
RECEIVED_USER_ID	Received User ID	Person who entered the received purchase order item.	VARCHAR2(63)	FPRRCDT	FPRRCDT_USER_ID
RECEIVER_DOCUMENT	Receiver Document	Unique user defined or system assigned one-up document number for the receiving document.	VARCHAR2(63)	FPRRCDT	FPRRCDT_RCHD_CODE
RECEIVING_METHOD	Receiving Method	Method used to ship from the vendor.	VARCHAR2(63)	FPBRCHD	FPBRCHD_RCMT_CODE
RECEIVING_METHOD_DESC	Receiving Method Description	Receiving method description or title.	VARCHAR2(255)	FTVRCMT	FTVRCMT_DESC
RETURN_DOCUMENT	Return Document	System-generated or user-specified number associated with this return to a vendor.	VARCHAR2(63)	FPRRTRN FUNCTION	FPRRTRN_CODE MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID
RETURN_REASON	Return Reason	User-specified code that defines the reason for the return such as damaged goods or wrong item.	VARCHAR2(63)	FPRRTRN FUNCTION	FPRRTRN_RRSN_CODE MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID
RETURN_REASON_DESC	Return Reason Description	Return reason description or title.	VARCHAR2(255)	FTVRRSN FUNCTION	FTVRRSN_DESC MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID
RETURN_SEQUENCE_NUMBER	Return Sequence Number	Numeric value of each accounting line item associated with the return document.	NUMBER	FPRRTRN FUNCTION	FPRRTRN_SEQ_NUM MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID
RETURN_UNIT_OF_MEASURE	Return Unit Of Measure	Unit-of-measure applicable to the returned commodity.	VARCHAR2(63)	FPRRTRN FUNCTION	FPRRTRN_UOMS_CODE MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID
RETURN_UNIT_OF_MEASURE_DESC	Return Unit Of Measure Description	Unit of measure description.	VARCHAR2(255)	FTVUOMS FUNCTION	FTVUOMS_DESC MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID
TERMS_OF_SALE	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(63)	FPRRCDT	FPRRCDT_FOB_CODE
TERMS_OF_SALE_DESC	Terms Of Sale Description	Terms of sale description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TOLERANCE_OVERRIDE_IND	Tolerance Override Indicator	Determine if the user override tolerance checking limits.	VARCHAR2(63)	CALCULATION	NVL(FPRRCDT_TOL_OVERRIDE_IND)
TOLERANCE_SUSPENSE_IND	Tolerance Suspense Indicator	Inform the user that the received item is being held in suspense due to a failed tolerance check on limits.	VARCHAR2(63)	FPRRCDT	FPRRCDT_SUSP_IND

Ver: 9.2