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.