guomao/DOC/DB/01_data/sequence_data.sql

#系统通用
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','');