EFT Standart18 Batch UML

Parent:    File Batch

Added On:  09/25/15 

SQL Table:  EFT_STANDART18_BATCH 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  EftStandart18Batch 

Represents a batch of transactions as it is defined in EFT Standart18 batch processing specification.

Available Fields:

• Create Date
• Credit Item Count
• Credit Value Total
• DDI Count
• Debit Item Count

• Debit Value Total
• Expire Date
• File Identifier
• File Number
• Originating Account Name

• Origination Account Number
• Origination Sorting Code
• Processing Date
• Serial Number
• Service User Number

• Work Code

Create Date

Added On:  09/25/15

SQL Column:  CREATE_DATE

Java Field:  createDate

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Date when the record was created.

Credit Item Count

Added On:  09/25/15

SQL Column:  CREDIT_ITEM_COUNT

Java Field:  creditItemCount

Status:  Active

SQL Type:  varchar(7)

Java Type:  String

Attributes:

Number of credit item records in the file.

Credit Value Total

Added On:  09/25/15

SQL Column:  CREDIT_VALUE_TOTAL

Java Field:  creditValueTotal

Status:  Active

SQL Type:  varchar(13)

Java Type:  String

Attributes:

Total value of credit operations.

DDI Count

Added On:  09/25/15

SQL Column:  DDI_COUNT

Java Field:  ddiCount

Status:  Active

SQL Type:  varchar(7)

Java Type:  String

Attributes:

Number of DDI records in the file.

Debit Item Count

Added On:  09/25/15

SQL Column:  DEBIT_ITEM_COUNT

Java Field:  debitItemCount

Status:  Active

SQL Type:  varchar(7)

Java Type:  String

Attributes:

Number of debit item records in the file.

Debit Value Total

Added On:  09/25/15

SQL Column:  DEBIT_VALUE_TOTAL

Java Field:  debitValueTotal

Status:  Active

SQL Type:  varchar(13)

Java Type:  String

Attributes:

Total value of debit operations.

Expire Date

Added On:  09/25/15

SQL Column:  EXPIRE_DATE

Java Field:  expireDate

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Expiration date of the file.

File Identifier

Added On:  09/25/15

SQL Column:  FILE_IDENTIFIER

Java Field:  fileIdentifier

Status:  Active

SQL Type:  varchar(17)

Java Type:  String

Attributes:

Identifier of the file in the system.

File Number

Added On:  09/25/15

SQL Column:  FILE_NUMBER

Java Field:  fileNumber

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Number of the file.

Originating Account Name

Added On:  09/25/15

SQL Column:  ORIGINATING_ACCOUNT_NAME

Java Field:  originatingAccountName

Status:  Active

SQL Type:  varchar(18)

Java Type:  String

Attributes:

Originating account name.

Origination Account Number

Added On:  09/25/15

SQL Column:  

Java Field:  originatingAccountNumber

Status:  Active

SQL Type:  

Java Type:  String

Attributes: Transient

Origination account number.

Origination Sorting Code

Added On:  09/25/15

SQL Column:  

Java Field:  originatingSortingCode

Status:  Active

SQL Type:  

Java Type:  String

Attributes: Transient

Origination sorting code.

Processing Date

Added On:  09/25/15

SQL Column:  PROCESSING_DATE

Java Field:  processingDate

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Date when the file was processed.

Serial Number

Added On:  09/25/15

SQL Column:  SERIAL_NUMBER

Java Field:  serialNumber

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Serial number of the submission.

Service User Number

Added On:  09/25/15

SQL Column:  SERVICE_USER_NUMBER

Java Field:  serviceUserNumber

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

A 6-digit number that identifies a service user. For bureaux, the service user number is B followed by 5 numerals.

Work Code

Added On:  09/25/15

SQL Column:  WORK_CODE

Java Field:  workCode

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

Workcode of the file.