Payment


Added On:  08/15/12 
SQL Table:  PAYMENT 
Module:  UniSell 
Type:  Entity  Status:  Active 
Java Class:  Payment 
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.
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.
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
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.
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.
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.
Added On:  08/15/12
SQL Column:  DRAWER_ID
Java Field:  drawerId
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
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.
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.
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.
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.
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.
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.
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.
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.
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.
Added On:  08/15/12
SQL Column:  SALES_PERSON_NUMBER1
Java Field:  salesPersonNumber1
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
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.
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.
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.
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.