{$page} 



Updated: 2009-12-15



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is used to store information about the types of payments that can be accepted from customers.



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 8002 - Payment Method
    * 8100 - Bill Payment Method



Enumerated Values
  * TCreditCardType
    * 1Amex
    * 2Mastercard
    * 3Visa
    * 4Discover
    * 5Diners
    * 6Other
    * 7DinersClubInternation
    * 8BankCard
    * 9Maestro
    * 10VisaElectron
    * 11JCB
  * TTenderType
    * 1Cash
    * 2Check
    * 3CreditCard
    * 4DebitCard
    * 5Other
    * 6EFT
    * 7System
    * 8WireTransfer



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| PaymentAccount.AccountName || varchar(50) || Name of the Payment Method (Check, Cash, etc.) ||   ||
|| PaymentAccount.AllowOverPayToCredit || bit || Can overpayments be applied to credit? ||   ||
|| PaymentAccount.BankAccountID || int ||  || [[sql_structure_-_glaccount_table|GLAccount]].ID ||
|| PaymentAccount.CanGiveCashBack || bit || Can change be given?  || ||
|| PaymentAccount.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| PaymentAccount.CreditCardType || int || TCreditCardType Enumeration ||   ||
|| PaymentAccount.Description || text ||  ||   ||
|| PaymentAccount.DiscountRate || decimal(18, 4) ||  ||   ||
|| PaymentAccount.GroupName || varchar(50) ||  ||   ||
|| PaymentAccount.ID || int || Primary Key for the Table ||   ||
|| PaymentAccount.ImageID || int ||  ||   ||
|| PaymentAccount.IsActive || bit || Indicates if Enabled.  1Record is Active, 0Record is Not Active ||   ||
|| PaymentAccount.IsProcessed || bit || Is this payment processed online? ||   ||
|| PaymentAccount.IsSystem || bit || Used to Mark Required Records ||   ||
|| PaymentAccount.LiabilityClassTypeID || int ||  ||   ||
|| PaymentAccount.LiabilityID || int ||  ||   ||
|| PaymentAccount.MaxChange || decimal(18, 4) ||  ||   ||
|| PaymentAccount.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| PaymentAccount.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| PaymentAccount.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| PaymentAccount.ReturnDiscountRate || decimal(18, 4) ||  ||   ||
|| PaymentAccount.SeqID || int ||  ||   ||
|| PaymentAccount.StoreID || int || Not Used. ||   ||
|| PaymentAccount.TenderType || int || TTenderType Enumeration ||   ||
|| PaymentAccount.UndepositedAccountID || int ||  ||   ||
|| PaymentAccount.UseUndeposited || bit ||  ||   ||
Related Tables 



[[sql_structure_-_glaccount_table|GLAccount]]



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]