Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
AFFILIATION_KEY		NUMBER				NO
CURRENCY_DESC	Currency code description or title.	VARCHAR2(35)	GUACURR	GTVCURR_TITLE	NO	NO
CURRENCY_KEY		NUMBER				NO
CURRENT_DATE	SYSDATE.	DATE	FUNCTION	SYSDATE	NO	NO
DELEGATE_UID		NUMBER				NO
DIRECT_DEPOSIT_OVERRIDE_IND	Indicates if the reimbursement will be paid with a check versus direct deposit when the expense owner is set up for direct deposit. (Y)es, override the direct deposit and pay with a check. (N)o, do not override the direct deposit.	VARCHAR2(1)	FTRBREMB	DIRECT_DEPOSIT_OVERRIDE_IND	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	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
OWNER_ADDRESS_NUMBER	Sequence used to identify different addresses within the same address type.	NUMBER	FTRBREMB	OWNER_ADDRESS_SEQ_NUM	NO	NO
OWNER_ADDRESS_TYPE	Unique code used with a sequence number to determine the actual address of the expense owner.	VARCHAR2(2)	FTRBREMB	OWNER_ADDRESS_TYPE_CODE	NO	NO
OWNER_EMAIL	Email address of the expense owner as contact information for workflow approvals.	VARCHAR2(128)	FTRBREMB	EMAIL_ADDRESS	NO	NO
OWNER_UID	Personal identification number of the expense owner.	NUMBER	FTRBREMB	OWNER_PIDM	NO	NO
PAYEE_ADDRESS_NUMBER	Sequence used to identify different addresses within the same address type.	NUMBER	FTRBREMB	PAYEE_ADDRESS_SEQ_NUM	NO	NO
PAYEE_ADDRESS_TYPE	Unique code use with a sequence number to determine the actual address of the expense payee.	VARCHAR2(2)	FTRBREMB	PAYEE_ADDRESS_TYPE_CODE	NO	NO
PAYEE_UID	Personal identification number of the payee when the funding source is saved as part of the profile. This is who the check will be cut to for the invoice.	NUMBER	FTRBREMB	PAYEE_PIDM	NO	NO
PAY_CURRENCY_EXCHANGE_RATE		NUMBER				NO
PORTFOLIO_KEY	Unique internal identification number of the portfolio record.	NUMBER	FTRBREMB	FTPBPORT_ID	NO	NO
REIMBURSEMENT	System generated code identifying the reimbursement. The prefix is defined by the client for system ID TRAVREIM in the table fobfseq.	VARCHAR2(8)	FTRBREMB	DOC_CODE	NO	NO
REIMBURSEMENT_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	FTRBREMB	ACTIVITY_DATE	NO	NO
REIMBURSEMENT_COMMENT	Free-form comment for the reimbursement.	VARCHAR2(4000)	FTRBREMB	USER_COMMENT	NO	NO
REIMBURSEMENT_COMPLETE_USER	Banner ID of the person who completed this reimbursement.	VARCHAR2(30)	FTRBREMB	COMPLETE_USER	NO	NO
REIMBURSEMENT_CREATE_DATE	Date and time when the new reimbursement record was created.	DATE	FTRBREMB	CREATE_DATE	NO	NO
REIMBURSEMENT_CREATE_SOURCE	Source system that created the data.	VARCHAR2(30)	FTRBREMB	CREATE_SOURCE	NO	NO
REIMBURSEMENT_CREATE_USER	Banner ID of the person who created this new record.	VARCHAR2(30)	FTRBREMB	CREATE_USER	NO	NO
REIMBURSEMENT_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(30)	FTRBREMB	DATA_ORIGIN	NO	NO
REIMBURSEMENT_DESC	Reimbursement request description.	VARCHAR2(255)	FTRBREMB	DESCRIPTION	NO	NO
REIMBURSEMENT_KEY	Unique internal identification number of the reimbursement record.	NUMBER	FTRBREMB	ID	NO	NO
REIMBURSEMENT_STATUS	Reimbursement request status.	VARCHAR2(1)	FTRBREMB	REQUEST_STATUS	NO	NO
REIMBURSEMENT_STATUS_DATE	Date and time the status was updated.	DATE	FTRBREMB	STATUS_DATE	NO	NO
REIMBURSEMENT_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	FTRBREMB	USER_ID	NO	NO
REIMBURSE_CURRENCY	Currency code used to indicate the base currency in which to be reimbursed.	VARCHAR2(4)	FTRBREMB	CURRENCY_CODE	NO	NO
REPORT_NAME	Owner assigned expense report name.	VARCHAR2(60)	FTRBREMB	NAME	NO	NO
REVIEW_SUBMIT_DATE		TIMESTAMP(6)				NO
TRANSACTION_DATE	Date used to post the invoice into the ledgers for payment, determining the fiscal year and posting period. Represents the create date of the reimbursement.	DATE	FTRBREMB	TRANSACTION_DATE	NO	NO
TRAVELER_AFFILIATION		VARCHAR2(25)				NO
TRAVELER_AFFILIATION_DESC		VARCHAR2(255)				NO
WIRE_AMOUNT		NUMBER				NO
WIRE_DATE		TIMESTAMP(6)				NO
WIRE_REFERENCE_NUMBER		VARCHAR2(30)				NO
WIRE_REIMBURSEMENT_IND		VARCHAR2(1)				NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: