#系统通用 insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('IM_LOG_NO','100000','1','100000','99999999',''); insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('IM_USER_NO','100000','1','100000','99999999',''); insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('IM_ROLE_NO','100000','1','100000','99999999',''); insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('IM_BRANCH_NO','100000','1','100000','99999999',''); insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_CONTRACT_INF_ID','100000','1','100000','99999999',''); insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_CONTRACT_DETAIL_ID','100000','1','100000','99999999',''); /**客户管理*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_CUSTOMER_INF_ID','100000','1','100000','99999999',''); /**客户联系人管理*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_CONTACT_ID','100000','1','100000','99999999',''); /**客户地址管理*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_ADDRESS_ID','100000','1','100000','99999999',''); /**客户账户管理*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_ACCOUNT_INFORMATION_ID','100000','1','100000','99999999',''); /**数字词典**/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_DICTIONARY_ID','100000','1','100000','99999999',''); /**价格维护*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_PRICE_INF_ID','100000','1','100000','99999999',''); /**信息管理*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_ARTICLE_INF_ID','100000','1','100000','99999999',''); /**资源表id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_FILE_ID','100000','1','100000','99999999',''); /**页面管理*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('ANI_ID','100000','1','100000','99999999',''); insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AND_ID','100000','1','100000','99999999',''); /**品牌主键*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_BRAND_INF_ID','100000','1','100000','99999999',''); /**商品主键*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_PRODUCT_INF_ID','100000','1','100000','99999999',''); /**规格主键*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_SPEC_NO','100000','1','100000','99999999',''); /**商品分类主键*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_CATEGORY_INF_ID','100000','1','100000','99999999',''); /**计划信息Id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_PLAN_INF','100000','1','100000','99999999',''); /**计划详情Id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_PLAN_DETAIL','100000','1','100000','99999999',''); /**计划上报Id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_PLAN_REPORT','100000','1','100000','99999999',''); /** 执行流程记录表ID */ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('IM_FLOW_INF_ID','1000000000','1','1000000000','99999999999',''); /** 消息记录表ID */ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('PUB_MSG_INF_ID','1000000000','1','1000000000','99999999999',''); /** 消息日志表ID */ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('IM_FLOW_LOG_ID','1000000000','1','1000000000','99999999999',''); /**仓库Id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_WAREHOUSE_ID','1000000000','1','1000000000','99999999999',''); /**仓库合同编号*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_WA_CONTRACT_ID','1000000000','1','1000000000','99999999999',''); /**仓库合同详情编号*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_WA_CONTR_DETAIL_ID','1000000000','1','1000000000','99999999999',''); /**仓库结算费用编号*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_WA_SETTLECOST','1000000000','1','1000000000','99999999999',''); /**商品部门关联id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_PRODUCT_BRANCH_ID','1000000000','1','1000000000','99999999999',''); /**订单id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_ORDER_ID','1000000000','1','1000000000','99999999999',''); /**出入库流水*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('PUT_STOCK_ID','1000000000','1','1000000000','99999999999',''); /**仓单号*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('WH_RECEIPT_ID','1000000000','1','1000000000','99999999999',''); /**仓储日志编号*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('WH_LOG_ID','1000000000','1','1000000000','99999999999',''); /**流程设置编号*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('FLOW_SET_ID','1000000000','1','1000000000','99999999999',''); /**合同模板id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('ACM_ID','htmb1000000000','1','1000000000','99999999999',''); insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('ACM_RELATE_ID','1000000000','1','1000000000','99999999999',''); /**物流id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_LOGISTICS_ID','1000000000','1','1000000000','99999999999',''); /**物流进度id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_LOGISTICS_DETAIL_ID','1000000000','1','1000000000','99999999999',''); /**费用详情id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('WH_COST_ID','1000000000','1','1000000000','99999999999',''); /**发票id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_INVOICE_ID','1000000000','1','1000000000','99999999999',''); /**铝发票id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_LV_INVOICE_ID','1000000000','1','1000000000','99999999999',''); /**客户信用id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('CREDIT_ID','1000000000','1','1000000000','99999999999',''); /**客户信用详情id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('CREDIT_DETAIL_ID','1000000000','1','1000000000','99999999999',''); /**手机端用户id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_PERSON_INF_NO','1000000000','1','1000000000','99999999999',''); /**收付款编号id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AOP_ID','1000000000','1','1000000000','99999999999',''); /**收付款详情编号id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AOPD_ID','1000000000','1','1000000000','99999999999',''); /**附加信息id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AMI_ID','1000000000','1','1000000000','99999999999',''); /**扫描发票id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('ASI_ID','1000000000','1','1000000000','99999999999',''); /**扫描发票详情id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AID_ID','1000000000','1','1000000000','99999999999',''); /**数据迁移生成新id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('NEWID_ID','1000000000','1','1000000000','99999999999',''); /**出入库发票关联Id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('ARI_ID','1000000000','1','1000000000','99999999999',''); /**出入库统计Id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AWT_ID','1000000000','1','1000000000','99999999999',''); /** 出入库汇总表 统计 */ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('Ap_warehouse_total_id','1000000000','1','1000000000','99999999999',''); /** 订单发票详情Id */ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AOID_ID','1000000000','1','1000000000','99999999999',''); /** 发票汇总表 */ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('ap_invoice_total_id','1000000000','1','1000000000','99999999999',''); /**库存总表*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('ap_warestock_id','1000000000','1','1000000000','99999999999',''); /**发出量报表*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_Giveout_id','1000000000','1','1000000000','99999999999',''); /**库存日明细报表*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_wareday_id','1000000000','1','1000000000','99999999999',''); /**预付款表id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_ADVANCE_ID','1000000000','1','1000000000','99999999999',''); /**预付款详情id*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_ADVANCE_DEL_ID','1000000000','1','1000000000','99999999999',''); /**厂内库存新增*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_PLANT_INVENTORY','1000000000','1','1000000000','99999999999',''); /**合同计划*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_CONTRACT_PLAN','1000000000','1','1000000000','99999999999',''); insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_EXPENSE_STATEMENT','1000000000','1','1000000000','99999999999',''); insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_RECORD_ID','1000000000','1','1000000000','99999999999',''); insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_ENCLOSURE_ID','1000000000','1','1000000000','99999999999',''); /**入库单*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('ap_finance_id','1000000000','1','1000000000','99999999999',''); /**公司费率*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_COMPANY_RATE_ID','1000000000','1','1000000000','99999999999',''); /**利息*/ insert into sequence (SEQ_NAME, CURRENT_VAL, INCREMENT_VAL, MIN_VAL, MAX_VAL,REMARKS) values('AP_INTEREST_ID','1000000000','1','1000000000','99999999999','');