Tsys Merchant Statement Detail

Added On:  10/30/18 

SQL Table:  TSYS_MERCHANT_STATEMENT_DETAIL 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  TsysMerchantStatementDetail 

Available Fields:

• Account Number
• Account Type
• Ach Hierarchy Level
• Ach Table
• Amount
• Association Number
• Bank Number

• Card Type
• Chargeback Case Number
• Dda Number
• Debit Credit Indicator
• Effective Date
• Esid
• Group Number

• Id
• Merchant Account Code
• Merchant Dba Name
• Processing Date
• Record Sequence Number
• Reference Number
• Routing Number

• Transaction Types
• Tsys Merchant Statement

Account Number

Added On:  10/29/18

SQL Column:  ACCOUNT_NUMBER

Java Field:  accountNumber

Status:  Active

SQL Type:  varchar(16)

Java Type:  String

Attributes:

Account Type

Added On:  10/29/18

SQL Column:  ACCOUNT_TYPE

Java Field:  accountType

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Ach Hierarchy Level

Added On:  10/29/18

SQL Column:  ACH_HIERARCHY_LEVEL

Java Field:  achHierarchyLevel

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Ach Table

Added On:  10/29/18

SQL Column:  ACH_TABLE

Java Field:  achTable

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Amount

Added On:  10/29/18

SQL Column:  AMOUNT

Java Field:  amount

Status:  Active

SQL Type:  varchar(17)

Java Type:  String

Attributes:

Association Number

Added On:  10/29/18

SQL Column:  ASSOCIATION_NUMBER

Java Field:  associationNumber

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Bank Number

Added On:  10/29/18

SQL Column:  BANK_NUMBER

Java Field:  bankNumber

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Card Type

Added On:  10/29/18

SQL Column:  CARD_TYPE

Java Field:  cardType

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Chargeback Case Number

Added On:  10/29/18

SQL Column:  CHARGEBACK_CASE_NUMBER

Java Field:  chargebackCaseNumber

Status:  Active

SQL Type:  varchar(13)

Java Type:  String

Attributes:

Dda Number

Added On:  10/29/18

SQL Column:  DDA_NUMBER

Java Field:  ddaNumber

Status:  Active

SQL Type:  varchar(17)

Java Type:  String

Attributes:

Debit Credit Indicator

Added On:  10/29/18

SQL Column:  DEBIT_CREDIT_INDICATOR

Java Field:  debitCreditIndicator

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Effective Date

Added On:  10/29/18

SQL Column:  EFFECTIVE_DATE

Java Field:  effectiveDate

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Esid

Added On:  10/29/18

SQL Column:  ESID

Java Field:  esid

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Group Number

Added On:  10/29/18

SQL Column:  GROUP_NUMBER

Java Field:  groupNumber

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Id

Added On:  10/29/18

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes: Unique, Required, CreateOnly, ReadOnly

Merchant Account Code

Added On:  10/29/18

SQL Column:  MERCHANT_ACCOUNT_CODE

Java Field:  merchantAccountCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Merchant Dba Name

Added On:  10/29/18

SQL Column:  MERCHANT_DBA_NAME

Java Field:  merchantDbaName

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Processing Date

Added On:  10/29/18

SQL Column:  PROCESSING_DATE

Java Field:  processingDate

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Record Sequence Number

Added On:  10/29/18

SQL Column:  RECORD_SEQUENCE_NUMBER

Java Field:  recordSequenceNumber

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Reference Number

Added On:  10/29/18

SQL Column:  REFERENCE_NUMBER

Java Field:  referenceNumber

Status:  Active

SQL Type:  varchar(16)

Java Type:  String

Attributes:

Routing Number

Added On:  10/29/18

SQL Column:  ROUTING_NUMBER

Java Field:  routingNumber

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

Transaction Types

Added On:  10/29/18

SQL Column:  TRANSACTION_TYPES

Java Field:  transactionTypes

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Tsys Merchant Statement

Added On:  10/29/18

SQL Column:  TSYS_MERCHANT_STATEMENT_FK

Java Field:  tsysMerchantStatement

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Tsys Merchant Statement

Attributes: