Address UML

Added On: 06/12/12

SQL Table: ADDRESS

Module: UniBill

Type: Entity Status: Active

Java Class: Address

Available Fields:

Address
Address CL
Address Source CL
Bad Reason
Base Object Code
City
Country Code
Create Date
Customer Account FK
Customer FK
Id

Is Bad
Is Collections Letter Sent1
Is Collections Letter Sent2
Is Collections Letter Sent3
Is Collections Letter Sent4
Is Collections Letter Sent5
Is Notification Letter Sent1
Is Notification Letter Sent2
Is Notification Letter Sent3
Is Skip TraceAllowed
Last Invoice Notification Letter Sent Date

Last Skip Trace Date
Last Statement Letter Sent Date
Last Update Date
Merchant Account Code
Name
Ref Code
Ref Creator Code
Ref ID
State
Street 1
Street 2

ZIP Code

Address

Added On: 06/06/18

SQL Column: ADDRESS

Java Field: address

Status: Active

SQL Type: varchar(321)

Java Type: String

Attributes: Calculated

Address associated with a payment card or bank account holder. The value is a concatenation of the street1, street2, city, state, zipCode, countryCode field values separated by commas (,).

Address CL

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.

Address Source CL

Added On: 06/12/12

SQL Column: ADDRESS_SOURCE_CL

Java Field: addressSourceCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Address Source Classifier

Attributes:

Represents the way the address information was obtained.

Bad Reason

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.

Base Object Code

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.

City

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.

Country Code

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.

Create Date

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

Customer Account FK

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.

Customer FK

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: 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.

Is Bad

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.

Is Collections Letter Sent1

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.

Is Collections Letter Sent2

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.

Is Collections Letter Sent3

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.

Is Collections Letter Sent4

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.

Is Collections Letter Sent5

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.

Is Notification Letter Sent1

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.

Is Notification Letter Sent2

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.

Is Notification Letter Sent3

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.

Is Skip TraceAllowed

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.

Last Invoice Notification Letter Sent Date

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.

Last Skip Trace Date

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.

Last Statement Letter Sent Date

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.

Last Update Date

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.

Merchant Account Code

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.

Name

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.

Ref Code

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 TidyPay and integrated systems.

Ref Creator Code

Added On: 06/12/12

SQL Column: REF_CREATOR_CODE

Java Field: refCreatorCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Ref ID

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 TidyPay and integrated systems.

State

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.

Street 1

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.

Street 2

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.

ZIP Code

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.

All Logos and Trademarks used or mentioned on this page are copyrighted property of their respective owners and are used for display purposes only.