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. |