EFT Westpac Batch UML

Parent: File Batch

Added On: 06/24/14

SQL Table: EFT_WESTPAC_BATCH

Module: UniCharge

Type: Entity Status: Active

Java Class: EftWestpacBatch

Represents a batch of transactions as it is defined in Westpac's batch processing specification.

Available Fields:

Credit Total Amount
Debit Total Amount
Description
Detail Record Count

File ID
File Name
File Number
Net Total Amount

Process Date
Status Indicator Disb
Status Indicator Exc
Trace Record

Credit Total Amount

Added On: 06/24/14

SQL Column: CREDIT_TOTAL_AMOUNT

Java Field: creditTotalAmount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Total dollar amount of the credit transactions. This element cannot be zero (0) or negative.

Debit Total Amount

Added On: 06/24/14

SQL Column: DEBIT_TOTAL_AMOUNT

Java Field: debitTotalAmount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Total dollar amount of the debit transactions. This element cannot be zero (0) or negative.

Description

Added On: 06/24/14

SQL Column: DESCRIPTION

Java Field: description

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Short description of the uploaded file.

Detail Record Count

Added On: 06/24/14

SQL Column: DETAIL_RECORD_COUNT

Java Field: detailRecordCount

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Total number of records in the file.

File ID

Added On: 06/24/14

SQL Column: FILE_ID

Java Field: fileId

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

The unique identifier for this file. If present, this value must be unique for each file sent. If you cannot generate a unique identifier for each file, you should omit this parameter.

If you do not know whether a file was transmitted successfully or not, you can resend it with the same fileID. Westpac will only process the fileID once. If the same fileID is received again, the file will be ignored by Westpac.

File Name

Added On: 06/24/14

SQL Column: FILE_NAME

Java Field: fileName

Status: Active

SQL Type: varchar(26)

Java Type: String

Attributes:

The name of the file uploaded if known, e.g. directEntry20090801.txt

File Number

Added On: 06/24/14

SQL Column: FILE_NUMBER

Java Field: fileNumber

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Number of the uploaded file.

Net Total Amount

Added On: 06/24/14

SQL Column: NET_TOTAL_AMOUNT

Java Field: netTotalAmount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Total dollar amount of the net transactions. This element cannot be zero (0) or negative.

Process Date

Added On: 11/05/14

SQL Column: PROCESS_DATE

Java Field: processDate

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Date when the file was processed.

Status Indicator Disb

Added On: 12/17/14

SQL Column: STATUS_INDICATOR_DISB

Java Field: statusIndicatorDisb

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Indicates the status of disbursement.

Status Indicator Exc

Added On: 12/17/14

SQL Column: STATUS_INDICATOR_EXC

Java Field: statusIndicatorExc

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Indicates the status of exchange.

Trace Record

Added On: 07/07/14

SQL Column: TRACE_RECORD

Java Field: traceRecord

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes: