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

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

NA

NA

APPROVAL_IND Approval Indicator Indicates the document has met final approval. VARCHAR2(1)  

FABINVH

FABINVH_APPR_IND

CANCEL_DATE Cancel Date Date the invoice was cancelled. DATE  

FABINVH

FABINVH_CANCEL_DATE

CANCEL_IND Cancel Indicator Indicates if the invoice is canceled. VARCHAR2(1)  

FABINVH

FABINVH_CANCEL_IND

COMPLETE_IND Complete Indicator Indicates if the purchase order document is complete. VARCHAR2(1)  

FABINVH

FABINVH_COMPLETE_IND

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

FABINVH

FABINVH_CR_MEMO_IND

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

FABINVH

FABINVH_CURR_CODE

CURRENCY_DESC Currency Description Currency code description or title. VARCHAR2(255)  

GTVCURR

GTVCURR_TITLE

DATA_ORIGIN Data Origin Source system that generated the data. VARCHAR2(63)  

FABINVH

FABINVH_DATA_ORIGIN

DAYS_BETWEEN_SUBMISSIONS Days Between Submissions Number of days between submissions. Used in lieu of submission frequency. NUMBER  

FABRUIV

FABRUIV_SUB_DAYS

DEFERRED_EDIT_IND Deferred Edit Indicator Indicates activation of the deferred edit feature allowing batch editing of the accounting strings. VARCHAR2(1)  

CALCULATION

NVL(FABINVH_EDIT_DEFER_IND,'N')

DIRECT_DEPOSIT_OVERRIDE_IND Direct Deposit Override Indicator Determines if the authorized user wants to override the vendor's direct deposit status. Used to pay a direct deposit vendor with a check on an individual invoice document basis. VARCHAR2(1)  

CALCULATION

NVL(FABINVH_ACH_OVERRIDE_IND,'N')

DISBURSING_AGENT_IND Disbursing Agent Indicator Indicates whether a disbursing agent is used to create the foreign currency checks for this invoice. VARCHAR2(1)  

CALCULATION

NVL(FABINVH_DISB_AGENT_IND,'N')

DISCOUNT Discount Code representing the discount terms established with the vendor. VARCHAR2(63)  

FABINVH

FABINVH_DISC_CODE

DISCOUNT_DESC Discount Description Discount description. VARCHAR2(255)  

FTVDISC

FTVDISC_DESC

DISCOUNT_PERCENT Discount Percent Discount percent. NUMBER  

FTVDISC

FTVDISC_PCT

DOCUMENT_ACCOUNTING_IND Document Accounting Indicator Indicates if this document uses document level accounting or commodity level accounting. (Y)es indicates document level accounting. (N)o indicates commodity level accounting. VARCHAR2(1)  

CALCULATION

NVL(FABINVH_SINGLE_ACCTG_IND,'N')

FAX_COUNTRY_CODE Fax Country Code Region or country code fax. VARCHAR2(63)  

FABINVH

FABINVH_CTRY_CODE_FAX

FEDERAL_TAX_ID 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 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(1)  

FABINVH

FABINVH_1099_IND

GROUPING Grouping Indicates if this invoice is to be grouped with other invoices on one check. (N)o indicates one invoice per check. (Y)es indicates to group many invoices per check. VARCHAR2(63)  

CALCULATION

DECODE(FABINVH_GROUPING_IND)

GROUPING_DESC Grouping Description Invoice grouping description. VARCHAR2(255)  

CALCULATION

DECODE(FABINVH_GROUPING_IND)

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

FABINVH

FABINVH_HOLD_IND

INSTALLMENT_IND Installment Indicator Indicates whether a fixed asset will be purchased through an installment plan. VARCHAR2(1)  

CALCULATION

NVL(FABINVH_RUIV_INSTALLMENT_IND,'N')

INVOICE Invoice Invoice document number. VARCHAR2(63)  

FABINVH

FABINVH_CODE

INVOICE_ACTIVITY_DATE Invoice Activity Date Date that information for this record in the table was entered or last updated. DATE  

FABINVH

FABINVH_ACTIVITY_DATE

INVOICE_CANCEL_ACTIVITY_DATE Invoice Cancel Activity Date Actual system date the invoice was canceled versus the cancel date input by the user. DATE  

FABINVH

FABINVH_CANCEL_ACTIVITY_DATE

INVOICE_CANCEL_USER_ID Invoice Cancel User ID Unique identification code of the user who cancelled the invoice. VARCHAR2(63)  

