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 
Added On:  10/29/18
SQL Column:  BANK_NUMBER
Java Field:  bankNumber
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  10/29/18
SQL Column:  GROUP_NUMBER
Java Field:  groupNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  10/29/18
SQL Column:  ASSOCIATION_NUMBER
Java Field:  associationNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  10/29/18
SQL Column:  ACCOUNT_NUMBER
Java Field:  accountNumber
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  10/29/18
SQL Column:  MERCHANT_DBA
Java Field:  merchantDba
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  10/29/18
SQL Column:  PROCESSING_DATE
Java Field:  processingDate
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  10/29/18
SQL Column:  ACH_TABLE
Java Field:  achTable
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  10/29/18
SQL Column:  TOTAL_ACH
Java Field:  totalAch
Status:  Active
SQL Type:  varchar(17)
Java Type:  String
Attributes:
Added On:  10/29/18
SQL Column:  DEBIT_CREDIT_INDICATOR
Java Field:  debitCreditIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  10/29/18
SQL Column:  MERCHANT_STATEMENT_EXTENDED_FK
Java Field:  merchantStatementExtended
Status:  Active
SQL Type:  bigint(20)(16)
Java Type:  Long
Attributes:
Added On:  10/29/18
SQL Column:  CUSTOM_DATA
Java Field:  customData
Status:  Active
SQL Type:  varchar(45)
Java Type:  String
Attributes:
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
Added On:  10/29/18
SQL Column:  FILE_RECORD_TYPE
Java Field:  fileRecordType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes: Transient
Added On:  10/29/18
SQL Column:  CONTENT
Java Field:  content
Status:  Active
SQL Type:  longblob
Java Type:  byte[]
Attributes: Transient
Added On:  10/29/18
SQL Column:  PROCESSING_MONTH
Java Field:  processingMonth
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  10/29/18
SQL Column:  AMOUNT_DEDUCTED
Java Field:  amountDeducted
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  10/29/18
SQL Column:  RECORD_CONTENT
Java Field:  recordContent
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Added On:  10/29/18
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes: