original_pages:sql_structure_-_sequence

{$page}

Updated: 10/6/2009

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is used to store the next number of records that require unique incremental numbers.

Information on Table Data

This table does not use the standard Control table structure. Instead, the next number to be used is associated with the class type of that row.

ClassTypeIDs known to use this table:
- 11009 - Receiving Document
- 11008 - Bill
- 11007 - Purchase Order
- 10005 - Invoice
- 10003 - Template
- 10002 - Estimate
- 10001 - Order
- 8919 - Session Closeout
- 8918 - Quarterly Closeout
- 8917 - Weekly Closeout
- 8916 - PC Charge Settlement
- 8915 - Royalty Closeout
- 8914 - Export Closeout
- 8913 - Yearly Closeout
- 8912 - Monthly Closeout
- 8911 - Daily Closeout
- 8910 - User Closeout
- 8901 - Part GL Entry
- 8900 - GL Entry
- 2000 - Company

Warning: The ClassTypeIDs over 10000 in this table are relative and may not represent the object that actually holds that ClassTypeID.

Example: ClassTypeID 10000 is CustTransHeader, but ClassTypeID 10001 is CustTransHeaderHistory. In this table, the enumerated types of CustTransHeader are added to the ClassTypeID to get the Next Number and misleadingly labeled ClassTypeID.

(10000 + 1) (ctCustTransHeader+ttOrder)

(11000 + 9) (ctPurchaseOrder+ttReceivingDoc)

Table Structure

~ Table.FieldName	~ Data Type	~ Description	~ Links To
Sequence.ClassTypeID	int	Identifier for the Type of Object
Sequence.NextNumber	int	The next number that should be used for the object ClassTypeID
Sequence.StoreID	int	Not Used.