Distribution Statement UML

Added On: 02/18/15

SQL Table: IAPP_DISTRIBUTION_STATEMENT

Module: UniCore

Type: Entity Status: Active

Java Class: DistributionStatement

Entity that represents general information about distribution statement.

Available Fields:

Adjusted Amount
Amount
Approver Code
Create Date
Distribution Schema FK

Distribution Statement Detail FK
Due Date
Email Sent Date
End Date
Id

Note
Remitter Code
Remitter FK
Reseller FK
Start Date

Status CL
Transaction Code

Adjusted Amount

Added On: 02/18/15

SQL Column: ADJUSTED_AMOUNT

Java Field: adjustedAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total amount on the statement after adjustments.
If adjusted amount is below the original amount, it means that:

1) the money has been withdrawn "manually", or
2) the balance in the previous statement was negative.

If adjusted amount is above the original one, it means that:

1) the money has been added manually, or
2) some former debt has been returned, or
3) the money from reserve has been returned.

Amount

Added On: 02/18/15

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

The amount element defines the amount of the transaction. Supply the value in cents without a decimal point.

Approver Code

Added On: 02/18/15

SQL Column: APPROVER_CODE

Java Field: approverCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Code of the user that approved the statement.

Create Date

Added On: 02/18/15

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created

Distribution Schema FK

Added On: 02/18/15

SQL Column: DISTRIBUTION_SCHEMA_FK

Java Field: distributionSchema

Status: Active

SQL Type: int(11)

Java Type: Integer

References Distribution Schema

Attributes:

Reference to the entity that represents distribution schema information.

Distribution Statement Detail FK

Added On: 08/31/16

SQL Column: DISTRIBUTION_STATEMENT_DETAIL_FK

Java Field: distributionStatementDetails

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Distribution Statement Detail

Attributes:

Reference to the entity that represents distribution statement details information.

Due Date

Added On: 02/18/15

SQL Column: DUE_DATE

Java Field: dueDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Email Sent Date

Added On: 02/18/15

SQL Column: EMAIL_SENT_DATE

Java Field: emailSentDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the email was sent.

End Date

Added On: 02/18/15

SQL Column: END_DATE

Java Field: endDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Distribution statement end date.

Added On: 02/18/15

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.

Note

Added On: 02/18/15

SQL Column: NOTE

Java Field: note

Status: Active

SQL Type: varchar(1024)

Java Type: String

Attributes:

Any additional information about the distribution statement.

Remitter Code

Added On: 02/18/15

SQL Column: REMITTER_CODE

Java Field: remitterCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Code of the remitter.

Remitter FK

Added On: 03/02/15

SQL Column: REMITTER_FK

Java Field: remitter

Status: Active

SQL Type: int(11)

Java Type: Integer

References Merchant

Attributes:

Reference to the entity that represents the merchant who is remitter in the gateway.

Reseller FK

Added On: 02/18/15

SQL Column: RESELLER_FK

Java Field: reseller

Status: Active

SQL Type: int(11)

Java Type: Integer

References Reseller

Attributes:

Reference to the entity that represents reseller information.

Start Date

Added On: 02/18/15

SQL Column: START_DATE

Java Field: startDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Distribution statement start date.

Status CL

Added On: 02/18/15

SQL Column: STATUS_CL

Java Field: statusCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Statement Status Classifier

Attributes:

Represents current (or selected) status of the statement.

Transaction Code

Added On: 02/18/15

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: varchar(24)

Java Type: String

Attributes:

Code of the initial transaction.