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)
BILL_OF_LADING	Bill of lading number for the goods being received.			FPBRCDT	FPBRCDT_BILL_OF_LADING
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.			FUNCTION	GOKODSF.F_GET_DESC
COMPLETE_IND	Indicates if the receiving document is complete.			FPBRCHD	FPBRCHD_COMPLETE_IND
CURRENT_DATE	System current date (sysdate) or date the data was extracted.			NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.			NA	NA
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
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MODEL	Model number for the fixed asset.			FPRRCDT	FPRRCDT_MODEL
PACKING_SLIP_KEY	Packing slip number generally found on the packing slip attached to goods received in the purchasing process.			FPRRCDT	FPRRCDT_PACKING_SLIP
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
RECEIVED_ACTIVITY_DATE	Date record was created or last updated.			FPRRCDT	FPRRCDT_ACTIVITY_DATE
RECEIVED_AMOUNT	Amount received for the purchased item. Used for standing orders.			FPRRCDT	FPRRCDT_QTY_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	Description or title of the receiving method.			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.			FPRRCDT	FPRRCDT_FOB_CODE
TERMS_OF_SALE_DESC	Description of the terms of sale.			FTVFOBS	FTVFOBS_DESC
TOLERANCE_OVERRIDE_IND	Determines if the user overrode tolerance checking limits.			CALCULATION	DECODE(FPRRCDT_TOL_ORVERRIDE_IND)
TOLERANCE_SUSPENSE_IND	Indicator informing the user that the received item is being held in suspense due to a failed tolerance check on limits.			FPRRCDT	FPRRCDT_SUSP_IND
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA

Ver: 8.3