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.