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

Ver: