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.