dbo.AP_Discount_Method |
Type table for AP Discount Methods. Currently the only discount method that can be selected is Discount after application. With this selected discounts are only recognized after being applied. |
dbo.AP_Enter_Transaction_Description_Type |
This table contains the three possible fields for Description column in Enter AP Transactions. |
dbo.AP_Enter_Transaction_List_View_Column |
This table contains the list of columns used in Enter AP Transactions screen and whether they can be hidden or not. |
dbo.AP_Enter_Transaction_List_View_Column_Option |
This table contains the user preferences per client for settings and fields defaults for Enter AP Transactions screen. |
dbo.AP_Enter_Transaction_Option |
This table contains user preferences per client for Data Entry Method and List View Filter in Enter AP Transactions. |
dbo.AP_Payment_Type |
This table defines all of our payment types used in manage ap payments processing. |
dbo.AR_Customer_Payment_List_View_Column |
Lists the column headers as they will appear in the AR Customer Payment view. |
dbo.AR_Customer_Payment_List_View_Column_Option |
Saves user-specified ordering of how the columns will appear in the AR Customer Payments view. |
dbo.AR_Customer_Payment_Option |
Saves user configuration of their settings for use in the AR Customer Payment view. |
dbo.AR_Deposit_Cash_Back_Distribution |
This table is used to identify the Cash Back distribution, if any, for bank transactions of type AR Deposit. |
dbo.AR_Enter_Invoice_List_View_Column |
Lists the column headers as they will appear in the AR Enter Invoices view. |
dbo.AR_Enter_Invoice_List_View_Column_Option |
Saves user-specified ordering of how the columns will appear in the AR Enter Invoices view. |
dbo.AR_Enter_Invoice_Option |
Saves user configuration of their settings for use in the AR Enter Invoices view. |
dbo.AR_Invoice_Sort_By |
Table to identify which field to sort by in invoices for Accounts Receivable |
dbo.AR_Item |
This table stores setup information for AR items. |
dbo.AR_Item_Group |
This table stores member items for a group along with their quantity and sequence number. The group represents a package of items that can be selected to be placed on an invoice. |
dbo.AR_Item_Tax_Status |
This table stores the different item tax statuses. |
dbo.AR_Item_Type |
This table stores the AR item types. |
dbo.AR_Payment |
Table which holds all the necessary information for each payment in Accounts Receivable. |
dbo.AR_Payment_Application |
Each row in this table represents a payment being applied to a receivable. A payment is either a credit memo (an AR_Transaction of type Credit Memo) or an AR payment (an AR_Payment of any type). A receivable is a regular invoice or a finance charge invoice (an AR_Transaction of type Invoice or Finance Charge). The receivable and payment must belong to the same customer. A given receivable can have multiple payments applied to it until its open balance is zero. A given payment can be applied until its unused amount is zero. |
dbo.AR_Payment_Application_Distribution |
This table contains a payment application's distribution across the receivable's items. Cash basis accounting requires knowing how much of each item on a receivable was paid by a given payment application. To this end, a payment application must be proportionally distributed across the items of the receivable it is applied to. More precisely, since each item can affect multiple GL accounts, the payment amount is distributed across the GL accounts associated with the receivable items. |
dbo.AR_Payment_Type |
Table to identify the different payment classifications for an AR payment |
dbo.AR_Statement_Sort_By |
Table to identify which field to sort by in statements for Accounts Receivable |
dbo.AR_Transaction |
This table stores Invoices, Credit Memos, and Finance Charges for the Accounts Receivable service. Invoices and Finance Charges are transactions customers have to pay while Credit Memos are can be used to reduce open balance. |
dbo.AR_Transaction_Item |
This table stores items for an AR Transaction. Items are usually created by selected an row from the AR Item table and copying all necessary information down to this table. This way changes made to the AR Item will not change existing payables. |
dbo.AR_Transaction_Item_GL_Account |
This table stores GL Accounts for AR Transaction Items and the type for that account. |
dbo.AR_Transaction_Item_GL_Account_Type |
This table stores types of GL Accounts for AR Transaction Items. |
dbo.AR_Transaction_Item_N_AR_Item |
This table stores the connection between an AR Transaction Item and an AR Item. This connect is maintained so that the system knows where specific AR Items are being used. This is in a seperate table to allow either side to be deleted without changing the other side. |
dbo.AR_Transaction_Template |
Contains templates that can be used to generate an AR transaction. |
dbo.AR_Transaction_Template_Item |
Tracks items associated with an AR template. |
dbo.AR_Transaction_Template_N_Customer |
Links AR templates to customers. An AR template can have multiple customers selected for it and a customer can be used for multiple templates. |
dbo.AR_Transaction_Type |
This table stores the AR transaction types. |
dbo.ATF_Payroll_Check_Entry_Option |
This table contains the data entry options to configure the After The Fact handwritten batch check entry grid. |
dbo.ATF_Payroll_Check_Entry_Option_Pay_And_Tax_Item_Definition |
This table contains the selected pay and tax items in the After The Fact Handwritten Batch Check entry["BR"] options screen. A row in this table can represent either a pay or a tax item (but not both). |
dbo.Account_Source_Selection |
Funding account reference source selection. |
dbo.Accounting_Application |
The table enumerates the different types of accounting applications that may use the database. |
dbo.Accrual_Date |
|
dbo.Accrual_Method |
|
dbo.Ach_Company_Batch_Header_Record |
|
dbo.Ach_Entry_Addenda_Record |
|
dbo.Ach_Entry_Detail_Record |
|
dbo.Ach_File_Header_Record |
|
dbo.Active_Filter |
|
dbo.Active_Status |
This table stores the values to be used for showing the Status values for various entities. |
dbo.Additional_Contact |
|
dbo.Additional_Contact_Role |
This table allows user to assign defined firm level additional contact roles to additional contact for a client. |
dbo.Address |
|
dbo.Affordable_Care_Act_Employee_Status |
This table stores the employee status allowed for selection with regard to affordable care act information |
dbo.Alert_Level |
|
dbo.Apply_Customer_Payment_Option |
This table holds user options, per client per staff, for apply customer payments. |
dbo.Apply_Customer_Payment_Transaction |
This table exists to provide a data source for the apply customer payments view grid. This table will exist only for the purpose of feeding the datasource to the grid, and to facilitate filtering in our system. Such a table is sometimes called a “temporary” table. It is permanently in the database, but holds data only temporarily, while the Apply Customer Payments view is displayed. This table holds a combination of ar payments (cash, check, credit card and write-offs) and ar transactions (invoices, credit memos, and finance charges) for a given client. |
dbo.Ascii_Time_Clock_Client_Benefit_Id_Map |
This table is used for ASCII time clock import. It maps a client benefit to a (user-provided) id. The format of the id is specified by a legacy file format. |
dbo.Ascii_Time_Clock_Client_Payroll_Item_Id_Map |
This table is used for ASCII time clock import. It maps a client payroll item to a (user-provided) id. The format of the id is specified by a legacy file format. |
dbo.Ascii_Time_Clock_Employee_Id_Map |
This table is used for ASCII time clock import. It maps an employee to a (user-provided) id. The format of the id is specified by a legacy file format. |
dbo.Ascii_Time_Clock_Payroll_Department_Id_Map |
This table is used for ASCII time clock import. It maps a payroll department to a (user-provided) id. The format of the id is specified by a legacy file format. |
dbo.Automatic_Journal_Entry_Period_Option |
Type table which defines the period options for automatic journal entry calculation. |
dbo.Automatic_Payment_Application_Method |
Accounts Payable Automatic Payment Application Method table |
dbo.Autopay_Session |
Contains info about Autopay sessions. In an Autopay session the system automatically creates checks from a pay schedule detail record. |
dbo.Autopay_Session_Status |
The available status values for an Autopay session (completed, failed, etc.). |
dbo.BS_Bank_Reconciliation_Statement_Import__Ach_File_Header_Record |
Used only in client backup databases, to hold summary information about references to ACH_File_Header_Record rows by Bank_Reconciliation_Statement_Import rows which cannot be directly represented in incomplete backup databases. |
dbo.BS_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__source |
This table will only have rows in a CDMU Backup Database. Tracks an outgoing reference to bank transaction data from Bank_Transaction_Reconciliation_Detail. If there is a reconciled firm client transaction from a funded paper net check with source__bank_transaction_KEY pointing to a standard client and it is then reversed we get into a state where a standard client row is referencing firm data through source__bank_transaction_KEY. Backup and restore uses this to link a restored client to data in the firm. |
dbo.BS_Billing_Item__GL_Account__delivery |
Tracks an outgoing reference to other client data in FK_Billing_Item__GL_Account__delivery__gl_account_KEY. Backup and restore uses this to link a restored client to data in another client. |
dbo.BS_Billing_Item__GL_Account__discount |
Tracks an outgoing reference to other client data in FK_Billing_Item__GL_Account__discount__gl_account_KEY. Backup and restore uses this to link a restored client to data in another client. |
dbo.BS_Billing_Item__GL_Account__fees |
Tracks an outgoing reference to other client data in FK_Billing_Item__GL_Account__fees__gl_account_KEY. Backup and restore uses this to link a restored client to data in another client. |
dbo.BS_Billing_Item__GL_Account__receivable |
Tracks an outgoing reference to other client data in FK_Billing_Item__GL_Account__receivable__gl_account_KEY. Backup and restore uses this to link a restored client to data in another client. |
dbo.BS_Billing_Item__GL_Account__sales_tax |
Tracks an outgoing reference to other client data in FK_Billing_Item__GL_Account__sales_tax__gl_account_KEY. Backup and restore uses this to link a restored client to data in another client. |
dbo.BS_Client_Billing__Client__bill_to_other_client |
Tracks an outgoing reference to other client data in FK_Client_Billing__Client__bill_to_other_client__client_KEY. Backup and restore uses this to link a restored client to data in another client. |
dbo.BS_Client_Payroll_Information__Checkbook__firm_vendor_impound_deposit |
Tracks an outgoing reference to other client data in FK_Client_Payroll_Information__Checkbook__firm_vendor_impound_deposit__checkbook_KEY. Backup and restore uses this to link a restored client to data in another client. |
dbo.BS_Client_Payroll_Information__Checkbook__firm_vendor_impound_withdrawal |
Tracks an outgoing reference to other client data in FK_Client_Payroll_Information__Checkbook__firm_vendor_impound_withdrawal__checkbook_KEY. Backup and restore uses this to link a restored client to data in another client. |
dbo.BS_Client_Payroll_Information__Checkbook__payroll_agent_impound_deposit |
Tracks an outgoing reference to other client data in FK_Client_Payroll_Information__Checkbook__payroll_agent_impound_deposit__checkbook_KEY. Backup and restore uses this to link a restored client to data in another client. |
dbo.BS_Client_Payroll_Information__Checkbook__payroll_agent_impound_withdrawal |
Tracks an outgoing reference to other client data in FK_Client_Payroll_Information__Checkbook__payroll_agent_impound_withdrawal__checkbook_KEY. Backup and restore uses this to link a restored client to data in another client. |
dbo.BS_Client_Payroll_Information__Checkbook__payroll_impound_deposit |
Tracks an outgoing reference to other client data in FK_Client_Payroll_Information__Checkbook__payroll_impound_deposit__checkbook_KEY. Backup and restore uses this to link a restored client to data in another client. |
dbo.BS_Client_Payroll_Information__Checkbook__payroll_impound_withdrawal |
Tracks an outgoing reference to other client data in FK_Client_Payroll_Information__Checkbook__payroll_impound_withdrawal__checkbook_KEY. Backup and restore uses this to link a restored client to data in another client. |
dbo.BS_Client_Payroll_Information__Checkbook__tax_agent_impound_deposit |
Tracks an outgoing reference to other client data in FK_Client_Payroll_Information__Checkbook__tax_agent_impound_deposit__checkbook_KEY. Backup and restore uses this to link a restored client to data in another client. |
dbo.BS_Client_Payroll_Information__Checkbook__tax_agent_impound_withdrawal |
Tracks an outgoing reference to other client data in FK_Client_Payroll_Information__Checkbook__tax_agent_impound_withdrawal__checkbook_KEY. Backup and restore uses this to link a restored client to data in another client. |
dbo.BS_Direct_Deposit_Bank_Transaction_Allocation__Ach_Company_Batch_Header_Record |
Tracks an outgoing reference to ACH data in FK_Direct_Deposit_Bank_Transaction_Allocation__Ach_Company_Batch_Header_Record__ach_company_batch_header_record_KEY. Backup and restore uses this to link a restored client to ACH data. |
dbo.BS_Workpaper__Staff__assigned_to_staff |
Tracks an outgoing reference to staff data in FK_Workpaper__Staff__assigned_to__staff_KEY. Backup and restore uses this to link a restored client to data in the staff. |
dbo.Backup_Withholding_Rate |
The table used to store backup withholding rates and their effective dates. |
dbo.Balance_Definition |
Balance Definition Table - Defines what journal entry types make up a balance for a client |
dbo.Balance_Definition_Journal_Entry_Type_Component |
Connects a client balance to the journal entry types that are it's components. |
dbo.Balance_Type |
ACS Balance Types - enumerates the supported calculation basis of journal entry balances |
dbo.Bank |
Data about banks is stored here. Bank_View exists and, as of 3004.75.120 limits the columns returned, so columns which should surface on the entity should be added there. |
dbo.Bank_Account_Direct_Deposit_Status |
|
dbo.Bank_Account_Type |
|
dbo.Bank_Feeds_Assignment_Column |
This table hold the information of Assign value in Create Rules dialog. Assign value should allow the user to select either description, reference, vendor, or account to bank statement transactions. |
dbo.Bank_Feeds_Assignment_Rule |
This table hold the information of Create Rules dialog. The dialog should allow the user to create rules for assigning a description, reference, vendor, and account to bank statement transactions. The user may use the reference, description, amount, vendor, or account fields to apply the rules. |
dbo.Bank_Feeds_Assignment_Rule_Action |
This table holds the information for Create Rules dialog Action part. The dialog should allow the user to create rules for assigning a description, reference, vendor, and account to bank statement transactions. The user may use the reference, description, amount, vendor, or account fields to apply the rules. |
dbo.Bank_Feeds_Assignment_Rule_Action_Distribution |
This table holds the information about multiple distributions to be assigned via rules. |
dbo.Bank_Feeds_Bank_Transaction |
This table keeps track of which bank transactions were imported from a yodlee transaction or matched to a yodlee transaction. |
dbo.Bank_Feeds_Import |
this table will store off the start date and the end date of the last retrieve. Also there will be data for the date and time of the last successful retrieve.["BR"] |
dbo.Bank_Feeds_License_Agreement |
this table tells records the staff id and staff name of the staff member that accepted a version of the bank feeds license agreement. Firms that use bank feeds will need a record in this table for the current license agreement and the primary key constant that matches the current license agreement. Firms that do not use bank feeds will not have a record in this table. Updates to the license agreement would result in new records being added to this table with a new primary key constant for the firms using bank feeds, once a staff member accepts the new version of the license agreement. |
dbo.Bank_Feeds_Refused_Transaction |
This table holds the information about bank feeds transactions that were deleted by the user so that they do not show up on future retrievals |
dbo.Bank_Feeds_Retrieved_Financial_Account |
This table provides records from a bank feeds bank account or other financial account. |
dbo.Bank_Feeds_Retrieved_Transaction |
This table provides transaction records from a bank feeds bank account or other financial account. |
dbo.Bank_Feeds_Retrieved_Transaction_Distribution |
This table provides transaction distribution records related to a bank feeds transaction. |
dbo.Bank_Feeds_Retrieved_Transaction_Rule_Applied |
This table holds the information about bank feeds retrieve transactions on which bank feeds rules has been applied. |
dbo.Bank_Feeds_Transaction_Description_Type |
Table for options for the description for Bank Feeds Retrieved Transactions. These options indicate on what the description value["BR"] of a transaction retrieved from Yodlee needs to be based |
dbo.Bank_Feeds_Transaction_Import_Status |
This table stores values for the transaction import status. These are values used in the import process to determine how to process each transaction retrieved from bank feeds. |
dbo.Bank_Feeds_Transaction_Option |
Table for options for the Bank Feeds Retrieved Transactions |
dbo.Bank_Feeds_Transaction_Source_Type |
This table hold the information of bank feeds retrieved transaction source either yodlee, or digital file like bank statement. |
dbo.Bank_Reconciliation_Adjustment_Order |
|
dbo.Bank_Reconciliation_Adjustment_Type |
|
dbo.Bank_Reconciliation_Aggregate_Clear_Status |
This is a type table of bank reconciliation clear status values that apply to a given bank transaction as a whole. This value is an aggregate of the bank transaction's associated bank reconciliation detail's clear status (cleared or uncleared). |
dbo.Bank_Reconciliation_Clear_Status |
|
dbo.Bank_Reconciliation_Client_Adjustment |
This table stores adjustments that show adjustments that the user wants one of their clients to make in their own bank account records. Adjustments in this table do not impact the general ledger, they are used for report purposes only. They do not impact any bank reconciliation statement totals, they are just intended as a means for a user to convey information to one of their clients about adjustments the client has to make to their own records. |
dbo.Bank_Reconciliation_Frequency_Type |
|
dbo.Bank_Reconciliation_Rapid_Clear_Unmatched_Transaction |
This table will hold all the pending unmatched keyed-in data in the Rapid Clear dialog for a given bank reconciliation. This data will be deleted for finalized bank reconciliations. |
dbo.Bank_Reconciliation_Recurring_Adjustment_Template |
|
dbo.Bank_Reconciliation_Recurring_Adjustment_Template_Distribution |
This table holds the distributions of a bank reconciliation recurring adjustment template. |
dbo.Bank_Reconciliation_Statement |
|
dbo.Bank_Reconciliation_Statement_Detail |
|
dbo.Bank_Reconciliation_Statement_Import |
This table will hold the list of bank statement transactions imported from the bank via a file. These transactions will be used by bank reconciliation to clear bank transactions. It will hold on to these transactions when the user chooses to finish the bank rec later and once the user finalizes, it will lose all its data for the given Bank Statement. |
dbo.Bank_Reconciliation_Statement_Imported_File_Name |
This table will hold the list of locations and names of bank statement files imported from the bank. |
dbo.Bank_Reconciliation_Statement_Summary |
This table will store bank reconciliation statement summary data entered by the user. The statement summary dialog is an optional feature in bank reconciliation and allows users to enter statement deposits/other credits and check/other debits amounts for multiple statements, amounts which are totaled and carry into one bank reconciliation. |
dbo.Bank_Reconciliation_Status |
|
dbo.Bank_Transaction |
|
dbo.Bank_Transaction_Accounting_Source_Override_Bank_Transaction_Distribution |
Entries in this dictionary table link a bank transaction distribution that uses a checkbook's GL account number with the bank transaction created to affect that checkbook's balance. The bank transaction is ignored as far as account balances go; the associated distribution carries all the accounting effect. |
dbo.Bank_Transaction_Accounting_Source_Override_Journal_Entry_Distribution |
Entries in this dictionary table link a journal entry distribution that uses a checkbook's GL account number with the bank transaction created to affect that checkbook's balance. The bank transaction is ignored as far as account balances go; the associated distribution carries all the accounting effect. |
dbo.Bank_Transaction_Address |
|
dbo.Bank_Transaction_Displayable_Status |
This type table contains values that represent a bank transaction's status determined by analyzing all pertinent attributes of the transaction (its type, record status, handwritten flag, etc.). This value can be displayed by data entry screens, used when filtering bank transactions on status, etc. |
dbo.Bank_Transaction_Distribution |
Distributions of Bank_Transaction records are stored here unless it is a Payroll Check. In that case see Payroll_Check_Payroll_THING_Distribution. Bank_Transaction_Distribution_View exists with an explicit column list, so columns which should surface on the entity should be added there. |
dbo.Bank_Transaction_Event |
Table to store bank transactions events |
dbo.Bank_Transaction_Event_Type |
Table to store the event type for bank transactions |
dbo.Bank_Transaction_Reconciliation_Detail |
This table is primarily for Bank Rec use. Its purpose is for partial clearing of a bank transaction. The records in this table define the smallest granularity at which a bank transaction can be cleared. For some types of transactions, the system defines the contents of this table; for others, the user is allowed to enter what they wish. |
dbo.Bank_Transaction_Reversal |
|
dbo.Bank_Transaction_Template |
This table stores information about the bank transaction portion of a transaction template. |
dbo.Bank_Transaction_Template_Distribution |
This table contains the distributions associated with a bank transaction template. |
dbo.Bank_Transaction_Template_Reconciliation_Detail |
This table contains records that denote if the user wishes to clear the whole transaction amount in bank reconciliation, or whether it wants the option of partially clearing the bank transaction. |
dbo.Bank_Transaction_Transfer_Type |
The table enumerates the different types of bank transaction transfers supported by the system. |
dbo.Bank_Transaction_Type |
|
dbo.Benefit_Accrual_Balance_Reset_Type |
|
dbo.Benefit_Accrual_Exclusion_Detail |
Table used to store selected accruable benefit exclusions. |
dbo.Benefit_Allowance |
|
dbo.Benefit_Eligibility_Duration_Type |
This table stores the time duration types available for accruable benefit eligibility items. |
dbo.Benefit_Item_Worker_Compensation_Exemption |
|
dbo.Benefit_Item_Worker_Compensation_Exemption_Detail |
|
dbo.Benefit_Period_Usage_Type |
The type table used to store accruable benefit period usage types. |
dbo.Benefit_Transaction |
|
dbo.Benefit_Transaction_Type |
The table defines benefit transaction types. |
dbo.Billable_Item |
|
dbo.Billable_Item_N_Check_Print_Run |
|
dbo.Billable_Item_N_Form_Processing_Run |
This table holds the connection between each billable item and the form processing run that it is associated with. |
dbo.Billing_Calculation_Method |
|
dbo.Billing_Calculation_Type |
|
dbo.Billing_Fee_Frequency |
|
dbo.Billing_Fee_Method |
|
dbo.Billing_Fee_Month |
|
dbo.Billing_Fee_Schedule |
|
dbo.Billing_Fee_Type |
|
dbo.Billing_Item |
|
dbo.Billing_Item_1099_Type |
This table is used to hold the differnt types of 1099 forms. |
dbo.Billing_Item_Form |
This table holds the different forms for each form type used for creating form fees. |
dbo.Billing_Item_Form_Rate |
This table is used to hold the different fee amounts for each form of a form fee. |
dbo.Billing_Item_Form_Type |
This table is used to hold the differnt form types used for creating form fees. |
dbo.Billing_Item_Schedule |
The table used to store default schedule settings associated with a global schedule. |
dbo.CSA_1099_Item_Map_To_W2_1099_Box_Pair |
Table that stores the CSA 1099 description and associates that with ACS 1099 items |
dbo.Cch_Tax_Code_Map_To_Acs_Tax_Code |
Lists the different types of Cch codes. |
dbo.Check_Date_Adjustment_Method |
|
dbo.Check_Output_Type |
|
dbo.Check_Print_Run |
|
dbo.Check_Print_Run_N_Bank_Transaction |
Dictionary table which links a print run and related bank transactions. |
dbo.Check_Template_Usage_Preference_Setting |
This table stores the usage settings used for payroll check templates, for when possibly initializing a payroll check based on a template, and for when possibly updating a payroll check template based on edits to a payroll check. |
dbo.Checkbook |
Table which holds data related to clients bank accounts. |
dbo.Child_Employee_Payroll_Item_N_Parent_Employee_Payroll_Item |
Linker from child employee payroll item to parent employee payroll item. Child employee payroll items get the values for calculation type and rates from the parent employee payroll item. The child and parent values cannot be the same. Parent items cannot also be children. Only pay type payroll items can be represented in this table. The employee payroll items in this table must be for the same employee. Parent items cannot be of special type weighted average overtime. The calculation types and rates must match between employee payroll items in the table as well as their distributions. |
dbo.Child_Support_Order |
|
dbo.Client |
|
dbo.Client_1095 |
This table stores the client 1095 information. |
dbo.Client_1095_Override |
This table stores the overrides for client 1095 information. |
dbo.Client_1099_Override |
The table used to store Client overrides for the 1099s. |
dbo.Client_1099_State_Override |
The table used to store the overrides for a Client's state id numbers. |
dbo.Client_1099_State_Override_Type |
The table used to various types of Client 1099 state overrides. |
dbo.Client_1099_Tax_Form_Information |
This table stores per-client selections regarding point-of-contact, signator, and some miscellaneous selections for the 1099 suite of forms. |
dbo.Client_1099_Tax_Form_Selection |
This table stores selections by client, 1099 Type, and tax form collation (as a proxy for federal/state copies of 1099s) as to the filing method, the do-not-file selection, and the filing threshold. |
dbo.Client_AP_Setup |
Client Accounts Payable Setup information table |
dbo.Client_AR_Setup |
Table used to set up a client for use in accounts receivable |
dbo.Client_Access_Notification |
This table stores the notifications created when certain types of actions are completed by the client in ACS Client Access. |
dbo.Client_Access_Notification_Event_Type |
The table stores the actions completed by the client staff in ACS Client Access that will create notifications in the Client Access Notification Portlet |
dbo.Client_Access_Notification_Review_Status |
This table stores the review status types of the Client Access Processing Notification. |
dbo.Client_Bank_Reconciliation_Option |
|
dbo.Client_Benefit |
|
dbo.Client_Billing |
|
dbo.Client_Billing_Item |
|
dbo.Client_Billing_Item_Rate_Adjustment |
The table used to store rate adjustments related to a client billing item. |
dbo.Client_Billing_Item_Schedule |
|
dbo.Client_Billing_Sales_Tax |
|
dbo.Client_Class |
|
dbo.Client_Consolidation_Grouping_Type |
This table will hold values for the client consolidating grouping type |
dbo.Client_Consolidation_Option |
This table will hold all the options for the consolidating master client |
dbo.Client_Contact_Payroll_Administrator |
This table contains the details of Payroll Administrator checkbox selected in Additional Contacts. |
dbo.Client_Contact_Payroll_Tax_Information |
The prescence of a record in this table for a given client contact indicates that the contact is the client payroll tax form signer. |
dbo.Client_Delay_Direct_Deposit_Status_Type |
This table contains types of client delay direct deposit status |
dbo.Client_Direct_Deposit |
|
dbo.Client_File_Exchange_Portal_Ems_User |
This table says which NetClient users are associated with ACS Clients for File Exchange purposes. It lists which users will have their data available when accessing File Exchange data for an ACS client. An ACS Client may have many NetClient users associated with it. |
dbo.Client_GL_Setup |
|
dbo.Client_Inactive_Reason |
|
dbo.Client_N_Client_Service_Type |
Table to subscribe services that the client belongs to |
dbo.Client_N_Report_Folder |
Linker/Dictionary table that associates Client records with Report_Folder records. |
dbo.Client_N_Staff |
List which firm staff are allowed access to each client. |
dbo.Client_N_Subsidiary_Client |
This table will hold all the master client and their subsidiary client linked to them |
dbo.Client_Onboarding_Property |
Contains information required to support communication with the MyPay Onboarding product. The Onboarding product is a wizard, hosted in Onvio, that collects data to be imported and create an SBPR client. |
dbo.Client_Onvio_Payroll_Integration_Status |
Status types specifically for a Client that are used to signify the stages of operations related to Onvio Payroll. |
dbo.Client_Pay_Schedule |
|
dbo.Client_Pay_Schedule_Batch_Session |
This table holds identifiers for client pay schedules currently being processed in batch check entry to prevent multiple processing instances. |
dbo.Client_Pay_Schedule_Detail |
|
dbo.Client_Pay_Schedule_Displayable_Status |
The types in this table correspond to those in Client_Pay_Schedule_Status, but are used to display to the user. |
dbo.Client_Pay_Schedule_Status |
|
dbo.Client_Pay_Schedule_Type |
The type of Client Pay Schedule. Such as On Demand, Regular, or Handwritten. |
dbo.Client_Payroll_Information |
|
dbo.Client_Payroll_Information_Swipe_Clock_Details |
This table contains login/configuration["BR"] information related to Swipe Clock. This table has a 0..1 to 1 relationship with Client. |
dbo.Client_Payroll_Information_Swipe_Clock_Partner_Login_Credentials |
This table contains login/configuration["BR"] information related to Swipe Clock. This table has a 0..1 to 1 relationship with Client. |
dbo.Client_Payroll_Item |
|
dbo.Client_Primary_Location |
|
dbo.Client_Remote_Payroll_Setup |
|
dbo.Client_Service_Type |
Table to name the services that the client can subscribe to |
dbo.Client_Shortcut |
|
dbo.Client_Staff_Intercept_Credentials |
Table for InterceptEFT credentials for client staff. |
dbo.Client_Staff_Next_Id_Number |
Contains next ID number to use for auto-ID creation for client staff. Only has one record. Used only by SBPR. |
dbo.Client_Synchronization |
This tables stores the last synchronization time per client. |
dbo.Client_Synchronization_Type |
This table defines all of the client synchronization types used in the Client_Synchronization table. |
dbo.Client_Tax_Item |
|
dbo.Client_Tax_Item_Type |
Table containing Client Tax item types. |
dbo.Client_Type |
|
dbo.Client_Undistributed_GL_Account |
|
dbo.Client_W2_Override |
The table used to store Client W-2 overrides. |
dbo.Client_W2_Rendered_Document |
Table used to store pre-rendered documents which are included in the client W2 package; the federal transmittal documents (W3) and state/local client transmittals (names vary by locality) |
dbo.Client_W2_Rendering_Queue |
This table acts as a queue of clients which require W2 document rendering. |
dbo.Client_W2_State_Override |
The table used to store the overrides for a Client's state id numbers. |
dbo.Client_W2_State_Override_Type |
The table used to various types of Client 1099 state overrides. |
dbo.Code_Subcode_Type |
This table stores type definition for the account grouping. |
dbo.Compare_Date_Type |
|
dbo.Complete_Forms_Output_Session |
This table stores the information associated with a complete forms output session. |
dbo.Complete_Forms_Output_Session_Client_Detail |
This table stores the client detail associated with a complete forms output session. |
dbo.Complete_Forms_Output_Session_Status |
This table stores the complete forms output session status item types. |
dbo.Complete_Payroll_Output_Liability_Payment_Method |
This tables describes methods for making liability payments. |
dbo.Complete_Payroll_Output_Session |
Complete Payroll Output sessions that are currently in progress. |
dbo.Complete_Payroll_Output_Session_Client_Detail |
This table stores the client detail associated with a complete payroll output session. |
dbo.Complete_Payroll_Output_Session_Status |
This table stores the complete payroll output session status item types. |
dbo.Connect_Alert |
This table stores alerts from CS Connect |
dbo.Connect_Alert_Type |
The type of Connect Alert |
dbo.Contact |
|
dbo.Contact_Address |
|
dbo.Contact_Address_N_Address |
This table links a contact address record to an address record. |
dbo.Contact_Address_Payroll_Information |
|
dbo.Contact_Address_Ste_Location_Code_History |
Table which holds residency history for employees - the lack of a record in this table indicates the current employee address is the only one. |
dbo.Contact_Address_Type |
|
dbo.Contact_Email |
|
dbo.Contact_Email_Type |
|
dbo.Contact_Phone |
|
dbo.Contact_Phone_Type |
|
dbo.Contact_Type |
|
dbo.Conversion_Wizard_Client_Payroll_Information |
The conversion wizard has different screens where users select various options that affect the conversion of data from CSA. This table holds options concerning certain data that is held in the Client_Payroll_Information table. |
dbo.Conversion_Wizard_Local_Withholding |
Stores local withholding conversion settings, both the source information and what it will be mapped to in SBPR. |
dbo.Conversion_Wizard_Segment_Choice |
The conversion wizard has different screens where users select various options that affect the conversion of data from CSA. This table holds the options pertaining to what segments of the CSA date should be converted, such as employees, payroll items or conversions. |
dbo.Copy_From_VO_Destination_Path |
This table will hold the destination paths selected by each user for each file type when using Copy Files. |
dbo.Copy_From_VO_Source_Type |
Copy From VO Source Type table. |
dbo.Country_Code |
Type table for ISO 3166-1 country codes. |
dbo.Creditor_Garnishment_Order |
Contains creditor garnishment orders for employee payroll items. |
dbo.Csa_Account_Group_Map_To_Classification_Code |
This table stores the classification code/subcode mappings for CSA account groups. |
dbo.Csa_Staff_Map_To_Acs_Staff |
This table stores the staff Id/staff name mappings for CSA staff. |
dbo.Custom_Excel_Grid |
This table will hold data for custom excel grid |
dbo.Custom_Excel_Template |
Templates saved in this table are at firm level i.e. available for all clients. |
dbo.Custom_Excel_Template_Amount_Data |
This table provides additional data about entries in table Custom_Excel_Template_Data which shall exist EXACTLY when the trial_balance_grid_column_type_KEY column of that table is 3 (Amount) |
dbo.Custom_Excel_Template_Data |
A row in this table corresponds to a mapped column in the Custom Excel Template |
dbo.Custom_Field |
["BR"]Defines custom fields, allowing users to attach custom data to various business objects["BR"]without altering schema. The kind of business object being extended is identified by["BR"]the "owner_table_name". |
dbo.Custom_Field_Type |
|
dbo.Custom_Fieldview |
|
dbo.Custom_Fieldview_Type |
|
dbo.Custom_Grouping |
|
dbo.Custom_Office_Account_Grouping |
This table will store all the grouping and grouping codes for the custom excel grid if the grid is grouped by account grouping |
dbo.Custom_Office_Grid_Column_Relation_Operator_Type |
This table stores column operation operator types. This table is used for custom Excel workpapers only and does not apply to trial balance. |
dbo.Custom_Office_Grid_Column_Relation_Option |
This table stores custom Office workpaper relation option for columns that are relation type. This table is used for custom Excel workpapers only and does not apply to trial balance. |
dbo.Custom_Office_Grid_Column_Segment |
This table stores gl account segment and gl account segment code keys for a custom office grid column. This table is used for custom Excel workpapers only and does not apply to trial balance. |
dbo.Custom_Portlet |
|
dbo.Custom_Portlet_Type |
|
dbo.Custom_Value |
|
dbo.Custom_Value_Client |
This table links a client to one of the custom values associated with it. |
dbo.Custom_Value_Client_Staff |
This table links a client staff (ACS or CSS) to one of the custom values associated with it. |
dbo.Custom_Value_Customer |
This table links a customer to one of the custom values associated with it. |
dbo.Custom_Value_Employee |
This table links a employee to one of the custom values associated with it. |
dbo.Custom_Value_Firm |
This table links a employee to one of the custom values associated with it. |
dbo.Custom_Value_Staff |
This table links a vendor to one of the custom values associated with it. |
dbo.Custom_Value_Vendor |
This table links a vendor to one of the custom values associated with it. |
dbo.Customer |
A client specific table that stores the setup information defining a customer. |
dbo.Customer_Historical_AR_Transaction |
This table stores the link to any AR Transactions that are considered historical transactions for a customer. |
dbo.Data_Entry_Confirmation |
Lists the types of data for which Data Entry Confirmation is supported and on which ones it is enabled. |
dbo.Data_Entry_Method |
This table contains the possible tabs for a screen. |
dbo.Data_Location_Profile |
Definitions of the Net Client Data Location Profiles. |
dbo.Data_Origin |
This table enumerates possible origins of certain data (for example, bank transactions or journal entries) in the database. |
dbo.Database_Property |
|
dbo.Date_Filter_Value_Type |
This table defines all of our date filter types for use in the date filter dropdown. |
dbo.Date_Format |
|
dbo.Deduction_Item |
Client payroll item properties applicable only to a deduction payroll item. |
dbo.Deduction_Type |
|
dbo.Default_Date_Option |
Options for default date settings. |
dbo.Deposit_Due_Within |
This table stores information on whether deposits are due within three or five banking days. |
dbo.Direct_Deposit_Bank_Transaction |
|
dbo.Direct_Deposit_Bank_Transaction_Allocation |
|
dbo.Direct_Deposit_Bank_Transaction_Allocation_Distribution |
This table stores off location/department portions of the values in the Direct_Deposit_Bank_Transaction_Allocation table. These values are distributed based on the payroll item portion per location/department of the net check amount. |
dbo.Direct_Deposit_Distribution_Method |
Type table for direct deposit distribution method.. |
dbo.Direct_Deposit_Fileheader |
|
dbo.Direct_Deposit_Fundable_Transaction |
This table's purpose is to allow the direct deposit funding UI to use the standard filtering mechanism.["BR"] WARNING - if this table is modified, use-defined table type dbo.Direct_Deposit_Fundable_Transactions and stored procedure["BR"] dbo.pb_Insert_Direct_Deposit_Fundable_Transactions also needs to be updated to maintain identical structure. |
dbo.Direct_Deposit_Method |
|
dbo.Direct_Deposit_Processable_Transaction |
This table's purpose is to allow the direct deposit processing UI to use the standard filtering mechanism.["BR"] WARNING - if this table is modified, use-defined table type dbo.Direct_Deposit_Processable_Transactions and stored procedure["BR"] dbo.pb_Insert_Direct_Deposit_Processable_Transactions also needs to be updated to maintain identical structure. |
dbo.Direct_Deposit_Processing_Locked_Transaction |
This table holds transaction identifiers for direct deposit transactions currently being processed to prevent multiple processing instances. |
dbo.Direct_Deposit_Processing_Locked_Transaction_Type |
This table holds keys for direct deposit processing locked transaction types |
dbo.Direct_Deposit_Status |
|
dbo.Do_Not_Pay_Reason |
This table stores various types of DNP(do not pay) reasons. |
dbo.Document_Management_System_Print_Category |
This table defines all of our print categories supported for outputting to various Document Management Systems. |
dbo.Document_Management_System_Value_Type |
This table defines all supported value types when outputting to various Document Management Systems. |
dbo.Duplicate_Treatment |
Duplicate Treatment types table |
dbo.Eftps_Transaction |
|
dbo.Elf_File |
Holds Electronic file records. These records are stored outside the database and also transmitted to the Connect server. |
dbo.Elf_Transmission |
|
dbo.Elf_Transmission_Status |
|
dbo.Email_Address |
Holds e-mail addresses to save space and aid in indexing. Each e-mail address must be unique and stored as lower case. It is expected that the e-mail address is a SMTP address and looks similar to "user.name@place.net" |
dbo.Employee |
|
dbo.Employee_1095 |
This table stores the employee 1095 information.. The schema for this table must be kept synchronized with Employee_1095_Override for year/month specific fields. A null in one of these year/month specific fields in this table means that it is not set for the employee. A particular year/month group can be all null if is does not apply. Alternatively, the year field can be null with at least some of the months filled in. Lastly, the year field can be non-null and the corresponding month fields are null. |
dbo.Employee_1095_Covered_Individual |
This table stores the employee 1095 Part 3 covered individual information. The form has a single field for name. But the electronic filing requires first name and last name. Suffix is there to distinguish between people with same first and last names. |
dbo.Employee_1095_Override |
This table stores the overrides for employee 1095 information. The schema for this table must be kept synchronized with Employee_1095 for year/month specific fields. A null in one of these year/month specific fields means thatit is not overridden. |
dbo.Employee_Benefit |
|
dbo.Employee_Direct_Deposit_Allocation |
|
dbo.Employee_Earning_Type |
The table used to store the employee earning type options. |
dbo.Employee_Event |
|
dbo.Employee_Event_Type |
|
dbo.Employee_Federal_Levy_Information |
This table is required for employee payroll items that are of garnishment type Federal levy. It holds information about the federal levy |
dbo.Employee_Independent_Contractor_Reported |
The table used to store when an employee has been reported to be an independent contractor. |
dbo.Employee_Multi_State_Income_Tax_Calculation_Method |
This is a type table of options for how an employee's multi-state income tax will be calculated. Each record maps to an available option in the Symmetry calculation engine to configure it to calculate as desired. |
dbo.Employee_Other_State_Setting |
|
dbo.Employee_Other_State_Setting_Type |
|
dbo.Employee_Other_State_Setting_Type_Group |
|
dbo.Employee_Payroll_Item |
|
dbo.Employee_Payroll_Item_Direct_Deposit_Allocation |
Holds direct deposit allocation data for an employee payroll item. |
dbo.Employee_Payroll_Item_Distribution |
Table that supports multiple rates/amount/percents as well as GL accounts for work location/payroll department combinations (for Employee_Payroll_Item). |
dbo.Employee_Payroll_Item_Garnishment_Order |
Contains each garnishment order amount per employee payroll item. |
dbo.Employee_Payroll_Item_N_Payroll_Item_Special_Timing |
This dictionary table associates a employee payroll item record with a payroll item special timing record. All employee payroll items will have a special timing row associated with it except payroll items of type garnishment. |
dbo.Employee_Political_Subdivision_Code_Override |
This table stores override values for employee political subdivision codes. The employee can have at most one override for each client tax item. |
dbo.Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override |
Track employee reconciliation form overrides from the employee detail view grid |
dbo.Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amount |
Provide employee reconciliation form override monthly overrride amounts from the employee detail view grid |
dbo.Employee_Self_Service_1095_Queue |
Table which persists employee 1095 pdf forms until they are transmitted to the Employee Self-Service portal |
dbo.Employee_Self_Service_1099_Queue |
Table which persists employee 1099 pdf forms until they are transmitted to the Employee Self-Service portal |
dbo.Employee_Self_Service_W2_Queue |
Table to track employee w2 forms pending transmission to ESS |
dbo.Employee_Service_Level_Type |
|
dbo.Employee_Sort_By_Type |
|
dbo.Employee_Tax_Form_Locality_Amount_Override |
Track employee reconciliation form local overrides from the employee detail view grid |
dbo.Employee_Tax_Form_Locality_Amount_Type |
The table used to store the employee local amount types. |
dbo.Employee_Tax_Item |
|
dbo.Employee_Tax_Item_Distribution |
Table that supports multiple GL accounts for work location/payroll department combinations (for Employee_Tax_Item). |
dbo.Employee_Tax_Jurisdiction |
|
dbo.Employee_Taxable_Wage_Adjustment |
This table will hold an employee's adjustments to ytd gross taxable wages and ytd taxable wages. |
dbo.Employee_Taxable_Wage_Adjustment_Tax_Selection |
This table holds the tax item (federal/state/local) selection that the user wants the adjustments applied to. |
dbo.Employee_Tip_Allocation |
The table used to store employee-level tip allocation data and overrides. |
dbo.Employee_Tip_Total |
The table used to store client level information for employee tip allocations (employee tip allocation totals). |
dbo.Employee_Type |
Table used to store the status of the an employee record. |
dbo.Employee_W2_Box_12_Other_Item |
A table to hold Box 12 other items for employees. This allows Box 12 items without association to a pay item |
dbo.Employee_W2_Box_12_Override |
The table used to store the overrides for an Employee's box 12 information. |
dbo.Employee_W2_Box_14_Other_Item |
A table to hold Box 14 other items for employees. This allows Box 14 items without association to a pay item |
dbo.Employee_W2_Box_14_Override |
The table used to store the overrides for an Employee's box 14 information. |
dbo.Employee_W2_In_Process_Rendering_Queue |
This table acts as a queue of employees which are in the process W2 document rendering. It provides the ability to roll the employees back into the Employee_W2_Rendering_Queue table if the w2 rendering user session dies, or the cron task is cancelled. |
dbo.Employee_W2_Override |
The table used to store the overrides for an Employee's W-2 information. |
dbo.Employee_W2_Rendered_Datashare |
Table used to store pre-rendered employee datasharing xml that will be exported for import by other applications. |
dbo.Employee_W2_Rendered_Document |
Table used to store pre-rendered employee W2 documents. |
dbo.Employee_W2_Rendering_Queue |
This table acts as a queue of employees which require W2 document rendering. |
dbo.Employee_W2_Tax_Jurisdiction_Override |
The table used to store the overrides for an Employee's state information. |
dbo.Employee_W2_Verification_Dates |
This table stores the dates the employee information has been verified for w2s |
dbo.Employee_W4_Setting |
|
dbo.Employee_W4_Setting_Parameter |
|
dbo.Employee_Work_Location_Payroll_Department |
|
dbo.Employee_Worker_Compensation_Item |
|
dbo.Employee_Worker_Compensation_Item_Distribution |
Holds the distribution of employee worker compensation items across multiple work locations |
dbo.Employer_Contribution_Item |
table containing Insurepay, XactPay employer contribution type information . |
dbo.Employer_Jurisdiction_Payroll_Tax_Information |
|
dbo.Employer_Type |
|
dbo.Ems_User |
Contains information on NetClient users that we mirror in ACS. |
dbo.Engagement_Binder |
This table contains information needed for storing engagements and their data. |
dbo.Engagement_Binder_N_Staff |
This table stores information about staff assigned to work on an Engagement and their assigned roles. |
dbo.Engagement_Binder_Status |
This table contains information needed for describing the states of the Engagement_Binder. |
dbo.Engagement_Binder_Tree_Item |
This will contain the data representing the tree structure for each client. It should never be written to in client code. All writes will happen through known SQL stored procedures. |
dbo.Engagement_Folder_Type |
This table stores information about the possible roles a folder can play in an engagement binder. |
dbo.Engagement_Item_Note |
This table stores the information about the association of notes with either the binder, the folder or the workpaper. |
dbo.Engagement_Item_Note_Status |
This table contains information needed for describing the states a note can have. |
dbo.Engagement_Tree_Column_Selector |
stores the order of columns as well as which columns will be displayed. |
dbo.Engagement_Tree_Static_Column |
Stores the static column types that will always be available to users. |
dbo.Engagement_Type |
This table contains information needed for describing the various states of an engagement binder. |
dbo.Engagement_View_Classification |
This is a type table that describes the different types of views that will use the engagement tree column selector table. |
dbo.Engagement_Workspace_Tab |
Stores foreign key to user preference table and description for each engagment workspace tab. |
dbo.Enter_AR_Deposit_Option |
This table contains options used on the Enter AR Deposit screen. |
dbo.Enter_Transaction_Data_Entry_Mode |
This table enumerates the different modes of data entry methods for Enter Transaction. |
dbo.Enter_Transaction_Data_Entry_Session_Element |
This table keeps track of the gl transaction keys that make up a staff member's current data entry session. |
dbo.Enter_Transaction_Default_Distribution_Description_Type |
This table enumerates the different types of descriptions for distributions to default to for Enter Transactions. |
dbo.Enter_Transaction_User_Preference |
This table is used to hold options for the data entry of Enter Transaction. |
Error_Log |
Surrogate Key, Primary Key, Clustering Key, Identity constraint. This column is maintenance for referential integrity and serves no exterial buisness constraint. |
dbo.Event_Class_Type |
|
dbo.Event_Type |
|
dbo.Export_Destination |
This table enumerates the different types of export destinations that are available when we export data. Examples of export destinations: CS Professional Suite Accounting, and quickbooks. |
dbo.Export_Journal_Entry_To_Csa_Format |
|
dbo.Export_Journal_Entry_To_Csa_Information |
|
dbo.Export_Journal_Entry_To_Csa_Status |
|
dbo.Export_Text_File_Format |
This table contains file formats for text files. These text files are used to export data out of the database. For example, Positive Pay type text file formats are used to export bank transaction information to financial institutions that support it. |
dbo.Export_Text_File_Format_Column_Definition |
This table contains column definitions for a given row in a text file format. Each text file format row definition can have one or more columns defined. |
dbo.Export_Text_File_Format_Export_Data |
This table lists the data available to be exported from the database. The first entry in this table is special; it indicates that the desired information is not available in our database. |
dbo.Export_Text_File_Format_Row_Definition |
This table contains row definitions for a given text file format. Each text file format can have one or more row definitions. For example, a definition that defines the format of rows in the header section of the file and a definition that defines the format of rows in the detail section of the file. |
dbo.Export_Text_File_Format_Type |
This type table lists the kinds of text file formats supported by the system. |
dbo.Export_User_Preference |
This table stores export user preferences. |
dbo.Federal_Levy_Exemption_Amount |
This table stores federal levy exemption values that will be updated via schema update when tax laws change these values. These values determine how much of an employees pay is exempt from federal levies. |
dbo.Federal_Levy_Exemption_Type |
Table for federal levy exemption type |
dbo.Federal_Tax_Exemption |
|
dbo.Federal_Tax_Exemption_Type |
|
dbo.Federal_Unemployment_Tax_Exemption_Type |
|
dbo.File_Location |
|
dbo.File_Storage |
This table contains information needed for storing files. |
dbo.File_Storage_Data |
This table holds the file data referenced in the File_Storage table. |
dbo.Filter |
|
dbo.Filter_Base_Type |
|
dbo.Filter_Line |
|
dbo.Filter_Line_Type |
|
dbo.Filter_Range |
|
dbo.Filter_Range_Cache |
|
dbo.Filter_Range_Type |
|
dbo.Filter_Select |
|
dbo.Filter_Selection |
Table used to store information about filters in use during the last user session. |
dbo.Filter_Selection_Type |
Table storing the different locations the user might use filters. |
dbo.Filter_Type |
|
dbo.Finance_Charge_Date_Basis |
This table stores the types of dates that finance charges can be calculated from. |
dbo.Finance_Charge_Definition |
A client specific table that stores the setup information defining a finance charge, which is used to calculate fees on overdue balances. |
dbo.Finance_Charge_Grace_Period_Basis |
This table stores the unit types of finance charge grace period. |
dbo.Firm |
This table contains all the firm level information. |
dbo.Firm_Additional_Contact_Role |
This table is used to save various roles to the Additional Contacts they set up on their clients |
dbo.Firm_Contact_Payroll_Tax_Information |
|
dbo.Firm_Electronic_Filing_Information |
|
dbo.Firm_Notification_Additional_Contact_Role |
This table stores additional contact roles which are applicable to the notification type. |
dbo.Firm_Notification_Hourly_Pay_Rate |
A table to store standard hourly pay rate used as a threshold in determining if an alert is needed. |
dbo.Firm_Notification_Information |
This table stores firm level settings related to what types of alerts and notifications should be provided for various scenarios. |
dbo.Firm_Notification_Other_Address |
This table stores information about the firm level other email addresses that notifications should be sent to. |
dbo.Firm_Preferences_Swipe_Clock_Partner_Login_Credentials |
This table contains partner login["BR"] information/credentials associated with SwipeClock application, needed while establishing connection from ACS. This["BR"] table has a 0..1 to 1 relationship with Firm. |
dbo.Firm_Preferences_Workforce_Hub_Login_Credentials |
This table contains login credentials used for WorkforceHUB. |
dbo.Firm_Shortcut |
|
dbo.Firm_Transitory_Information |
This table stores firm information that changes often. Updates to the firm table can cause blocking if other long running queries are ongoing. |
dbo.Folder |
This table contains information needed for describing a folder in the engagement binder tree. |
dbo.Folder_N_Source_Document_Processing_Sort_Order |
this table stores the linking information between Folder table and Source Document Processing Sort Order table. |
dbo.Folder_N_Source_Document_Processing_Tax_Organizer_Sort_Order |
This table stores the linking information between Folder table and Source Document Processing Tax Organizer Sort Order table. |
dbo.Form_1094_Section_4980H_Code |
This table stores the 1094 section 4980H code selections. |
dbo.Form_1094c_Aggregate_Group |
An aggregate group is made up of related companies that have different EINs but must be considered one entity ["BR"] for determining if they are subject to the Affordable Care Act. ["BR"] Example: TRTA and myPay have their own EINs but are considered part of Thomson Reuters for purposes of the Affordable Care Act. |
dbo.Form_1094c_Aggregate_Group_Member |
A client in the database that is associated with an aggregrate group for Affordable Care Act purposes. |
dbo.Form_1094c_Aggregate_Group_Member_Outside_Database |
Aggregate group members who are not stored as a client in the database |
dbo.Form_1095_Corrected_Type |
This table stores the valid values for corrected types of ACA 1095 forms. |
dbo.Form_1095_Coverage_Code |
This table stores the 1095 coverage code selections. |
dbo.Form_1095_Coverage_Code__Individual_Months |
This table stores the 1095 coverage codes that are valid for individual months. |
dbo.Form_1095_Safe_Harbor_Code |
This table stores the 1095 safe harbor code selections. |
dbo.Form_1095_User_Preference |
This table form 1095 user preferences. |
dbo.Form_1096_Client_Copy_Type |
Table to identify the copy type used when printing the client copy for the 1096. |
dbo.Form_1098_C_Option |
This table stores the detailed options for 1098 C form. |
dbo.Form_1098_E_Option |
This table stores the detailed options for 1098 E form. |
dbo.Form_1098_Option |
This table stores the detailed options for 1098 form. |
dbo.Form_1098_T_Option |
Table for 1098-T form specific data |
dbo.Form_1099 |
The parent table for the print options of all the myriad 1099 forms. Each of the forms have a unique set of options so this parent table provides a common foreign key that all schema referencing 1099 print options can use. |
dbo.Form_1099_A_Option |
Detailed options for 1099-A form |
dbo.Form_1099_B_Box_1F_Code |
Form 1099 B Box 1F codes. |
dbo.Form_1099_B_Form_8949_Code |
Form 1099 B 8949 codes. |
dbo.Form_1099_B_Option |
Detailed options for 1099-B form. |
dbo.Form_1099_C_Event_Code |
Table for identifiable event code options for the 1099-C |
dbo.Form_1099_C_Option |
Table for 1099-C form specific data |
dbo.Form_1099_Copy_A_Client_Copy_Type |
Table to identify the copy type used when printing the client copy for the 1099 Copy A. |
dbo.Form_1099_Correction_Type |
This table stores the 1099 correction types. |
dbo.Form_1099_Div_Option |
Detailed options for 1099-Div form |
dbo.Form_1099_G_Option |
Detailed options for 1099-G form |
dbo.Form_1099_Int_Option |
Detailed options for 1099-INT form |
dbo.Form_1099_Misc_Option |
The specific options for printing a 1099 MISC form. |
dbo.Form_1099_Nec_Option |
The specific options related to a 1099 NEC form. |
dbo.Form_1099_Oid_Option |
Detailed options for 1099-OID form |
dbo.Form_1099_Original_Efile_Transmission_Information |
Table that holds the values of previous e-file transmission information for relevant 1099 recepients. In a chain of of three or more filings (for two or more rounds of correction) this holds data about the most recent version being corrected. |
dbo.Form_1099_Override_Type |
This table stores the 1099 form override types. |
dbo.Form_1099_Patr_Option |
Detailed options for 1099-PATR form |
dbo.Form_1099_Print_Threshold_Override |
This table contains the valid 1099 box combinations available for use on bank transactions for a particular vendor. |
dbo.Form_1099_R_Distribution_Code |
Distribution codes for the 1099-R form, box 7 |
dbo.Form_1099_R_Distribution_Code_Map |
Ties first distribution codes to the potential options for second distribution code |
dbo.Form_1099_R_Option |
Detailed options for 1099-R form |
dbo.Form_1099_S_Option |
Detailed options for 1099-S form |
dbo.Form_1099_Sa_Distribution_Code |
Distribution codes for the 1099-Sa form, box 3 |
dbo.Form_1099_Sa_Option |
Detailed options for 1099-SA form |
dbo.Form_5498_Fmv_Code |
Form 5498 fair market value (FMV) codes. |
dbo.Form_5498_Option |
Detailed options for 5498 form |
dbo.Form_5498_Other_Contribution_Code |
Table for the other contribution codes for the 5498 |
dbo.Form_5498_Repayment_Code |
Table for the repayment codes for the 5498 |
dbo.Form_5498_Sa_Option |
The specific options for printing a 5498 SA form. |
dbo.Form_7200_Payment_Requested |
This table stores the payments requested (possibly multiple payments per quarter) by means of filing form 7200 during any valid period. Form 7200 was introduced related to the advance payment for COVID-19 relief. |
dbo.Form_Processing_Run |
This table holds the data for each form processing run. |
dbo.Form_Processing_Run_Form_Count |
This table holds the data needed for recreating, modifying, and creating new fees based on historical data. |
dbo.Form_W2G_Option |
Table to set various options on the W-2G form. |
dbo.Form_W2G_Wager_Type |
Table to identify the various types of wagers for use by the W-2G. |
dbo.Fund_Payroll_Transaction_Type |
The type of payroll transaction funding to be performed. Payroll funding can be done on the entire transaction, or the direct deposit or net check portion only. |
dbo.Funded_Transaction_Type |
Table holds values for the types of transactions that can be funded. |
dbo.Funding_Processed_Status |
Type table for funding processed status. |
dbo.Funding_Processed_Status_Filter_Type |
|
dbo.Funding_Withdrawal_Bank_Transaction_Detail |
|
dbo.Funding_Withdrawal_Liability_Detail |
|
dbo.GL_Account |
|
dbo.GL_Account_Budget |
This table records the budget and its amount for a gl_account in a gl_period |
dbo.GL_Account_Budget_Category |
This table stores type definition to Budget Buckets |
dbo.GL_Account_Budget_Category_Name_Override |
This table records the override name for client budget buckets |
dbo.GL_Account_Classification_N_GL_Account_Grouping_Code |
Dictionary table for connecting GL_Account_Grouping_Subcode to GL account grouping code for mapping. |
dbo.GL_Account_Classification_N_GL_Account_Grouping_Code_Subcode |
Dictionary table for connecting GL account to GL account grouping subcode through the code dictionary table for subcodes that are not Account Classification subcodes. |
dbo.GL_Account_Classification_N_Tax_Code |
Connects a gl account grouping subcode to the tax code |
dbo.GL_Account_Classification_N_Tax_Code_M3 |
Connects a gl account classification subcode to an M3-A tax code. |
dbo.GL_Account_Csa_Account_Number |
This table stores the csa account number for a gl account. |
dbo.GL_Account_Grouping |
Complete set of Account Groupings for a client and global |
dbo.GL_Account_Grouping_Category |
This table is used To allow categories to be assigned to account grouping codes |
dbo.GL_Account_Grouping_Code |
Complete set of Account Groupings Codes/Classes for a client and global |
dbo.GL_Account_Grouping_Code_Type |
Extension of the GL_Account_Grouping_Code table to hold the Type for the standard classification codes and the default codes for each Type |
dbo.GL_Account_Grouping_Csa_Description |
This table stores the csa description for a gl account grouping. |
dbo.GL_Account_Grouping_Subcode |
Complete set of Account Groupings Subcodes/subclasses for a client and global |
dbo.GL_Account_Hierarchy_Type |
The type table used to differentiate the different GL account hierarchies supported via the GL_Account_Parent table. Currently there are two types: Core account and User defined. The Core Account hierarchy will associate a core account number with its posting account numbers. This information will be system maintained based on the user's selected core account segment and the account numbers entered into the Chart. The User-defined hierarchy will be maintained by the user and will represent whatever concept they wish it too (thus the name user-defined!). Both hierarchies are limited to one generation. That is, a parent can't be a child and a child can't be a parent. |
dbo.GL_Account_N_GL_Account_Grouping_Code |
Dictionary table for connecting GL account to GL account grouping code for codes that are not Account Classification codes. |
dbo.GL_Account_N_GL_Account_Grouping_Code_Subcode |
Dictionary table for connecting GL account to GL account grouping subcode through the code dictionary table for subcodes that are not Account Classification subcodes. |
dbo.GL_Account_N_GL_Account_Segment_Code |
|
dbo.GL_Account_Parent |
The parent child relationships of the GL Account table. |
dbo.GL_Account_Segment |
|
dbo.GL_Account_Segment_Code |
|
dbo.GL_Account_Segment_Code_N_Quick_Books_Class |
This table shows the export mapping of gl account segment codes to quick books classes. A gl account segment code key is used only once in the mapping per client, so this can be the primary key. The quick books class key can be used one or more times in the mapping. |
dbo.GL_Account_Segment_Code_Rounding_Account |
Table to hold different type of account keys we will use for rounding on the financial statement, Report and Trial balance grid. |
dbo.GL_Account_Segment_Csa_Description |
This table stores the csa description for a gl account segment. |
dbo.GL_Account_Standard_Segment |
|
dbo.GL_Account_Tickmark |
This table contains the connection between a GL account and a tickmark. |
dbo.GL_Account_Type |
|
dbo.GL_Account_Workpaper_Reference |
This table contains the connection between a GL account and workpaper reference. |
dbo.GL_Accounting_Method |
|
dbo.GL_Balance_Calculation_Method |
Journal Entry Template Source Account Calculation Types - enumerates the supported summation methods for calculating the source amount |
dbo.GL_Balance_Effect |
This table stores type definition for the balances. |
dbo.GL_Balancing_Entry |
This table stores the balancing entry for one or more bank transactions. In the land of GL, bank transactions are created as unbalanced journal entries until such time as the user chooses to balance them. Balancing entails creating a GL balancing entry row that sums to the total of the selected bank transactions. These bank transaction must always belong to the same checkbook and said checkbook's GL account number is used to create a journal entry that balances the selected unbalanced bank transactions. |
dbo.GL_Balancing_Entry_N_Bank_Transaction |
This dictionary table links a GL balancing entry with the one or more bank transactions that the entry balances. |
dbo.GL_Balancing_Entry_Type |
This table enumerates the different types of balancing journal entries that can be created in the system. |
dbo.GL_Fiscal_Year |
|
dbo.GL_Period |
|
dbo.GL_Period_Key_Old_To_New_Map |
This is a staging table used only for remapping GL period foreign keys for a particular client. After the foreign keys are remapped, the rows in this map table are removed. |
dbo.GL_Period_Type |
|
dbo.GL_Transaction |
This table contains all additional GL transaction specific details that the originating source transaction (bank transaction, payable transaction, journal entry transaction, etc) does not contain. |
dbo.GL_Transaction_N_Bank_Transaction |
This dictionary table associates a bank transaction with its associated GL transaction specific detail. |
dbo.GL_Transaction_N_GL_Balancing_Entry |
This dictionary table associates a balancing entry transaction with its associated GL transaction specific detail.. |
dbo.GL_Transaction_N_Journal_Entry |
This dictionary table associates a jouranl entry transaction with its associated GL transaction. |
dbo.GL_Transaction_N_Payable_Transaction |
Table for linking the gl transaction table to payable transaction table. |
dbo.GL_Transaction_Note |
|
dbo.GL_Transaction_Type |
This table gathers together all the transaction types supported by the application. These type values are also stored in several separate type tables (Bank_Transaction_Type, Journal_Entry_Type, etc). |
dbo.Garnishment_Order |
Contains the garnishment information order(s) for each valid garnishment type employee payroll item. |
dbo.Garnishment_Type |
|
dbo.Gender_Type |
|
dbo.Global_Report_Profile |
This table holds the primary key, description and report profile type of every global report profile. |
dbo.Global_Report_Profile_Element |
This table will contain an entry for each report contained within a report profile. Each entry will have a key to link to a report definition, and a report option xml file. Together, the report definition xml and the report option xml describe how to print a report. |
dbo.Global_Report_Profile_N_Report_Profile |
This table will have an entry for every report profile which has been overridden for a particular client. If there are not cient-specific overrides for a profile, then that profile will have no entries in this table. |
dbo.Graduated_Payroll_Item_Tier |
|
dbo.Grid_Account_Selection_Type |
This table will hold values for the custom excel grid account selection type |
dbo.Health_Plan_Type |
Types of health plans available for payroll items. |
dbo.Holiday_Definition |
|
dbo.Holiday_Definition_Default |
|
dbo.Hot_Key |
This table will be used to keep track of the hot keys for the system |
dbo.Import_Method |
This table enumerates the different types of import methods that may be available when we import data. The import method tells us more about from where we are physically retrieving the data. |
dbo.Import_Source |
This table enumerates the different types of import sources that are available when we import data. Examples of import sources: Client Bookkeeping Solution, and QuickBooks. |
dbo.Import_Template |
Parent record for user-defined Import Templates. |
dbo.Import_Template_Column |
Parent record for user-defined Import Templates. |
dbo.Import_Template_Column_1095C_Data |
|
dbo.Import_Template_Column_AR_Item_Data |
Specifies information about user defined template columns for spreadsheet import of invoice items. Only import template column rows of type Discount, Other Charge, Shipping, Sales Tax will have an associated rows in this table. |
dbo.Import_Template_Column_AR_Transaction_Item_Data |
Specifies information about user defined template columns for spreadsheet import of AR Transactions invoice items. Only import template column rows of type Item, Shipping will have an associated rows in this table. |
dbo.Import_Template_Column_Check_Number_Data |
This table stores information about the user-defined template coulumns that are imported for each check |
dbo.Import_Template_Column_Customer_Data |
This table stores information of user defined template columns for spreadsheet import of customer. |
dbo.Import_Template_Column_Employee_Data |
This table stores info for employees excel import grid headers |
dbo.Import_Template_Column_GL_Account_Data |
This table stores info for chart of accounts excel import grid headers |
dbo.Import_Template_Column_Payroll_Item_Data |
List of payroll items(deductions and pay item) and their types associated with a template column. |
dbo.Import_Template_Column_Tax_Item_Data |
List of tax items and their types associated with a template column. |
dbo.Import_Template_Column_Type |
Lists the types of column data available for importing. |
dbo.Import_Template_Column_Vendor_Data |
This table stores information of user defined template columns for spreadsheet import of Vendor. |
dbo.Import_Template_Type |
Lists the types of data available for importing. |
dbo.Import_User_Preference |
This table stores the import user preferences on a per staff member basis. |
dbo.Impound_Payment_Client_Bank_Transaction_Detail |
|
dbo.Impound_Profile |
Firm level profiles assignable to clients that enforce how early payroll processes need to be run. |
dbo.Initial_Open_Item_Bank_Transaction |
This table holds additional information needed only by an Initial Open Item bank transaction. |
dbo.Insurepay_Accruable_Benefit_Type |
Table containing InsurePay accruable benefit types. |
dbo.Insurepay_Client |
Table containing client specific InsurePay consent information. |
dbo.Insurepay_Client_Class_Code |
Table containing InsurePay client specific class code. |
dbo.Insurepay_Client_Class_Code_N_Client_Benefit |
Table is a dictionary table for insurepay_client_class_code_KEY and client_benefit_KEY. |
dbo.Insurepay_Client_Class_Code_N_Client_Payroll_Item |
Table is a dictionary table for insurepay_client_class_code_KEY and client_payroll_item_KEY. |
dbo.Insurepay_Client_Class_Code_N_Employee_Payroll_Item |
Table is a dictionary table for insurepay_client_class_code_KEY and employee_payroll_item_KEY |
dbo.Insurepay_Employer_Contribution_Type |
Table containing InsurePay employer contribution types. |
dbo.Insurepay_N_Payroll_Bank_Transaction |
A dictionary table to map Insurepay_Payroll_Transmission and Payroll_Bank_Transaction, so that each check item in the payroll file will have an entry here. |
dbo.Insurepay_Pay_Item_Type |
Table containing Insurepay pay item types. |
dbo.Insurepay_Payroll_Transmission |
Table containing client specific InsurePay payroll file information. |
dbo.Insurepay_Payroll_Transmission_Result |
Table containing client specific InsurePay payroll transmission result information. |
dbo.Insurepay_Setup_Transmission |
Table containing client specific InsurePay setup information. |
dbo.Insurepay_Setup_Transmission_Result |
Table containing client specific InsurePay setup transmission result information. |
dbo.Invoice_Printing_Default_Option |
|
dbo.Journal |
|
dbo.Journal_Entry |
Table for journal entries |
dbo.Journal_Entry_Distribution |
Table for journal entry distributions |
dbo.Journal_Entry_Event |
Table for journal entry events. |
dbo.Journal_Entry_Event_Type |
Table containing journal entry event types. |
dbo.Journal_Entry_Misstatement_Type |
Journal Entry Misstatement Types - enumerates the supported types of misstatments for journal entries |
dbo.Journal_Entry_Reversal |
This table stores links between an journal entry that has been reversed and its journal entry reversal. |
dbo.Journal_Entry_Template |
Contains Journal Entry specific template information. |
dbo.Journal_Entry_Template_Automatic_Percentage_Distribution |
Journal_Entry_Template_Automatic_Percentage_Distribution - allocates a percentage of the source amount to a gl account. |
dbo.Journal_Entry_Template_Automatic_Percentage_Source_Account |
Journal_Entry_Template_Automatic_Percentage_Source_Account - source account information used in the calculation for automatic percentage journal entries. |
dbo.Journal_Entry_Type |
Journal Entry type table. |
dbo.Journal_Filter_Value_Type |
This table defines all of our journal filter types for use in the journal filter dropdown. |
dbo.Journal_N_Checkbook |
Table linking the Journal and Checkbook tables |
dbo.Known_Application_Extension |
This table contains the known application extensions (i.e. excel has xls and xlsx, word as doc and docx, etc...). |
dbo.Known_Application_Type |
This table contains the known application types (i.e. excel, word, etc...). |
dbo.Lacerte_Tax_Code_Map_To_Acs_Tax_Code |
Lists the different types of Lacerte codes. |
dbo.Ledger_Entry |
|
dbo.Ledger_Entry_Type |
|
dbo.Length_Of_Service_Selection |
|
dbo.License |
Contains information about the firm's current licenses. Client Access products can't see license files but sometimes need to know which licenses exist. This was created to support ACS Client Acces PR Only. |
dbo.Limit_Calculation_Type |
|
dbo.Limit_Period_Type |
This tables holds the limit periods. |
dbo.Local_Tax_Exemption |
|
dbo.Local_Tax_Exemption_Type |
This table contains the list of local taxes defined in the Tax_Code_Type table. Is it used to determine tax exemptions. |
dbo.Location |
|
dbo.Location_Search_Accuracy_Type |
This table holds the values specifying a location search accuracy. |
dbo.Login_Ticket |
Single-use login tickets which can be used in lieu of a password for authentication. |
dbo.Magnetic_Media_Client_Record |
|
dbo.Magnetic_Media_File |
|
dbo.Magnetic_Media_File_Client |
|
dbo.Magnetic_Media_File_Client_Type |
Table to store the various types of Magnetic Media Clients that can exist in a magnetic media file |
dbo.Magnetic_Media_File_N_Tax_Agent |
Table a link between magnetic media files and tax agents. |
dbo.Magnetic_Media_File_Record |
|
dbo.Magnetic_Media_File_Status |
|
dbo.Manage_AP_Payment_Grid_Column |
This tables records are only added during schema updates. It contains records that corresponds to columns in the Mange AP Payment Options. |
dbo.Manage_AP_Payment_Grid_User_Option |
This table holds preferences, per user, per client, on which columns are shown in the Manage AP Payment grid. |
dbo.Manage_AP_Payment_Option |
This table holds preferences per client for Manage AP Payments. |
dbo.Manage_AP_Payment_Processable_Transaction |
reasons for the Manage_AP_Payment_Processable_Transaction table It has been recommended that the best way to provide a data source for the Manage AP Payments rapid tab grid is with a special database table which will exist only for the purpose of feeding the datasource to the grid, and to facilitate filtering in our system. Such a table is sometimes called a ?temporary? table. It is permanently in the database, but holds data only temporarily, while the Manage Payments view is displayed. This table holds a combination of payment and payable transactions for a given client. The payment and payable transactions will each have a gross open balance amount that has not yet been reduced to zero. These transactions will be paired together so that they can be applied, that is, the payable gross amount will be reduced and the payment gross amount will be reduced in tandem. |
dbo.Manage_AP_Payment_User_Preference |
This table holds preferences per user per client for Manage AP Payments. |
dbo.Manage_Customer_Payment |
This table holds temporary data that only exists as long as the current user session exists. This table also has a DAL bypass to aid in the performance of high row count inserts. No DAL constraints should be added to this table. WARNING - if this table is modified, use-defined table type dbo.Manage_Customer_Payment_Rows and stored procedure dbo.pb_Insert_Manage_Customer_Payment_Rows also need to be updated to maintain identical structure |
dbo.Manual_Funding_Bank_Transaction |
Holds manual funding transaction data - used to created bank transactions when manual funding is processed. |
dbo.Manual_Funding_Bank_Transaction_N_Ach_Entry_Detail_Record |
Maps manual funding bank transaction records to the ACH entry detail record associated with that transaction - for firm vendor funding |
dbo.Marital_Status_Type |
|
dbo.Micr_Line_Format |
The table used to store the different types of MICR line format options. |
dbo.Minimum_Wage |
|
dbo.Minimum_Wage_Payroll_Check_Treatment |
Type table which defines the actions to take if minimum wage is not met when saving a check. |
dbo.Month_Information |
Table to identify Month information |
dbo.Multiple_Garnishment_Calculation_Method |
|
dbo.Negative_Payroll_Check_Treatment |
Type table which defines the actions to take if a negative check is found when saving a check. |
dbo.Netclient_File_Log |
|
dbo.Netclient_Time_Entry_Option |
This tables purpose is to store client-level options used by the NetClient portal. |
dbo.Non_Posting_Payroll_Transaction_GL_Period |
Payroll transactions will not post for periods stored in this table. When the client selects an effective period, if the post_payroll_transactions is set to true, every gl period from the effective period and beyond will be removed from this table. When the flag is set to false, every period from the effective period through the latest fiscal year will be added to this table. When new fiscal years are created the post_payroll_transactions flag will be used to determine whether or not to add the gl periods of the new fiscal year to this table. Payroll transactions with posting periods that are present in this table will not post to the general ledger. |
dbo.Notification_Category_Type |
This table stores identifiers for the different scenario categories. |
dbo.Notification_Generalized_Type |
This table stores identifiers for the different types of general scenarios that result in notifications. This combined with a notification category identifies a specific scenario. e.g Check SSN validation vs. Employee SSN validation |
dbo.Notification_Queue |
This table stores data for notifications that need to be processed by Cron tasks. |
dbo.Notification_Queue_Record_Lock |
This table locks records in parent table Notification_Queue, where a lock record indicates a queue record is being processed by a Cron task. |
dbo.Notification_Status |
This table stores status options to indicate whether a Cron task has handled a record yet. |
dbo.Notification_Type |
This table stores identifiers for the different types of specific scenarios that result in notifications. e.g Check SSN validation vs. Employee SSN validation. |
dbo.Numeric_GL_Account_Number_Metrics |
This table contains metrics calculated across a client's Chart of Accounts. It's used by the GL_Account_Sort_View to build a padded string that can be used to sort the chart such that numeric account numbers (all digits with at most one decimal point) will appear to sort numerically (ex. 10, 20, 100) instead of alphanumerically (10, 100, 20). |
dbo.Office |
|
dbo.Ohio_Jedd_Tax |
A table used to store an Ohio JEDD Tax code and description to be applied in place of local taxes.["BR"] JEDD stands for Joint Economic Development District. Multiple townships, cities or villages can enter["BR"] into a JEDD agreement to jointly collect income tax. |
dbo.OnBalance_Bank_Account |
Table to store the mapping data information of bank accounts for OnBalance |
dbo.OnBalance_GL_Account |
Table to store the mapping data information of chart of accounts for OnBalance. |
dbo.OnBalance_Import_Option |
This table contains the data entry import options to configure the OnBalance Import feature. |
dbo.Online_Bill_Pay_Bank_Transaction |
This table holds Online Bill Pay specific data for a given Bank Transaction. |
dbo.Online_Bill_Pay_Transmission_Status |
This table holds the values specifying the transmission statuses for Online Bill Pay. |
dbo.Onvio_Client_List |
This ephemeral table exists to satisfy a quirk of the SearchTextBox, which is that it insists on having the ability to query the database to handle how it does things like type-ahead, etc. |
dbo.Onvio_Documents_Display_Dialog |
This table pairs a Document_Management_System_Print_Category (as defined by the DMS_Print_Category table) to a boolean value["BR"] for displaying a dialog when printing that category and to a boolean value["BR"] for including document date year property on parent level folder when printing that category. Not changing the historical name of table, just added the required column. |
dbo.Onvio_Documents_Mapping |
This table pairs a Document_Management_System_Print_Category (as defined by the DMS_Print_Category table) and Folder Level to values for["BR"] value type, and actual folder value |
dbo.Onvio_Payroll_Integration_Action |
This table stores action type to indicate which action should run. |
dbo.Onvio_Payroll_Integration_Data_Type |
The data type the operations is run for (client, employee, etc). |
dbo.Onvio_Payroll_Integration_Queue |
This table stores data for Onvio Payroll Integration that need to be processed by Cron tasks. |
dbo.Onvio_Payroll_Integration_Status |
This is the union of all statuses (for client, employee, pay schedule, contact, etc.) that an operation may have with regard to Onvio. Each such table using these statuses should both foreign key into this table as well as check constraint to ensure they only record status for which they are prepared to handle. |
dbo.Overpayment_Handling_Option |
|
dbo.PPC_Smart_Engagement |
This table is used for PPC SMART integration. A binder that is linked with SMART engagement will store the linking information in this table. |
dbo.PPC_Workpaper |
This table stores document information of a PPC Checkpoint Tools documents. WorkpaperCS can integration with PPCs Checkpoint Tools by allowing users to add PPC Checkpoint Tools document into WorkpaperCS. Information stored in this table come from Custom Properties of PPC Checkpoint tools Excel or Word documents. |
dbo.Pay_Frequency |
|
dbo.Pay_Item |
Client payroll item properties applicable only to a pay payroll item. |
dbo.Pay_Item_Exclusion_Detail |
Table used to store selected payroll items exclusions. |
dbo.Payable_Payment_Application |
This table holds records that are Applications of Payments to Payables. |
dbo.Payable_Payment_Application_Payable_Distribution |
This table holds distributions for Payable_Payment_Application records. |
dbo.Payable_Payment_Application_Payment_Distribution |
This table holds distributions for Payable_Payment_Application records. |
dbo.Payable_Transaction |
|
dbo.Payable_Transaction_Distribution |
A Payables amount is distributed among one or more liablity accounts. This collection of liabilities is called distributions which is what this table contains. |
dbo.Payable_Transaction_N_Ach_Entry_Detail_Record |
Maps payable transactions to the ACH entry detail record associated with that transaction - for firm vendor funding |
dbo.Payable_Transaction_N_Elf_File |
Maps the payable transaction to the electronic filing (ELF) file that paid it. |
dbo.Payable_Transaction_N_Magnetic_Media_File_Client |
Maps the payable transaction to the magnetic media file client that paid it. |
dbo.Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item |
This dictionary table associates payable transaction worker compensation items with the liabilities created from them. |
dbo.Payable_Transaction_N_Payroll_Check_Payroll_Item |
This dictionary table associates payroll check payroll items with the liabilities created from them. |
dbo.Payable_Transaction_N_Payroll_Check_Tax_Item |
This dictionary table associates payroll check tax items with the liabilities created from them. |
dbo.Payable_Transaction_N_Receivable_Transaction |
This dictionary table links related payables and receivables. The payables and receivables don not necessaryily have to belong to the same client. For example, in SBPR, the fees and billing cycle will generate receivables for the firm and related payables for the client which are linked together via an entry in this table. |
dbo.Payable_Transaction_N_Shortfall_Transaction |
This dictionary table associates a payable transaction with the shortfall transaction for which it was created. |
dbo.Payable_Transaction_Template |
This table is used to store information about a transaction template that can be used to generate a payable transaction. |
dbo.Payable_Transaction_Template_Distribution |
A table used to describe one of the possibly multiple distributions that make up a payable transaction template. |
dbo.Payable_Transaction_Type |
The table enumerates the different types of payable transactions. |
dbo.Payment_Term |
This table contains the fields required for the Payment Term screen. |
dbo.Payment_Term_Basis |
Type table that will have payment bases that will determine the payment discount date or due date. |
dbo.Payment_Term_Discount_Method |
Type table which will have discount types that determine how payments will be discounted. |
dbo.Payroll_Agent_Payment_Method_Lead_Days |
This table is used by the manage impound payments workitem for use with payroll agents. It contains information used in conjunction with a filter to select processing days for payments based on payment method, the due date and the number of lead days. The filter system will calculate the processing date by due date minus the number of lead days for the payment method type. This table is at the firm level and is shared by all clients. There are a fixed number of rows as the payment method types are static, but the table is not read only since the number of lead days can be modified. |
dbo.Payroll_Bank_Transaction |
Bank_Transaction records that correspond to Payroll Checks have a record here to link to the Employee and record the Pay Period. Payroll_Bank_Transaction_View exists to limit the columns returned by a read which fails to specify a DropAllBut(). |
dbo.Payroll_Bank_Transaction_N_Client_Pay_Schedule_Detail |
This dictionary table associates a payroll bank transaction record with a client pay schedule detail record. |
dbo.Payroll_Bank_Transaction_Worker_Compensation_Item |
|
dbo.Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution |
Holds the distribution of payroll bank transaction worker compensation items across multiple work locations |
dbo.Payroll_Check_Benefit_Item_Import |
Table used to import employee benefits related to a single check. |
dbo.Payroll_Check_Entry_Option |
This table contains the data entry options to configure the batch check entry grid. |
dbo.Payroll_Check_Entry_Option_Payroll_Item_Definition |
This table contains the data entry column definitions to configure the batch check entry grid. |
dbo.Payroll_Check_Entry_Option_Payroll_Item_Exclusion |
Specifies the client payroll items to be excluded from a pay schedule. This table contains rows for excluded payroll items for which the selection scope set to "Selected" |
dbo.Payroll_Check_Entry_Option_Shortfall_Deduction_Treatment |
This table contains the client deduction items used to reduce a negative check. |
dbo.Payroll_Check_Entry_Option_Shortfall_Tax_Treatment |
This table contains the client tax items used to reduce a negative check. |
dbo.Payroll_Check_Number_Import |
List of check numbers associated with a template column. This table will hold check numbers for imported payroll checks prior to check creation |
dbo.Payroll_Check_Payroll_Item |
|
dbo.Payroll_Check_Payroll_Item_Distribution |
|
dbo.Payroll_Check_Payroll_Item_Distribution_Child_Support_Detail |
|
dbo.Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail |
Details of creditor garnishment orders for payroll check payroll item distributions |
dbo.Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail |
Contains garnishment detail information for each payroll check distribution record. |
dbo.Payroll_Check_Payroll_Item_Import |
|
dbo.Payroll_Check_Printing_Primary_Sort_By_Type |
|
dbo.Payroll_Check_Sales_Amount_Distribution |
Table to hold sales amount distributions for payroll checks. |
dbo.Payroll_Check_Sales_Amount_Import |
This table will hold imported sales amounts prior to check creation. |
dbo.Payroll_Check_Tax_Item |
|
dbo.Payroll_Check_Tax_Item_Distribution |
|
dbo.Payroll_Check_Tax_Item_Import |
List of imported tax items associated with a template column. |
dbo.Payroll_Consolidation_Group |
Payroll consolidation involves selecting a set of clients whose data will be combined["BR"] in order to produce a single tax form with the combined amounts. Each consolidated group has a primary client["BR"] and any number of secondary clients. Tax processing calculations combine data across multiple clients when["BR"] producing tax forms. |
dbo.Payroll_Consolidation_Group_Member |
Defines which payroll consolidation group a client might belong to as well as["BR"] the client's sequence number in the group. These are all secondary clients in the group. |
dbo.Payroll_Department |
|
dbo.Payroll_Item_Calculation_Type |
|
dbo.Payroll_Item_Calculation_Type_Qualifier |
Type table which defines the payroll item calculation type for payroll check entry options. |
dbo.Payroll_Item_Special_Timing |
Table that holds how a payroll items special timing is handled. |
dbo.Payroll_Item_Special_Timing_Date_Basis |
Table to identify which date to base the payroll special timing on. |
dbo.Payroll_Item_Special_Timing_Frequency |
Table to identify the frequency for a special timing payroll item. |
dbo.Payroll_Item_Special_Timing_Selected_Payroll_Period_Basis |
Table to identify the period basis for a payroll special timing frequency of selected payrolls. |
dbo.Payroll_Item_Special_Type |
Table used to store payroll item special types. |
dbo.Payroll_Item_Type |
|
dbo.Payroll_Item_Worker_Compensation_Exemption |
|
dbo.Payroll_Item_Worker_Compensation_Exemption_Detail |
|
dbo.Payroll_Journal_Entry_Option |
Table to hold information specified in the Payroll Journal Entry Options Dialog |
dbo.Payroll_Journal_Entry_Option_Date_Type |
Type table describing the date types of the Payroll_Journal_Entry_Option table |
dbo.Payroll_Tax_Forms_Filed_By_Type |
The table used to store the payroll tax forms filed by type options. |
dbo.Payroll_Tracking_Portlet_Column_Screen_Option |
This table holds the customized order and visibility of columns on payroll tracking tab grid and links to the user interface grid columns and client custom fields. |
dbo.Pending_AP_Payment |
This table holds pending payments. A pending payment can be paired with an existing payable, so that the payable can be paid. What this means here is that the pending payment would be turned into a real payment, and then applied against a payable. |
dbo.Pending_AP_Payment_Application |
This table holds pending applications. A pending application is the pairing of one existing payable and one existing payment, or one existing payable and one pending payment. It can be used to create a real (no longer pending) application of payment to payable. |
dbo.Pod_Service_W2_Queue |
A row in this table corresponds to a UT W2 pod file queued for transmission |
dbo.Portlet_Type |
|
dbo.Positive_Pay_File |
This table tracks each positive pay export file created by our program. |
dbo.Positive_Pay_File_Detail |
This table associates a given positive pay file with all the bank transactions that exported in the file. |
dbo.Practice_User |
|
dbo.Preloaded_Payroll_Check_Entry_Batch |
This table stores preloaded payroll check entry batches. Batched will be calculated overnight and removed when the batch is submitted or a change in the system invalidates the stored data. |
dbo.Print_1095 |
This table holds information for a form 1095 print run. |
dbo.Print_1095_Selection |
This table holds selection information for a form 1095 print run. |
dbo.Print_1096_Selection |
This table is used by tax processing code to drive 1096 form printing. |
dbo.Print_1099 |
This table is used by tax processing code to drive 1099 and 1096 form printing. It determines which user is printing, what year they are printing for, and which 1099 type they are printing. |
dbo.Print_1099_Selection |
This ephemeral table is used by tax processing code to drive 1099 and 1096 form printing. It determines each form's account number. Updates to schema for this table typically must be paralleled in table Recipient_1099_Override but accept NULL there. |
dbo.Print_AR_Transaction_Selection |
This is a locking table that ensures an AR Transaction added to it is not being printed by more than one user at a time. |
dbo.Print_Check_Selection |
|
dbo.Print_Customer_Statement_Selection |
This table is used drive AR Statement printing. It determines which user is printing, which customers are being printed and the dates required by the report variables. |
dbo.Print_Destination_User_Preference |
Store user preferences for print destinations and use them to populate various Print Options views. |
dbo.Print_Filing_Instruction |
Stores the filing instruction for a particular federal/state/local collation item for a particular processing period. |
dbo.Print_Job |
This table contains an entry for each job submitted to the check/invoice/form printing engine. This table's primary key is used to uniquely identify a given print job. |
dbo.Print_Job_Subtype |
Table to store the sub output types for printers |
dbo.Print_Job_Type |
Table to store the output types for printers |
dbo.Print_Payable_Transaction_Selection |
Lock payable transactions during printing (similar to table Print_Check_Selection, which locks bank transactions during printing). |
dbo.Print_Receivable_Transaction_Detail_Selection |
This table stores locks for receivable transaction detail records (aka fees) tied to invoices that are printing so that other users may not print them. |
dbo.Print_Report_Selection |
|
dbo.Print_W2 |
This table is used by tax processing code to drive W2 and W3 form printing. It determines which user is printing and what year they are printing for. |
dbo.Print_W2_Selection |
This table is used by tax processing code to drive W2 and W3 form printing. It determines each form's control number as well as which box 12 codes, which states, and which localities ton include on a form. |
dbo.Print_W3_Selection |
This table is used by tax processing code to drive W3 form printing. It determines each form's control number as well as which box 12 codes, which states, and which localities ton include on a form. |
dbo.Printer_User_Preference |
Table to store the users preferences for printers |
dbo.Printer_User_Preference_By_Subtype |
Table to store the user preferences for printers of print job subtypes. The user preferences for printers of main types like W-2s, Reports, Checks, Invoices, and 1099s are still stored in the Printer_User_Preference table, but any subtypes to these main types, like the W-2 Preprinted W-3, can have a printer that overrides the main printer, and that is what we store in this table. |
dbo.Priority |
This table contains levels of priority. |
dbo.Privilege |
|
dbo.Privilege_Dependency |
|
dbo.Privilege_Description |
This table holds description for Privileges with a database prefix specified in database_prefix. |
dbo.Privilege_Forbidden |
This table contains privileges that will always be denied (even members of the Administrator group). Maintenance of this table is not the responsibility of the applications and changes made won't appear until the next time the application runs. |
dbo.Processed_Direct_Deposit_Fileheader |
Table to hold file header data for processed ACH files. |
dbo.Processed_Tax_Form |
Any tax forms in this table have been processed. Tax forms are considered processed when they have been printed or magnetic media/internet files have been created for them. |
dbo.Processed_Tax_Form_Liability |
Any tax forms in this table have had their liability adjustments processed. Liability adjustments are considered processed when the associated form has been processed and no adjustment is required, or the liability adjustment has been written off. |
dbo.Processing_Note |
|
dbo.Processing_Note_Category |
The category of a processing note. Users can add to this list. |
dbo.Processing_Note_Sort_Order |
Determines how processing notes should be sorted in the Client Processing Notes and Process Payroll Tax Forms Notes dialogs. |
dbo.Processing_Note_Type |
The type of processing note. This determines which notes should be shown in different areas of the program. |
dbo.Product_Id |
|
dbo.Quarter |
This table holds the description of quarters. It is used by the user interface and as a foreign key constraint. |
dbo.Quick_Books_Account |
This table stores a quick book account |
dbo.Quick_Books_Account_GL_Account |
This table stores a quick book account gl account data |
dbo.Quick_Books_Account_Integration_Direction |
This table contains what type of data transfer QBO supports. |
dbo.Quick_Books_Account_N_Checkbook |
This table will have an entry for every quickbooks gl account of type Bank that is mapped to an acs checking account. |
dbo.Quick_Books_Class |
This table stores a quick books class and connects it to a gl account code |
dbo.Quick_Books_Export_Option |
This table contains export options used when exporting data to QuickBooks. |
dbo.Quick_Books_Import_Option |
This table contains import options used when importing data from QuickBooks. |
dbo.Quick_Books_Online_Export_Option |
This table is for the Client Quickbooks Online Export Options. |
dbo.Quick_Books_Online_Exported_Journal_Entry |
This table contains returned data for journal entry exported to Quick Books Online. |
dbo.Quick_Books_Online_Import_Option |
This table contains the data entry import options to configure the Quickbooks Online Import feature. |
dbo.Quick_Books_Online_Integration_Client |
A table to store tokens needed to access a client's QuickBooks Online account. The QuickBooks Online ACS identifiers stored in table Quick_Books_Online_Integration are used to get access tokens (Access Token, Access Token Secret) and an identifier (Company ID) for an individual client QBO accounts. These access tokens allow ACS to grab information from a client's QBO account. The Access Token and Access Token Secret expire periodically and need to be refreshed. |
dbo.Quick_Books_Online_Integration_License_Agreement |
this table tells records the staff id and staff name of the staff member that accepted a version of the quickbooks online integration license agreement. Firms that use quickbooks online integration will need a record in this table for the current license agreement and the primary key constant that matches the current license agreement. Firms that do not use quickbooks online integration will not have a record in this table. Updates to the license agreement would result in new records being added to this table with a new primary key constant for the firms using quickbooks online integration, once a staff member accepts the new version of the license agreement. |
dbo.Quick_Books_Payee |
Quick Books Payee |
dbo.Quick_Books_Payee_N_Employee |
This table will have an entry for every quickbooks payee of type employee that is mapped to an acs employee. |
dbo.Quick_Books_Payee_N_Vendor |
This table will have an entry for every quickbooks payee of type vendor that is mapped to an acs vendor. |
dbo.Quick_Books_Payee_Type |
This table stores the valid Quick Books payee types |
dbo.Quick_Books_Payroll_Item |
This table contains information about payroll items that we have imported from quickbooks. |
dbo.Quick_Books_Payroll_Item_N_Client_Payroll_Item |
This dictionary table associates quickbooks payroll items with an associated client payroll item. |
dbo.Quick_Books_Payroll_Item_N_Client_Tax_Item |
This dictionary table associates quickbooks payroll items of type tax with an associated client tax item. |
dbo.Quick_Books_Payroll_Item_Type |
This table stores the valid Quick Books payroll item types |
dbo.Quick_Books_Retrieved_Account |
this table contains information on gl accounts retrieved from quickbooks for a given ACS client, where the gl accounts have not yet been imported into the permanent ACS tables for that client. For quickbooks online, the process of importing data has two steps. First, we retrieve the data from a quickbooks online company, and then we import the retrieved data into the permanent ACS tables. We need a means to store off the information after that first step has completed, but before that second step. This table provides the means for us to store information on accounts that have been retrieved from a quickbooks online company, but not yet imported into the permanent tables in ACS for the client. Once the import completes for one client, the records in this table for that one client will be removed. |
dbo.Quick_Books_Retrieved_Transaction |
This table contains information on transactions retrieved from quickbooks for a given ACS client, where the transactions have not yet been imported into ACS for that client. For quickbooks online, the process of importing data has two steps. First, we retrieve the data from a quickbooks online company, and then we import the retrieved data into the permanent ACS tables. We need a means to store off the information after that first step has completed, but before that second step. This table provides the means for us to store information on transactions that have been retrieved from a quickbooks online company, but not yet imported into the permanent tables in ACS for the client. Once the import completes for one client, the records in this table for that one client will be removed. |
dbo.Quick_Books_Retrieved_Transaction_Distribution |
this table contains information on transaction distributions retrieved from quickbooks for a given ACS client, where the transactions have not yet been imported into the permanent ACS tables for that client. For quickbooks online, the process of importing data has two steps. First, we retrieve the data from a quickbooks online company, and then we import the retrieved data into the permanent ACS tables. We need a means to store off the information after that first step has completed, but before that second step. This table provides the means for us to store information on transaction distributions that have been retrieved from a quickbooks online company, but not yet imported into the permanent tables in ACS for the client. Once the import completes for one client, the records in this table for that one client will be removed. |
dbo.Quick_Books_Retrieved_Vendor |
this table contains information on vendors retrieved from quickbooks for a given ACS client, where the vendors have not yet been imported into the permanent ACS tables for that client. For quickbooks online, the process of importing data has two steps. First, we retrieve the data from a quickbooks online company, and then we import the retrieved data into the permanent ACS tables. We need a means to store off the information after that first step has completed, but before that second step. This table provides the means for us to store information on vendors that have been retrieved from a quickbooks online company, but not yet imported into the permanent tables in ACS for the client. Once the import completes for one client, the records in this table for that one client will be removed. |
dbo.Quick_Books_Transaction |
This table contains information about transactions that we have imported from quickbooks. |
dbo.Quick_Books_Transaction_Distribution |
This table will store the transaction distributions of transactions imported from QuickBooks. |
dbo.Quick_Books_Transaction_N_GL_Transaction |
This dictionary table associates a gl transaction with an associated quickbooks transaction. |
dbo.Quick_Books_Transaction_Type |
This table stores transaction types used in quickbooks. |
dbo.Race_Type |
|
dbo.Rapid_Tab_List_View_Filter |
This table contains the four possible filters for the Rapid tab in the Enter AP Transactions screen. |
dbo.Receivable_Detail_Type |
|
dbo.Receivable_Transaction |
|
dbo.Receivable_Transaction_Detail |
|
dbo.Receivable_Transaction_Fee |
|
dbo.Receivable_Transaction_Fee_Detail |
|
dbo.Receivable_Transaction_Fee_Detail_Type |
|
dbo.Receivable_Transaction_Print_Option |
Holds the most recent print options used when this receivable transaction was last printed. |
dbo.Receivable_Transaction_Print_Override |
The table used to store overrides for unprinted Receivable Transaction during the printing process. |
dbo.Receivable_Transaction_Sales_Tax_Taxable_Item |
The table used to link a sales tax to the related taxable fee. |
dbo.Receivable_Transaction_Type |
|
dbo.Recipient_1099_Override |
The table used to store Recipient 1099 overrides for all 1099 types. The schema for this table should closely match that in Print_1099_Selection but accept NULL to indicate a field that is not overridden and the calculated value should be used. |
dbo.Reconciliation_Tax_Form_Override_Type |
Provide valid employee reconciliation form override monthly overrride amount types from the employee detail view grid |
dbo.Record_Status |
Generic status table that houses the types that define if a given record is active, inactive or virtually deleted. |
dbo.Recorded_Event |
|
dbo.Recorded_Event_Client_Recorded_Event_Object |
Table that links a recorded event with a recorded event object for a client. |
dbo.Recorded_Event_N_Recorded_Event_Object |
Table that links a recorded event with a recorded event object. |
dbo.Recorded_Event_N_Secondary_Recorded_Event_Object |
Links objects to an event that are not the primary event object (meaning the one the event happened to), but were otherwise involved - like employees in a batch of payroll checks. |
dbo.Recorded_Event_Notification |
|
dbo.Recorded_Event_Object |
Table that represents an object tracked by the recorded event system. |
dbo.Recorded_Event_Object_N_Balance_Definition |
Table that links a recorded event object record with an Balance_Definition record. |
dbo.Recorded_Event_Object_N_Bank |
Table that links a recorded event object record with an bank record. |
dbo.Recorded_Event_Object_N_Checkbook |
Table that links a recorded event object record with a checkbook. |
dbo.Recorded_Event_Object_N_Client |
Table that links a recorded event object record with an client record. |
dbo.Recorded_Event_Object_N_Client_Access_Notification |
A link table that links dbo. Recorded_Event_Object table and dbo. Client_Access_Notification table. |
dbo.Recorded_Event_Object_N_Client_Pay_Schedule |
Table used to store references of the event object with the client pay schedule key on which the action is performed. |
dbo.Recorded_Event_Object_N_Employee |
Table that links a recorded event object record with an employee record. |
dbo.Recorded_Event_Object_N_Engagement_Binder |
Table used to store references of the event object with the engagement key on which the action is performed. |
dbo.Recorded_Event_Object_N_GL_Account |
Table that links a recorded event object record with a GL_Account record. |
dbo.Recorded_Event_Object_N_Impound_Profile |
This table stores information that links the recoded event object with the impound profile |
dbo.Recorded_Event_Object_N_Payroll_Department |
Table that links a recorded event object record with a Payroll_Department. |
dbo.Recorded_Event_Object_N_Staff |
Table that links a recorded event object record with an staff record. |
dbo.Recorded_Event_Object_N_Workpaper |
Table used to store references of the event object with the workpaper key on which the action is performed. |
dbo.Recorded_Event_Searchable_Attribute |
Collection of attribute values associated with a Recorded_Event that can be searched on. One event can have many attribute values |
dbo.Recorded_Event_Searchable_Attribute_Type |
Defines the type of data that can be searched on. |
dbo.Recorded_Event_Staff_Recorded_Event_Object |
Table that links a recorded event with a recorded event object for a staff. |
dbo.Report_Definition |
|
dbo.Report_Definition_Application_License_Requirement |
Lists application/license combinations that make CS defined reports available. |
dbo.Report_Definition_Security_Group |
Each record indicates that the report is available to staff who are in the specified security group |
dbo.Report_Definition_Source |
Report layout definition source information. Indicates the origin/status of a layout. |
dbo.Report_Designer_Page_Setup_Default |
This table contains all properties of Page Setup Default dialog box. |
dbo.Report_Folder |
Table that holds system and user-defined folders that house reports/financial statements/letters.["BR"]The last record has 999 for the PK value so we have a reserve int padding for future system defined folders. |
dbo.Report_Folder_Type |
Table that houses the different system folder types that will be used. |
dbo.Report_Image |
|
dbo.Report_Profile |
This table holds the primary key, description and report type of every client report profile. Client report profiles are overrides on a per-client basis of a global report profile. Therefore, this table also holds a client key to tell us for which client this client profile is intended. |
dbo.Report_Profile_Element |
This table will contain an entry for each report contained within a client specific override of a global report profile. Each entry will have a key to link to a report definition, and a report option xml file. Together, the report definition xml and the report option xml describe how to print a report. |
dbo.Report_Profile_Type |
This table contains the different types of report profiles. Profiles of type firm can only hold firm level reports. Profiles of type client can only hold client level reports. |
dbo.Report_Type |
|
dbo.Report_User_Preference |
|
dbo.Reprintable_Bank_Transaction |
This table is the master list of all bank transactions that may be reprinted because they were stored for reprinting during their initial printing. |
dbo.Reprintable_Print_Job |
This table stores data needed to reprint all checks in a print job. |
dbo.STE_Filing_Status_State |
Reverse engineered from no doc 2019-11-01: This table drives the list of allowed values for states. |
dbo.STE_State_Misc_Parameter |
|
dbo.STE_State_Misc_Parameter_Allowed_Value |
Reverse engineered from no doc 2019-11-01: This table drives the list of allowed values for parameters. It did not need a version added as that was driven a layer up. |
dbo.STE_State_Misc_Parameter_Usage |
Reverse engineered from no doc 2019-11-01: This table helps data-driven UI for the Withholding in Employee Self Service, and possibly in ACS. |
dbo.STE_Tax_Dictionary |
This table contains a list of taxes defined by Symmetry. It is used to build items for tax exemptions. |
dbo.Schedule_M3_Tax_Code_Attribute |
This table enumerates an attribute Tax journal entries require for Schedule M-3 Code mapping. |
dbo.Scheduled_Payroll_Change_Initiator |
This table stores various types of Payroll Change Initiators. |
dbo.Scheduled_Payroll_Tracking_Detail |
This table allows the processor(staff) to know which payrolls need to be processed and find the status of a particular client. It also includes the information needed for management reporting. |
dbo.Scheduled_Statistics_Update |
Table containing information about statistics that need recurring updates. |
dbo.Scheduled_Transaction_Instance |
This table stores the information we need to track transactions scheduled to be created from a template. It stores information for transactions already created and for transactions not created yet. |
dbo.Scheduled_Transaction_Interval |
This table stores the time intervals defined by the frequency of the associated template. The intervals are a means to organize scheduled transactions (both those created from the template, and those scheduled but not yet created), and efficiently alter a schedule when a user changes scheduling options after we begin to generate transactions from the template. |
dbo.Schema_Update_Alert |
Schema updates can place alerts in this table that will be displayed to the user when they next log into the database. The alerts will continue to be displayed until the user removes them from the queue. At a minumum, the alert must have a title; the description is optional. |
dbo.Security_Group |
|
dbo.Selection_Scope |
|
dbo.Semimonthly_Period |
This table contains the semimonthly period descriptions. |
dbo.Shortfall_Balance_Payroll_Check_Treatment |
Type table which defines the actions to take to apply gains to a prior shortfall. |
dbo.Shortfall_Deduction_Treatment_Selection |
Table that defines which client deduction items are applicable for shortfall processing |
dbo.Shortfall_Tax_Treatment_Selection |
Table that defines which client tax items are applicable for shortfall processing |
dbo.Shortfall_Tax_Treatment_Type |
Type table which defines the selectable tax types |
dbo.Shortfall_Transaction |
Transactions to track tax and deduction shortfalls from checks and restitution payments. |
dbo.Shortfall_Transaction_N_Client_Payroll_Item |
Dictionary to associate a shortfall transaction to a client payroll item |
dbo.Shortfall_Transaction_N_Client_Tax_Item |
Dictionary to associate a shortfall transaction to a client tax item |
dbo.Shortfall_Transaction_N_Payroll_Check_Payroll_Item |
Dictionary to associate a shortfall transaction to a payroll check payroll item |
dbo.Shortfall_Transaction_N_Payroll_Check_Tax_Item |
Dictionary to associate a shortfall transaction to a payroll check tax item |
dbo.Shortfall_Transaction_Type |
Type table which defines the source of the shortfall transaction |
dbo.Signoff_Role |
This table will be used to keep track of the different roles for a signoff |
dbo.Signoff_Type |
This table will be contain the data representing a signoff type |
dbo.Skipped_Check_Number |
Each record lists a number that we tried to use but for some reason were not able to, and we choose not to return to the pool of available numbers. |
dbo.Skipped_Direct_Deposit_Voucher_Id |
Each record lists a voucher id that we tried to use but for some reason were not able to, and we choose not to return to the pool of available voucher ids. |
dbo.Sort_Order_Type |
|
dbo.Source_Document_Processing_Sort_Order |
this table stores the sort order in the engagement tree for documents that have been through source document processing |
dbo.Source_Document_Processing_Tax_Organizer_Sort_Order |
This table stores the sort order in the engagement tree for tax organizer documents that have been through source document processing. |
dbo.Spreadsheet_Import_1095C_Covered_Individual_Detail |
An enumeration of the 1095-C Part 3 covered individual detail names used for spreadsheet import. |
dbo.Spreadsheet_Import_1095C_Offer_And_Coverage_Box_Name |
An enumeration of the 1095-C Part 2 box names used for spreadsheet import. |
dbo.Spreadsheet_Import_1095C_Offer_And_Coverage_Col_Header_Name |
An enumeration of the 1095-C Part 2 column headers used for spreadsheet import. |
dbo.Spreadsheet_Import_1099_Box_Combination |
Table to store the mapping data information of 1099 forms for spreadsheet import. |
dbo.Spreadsheet_Import_AR_Item |
The purpose of this table is to map shipping items or sales tax items imported via the spreadsheet import process to shipping items or sales tax item already existing in the database. |
dbo.Spreadsheet_Import_AR_Transaction_Item_Selection |
Specifies column options for AR transaction invoice items of type Item. |
dbo.Spreadsheet_Import_AR_Transaction_Shipping_Item_Selection |
Specifies column options for AR transaction invoice items of type Shipping. |
dbo.Spreadsheet_Import_Account |
Table to store the mapping data information of chart of accounts for spreadsheet import. |
dbo.Spreadsheet_Import_Accruable_Benefit_Type |
Table to identify the accruable benefit type used when importing employees |
dbo.Spreadsheet_Import_Bank_Account |
Table to store the mapping data information of bank accounts for spreadsheet import |
dbo.Spreadsheet_Import_Bank_Routing_Number |
Table to store the mapping data information of payment terms for spreadsheet import. |
dbo.Spreadsheet_Import_Customer |
The purpose of this table is to map customers imported via the spreadsheet import process to AR customer�s already existing in the database. |
dbo.Spreadsheet_Import_Deduction_Item_Type |
Table to identify the deduction item type used when importing employees |
dbo.Spreadsheet_Import_Direct_Deposit_Allocation_Type |
Table to identify the direct deposit allocation type used when importing employees |
dbo.Spreadsheet_Import_Discount_Other_Charge_Shipping_Selection |
Specifies column options for invoice item of type "Discount" or "Other Charge" or "Shipping" |
dbo.Spreadsheet_Import_Finance_Charge_Definition |
The purpose of this table is to map finance charge definitions imported via the spreadsheet import process to finance charge definitions already existing in the database. |
dbo.Spreadsheet_Import_Payment_Term |
Table to store the mapping data information of payment terms for spreadsheet import. |
dbo.Spreadsheet_Import_Payroll_Item_Type |
Table to identify the pay item type used when importing employees |
dbo.Spreadsheet_Import_Sales_Tax_Selection |
Specifies column options for invoice item of type "Sales Tax" |
dbo.Spreadsheet_Import_Tax_Info_Type |
Table to identify the tax informatio type(tax codes,tax codes unit or m3 tax codes) used when importing data from spreadsheet. |
dbo.Spreadsheet_Import_Tax_Item_Type |
Table to identify the Tax item type used when importing employees |
dbo.Spreadsheet_Import_Taxing_Authority |
Specifies mapping data for sales tax descriptions. |
dbo.Spreadsheet_Import_Vendor |
Table to store the mapping data information of vendors for spreadsheet import |
dbo.Staff |
|
dbo.Staff_Create_Ems_User_Requested |
Track staff members for which we've asked Web Services to create an EMS user. |
dbo.Staff_Default_Report_Option |
|
dbo.Staff_Ems_User_Id |
Maps Staff to the EMS User ID, if needed. (EMS being the CSi interal user license management system.) |
dbo.Staff_Locator |
|
dbo.Staff_Locator_Status |
|
dbo.Staff_Security_Group |
|
dbo.Staff_Shortcut |
|
dbo.Staff_Status |
|
dbo.Staff_Type |
The table used to store system Staff types. These values are not expected to be surfaced to the user. |
dbo.Staff_With_Access_To_Checkbook |
This table lists the staff allowed to access a checkbook. If there are no records in this table for a checkbook, then, all["BR"] staff with access to the checkbook's client will have access to the checkbook. If there are records in this table, then only those["BR"] staff will have access to the checkbook. |
dbo.State_Definition |
|
dbo.State_Local_Amount_Code_Type |
|
dbo.State_Tax_Exemption |
|
dbo.State_Tax_Exemption_Detail |
|
dbo.State_Tax_Exemption_Type |
This table contains the list of state taxes defined in the Tax_Code_Type table. Is it used to determine tax exemptions. |
dbo.Static__Valid_Address_Type_Usage_Rule |
This table defines which contact types can be associated with which contact address types. |
dbo.Ste_County |
|
dbo.Ste_Feature_Code |
The Symmetry Tax Engine code for a tax region other than a state or county. This is a sub-type table of Ste_Location_Code. Rows are added to this table as needed, using data retrieved from the STE. |
dbo.Ste_Feature_Code_By_County |
Table that holds a list of feature codes contained in a county. |
dbo.Ste_Location_Code |
Table which holds the super-type STE location codes. STE location codes are defined by the Symmetry Tax Engine (ste). This super type holds the complete location code for any location needed by the system. |
dbo.Ste_State_Code |
The Symmetry Tax Engine code to designate a county. This is a sub-type table of Ste_Location_Code. The contents of this table are pre-populated with all defined codes. |
dbo.Ste_State_Misc_Parameter_Droplist_Item |
|
dbo.Subsidiary_Client_Collection_Type |
The table enumerates the two different types of subsidiary client collections a master consolidated client can have associated with it. The first collection of subsidiary clients is called the User Selected to Consolidate collection and has a key value of 1. This type indicates those subsidiary clients that the user has selected to be consolidated. The second collection is called the Currently Consolidated collection and has a key value of 2. This type indicates those subsidiary clients that have been consolidated and are currently part of the master client's consolidated data. |
dbo.Suta_Supplemental_Type |
|
dbo.Swipe_Clock_Options_Type |
This table holds the description of Swipe Clock Option Type available. It is used to provide options in combo box. |
dbo.Synchronized_Privilege |
Identifies groups of privilege keys that must always have the same value in the array of privilege data. |
dbo.Synchronized_Privilege_Group |
Each row identifies a privilege that is logically the same across modules but is implemented with multiple privilege keys that must always have the same value privilege data array. |
dbo.Table_Information |
|
dbo.Tax_Agent |
|
dbo.Tax_Agent_Direct_Deposit_Allocation |
Table for tax agent direct deposit allocations |
dbo.Tax_Agent_Direct_Deposit_Tax_Payment_Information |
Table for tax agent direct deposit tax payment information. |
dbo.Tax_Agent_Form_Filing_Address |
Table for all the current form filing address for the tax agents. |
dbo.Tax_Agent_Form_Filing_Address_Scenario |
Table for all the various types of form filing address scenarios for the tax agents. |
dbo.Tax_Agent_Locality_Tax_Uid |
|
dbo.Tax_Agent_N_Vendor_Agent |
|
dbo.Tax_Agent_N_Vendor_Agent_Payment_Schedule |
Table to store all selected payment schedules for a particular tax agent along with a set of options for each payment schedule |
dbo.Tax_Agent_Payment_Address |
Holds payment addresses for tax agents and their payment types |
dbo.Tax_Agent_Payment_Address_Type |
Holds types of payment addresses for tax agents |
dbo.Tax_Agent_Payment_Method_Lead_Days |
This table is used by the manage impound payments workitem for use with tax agents. It contains information used in conjunction with a filter to select processing days for payments based on payment method, the due date and the number of lead days. The filter system will calculate the processing date by due date minus the number of lead days for the payment method type. This table is at the firm level and is shared by all clients. There are a fixed number of rows as the payment method types are static, but the table is not read only since the number of lead days can be modified. |
dbo.Tax_Agent_State_Local_Tax_Type_Code |
Table for tax agent direct deposit state/local tax type codes. |
dbo.Tax_Agent_Ste_Location_Code |
|
dbo.Tax_Calculation_Status |
|
dbo.Tax_Code |
Complete set of Ultra Tax and Custom Tax codes for a client |
dbo.Tax_Code_M3_N_GL_Account |
Connects an M3-A tax code to the gl account for a specific year. |
dbo.Tax_Code_N_GL_Account |
Connects a tax code to the gl account for a specific year and unit. |
dbo.Tax_Code_N_Ultra_Tax_Tax_Code |
Connects a client's tax code to the Ultra Tax tax code info for a specific year and entity type. |
dbo.Tax_Code_Type |
This table stores the various tax code types in the system that serve as tax categories. This table also stores the FAKE tax code types. Those FAKEs are added in to serve as placeholders that signify multiple tax code types and the multiple types are defined in the code. Local_Tax_Exemption_Type basically has a one to one relationship with Tax_Code_Type in the database and for certain exemption selections this needs to be one-to-many and the FAKEs allow the many to be specified in the code. |
dbo.Tax_Deferral_Reason |
This type table enables us to know the exact reason for which the tax has been deferred. |
dbo.Tax_Export_Program |
Lists the different types of tax export programs. |
dbo.Tax_Form |
This poorly named table actually describes all tax form COLLATIONS currently in the system |
dbo.Tax_Form_Filing |
This table represents an instance of a Tax Form Collation for a particular client.It is possible that instance was never processed nor filed.While it is the case that this deals with Tax Forms one Collation at a time,this table-level documentation is the only place that will be acknowledged, except where the distinction is critical. |
dbo.Tax_Form_Filing_Method |
|
dbo.Tax_Form_Filing_Override |
Entries in this table each represent a single overriden field on a Tax Form.When the option to Save overrides by period end date for the relevant form type is off,the system will maintain only one set of overrides for the given tax form collation / client combination by dynamically reassigning them from one period_end_date to another. |
dbo.Tax_Form_Grouping |
Table to identify how tax forms should be grouped together. |
dbo.Tax_Form_Liability_Processing_Lock |
This table is used to implement a locking mechanism for tax form liability processing. When a tax form's liabilities are being processed an entry is first made into this table to indicate that other users are prevented from processing identical liabilities. |
dbo.Tax_Form_Override |
This table stores data about override present on the most-recently edited version of a tax form. Each separate field that is overridden has its own entry in this table. Historical data is not preserved. As each form gets re-filed, the system makes the assumption that the same set of overrides as last time shall be applied, unless a service pack deletes overrides due to form updates. It is not possible to retrieve the set of overrides that existed at an arbitrary point in the history of form filing, as only the most recently edited version of the form has its overrides stored. |
dbo.Tax_Form_Selection |
This table contains all the tax forms selected. |
dbo.Tax_Form_Selection_Filing_Instruction_Type |
This table defines all of the tax form slection filing instruction types used in the Tax_Form_Selection table. |
dbo.Tax_Form_Type |
The types of tax forms that can be processed |
dbo.Tax_Jurisdiction |
|
dbo.Tax_Jurisdiction_State_Setting |
|
dbo.Tax_Jurisdiction_Suta_Base_Rate |
|
dbo.Tax_Jurisdiction_Suta_Supplemental_Rate |
|
dbo.Tax_Jurisdiction_Type |
|
dbo.Tax_Period_Frequency |
|
dbo.Tax_Reconciliation_N_Journal_Entry_Distribution |
This table links journal entry distributons of Tax Journal Entries to their tax reconciliation schedule line |
dbo.Tax_Reconciliation_Schedule_Line |
This table will hold predefined values of tax reconcilation lines for some ultra tax entity type |
dbo.Tax_System_Bridged_Carry_Over_Source |
Tax systems that generate carryovers to other systems. Example: 941-X. Also it is tax systems that carryover amounts within the same tax system. Example: 941 Line 10 amounts |
dbo.Tax_System_Bridged_Federal_Carry_Over |
The carryover amounts from one system to another. Example: 941-X credit amount carryovers to 941 for the quarter/year the error was discovered. Also tracks carryover amounts within the same tax systems. Example: 941 Line 10 amounts |
dbo.Taxing_Authority |
Taxing authorities are governmental bodies empowered to collect tax on goods, services or both. If both goods and services are taxed at different rates then two taxing authorities would be created. |
dbo.Taxing_Authority_Type |
A list of possible tax types, such as Service Tax and Sales Tax. |
dbo.Taxpayer_Id_Number_Selection_Type |
Type table for taxpayer id number selection. |
dbo.Term |
|
dbo.Thirdparty_Worker_Compensation_Transmission_Status_Type |
Table containing third party worker compensation transmission status types. |
dbo.Tickmark |
The table contains contains the tickmarks for the firm. It can store one of two types of tickmarks. Images or text. |
dbo.Time_Entry_Method |
|
dbo.Time_Entry_Method_Classification |
Define classifications for time entry methods. |
dbo.Timerack_Client_Update_Queue |
This table stores updated clients that are queued for TimeRack export. |
dbo.Timerack_Client_Update_Queue_Graveyard |
Holds records of Timerack_Client_Update_Queue which couldn't be transmitted. |
dbo.Timerack_Employee_Update_Queue |
This table stores updated employees that are queued for TimeRack export. |
dbo.Timerack_Employee_Update_Queue_Graveyard |
Holds records of Timerack_Employee_Update_Queue which couldn't be transmitted. |
dbo.Timerack_Failure_Type |
Holds types of failures |
dbo.Tip_Allocation_Method |
The table used to store the different types of Tip Allocation methods. |
dbo.Transaction_Status |
|
dbo.Transaction_Template |
Transaction Templates - Parent table for template information used to create OnDemand or recurring transactions. |
dbo.Transaction_Template_Automatic_Type |
Transaction Template Automatic Types - enumerates the supported subtypes for automatic transaction templates |
dbo.Transaction_Template_Calendar_Day |
This table stores options that denote how a user can specify the day of week on which we create a scheduled transaction (e.g., Monday, or weekday, or weekend day). |
dbo.Transaction_Template_Calendar_Day_Occurrence |
This table stores options that denote how a user can specify the occurrence of a day of week on which we create a scheduled transaction (e.g., the first, or the third, or the last). |
dbo.Transaction_Template_Creation_Day |
This table stores options that denote how a user specifies the day on which we should create a scheduled transaction (e.g., create on the Nth day of the month, where N is an integer). |
dbo.Transaction_Template_Frequency |
Transaction Template Frequency - enumerates the supported types of frequencies for transaction templates |
dbo.Transaction_Template_N_GL_Transaction |
This dictionary table associates a transaction template with a GL transaction that was created from it. |
dbo.Transaction_Template_N_Journal_Entry |
This dictionary table associates a jouranl entry transaction with a transaction template. |
dbo.Transaction_Template_Note |
This table is used to store a note associated with a transaction template. A transaction template may have multiple notes associated with it. |
dbo.Transaction_Template_Recurrence_End |
This table stores the options we support for ending a scheduled transaction (e.g., end when we have created a specific number of transactions from a template). |
dbo.Transaction_Template_Schedule_Option |
This table stores the options we support for scheduled transaction templates. |
dbo.Transaction_Template_Scheduled_Recurrence |
This table stores recurrence frequencies we support for scheduled transactions (e.g., daily or weekly). |
dbo.Transaction_Template_Type |
This table allows us to differentiate between potential transaction templates. |
dbo.Transfer_Bank_Transaction |
|
dbo.Transmit_Online_Bill_Pay_Selection |
This is a locking table assuring that no more than one bank transaction is ever being locked tying the transaction to the user who locked it. |
dbo.Trial_Balance_Grid |
This table stores a number of Trial Balance Data Entry Grid for each client with write-up and/or trial balance functionality enabled |
dbo.Trial_Balance_Grid_Column |
This table stores column information for trial balance data entry grid. Each entry in this table represents one column in grid. A grid can have variable number of columns |
dbo.Trial_Balance_Grid_Column_Account_Grouping_Option |
This table stores more column defintion information for trial balance data entry grid columns. For Account_Grouping columns they need more specific informaiton |
dbo.Trial_Balance_Grid_Column_Account_Number_Option |
This table stores more column defintion information for trial balance data entry grid columns. For Account Number columns they need more specifical informaiton |
dbo.Trial_Balance_Grid_Column_Account_Tax_Code_Option |
This table stores more column definition information for trial balance data entry grid columns. For Tax Code columns they need more specific information |
dbo.Trial_Balance_Grid_Column_Amount_Amount_Type |
This table stores type definition to Trial_Balance_Grid_Column_Amount. The Amount Type is more detaild information such as Beginning Balance, Adjusting JE and so so. |
dbo.Trial_Balance_Grid_Column_Amount_Balance_Type |
This table will hold values for the trial balance grid column amount balance type. |
dbo.Trial_Balance_Grid_Column_Amount_Option |
This table stores more column defintion information for trial balance data entry grid columns. For Amount columns they need more specifical informaiton |
dbo.Trial_Balance_Grid_Column_Amount_Period_Basis |
This table stores type definition to Trial_Balance_Grid_Amount_Period_Base. User has flexibilty to define an amount column by specifiying an offset from a period Base. it could be Current Period, Current YTD or The Begining of the Year |
dbo.Trial_Balance_Grid_Column_Tickmark_Option |
This table stores more column defintion information for trial balance data entry grid columns. For Amount columns they need more specifical informaiton |
dbo.Trial_Balance_Grid_Column_Type |
This table stores type definition to Trial Balance Grid Column |
dbo.Trial_Balance_Grid_Column_Workpaper_Reference_Option |
This table stores more column defintion information for trial balance data entry grid columns. For workpaper reference columns they need more specifical information |
dbo.Trial_Balance_Grid_Type |
This table will hold values for the trial balance grid type. |
dbo.Trial_Balance_Split_Screen_Grid_Option |
Table to store the options on a per client basis for the Journal Entry Split Screen View in the Trial Balance Grid. |
dbo.Ultra_Tax_Category_Type |
Tax Code Category type table |
dbo.Ultra_Tax_Entity_Type |
Ultra Tax Enity information |
dbo.Ultra_Tax_Map_File |
Ultra Tax tax code map file information |
dbo.Ultra_Tax_Staged_Tax_Code |
This table is used to stage incoming Ultra Tax tax codes before they are merged into the global and client Ultra Tax tax codes. |
dbo.Ultra_Tax_Tax_Code |
Ultra Tax tax code map file contents |
dbo.Undo_Manager_Entry |
This table stores the xml version of reports when a user is using the Undo Manager. |
Unique_Identifier_Counter |
|
dbo.Update_Data_Change_Log |
|
dbo.Update_Data_Version_History |
|
dbo.Updated_Ledger_Entry_Queue |
Table used to queue up gl transaction changes that will require the ledger entry ETL processes to run. |
dbo.User_Client_Preference_Grid_Column_Screen_Option |
This table holds links to the customised columns and the grids they belong to (if the user customised order and visibility of columns in a given grid). |
dbo.User_Interface_Grid |
This table holds the description of the grid that has the column with customised display settings and the link to the screen it belongs to. |
dbo.User_Interface_Grid_Column |
This table holds the description of the columns and whether it is required and the link to the grid it belongs to. |
dbo.User_Interface_Screen |
The table used to store the different types of UI screens in the system. |
dbo.User_Preference |
|
dbo.User_Preference_Grid_Column_Screen_Option |
This table holds links to the customised columns and the grids they belong to (if the user customised order and visibility of columns in a given grid). |
dbo.User_Screen_Option |
The table used to store UI control states on system screens. |
dbo.User_Session |
|
dbo.User_Session_Override |
This table holds updates to rows in dbo.User_Session that would have otherwise been blocked. It is important to NOT have a relationship to dbo.User_Session so that we avoid any blocking on enforcing DRI. |
dbo.User_Session_Pattern |
|
dbo.User_Session_Status |
|
dbo.Valid_7200_Period |
This table records the valid year/quarter combinations for form 7200, allowing future legislative changes to be handled via a simple insert. |
dbo.Vendor |
|
dbo.Vendor_1099_Box_Setup |
This table contains the valid 1099 box combinations available for use on bank transactions for a particular vendor. |
dbo.Vendor_1099_Recipient_Filter_Type |
This table defines all of the types of filtering available for a vendor 1099 recipient. |
dbo.Vendor_1099_Sort_Type |
Table used to store the ways to sort vendors on 1099s. |
dbo.Vendor_AP_Beginning_Balance |
This table may hold a link between a vendor and a carry over payable transaction if they have one. |
dbo.Vendor_Agent |
|
dbo.Vendor_Agent_Due_Date_Adjustment |
|
dbo.Vendor_Agent_Effective_Date |
This table will essentialy hold duplicate information from the Vendor_Agent table, and will be used as temp table while areas of the code are changed for the Effective Date for Deposit Schedules project. |
dbo.Vendor_Agent_Liability_Source |
|
dbo.Vendor_Agent_Payment_Schedule |
|
dbo.Vendor_Amortization_Schedule |
Amortization schedules are used to display payments over time that have principal and interest amounts. |
dbo.Vendor_Amortization_Schedule_Entry |
Individual payments scheduled as part of an amortization schedule. |
dbo.Vendor_Bank_Transaction |
|
dbo.Vendor_Direct_Deposit_Allocation |
|
dbo.Vendor_Distribution |
This table contains the default distributions used when a payment is created for a vendor. |
dbo.Vendor_Independent_Contractor_Reported |
The table used to store when a vendor has been reported to be an independent contractor. |
dbo.Vendor_Payment_Method |
|
dbo.Vendor_Payment_Primary_Sort_By_Type |
|
dbo.Vendor_Payment_Secondary_Sort_By_Type |
This table contains the values for secondary sort in Print Checks screen. |
dbo.Vendor_Type |
Table used to store the types of vendors. |
dbo.W2_1099_Box_Type |
Lookup table of boxes available on 1099 forms |
dbo.W2_1099_Ordering_Worksheet_Client_Option |
This table enumerates the different types of client options available when previewing the W-2 and 1099 ordering worksheets. |
dbo.W2_1099_Type |
|
dbo.W2_1099_User_Preference |
Table used to store user preferences for W-2s and 1099s |
dbo.W2_Compensation_Code_Type |
The table defines compensation codes relevant for W2 processing. |
dbo.W2_Copy_A_Client_Copy_Type |
Table to identify the copy type used when printing the client copy for the W-2 Copy A. |
dbo.W2_Employee_Sort_Type |
Table used to store the ways to sort employees on W-2s. |
dbo.W2_Form_Corrected_Type |
The entries in this type table specify the various types of W-2s that can be corrected. |
dbo.W2_Kentucky_Tax_Credit_Type |
The table defines types of Kentucky tax credits, relevant for W2 processing. |
dbo.W2_Nonqualified_Deferred_Compensation_Type |
The table defines types of nonqualified deferred compensation for W2 processing. |
dbo.W2_Override_Type |
Type table for W-2 override type. |
dbo.W2_Rendered_Template |
Table used to store pre-rendered form template documents used during W2 processing. |
dbo.W2_Rendering_Client_Lock |
This table locks a particular client, where a lock record indicates the client is being processed by the W2 rendering Cron task. |
dbo.W2_Special_Correction_Type |
The entries in this type table specify the various types of special corrections that can occur when correction a W-2. |
dbo.W3_Client_Copy_Type |
Table to identify the copy type used when printing the client copy for the W-3. |
dbo.W3_Kind_Of_Employer |
This table defines the possible kinds of W-3 employers. |
dbo.W4_Additional_Amount_Type |
|
dbo.Wage_Type |
|
dbo.Web_Employee_Check_Stub_Queue |
Table to track check stubs data pending transmission to a web service |
dbo.Web_Employee_Employee_Update_Queue |
Table to track employee data pending transmission to a web service |
dbo.Web_Page_Portlet |
|
dbo.Web_Services_Client_Deletion_Queue |
Table to track deleted clients pending transmission to Web Services |
dbo.Web_Services_Employee_Deletion_Queue |
Table to track deleted employees pending transmission to Web Services |
dbo.Web_Services_Transmit_Queue |
Top level table to track data that needs to be uploaded to a web service |
dbo.Web_Services_Transmit_Queue_Graveyard |
Holds records of Web_Services_Transmit_Queue which couldn't be transmitted. |
dbo.Withholding_Deposit_Frequency |
|
dbo.Withholding_Deposit_Schedule |
|
dbo.Work_Location |
|
dbo.Work_Location_Tax_Jurisdiction |
|
dbo.Worker_Compensation |
|
dbo.Worker_Compensation_Class_Code |
|
dbo.Worker_Compensation_Class_Code_Detail |
|
dbo.Worker_Compensation_Limit |
|
dbo.Worker_Compensation_Limit_Detail |
|
dbo.Worker_Compensation_Rate |
|
dbo.Workforce_Hub_Check_Stub_Queue |
This table contains all check stubs that have been queued to send to Workforce Hub |
dbo.Workforce_Hub_Employee_Update_Queue |
This table contains employees and any additional data for those employees that needs to be sent to Workforce Hub. |
dbo.Workforce_Hub_Form_Queue |
This table contains all forms that have been queued to send to Workforce Hub |
dbo.Workforce_Hub_Form_Type |
This table contains all the types of forms that can be sent to Workforce Hub |
dbo.Workforce_Hub_Pending_Acknowledgement_Queue |
This table contains list of updates that came from WFH but have not been acknowledged yet. |
dbo.Workpaper |
This table contains the data that represents a document within an engagement binder. |
dbo.Workpaper_File_Component |
This table contains the known types of files a workpaper may contain (i.e. preview, original, etc...). |
dbo.Workpaper_List_Column |
This table contains the order (and presence) of the columns in the workpaper list portlet, chosen by the logged in staff. |
dbo.Workpaper_List_Column_Type |
This table contains all the column types for workpapers list portlet grid.["BR"] Logged in Staff can modify the column order as per their requirement. |
dbo.Workpaper_N_File_Storage |
This table contains links a workpaper to the many files it can be made up of. |
dbo.Workpaper_Roll_Forward_Treatment |
This table is a type table used to keep track of which ways we allow the user to roll forward a workpaper. |
dbo.Workpaper_Signoff |
This table will record all of the signoffs a particular workpaper contains. |
dbo.Workpaper_Source_Document_Processing |
This table stores information about a workpaper as it is being sent to Source Document Processing. Entries in this table will tracking an automated process that uploads a file to be OCRd, waits for processing to be complted, downloads the file and then splits up documents. Each workpaper has only one entry in this table and the status gets updated as changes occur. Workpaper entries can be Added, processed and Uploaded/Downloaded to secure servers for OCR processing from Engagement Binder Window in Workpaper Dashboard. They can also be processed and Uploaded/Downloaded from Source Document Portlet (Firm Dashboard) |
dbo.Workpaper_Source_Document_Processing_Status |
This table stores information about the states a workpaper goes through when it is sent to Source Document Processing. |
dbo.Workpaper_Source_Ocr_Data |
This table stores information of Source Document (PDF) OCR data and page index where the OCR belongs to . |
dbo.Workpaper_Status |
This table contains information needed for describing the various states of a workpaper. |
dbo.XactPay_Accruable_Benefit_Type |
Table containing XactPay accruable benefit types. |
dbo.XactPay_Client_EIN_History |
Table containing the EIN history for XactPay clients |
dbo.XactPay_Consent |
Table containing XactPay consent file information |
dbo.XactPay_Employee_SSN_History |
Table containing the SSN history for XactPay employees |
dbo.XactPay_Employer_Contribution_Type |
Table containing XactPay employer contribution types. |
dbo.XactPay_Multi_Class_Identifier_Type |
Table containing XactPay multi class identifier types. |
dbo.XactPay_N_Payroll_Bank_Transaction |
A dictionary table to map XactPay_Payroll_Transmission and Payroll_Bank_Transaction, so that each check item in the payroll file will have an entry here. |
dbo.XactPay_Pay_Item_Type |
Table containing XactPay pay item types. |
dbo.XactPay_Payroll_Transmission |
Table containing XactPay payroll file information |
dbo.XactPay_Payroll_Transmission_Result |
Table containing XactPay payroll file history |
dbo.XactPay_Setup_Transmission |
Table containing XactPay setup file information |
dbo.XactPay_Setup_Transmission_Result |
Table containing XactPay setup file history |
dbo.Year_End_Close_Balance_Sheet_Account_Distribution |
The table contains the accounts that had ballance sheet account amounts distributed to them during a year end close event. |
dbo.Year_End_Close_Budget_Amount_Treatment |
The table enumerates the different treatments available to the year end close process for initializing the budget amounts in the new fiscal year. |
dbo.Year_End_Close_Net_Income_Distribution |
The table contains the accounts that had net income distributed to them during a year end close event. |
dbo.Year_End_Close_Option |
The table contains the options a client has used to perform the year end close process for a fiscal year. |
dbo.Yodlee_Financial_Account_Link_Status |
This table holds values for Yodlee financial account link statuses. |
dbo.Zero_Hours_Code |
This table stores the zero hours codes and their descriptions. These are explanations of why an employee may have wages without having any hours. |