FABINVH

FABINVH_CANCEL_USER

INVOICE_COMPLETE_DATE Invoice Completion Date Date on which the invoice was completed and forwarded to the next process. DATE  

FABINVH

FABINVH_COMPLETE_DATE

INVOICE_COMPLETE_USER Invoice Completion User Banner ID of the person who completed this invoice. VARCHAR2(63)  

FABINVH

FABINVH_COMPLETE_USER

INVOICE_CREATE_DATE Invoice Create Date Date on which the new invoice record was created. DATE  

FABINVH

FABINVH_CREATE_DATE

INVOICE_CREATE_USER Invoice Create User Banner ID of the person who created this invoice. VARCHAR2(63)  

FABINVH

FABINVH_CREATE_USER

INVOICE_DATE Invoice Date Date of the invoice. DATE  

FABINVH

FABINVH_INVOICE_DATE

INVOICE_ORIGIN Invoice Origin Source process that created the invoice document. Used specifically to identify when this is a purchasing card invoice. VARCHAR2(63)  

FABINVH

FABINVH_ORIGIN_CODE

INVOICE_RE_ESTABLISHED_IND Invoice Re Established Indicator Indicates if the invoice is to be re-established at time of invoice cancel or check cancel. VARCHAR2(1)  

CALCULATION

NVL(FABINVH_INVD_RE_ESTABLISH_IND,'N')

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

FABINVH

FABINVH_INVOICE_TYPE_IND

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

CALCULATION

DECODE(FABINVH_INVOICE_TYPE_IND)

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

FABINVH

FABINVH_USER_ID

MAXIMUM_NUMBER_SUBMISSIONS Maximum Number Submissions Maximum number of times this payment occurs. NUMBER  

CALCULATION

NVL(FABRUIV_MAX_SUB,0)

MULTIPLE_INVOICE_IND Multiple Invoice Indicator Indicates whether this invoice contains multiple vendor invoices. VARCHAR2(1)  

FABINVH

FABINVH_MULTIPLE_INV_IND

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

NEXT_SUBMISSION_DATE Next Submission Date Next submission date for payment. DATE  

FABRUIV

FABRUIV_NEXT_SUB_DATE

NSF_ON_OFF_IND Non_Sufficient Funds On Off Indicator Indicates when non-sufficient funds checking will be performed. If (Y)es, checking is performed at time of data entry. VARCHAR2(1)  

CALCULATION

NVL(FABINVH_NSF_ON_OFF_IND,'N')

ONE_TIME_VENDOR_ADDRESS_IND One Time Vendor Address Indicator Indicates if the remit-to address is a one-time vendor address. VARCHAR2(1)  

CALCULATION

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

OPEN_PAID_IND Open Paid Indicator Indicates if a document is open or paid. VARCHAR2(1)  

FABINVH

FABINVH_OPEN_PAID_IND

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

FABINVH

FABINVH_PMT_DUE_DATE

PHONE_COUNTRY_CODE Phone Country Code Phone region or country code designation. VARCHAR2(63)  

FABINVH

FABINVH_CTRY_CODE_PHONE

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)  

FABINVH

FABINVH_POHD_CODE

RECEIVING_REQUIRED Receiving Required Indicates whether this Invoice associated with the Purchase Order will require matching. Valid values are (N)o matching, (Y)es matching, (U) for no matching set on FOBSYSC. VARCHAR2(63)  

FABINVH

FABINVH_MATCH_REQUIRED

RECEIVING_REQUIRED_DESC Receiving Required Description Receiving required description. VARCHAR2(255)  

CALCULATION

DECODE(FABINVH_MATCH_REQUIRED)

RECURRING_PAYABLE_USER_ID Recurring Payable User ID Unique identification code of the user who entered or last touched recurring payable information. VARCHAR2(63)  

FABRUIV

FABRUIV_USER_ID

REMAINING_SUBMISSIONS Remaining Submissions Number of vendor payments remaining for this invoice. NUMBER  

CALCULATION

NVL(FABRUIV_MAX_SUB,0) - NVL(FABRUIV_SUB_TO_DATE,0)

REMIT_TO_ADDRESS_TYPE 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 Remit To Address Type Description Description for the address type of the vendor. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

REMIT_TO_ADDRESS_TYPE_NUMBER 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 Remit To Carrier Route Address carrier route. VARCHAR2(4)  

SPRADDR

SPRADDR_CARRIER_ROUTE

