Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADDITIONAL_CHARGES_AMOUNT	Amount of additional charges for the commodity record.	NUMBER	FARINVC	FARINVC_ADDL_CHRG_AMT
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)
APPROVED_QUANTITY	Number of items approved for payment processing on this invoice item.	NUMBER	FARINVC	FARINVC_APPR_QTY
APPROVED_UNIT_PRICE	Unit amount approved for payment on this invoice item.	NUMBER	FARINVC	FARINVC_APPR_UNIT_PRICE
COMMODITY	User-defined code associated with this commodity.	VARCHAR2(10)	FARINVC	FARINVC_COMM_CODE
COMMODITY_DESC	Commodity description or title.	VARCHAR2(50)	FUNCTION	GOKODSF.F_GET_DESC
COMMODITY_HOLD_IND	An attribute used to place invoice records on hold to prevent disbursement to a vendor.	VARCHAR2(1)	FARINVC	FARINVC_HOLD_IND
COMMODITY_UNIT_OF_MEASURE	Code that depicts the unit of measure applicable to the selected commodity.	VARCHAR2(4)	FARINVC	FARINVC_UOMS_CODE
COMMODITY_UNIT_OF_MEASURE_DESC	Unit of measure description.	VARCHAR2(35)	FTVUOMS	FTVUOMS_DESC
CONVERTED_ADDITIONAL_AMOUNT	Base currency additional charges amount calculated for this commodity record.	NUMBER	FARINVC	FARINVC_CONVERT_ADDL_CHRG_AMT
CONVERTED_DISCOUNT_AMOUNT	Base currency discount amount calculated for this commodity record.	NUMBER	FARINVC	FARINVC_CONVERT_DISC_AMT
CONVERTED_TAX_AMOUNT	Base currency tax amount calculated for this commodity record.	NUMBER	FARINVC	FARINVC_CONVERT_TAX_AMT
CONVERTED_UNIT_PRICE	Base currency unit price calculated for this commodity record.	NUMBER	FARINVC	FARINVC_CONVERT_UNIT_PRICE
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DISCOUNT_AMOUNT	Value of the discount taken on the invoice or purchase order accounting amount.	NUMBER	FARINVC	FARINVC_DISC_AMT
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
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(0)	NA	NA
INVOICE	Invoice document number.	VARCHAR2(8)	FARINVC	FARINVC_INVH_CODE
INVOICE_ITEM	Unique system generated one-up sequence number directly associated to an item on the commodity record.	NUMBER	FARINVC	FARINVC_ITEM
ITEM		NUMBER
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
PURCHASE_ORDER	User-defined or system assigned one-up purchase order number issued to this vendor.	VARCHAR2(8)	FARINVC	FARINVC_POHD_CODE
PURCHASE_ORDER_ITEM	System assigned one-up number of the commodity on the purchase order item.	NUMBER	FARINVC	FARINVC_PO_ITEM
TAX_AMOUNT	Amount of tax computed or entered for a document item.	NUMBER	FARINVC	FARINVC_TAX_AMT
TAX_GROUP	Tax group code to be used for this commodity record.	VARCHAR2(4)	FARINVC	FARINVC_TGRP_CODE
TAX_GROUP_DESC	Tax group description.	VARCHAR2(35)	FTVTGRP	FTVTGRP_TITLE
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: