{$page} 



[[toc]]Updated: 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|Station]].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 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]