REMIT_TO_CITY 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 Remit To Correction Digit Correction digit associated with the address for bar code mailing. VARCHAR2(40)  

SPRADDR

SPRADDR_CORRECTION_DIGIT

REMIT_TO_COUNTY Remit To County County associated with the address. VARCHAR2(63)  

CALCULATION

SPRADDR_CNTY_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

SPRADDR

SPRADDR_DELIVERY_POINT

REMIT_TO_NATION 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 Remit To Nation Description Description for the nation/country associated with the address. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

REMIT_TO_POSTAL_CODE 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 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 Remit To State Province Description Name of the state/province. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

REMIT_TO_STREET_LINE1 Remit To Street Line 1 First line of the address. VARCHAR2(255)  

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR1, NULL)

REMIT_TO_STREET_LINE2 Remit To Street Line 2 Second line of the address. VARCHAR2(255)  

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR2, NULL)

REMIT_TO_STREET_LINE3 Remit To Street Line 3 Third line of the address. VARCHAR2(255)  

CALCULATION

DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR3, NULL)

REMIT_TO_STREET_LINE4 Remit To Street Line 4 Fourth line of the address. VARCHAR2(255)  

NA

NA

REPEATING_FREQUENCY_DESC Repeating Frequency Description Frequency of payment description. VARCHAR2(255)  

CALCULATION

CASE WHEN FABRUIV_SUB_IND

REPEATING_INVOICE_FREQUENCY Repeating Invoice Frequency Frequency of payment. As an example, monthly, yearly, weekly, etc. VARCHAR2(63)  

FABRUIV

FABRUIV_SUB_IND

REPEATING_INVOICE_IND Repeating Invoice Indicator Indicates if the user wants this invoice to be paid on a recurring basis. VARCHAR2(1)  

CALCULATION

NVL(FABINVH_RUIV_IND,'N')

SUBMISSIONS_TO_DATE Submissions To Date How many times this payment has been made to the vendor since the recurring payable began. NUMBER  

CALCULATION

NVL(FABRUIV_SUB_TO_DATE,0)

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

FABINVH

FABINVH_SUBMISSION_NUMBER

SUSPENSE_IND Suspense Indicator Indicates that the document is being held in suspense due to missing or erroneous data content. VARCHAR2(1)  

FABINVH

FABINVH_SUSP_IND

TAX_GROUP Tax Group Represents the group of tax rates that should be applied to this invoice if tax processing is on at the system level. VARCHAR2(63)  

FABINVH

FABINVH_TGRP_CODE

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

FTVTGRP

FTVTGRP_TITLE

TAX_INCOME_TYPE Tax Income Type User value representing income type for 1099 processing and reporting purposes. VARCHAR2(63)  

FTVITYP

FTVITYP_CODE

TAX_INCOME_TYPE_DESC Tax Income Type Description Tax income type description. VARCHAR2(255)  

FTVITYP

FTVITYP_DESC

TAX_INCOME_TYPE_KEY Tax Income Type KEY Unique, internal, system generated value representing the user selected income type for 1099 processing and reporting purposes. NUMBER  

FABINVH

FABINVH_ITYP_SEQ_CODE

TEXT_EXISTS_IND Text Exists Indicator Determines if text exists for the invoice. VARCHAR2(1)  

CALCULATION

NVL(FABINVH_TEXT_IND,'N')

THIRD_PARTY_ADDRESS_IND Third Party Address Indicator Indicates if the remit-to address is a third party address. VARCHAR2(1)  

CALCULATION

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

THIRD_PARTY_ENTITY_IND Third Party Entity Indicator 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 ID Third party or contract sponsor's current identification number. VARCHAR2(63)  

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

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

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

THIRD_PARTY_UID 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 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 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 Transaction Date Date used by the finance system to control posting to the ledgers. DATE  

FABINVH

FABINVH_TRANS_DATE

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

FUNCTION

FRKIDEN.F_GET_SPRIDEN_ENTITY_IND

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

FUNCTION

MFKFUNC.F_GET_VENDOR_FIELDS

VENDOR_INVOICE_NUMBER Vendor Invoice Number Vendor's invoice code. VARCHAR2(63)  

FABINVH

FABINVH_VEND_INV_CODE

VENDOR_NAME Vendor Name Extracted name of the vendor. VARCHAR2(255)  

FABINVH

FUNCTION

FABINVH_ONE_TIME_VEND_NAME

MFKFUNC.F_GET_VENDOR_FIELDS

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

FABINVH

FABINVH_VEND_PIDM



Ver: 9.0