Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: INVOICE_ITEM

Description Contains invoice items with purchase order, and commodity information. This includes each base and converted amount for unit price, taxes, discounts and additional charges as well as approved quantity.
Key & Frequency One row per invoice per invoice item.
Recommended Search Columns INVOICE, ITEM

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

FARINVC

FARINVC_ADDL_CHRG_AMT

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

APPROVED_ITEM_AMOUNT 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 Approved Quantity Number of items approved for payment processing on this invoice item. NUMBER  

FARINVC

FARINVC_APPR_QTY

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

FARINVC

FARINVC_APPR_UNIT_PRICE

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

FARINVC

FARINVC_COMM_CODE

COMMODITY_DESC Commodity Description Commodity description or title. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

COMMODITY_HOLD_IND Commodity Hold Indicator An attribute used to place invoice records on hold to prevent disbursement to a vendor. VARCHAR2(63)  

FARINVC

FARINVC_HOLD_IND

COMMODITY_UNIT_OF_MEASURE Commodity Unit Of Measure Code that depicts the unit of measure applicable to the selected commodity. VARCHAR2(63)  

FARINVC

FARINVC_UOMS_CODE

COMMODITY_UNIT_OF_MEASURE_DESC Commodity Unit of Measure Description Unit of measure description. VARCHAR2(255)  

FTVUOMS

FTVUOMS_DESC

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

FARINVC

FARINVC_CONVERT_ADDL_CHRG_AMT

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

FARINVC

FARINVC_CONVERT_DISC_AMT

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

FARINVC

FARINVC_CONVERT_TAX_AMT

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

FARINVC

FARINVC_CONVERT_UNIT_PRICE

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

FARINVC

FARINVC_DISC_AMT

FEDERAL_TAX_IND Federal Tax Indicator 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(63)  

NA

NA

INVOICE Invoice Invoice document number. VARCHAR2(63)  

FARINVC

FARINVC_INVH_CODE

ITEM Item Literal commodity or goods description associated with an invoice processing record. The unique sequence number directly associated with an item on the commodity record. NUMBER  

FARINVC

FARINVC_ITEM

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)  

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)  

NA

NA

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

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

FARINVC

FARINVC_POHD_CODE

PURCHASE_ORDER_ITEM Purchase Order Item System assigned one-up number of the commodity on the purchase order item. NUMBER  

FARINVC

FARINVC_PO_ITEM

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

FARINVC

FARINVC_TAX_AMT

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

FARINVC

FARINVC_TGRP_CODE

TAX_GROUP_DESC Tax Group Description Tax group description. VARCHAR2(255)  

FTVTGRP

FTVTGRP_TITLE



Ver: 9.0