Tsys Merchant Statement UML

Parent:    File Batch

Added On:  10/29/18 

SQL Table:  TSYS_MERCHANT_STATEMENT 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  TsysMerchantStatement 

Available Fields:

• Account Number
• Ach Table
• Amount Deducted
• Association Number
• Bank Number
• Content

• Create Date
• Custom Data
• Debit Credit Indicator
• File Record Type
• Group Number
• Id

• Merchant Dba
• Merchant Statement Extended
• Processing Date
• Processing Month
• Record Content
• Total Ach

Account Number

Added On:  10/29/18

SQL Column:  ACCOUNT_NUMBER

Java Field:  accountNumber

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Ach Table

Added On:  10/29/18

SQL Column:  ACH_TABLE

Java Field:  achTable

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Amount Deducted

Added On:  10/29/18

SQL Column:  AMOUNT_DEDUCTED

Java Field:  amountDeducted

Status:  Active

SQL Type:  varchar(20)

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:

Content

Added On:  10/29/18

SQL Column:  CONTENT

Java Field:  content

Status:  Active

SQL Type:  longblob

Java Type:  byte[]

Attributes: Transient

Create Date

Added On:  10/29/18

SQL Column:  CREATE_DATE

Java Field:  createDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Custom Data

Added On:  10/29/18

SQL Column:  CUSTOM_DATA

Java Field:  customData

Status:  Active

SQL Type:  varchar(45)

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:

File Record Type

Added On:  10/29/18

SQL Column:  FILE_RECORD_TYPE

Java Field:  fileRecordType

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes: Transient

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 Dba

Added On:  10/29/18

SQL Column:  MERCHANT_DBA

Java Field:  merchantDba

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Merchant Statement Extended

Added On:  10/29/18

SQL Column:  MERCHANT_STATEMENT_EXTENDED_FK

Java Field:  merchantStatementExtended

Status:  Active

SQL Type:  bigint(20)(16)

Java Type:  Long

References Merchant Statement Extended

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:

Processing Month

Added On:  10/29/18

SQL Column:  PROCESSING_MONTH

Java Field:  processingMonth

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Record Content

Added On:  10/29/18

SQL Column:  RECORD_CONTENT

Java Field:  recordContent

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Total Ach

Added On:  10/29/18

SQL Column:  TOTAL_ACH

Java Field:  totalAch

Status:  Active

SQL Type:  varchar(17)

Java Type:  String

Attributes: