{$page} 



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|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|GLAccount.ID]] ||
|| 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 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]