RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

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

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 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(63)

FARINVC

FARINVC_COMM_CODE

COMMODITY_DESC Commodity description or title. VARCHAR2(255)

FARINVC

FARINVC_COMM_DESC

COMMODITY_HOLD_IND 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 Code that depicts the unit of measure applicable to the selected commodity. VARCHAR2(63)

FARINVC

FARINVC_UOMS_CODE

COMMODITY_UNIT_OF_MEASURE_DESC Unit of measure description. VARCHAR2(255)

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

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

FARINVC

FARINVC_DISC_AMT

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(63)

NA

NA

INVOICE Invoice document number. VARCHAR2(63)

FARINVC

FARINVC_INVH_CODE

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 Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

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

NA

NA

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

NA

NA

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 System assigned one-up number of the commodity on the purchase order item. NUMBER

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(63)

FARINVC

FARINVC_TGRP_CODE

TAX_GROUP_DESC Tax group description. VARCHAR2(255)

FTVTGRP

FTVTGRP_TITLE



Ver: 3.1