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.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

You could leave a comment if you were logged in.