Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-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.2