Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTUAL_TAX_AMOUNT	Actual Tax Amount	Receipt tax portion of the entered receipt amount.	NUMBER(17,2)		FTPRETAX	ACTUAL_TAX_AMOUNT
CALCULATED_TAX_AMOUNT	Calculated Tax Amount	Tax amount calculated in base currency.	NUMBER(17,2)		FTPRETAX	CALCULATED_TAX_AMOUNT
CURRENT_DATE	Current Date	This is a the system current date (sysdate).	DATE		NA	SYSDATE
DOMAIN_VALUE	Domain Value	Domain column for future use, not currently populated.	VARCHAR2(6)		NA	NA
EXPENSE_ITEM_KEY	Expense Item KEY	Unique internal identification number of the expense tax item record.	NUMBER(19)		FTPRETAX	FTPREXPS_ID
EXPENSE_TAX_ITEM_KEY	Expense Tax Item KEY	Unique internal identification number of the expense tax item record.	NUMBER(19)		FTPRETAX	ID
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
PAY_TAX_AMOUNT	Pay Tax Amount	Tax amount calculated in pay currency.	NUMBER(17,2)		FTPRETAX	PAY_TAX_AMOUNT
RATE	Rate	Sales or or use tax withholding rate expressed as a percentage.	VARCHAR2(40)		FTVTRAT	FTVTRAT_RATE
TAX_ITEM_ACTIVITY_DATE	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	Tax Item Data Origin	Source system that created or updated the data.	VARCHAR2(30)		FTPRETAX	DATA_ORIGIN
TAX_ITEM_USER_ID	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	Tax rate code used to caluclate the tax amount.	VARCHAR2(4)		FTPRETAX	TAX_RATE_CODE
TAX_RATE_DESC	Tax Rate Description	Tax rate description.	VARCHAR2(35)		FTVTRAT	FTVTRAT_DESC
ZONE_VALUE	Zone Value	Zone column for future use, not currently populated.	VARCHAR2(6)		NA	NA

Ver: