Sub Batch UML


Parent:    Submission
Added On:  02/13/12 
SQL Table:  SUB_BATCH 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  SubBatch 
Represents a sub-group of transactions within Batch or Retail Cycle.

Sub-batch is maintained for each group of transacions that have their own processing logic. For example, a batch that contains both credit card and ACH transactions will have two sub-batches in it.

Another example is a batch that contains transactions belonging to more than one Merchant Account. In such cases, when processing settings are different for each account, multiple sub-batches are created.

Error transactions are placed in a separate sub-batch. Decline transactions for rebill are placed in a separate sub-batch as well.
Added On:  02/13/12
SQL Column:  TOTAL_COUNT
Java Field:  totalCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Total number of the transactions included in the sub-batch file.
Added On:  02/13/12
SQL Column:  TOTAL_AMOUNT
Java Field:  totalAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Total amount of the sub-batch transactions.
Added On:  02/13/12
SQL Column:  STATUS
Java Field:  status
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
References Status Classifier
Attributes:
Indicates current status of the sub-batch operation.
Added On:  02/13/12
SQL Column:  PROVIDER_CODE
Java Field:  providerCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Name of the provider associated with this sub-batch file.
Added On:  02/13/12
SQL Column:  OPERATION_CL
Java Field:  operationCl
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
References Operation Type
Attributes:
Represents the type of performed sub-batch operation.
Added On:  02/13/12
SQL Column:  REVIEW_CL
Java Field:  reviewCl
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
References Review Classifier
Attributes:
Represents the type of sub-batch operation to be performed after the review.
Added On:  02/13/12
SQL Column:  HAS_DECLINE_TRANSACTIONS
Java Field:  hasDeclineTransactions
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the sub-batch operation has a decline from the processor.
Added On:  02/13/12
SQL Column:  ATTEMPT_DATE
Java Field:  attemptDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
The date of the first attempted sub-batch operation.
Added On:  02/13/12
SQL Column:  RETRY_COUNT
Java Field:  retryCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The number of the sub-batch operation reccurence times.
Added On:  02/13/12
SQL Column:  REMAINING_RETRY_COUNT
Java Field:  remainingRetryCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The number of the sub-batch operation reccurence times left.
Added On:  02/13/12
SQL Column:  PROCESSED_DATE
Java Field:  processedDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
The date when the sub-batch was processed.
Added On:  06/27/12
SQL Column:  SUB_BATCH_CL
Java Field:  subBatchCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the type of sub-batch operation to be performed.
Added On:  09/27/13
SQL Column:  SUB_BATCH_TYPE
Java Field:  subBatchType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Type of the sub-batch operation.
Added On:  03/30/14
SQL Column:  APPROVER_CODE
Java Field:  approverCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Code of the user that approved the operation.
Added On:  01/20/15
SQL Column:  SUB_BATCH_CONTENT_CL
Java Field:  subBatchContentCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Represents current type of sub-batch file content.
Added On:  12/02/15
SQL Column:  IS_RESPONSE_SUPPRESSED
Java Field:  isResponseSuppressed
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the response is suppressed.
Added On:  02/18/16
SQL Column:  IS_LOCKED
Java Field:  isLocked
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates that the database table is blocked.
Added On:  03/25/16
SQL Column:  DUPLICATE_SUB_BATCH_FK
Java Field:  duplicateSubBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Sub Batch
Attributes:
Reference to the entity that represents information about duplicated sub-batch.
Added On:  03/25/16
SQL Column:  HOLD_SUB_BATCH_FK
Java Field:  holdSubBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Sub Batch
Attributes:
Reference to the entity that represents information about sub-batch on hold.
Added On:  03/25/16
SQL Column:  TERMINAL_ORDER_TRANSACTION_FK
Java Field:  terminalOrderTransactions
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents terminal order transaction information.
Added On:  03/25/16
SQL Column:  FILE_BATCH_FK
Java Field:  fileBatches
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References File Batch
Attributes:
Reference to the entity that represents information about batch file.
Added On:  03/25/16
SQL Column:  ACCOUNT_UPDATE_SUBSCRIPTION_TRANSACTIONS_FK
Java Field:  accountUpdateSubscriptionTransactions
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents account update subscription transaction information.
Added On:  03/25/16
SQL Column:  SUBSCRIPTION_TRANSACTIONS_FK
Java Field:  subscriptionTransactions
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents subsciption transaction information.
Added On:  03/25/16
SQL Column:  AGGREGATE_SUB_BATCH_FK
Java Field:  aggregateSubBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Sub Batch
Attributes:
Reference to the entity that represents aggregate sub-batch file.
Added On:  03/25/16
SQL Column:  CHARGE_TRANSACTIONS_FK
Java Field:  chargeTransactions
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:  03/28/16
SQL Column:  COLLECTIONS_TRANSACTIONS_FK
Java Field:  collectionsTransactions
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents collections transactions information.
Added On:  03/28/16
SQL Column:  EMAIL_TRANSACTION_FK
Java Field:  emailTransactions
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Email Transaction
Attributes:
Reference to the entity that represents emails information.
Added On:  03/28/16
SQL Column:  CREDIT_AGENCY_TRANSACTIONS_FK
Java Field:  creditAgencyTransactions
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents credit agency transactions information.
Added On:  03/28/16
SQL Column:  ACCOUNT_UPDATE_TRANSACTIONS_FK
Java Field:  accountUpdateTransactions
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents account update transaction information.
Added On:  03/28/16
SQL Column:  SKIP_TRACING_TRANSACTIONS_FK
Java Field:  skipTracingTransactions
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents skip tracing transaction information.
Added On:  03/28/16
SQL Column:  CHARGEBACK_CASE_ACTIVITIES_FK
Java Field:  chargebackCaseActivities
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents chargeback case activity information.
Added On:  03/28/16
SQL Column:  PROVISIONING_TRANSACTIONS
Java Field:  provisioningTransactions
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity taht represents provisioning transaction information.
Added On:  03/28/16
SQL Column:  CHARGEBACK_CASE_DOCUMENTS_FK
Java Field:  chargebackCaseDocuments
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents chargeback case document information.
Added On:  04/06/16
SQL Column:  APPROVAL_DATE
Java Field:  approvalDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of approval.
Added On:  07/07/16
SQL Column:  ACCOUNT_UPDATE_BATCH_FK
Java Field:  accountUpdateBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Batch
Attributes:
Reference to the entity that represents account update batch information.
Added On:  08/11/17
SQL Column:  CLIENT_CAPTURE_TRANSACTIONS
Java Field:  clientCaptureTransactions
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents realtime sale-auth/credit-auth transaction submitted in capture file.
Added On:  12/13/17
SQL Column:  EXTERNAL_CODE
Java Field:  externalCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/25/16
SQL Column:  DUPLICATE_SUB_BATCH_CODE
Java Field:  duplicateSubBatchCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents information about duplicated sub-batch.