Reconciliation Profile

Parent:    Processing Profile

Added On:  05/16/18 

SQL Table:  RECONCILIATION_PROFILE 

Module:  UniCharge 

Type:  Profile  Status:  Active 

Java Class:  ReconciliationProfile 

Available Fields:

• Account Number
• Api Key
• Api Key Expiration Date
• Client Id

• Client Secret
• Connectivity Mode Cl
• Country Code
• Id

• Last Fee Detail Import Date
• Last Transaction Detail Import Date
• Merchant Id
• Password

• Provider Name
• Reconciliation Profile Cl

Account Number

Added On:  10/24/23

SQL Column:  ACCOUNT_NUMBER

Java Field:  accountNumber

Status:  Active

SQL Type:  varchar(35)

Java Type:  String

Attributes:

Api Key

Added On:  10/24/23

SQL Column:  API_KEY

Java Field:  apiKey

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Api Key Expiration Date

Added On:  10/24/23

SQL Column:  API_KEY_EXPIRATION_DATE

Java Field:  apiKeyExpirationDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Client Id

Added On:  10/24/23

SQL Column:  CLIENT_ID

Java Field:  clientId

Status:  Active

SQL Type:  varchar(80)

Java Type:  String

Attributes:

Client Secret

Added On:  10/24/23

SQL Column:  CLIENT_SECRET

Java Field:  clientSecret

Status:  Active

SQL Type:  varchar(80)

Java Type:  String

Attributes:

Connectivity Mode Cl

Added On:  10/12/17

SQL Column:  CONNECTIVITY_MODE_CL

Java Field:  connectivityModeCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References Connectivity Mode Classifier

Attributes:

Country Code

Added On:  11/27/23

SQL Column:  COUNTRY_CODE

Java Field:  countryCode

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Country code of the Merchant.

Id

Added On:  10/12/17

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes:

Last Fee Detail Import Date

Added On:  10/12/17

SQL Column:  LAST_FEE_DETAIL_IMPORT_DATE

Java Field:  lastFeeDetailImportDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Last Transaction Detail Import Date

Added On:  10/12/17

SQL Column:  LAST_TRANSACTION_DETAIL_IMPORT_DATE

Java Field:  lastTransactionDetailImportDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Merchant Id

Added On:  10/12/17

SQL Column:  MERCHANT_ID

Java Field:  merchantId

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Password

Added On:  10/12/17

SQL Column:  PASSWORD

Java Field:  password

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Provider Name

Added On:  11/27/23

SQL Column:  PROVIDER_NAME

Java Field:  providerName

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Reconciliation Profile Cl

Added On:  10/12/17

SQL Column:  RECONCILIATION_PROFILE_CL

Java Field:  reconciliationProfileCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References Reconciliation Profile Classifier

Attributes: