Database schema for authorization and cash accounts
Card authorization account information and cash account information is kept in the following iMIS tables.
Payflow Pro credit card authorization accounts
The following columns in the CCAuthAcct table are used for each Payflow Pro (PayPay, previously Verisign) card authorization account:
| Column | Data type | Description |
|---|---|---|
| CCAuthAcctCode | varchar (20) | The code for the card authorization account |
| CCAuthAcctDescription | varchar (255) | Description associated with an account code |
| CCAuthMode | tinyint | Authorization mode: 0 (manual), 1 (immediate), or 3 (deferred) |
| CCAuthAdminEmail | varchar (255) | E-mail address of the system administrator responsible for setting up the accounts |
| CCAuthUrl | varchar (255) | URL of the test or live site |
| CCAuthGateway | varchar (255) | Gateway interface through which card authorization occurs |
| CCAuthPort | int | Port address used for transaction processing |
| CCAuthUser | varchar (255) | Username created during setup process |
| CCAuthPassword | varchar (255) | Password created during sign-up process |
| CCAuthVerisignPartner | varchar (255) | Partner name supplied |
| CCAuthVerisignVendor | varchar (255) | Vendor name supplied |
| CCAuthTimeout | int | Timeout period supplied |
| CCAuthVerisignProxyServer | varchar (255) | Proxy server supplied by network administrator |
| CCAuthVerisignProxyPort | varchar (255) | Proxy port supplied by network administrator |
| CCAuthVerisignProxyUser | varchar (255) | Proxy user ID supplied by network administrator |
| CCAuthVerisignProxyPassword | varchar (255) | Proxy password supplied by network administrator |
| CCAuthSaveCscBeforeAuth | tinyint | Handling of CSC value for deferred authorization: 0 (do not save CSC in *iMIS*) or 1 (save encrypted CSC in *iMIS* then delete after successful authorization) |
SafePay credit card authorization accounts
The following columns in the CCAuthAcct table are used for each SafePay (TNS, previously Dialect and QSI) card authorization account:
| Column | Data type | Description |
|---|---|---|
| CCAuthAcctCode | varchar (20) | The code for the card authorization account |
| CCAuthAcctDescription | varchar (255) | Description associated with an account code |
| CCAuthMode | tinyint | Authorization mode: 0 (manual), 1 (immediate), or 3 (deferred) |
| CCAuthAdminEmail | varchar (255) | E-mail address of the system administrator responsible for setting up the accounts |
| CCAuthGateway | varchar (255) | Gateway interface through which card authorization occurs |
| CCAuthUser | varchar (255) | Merchant ID created during setup process |
| CCAuthVerisignPartner | varchar (255) | Merchant Administration login (username) obtained from QSI/Dialect during setup process |
| CCAuthPassword | varchar (255) | Merchant Administration login (username) password obtained from TNS during setup process |
| CCAuthSaveCscBeforeAuth | tinyint | Handling of CSC value for deferred authorization: 0 (do not save CSC in *iMIS*) or 1 (save encrypted CSC in *iMIS* then delete after successful authorization) |
Other gateway credit card authorization accounts
The following columns in the CCAuthAcct table are used for each Other card authorization account:
| Column | Data type | Description |
|---|---|---|
| CCAuthAcctCode | varchar (20) | The code for the card authorization account |
| CCAuthAcctDescription | varchar (255) | Description associated with an account code |
| CCAuthMode | tinyint | Authorization mode: 0 (manual), 1 (immediate), or 3 (deferred) |
| CCAuthGateway | varchar (255) | Gateway interface through which card authorization occurs |
| CCAuthSaveCscBeforeAuth | tinyint | Handling of CSC value for deferred authorization: 0 (do not save CSC in *iMIS*) or 1 (save encrypted CSC in *iMIS*) |
Credit/debit cards cash accounts
The following columns in the Cash_Accounts table are used for each credit/debit card cash account:
| Column | Data type | Description |
|---|---|---|
| CCAuthAcctCode | varchar (20) | The code for the card authorization account |
| CSC\_REQUIRED\_WEB | bit | Indicates whether the CSC value is required on the web: 0 (not required) or 1 (required) |
| CSC\_REQUIRED\_CS | bit | Indicates whether the CSC value is required in *iMIS*: 0 (not required) or 1 (required) |
| ISSUE\_NO\_FLAG | tinyint | Indicates whether the Issue Number field should be displayed in *iMIS* payment entry windows: 0 (not displayed) or 1 (displayed) |
| ISSUE\_DATE\_FLAG | tinyint | Indicates whether the Issue Date field should be displayed in *iMIS* payment entry windows: 0 (not displayed) or 1 (displayed) |