CС Elavon Batch UML

Parent:    File Batch

Added On:  08/29/12 

SQL Table:  CC_ELAVON_BATCH 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  CcElavonBatch 

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

Available Fields:

• Amex Count
• Amex Net
• Amex Sign
• Bankcard Count
• Bankcard Net
• Bankcard Sign
• Creation Date

• Deposit Flag
• Discover Count
• Discover Net
• Discover Sign
• Merchant FI Number
• Merchant Number
• Net Amount

• Net Count
• Net Sign
• Other Count
• Other Net
• Other Sign
• Return Amount
• Return Count

• Sales Amount
• Sales Count

Amex Count

Added On:  08/29/12

SQL Column:  AMEX_COUNT

Java Field:  amexCount

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

The count of Amex transactions in the file.

Amex Net

Added On:  08/29/12

SQL Column:  AMEX_NET

Java Field:  amexNet

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Indicates if the Item Amount includes any tax.

Space fill if not supported
Y = Item Amount includes tax
N = Item Amount does not include tax

Amex Sign

Added On:  08/29/12

SQL Column:  AMEX_SIGN

Java Field:  amexSign

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

The “+” or “–“ character depending on sign of Amex Net Amount field.

Bankcard Count

Added On:  08/29/12

SQL Column:  BANKCARD_COUNT

Java Field:  bankcardCount

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

The count of bankcard transactions in the file.

Bankcard Net

Added On:  08/29/12

SQL Column:  BANKCARD_NET

Java Field:  bankcardNet

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Indicates if the Item Amount includes any tax.

Space fill if not supported
Y = Item Amount includes tax
N = Item Amount does not include tax

Bankcard Sign

Added On:  08/29/12

SQL Column:  BANKCARD_SIGN

Java Field:  bankcardSign

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

The “+” or “–“ character depending on sign of Bankcard Net Amount field.

Creation Date

Added On:  08/29/12

SQL Column:  CREATION_DATE

Java Field:  creationDate

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

The date of creation. YYYYMMDD (same as file header).

Deposit Flag

Added On:  06/04/13

SQL Column:  DEPOSIT_FLAG

Java Field:  depositFlag

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

A Deposit Flag within the file tells the Host to deposit all authorized transactions.

Discover Count

Added On:  08/29/12

SQL Column:  DISCOVER_COUNT

Java Field:  discoverCount

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

The count of Discover transactions in the file.

Discover Net

Added On:  08/29/12

SQL Column:  DISCOVER_NET

Java Field:  discoverNet

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Indicates if the Item Amount includes any tax.

Space fill if not supported
Y = Item Amount includes tax
N = Item Amount does not include tax

Discover Sign

Added On:  08/29/12

SQL Column:  DISCOVER_SIGN

Java Field:  discoverSign

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

The “+” or “–“ character depending on sign of Discover Net Amount field.

Merchant FI Number

Added On:  08/29/12

SQL Column:  MERCHANT_FI_NUMBER

Java Field:  merchantFiNumber

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Number assigned by Elavon.

Merchant Number

Added On:  08/29/12

SQL Column:  MERCHANT_NUMBER

Java Field:  merchantNumber

Status:  Active

SQL Type:  varchar(16)

Java Type:  String

Attributes:

This value contains the merchant assigned number for this transaction. If this value is not present, then Elavon will generate this number for backend use.

Net Amount

Added On:  08/29/12

SQL Column:  NET_AMOUNT

Java Field:  netAmount

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Purchase Amount minus Return Amount (no sign) 9(10)v99.

Net Count

Added On:  08/29/12

SQL Column:  NET_COUNT

Java Field:  netCount

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

The count of Net transactions in the file.

Net Sign

Added On:  08/29/12

SQL Column:  NET_SIGN

Java Field:  netSign

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

The “+” or “–“ character depending on sign of Batch Net Amount field.

Other Count

Added On:  08/29/12

SQL Column:  OTHER_COUNT

Java Field:  otherCount

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

The count of other transactions in the file.

Other Net

Added On:  08/29/12

SQL Column:  OTHER_NET

Java Field:  otherNet

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Indicates if the Item Amount includes any tax.

Space fill if not supported
Y = Item Amount includes tax
N = Item Amount does not include tax

Other Sign

Added On:  08/29/12

SQL Column:  OTHER_SIGN

Java Field:  otherSign

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

The “+” or “–“ character depending on sign of Other Net Amount field.

Return Amount

Added On:  08/29/12

SQL Column:  RETURN_AMOUNT

Java Field:  returnAmount

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

The total dollar amount of return transactions for the file in 9(10)v99 format.

Return Count

Added On:  08/29/12

SQL Column:  RETURN_COUNT

Java Field:  returnCount

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

The count of return transactions in the file.

Sales Amount

Added On:  08/29/12

SQL Column:  SALES_AMOUNT

Java Field:  salesAmount

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

The total dollar amount of the sales transaction.

Sales Count

Added On:  08/29/12

SQL Column:  SALES_COUNT

Java Field:  salesCount

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

The total count of the sales transaction.