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_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
You could leave a comment if you were logged in.