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)