tocUpdated: 2009-09-21Version: Control 4.4
Table Purpose, Usage, and Notes
This table is used for storage of all stations used by the following objects:
- Accounts (Customers, Vendors, Prospects)
- Macros
- Part Usage Cards
- Payroll
- Time Clock Entries
- Transactions (Orders, Estimates, Service Tickets, Recurring Orders)
- Line Items
- Workers' Compensation
- Vendor Transactions (Purchase Orders, Bills, Receiving Documents)
Information on Table Data
- ClassTypeIDs Stored in Table:
- 26100 - Station
Table Structure
~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
Station.ClassTypeID | int | Identifier for the Type of Object | |||||
Station.DepartmentID | int | ID of Top-Most Station (Department) | sql_structure_-_station_table.ID | ||||
Station.ID | int | Primary Key Field | |||||
Station.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
Station.IsGLDepartment | bit | Indicates whether this station can be used as a GL Department station list. | |||||
Station.IsPaid | bit | Indicates whether this station is a paid time clock station. 1Record is a Paid Time Clock Station, 0Record is Not a Paid Time Clock Station | |||||
Station.IsSystem | bit | Used to Mark Required Records | |||||
Station.Level2StationID | int | ID of the second level parent station if this station is 3 levels or deeper. | |||||
Station.Level3StationID | int | ID of the third level parent station if this station is 4 levels or deeper. | |||||
Station.Level4StationID | int | ID of the fourth level parent station if this station is 5 levels or deeper. | |||||
Station.MarkLIComplete | bit | Indicates whether a line item will be marked complete if it is set to this station. | |||||
Station.ModifiedByComputer | varchar(25) | HostName of computer that last modified this record | |||||
Station.ModifiedByUser | varchar(25) | Windows User who last modified this record | |||||
Station.ModifiedDate | datetime | DateTime this Record was last modified | |||||
Station.ParentClassTypeID | int | Identifier for the Type of Object for the Parent Station | |||||
Station.ParentID | int | ID of Parent Station | Station.ID | ||||
Station.PayrollExpenseClassTypeID | int | Identifier for the Type of Object for the Fallback Expense Account for Labor on this station not assigned to a part | |||||
Station.PayrollExpenseID | int | Fallback Expense Account for Labor on this station not assigned to a part | GLAccount.ID | ||||
Station.PayrollExpenseIDOV | bit | Indicated whether or not the Fallback Expense Account is overridden | |||||
Station.SeqID | int | Sequense ID indicating the amount of times this record has been modified | |||||
Station.ShowForBuilt | bit | Indicates if this Station shows for Orders marked Built, 1Record shows for Orders Marked Built, 0Record Does Not show for Orders Marked Built | |||||
Station.ShowForLineItem | bit | Indicates if this Station shows for Line Items, 1Record shows for Line Itemst, 0Record Does Not show for Line Items | |||||
Station.ShowForPendingEstimates | bit | Indicates if this Station shows for Pending Estimates, 1Record shows for Pending Estimates, 0Record Does Not show for Pending Estimates | |||||
Station.ShowForProductionTerm | bit | Indicates if this Station shows in Production Terminal, 1Record shows for Production Terminal, 0Record Does Not show for Production Terminal | |||||
Station.ShowForSale | bit | Indicates if this Station shows in Orders Marked Sale, 1Record shows for Orders Marked Sale, 0Record Does Not show for Orders Marked Sale | |||||
Station.ShowForVendorLineItem | bit | Indicates if this Station shows in Line Items, 1Record shows for Orders Marked Sale, 0Record Does Not show for Orders Marked Sale | |||||
Station.ShowForWIP | bit | Indicates if this Station shows for Orders in WIP, 1Record shows for Orders in WIP, 0Record Does Not show for Orders in WIP | |||||
Station.ShowOnTimeClock | bit | Indicates if this Station shows in the Time Clock, 1Record shows in the Time Clock, 0Record Does Not show for Time Clock | |||||
Station.SortIndex | float | ||||||
Station.StationName | varchar(100) | Name of Station | |||||
Station.StationType | int | Not Used. | |||||
Station.StationTypeText | varchar(30) | Not Used. | |||||
Station.StoreID | int | Not Used. | |||||
Station.TimeCardPayStatus | int | Indicates the type of time clock status the record. 0 - Paid, 1 - Not Paid, 3 - Vacation, 4 - Sick, 5 - Holiday | |||||
Station.WorkersCompID | int | ID of Workers Comp Code for this Station | ?? |
Related Tables
You could leave a comment if you were logged in.