Ezidebit Auth Retail Transaction                                                    UML
                                
         
     
    
    
    
    
        
            Added On:  08/12/13 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  EzidebitAuthRetailTransaction 
                    
        
        
     
    
        
        
                    
                        
                Added On:  12/04/15
                SQL Column:  
                Java Field:  bankAccountBsb
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        The client side element name that is capturing the customer BSB number.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  BANK_RECEIPT_ID
                Java Field:  bankReceiptId
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The Original Receipt Number issued by the Merchant Acquirer (bank) for this payment.                        
                     
                 
             
                    
                        
                Added On:  06/14/16
                SQL Column:  CHARGE_TRANSACTION_FK
                Java Field:  chargeTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents real-time financial transaction.                        
                     
                 
             
                    
                        
                Added On:  12/04/15
                SQL Column:  
                Java Field:  creditCardCcv
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Credit card CCV/CVV secure number.                        
                     
                 
             
                    
                        
                Added On:  12/04/15
                SQL Column:  
                Java Field:  creditCardExpiryMonth
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Month of the credit card expiry date.                        
                     
                 
             
                    
                        
                Added On:  12/04/15
                SQL Column:  
                Java Field:  creditCardExpiryYear
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Year of the credit card expiry date.                        
                     
                 
             
                    
                        
                Added On:  12/04/15
                SQL Column:  
                Java Field:  creditCardNumber
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Encoded number of the credit card.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  CUSTOMER_NAME
                Java Field:  customerName
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/14/13
                SQL Column:  CUSTOMER_REF
                Java Field:  customerRef
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Unique reference number stored in the Ezidebit database that corresponds to the customer.                        
                     
                 
             
                    
                        
                Added On:  10/31/13
                SQL Column:  DEBIT_DATE
                Java Field:  debitDate
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Date when the payment will be deducted from customer's bank account or credit card.                        
                     
                 
             
                    
                        
                Added On:  12/04/15
                SQL Column:  
                Java Field:  digitalKey
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Ezidebit digital key of the profile.                        
                     
                 
             
                    
                        
                Added On:  10/31/13
                SQL Column:  EMAIL_ADDRESS
                Java Field:  emailAddress
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Email address of the customer.                        
                     
                 
             
                    
                        
                Added On:  09/14/13
                SQL Column:  ERROR
                Java Field:  error
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the occured error.                        
                     
                 
             
                    
                        
                Added On:  09/14/13
                SQL Column:  ERROR_MESSAGE
                Java Field:  errorMessage
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Text message explaining the occured error.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  EXCHANGE_PAYMENT_ID
                Java Field:  exchangePaymentId
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifier for the payment within Ezidebit's own payment systems.                        
                     
                 
             
                    
                        
                Added On:  11/06/19
                SQL Column:  EZI_DEBIT_CUSTOMER_ID
                Java Field:  eziDebitCustomerId
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  10/31/13
                SQL Column:  FIRST_NAME
                Java Field:  firstName
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                
                    
                        
                        First name of the customer.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  ID
                Java Field:  id
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
                
                    Attributes:
                    Unique, Required, CreateOnly, ReadOnly                
                             
            
                
                    
                        
                        Identifier of the object used for references; auto-incremented integer value.                        
                     
                 
             
                    
                        
                Added On:  10/31/13
                SQL Column:  LAST_NAME
                Java Field:  lastName
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Last name of the customer.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  MERCHANT_ACCOUNT_CODE
                Java Field:  merchantAccountCode
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        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:  10/31/13
                SQL Column:  MOBILE_PHONE_NUMBER
                Java Field:  mobilePhoneNumber
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Mobile phone number of the customer for discussing any processing issues.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  NAME_ON_CREDIT_CARD
                Java Field:  nameOnCreditCard
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Name of the credit card holder, printed on the credit card.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  PAYMENT_AMOUNT_IN_CENTS
                Java Field:  paymentAmountInCents
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The amount to debit from the customer in cents.                         
                     
                 
             
                    
                        
                Added On:  12/04/15
                SQL Column:  PAYMENT_ID
                Java Field:  paymentId
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The unique transaction ID given to the original payment by Ezidebit.                         
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  PAYMENT_REFERENCE
                Java Field:  paymentReference
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Reference number of the transaction.                         
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  PAYMENT_RESULT
                Java Field:  paymentResult
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Result of the processed payment of the customer.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  PAYMENT_RESULT_CODE
                Java Field:  paymentResultCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Gateway generated result code of the processed payment.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  PAYMENT_RESULT_TEXT
                Java Field:  paymentResultText
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Gateway generated result text message of the processed payment.                        
                     
                 
             
                    
                        
                Added On:  12/04/15
                SQL Column:  REFUND_AMOUNT_IN_CENTS
                Java Field:  refundAmountInCents
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        The amount that the refund is to be processed for. Must be less than or equal to the amount originally paid by the payer.                        
                     
                 
             
                    
                        
                Added On:  12/04/15
                SQL Column:  REFUND_BANK_RECEIPT_ID
                Java Field:  refundBankReceiptId
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Receipt Number issued by the Merchant Acquirer (bank) for this refund.                         
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
                Java Field:  retailTransactionCycle
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents a group of real-time transactions which must be settled together.                        
                     
                 
             
                    
                        
                Added On:  10/31/13
                SQL Column:  SMS_EXPIRED_CARD
                Java Field:  smsExpiredCard
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether SMS notification will be sent to the customer if his recorded credit card is due to expire. Optional.                        
                     
                 
             
                    
                        
                Added On:  10/31/13
                SQL Column:  SMS_FAILED_NOTIFICATION
                Java Field:  smsFailedNotification
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether SMS notification will be sent to the customer if his debit fails.                        
                     
                 
             
                    
                        
                Added On:  10/31/13
                SQL Column:  SMS_PAYMENT_REMINDER
                Java Field:  smsPaymentReminder
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether SMS notification will be sent to the customer to remind him of upcoming scheduled debits. Optional.                        
                     
                 
             
                    
                        
                Added On:  10/31/13
                SQL Column:  SUBMISSION_CL
                Java Field:  submissionCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Enumeration of possible submission types.                        
                     
                 
             
                    
                        
                Added On:  10/31/13
                SQL Column:  YOUR_GENERAL_REFERENCE
                Java Field:  yourGeneralReference
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        A secondary unique reference for the customer. If no value is supplied for this field it will default to 'LastnameFirstnameYYYYmmDDhhMM'.                        
                     
                 
             
                    
                        
                Added On:  10/31/13
                SQL Column:  YOUR_SYSTEM_REFERENCE
                Java Field:  yourSystemReference
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        A unique system identifier for the customer (e.g. GUID or your primary key).