Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Organization-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(63)	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(63)	FABINVH	FABINVH_COMPLETE_IND
CREDIT_MEMO_IND	Indicator identifies invoices for which a credit memo has been processed.	VARCHAR2(63)	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
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(63)	FABINVH	FABINVH_1099_IND
HOLD_IND	Indicates if invoice records are on hold to prevent disbursement to a vendor.	VARCHAR2(63)	FABINVH	FABINVH_HOLD_IND
INVOICE	Invoice document number.	VARCHAR2(63)	FABINVH	FABINVH_CODE
INVOICE_DATE	Date of the invoice.	DATE	FABINVH	FABINVH_INVOICE_DATE
INVOICE_METHOD	Invoice method.	VARCHAR2(63)	NA	NA
INVOICE_METHOD_DESC	Invoice method description.	VARCHAR2(255)	NA	NA
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
MULTIPLE_INVOICE_IND	Indicates whether this invoice contains multiple vendor invoices.	VARCHAR2(63)	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
ONE_TIME_VENDOR_ADDRESS_IND	Indicates if the remit-to address is a one-time vendor address.	VARCHAR2(63)	CALCULATION	DECODE(FABINVH_ATYP_CODE,NULL,'Y','N')
OPEN_PAID_IND	Indicates if a document is open or paid.	VARCHAR2(63)	FABINVH	FABINVH_OPEN_PAID_IND
PAYMENT_DUE_DATE	Date an invoice is due to be paid by check.	DATE	FABINVH	FABINVH_PMT_DUE_DATE
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
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
SUBMISSION_NUMBER	Last submission number used for this invoice if it was recurring or re-established.	NUMBER	FABINVH	FABINVH_SUBMISSION_NUMBER
THIRD_PARTY_ADDRESS_IND	Indicates if the remit-to address is a third party address.	VARCHAR2(63)	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.1