Data Dictionary Your Guide to the Prophet 21 (CommerceCenter) Database     Search   |   Object Details

Table Information Select a table from the drop down list to get information for that table. Table Name: activant_layout_def activity activity_reminder activity_trans ad_role_x_users address address_dea address_freight_display address_history address_x_dea_license adjustment_criteria ADPIM_Prod ADPIM_Web ADPIM_Webimage ads_audit_accounting_ar ads_audit_commission ads_audit_customer ads_audit_invoice ads_audit_order ads_audit_run ads_metric_configuration affinity_hierarchy aha_security aia_element aiag_label alarm_code alarm_code_x_inv_mast alert_implementation Alert_implementation_query alert_message alert_queued_mail alert_recipient alert_task alert_task_aux_assignee alert_type alert_type_x_token alternate_code alternate_code_aux_info alternate_oe_settings apinv_hdr apinv_hdr_174 apinv_hdr_not_delete apinv_hdr_vat apinv_hdr_x_inventory_receipts apinv_line apinv_line_disputed_vouch apinv_line_x_inv_receipts_line application_resource_file application_security ar_allowed_amt_distribution ar_payment_details ar_receipts ar_receipts_detail area area_x_custom_column assembly_hdr assembly_hdr_location assembly_hdr_make_days assembly_line assembly_line_tally audit_trail audit_trail_support average_inventory_value balances balances_reporting_curr bank_accounts bank_accounts_eft bank_accounts_reconciliation bhl_release_bin bill_hold_hdr bill_hold_line bill_hold_line_x_adjust bill_of_lading_detail bill_of_lading_hdr bill_to_category bill_to_category_items bin bin_replenishment bin_replenishment_order bin_type bin_zone bin_zone_group bin_zone_x_bin_zone_group boeing_caller_10000 boeing_order_10000 boeing_order_xref_10000 boeing_po_10000 boeing_shipping_10000 box_item_x_each_item branch branch_inv_no_display business_rule business_rule_data_element business_rule_x_roles business_rule_x_users buy_list_hdr buy_list_line calendar_based_delivery calendar_based_reading_hist calendar_measure_10005 call_category call_log cancel_pick_ticket_bin cancel_pick_ticket_item cancel_pick_ticket_lot cancel_pick_ticket_serial cancel_pick_ticket_tag carrier_194 carrier_2164 carrier_bill_of_lading carrier_cube_factor carrier_cube_modifier carrier_data carrier_data_detail carrier_data_x_package carrier_data_x_shipment carrier_shipping_charge carrier_shipping_document carrier_x_freight_code cash_drawer cash_drawer_history cash_drawer_transaction castrol_trans_summary category category_x_activity cc_columns cc_payment_type_x_processor cc_processor_x_location cc_tables cell_definition cell_range certificates_335 certification_level chart_of_accts chart_of_accts_edi check_payment_details class clippership_return_10004 clippership_return_nfa_1934 code_group_p21 code_p21 code_x_code_group_p21 code_x_code_p21 columns comm_defaults_days_overdue commission_defaults commission_rule commission_rule_detail commission_run commission_run_consolidated_invoice_holding commission_run_exception commission_run_invoice_line_amounts commission_run_line commission_run_line_rule commission_run_rule commission_schedule commission_schedule_detail company company_111 company_322 company_agent company_ar_info company_cost_var_info company_cust_size_limits company_distranet_info company_edi_setting company_greeting_10016 company_inv_no_display company_iva_tax company_language company_lc_search_order company_lost_sales company_mac_adjustment company_so_options company_strategic_pricing company_wit company_work_day competitor competitor_representative condition consignment_billing_cycle consignment_bin_count consolidated_invoices_xref consolidated_invoices_xref_p21_case938985 consolidated_picking_hdr consolidated_picking_line contact_document contact_filter_tracking contact_insurance contact_lead_source contact_role contact_salesrep contact_type contact_x_oe_hdr contactlist contacts contacts_335 contacts_outlook_sync_criteria contacts_x_ship_to contacts_x_supplier container_receipts_hdr container_receipts_line contract_x_contract_class copy_item_sql copy_item_table copy_table_data_x_argument copy_table_data_x_argument_val copy_table_data_x_clause copy_table_data_x_column copy_table_data_x_column_val copy_table_data_x_counter copy_table_data_x_process copy_table_data_x_table core_class core_status_family_detail core_status_family_hdr corp_id counter country county credinv_x_invhdr_x_fcinv credit_status credit_status_2164 creditcard_payment_details creditcard_proc_comp_user creditcard_processor creditcard_processor_x_users creditcard_transrequest creditcard_transresponse creditcard_transtype creditcard_validation crew crm_contact_information crystal_external_report crystal_external_report_x_role cube_factor cube_modifier currency_contract currency_hdr currency_line currency_variance_account cust_defaults cust_defaults_foreign cust_defaults_labels cust_defaults_merge_cust cust_defaults_strategic cust_defaults_terms_acct cust_part_no_group_hdr cust_part_no_group_line cust_part_no_notepad cust_x_invsupplier_freight custom_column_data_customer custom_column_data_shipto custom_column_data_supplier custom_column_data_vendor custom_column_definition custom_column_list custom_objects custom_objects_backup custom_objects_detail customer customer_10011 customer_194 customer_2164 customer_322 customer_335 customer_45 customer_723 customer_activity customer_activity_link customer_activity_type customer_aha customer_call customer_call_inv_detail customer_category customer_class_order_charge customer_class_x_inventory_class customer_cons_inv_cardlock customer_contract customer_contract_class customer_coop_advert_allowance customer_core_tracking customer_coupon customer_credit_history customer_credit_history_daily customer_document customer_edi_setting customer_edi_trans_detail customer_edi_transaction customer_form_template customer_freight_display customer_freight_options customer_gl_code customer_gpo customer_invoice_surcharge customer_item_comm_class customer_iva_tax customer_language customer_list_temp customer_lot_requirement customer_merge_cust customer_notepad customer_oe_info customer_order_duplicate_check customer_order_history customer_order_history_daily customer_order_surcharge customer_package_hdr customer_package_line customer_profitability_role customer_retail customer_retail_item customer_retail_pricing customer_salesrep customer_salesrep_location customer_sensitivity_matrix customer_statement_history customer_strategic_item customer_strategic_pricing customer_supplier customer_supplier_freight customer_terms customer_tpw customer_tradenet customer_type customer_vat customer_weboe customer_x_contract_class customer_x_dealer_type customer_x_restricted_class customer_x_rewards_program cycle_count_accuracy cycle_count_detail cycle_count_hdr cycle_count_loc_criteria cycle_count_purchase_class data_ident_x_data_ident_group data_identifier data_identifier_group db_sql db_sql_orig_backup dct_layout_column dct_layout_file dct_layout_hdr dct_layout_rule dct_lookup_detail dct_lookup_hdr dct_transaction dct_transaction_config dct_transaction_table dct_transaction_table_config dct_transaction_table_rule dea_license dealer_commission dealer_commission_payments dealer_commission_receipts dealer_type deallocate_transactions_run decoder_comb_segment_dtl decoder_comb_segment_hdr decoder_segment_dtl decoder_segment_dtl_breaks decoder_segment_hdr decoder_segment_hdr_rules decoder_template_dtl decoder_template_dtl_rules decoder_template_dtl_val_rules decoder_template_hdr decoder_template_hdr_mask degree_days degree_days_delivery delivery delivery_group delivery_package delivery_pick_ticket delivery_pick_ticket_detail delivery_rma delivery_rma_detail delivery_ticket_info delivery_x_delivery_group delivery_zone demand_forecast_formula demand_level demand_line_point demand_pattern_criteria demand_pattern_run demand_period demand_review_adjustment departments deployed_map deployed_maps_mft dimensions direction_recent_search discount_group discount_group_defaults discount_group_x_restricted_class discount_group_x_rewards_program discount_installment_10005 dispatcher_pricing_dtl dispatcher_pricing_hdr disputed_voucher_reason distranet_info division document document_inout_data document_line_bin document_line_inv_xref_dtl document_line_inv_xref_hdr document_line_lot document_line_lot_bin_xref document_line_lot_grid document_line_lot_sub document_line_serial document_link document_link_area document_link_entity_req document_link_key document_link_trans_type document_link_window document_link_window_x_key document_printer_x_loc document_summary document_transaction_data document_types downpayment_refund_details dwobject dwobject_syntax dynachange dynachange_config dynachange_config_orig_backup dynachange_desc dynachange_menu dynachange_menu_orig_backup dynachange_orig_backup edi_852_log edi_process_info equip_engine_type equip_manufacturer equip_model export_counter export_matrix extensibility_object extensibility_window external_tax_detail fascor_export_data fascor_export_log fascor_import_data fascor_import_ship_temp fascor_invdiscrepancy fast_edit_change fast_edit_detail fast_edit_error fast_edit_hdr fault_tolerance_area_code fault_tolerance_audit_trail fault_tolerance_problem_code fault_tolerance_production_orders fault_tolerance_purchase_orders fault_tolerance_sales_orders fault_tolerance_transfers fax_cover fbff_criteria fbff_forecasts fbff_forecasts_per_item_location_formula fbff_sum_error_per_item_location_formula fbff_to_update fc_dataobject fc_dataobject_column fc_dataobject_table fedex_service_type feedback_data_audit_trail field_chooser_area field_chooser_info fifo_layer_cost_history fifo_layer_transaction fifo_layers fin_report finance_charge_cycle financial_report_column financial_report_row financial_report_row_x_acct floor_plan_10002 form form_destination form_destination_hierarchy freight_charge freight_charge_break freight_charge_by_mile_dtl freight_charge_by_mile_hdr freight_charge_carrier freight_code freight_code_2186 freight_code_220 freight_handling_break freightquote_class freightquote_package_detail freightquote_package_hdr freightquote_pkg_type frl_seg_ctrl frl_seg_desc fuel_pricing geocom_handheld gl gl_alloc gl_code gl_code_list_detail gl_code_list_hdr gl_counter gl_notepad gl_reporting_curr gl_tran_number_counter gpor_run gpor_run_hdr gpor_supplier_pending_log gpor_vss group_pick_ticket_detail group_pick_ticket_hdr gtor_run hazmat_class hazmat_code help_access help_topic help_topic_notepad icm_customer_item_info impexp_source import_audit import_audit_settings import_restart_file import_restart_hdr import_restart_requestor import_suspense_fkerror import_suspense_hdr import_suspense_line import_suspense_settings import_temp_table_x_file import_val_status incoming_freight_charge installment_dates_10005 installment_frequency_10005 installment_plan_discount_pct installment_plans_10005 intercompany_acct intrastat_currency intrastat_info inv_accessory inv_adj_hdr inv_adj_line inv_bin inv_bin_deletion_inv_bin_hdr inv_bin_hdr_not_delete inv_excise_tax inv_group_hdr inv_group_loc_allocation inv_group_region inv_group_region_loc inv_hdr_salesrep_rules inv_hdr_x_fc_inv inv_line_salesrep_rules inv_loc inv_loc_additional_price inv_loc_aqnet inv_loc_expedite_time inv_loc_gtor_ns inv_loc_msp inv_loc_price_multiplier inv_loc_salesrep inv_loc_stock_status inv_mast inv_mast_15 inv_mast_194 inv_mast_2164 inv_mast_219 inv_mast_335 inv_mast_additional_price inv_mast_assem_info inv_mast_core inv_mast_coredisc inv_mast_dea inv_mast_default inv_mast_default_x_company inv_mast_document inv_mast_equip inv_mast_freight_option inv_mast_intrastat inv_mast_labels inv_mast_language inv_mast_lifo_pool inv_mast_links inv_mast_lot inv_mast_msds inv_mast_strategic_pricing inv_mast_taxinfo inv_mast_tire_proration inv_mast_web_desc inv_mast_x_company inv_mast_x_restricted_class inv_mast_x_rewards_program inv_period_usage inv_period_usage_temp inv_ranking_criteria inv_rcpts_x_vendor_invoice inv_reclassification_detail inv_reclassification_work inv_sub inv_sub_history inv_supp_auto_update_price inv_supplier_x_loc_pricing inv_tran inv_tran_bin_detail inv_tran_lot_detail inv_tran_serial_detail inv_xref inv_xref_230 inv_xref_741 inv_xref_supplier_info inv_xref_udf inventory_card inventory_defaults inventory_defaults_335 inventory_issues_audit inventory_issues_date_summary inventory_issues_document_summary inventory_issues_item_loc inventory_issues_item_table inventory_issues_return_row inventory_links inventory_receipt_location inventory_receipt_notepad inventory_receipts_hdr inventory_receipts_hdr_1348 inventory_receipts_line inventory_return_hdr inventory_return_hdr_notepad inventory_return_hdr_x_jc_job inventory_return_line inventory_return_line_notepad inventory_supplier inventory_supplier_1348 inventory_supplier_31 inventory_supplier_pricing inventory_supplier_x_loc inventory_supplier_x_uom inventoryissuesrebuilds InventoryIssuesResults1 InventoryIssuesResults10 InventoryIssuesResults11 InventoryIssuesResults12 InventoryIssuesResults13 InventoryIssuesResults14 InventoryIssuesResults15 InventoryIssuesResults16 InventoryIssuesResults17 InventoryIssuesResults18 InventoryIssuesResults19 InventoryIssuesResults2 InventoryIssuesResults20 InventoryIssuesResults21 InventoryIssuesResults22 InventoryIssuesResults23 InventoryIssuesResults24 InventoryIssuesResults25 InventoryIssuesResults26 InventoryIssuesResults27 InventoryIssuesResults28 InventoryIssuesResults29 InventoryIssuesResults3 InventoryIssuesResults30 InventoryIssuesResults31 InventoryIssuesResults32 InventoryIssuesResults33 InventoryIssuesResults34 InventoryIssuesResults35 InventoryIssuesResults36 InventoryIssuesResults37 InventoryIssuesResults38 InventoryIssuesResults39 InventoryIssuesResults4 InventoryIssuesResults40 InventoryIssuesResults41 InventoryIssuesResults42 InventoryIssuesResults43 InventoryIssuesResults44 InventoryIssuesResults45 InventoryIssuesResults46 InventoryIssuesResults47 InventoryIssuesResults48 InventoryIssuesResults49 InventoryIssuesResults5 InventoryIssuesResults50 InventoryIssuesResults51 InventoryIssuesResults52 InventoryIssuesResults53 InventoryIssuesResults54 InventoryIssuesResults55 InventoryIssuesResults56 InventoryIssuesResults6 inventoryissuesresults64 inventoryissuesresults65 inventoryissuesresults66 inventoryissuesresults67 inventoryissuesresults68 inventoryissuesresults69 InventoryIssuesResults7 InventoryIssuesResults8 InventoryIssuesResults9 InventoryIssuesRun InventoryIssuesRunItemLocation inventoryissuestest_x_rebuild InventoryIssuesTestDesc InventoryIssuesTestRunDetail InventoryIssuesTests invoice_batch invoice_class invoice_deletion_fk_info invoice_deletion_invoice_hdr invoice_deletion_oe_hdr invoice_hdr invoice_hdr_2164 invoice_hdr_220 invoice_hdr_asn invoice_hdr_customer_po invoice_hdr_freight_allowed invoice_hdr_installment invoice_hdr_not_delete invoice_hdr_notepad invoice_hdr_prelim_tracking invoice_hdr_salesrep invoice_hdr_signature invoice_hdr_x_tax_juris_manual invoice_line invoice_line_2164 invoice_line_235 invoice_line_notepad invoice_line_proration invoice_line_rewards invoice_line_salesrep invoice_line_taxes invoice_line_taxes_perunit invoice_types invoice_x_work_order IRS_1099_type iso_currency_code item_catalog item_catalog_def item_catalog_def_detail item_category item_category_hierarchy item_category_image item_category_link item_category_text item_category_x_class item_category_x_inv_mast item_commission_class item_commitment_detail item_commitment_hdr item_commitment_ship_to item_conversion item_id_change_history item_labor item_lead_time item_notepad item_package_type item_prefix_194 item_price_dts item_price_dts_criteria item_putaway_attribute item_revision item_service item_service_contract item_service_part_list item_uom item_warranty item_warranty_x_warranty item_warranty_x_warranty_reason ivref_counter jc_job job_based_commission job_control_hdr job_control_hdr_notepad job_control_line job_price_batch_hdr job_price_batch_line job_price_batch_line_x_employee job_price_bin job_price_bin_wurth job_price_cust_shipto_aggr job_price_cust_shipto_budget job_price_cust_shipto_csn job_price_cust_shipto_ordlim job_price_customer_shipto job_price_hdr job_price_hdr_148 job_price_hdr_budget_prd job_price_hdr_notepad job_price_line job_price_line_148 job_price_line_budget_code job_price_line_consign job_price_line_quote_info job_price_value job_price_vendor job_quote_line job_site job_site_notepad john_deere_invoice_info_10008 john_deere_order_info_10008 journal jurisdiction_acct jurisdiction_tax_is_taxable label_definition label_definition_x_customer label_definition_x_loc label_definition_x_ship_to labor labor_type labor_type_x_location labor_x_crew labor_x_region labor_x_skillset landed_cost_category landed_cost_category_x_company landed_cost_driver landed_cost_driver_tax landed_cost_driver_x_po_hdr language lc_driver_x_receipts_hdr lc_driver_x_tran lc_driver_x_tran_detail lead_source link_quantity list_temp loan loan_customer loan_item loan_item_extra loan_security_item loan_surcharge location location_allocation_info location_allocation_path location_form_template location_intercompany location_jurisdiction location_other_charge location_supplier location_supplier_194 location_supplier_aqnet location_terms location_workorder_info location_x_po_hdr lost_sales lost_sales_transaction lot lot_attr_x_lot_attr_grp lot_attribute lot_attribute_group lot_attribute_group_tran lot_attribute_value lot_bin_dealloc_report lot_bin_xref lot_shelf_life_audit_trail lot_x_lot_attribute_value mail_list manufacturer_program_type manufacturing_class master_inquiry_tab_default med_coup_cust_dtl_x_oe_hdr medical_coupon_customer_dtl medical_coupon_hdr medical_coupon_hdr_x_inv_mast message_foreign message_log messages mft_x_import_transaction minmax_selection_criteria module module_x_portal move_cost_criteria moving_avg_cost_history mru_window msp_deletion_process_x_transaction multiple_uom_receipt mymenu navigation_index needs_list_194 note note_area note_template_detail note_template_hdr note_x_company notepad_class nsp_smtp_mail_error_log oe_auxiliary_194 oe_contacts_customer oe_deletion_oe_hdr oe_hdr oe_hdr_15 oe_hdr_369 oe_hdr_additional_info oe_hdr_advance_billing oe_hdr_bss oe_hdr_cardlock oe_hdr_cc_freight_estimate oe_hdr_construction_info oe_hdr_fedex_info oe_hdr_fedex_info_detail oe_hdr_mfr oe_hdr_not_delete oe_hdr_notepad oe_hdr_order_cmp_pct oe_hdr_product_group oe_hdr_progress_billing oe_hdr_rma oe_hdr_salesrep oe_hdr_ship_location oe_hdr_shipserv oe_hdr_source_loc_override oe_hdr_tax oe_hdr_u_of_michigan oe_hdr_uom_conversion oe_hdr_work_order_info oe_hdr_x_price_library oe_line oe_line_1000 oe_line_194 oe_line_230 oe_line_235 oe_line_265 oe_line_523 oe_line_982 oe_line_bss oe_line_class oe_line_consignment oe_line_cost_code oe_line_dealer_commission oe_line_excise_tax oe_line_freight oe_line_hose_assembly oe_line_insurance oe_line_labor oe_line_last_margin_price oe_line_lot_billing oe_line_notepad oe_line_panel oe_line_pass_through oe_line_po oe_line_promise_date oe_line_quote_info_27 oe_line_rma oe_line_room oe_line_salesrep oe_line_schedule oe_line_secondary_rebate oe_line_serial oe_line_service oe_line_service_labor oe_line_service_labor_tax oe_line_service_labor_time oe_line_service_part oe_line_service_warranty oe_line_special_purchase oe_line_tax oe_line_valve oe_line_work_order oe_line_x_employee oe_location_carrier oe_pick_ticket oe_pick_ticket_consolidate oe_pick_ticket_detail oe_pick_ticket_detail_pkg oe_pick_ticket_detail_room oe_pick_ticket_freight_info oe_pick_ticket_package oe_pick_ticket_signature oe_pick_ticket_ups oe_schedule oe_schedule_detail operation opportunity opportunity_competitor opportunity_contact opportunity_list_temp opportunity_product_group opportunity_stage opportunity_status opportunity_step opportunity_type opportunity_x_order opportunity_x_room order_based_commission order_deletion_fk_info order_floor_plan_xref_10002 order_import_exception order_priority order_priority_threshold order_surcharge order_type_value ota_delivery outlook_error_log p21_dblevel p21_deletion_other_columns p21_deletion_sql p21_fulltext_catalog p21_fulltext_index_column p21_fulltext_index_table p21_inventory_issues_row p21_mapper_translation_table p21_number p21_rebuild_inv_tran_insert p21_unallocate_orders_bin_info p21_unallocate_orders_lot_bin_info p21_unallocate_orders_lot_info p21_unallocate_orders_order_line_info p21_unallocate_orders_order_line_schedule_info package package_type package_x_shipment pallet_hdr pallet_line passive_rebate_exclusion passive_rebate_hdr passive_rebate_level passive_rebate_line payable_group payment_1099_detail payment_account payment_account_x_contact payment_account_x_customer payment_account_x_ship_to payment_account_x_transaction payment_detail payment_detail_1348 payment_methods payment_types payment_types_335 payments pc_app_def pc_country pc_language_def pc_location_def pc_message_def pc_message_detail pc_outline pc_profile_def pc_seqctl pc_state pc_time_zone pc_user_def pc_version pc_window_def pda_oelist_criteria pda_oelist_hdr pda_oelist_item pda_oelist_shipto pdaship_delivery_data pdaship_pick_hdr_data pdaship_pick_line_data pdaship_rma_hdr_data pdaship_rma_line_data pdaship_stop_data pegmost_account pegmost_export_history pegmost_oe_hdr pending_alerts pending_import pending_payments periods pick_list_hdr pick_list_hdr_x_oe_pick_ticket pick_list_line pl_app_extend pl_collect_def pl_group_collect pl_group_def pl_group_object pl_object_collect pl_object_def pl_profile_group pl_user_collect pl_user_object pmt_type_x_comm_reduction po_acknowledgement po_acknowledgement_hdr po_acknowledgement_line po_asn_hdr po_asn_line po_deletion_po_hdr po_hdr po_hdr_not_delete po_hdr_notepad po_hdr_x_jc_job po_line po_line_108 po_line_27 po_line_721 po_line_delivery_info po_line_disputed_voucher po_line_notepad po_line_schedule po_line_vessel_6 po_receipt_voucher_194 po_schedule po_schedule_receipts po_schedule_rule pod_document_template pool_liner_info pool_liner_pattern pool_liner_process pool_liner_process_defaults pool_liner_processing pool_liner_slot pool_position pool_pricing_code pool_pricing_code_break pool_shape popup_column portal portal_assignment portal_element portal_param_def portal_param_value portal_user_defined portal_x_portal_element predefined_coa predefined_fin_rpt_row_x_acct preference price_book price_book_additional_info price_book_x_library price_book_x_location price_family price_family_x_restricted_class price_family_x_rewards_program price_library price_library_x_cust_x_cmpy price_override_exception price_page price_page_1266 price_page_custpart price_page_dealer_commission price_page_discgrp price_page_import_column price_page_import_dtl price_page_import_layout price_page_item price_page_po_cost_calc price_page_pricefam price_page_prodgrp price_page_secondary_rebate price_page_source price_page_suppdisc price_page_supplier price_page_suppmfg price_page_supppricefam price_page_suppprod price_page_type_x_company price_page_x_book price_source_x_company pricing_service_catalog pricing_service_code pricing_service_code_detail pricing_service_column pricing_service_conversion pricing_service_extension pricing_service_filter pricing_service_layout pricing_service_layout_detail pricing_service_layout_loc pricing_service_log pricing_service_map pricing_service_product_accts pricing_service_value pricing_service_value_detail pricing_template pricing_template_item_dflt pricing_template_key_field pricing_template_location pricing_template_location_dflt printer_detail printer_hdr printer_x_form problem_code problem_code_x_inv_mast proc_x_trans_det_x_po_hdr process process_notepad process_predefined_item process_x_trans_x_oe_line process_x_transaction process_x_transaction_detail process_x_transaction_not_delete process_x_transaction_note prod_group_strategic_hdr prod_group_strategic_line prod_line_component_labor prod_ord_comp_x_inv_adj prod_ord_hdr_not_delete prod_ord_line_compnt_x_oe_line prod_ord_line_po prod_order_deletion_prod_ord_hdr prod_order_hdr prod_order_line prod_order_line_comp_frght prod_order_line_comp_labor prod_order_line_component prod_order_line_link prod_order_line_process prod_order_print_info prod_pick_ticket_detail prod_pick_ticket_hdr prodord_tech_default_shift prodorder_calendar prodorder_labor prodorder_labor_proc_dtl prodorder_labor_proc_hdr prodorder_labor_rate prodorder_labor_schedule prodorder_shift prodorder_tech_x_labor prodorder_technician prodorder_work_center prodorder_work_day product_group product_group_direct_ship product_group_duplicate_order product_group_effective_days product_group_prc_ctrl_dtl product_group_prefix product_group_salesrep product_group_x_restricted_class product_group_x_rewards_program progress_billing_x_invoice_hdr prorate_reason_detail prorate_reason_hdr pt_dtl_bill_hold_bin purch_type purchase_acct_group_hdr purchase_acct_group_line purchase_class purchase_criteria purchase_price_library purchase_price_library_detail purchase_pricing_book purchase_pricing_page purchase_pricing_page_1266 purchase_transfer_group purchase_transfer_locations putaway_trace quality_code quarter quote_hdr quote_line reapplied_payment_line reason reason_code rebate_payments_detail rebate_receipts_detail rebill_invoice_reason receivable_group recur_apinv_hdr recur_apinv_line region region_x_branch remittances remittances_detail repair_sales_orders repair_sales_orders_history repair_transfers repeat_je report_code report_hdr report_parm report_presentation report_territory research_tracking_hdr research_tracking_line resource_monitor restricted_class reverse_payment_hdr reverse_payment_line revision_transaction rewards_program rf_found_item rf_terminal rf_terminal_inventory rma_receipt_hdr rma_receipt_line roles roles_portal roles_price_controls roles_x_activity room room_x_oe_hdr rounding_installment_10005 routeview_batch_dtl routeview_batch_hdr sales_calls sales_market_group sales_mgmt_criteria sales_pricing_option salesrep_comm_days_overdue salesrep_commission salesrep_commission_class salesrep_commission_split salesrep_inside salesrep_postalcode salesrep_quota salesrep_quota_detail salesrep_quota_period salesrep_quota_x_quarter salesrep_weboe salutation scheduled_impmst_addlpath_194 scheduled_import_def scheduled_import_details scheduled_import_master serial_number serial_number_extd_info serial_x_lot service_calendar service_center service_code service_cycle service_inv_mast service_inv_mast_part_list service_inv_mast_pm_sched service_inv_warranty service_inv_warranty_labor service_inv_warranty_part service_item_notepad service_labor service_labor_process_dtl service_labor_process_hdr service_labor_rate service_labor_schedule service_labor_x_tax_group_hdr service_order_priority service_plan service_pm_notice_msg service_signature service_technician service_technician_x_labor service_technician_x_service_center service_warranty service_warranty_claim service_warranty_item service_warranty_labor service_warranty_part shift ship_to ship_to_194 ship_to_2186 ship_to_335 ship_to_3rd_party_carriers_194 ship_to_blind_addressing ship_to_cardlock ship_to_credit ship_to_dea ship_to_finance_charge ship_to_freight_multiplier ship_to_geocom ship_to_gpo ship_to_item ship_to_jurisdiction ship_to_notepad ship_to_order_cmp_pct ship_to_packing_list ship_to_salesrep ship_to_salesrep_location ship_to_tax_exceptions ship_to_tax_exemption ship_to_tax_state_exempt shipment shipping_charges shipping_containers_hdr shipping_containers_line shipping_document_template shipping_group shipping_group_hdr shipping_group_line shipping_log shipping_package_type shipping_route shipping_route_day_range shipping_zone_hdr shipping_zone_line shipto_carrier shopper shopping_cart_allocation sic skillset spa_slots special_inv_layer special_inv_layer_tran stage stage_notepad stage_po_description_temp stage_x_process state state_alt_loc statement_frequency stop store_credit_hdr strat_price_factor_detail strat_price_factor_hdr strategic_pricing_invoice strategic_pricing_oe_info strategic_pricing_role summary_invoice_daily summary_invoice_monthly summary_po_loc_daily summary_po_loc_monthly summary_sales_daily summary_sales_monthly supplier supplier_1348 supplier_194 supplier_fascor_wms supplier_form_template supplier_item_conversion supplier_list_price supplier_lot supplier_nickname supplier_notepad supplier_po_disc_group supplier_pricing supplier_pricing_detail supplier_purchase_info supplier_x_restricted_class supplier_x_rewards_program supplier_zip_codes support_sql support_sql_column_detail system_alerts system_setting table_prog tag_created_from_rebuild_info tag_detail tag_document_line tag_hdr tag_hold_class tag_inv_tran_detail tag_inv_tran_hdr tag_picking_criteria task_area_x_user task_auxiliary_assignee task_auxiliary_contact tax_exempt_reason tax_group_hdr tax_group_hdr_zip tax_group_line tax_integration_error_log tax_juris_date_range tax_jurisdiction tax_jurisdiction_schedule technician_default_shift temp_credit_status temp_default_redo temp_distranet_export temp_distranet_info temp_distranet_zero_quantity temp_document_line_lot temp_inv_mast_nsync temp_inventory_rebuild_items temp_inventory_rebuild_periods temp_inventory_usage_rebuild temp_inventory_usage_rebuild_history temp_invoice_cost temp_invoice_summary temp_item_uom temp_job_price_hdr temp_jobsite_shipto_update temp_order_change_order_header temp_order_change_order_line temp_pick_ticket_cancel_audit temp_po_loc_summary temp_portal_assignment temp_portal_assignment_browser temp_rescale_document_line_bin temp_rescale_document_line_lot temp_rescale_document_line_lot_bin_xref temp_rescale_fifo_layer_transaction_cost temp_rescale_fifo_layer_transaction_quantity temp_rescale_fifo_layers_cost temp_rescale_fifo_layers_qty temp_rescale_inv_adj_line temp_rescale_inv_loc_cost temp_rescale_inv_loc_qty temp_rescale_inv_mast_purchase_pricing_unit temp_rescale_inv_mast_sales_pricing_unit temp_rescale_inv_period_usage temp_rescale_inv_tran_bin_detail temp_rescale_inv_tran_lot_detail temp_rescale_inventory_receipts_line_pricing_unit_size temp_rescale_inventory_receipts_line_unit_size temp_rescale_inventory_return_line_price_unit_size temp_rescale_inventory_return_line_qty temp_rescale_inventory_supplier_cost temp_rescale_inventory_supplier_list_price temp_rescale_invoice_line_pricing_unit_size temp_rescale_invoice_line_sales_unit_size temp_rescale_invoice_line_unit_price temp_rescale_item_uom temp_rescale_lot_cost temp_rescale_lot_qty temp_rescale_oe_line_pricing_unit_size temp_rescale_oe_line_schedule temp_rescale_oe_line_unit_price temp_rescale_oe_line_unit_size temp_rescale_oe_pick_ticket_detail temp_rescale_po_line_pricing_unit_size temp_rescale_po_line_unit_price temp_rescale_po_line_unit_size temp_rescale_prod_order_line temp_rescale_prod_order_line_component temp_rescale_transfer_line temp_rescale_uom temp_rescale_uom_history temp_rescale_uom_inv_tran temp_sales_summary temp_slab_bin_disable temp_tag_build_repair temp_tag_detail_info temp_tag_document_line_info temp_tag_hdr_info temp_tag_no_default temp_temp temp_upgrade_error temp_Webimage temp_weboe_customer_info temp_weboe_item_history_info Temp_WEBPROD Temp_WEBTABLE ten99_audit_trail ten99_balances term_x_language terms terms_user_defined_days terms_x_customer territory territory_grp territory_x_customer territory_x_ship_to territory_x_territory_grp test_data test_data_hdr test_data_segment token topic tpcx_dead_stock tpcx_disconnected_transaction tpcx_inbound_document tpcx_outbound_document tpcx_trading_partner tpw_sales_history_dtl tpw_sales_history_hdr trans_set_x_xml_dataobject transaction_charge transaction_set transfer_backorders transfer_bin_schedule transfer_bin_schedule_exception transfer_criteria transfer_days transfer_hdr transfer_hdr_notepad transfer_line transfer_line_notepad transfer_schedule_exception transfer_shipment_hdr transfer_shipment_line translation_term transportation_method tropic_addon tropic_cardex_po_eval tropic_cardex_setup tropic_lotbin tropic_lotbin_detail tropic_order_evaluation tropic_po_expedite tropic_po_gen_detail tropic_po_gen_hdr tropic_po_gen_item_note tropic_po_review unit unit_of_measure unit_of_measure_153 unit_x_udf user_authority user_configured_tabpage user_defined_column user_defined_field user_preference user_window_pref users users_crm users_portal users_x_application_security users_x_cash_drawer users_x_company users_x_location users_x_oe_line_panel value_list value_list_value valve_info valvoline_export_history vat_code vendor vendor_111 vendor_contract vendor_contract_hierarchy vendor_contract_type vendor_core_tracking vendor_defaults vendor_edi_setting vendor_edi_transaction vendor_edi_transaction_detail vendor_eft vendor_invoice_edi vendor_invoice_hdr vendor_invoice_line vendor_iva_tax vendor_notepad vendor_pass_through vendor_po_options vendor_purchase_acct vendor_rebate vendor_rfq_hdr vendor_rfq_hdr_x_oe_hdr vendor_rfq_hdr_x_po_hdr vendor_rfq_line vendor_rfq_line_analysis vendor_supplier vendor_vat vendor_vmi vendor_vmi_x_location vendor_wit version_code vessel_receipts_container vessel_receipts_hdr vessel_receipts_line vessel_receipts_repair vics_bill_of_lading vies_rpt voucher_class voucher_deletion_apinv_hdr voucher_purchase_acct warranty warranty_claim_detail warranty_claim_hdr warranty_claim_payments warranty_claim_receipts warranty_reason warranty_state_req web_display_type weboe_ar_transaction_data weboe_audit_trail_detail weboe_audit_trail_detail_history weboe_audit_trail_hdr weboe_audit_trail_hdr_history weboe_bcbi_data weboe_code weboe_cost_changes_data weboe_customer_contact_data weboe_customer_data weboe_customer_statistics_data weboe_file weboe_invoice_history_data weboe_item_category_data weboe_item_category_group_data weboe_item_data weboe_item_location_data weboe_item_pricebreaks_data weboe_items_on_backorder_data weboe_new_order_header_data weboe_new_order_line_data weboe_open_account_balance_data weboe_order_header_change_data weboe_order_line_change_data weboe_orders_on_credit_hold_data weboe_ship_to_data weboe_ship_to_unique weboe_stock_outs_data weboe_variable_data wee_tax_code week window_tab_navigation wireless_trans_audit_hdr wireless_trans_audit_line work_order work_order_audit_trail work_order_item work_order_labor work_order_notepad work_order_schedule work_order_type work_order_type_x_skillset work_order_type_x_udf work_order_unit_room work_order_x_labor_type work_order_x_unit work_order_x_unit_x_unit_udf workbench workbench_allocation_dflt workbench_query_hdr workbench_query_process workbench_query_prod workbench_query_pt workbench_query_replenishment workbench_query_transfer workbench_queue workbench_x_users wwms_in_process wwms_label_defaults wwms_loc_session_defaults wwms_receipt_defaults wzd_app_p21 wzd_prcs_sesn_state_p21 wzd_prcs_status_p21 wzd_prcs_x_wzd_sesn_p21 wzd_process_ext_p21 wzd_process_p21 wzd_session_p21 wzd_type_p21 xml_dataobject xml_dataobject_column xml_dataobject_x_config xml_document xml_document_element xml_stylesheet year_control zip_code zip_code_local    Search Data Dictionary What to Search   How to Search   Search String   Everything Table Name Table Description Column Name Column Description Stored Procedures Triggers Views Functions   Contains Equals Begins With Ends With

Database Version: 12.6.770