数据:insert into m_pattern_0105_001(version,original_store_code,apply_start_date,apply_end_date,pattern_type,pattern_code,update_datetime,update_function_id,update_person_id,update_count) values
('0105_001','1234567890','2024/02/20','2024/02/20','1','1','2024/02/27','1','1',1); insert into m_item_0226_001(version,item_code,shipment,pattern_type,pattern_code,apply_start_date,apply_end_date,order_start_date,order_end_date,vendor_code,pma_code,information_category_code,subcategory_code,item_name,pos_item_name,maker_code,license_code,quantity,particular_type,tax_type,indefinite_type,marketprice_item_type,magazine_period_revised_type,magazine_store_information_output,special_order_item_type,reserve_item_type,sales_report_separation_type,consigned_item_type,item_size_width,item_size_height,item_size_depth,item_rank,specific_item_type,matrix_vertical_code,host_cycle_code,store_cycle_code,lead_time,common_delivery_code,label_code,order_unit,order_limit_quantity,minimum_order_quantity,cost_unit_price,recommendation_sales_price,gp,quantity_cost_price,quantity_sales_price,keyff_number,small_keyff_number,monday_no_delivery,tuesday_no_delivery,wednesday_no_delivery,thursday_no_delivery,friday_no_delivery,saturday_no_delivery,sunday_no_delivery,freshness_management_type,delivery_freshness,sales_freshness,date_quantity_unit,freshness_over_time_type,instore_aggregate_flag,date_type,addition_order_type,revised_order_type,price_change_unnecessary_flag,distribution_separation_type,return_permission_type,magazine_type,cut_reason_code,price_change_reason_code,image_discrimination_code,payment_status,pricing_status,misc_status,forced_content_apply_date,order_code,pattern_apply_date,prepaidcard_payment_status,item_tax_rate,pos_image_discrimination_code,point_excluded_flag,price_sticker_output_type,leaflet_print_permission_type,recommendation_reason_discrimination_code,payment_status_old,internet_item_type,recommendation_item_category_type,dutyfree_type,payment_status_2,stockout_permission_flag,delivery_start_date,first_delivery_end_date,disaster_common_delivery_type_code,serial_number_scan_type,update_datetime,update_function_id,update_person_id,update_count) values
('0226_001','01','1','1','1','2024/02/20','2024/02/20','2024/02/27','2024/02/27','12345','12','1234','2','123456789','1','1','1',1,'1','1','1','1','1','1','1','1','1','1',1,1,1,'1','1','1','1','1','1','1','9999999999999',1,1,1,1,100,1,201,1,'1','1','1','1','1','1','1','1','1','1',1,1,'1','1','1','1','1','1','1','1','1','1','1','1','1',1,1,1,'2024/02/27','1','2024/02/27','1','1','1','1','1','1','1','1','1','1','1','1','1','2024/02/27','2024/02/27','1','1','2024/02/27','1','1',1)
, ('0226_001','01','1','2','1','2024/02/27','2024/02/27','2024/02/27','2024/02/27','12345','12','1234','1','123456788','123','1','1',0,'1','1','1','1','1','1','1','1','1','1',0,0,0,'1','1','1','1','1','1','1','9999999999999',0,0,0,0,100,0,200,0,'1','1','1','1','1','1','1','1','1','1',0,0,'1','1','1','1','1','1','1','1','1','1','1','1','1',0,0,0,'2024/02/27',' ','2024/02/27','1','1','1','1','1','1','1','1','1','1','1','1','1','2024/02/27','2024/02/27','1','1','2024/02/27','1','1',0); insert into m_vendor_name_0226_001(version,vendor_code,vendor_short_code,vendor_name,update_datetime,update_function_id,update_person_id,update_count) values
('0226_001','12345','321','123457890','2024/02/27','1','1',1)
, ('0226_001','12346','123','123457890','2024/02/27','1','1',1); version pma_code information_category_code subcategory_code subcategory_name subcategory_display_order apply_start_date apply_end_date update_datetime update_function_id update_person_id update_count
0226_001 12 1234 1 54321 1 2024/01/27 2024/02/27 2024/02/27 0:00:00 1 1 1
0226_001 12 1234 2 12345 1 2024/01/27 2024/02/27 2024/02/27 0:00:00 1 1 1
最新发布