EXM_CC_DOWNLOAD_PARAMS

This table contains the parameters used to automatically download corporate card transaction files from a card issuer's server.

Details

• Schema: FUSION

• Object owner: EXM

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
EXM_CC_DOWNLOAD_PARAMS_PK	CC_DOWNLOAD_PARAM_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CC_DOWNLOAD_PARAM_ID	NUMBER		18	Yes	Unique identifier of the download parameter set.
DOWNLOAD_PROFILE_NAME	VARCHAR2	80		Yes	Name that identifies a set of download parameters.
CARD_PROGRAM_ID	NUMBER		18		Identifier of the corporate card program for which download parameters are defined.
COMPANY_ACCOUNT_ID	NUMBER		18		Identifier of the company account for which download parameters are defined.
OVERRIDE_CP_DEFAULTS_FLAG	VARCHAR2	1			Indicator of whether to use company account-specific download parameters.
USERNAME	VARCHAR2	100		Yes	Deploying company's account name with card issuer for connecting to the card issuer's server.
ENCRYPTED_PASSWORD	VARCHAR2	255		Yes	Deploying company's account password for card issuer stored encrypted.
REMOTE_FILENAME	VARCHAR2	255		Yes	Partial name of the feed file from the card issuer.
SERVER	VARCHAR2	255		Yes	Corporate card issuer's server from which the application downloads the feed file.
SECURE_DIRECTORY	VARCHAR2	255		Yes	Deploying company's directory where the feed file is stored.
PGP_ENCRYPTION_ALIAS	VARCHAR2	80			An alternative name used to identify the Pretty Good Privacy (PGP) encryption key for a corporate card transaction file.
PGP_SIGNATURE_ALIAS	VARCHAR2	80			An alternate name used to identify a bank's Pretty Good Privacy (PGP) signature key for a corporate card transaction file.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
EXM_CC_DOWNLOAD_PARAMS	exm_card_programs	CARD_PROGRAM_ID
EXM_CC_DOWNLOAD_PARAMS	exm_cc_company_accounts	COMPANY_ACCOUNT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
EXM_CC_DOWNLOAD_PARAMS_N1	Non Unique	Default	CARD_PROGRAM_ID, COMPANY_ACCOUNT_ID
EXM_CC_DOWNLOAD_PARAMS_PK	Unique	Default	CC_DOWNLOAD_PARAM_ID