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.