Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: INVOICE

Description Contains general invoice and vendor information including invoice type, purchase order, vendor, vendor invoice number, third party information, one time vendor information, invoice date, payment due date, transaction date, cancel date, open paid indicator, and total approved amount.
Key & Frequency One row per invoice.
Recommended Search Columns ADDRESS_TYPE
INVOICE

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

APPROVAL_IND Indicates the document has met final approval. VARCHAR2(63)

FABINVH

FABINVH_APPR_IND

CANCEL_DATE Date the invoice was cancelled. DATE

FABINVH

FABINVH_CANCEL_DATE

COMPLETE_IND Indicates if the purchase order document is complete. VARCHAR2(63)

FABINVH

FABINVH_COMPLETE_IND

CREDIT_MEMO_IND Indicator identifies invoices for which a credit memo has been processed. VARCHAR2(63)

FABINVH

FABINVH_CR_MEMO_IND

CURRENCY Type of currency represented in the amount field. VARCHAR2(63)

FABINVH

FABINVH_CURR_CODE

CURRENCY_DESC Currency code description or title. VARCHAR2(255)

GTVCURR

GTVCURR_TITLE

FEDERAL_TAX_ID Indicates 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)

FABINVH

FABINVH_1099_ID

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)

FABINVH

FABINVH_1099_IND

HOLD_IND Indicates if invoice records are on hold to prevent disbursement to a vendor. VARCHAR2(63)

FABINVH

FABINVH_HOLD_IND

INVOICE Invoice document number. VARCHAR2(63)

FABINVH

FABINVH_CODE

INVOICE_DATE Date of the invoice. DATE

FABINVH

FABINVH_INVOICE_DATE

INVOICE_METHOD Invoice method. VARCHAR2(63)

NA

NA

INVOICE_METHOD_DESC Invoice method description. VARCHAR2(255)

NA

NA

INVOICE_TYPE Indicator designates whether an invoice is direct pay or regular. VARCHAR2(63)

FABINVH

FABINVH_INVOICE_TYPE_IND

INVOICE_TYPE_DESC Deciphers invoice type as direct pay or regular pay. VARCHAR2(255)

CALCULATION

DECODE(FABINVH_INVOICE_TYPE_IND)

INVOICE_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

FABINVH

FABINVH_USER_ID

MULTIPLE_INVOICE_IND Indicates whether this invoice contains multiple vendor invoices. VARCHAR2(63)

FABINVH

FABINVH_MULTIPLE_INV_IND

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

ONE_TIME_VENDOR_ADDRESS_IND Indicates if the remit-to address is a one-time vendor address. VARCHAR2(63)

CALCULATION

DECODE(FABINVH_ATYP_CODE,NULL,'Y','N')

OPEN_PAID_IND Indicates if a document is open or paid. VARCHAR2(63)

FABINVH

FABINVH_OPEN_PAID_IND

PAYMENT_DUE_DATE Date an invoice is due to be paid by check. DATE

FABINVH

FABINVH_PMT_DUE_DATE

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)

FABINVH

FABINVH_POHD_CODE

REMIT_TO_ADDRESS_TYPE Identifies the type of address that the payment for the invoice is to be sent. VARCHAR2(63)

FABINVH

FABINVH_ATYP_CODE

REMIT_TO_ADDRESS_TYPE_DESC Description for the address type of the vendor. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

REMIT_TO_ADDRESS_TYPE_NUMBER Sequence number of the address type of the remit to vendor. NUMBER

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, TO_NUMBER(NULL), FABINVH_ATYP_SEQ_NUM)

REMIT_TO_CARRIER_ROUTE Address carrier route. VARCHAR2(4)

SPRADDR

SPRADDR_CARRIER_ROUTE

REMIT_TO_CITY City, town or municipality associated with the address. VARCHAR2(63)

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_CITY, NULL)

REMIT_TO_CORRECTION_DIGIT Correction digit associated with the address for bar code mailing. VARCHAR2(40)

