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
Enumerated Values
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