Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADDITIONAL_CHARGES_AMOUNT	Amount of additional charges for the commodity record.	NUMBER	FARINVC	FARINVC_ADDL_CHRG_AMT	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
APPROVED_ITEM_AMOUNT	Calculation to determine the actual cost of an item.	NUMBER	CALCULATION	(NVL(FARINVC_APPR_QTY,0)*NVL(FARINVC_APPR_UNIT_PRICE,0))+NVL(FARINVC_ADDL_CHRG_AMT,0)+NVL(FARINVC_TAX_AMT,0)-NVL(FARINVC_DISC_AMT,0)	NO	NO
APPROVED_QUANTITY	Number of items approved for payment processing on this invoice item.	NUMBER	FARINVC	FARINVC_APPR_QTY	NO	NO
APPROVED_UNIT_PRICE	Unit amount approved for payment on this invoice item.	NUMBER	FARINVC	FARINVC_APPR_UNIT_PRICE	NO	NO
COMMODITY	User-defined code associated with this commodity.	VARCHAR2(63)	FARINVC	FARINVC_COMM_CODE	NO	NO
COMMODITY_DESC	Commodity description or title.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
COMMODITY_HOLD_IND	An attribute used to place invoice records on hold to prevent disbursement to a vendor.	VARCHAR2(63)	FARINVC	FARINVC_HOLD_IND	NO	NO
COMMODITY_UNIT_OF_MEASURE	Code that depicts the unit of measure applicable to the selected commodity.	VARCHAR2(63)	FARINVC	FARINVC_UOMS_CODE	NO	NO
COMMODITY_UNIT_OF_MEASURE_DESC	Unit of measure description.	VARCHAR2(255)	FTVUOMS	FTVUOMS_DESC	NO	NO
CONVERTED_ADDITIONAL_AMOUNT	Base currency additional charges amount calculated for this commodity record.	NUMBER	FARINVC	FARINVC_CONVERT_ADDL_CHRG_AMT	NO	NO
CONVERTED_DISCOUNT_AMOUNT	Base currency discount amount calculated for this commodity record.	NUMBER	FARINVC	FARINVC_CONVERT_DISC_AMT	NO	NO
CONVERTED_TAX_AMOUNT	Base currency tax amount calculated for this commodity record.	NUMBER	FARINVC	FARINVC_CONVERT_TAX_AMT	NO	NO
CONVERTED_UNIT_PRICE	Base currency unit price calculated for this commodity record.	NUMBER	FARINVC	FARINVC_CONVERT_UNIT_PRICE	NO	NO
DISCOUNT_AMOUNT	Value of the discount taken on the invoice or purchase order accounting amount.	NUMBER	FARINVC	FARINVC_DISC_AMT	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(63)	NA	NA	NO	NO
INVOICE	Invoice document number.	VARCHAR2(63)	FARINVC	FARINVC_INVH_CODE	NO	NO
ITEM	Literal commodity or goods description associated with an invoice processing record. The unique sequence number directly associated with an item on the commodity record.	NUMBER	FARINVC	FARINVC_ITEM	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
PURCHASE_ORDER	User-defined or system assigned one-up purchase order number issued to this vendor.	VARCHAR2(63)	FARINVC	FARINVC_POHD_CODE	NO	NO
PURCHASE_ORDER_ITEM	System assigned one-up number of the commodity on the purchase order item.	NUMBER	FARINVC	FARINVC_PO_ITEM	NO	NO
TAX_AMOUNT	Amount of tax computed or entered for a document item.	NUMBER	FARINVC	FARINVC_TAX_AMT	NO	NO
TAX_GROUP	Tax group code to be used for this commodity record.	VARCHAR2(63)	FARINVC	FARINVC_TGRP_CODE	NO	NO
TAX_GROUP_DESC	Tax group description.	VARCHAR2(255)	FTVTGRP	FTVTGRP_TITLE	NO	NO

Ver: 9.2