# CTI Configuration

The following DB2 physical files are used to configure your CTI installation.

### CTICFGENV

This file stores environment-level configuration for CTI. This includes which webservice endpoints are available, whether or not a proxy is used for communication, and logging and report downloading directories.

| Field Name | Long Field Name | Data Type | Field Title | Comments |
|---|---|---|---|---|
| `MERCHANTID` | `MERCHANTID` | `VARCHAR(30)` | Merchant ID |  |
| `LOGDIR` | `LOGDIR` | `VARCHAR(512)` | Logging Directory |  |
| `DOWNLDDIR` | `DOWNLDDIR` | `VARCHAR(512)` | Download Directory |  |
| `PLUGINDIR` | `PLUGINDIR` | `VARCHAR(512)` | Plugin Directory |  |
| `TMPDIR` | `TMPDIR` | `VARCHAR(512)` | Temporary Directory |  |
| `TESTWSURL` | `TESTWSURL` | `VARCHAR(1024)` | CyberSource Test WebService URL |  |
| `PRODWSURL` | `PRODWSURL` | `VARCHAR(1024)` | CyberSource Prod WebService URL |  |
| `TESTRPTURL` | `TESTRPTURL` | `VARCHAR(1024)` | CyberSource Test Reporting URL |  |
| `PRODRPTURL` | `PRODRPTURL` | `VARCHAR(1024)` | CyberSource Prod Reporting URL |  |
| `PROXYURL` | `PROXYURL` | `VARCHAR(1024)` | Proxy URL |  |
| `PROXYUSER` | `PROXYUSER` | `VARCHAR(60)` | Proxy Username |  |
| `PROXYPASS` | `PROXYPASS` | `VARCHAR(60)` | Proxy Password |  |
| `TESTAPIURL` | `TESTAPIURL` | `VARCHAR(1024)` | CyberSource Test Reporting API URL |  |
| `PRODAPIURL` | `PRODAPIURL` | `VARCHAR(1024)` | CyberSource Prod Reporting API URL |  |
| `TIMEOUT` | `TIMEOUT` | `VARCHAR(8)` | SSL/Socket Timeout Seconds |  |

### CTICFGCER

This file stores P12 authentication certificate information for CTI. This also includes merchant ID, target environment (*TEST or *PROD), and whether logging is enabled for requests. This file can be managed using the [WRKCTICERT](https://isupport.katointegrations.com/cti/wrkcticert.md) command.

To generate this security key, follow the instructions here: [Generate CyberSource Security Keys](https://isupport.katointegrations.com/cti/cs_keys.md)

| Field Name | Long Field Name | Data Type | Field Title | Comments |
|---|---|---|---|---|
| `MERCHANTID` | `MERCHANTID` | `VARCHAR(30)` | Merchant ID |  |
| `LOGALL` | `LOGALL` | `CHAR(4)` | Log All Requests? |  |
| `WSENV` | `WSENV` | `CHAR(5)` | Environment |  |
| `SERIAL` | `CERTIFICATESERIALNUMBER` | `VARCHAR(32)` | Certificate Serial Number |  |
| `STRDT` | `CERTIFICATESTARTDATE` | `DATE` | Certificate Start Date |  |
| `ENDDT` | `CERTIFICATEENDDATE` | `DATE` | Certificate End Date |  |
| `CERT` | `CERTIFICATE` | `VARCHAR(4096)` | Certificate | Managed by the WRKCTICERT command |
| `PRIVKEY` | `PRIVATEKEY` | `VARCHAR(8192)` | Private Key | Managed by the WRKCTICERT command |
| `AUDTYPE` | `AUDITTYPE` | `CHAR(1)` | Audit Type | Automatically updated field showing type of most recent record change operation |
| `AUDUSER` | `AUDITUSER` | `VARCHAR(18)` | Audit User | Automatically updated field showing username of most recent record change operation |
| `AUDJOBNM` | `AUDITJOBNAME` | `VARCHAR(28)` | Audit Job Name | Automatically updated field showing job name of most recent record change operation |
| `AUDTS` | `AUDITTIME` | `TIMESTAMP` | Audit Timestamp | Automatically updated field showing timestamp of most recent record change operation |

### CTICFGRPT

This file stores reporting credentials added using the [ADDRPTKEY](https://isupport.katointegrations.com/cti/addrptkey.md) command.

| Field Name | Long Field Name | Data Type | Field Title | Comments |
|---|---|---|---|---|
| `MERCHANTID` | `MERCHANTID` | `VARCHAR(30)` | Merchant ID |  |
| `ENV` | `ENVIRONMENT` | `VARCHAR(5)` | CyberSource Environment |  |
| `KEYLABEL` | `KEYLABEL` | `VARCHAR(50)` | Key Label |  |
| `SHAREDKEY` | `SHAREDKEY` | `VARCHAR(36)` | Shared Key |  |
| `SECRETKEY` | `SECRETKEY` | `VARCHAR(50)` | Secret Key |  |