Go To View:  RETURN TO BANNER COMP META DATA 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.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADDITIONAL_CHARGES_AMOUNT Amount of additional charges for the commodity record.    

FARINVC

FARINVC_ADDL_CHRG_AMT

 
APPROVED_ITEM_AMOUNT Calculation to determine the actual cost of an item.    

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.    

FARINVC

FARINVC_APPR_QTY

 
APPROVED_UNIT_PRICE Unit amount approved for payment on this invoice item.    

FARINVC

FARINVC_APPR_UNIT_PRICE

 
COMMODITY User-defined code associated with this commodity.    

FARINVC

FARINVC_COMM_CODE

 
COMMODITY_DESC Commodity description or title.    

FUNCTION

GOKODSF.F_GET_DESC

 
COMMODITY_HOLD_IND An attribute used to place invoice records on hold to prevent disbursement to a vendor.    

FARINVC

FARINVC_HOLD_IND

 
COMMODITY_UNIT_OF_MEASURE Code that depicts the unit of measure applicable to the selected commodity.    

FARINVC

FARINVC_UOMS_CODE

 
COMMODITY_UNIT_OF_MEASURE_DESC Unit of measure description.    

FTVUOMS

FTVUOMS_DESC

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

FARINVC

FARINVC_CONVERT_ADDL_CHRG_AMT

 
CONVERTED_DISCOUNT_AMOUNT Base currency discount amount calculated for this commodity record.    

FARINVC

FARINVC_CONVERT_DISC_AMT

 
CONVERTED_TAX_AMOUNT Base currency tax amount calculated for this commodity record.    

FARINVC

FARINVC_CONVERT_TAX_AMT

 
CONVERTED_UNIT_PRICE Base currency unit price calculated for this commodity record.    

FARINVC

FARINVC_CONVERT_UNIT_PRICE

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

NA

SYSDATE

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

FARINVC

FARINVC_DISC_AMT

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

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.    

NA

NA

 
INVOICE Invoice document number.    

FARINVC

FARINVC_INVH_CODE

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

FARINVC

FARINVC_ITEM

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

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

FARINVC

FARINVC_POHD_CODE

 
PURCHASE_ORDER_ITEM System assigned one-up number of the commodity on the purchase order item.    

FARINVC

FARINVC_PO_ITEM

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

FARINVC

FARINVC_TAX_AMT

 
TAX_GROUP Tax group code to be used for this commodity record.    

FARINVC

FARINVC_TGRP_CODE

 
TAX_GROUP_DESC Tax group description.    

FTVTGRP

FTVTGRP_TITLE

 
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 


Ver: 8.3