Tables list report

Generated: 2018-10-18 8:17:41 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Spire Data Dictionary tables list

Tables

Table Owner Comment
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

Report generated by pgAdmin3 LTS by BigSQL