Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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	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(4)		FARINVC	FARINVC_ITEM
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(4)		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: