Return to: Database Reference Home Page

---

Master List of TABLE DEFINITIONS and SCHEMA

001_company_master
002_stock_adjust_gl_accounts
003_content_blocks
004_vendor_purchasing_master
005_vendor_master
006_vendor_item_multipliers
007_gl_dept_header
008_gl_master
009_freight_carrier
010_freight_service
011_freight_options
012_zipcode_tax_lookup
013_tax_jurisdiction_master
014_tax_jurisdiction_gl_accts
015_zip_to_jurisdiction
016_printer_master
017_warehouse_master
018_amazon_shipping_confirmation
019_amazon_order_cancellation
020_ebay_category_master_version
021_ebay_category_master
022_sys_timestamps
023_ebay_request_token
024_customer_terms_master
025_category_master
026_category_attribute_columns
027_customer_master
028_customer_shipto
029_exempt_form_images
030_item_master
031_item_aliases
032_nonstock_master
033_sim_to_item
034_item_assembly
035_item_go_together
036_item_categories
037_item_warehouse
038_item_ledger
039_amazon_items
040_employee_master
041_employee_default_warehouse
042_employee_default_printer
043_contact_master
044_vendor_contacts
045_customer_contacts
046_call_report_master
047_call_report_files
048_employee_content_blocks
049_session_master
050_ebay_auction_master
051_ebay_auction_scheduler
052_ebay_auction_winners
053_ebay_auction_post_log
054_paypal_payment_master
055_paypal_payment_lines
056_paypal_ipn_scratchpad
057_feedback_summary
058_feedback_detail
059_sales_order_header
060_sales_order_line_items
061_history_sales_order
062_vendor_returns_header
063_vendor_returns_line_items
064_history_back_order_fill
065_ups_tracking_export
066_fedex_tracking_export
067_ar_detail_comment_master
068_ar_detail
069_auto_payment_register
070_ar_batch
071_ar_batch_history
072_ar_batch_lock
073_po_header
074_po_line_items
075_history_po_receipts
076_po_receipts
077_po_costing_header
078_po_costing_line_items
079_report_master
080_report_args
081_report_spooler
082_user_reports
083_email_repository
084_item_plan_master
085_item_plan_week
086_item_plan_month
087_vendor_plan_master
088_vendor_plan_month
089_company_plan_master
090_week_date_info
091_attribute_master
092_item_attributes
093_history_stock_level
094_history_table_revision
095_shipping_rate_data
096_active_shoppingcart
097_ecommerce_accounts
098_ecommerce_accounts_permission
099_orderpad_header
100_orderpad_line_items
101_saved_shoppingcart
102_ecommerce_session_master
103_web_logs
104_email_log
105_viaklix_auth
106_note_master
107_config_main
108_config_values
109_coupons
110_coupons_users
111_viaklix
112_month_end_dates
113_month_end_reports
114_day_end_reports
115_employee_reports
116_cyclecount_rules
117_cyclecount_pool_seqno
118_cyclecount_pools
119_cyclecount_pool_items
120_pricing_matrix
121_pricing_contract
122_count_sheet_header
123_count_sheet_line_items
124_permission_master
125_permission_roles
126_permission_role_membership
127_permission_rules
128_pending_price_updates
129_price_update_queue