Address UML


Added On:  06/12/12 
SQL Table:  ADDRESS 
Module:  UniBill 
Type:  Entity  Status:  Active 
Java Class:  Address 
Added On:  06/12/12
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly, ReadOnly
Identifier of the object used for references; auto-incremented integer value.
Added On:  06/12/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:  06/12/12
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was created
Added On:  06/12/12
SQL Column:  NAME
Java Field:  name
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Name of the customer.
Added On:  06/12/12
SQL Column:  STREET1
Java Field:  street1
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes: Max Length: 128
Street address of the customer.
Added On:  06/12/12
SQL Column:  STREET2
Java Field:  street2
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes: Max Length: 128
Street address of the customer.
Added On:  06/12/12
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes: Max Length: 50
City of the customer.
Added On:  06/12/12
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes: Max Length: 3
State of the customer.
Added On:  06/12/12
SQL Column:  ZIP_CODE
Java Field:  zipCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes: Max Length: 10
ZIP or postal code of the customer.
Added On:  06/12/12
SQL Column:  REF_CREATOR_CODE
Java Field:  refCreatorCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  06/12/12
SQL Column:  IS_BAD
Java Field:  isBad
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
If checked, the address is invalid.
Added On:  06/12/12
SQL Column:  BAD_REASON
Java Field:  badReason
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
The reason why the address was marked as invalid.
Added On:  06/12/12
SQL Column:  ADDRESS_SOURCE_CL
Java Field:  addressSourceCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the way the address information was obtained.
Added On:  06/12/12
SQL Column:  IS_SKIP_TRACE_ALLOWED
Java Field:  isSkipTraceAllowed
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: true
Indicates whether skip tracing is allowed for this address.
Added On:  06/12/12
SQL Column:  LAST_SKIP_TRACE_DATE
Java Field:  lastSkipTraceDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
The date when this address was skip traced for the last time.
Added On:  06/12/12
SQL Column:  IS_NOTIFICATION_LETTER_SENT1
Java Field:  isNotificationLetterSent1
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Indicates whether the notification letter 1 is sent to the customer.
Added On:  06/12/12
SQL Column:  IS_NOTIFICATION_LETTER_SENT2
Java Field:  isNotificationLetterSent2
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Indicates whether the notification letter 2 is sent to the customer.
Added On:  06/12/12
SQL Column:  IS_NOTIFICATION_LETTER_SENT3
Java Field:  isNotificationLetterSent3
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Indicates whether the notification letter 3 is sent to the customer.
Added On:  06/12/12
SQL Column:  IS_COLLECTIONS_LETTER_SENT1
Java Field:  isCollectionsLetterSent1
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Indicates whether the collections letter 1 is sent to the customer.
Added On:  06/12/12
SQL Column:  IS_COLLECTIONS_LETTER_SENT2
Java Field:  isCollectionsLetterSent2
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Indicates whether the collections letter 2 is sent to the customer.
Added On:  06/12/12
SQL Column:  IS_COLLECTIONS_LETTER_SENT3
Java Field:  isCollectionsLetterSent3
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Indicates whether the collections letter 3 is sent to the customer.
Added On:  06/12/12
SQL Column:  IS_COLLECTIONS_LETTER_SENT4
Java Field:  isCollectionsLetterSent4
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Indicates whether the collections letter 4 is sent to the customer.
Added On:  06/12/12
SQL Column:  IS_COLLECTIONS_LETTER_SENT5
Java Field:  isCollectionsLetterSent5
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default: false
Indicates whether the collections letter 5 is sent to the customer.
Added On:  06/12/12
SQL Column:  CUSTOMER_FK
Java Field:  customer
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Customer
Attributes:
Reference to the entity that represents customer's information.
Added On:  06/12/12
SQL Column:  ADDRESS_CL
Java Field:  addressCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
References Address Classifier
Attributes:
Represents the type of selected address.
Added On:  07/08/12
SQL Column:  CUSTOMER_ACCOUNT_FK
Java Field:  customerAccount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Customer Account
Attributes:
Reference to the entity that represents customer's account information.
Added On:  07/10/12
SQL Column:  REF_CODE
Java Field:  refCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Secondary identifier, which can be used to cross-reference records between UniPay and integrated systems.
Added On:  10/02/12
SQL Column:  LAST_UPDATE_DATE
Java Field:  lastUpdateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the last account update.
Added On:  10/02/12
SQL Column:  COUNTRY_CODE
Java Field:  countryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Country code of the customer's address.
Added On:  10/02/12
SQL Column:  LAST_INVOICE_NOTIFICATION_LETTER_SENT_DATE
Java Field:  lastInvoiceNotificationLetterSentDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the notification letter was sent last time.
Added On:  10/02/12
SQL Column:  LAST_STATEMENT_LETTER_SENT_DATE
Java Field:  lastStatementLetterSentDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the statements letter was sent last time.
Added On:  06/05/14
SQL Column:  BASE_OBJECT_CODE
Java Field:  baseObjectCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
The reference to the Address that was used as the base object for cloning the current object.
Added On:  09/16/16
SQL Column:  
Java Field:  refId
Status:  Active
SQL Type:  
Java Type:  Long
Attributes: Transient
Secondary identifier which can be used to cross-reference records between UniPay and integrated systems.