Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
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	Cancel Indicator	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(4)		FABINVH	FABINVH_CURR_CODE
CURRENCY_DESC		Currency code description or title.	VARCHAR2(35)		GTVCURR	GTVCURR_TITLE
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DATA_ORIGIN	Data Origin	Source system that generated the data.	VARCHAR2(30)		FABINVH	FABINVH_DATA_ORIGIN
DAYS_BETWEEN_SUBMISSIONS	Days Between Submissions	Number of days between submissions. Used in lieu of submission frequency.	NUMBER(3)		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(2)		FABINVH	FABINVH_DISC_CODE
DISCOUNT_DESC	Discount Description	Discount description.	VARCHAR2(35)		FTVDISC	FTVDISC_DESC
DISCOUNT_PERCENT	Discount Percent	Discount percent.	NUMBER(6,3)		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')
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
FAX_COUNTRY_CODE	Fax Country Code	Region or fax country code.	VARCHAR2(4)		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(9)		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	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)
GROUPING_DESC	Grouping Description	Invoice grouping description.	VARCHAR2(25)		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	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 document number.	VARCHAR2(8)		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(30)		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(30)		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(30)		FABINVH	FABINVH_CREATE_USER
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(10)		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		Indicator designates whether an invoice is direct pay or regular.	VARCHAR2(1)		FABINVH	FABINVH_INVOICE_TYPE_IND
INVOICE_TYPE_DESC		The description for the invoice type.	VARCHAR2(30)		CALCULATION	DECODE(FABINVH_INVOICE_TYPE_IND)
INVOICE_USER_ID		Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)		FABINVH	FABINVH_USER_ID
MAXIMUM_NUMBER_SUBMISSIONS	Maximum Number Submissions	Maximum number of times this payment occurs.	NUMBER		CALCULATION	NVL(FABRUIV_MAX_SUB,0)
MIF_DESC		Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
MULTIPLE_INVOICE_IND		Indicates whether this invoice contains multiple vendor invoices.	VARCHAR2(1)		FABINVH	FABINVH_MULTIPLE_INV_IND
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		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 Country Code	Phone region or country code designation.	VARCHAR2(4)		FABINVH	FABINVH_CTRY_CODE_PHONE
PURCHASE_ORDER		User-defined or system assigned one-up purchase order number issued to this vendor.	VARCHAR2(8)		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(1)		FABINVH	FABINVH_MATCH_REQUIRED
RECEIVING_REQUIRED_DESC	Receiving Required Description	Receiving required description.	VARCHAR2(35)		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(30)		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		Identifies the type of address that the payment for the invoice is to be sent.	VARCHAR2(2)		FABINVH	FABINVH_ATYP_CODE
REMIT_TO_ADDRESS_TYPE_DESC		Description for the address type of the vendor.	VARCHAR2(30)		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_CITY	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)
REMIT_TO_NATION		Nation/country code associated with the address.	VARCHAR2(5)		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(35)		FUNCTION	GOKODSF.F_GET_DESC
REMIT_TO_POSTAL_CODE	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)
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)
REMIT_TO_STATE_PROVINCE_DESC		Name of the state/province.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
REMIT_TO_STREET_LINE1	Remit To Street Line 1	First line of the address.	VARCHAR2(75)		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(75)		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(75)		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(75)		NA	NA
REPEATING_FREQUENCY_DESC	Repeating Frequency Description	Frequency of payment description.	VARCHAR2(15)		CALCULATION	CASE WHEN FABRUIV_SUB_IND
REPEATING_INVOICE_FREQUENCY	Repeating Invoice Frequency	Frequency of payment. As an example, monthly, yearly, weekly, etc.	VARCHAR2(1)		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		Last submission number used for this invoice if it was recurring or re-established.	NUMBER(3)		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(4)		FABINVH	FABINVH_TGRP_CODE
TAX_GROUP_DESC	Tax Group Description	Tax group description.	VARCHAR2(35)		FTVTGRP	FTVTGRP_TITLE
TAX_INCOME_TYPE	Tax Income Type	User value representing income type for 1099 processing and reporting purposes.	VARCHAR2(2)		FTVITYP	FTVITYP_CODE
TAX_INCOME_TYPE_DESC	Tax Income Type Description	Tax income type description.	VARCHAR2(35)		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(2)		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		Indicates if the remit-to address is a third party address.	VARCHAR2(1)		CALCULATION	DECODE(FABINVH_VEND_CHECK_PIDM,NULL,'N','Y')
THIRD_PARTY_UID		System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8)		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_INVOICE_NUMBER		Vendor's invoice code.	VARCHAR2(15)		FABINVH	FABINVH_VEND_INV_CODE
VENDOR_NAME		Name of the Vendor	VARCHAR2(60)
VENDOR_UID		System generated unique internal identification number used to access the vendor.	NUMBER(8)		FABINVH	FABINVH_VEND_PIDM
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: