Paper Statement UML


Added On:  02/13/12 
SQL Table:  PAPER_STATEMENT 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  PaperStatement 
Added On:  02/13/12
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly
Identifier of the object used for references; auto-incremented integer value.
Added On:  02/13/12
SQL Column:  MERCHANT_NAME
Java Field:  merchantName
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  MERCHANT_STREET1
Java Field:  merchantStreet1
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  MERCHANT_STREET2
Java Field:  merchantStreet2
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  MERCHANT_CITY
Java Field:  merchantCity
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  MERCHANT_STATE
Java Field:  merchantState
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  MERCHANT_ZIP_CODE
Java Field:  merchantZipCode
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  MERCHANT_PHONE
Java Field:  merchantPhone
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  MERCHANT_EMAIL
Java Field:  merchantEmail
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  MERCHANT_MAIL_NAME
Java Field:  merchantMailName
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  HEADER_MESSAGE
Java Field:  headerMessage
Status:  Active
SQL Type:  varchar(2048)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  FOOTER_MESSAGE
Java Field:  footerMessage
Status:  Active
SQL Type:  varchar(2048)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CUSTOMER_ACCOUNT_CODE
Java Field:  customerAccountCode
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CUSTOMER_ACCOUNT_FIRST_NAME
Java Field:  customerAccountFirstName
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CUSTOMER_ACCOUNT_LAST_NAME
Java Field:  customerAccountLastName
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CUSTOMER_ACCOUNT_STREET
Java Field:  customerAccountStreet
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CUSTOMER_ACCOUNT_CITY
Java Field:  customerAccountCity
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CUSTOMER_ACCOUNT_STATE
Java Field:  customerAccountState
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  CUSTOMER_ACCOUNT_ZIP_CODE
Java Field:  customerAccountZipCode
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  02/13/12
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required
Code of Merchant Account to which instance of this object is attributed to.
Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.
Added On:  02/13/12
SQL Column:  STATEMENT_FILE_BATCH_FK
Java Field:  statementFileBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents statement file batch information.
Added On:  07/14/16
SQL Column:  PAPER_STATEMENT_DETAIL_FK
Java Field:  paperStatementDetails
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents additional paper statement details information.