Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

Banner Operational Data Store
Composite View Target: AF_RECEIVED_ITEM

Description Source composite view contains information on received/returned items.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ADJUSTED_IND Indicates if the item received was adjusted. VARCHAR2(1)

CALCULATION

DECODE(FPBRCDT_ADJUST_RECEIVE_IND)

NO

NO
BILL_OF_LADING Bill of lading number for the goods being received. VARCHAR2(10)

FPBRCDT

FPBRCDT_BILL_OF_LADING

NO

NO
CARRIER_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

FPBRCHD

FPBRCHD_CARR_PIDM

NO

NO
COMMODITY User-defined code associated with this commodity. VARCHAR2(10)

FPRRCDT

FPRRCDT_COMM_CODE

NO

NO
COMMODITY_DESC Commodity description or title. VARCHAR2(50)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
COMPLETE_IND Indicates if the receiving document is complete. VARCHAR2(1)

FPBRCHD

FPBRCHD_COMPLETE_IND

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

NO
FINAL_RECEIPT_IND Determines if this is the last receipt for the purchase order item. VARCHAR2(1)

CALCULATION

DECODE(FPRRCDT_PARTIAL_FINAL_IND)

NO

NO
ITEM System-generated item number associated with the purchase order commodity. NUMBER

FPRRCDT

FPRRCDT_ITEM

NO

NO
MAKE Make for the fixed asset usually associated with a car. VARCHAR2(30)

FPRRCDT

FPRRCDT_MAKE

NO

NO
MANUFACTURER Name of the manufacturer for the fixed asset. VARCHAR2(30)

FPRRCDT

FPRRCDT_MANUFACTURER

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
MODEL Model number for the fixed asset. VARCHAR2(35)

FPRRCDT

FPRRCDT_MODEL

NO

NO
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

NO

NO
PURCHASE_ORDER User-defined or system assigned one-up purchase order number issued to this vendor. VARCHAR2(8)

FPRRCDT

FPRRCDT_POHD_CODE

NO

NO
QUANTITY_RECEIVED Quantity received of an ordered commodity. NUMBER

FPRRCDT

FPRRCDT_QTY_RCVD

NO

NO
QUANTITY_RECEIVED_REJECTED Quanity received less quantity rejected for a received item. NUMBER

CALCULATION

SUM(FPRRCDT_QTY_RCVD - FPRRCDT_QTY_REJD)

NO

NO
QUANTITY_REJECTED Quantity rejected of an ordered commodity. NUMBER

FPRRCDT

FPRRCDT_QTY_REJD

NO

NO
RECEIVED_ACTIVITY_DATE Date record was created or last updated. DATE

FPRRCDT

FPRRCDT_ACTIVITY_DATE

NO

NO
RECEIVED_AMOUNT Amount received for the purchased item. Used for standing orders. NUMBER

FPRRCDT

FPRRCDT_QTY_RCVD

NO

NO
RECEIVED_DATE Date the purchase order item was received. DATE

FPRRCDT

FPRRCDT_RCVD_DATE

NO

NO
RECEIVED_USER_ID Person who entered the received purchase order item. VARCHAR2(30)

FPRRCDT

FPRRCDT_USER_ID

NO

NO
RECEIVER_DOCUMENT Unique user defined or system assigned one-up document number for the receiving document. VARCHAR2(8)

FPRRCDT

FPRRCDT_RCHD_CODE

NO

NO
RECEIVING_METHOD Method used to ship from the vendor. VARCHAR2(4)

FPBRCHD

FPBRCHD_RCMT_CODE

NO

NO
RECEIVING_METHOD_DESC Description or title of the receiving method. VARCHAR2(35)

FTVRCMT

FTVRCMT_DESC

NO

NO
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

NO

NO
TERMS_OF_SALE_DESC Description of the terms of sale. VARCHAR2(50)

FTVFOBS

FTVFOBS_DESC

NO

NO
TOLERANCE_OVERRIDE_IND Determines if the user overrode tolerance checking limits. VARCHAR2(1)       NO
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

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: