sys_config.sql 6.34 KB
INSERT INTO `sys_config` (`id`, `configName`, `configKey`, `configValue`, `configType`, `remark`, `createBy`, `createTime`, `updateBy`, `updateTime`) VALUES (16, '物料——过滤参数', 'material_FilterString', 'fdocumentStatus=\'C\' and FUseOrgId.FNumber=\'102\' and FForbidStatus=\'A\' and FMaterialGroup.Fnumber like \'2%\'', 'Y', 'fdocumentStatus 审核状态 FForbidStatus 是否禁用 FUseOrgId.FNumber 使用组织 FMaterialGroup.Fnumber 物料分类匹配物料', 'tzh', '2022-08-22 10:37:59', 'tzh', '2022-08-22 11:13:18');
INSERT INTO `sys_config` (`id`, `configName`, `configKey`, `configValue`, `configType`, `remark`, `createBy`, `createTime`, `updateBy`, `updateTime`) VALUES (17, '客户——过滤参数', 'customer_FilterString', 'fdocumentStatus=\'C\' and FUseOrgId.FNumber=\'102\' and FForbidStatus=\'A\'', 'Y', 'fdocumentStatus 审核状态 FForbidStatus 是否禁用 FUseOrgId.FNumber 使用组织', 'tzh', '2022-08-22 10:39:11', 'tzh', '2022-08-22 10:41:27');
INSERT INTO `sys_config` (`id`, `configName`, `configKey`, `configValue`, `configType`, `remark`, `createBy`, `createTime`, `updateBy`, `updateTime`) VALUES (18, '用户——过滤参数', 'user_FilterString', 'fdocumentStatus=\'C\' and FUseOrgId.FNumber=\'102\' and FForbidStatus=\'A\'', 'Y', 'fdocumentStatus 审核状态 FForbidStatus 是否禁用 FUseOrgId.FNumber 使用组织', 'tzh', '2022-08-22 10:39:48', 'tzh', '2022-08-22 10:40:57');
INSERT INTO `sys_config` (`id`, `configName`, `configKey`, `configValue`, `configType`, `remark`, `createBy`, `createTime`, `updateBy`, `updateTime`) VALUES (19, '部门——过滤参数', 'dept_FilterString', 'fdocumentStatus=\'C\'\' and FUseOrgId.FNumber=\'102\' and FForbidStatus=\'A\'', 'Y', 'fdocumentStatus 审核状态 FForbidStatus 是否禁用 FUseOrgId.FNumber 使用组织', 'tzh', '2022-08-22 10:40:44', '', NULL);
INSERT INTO `sys_config` (`id`, `configName`, `configKey`, `configValue`, `configType`, `remark`, `createBy`, `createTime`, `updateBy`, `updateTime`) VALUES (20, '产品包装——过滤参数', 'proPackaging_FilterString', 'fdocumentStatus=\'C\' and FUseOrgId.FNumber=\'101\' and FForbidStatus=\'A\'', 'Y', 'fdocumentStatus 审核状态 FForbidStatus 是否禁用 FUseOrgId.FNumber 使用组织', 'tzh', '2022-08-22 10:42:30', '', NULL);
INSERT INTO `sys_config` (`id`, `configName`, `configKey`, `configValue`, `configType`, `remark`, `createBy`, `createTime`, `updateBy`, `updateTime`) VALUES (21, '产品尺寸——过滤参数', 'productSize_FilterString', 'fdocumentStatus=\'C\' and FForbidStatus=\'A\' and FUseOrgId.FNumber=\'100\'', 'Y', 'fdocumentStatus 审核状态 FForbidStatus 是否禁用 FUseOrgId.FNumber 使用组织', 'tzh', '2022-08-22 10:43:17', '', NULL);
INSERT INTO `sys_config` (`id`, `configName`, `configKey`, `configValue`, `configType`, `remark`, `createBy`, `createTime`, `updateBy`, `updateTime`) VALUES (22, '仓位——过滤参数', 'flexValues_FilterString', 'fdocumentStatus=\'C\' and FUseOrgId.FNumber=\'101\' and FForbidStatus=\'A\'', 'Y', 'fdocumentStatus 审核状态 FForbidStatus 是否禁用 FUseOrgId.FNumber 使用组织', 'tzh', '2022-08-22 10:46:49', '', NULL);
INSERT INTO `sys_config` (`id`, `configName`, `configKey`, `configValue`, `configType`, `remark`, `createBy`, `createTime`, `updateBy`, `updateTime`) VALUES (23, '仓库——过滤参数', 'stock_FilterString', 'fdocumentStatus=\'C\' and FUseOrgId.FNumber=\'102\' and FForbidStatus=\'A\'', 'Y', 'fdocumentStatus 审核状态 FForbidStatus 是否禁用 FUseOrgId.FNumber 使用组织', 'tzh', '2022-08-22 10:47:49', 'tzh', '2022-08-22 11:05:12');
INSERT INTO `sys_config` (`id`, `configName`, `configKey`, `configValue`, `configType`, `remark`, `createBy`, `createTime`, `updateBy`, `updateTime`) VALUES (24, '排除计划——过滤参数', 'productSchedule_FilterString', 'fdocumentStatus=\'C\' and FForbidStatus=\'A\' and F_CH_IsClose=0 and FCreateOrgId.Fnumber=\'100\'', 'Y', 'fdocumentStatus 审核状态 FCloseStatus 启用状态 F_CH_IsClose 是否关闭 FCreateOrgId.Fnumber 创建组织', 'tzh', '2022-08-22 10:48:46', 'tzh', '2022-08-22 11:03:44');
INSERT INTO `sys_config` (`id`, `configName`, `configKey`, `configValue`, `configType`, `remark`, `createBy`, `createTime`, `updateBy`, `updateTime`) VALUES (25, '单位——过滤参数', 'unit_FilterString', 'FDocumentStatus=\'C\' and FForbidStatus=\'A\'', 'Y', 'fdocumentStatus 审核状态 FCloseStatus 启用状态', 'tzh', '2022-08-22 10:49:49', 'tzh', '2022-08-22 11:02:43');
INSERT INTO `sys_config` (`id`, `configName`, `configKey`, `configValue`, `configType`, `remark`, `createBy`, `createTime`, `updateBy`, `updateTime`) VALUES (26, '辅助属性——过滤参数', 'bosAssistantDetail_FilterString', 'fdocumentStatus=\'C\' and FForbidStatus=\'A\' and FId.FNumber in (\'level\',\'colour\',\'QTCKLX\',\'QTRKLX\',\'SCLLLX\')', 'Y', 'fdocumentStatus 审核状态 FCloseStatus 启用状态 FId.FNumber 辅助属性 key', 'tzh', '2022-08-22 10:54:57', 'tzh', '2022-08-22 11:02:27');
INSERT INTO `sys_config` (`id`, `configName`, `configKey`, `configValue`, `configType`, `remark`, `createBy`, `createTime`, `updateBy`, `updateTime`) VALUES (27, '出库申请单——过滤参数', 'shipmentRequest_FilterString', 'fdocumentStatus=\'C\' and FCloseStatus=\'A\' and FStockOrgId.FNumber=\'102\'', 'Y', 'fdocumentStatus 审核状态 FCloseStatus 启用状态 FStockOrgId.FNumber 发货仓库组织', 'tzh', '2022-08-22 10:55:38', 'tzh', '2022-08-22 11:01:19');
INSERT INTO `sys_config` (`id`, `configName`, `configKey`, `configValue`, `configType`, `remark`, `createBy`, `createTime`, `updateBy`, `updateTime`) VALUES (28, '发货通知单——过滤参数', 'deliveryNotice_FilterString', 'fdocumentStatus=\'C\'  and FCloseStatus=\'A\' and FDeliveryOrgID.FNumber=\'102\' and FstockId.FNumber=\'CK003\'', 'Y', 'fdocumentStatus 审核状态 FCloseStatus 启用状态 FDeliveryOrgID.FNumber 发货组织', 'tzh', '2022-08-22 10:56:33', 'tzh', '2022-08-22 11:50:48');
INSERT INTO `sys_config` (`id`, `configName`, `configKey`, `configValue`, `configType`, `remark`, `createBy`, `createTime`, `updateBy`, `updateTime`) VALUES (29, '退货通知单——过滤参数', 'returnNotice_FilterString', 'fdocumentStatus=\'C\' and FCloseStatus=\'A\' and FRetorgId.FNumber=\'102\'', 'Y', 'fdocumentStatus 审核状态 FCloseStatus 启用状态 FRetorgId.FNumber 退货组织', 'tzh', '2022-08-22 10:58:15', 'tzh', '2022-08-22 10:59:40');