Target Column	Business Definition	Database Data Type	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
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
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
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
HOLD_IND	Indicates if invoice records are on hold to prevent disbursement to a vendor.	VARCHAR2(1)	FABINVH	FABINVH_HOLD_IND
INVOICE	Invoice document number.	VARCHAR2(8)	FABINVH	FABINVH_CODE
INVOICE_DATE	Date of the invoice.	DATE	FABINVH	FABINVH_INVOICE_DATE
INVOICE_METHOD	Invoice method.	VARCHAR2(0)	NA	NA
INVOICE_METHOD_DESC	Invoice method description.	VARCHAR2(0)	NA	NA
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
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
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
PURCHASE_ORDER	User-defined or system assigned one-up purchase order number issued to this vendor.	VARCHAR2(8)	FABINVH	FABINVH_POHD_CODE
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	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	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	First line of the address.	VARCHAR2(75)	CALCULATION	DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR1, NULL)
REMIT_TO_STREET_LINE2	Second line of the address.	VARCHAR2(75)	CALCULATION	DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR2, NULL)
REMIT_TO_STREET_LINE3	Third line of the address.	VARCHAR2(75)	CALCULATION	DECODE(FABINVH_ATYP_CODE, NULL, FABINVH_ONE_TIME_VEND_ADDR3, NULL)
REMIT_TO_STREET_LINE4	Fourth line of the address.	VARCHAR2(0)	NA	NA
SUBMISSION_NUMBER	Last submission number used for this invoice if it was recurring or re-established.	NUMBER(3)	FABINVH	FABINVH_SUBMISSION_NUMBER
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)	CALCULATION	DECODE(FABINVH_VEND_PIDM, NULL, FABINVH_ONE_TIME_VEND_NAME, NULL)
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: 8.1