SPRADDR

SPRADDR_CORRECTION_DIGIT

REMIT_TO_COUNTY County associated with the address. VARCHAR2(63)

CALCULATION

SPRADDR_CNTY_CODE

REMIT_TO_COUNTY_DESC Description of the county associated with the address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

REMIT_TO_DELIVERY_POINT Delivery point associated with the address for barcode mailings. VARCHAR2(40)

SPRADDR

SPRADDR_DELIVERY_POINT

REMIT_TO_NATION Nation/country code associated with the address. VARCHAR2(63)

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_NATN, NULL)

REMIT_TO_NATION_DESC Description for the nation/country associated with the address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

REMIT_TO_POSTAL_CODE Postal code associated with the remit-to address. VARCHAR2(63)

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ZIP, NULL)

REMIT_TO_STATE_PROVINCE Identifies the state or province associated with this address. VARCHAR2(63)

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_STATE, NULL)

REMIT_TO_STATE_PROVINCE_DESC Name of the state/province. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

REMIT_TO_STREET_LINE1 First line of the address. VARCHAR2(255)

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR1, NULL)

REMIT_TO_STREET_LINE2 Second line of the address. VARCHAR2(255)

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR2, NULL)

REMIT_TO_STREET_LINE3 Third line of the address. VARCHAR2(255)

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR3, NULL)

REMIT_TO_STREET_LINE4 Fourth line of the address. VARCHAR2(255)

NA

NA

SUBMISSION_NUMBER Last submission number used for this invoice if it was recurring or re-established. NUMBER

FABINVH

FABINVH_SUBMISSION_NUMBER

THIRD_PARTY_ADDRESS_IND Indicates if the remit-to address is a third party address. VARCHAR2(63)

CALCULATION

DECODE(FABINVH_VEND_CHECK_PIDM,NULL,'N','Y')

THIRD_PARTY_ENTITY_IND Indicates if third party vendor is a person or non-person. VARCHAR2(1)

FUNCTION

FRKIDEN.F_GET_SPRIDEN_ENTITY_IND

THIRD_PARTY_ID Third party or contract sponsor's current identification number. VARCHAR2(63)

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

THIRD_PARTY_NAME Third party or contract sponsor's current name. VARCHAR2(255)

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

THIRD_PARTY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

FABINVH

FABINVH_VEND_CHECK_PIDM

TOTAL_APPROVED_ITEM_AMOUNT Total approved amount for all invoice items calculated as approved amount plus taxes plus additional charges minus discounts minus tax rebates. NUMBER

FUNCTION

FOKODSF.F_INV_TOT_APPROV_ITEM_AMT

TOTAL_CONVERTED_AMOUNT Total conversion amount for all invoice items calculated as approved amount plus taxes plus additional charges minus discounts minus tax rebates. NUMBER

FUNCTION

FOKODSF.F_INV_TOT_CONVERT_ITEM_AMT

TRANSACTION_DATE Date used by the finance system to control posting to the ledgers. DATE

FABINVH

FABINVH_TRANS_DATE

VENDOR_ENTITY_IND Extracts type of vendor as person or non-person. VARCHAR2(1)

FUNCTION

FRKIDEN.F_GET_SPRIDEN_ENTITY_IND

VENDOR_ID Extracted identification number for the vendor. VARCHAR2(63)

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

VENDOR_INVOICE_NUMBER Vendor's invoice code. VARCHAR2(63)

FABINVH

FABINVH_VEND_INV_CODE

VENDOR_NAME Extracted name of the vendor. VARCHAR2(255)

FABINVH

FUNCTION

FABINVH_ONE_TIME_VEND_NAME

MFKFUNC.F_GET_VENDOR_FIELDS

VENDOR_UID System generated unique internal identification number used to access the vendor. NUMBER

FABINVH

FABINVH_VEND_PIDM



Ver: 8.0