Funds Distribution UML


Added On:  01/09/15 
SQL Table:  FUNDS_DISTRIBUTION 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  FundsDistribution 
Added On:  01/09/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.
Added On:  01/09/15
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:  01/09/15
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was created
Added On:  01/09/15
SQL Column:  SEQUENCE_NUMBER
Java Field:  sequenceNumber
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/09/15
SQL Column:  DESTINATION_CL
Java Field:  destinationCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Represents the selected type of funds destination.
Added On:  01/09/15
SQL Column:  DESTINATION_CODE
Java Field:  destinationCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/09/15
SQL Column:  BASE_AMOUNT
Java Field:  baseAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Base amount of the transaction, not including freight, handling, and tax amounts.
Added On:  01/09/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.
Added On:  01/09/15
SQL Column:  NET_AMOUNT
Java Field:  netAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/09/15
SQL Column:  CONVENIENCE_FEE_AMOUNT
Java Field:  convenienceFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/09/15
SQL Column:  TAX_AMOUNT
Java Field:  taxAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/09/15
SQL Column:  VENDOR_AMOUNT
Java Field:  vendorAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/09/15
SQL Column:  GROSS_AMOUNT
Java Field:  grossAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/09/15
SQL Column:  BALANCE_CL
Java Field:  balanceCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Represents the type of funds balance selected.
Added On:  01/09/15
SQL Column:  DISTRIBUTION_SCHEMA_CODE
Java Field:  distributionSchemaCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  01/09/15
SQL Column:  DISTRIBUTION_SCHEMA_DETAIL_CODE
Java Field:  distributionSchemaDetailCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  01/09/15
SQL Column:  CHARGE_TRANSACTION_FK
Java Field:  chargeTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Charge Transaction
Attributes:
Reference to the entity that represents real-time financial transaction.
Added On:  01/09/15
SQL Column:  CHARGEBACK_TRANSACTION_FK
Java Field:  chargebackTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to a chargeback transaction representing either initial chargeback (for credit cards) or ACH return (for bank accounts). If not chargeback/return came in, the field is not set. The field is primarily used to quickly identify transactions that have chargebacks/returns.