ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ADJUSTED_IND	Indicates if the item received was adjusted.			CALCULATION	DECODE(FPBRCDT_ADJUST_RECEIVE_IND)
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
BILL_OF_LADING	Bill of lading number for the goods being received.			FPBRCDT	FPBRCDT_BILL_OF_LADING
CARRIER_ENTITY_IND	Identifies if the carrier is a person or a non-person.			FUNCTION SPRIDEN	MFKFUNC.F_GET_VENDOR_FIELDS SPRIDEN_ENTITY_IND
CARRIER_ID	User-defined or system generated one-up number of the carrier.			FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS
CARRIER_NAME	Carrier's name.			FUNCTION	MFKFUNC.F_GET_VENDOR_FIELDS
CARRIER_UID	System generated, unique, internal identification number assigned to this person or organization entity.			FPBRCHD	FPBRCHD_CARR_PIDM
COMMODITY	User-defined code associated with this commodity.			FPRRCDT	FPRRCDT_COMM_CODE
COMMODITY_DESC	Commodity description or title.			FPRRCDT FUNCTION	FPRRCDT_COMM_DESC GOKODSF.F_GET_DESC
COMPLETE_IND	Indicates if the receiving document is complete.			FPBRCHD	FPBRCHD_COMPLETE_IND
FINAL_RECEIPT_IND	Determines if this is the last receipt for the purchase order item.			CALCULATION	DECODE(FPRRCDT_PARTIAL_FINAL_IND)
ITEM	System-generated item number associated with the purchase order commodity.			FPRRCDT	FPRRCDT_ITEM
MAKE	Make for the fixed asset usually associated with a car.			FPRRCDT	FPRRCDT_MAKE
MANUFACTURER	Name of the manufacturer for the fixed asset.			FPRRCDT	FPRRCDT_MANUFACTURER
MODEL	Model number for the fixed asset.			FPRRCDT	FPRRCDT_MODEL
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
PACKING_SLIP_KEY	Packing slip number generally found on the packing slip attached to goods received in the purchasing process.			FPRRCDT	FPRRCDT_PACKING_SLIP
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
PURCHASE_ORDER	User-defined or system assigned one-up purchase order number issued to this vendor.			FPRRCDT	FPRRCDT_POHD_CODE
QUANTITY_RECEIVED	Quantity received of an ordered commodity.			FPRRCDT	FPRRCDT_QTY_RCVD
QUANTITY_RECEIVED_REJECTED	Quanity received less quantity rejected for a received item.			CALCULATION	SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REJD)
QUANTITY_REJECTED	Quantity rejected of an ordered commodity.			FPRRCDT	FPRRCDT_QTY_REJD
QUANTITY_RETURNED	Quantity being returned on an ordered commodity.			FPRRTRN FUNCTION	FPRRTRN_QTY MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID
RECEIVED_AMOUNT	Amount received for the purchased item. Used for standing orders.			FPRRCDT	FPRRCDT_AMT_RCVD
RECEIVED_DATE	Date the purchase order item was received.			FPRRCDT	FPRRCDT_RCVD_DATE
RECEIVED_USER_ID	Person who entered the received purchase order item.			FPRRCDT	FPRRCDT_USER_ID
RECEIVER_DOCUMENT	Unique user defined or system assigned one-up document number for the receiving document.			FPRRCDT	FPRRCDT_RCHD_CODE
RECEIVING_METHOD	Method used to ship from the vendor.			FPBRCHD	FPBRCHD_RCMT_CODE
RECEIVING_METHOD_DESC	Receiving method description or title.			FTVRCMT	FTVRCMT_DESC
RETURN_DOCUMENT	System-generated or user-specified number associated with this return to a vendor.			FPRRTRN FUNCTION	FPRRTRN_CODE MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID
RETURN_REASON	User-specified code that defines the reason for the return such as damaged goods or wrong item.			FPRRTRN FUNCTION	FPRRTRN_RRSN_CODE MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID
RETURN_REASON_DESC	Return reason description or title.			FTVRRSN FUNCTION	FTVRRSN_DESC MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID
RETURN_SEQUENCE_NUMBER	Numeric value of each accounting line item associated with the return document.			FPRRTRN FUNCTION	FPRRTRN_SEQ_NUM MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID
RETURN_UNIT_OF_MEASURE	Unit-of-measure applicable to the returned commodity.			FPRRTRN FUNCTION	FPRRTRN_UOMS_CODE MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID
RETURN_UNIT_OF_MEASURE_DESC	Unit of measure description.			FTVUOMS FUNCTION	FTVUOMS_DESC MFKFUNC.F_GET_MFT_RETURNED_ITEM_ROWID
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.			FPRRCDT	FPRRCDT_FOB_CODE
TERMS_OF_SALE_DESC	Terms of sale description.			FUNCTION	GOKODSF.F_GET_DESC
TOLERANCE_OVERRIDE_IND	Determine if the user override tolerance checking limits.			CALCULATION	NVL(FPRRCDT_TOL_OVERRIDE_IND)
TOLERANCE_SUSPENSE_IND	Inform the user that the received item is being held in suspense due to a failed tolerance check on limits.			FPRRCDT	FPRRCDT_SUSP_IND

Ver: 8.3