Updated: 2009-09-21
Version: Control 4.4
Table Purpose, Usage, and Notes
This table is a split table with the sql_structure_-_journal_table and is used for …
Information on Table Data
- ClassTypeIDs Stores in Table:
- 20000 - Master Payment
- 20001 - Order Payment
- 20002 - Over Payment
- 20003 - Change Return
- 20004 - Order Refund
- 20005 - Credit Refund
- 20006 - Order Credit Memo
- 20007 - Failed Payment
- 20008 - Tip Recorded
- 20009 - Bill Payment
- 20037 - Master Bill Payment
- 35300 - ???
- 35301 - ???
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| Payment.BankAccountClasstypeID | int | ||||||
| Payment.BankAccountID | int | sql_structure_-_glaccount_table | |||||
| Payment.BankCode | varchar(50) | ||||||
| Payment.BankReference | varchar(50) | ||||||
| Payment.BranchCode | varchar(50) | ||||||
| Payment.CCAccount | varchar(50) | ||||||
| Payment.CCCSCustomerGuid | varchar(50) | ||||||
| Payment.CCCSTransactionGuid | varchar(50) | ||||||
| Payment.CIN | varchar(50) | ||||||
| Payment.ClassTypeID | int | Identifier for the Type of Object | |||||
| Payment.DepositGLGroupID | int | ||||||
| Payment.DepositJournalID | int | ||||||
| Payment.DisplayNumber | varchar(50) | ||||||
| Payment.ExpirationDate | datetime | ||||||
| Payment.ID | int | Primary Key for the Table | |||||
| Payment.IsActive | bit | Not Used for This Table | |||||
| Payment.IsCCNumEncrypt | bit | ||||||
| Payment.IsSystem | bit | Used to Mark Required Records | |||||
| Payment.IsVCodeEncrypted | bit | ||||||
| Payment.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
| Payment.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
| Payment.ModifiedDate | datetime | DateTime this Record was last modified | |||||
| Payment.NameOnCard | nvarchar(25) | ||||||
| Payment.PaycheckID | int | ||||||
| Payment.PaymentAccountClassTypeID | int | ||||||
| Payment.PaymentAccountID | int | ||||||
| Payment.PaymentDate | datetime | ||||||
| Payment.PayrollClassTypeID | int | ||||||
| Payment.PayrollID | int | ||||||
| Payment.SeqID | int | ||||||
| Payment.State | varchar(50) | ||||||
| Payment.StoreID | int | Not Used. | |||||
| Payment.TenderType | int | ||||||
| Payment.TrackingNumber | nvarchar(25) | ||||||
| Payment.Undeposited | bit | ||||||
| Payment.VCode char(10) |
Related Tables
You could leave a comment if you were logged in.