* id cust_id cust_name cust_short_name cust_type cust_level industry main_contact_name main_contact_phone main_contact_email business_license tax_number sales_person sales_team cust_sta is_active cust_memo requirements create_date create_by last_modify_date last_modify_by tag_id

* id cust_id addr_type is_default contact_person contact_phone country province city district street detail_address postal_code addr_memo sort_order is_active create_date last_modify_date

* id cust_id contact_type is_primary name gender position department phone mobile email fax qq wechat birthday hobby remarks sort_order is_active create_date create_by last_modify_date

* id so_no cust_id address_id order_date delivery_date so_status total_amount currency sales_person remark created_at updated_at

* id so_no item_sn line_no item_id item_name item_material item_drawing item_spec surface quantity unit unit_price amount delivery_date remark is_active created_at updated_at

* id so_no line_no term_type term_title term_content term_order version is_active is_latest change_reason effective_date created_at updated_at created_by updated_by

* id address_id source_type cust_id vend_id addr_type is_default contact_person contact_phone country province city district detail_address postal_code addr_memo sort_order is_active create_date last_modify_date

* id item_id item_name item_part_no item_material item_drawing heat_spec surface net_weight item_spec item_model item_brand class_id class_code item_type unit unit_purchase unit_sales conversion_rate cost_price sales_price last_purchase_price current_stock min_stock max_stock safe_stock warehouse_location shelf_no main_vendor_id main_vendor_name quality_level quality_status item_sta is_active has_bom parent_item_id parent_item_name bom_level item_desc remark item_image create_date create_by last_modify_date last_modify_by ext_field1 ext_field2 ext_field3

* id class_code class_name parent_code level path sort_order is_active class_desc is_sales_enabled create_date create_by

* id vend_id vend_name vend_short_name vend_type vend_level industry main_contact main_phone main_email business_license tax_number bank_name bank_account cooperation_years credit_rating payment_terms delivery_terms purchaser source vend_sta is_active vend_memo cooperation_history quality_notes create_date create_by last_modify_date last_modify_by tag_id

* id vend_id addr_type is_default contact_person contact_phone country province city district detail_address postal_code addr_memo sort_order is_active create_date last_modify_date

* id vend_id contact_type is_primary name gender position department phone mobile email fax qq wechat birthday remarks sort_order is_active create_date create_by last_modify_date

* id dict_class dict_class_desc dict_code dict_desc dict_order is_default is_active parent_code remark create_date create_by last_modify_date last_modify_by

* id logid username password full_name email phone mobile mb_limit mb_comid mb_link_str department position is_active is_locked last_login_time last_login_ip login_count last_password_change create_date create_by last_modify_date last_modify_by remark

* id module_name module_desc module_level module_class module_sta module_link use_count remark create_date create_by last_modify_date last_modify_by

* cust_id contact_person contact_phone detail_address

选择表 crm_customer crm_customer_address crm_customer_contact crm_sales_order crm_sales_order_item crm_sales_order_terms scm_address scm_item scm_item_class scm_vendor scm_vendor_address scm_vendor_contact sys_dictionary sys_member sys_module v_customer_main_contact . 选择字段
显示

条件

排序	递增	递减
添加为	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	文字 另一个字段
	选择表 crm_customer crm_customer_address crm_customer_contact crm_sales_order crm_sales_order_item crm_sales_order_terms scm_address scm_item scm_item_class scm_vendor scm_vendor_address scm_vendor_contact sys_dictionary sys_member sys_module v_customer_main_contact .	选择字段