Billing File Store Content UML

Added On: 01/24/17

SQL Table: BILLING_FILE_STORE_CONTENT

Module: UniBill

Type: Entity Status: Active

Java Class: BillingFileStoreContent

Available Fields:

Content
Customer Account Code

Customer Account FK
Id

Last Payment Date
Merchant Account Code

Content

Added On: 01/24/17

SQL Column: CONTENT

Java Field: content

Status: Active

SQL Type: longblob

Java Type: byte[]

Attributes:

Customer Account Code

Added On: 01/24/17

SQL Column: CUSTOMER_ACCOUNT_CODE

Java Field: customerAccountCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Customer Account FK

Added On: 01/25/17

SQL Column: CUSTOMER_ACCOUNT_FK

Java Field: customerAccount

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Customer Account

Attributes:

Added On: 01/24/17

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.

Last Payment Date

Added On: 01/24/17

SQL Column: LAST_PAYMENT_DATE

Java Field: lastPaymentDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Merchant Account Code

Added On: 01/24/17

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.