addresses |
spireapp |
Table for all Address records |
ap_batch_items |
spireapp |
Table for saved Accounts Payable payment batch items |
ap_batches |
spireapp |
Table for saved Accounts Payable Batches |
ap_transaction_links |
spireapp |
Table to link Accounts Payable Debit transactions to Credit transactions |
ap_transactions |
spireapp |
Table for Accounts Payable Transactions |
ar_batch_items |
spireapp |
Table for saved Accounts Receivable payment batch items |
ar_batches |
spireapp |
Table for saved Accounts Receivable payment batches |
ar_transaction_links |
spireapp |
Table to link Accounts Receivable Credit transactions to Debit transactions |
ar_transactions |
spireapp |
Table for Accounts Receivable transactions |
bom_categories |
spireapp |
Table for Bill of Materials categories |
bom_item_replacements |
spireapp |
Table for saved Production Order and Template Components replacements |
cash_out_payment_methods |
spireapp |
Table for Payment Methods selected in Cash Outs |
cash_outs |
spireapp |
Table for Cash Outs performed |
countries |
spireapp |
Table for Countries |
currencies |
spireapp |
Table for Currency rates |
customer_code_changes |
spireapp |
Table for Customer Code changes |
customers |
spireapp |
Table for Customers |
email_templates |
spireapp |
Table for email templates |
employee_roe_details |
spireapp |
Table for details on the Record of Employment |
employee_roes |
spireapp |
Table for Record of Employment reports |
employee_t4s |
spireapp |
Table for Employee T4 records |
employees |
spireapp |
Table for Employees |
equipment |
spireapp |
Table for Equipment; All Equipment labels are user definable however database field names do not change |
gl_accounts |
spireapp |
Table for General Ledger Accounts |
gl_allocations |
spireapp |
Table for General Ledger Allocation posting control |
gl_divisions |
spireapp |
Table for General Ledger divisions. Only one record will exist for non divisionalized companies. One extra record will exist for divisionalized companies, '000', for the consolidated division. |
gl_groups |
spireapp |
Table for General Ledger Account Groups |
gl_history_accounts |
spireapp |
Table for historical General Ledger Accounts as they were when the Year End Close was performed for the Fiscal Year ending as stated in year_end. |
gl_history_divisions |
spireapp |
Table for General Ledger divisions as they were when the Year End Close was performed for the Fiscal Year ending as stated in year_end. Only one record will exist for non divisionalized companies. One extra record, '000', will exist for divisionalized companies for the consolidated division. |
gl_history_groups |
spireapp |
Table for General Ledger Groups as they were when the Year End Close was performed for the Fiscal Year ending as stated in year_end. |
gl_history_periods |
spireapp |
Table for General Ledger Fiscal Periods as they were when the Year End Close was performed for the Fiscal Year ending as stated in year_end. |
gl_history_segments |
spireapp |
Table for General Ledger segments as they were when the Year End Close was performed for the Fiscal Year ending as stated in year_end. |
gl_history_subgroups |
spireapp |
Table for General Ledger subgroups as they were when the Year End Close was performed for the Fiscal Year ending as stated in year_end. |
gl_history_transactions |
spireapp |
Table for General Ledger history transactions for the fiscal year ending as stated in year_end. |
gl_periods |
spireapp |
Table of General Ledger Periods for Last Year, This Year and Next Year |
gl_reconciliation_items |
spireapp |
Table for list of Reconciliation items |
gl_reconciliations |
spireapp |
Table for Reconciliations saved, not yet posted |
gl_recurring_pending |
spireapp |
Table for Recurring transactions |
gl_recurring_transactions |
spireapp |
Table of Templates defining Recurring transactions |
gl_segments |
spireapp |
Table of General Ledger Segments |
gl_special_accounts |
spireapp |
Table of Special Accounts for system posting |
gl_subgroups |
spireapp |
Table for General Ledger Account Sub Groups |
gl_transactions |
spireapp |
General Ledger Transactions for the fiscal last year, this year and next year |
inventory |
spireapp |
Table for all Inventory items, one record exists for each warehouse, part number combination |
inventory_adjustment_items |
spireapp |
Table for items in Inventory Adjustment batches |
inventory_adjustments |
spireapp |
Table for Inventory Adjustment batches |
inventory_comments |
spireapp |
Table for Comments to be used on Sales Orders in the place of Inventory |
inventory_components |
spireapp |
Table for Kit and Macro Inventory components |
inventory_conversion_factors |
spireapp |
Table no longer used |
inventory_count_details |
spireapp |
Table for Inventory Count item records, one record for each count entered, for every part number counted |
inventory_counts |
spireapp |
Table for Inventory Count batches |
inventory_labels |
spireapp |
Schema for temp table created when printing Inventory labels |
inventory_levy_codes |
spireapp |
Table for Levies |
inventory_lot_trace |
spireapp |
Schema for temp table created for records located during Lot Trace Print process |
inventory_part_no_changes |
spireapp |
Table for Part Number changes saved but not yet applied |
inventory_price_matrix |
spireapp |
Table for Price Matrix records |
inventory_product_codes |
spireapp |
Table for Inventory product groups |
inventory_promo_codes |
spireapp |
Table of promotional codes used by Price Matrix |
inventory_receipts |
spireapp |
Table for Inventory Receipts through Purchase Orders, Inventory Adjustments/Transfers, Production Orders, Sales Order returns, each record includes FIFO/LIFO information |
inventory_requisitions |
spireapp |
Table for records created by Sales Orders, Production Orders or Inventory Requisitions, used to create Production Orders or Purchase Orders |
inventory_serial_numbers |
spireapp |
Table for serial numbers and lot numbers |
inventory_serial_transactions |
spireapp |
Table for serial number and lot number transactions |
inventory_statistics |
spireapp |
Table for Inventory Sales Statistics by finanacial period |
inventory_uoms |
spireapp |
Table for Inventory Unit of Measure records |
inventory_upc_codes |
spireapp |
Table for Universal Product Codes link to Inventory items |
inventory_warehouses |
spireapp |
Table of Inventory Warehouses |
job_items |
spireapp |
Table for Job transactions |
jobs |
spireapp |
Table for Jobs |
note_types |
spireapp |
Table for Communication Note types |
notes |
spireapp |
Table for Communication Notes |
payment_methods |
spireapp |
Table for Payment Methods |
payment_terms |
spireapp |
Table for Payment Terms for Sales and Purchases |
payroll_depts |
spireapp |
Table for Payroll Departments containg control settings for posting timecards |
payroll_schedules |
spireapp |
Table for Payroll Schedules for each pay frequency |
phase_history |
spireapp |
Table to store the changes to Phases on Orders |
phases |
spireapp |
Table for Phases available to Sales Orders, Purchase Orders and Production Orders |
production_history |
spireapp |
Table for Production Orders that have been built |
production_history_items |
spireapp |
Table for built Prodution Order component details |
production_order_items |
spireapp |
Table for Prodution Order component details |
production_orders |
spireapp |
Table for Production Orders not yet fully built |
production_template_items |
spireapp |
Table for Prodution Template component details |
production_templates |
spireapp |
Table for Production Templates |
purchase_history |
spireapp |
Table for closed Purchase Orders |
purchase_history_items |
spireapp |
Table for items on closed Purchase Orders |
purchase_order_items |
spireapp |
Table for items on open Purchase Orders |
purchase_orders |
spireapp |
Table for open Purchase Orders |
purchase_receipts |
spireapp |
Table for all receipts in Purchase Orders |
record_types |
spireapp |
Table for Customer and Inventory types |
sales_departments |
spireapp |
Table for Inventory Sales Departments |
sales_history |
spireapp |
Table for posted Sales Invoices |
sales_history_equipment |
spireapp |
Table for equipment attached to posted Invoices |
sales_history_items |
spireapp |
Table for posted Sales Invoice lines |
sales_history_payments |
spireapp |
Table for Payments on posted Sales Invoices |
sales_order_batches |
spireapp |
Table for for Sales Order batches |
sales_order_equipment |
spireapp |
Table for equipment attached to open Sales Orders |
sales_order_items |
spireapp |
Table for Sales Orders lines not yet posted |
sales_order_payments |
spireapp |
Table for Payments made on Sales Orders |
sales_orders |
spireapp |
Table for Sales Orders not yet posted |
sales_taxes |
spireapp |
Table for Sales Taxes |
salespeople |
spireapp |
Table for Salespeople |
shipping_methods |
spireapp |
Table for Shipping Methods |
system_filters |
spireapp |
Tables for saved filters |
system_record_locks |
spireapp |
Table to control lock records being edited by a user |
system_report_permissions |
spireapp |
Table to control report permissions when Report security is enabled in Company settings or User settings |
system_sequence_numbers |
spireapp |
Table to control all of the next sequence numbers i.e. trans_no, order_no, invoice_no etc. |
system_settings |
spireapp |
Table to control system settings and values |
system_users_base |
spireapp |
Table for User list |
territories |
spireapp |
Table of Sales Territories |
timecard_entries |
spireapp |
Table of Timecard pay records |
timecards |
spireapp |
Table for Payroll timecards |
udf_fields |
spireapp |
Table of UDF field definitions |
udf_pages |
spireapp |
Table for UDF page definitiions |
vendor_code_changes |
spireapp |
Table for saved Vendor Code changes |
vendor_pricing |
spireapp |
Table for Vendor prices per part number |
vendors |
spireapp |
Table for Vendors |
zip_codes |
spireapp |
Table for U.S.A. Zip codes |