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
ADDRESS_TYPE

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative-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(1)

FABINVH

FABINVH_APPR_IND

CANCEL_DATE Date the invoice was cancelled. DATE

FABINVH

FABINVH_CANCEL_DATE

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

FABINVH

FABINVH_CANCEL_IND

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

FABINVH

FABINVH_COMPLETE_IND

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

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

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

FABINVH

FABINVH_DATA_ORIGIN

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

FABRUIV

FABRUIV_SUB_DAYS

DEFERRED_EDIT_IND 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 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 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 Code representing the discount terms established with the vendor. VARCHAR2(63)

FABINVH

FABINVH_DISC_CODE

DISCOUNT_DESC Discount description. VARCHAR2(255)

FTVDISC

FTVDISC_DESC

DISCOUNT_PERCENT Discount percent. NUMBER

FTVDISC

FTVDISC_PCT

DOCUMENT_ACCOUNTING_IND 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 Region or country code fax. VARCHAR2(63)

FABINVH

FABINVH_CTRY_CODE_FAX

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

FABINVH

FABINVH_1099_IND

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 Invoice grouping description. VARCHAR2(255)

CALCULATION

DECODE(FABINVH_GROUPING_IND)

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

FABINVH

FABINVH_HOLD_IND

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

CALCULATION

NVL(FABINVH_RUIV_INSTALLMENT_IND,'N')

INVOICE Invoice document number. VARCHAR2(63)

FABINVH

FABINVH_CODE

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 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 Unique identification code of the user who cancelled the invoice. VARCHAR2(63)

FABINVH

FABINVH_CANCEL_USER

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

FABINVH

FABINVH_COMPLETE_DATE

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

FABINVH

FABINVH_COMPLETE_USER

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

FABINVH

FABINVH_CREATE_DATE

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

FABINVH

FABINVH_CREATE_USER

INVOICE_DATE Date of the invoice. DATE

FABINVH

FABINVH_INVOICE_DATE

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

MAXIMUM_NUMBER_SUBMISSIONS Maximum number of times this payment occurs. NUMBER

CALCULATION

NVL(FABRUIV_MAX_SUB,0)

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

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

NEXT_SUBMISSION_DATE Next submission date for payment. DATE

FABRUIV

FABRUIV_NEXT_SUB_DATE

NSF_ON_OFF_IND 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 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 Indicates if a document is open or paid. VARCHAR2(1)

FABINVH

FABINVH_OPEN_PAID_IND

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

FABINVH

FABINVH_PMT_DUE_DATE

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

FABINVH

FABINVH_CTRY_CODE_PHONE

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

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. VARCHAR2(255)

CALCULATION

DECODE(FABINVH_MATCH_REQUIRED)

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

REPEATING_FREQUENCY_DESC Frequency of payment description. VARCHAR2(255)

CALCULATION

CASE WHEN FABRUIV_SUB_IND

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

FABRUIV

FABRUIV_SUB_IND

REPEATING_INVOICE_IND 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 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 Last submission number used for this invoice if it was recurring or re-established. NUMBER

FABINVH

FABINVH_SUBMISSION_NUMBER

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

FABINVH

FABINVH_SUSP_IND

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. VARCHAR2(255)

FTVTGRP

FTVTGRP_TITLE

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. VARCHAR2(255)

FTVITYP

FTVITYP_DESC

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 Determines if text exists for the invoice. VARCHAR2(1)

CALCULATION

NVL(FABINVH_TEXT_IND,'N')

THIRD_PARTY_ADDRESS_IND 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 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.5