Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTUAL_TAX_AMOUNT	Receipt tax portion of the entered receipt amount.	NUMBER(17,2)	FTPRETAX	ACTUAL_TAX_AMOUNT
CALCULATED_TAX_AMOUNT	Tax amount calculated in base currency.	NUMBER(17,2)	FTPRETAX	CALCULATED_TAX_AMOUNT
CURRENT_DATE	This is a the system current date (sysdate).	DATE	NA	SYSDATE
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
EXPENSE_ITEM_KEY	Unique internal identification number of the expense tax item record.	NUMBER(19)	FTPRETAX	FTPREXPS_ID
EXPENSE_TAX_ITEM_KEY	Unique internal identification number of the expense tax item record.	NUMBER(19)	FTPRETAX	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
PAY_TAX_AMOUNT	Tax amount calculated in pay currency.	NUMBER(17,2)	FTPRETAX	PAY_TAX_AMOUNT
RATE	Sales or or use tax withholding rate expressed as a percentage.	VARCHAR2(40)	FTVTRAT	FTVTRAT_RATE
TAX_ITEM_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	TIMESTAMP(6)	FTPRETAX	ACTIVITY_DATE
TAX_ITEM_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(30)	FTPRETAX	DATA_ORIGIN
TAX_ITEM_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	FTPRETAX	USER_ID
TAX_RATE	Tax rate code used to caluclate the tax amount.	VARCHAR2(4)	FTPRETAX	TAX_RATE_CODE
TAX_RATE_DESC	Tax rate description.	VARCHAR2(35)	FTVTRAT	FTVTRAT_DESC
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: