Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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(8)		FPBRCHD	FPBRCHD_CARR_PIDM
COMMODITY		User-defined code associated with this commodity.	VARCHAR2(10)		FPRRCDT	FPRRCDT_COMM_CODE
COMMODITY_DESC	Commodity Description	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(4)		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(8, 2)		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(8, 2)		FPRRCDT	FPRRCDT_QTY_REJD
RECEIVED_ACTIVITY_DATE		Date record was created or last updated.	DATE		FPRRCDT	FPRRCDT_ACTIVITY_DATE
RECEIVED_AMOUNT	Received Amount	Amount received for the purchased item. Used for standing orders.	NUMBER(17,2)		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: