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

SGHE Banner Operational Data Store
Composite View Target: AF_INVOICE_ITEM

Description Source composite view contains item level detailed information on invoices.

Target Column Business Definition Database Data Type Source Name Source Column
ADDITIONAL_CHARGES_AMOUNT Amount of additional charges for the commodity record. NUMBER

FARINVC

FARINVC_ADDL_CHRG_AMT

APPROVED_ITEM_AMOUNT Calculation to determine the actual cost of an item. NUMBER

CALCULATION

(NVL(FARINVC_APPR_QTY,0)*NVL(FARINVC_APPR_UNIT_PRICE,0))+NVL(FARINVC_ADDL_CHRG_AMT,0)+NVL(FARINVC_TAX_AMT,0)-NVL(FARINVC_DISC_AMT,0)

APPROVED_QUANTITY Number of items approved for payment processing on this invoice item. NUMBER

FARINVC

FARINVC_APPR_QTY

APPROVED_UNIT_PRICE Unit amount approved for payment on this invoice item. NUMBER

FARINVC

FARINVC_APPR_UNIT_PRICE

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

FARINVC

FARINVC_COMM_CODE

COMMODITY_DESC Commodity description or title. VARCHAR2(50)

FUNCTION

GOKODSF.F_GET_DESC

COMMODITY_HOLD_IND An attribute used to place invoice records on hold to prevent disbursement to a vendor. VARCHAR2(1)

FARINVC

FARINVC_HOLD_IND

COMMODITY_UNIT_OF_MEASURE Code that depicts the unit of measure applicable to the selected commodity. VARCHAR2(4)

FARINVC

FARINVC_UOMS_CODE

COMMODITY_UNIT_OF_MEASURE_DESC Unit of measure description. VARCHAR2(35)

FTVUOMS

FTVUOMS_DESC

CONVERTED_ADDITIONAL_AMOUNT Base currency additional charges amount calculated for this commodity record. NUMBER

FARINVC

FARINVC_CONVERT_ADDL_CHRG_AMT

CONVERTED_DISCOUNT_AMOUNT Base currency discount amount calculated for this commodity record. NUMBER

FARINVC

FARINVC_CONVERT_DISC_AMT

CONVERTED_TAX_AMOUNT Base currency tax amount calculated for this commodity record. NUMBER

FARINVC

FARINVC_CONVERT_TAX_AMT

CONVERTED_UNIT_PRICE Base currency unit price calculated for this commodity record. NUMBER

FARINVC

FARINVC_CONVERT_UNIT_PRICE

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

NA

SYSDATE

DISCOUNT_AMOUNT Value of the discount taken on the invoice or purchase order accounting amount. NUMBER

FARINVC

FARINVC_DISC_AMT

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

NA

NA

FEDERAL_TAX_IND Distinguishes taxable payments resulting from the payment processing of the invoice. If Y (yes) the payment is recorded and accumulated for income tax reporting purposes. VARCHAR2(0)

NA

NA

INVOICE Invoice document number. VARCHAR2(8)

FARINVC

FARINVC_INVH_CODE

INVOICE_ITEM Unique system generated one-up sequence number directly associated to an item on the commodity record. NUMBER(4)

FARINVC

FARINVC_ITEM

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

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

FARINVC

FARINVC_POHD_CODE

PURCHASE_ORDER_ITEM System assigned one-up number of the commodity on the purchase order item. NUMBER(4)

FARINVC

FARINVC_PO_ITEM

TAX_AMOUNT Amount of tax computed or entered for a document item. NUMBER

FARINVC

FARINVC_TAX_AMT

TAX_GROUP Tax group code to be used for this commodity record. VARCHAR2(4)

FARINVC

FARINVC_TGRP_CODE

TAX_GROUP_DESC Tax group description. VARCHAR2(35)

FTVTGRP

FTVTGRP_TITLE

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