Payment

Added On: 08/15/12

SQL Table: PAYMENT

Module: UniSell

Type: Entity Status: Active

Java Class: Payment

Available Fields:

Account Payment Amount
Account Payment Description
Create Date
Creator Code
Credit Card CL
Customer Account Code
Drawer Id

First Name
Id
Last Name
Merchant Account Code
New Sale Amount
New Sale Description
New Sale Tax Amount

Payment Option Code
Response Code
Response Message
Sales Person Number1
Status CL
Store Number
Total Amount

Transaction Code

Account Payment Amount

Added On: 08/15/12

SQL Column: ACCOUNT_PAYMENT_AMOUNT

Java Field: accountPaymentAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of account payment.

Account Payment Description

Added On: 08/15/12

SQL Column: ACCOUNT_PAYMENT_DESCRIPTION

Java Field: accountPaymentDescription

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Description of account payment.

Create Date

Added On: 08/15/12

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created

Creator Code

Added On: 08/15/12

SQL Column: CREATOR_CODE

Java Field: creatorCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Code of the payment creator within the system.

Credit Card CL

Added On: 08/15/12

SQL Column: CREDIT_CARD_CL

Java Field: creditCardCl

Status: Active

SQL Type: varchar(255)

Java Type: String

References Card Classifier

Attributes:

Represents the type of selecetd credit card.

Customer Account Code

Added On: 08/15/12

SQL Column: CUSTOMER_ACCOUNT_CODE

Java Field: customerAccountCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Account code of the customer within the system.

Drawer Id

Added On: 08/15/12

SQL Column: DRAWER_ID

Java Field: drawerId

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

First Name

Added On: 08/15/12

SQL Column: FIRST_NAME

Java Field: firstName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

First name of the customer.

Added On: 08/15/12

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes: Required

Identifier of the object used for references; auto-incremented integer value.

Last Name

Added On: 08/15/12

SQL Column: LAST_NAME

Java Field: lastName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Last name of the sustomer.

Merchant Account Code

Added On: 08/15/12

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.

New Sale Amount

Added On: 08/15/12

SQL Column: NEW_SALE_AMOUNT

Java Field: newSaleAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of the new sale operation.

New Sale Description

Added On: 08/15/12

SQL Column: NEW_SALE_DESCRIPTION

Java Field: newSaleDescription

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Description of new sale operation.

New Sale Tax Amount

Added On: 08/15/12

SQL Column: NEW_SALE_TAX_AMOUNT

Java Field: newSaleTaxAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of new sale operation tax.

Payment Option Code

Added On: 08/15/12

SQL Column: PAYMENT_OPTION_CODE

Java Field: paymentOptionCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Code of the payment option.

Response Code

Added On: 08/15/12

SQL Column: RESPONSE_CODE

Java Field: responseCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Gateway generated response code.

Response Message

Added On: 08/15/12

SQL Column: RESPONSE_MESSAGE

Java Field: responseMessage

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Gateway generated response message.

Sales Person Number1

Added On: 08/15/12

SQL Column: SALES_PERSON_NUMBER1

Java Field: salesPersonNumber1

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Status CL

Added On: 08/15/12

SQL Column: STATUS_CL

Java Field: statusCl

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Represents current status of payment.

Store Number

Added On: 08/15/12

SQL Column: STORE_NUMBER

Java Field: storeNumber

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Identification number of the store.

Total Amount

Added On: 08/15/12

SQL Column: TOTAL_AMOUNT

Java Field: totalAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total amount of the payment transaction.

Transaction Code

Added On: 08/15/12

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Code of the transaction.