Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
APPROVAL_IND	Indicates the document has met final approval.	VARCHAR2(1)	FABINVH	FABINVH_APPR_IND	NO	NO
CANCEL_DATE	Date the invoice was cancelled.	DATE	FABINVH	FABINVH_CANCEL_DATE	NO	NO
CANCEL_IND	Indicates if the invoice is canceled.	VARCHAR2(1)	FABINVH	FABINVH_CANCEL_IND	NO	NO
COMPLETE_IND	Indicates if the purchase order document is complete.	VARCHAR2(1)	FABINVH	FABINVH_COMPLETE_IND	NO	NO
CREDIT_MEMO_IND	Indicator identifies invoices for which a credit memo has been processed.	VARCHAR2(1)	FABINVH	FABINVH_CR_MEMO_IND	NO	NO
CURRENCY	Type of currency represented in the amount field.	VARCHAR2(4)	FABINVH	FABINVH_CURR_CODE	NO	NO
CURRENCY_DESC	Currency code description or title.	VARCHAR2(35)	GTVCURR	GTVCURR_TITLE	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DATA_ORIGIN	Source system that generated the data.	VARCHAR2(30)	FABINVH	FABINVH_DATA_ORIGIN	NO	NO
DAYS_BETWEEN_SUBMISSIONS	Number of days between submissions. Used in lieu of submission frequency.	NUMBER	FABRUIV	FABRUIV_SUB_DAYS	NO	NO
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')	NO	NO
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')	NO	NO
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')	NO	NO
DISCOUNT	Code representing the discount terms established with the vendor.	VARCHAR2(2)	FABINVH	FABINVH_DISC_CODE	NO	NO
DISCOUNT_DESC	Discount description.	VARCHAR2(35)	FTVDISC	FTVDISC_DESC	NO	NO
DISCOUNT_PERCENT	Discount percent.	NUMBER	FTVDISC	FTVDISC_PCT	NO	NO
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')	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
FAX_COUNTRY_CODE	Region or fax country code.	VARCHAR2(4)	FABINVH	FABINVH_CTRY_CODE_FAX	NO	NO
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(9)	FABINVH	FABINVH_1099_ID	NO	NO
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	NO	NO
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(1)	CALCULATION	DECODE(FABINVH_GROUPING_IND)	NO	NO
GROUPING_DESC	Invoice grouping description.	VARCHAR2(25)	CALCULATION	DECODE(FABINVH_GROUPING_IND)	NO	NO
HOLD_IND	Indicates if invoice records are on hold to prevent disbursement to a vendor.	VARCHAR2(1)	FABINVH	FABINVH_HOLD_IND	NO	NO
INSTALLMENT_IND	Indicates whether a fixed asset will be purchased through an installment plan.	VARCHAR2(1)	CALCULATION	NVL(FABINVH_RUIV_INSTALLMENT_IND,'N')	NO	NO
INVOICE	Invoice document number.	VARCHAR2(8)	FABINVH	FABINVH_CODE	NO	NO
INVOICE_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	FABINVH	FABINVH_ACTIVITY_DATE	NO	NO
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	NO	NO
INVOICE_CANCEL_USER_ID	Unique identification code of the user who cancelled the invoice.	VARCHAR2(30)	FABINVH	FABINVH_CANCEL_USER	NO	NO
INVOICE_COMPLETE_DATE	Date on which the invoice was completed and forwarded to the next process.	DATE	FABINVH	FABINVH_COMPLETE_DATE	NO	NO
INVOICE_COMPLETE_USER	Banner ID of the person who completed this invoice.	VARCHAR2(30)	FABINVH	FABINVH_COMPLETE_USER	NO	NO
INVOICE_CREATE_DATE	Date on which the new invoice record was created.	DATE	FABINVH	FABINVH_CREATE_DATE	NO	NO
INVOICE_CREATE_USER	Banner ID of the person who created this invoice.	VARCHAR2(30)	FABINVH	FABINVH_CREATE_USER	NO	NO
INVOICE_DATE	Date of the invoice.	DATE	FABINVH	FABINVH_INVOICE_DATE	NO	NO
INVOICE_ORIGIN	Source process that created the invoice document. Used specifically to identify when this is a purchasing card invoice.	VARCHAR2(10)	FABINVH	FABINVH_ORIGIN_CODE	NO	NO
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')	NO	NO
INVOICE_TYPE	Indicator designates whether an invoice is direct pay or regular.	VARCHAR2(1)	FABINVH	FABINVH_INVOICE_TYPE_IND	NO	NO
INVOICE_TYPE_DESC	The description for the invoice type.	VARCHAR2(30)	CALCULATION	DECODE(FABINVH_INVOICE_TYPE_IND)	NO	NO
INVOICE_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	FABINVH	FABINVH_USER_ID	NO	NO
MAXIMUM_NUMBER_SUBMISSIONS	Maximum number of times this payment occurs.	NUMBER	CALCULATION	NVL(FABRUIV_MAX_SUB,0)	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
MULTIPLE_INVOICE_IND	Indicates whether this invoice contains multiple vendor invoices.	VARCHAR2(1)	FABINVH	FABINVH_MULTIPLE_INV_IND	NO	NO
NEXT_SUBMISSION_DATE	Next submission date for payment.	DATE	FABRUIV	FABRUIV_NEXT_SUB_DATE	NO	NO
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')	NO	NO
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')	NO	NO
OPEN_PAID_IND	Indicates if a document is open or paid.	VARCHAR2(1)	FABINVH	FABINVH_OPEN_PAID_IND	NO	NO
PAYMENT_DUE_DATE	Date an invoice is due to be paid by check.	DATE	FABINVH	FABINVH_PMT_DUE_DATE	NO	NO
PHONE_COUNTRY_CODE	Phone region or country code designation.	VARCHAR2(4)	FABINVH	FABINVH_CTRY_CODE_PHONE	NO	NO
PURCHASE_ORDER	User-defined or system assigned one-up purchase order number issued to this vendor.	VARCHAR2(8)	FABINVH	FABINVH_POHD_CODE	NO	NO
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(1)	FABINVH	FABINVH_MATCH_REQUIRED	NO	NO
RECEIVING_REQUIRED_DESC	Receiving required description.	VARCHAR2(35)	CALCULATION	DECODE(FABINVH_MATCH_REQUIRED)	NO	NO
RECURRING_PAYABLE_USER_ID	Unique identification code of the user who entered or last touched recurring payable information.	VARCHAR2(30)	FABRUIV	FABRUIV_USER_ID	NO	NO
REMAINING_SUBMISSIONS	Number of vendor payments remaining for this invoice.	NUMBER	CALCULATION	NVL(FABRUIV_MAX_SUB,0) - NVL(FABRUIV_SUB_TO_DATE,0)	NO	NO
REMIT_TO_ADDRESS_TYPE	Identifies the type of address that the payment for the invoice is to be sent.	VARCHAR2(2)	FABINVH	FABINVH_ATYP_CODE	NO	NO
REMIT_TO_ADDRESS_TYPE_DESC	Description for the address type of the vendor.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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)	NO	NO
REMIT_TO_CITY	City, town or municipality associated with the address.	VARCHAR2(50)	CALCULATION	DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_CITY, NULL)	NO	NO
REMIT_TO_NATION	Nation/country code associated with the address.	VARCHAR2(5)	CALCULATION	DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_NATN, NULL)	NO	NO
REMIT_TO_NATION_DESC	Description for the nation/country associated with the address.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
REMIT_TO_POSTAL_CODE	Postal code associated with the remit-to address.	VARCHAR2(30)	CALCULATION	DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ZIP, NULL)	NO	NO
REMIT_TO_STATE_PROVINCE	Identifies the state or province associated with this address.	VARCHAR2(3)	CALCULATION	DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_STATE, NULL)	NO	NO
REMIT_TO_STATE_PROVINCE_DESC	Name of the state/province.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
REMIT_TO_STREET_LINE1	First line of the address.	VARCHAR2(75)	CALCULATION	DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR1, NULL)	NO	NO
REMIT_TO_STREET_LINE2	Second line of the address.	VARCHAR2(75)	CALCULATION	DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR2, NULL)	NO	NO
REMIT_TO_STREET_LINE3	Third line of the address.	VARCHAR2(75)	CALCULATION	DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR3, NULL)	NO	NO
REMIT_TO_STREET_LINE4	Fourth line of the address.	VARCHAR2(75)	NA	NA	NO	NO
REPEATING_FREQUENCY_DESC	Frequency of payment description.	VARCHAR2(15)	CALCULATION	CASE WHEN FABRUIV_SUB_IND	NO	NO
REPEATING_INVOICE_FREQUENCY	Frequency of payment. As an example, monthly, yearly, weekly, etc.	VARCHAR2(1)	FABRUIV	FABRUIV_SUB_IND	NO	NO
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')	NO	NO
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)	NO	NO
SUBMISSION_NUMBER	Last submission number used for this invoice if it was recurring or re-established.	NUMBER	FABINVH	FABINVH_SUBMISSION_NUMBER	NO	NO
SUSPENSE_IND	Indicates that the document is being held in suspense due to missing or erroneous data content.	VARCHAR2(1)	FABINVH	FABINVH_SUSP_IND	NO	NO
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(4)	FABINVH	FABINVH_TGRP_CODE	NO	NO
TAX_GROUP_DESC	Tax group description.	VARCHAR2(35)	FTVTGRP	FTVTGRP_TITLE	NO	NO
TAX_INCOME_TYPE	User value representing income type for 1099 processing and reporting purposes.	VARCHAR2(2)	FTVITYP	FTVITYP_CODE	NO	NO
TAX_INCOME_TYPE_DESC	Tax income type description.	VARCHAR2(35)	FTVITYP	FTVITYP_DESC	NO	NO
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	NO	NO
TEXT_EXISTS_IND	Determines if text exists for the invoice.	VARCHAR2(1)	CALCULATION	NVL(FABINVH_TEXT_IND,'N')	NO	NO
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')	NO	NO
THIRD_PARTY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	FABINVH	FABINVH_VEND_CHECK_PIDM	NO	NO
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	NO	NO
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	NO	NO
TRANSACTION_DATE	Date used by the finance system to control posting to the ledgers.	DATE	FABINVH	FABINVH_TRANS_DATE	NO	NO
VENDOR_INVOICE_NUMBER	Vendor's invoice code.	VARCHAR2(15)	FABINVH	FABINVH_VEND_INV_CODE	NO	NO
VENDOR_NAME	Name of the Vendor.	VARCHAR2(60)				NO
VENDOR_UID	System generated unique internal identification number used to access the vendor.	NUMBER	FABINVH	FABINVH_VEND_PIDM	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: