Updated: 2009-09-17
Version: Control 4.4
Table Purpose, Usage, and Notes
This tables the basic store information. There should only be 1 record of this type in table. Additional record may cause duplication of certain data when displayed on reports.
Some early store options are stored in this table, however most system options are stored in the UserOption(?) table.
Information on Table Data
- ClassTypeIDs Stores in Table:
- 1000 - Store
Table Structure
~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
Store.AddressID | int | ||||||
Store.AppVersion | varchar(32) | ||||||
Store.AutoDecLunch | bit | ||||||
Store.BankAccountNumber | text | ||||||
Store.BankCode | text | ||||||
Store.BankName | text | ||||||
Store.BillDiscountAccountClassTypeID | int | ||||||
Store.BillDiscountAccountID | int | ||||||
Store.BillingAddressID | int | ||||||
Store.ChamberCommerceNumber | text | ||||||
Store.ClassTypeID | int | Identifier for the Type of Object | |||||
Store.CompanyName | nvarchar(25) | ||||||
Store.CustomerWebOutputTemplateID | int | ||||||
Store.DefaultAPsPaymentTermID | int | ||||||
Store.DefaultAreaCode | nvarchar(10) | ||||||
Store.DefaultCountryCode | varchar(10) | ||||||
Store.DefaultDueTime | datetime | ||||||
Store.DefaultpaymentTermID | int | ||||||
Store.DefaultTaxClassID | int | ||||||
Store.DepositMinimum | float | ||||||
Store.DepositPercentage | decimal(18, 0) | ||||||
Store.EmailAddress | nvarchar(50) | ||||||
Store.EmployeeWebOutputTemplateID | int | ||||||
Store.EquipmentCostMultiplier | text | ||||||
Store.EstimateTemplateID | int | ||||||
Store.FaxNumberID | int | ||||||
Store.FinanceChargeAccountClassTypeID | int | ||||||
Store.FinanceChargeAccountID | int | ||||||
Store.FreightCostMultiplier | text | ||||||
Store.HoursBeforeLunch | int | ||||||
Store.ID | int | Primary Key for the Table | |||||
Store.InvoiceAsOrderNumber | bit | ||||||
Store.InvoicePrefix | nvarchar(10) | ||||||
Store.InvoiceTemplateID | int | ||||||
Store.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
Store.IsSystem | bit | Used to Mark Required Records | |||||
Store.LaborCostMultiplier | text | ||||||
Store.LogoID | int | ||||||
Store.LunchMinutes | int | ||||||
Store.ManagerID | int | ||||||
Store.MaterialCostMultiplier | text | ||||||
Store.MaxClockOutTime | datetime | ||||||
Store.MinClockinTime | datetime | ||||||
Store.MktgListCode1Name | nvarchar(25) | ||||||
Store.MktgListCode2Name | nvarchar(25) | ||||||
Store.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
Store.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
Store.ModifiedDate | datetime | DateTime this Record was last modified | |||||
Store.OrderMinimum | decimal(18, 0) | ||||||
Store.OtherCostMultiplier | text | ||||||
Store.OutsourceCostMultiplier | text | ||||||
Store.ParamToVarList | text | ||||||
Store.PhoneNumberID | int | ||||||
Store.PickUpAddressID | int | ||||||
Store.PickUpAddressLinkID | int | ||||||
Store.QPHomeListID | int | ||||||
Store.QPHomeListStoreID | int | Not Used. | |||||
Store.QPServiceListID | int | ||||||
Store.QPServiceListStoreID | int | Not Used. | |||||
Store.QPTransListID | int | ||||||
Store.QPTransListStoreID | int | Not Used. | |||||
Store.RoundingDigits | int | ||||||
Store.RoundingOption | int | ||||||
Store.RoyaltyFee1 | float | ||||||
Store.RoyaltyFee1Name | nvarchar(25) | ||||||
Store.RoyaltyFee2 | float | ||||||
Store.RoyaltyFee2Name | nvarchar(25) | ||||||
Store.ScreenTemplateID | int | ||||||
Store.SeqID | int | ||||||
Store.ShippingAddressID | int | ||||||
Store.StarShipProductClassTypeID | int | ||||||
Store.StarShipProductID | int | ||||||
Store.StarShipProductStoreID | int | Not Used. | |||||
Store.StoreID | int | Not Used. | |||||
Store.StoreNumber | nvarchar(25) | ||||||
Store.TagLine | nvarchar(75) | ||||||
Store.TaxIdentifier | nvarchar(25) | ||||||
Store.TipsPayOffAccountClassTypeID | int | ||||||
Store.TipsPayOffAccountID | int | ||||||
Store.TipsRevenueAccountClassTypeID | int | ||||||
Store.TipsRevenueAccountID | int | ||||||
Store.UseTaxLookup | bit | ||||||
Store.WebAddress | varchar(50) | ||||||
Store.WebInputTemplateID | int | ||||||
Store.WorkOrderTemplateID | int | ||||||
Store.WriteOffAccountClassTypeID | int | ||||||
Store.WriteOffAccountID | int | ||||||
StoreConstant.CategoryClassTypeID | int | ||||||
StoreConstant.CategoryID | int | ID of Category for User Constant | ?? | ||||
StoreConstant.CategoryStoreID | int | Not Used. | |||||
StoreConstant.ClassTypeID | int | Identifier for the Type of Object | |||||
StoreConstant.ConstantValue | decimal(18, 4) | ||||||
StoreConstant.Formula | text | Value of User Constant | |||||
StoreConstant.ID | int | Primary Key Field | |||||
StoreConstant.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
StoreConstant.IsSystem | bit | Used to Mark Required Records | |||||
StoreConstant.ItemProperties | text | ||||||
StoreConstant.ItemText | nvarchar(50) | Name of User Constant | |||||
StoreConstant.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
StoreConstant.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
StoreConstant.ModifiedDate | datetime | DateTime this Record was last modified | |||||
StoreConstant.SeqID | int | ||||||
StoreConstant.StoreID | int | Not Used. | |||||
StoreConstant.UnitID | int |
Related Tables
You could leave a comment if you were logged in.