{$page} 



Updated: 2009-09-17



Version: Control 4.4



Table Purpose, Usage, and Notes 



The Closeout table is a //split table// with the [[sql_structure_-_journal_tablejournal_table|Journal Table]].  It is used to store additional information specific to closeouts.



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 8911 - Daily Closeout
    * 8912 - Monthly Closeout
    * 8913 - Yearly Closeout
    * 8914 - Export Closeout
    * 8915 - Royalty Closeout
    * 8916 - CC Settlement
    * 8917 - Weekly Closeout
    * 8918 - Quarterly Closeout
    * 8919 - Session Closeout



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| Closeout.CategoryID || int ||  ||   ||
|| Closeout.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| Closeout.CloseOutPeriod || int ||  ||   ||
|| Closeout.CloseoutType || int ||  ||   ||
|| Closeout.CloseoutTypeText || nvarchar(25) ||  ||   ||
|| Closeout.ID || int || Primary Key for the Table ||   ||
|| Closeout.IsActive || bit || Not Used for This Table ||   ||
|| Closeout.IsSystem || bit || Used to Mark Required Records ||   ||
|| Closeout.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| Closeout.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| Closeout.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| Closeout.SeqID || int ||  ||   ||
|| Closeout.StoreID || int || Not Used. ||   ||
Related Tables 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]