Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

SGHE 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
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 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 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)

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. 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: 8.0