LZY'Blog

记录LZY的生活、行程!

« 【工作笔记】成本分析报表人工统计之系统账号权限设置方式【工作笔记】成本分析报表大昶ERP数据统计规则 »

【工作笔记】成本分析报表昶宝ERP数据统计规则

一、部门名称

  1. 镁铝成型

  2. CNC

  3. 手工化成

  4. 涂装喷漆

  5. 涂装组立

二、项目类别

  1. 主营业务收入(USD)

  2. 耗用半成品(USD)

  3. 耗用镁粒

  4. 耗用塑胶粒

  5. 耗用辅料

  6. 耗用涂料

  7. 耗用其它(含包材)

二、费用按部门及项目统计规则

部门名称 项目类别 计算方法 ERP事务记录中数量统计筛选条件
镁铝成型 主营业务收入(USD) 产品入库数量
*
物料号核价
1)事务类型仅限于加工单入库
 (tr_type='rct-wo')
2)工单号第3位部门代码为1,工单类型包括:正常工单、试产工单和重工工单
 (tr_nbr like 'WO1%' or tr_nbr like 'WP1%' or tr_nbr like 'WR1%')
3)排除治具类工单入库
 (substring(tr_nbr,6,3)<>'ZJ0')
4)排除CNC、手工和化成报废库位入库记录
 (tr_loc<>'X2C02' and tr_loc<>'X2CP2' and tr_loc<>'X2G02' and tr_loc<>'X2GP2' and tr_loc<>'X2H02' and tr_loc<>'X2HP2')
5)物料类型代码首位为1或2
 (pt_part_type like '1%' or pt_part_type like '2%')
CNC 1)事务类型仅限于加工单入库
 (tr_type='rct-wo')
2)工单号第3位部门代码为2,工单类型包括:正常工单、试产工单和重工工单
 (tr_nbr like 'WO2%' or tr_nbr like 'WP2%' or tr_nbr like 'WR2%')
3)排除治具类工单入库
 (substring(tr_nbr,6,3)<>'ZJ0')
4)排除CNC、手工和化成报废库位入库记录
 (tr_loc<>'X2C02' and tr_loc<>'X2CP2' and tr_loc<>'X2G02' and tr_loc<>'X2GP2' and tr_loc<>'X2H02' and tr_loc<>'X2HP2')
5)物料类型代码首位为1或2
 (pt_part_type like '1%' or pt_part_type like '2%')
手工化成 1)事务类型仅限于加工单入库
 (tr_type='rct-wo')
2)工单号第3位部门代码为3或4,工单类型包括:正常工单、试产工单和重工工单
 (tr_nbr like 'WO3%' or tr_nbr like 'WP3%' or tr_nbr like 'WR3%' or tr_nbr like 'WO4%' or tr_nbr like 'WP4%' or tr_nbr like 'WR4%')
3)排除治具类工单入库
 (substring(tr_nbr,6,3)<>'ZJ0')
4)排除CNC、手工和化成报废库位入库记录
 (tr_loc<>'X2C02' and tr_loc<>'X2CP2' and tr_loc<>'X2G02' and tr_loc<>'X2GP2' and tr_loc<>'X2H02' and tr_loc<>'X2HP2')
5)物料类型代码首位为1或2
 (pt_part_type like '1%' or pt_part_type like '2%')
涂装喷漆 1)事务类型仅限于加工单入库
 (tr_type='rct-wo')
2)工单号第3位部门代码为5,工单类型包括:正常工单、试产工单和重工工单
 (tr_nbr like 'WO5%' or tr_nbr like 'WP5%' or tr_nbr like 'WR5%')
3)排除治具类工单入库
 (substring(tr_nbr,6,3)<>'ZJ0')
4)排除CNC、手工和化成报废库位入库记录
 (tr_loc<>'X2C02' and tr_loc<>'X2CP2' and tr_loc<>'X2G02' and tr_loc<>'X2GP2' and tr_loc<>'X2H02' and tr_loc<>'X2HP2')
5)物料类型代码首位为1或2
 (pt_part_type like '1%' or pt_part_type like '2%')
涂装组立 1)事务类型仅限于加工单入库
 (tr_type='rct-wo')
2)工单号第3位部门代码为6,工单类型包括:正常工单、试产工单和重工工单
 (tr_nbr like 'WO6%' or tr_nbr like 'WP6%' or tr_nbr like 'WR6%')
3)排除治具类工单入库
 (substring(tr_nbr,6,3)<>'ZJ0')
4)排除CNC、手工和化成报废库位入库记录
 (tr_loc<>'X2C02' and tr_loc<>'X2CP2' and tr_loc<>'X2G02' and tr_loc<>'X2GP2' and tr_loc<>'X2H02' and tr_loc<>'X2HP2')
5)物料类型代码首位为1或2
 (pt_part_type like '1%' or pt_part_type like '2%')
镁铝成型 耗用半成品(USD) 产品领用数量
*
物料号核价
1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为1,工单类型包括:正常工单、试产工单和重工工单
 (tr_nbr like 'WO1%' or tr_nbr like 'WP1%' or tr_nbr like 'WR1%')
3)排除治具类工单发料
 (substring(tr_nbr,6,3)<>'ZJ0')
4)排除CNC、手工和化成报废库位领用记录
 (tr_loc<>'X2C02' and tr_loc<>'X2CP2' and tr_loc<>'X2G02' and tr_loc<>'X2GP2' and tr_loc<>'X2H02' and tr_loc<>'X2HP2')
5)物料类型代码首位为1或2
 (pt_part_type like '1%' or pt_part_type like '2%')
CNC 1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为2,工单类型包括:正常工单、试产工单和重工工单
 (tr_nbr like 'WO2%' or tr_nbr like 'WP2%' or tr_nbr like 'WR2%')
3)排除治具类工单发料
 (substring(tr_nbr,6,3)<>'ZJ0')
4)排除CNC、手工和化成报废库位领用记录
 (tr_loc<>'X2C02' and tr_loc<>'X2CP2' and tr_loc<>'X2G02' and tr_loc<>'X2GP2' and tr_loc<>'X2H02' and tr_loc<>'X2HP2')
5)物料类型代码首位为1或2
 (pt_part_type like '1%' or pt_part_type like '2%')
手工化成 1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为3或4,工单类型包括:正常工单、试产工单和重工工单
 (tr_nbr like 'WO3%' or tr_nbr like 'WP3%' or tr_nbr like 'WR3%' or tr_nbr like 'WO4%' or tr_nbr like 'WP4%' or tr_nbr like 'WR4%')
3)排除治具类工单发料
 (substring(tr_nbr,6,3)<>'ZJ0')
4)排除CNC、手工和化成报废库位领用记录
 (tr_loc<>'X2C02' and tr_loc<>'X2CP2' and tr_loc<>'X2G02' and tr_loc<>'X2GP2' and tr_loc<>'X2H02' and tr_loc<>'X2HP2')
5)物料类型代码首位为1或2
 (pt_part_type like '1%' or pt_part_type like '2%')
涂装喷漆 1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为5,工单类型包括:正常工单、试产工单和重工工单
 (tr_nbr like 'WO5%' or tr_nbr like 'WP5%' or tr_nbr like 'WR5%')
3)排除治具类工单发料
 (substring(tr_nbr,6,3)<>'ZJ0')
4)排除CNC、手工和化成报废库位领用记录
 (tr_loc<>'X2C02' and tr_loc<>'X2CP2' and tr_loc<>'X2G02' and tr_loc<>'X2GP2' and tr_loc<>'X2H02' and tr_loc<>'X2HP2')
5)物料类型代码首位为1或2
 (pt_part_type like '1%' or pt_part_type like '2%')
涂装组立 1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为6,工单类型包括:正常工单、试产工单和重工工单
 (tr_nbr like 'WO6%' or tr_nbr like 'WP6%' or tr_nbr like 'WR6%')
3)排除治具类工单发料
 (substring(tr_nbr,6,3)<>'ZJ0')
4)排除CNC、手工和化成报废库位领用记录
 (tr_loc<>'X2C02' and tr_loc<>'X2CP2' and tr_loc<>'X2G02' and tr_loc<>'X2GP2' and tr_loc<>'X2H02' and tr_loc<>'X2HP2')
5)物料类型代码首位为1或2
 (pt_part_type like '1%' or pt_part_type like '2%')
镁铝成型 耗用镁粒 镁粒领用数量
*
物料号未税采购价格
1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为1,工单类型包括:正常工单、试产工单
 (tr_nbr like 'WO1%' or tr_nbr like 'WP1%')
3)排除委外加工镁原料发料、其它采购镁原料不良品、炉喷报废料
 (tr_loc<>'X3M01' and tr_loc<>'X3MQ2' and tr_loc<>'X3MQ3')
4)物料类型代码为3M
 (pt_part_type='3M')
CNC 1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为2,工单类型包括:正常工单、试产工单
 (tr_nbr like 'WO2%' or tr_nbr like 'WP2%')
3)排除委外加工镁原料发料、其它采购镁原料不良品、炉喷报废料
 (tr_loc<>'X3M01' and tr_loc<>'X3MQ2' and tr_loc<>'X3MQ3')
4)物料类型代码为3M
 (pt_part_type='3M')
手工化成 1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为3或4,工单类型包括:正常工单、试产工单
 (tr_nbr like 'WO3%' or tr_nbr like 'WP3%' or tr_nbr like 'WO4%' or tr_nbr like 'WP4%')
3)排除委外加工镁原料发料、其它采购镁原料不良品、炉喷报废料
 (tr_loc<>'X3M01' and tr_loc<>'X3MQ2' and tr_loc<>'X3MQ3')
4)物料类型代码为3M
 (pt_part_type='3M')
涂装喷漆 1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为5,工单类型包括:正常工单、试产工单
 (tr_nbr like 'WO5%' or tr_nbr like 'WP5%')
3)排除委外加工镁原料发料、其它采购镁原料不良品、炉喷报废料
 (tr_loc<>'X3M01' and tr_loc<>'X3MQ2' and tr_loc<>'X3MQ3')
4)物料类型代码为3M
 (pt_part_type='3M')
涂装组立 1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为6,工单类型包括:正常工单、试产工单
 (tr_nbr like 'WO6%' or tr_nbr like 'WP6%')
3)排除委外加工镁原料发料、其它采购镁原料不良品、炉喷报废料
 (tr_loc<>'X3M01' and tr_loc<>'X3MQ2' and tr_loc<>'X3MQ3')
4)物料类型代码为3M
 (pt_part_type='3M')
镁铝成型 耗用塑胶粒 塑胶粒领用数量
*
物料号未税采购价格
1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为1,工单类型包括:正常工单、试产工单
 (tr_nbr like 'WO1%' or tr_nbr like 'WP1%')
3)物料类型代码为3S
 (pt_part_type='3S')
CNC 1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为2,工单类型包括:正常工单、试产工单
 (tr_nbr like 'WO2%' or tr_nbr like 'WP2%')
3)物料类型代码为3S
 (pt_part_type='3S')
手工化成 1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为3或4,工单类型包括:正常工单、试产工单
 (tr_nbr like 'WO3%' or tr_nbr like 'WP3%' or tr_nbr like 'WO4%' or tr_nbr like 'WP4%')
3)物料类型代码为3S
 (pt_part_type='3S')
涂装喷漆 1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为5,工单类型包括:正常工单、试产工单
 (tr_nbr like 'WO5%' or tr_nbr like 'WP5%')
3)物料类型代码为3S
 (pt_part_type='3S')
涂装组立 1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为6,工单类型包括:正常工单、试产工单
 (tr_nbr like 'WO6%' or tr_nbr like 'WP6%')
3)物料类型代码为3S
 (pt_part_type='3S')
镁铝成型 耗用辅料 辅料领用数量
*
物料号未税采购价格
1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为1,工单类型不限
 (tr_nbr like 'W_1%')
3)物料类型代码以3F开始
 (pt_part_type like '3F%')
CNC 1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为2,工单类型不限
 (tr_nbr like 'W_2%')
3)物料类型代码以3F开始
 (pt_part_type like '3F%')
手工化成 1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为3或4,工单类型不限
  (tr_nbr like 'W_3%' or tr_nbr like 'W_4%')
3)物料类型代码以3F开始
 (pt_part_type like '3F%')
涂装喷漆 1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为5,工单类型不限
 (tr_nbr like 'W_5%')
3)物料类型代码以3F开始
 (pt_part_type like '3F%')
涂装组立 1)事务类型仅限于加工单发料
 (tr_type='iss-wo')
2)工单号第3位部门代码为6,工单类型不限
  (tr_nbr like 'W_6%')
3)物料类型代码以3F开始
 (pt_part_type like '3F%')
镁铝成型 耗用涂料 涂料领用数量
*
物料号未税采购价格
1)事务类型仅限于加工单发料和计划外出库
 (tr_type='iss-wo' or tr_type='iss-unp')
2)工单号第3位部门代码为1,不限工单类型;或者计划外出库单号以I开始,且部门代码为3110
 (tr_nbr like 'W_1%' or (tr_nbr like 'I%' and tr_so_job='3110'))
3)物料类型代码以3T开始
 (pt_part_type like '3T%')
CNC 1)事务类型仅限于加工单发料和计划外出库
 (tr_type='iss-wo' or tr_type='iss-unp')
2)工单号第3位部门代码为2,不限工单类型;或者计划外出库单号以I开始,且部门代码为3120
 (tr_nbr like 'W_2%' or (tr_nbr like 'I%' and tr_so_job='3120'))
3)物料类型代码以3T开始
 (pt_part_type like '3T%')
手工化成 1)事务类型仅限于加工单发料和计划外出库
 (tr_type='iss-wo' or tr_type='iss-unp')
2)工单号第3位部门代码为3或4,不限工单类型;或者计划外出库单号以I开始,且部门代码为3130或3140
 (tr_nbr like 'W_3%' or tr_nbr like 'W_4%' or (tr_nbr like 'I%' and (tr_so_job='3130' or tr_so_job='3140')))
3)物料类型代码以3T开始
 (pt_part_type like '3T%')
涂装喷漆 1)事务类型仅限于加工单发料和计划外出库
 (tr_type='iss-wo' or tr_type='iss-unp')
2)工单号第3位部门代码为5,不限工单类型;或者计划外出库单号以I开始,且部门代码为3150
 (tr_nbr like 'W_5%' or (tr_nbr like 'I%' and tr_so_job='3150'))
3)物料类型代码以3T开始
 (pt_part_type like '3T%')
涂装组立 1)事务类型仅限于加工单发料和计划外出库
 (tr_type='iss-wo' or tr_type='iss-unp')
2)工单号第3位部门代码为6,不限工单类型;或者计划外出库单号以I开始,且部门代码为3160
 (tr_nbr like 'W_6%' or (tr_nbr like 'I%' and tr_so_job='3160'))
3)物料类型代码以3T开始
 (pt_part_type like '3T%')
镁铝成型 耗用其它(含包材) (其它物料领用数量
*
物料号未税采购价格)
-
(其它物料退回数量
*
物料号未税采购价格)
因做账方式不同,此部分领用和退回需要单独计算
物料领用数量统计条件:
1)事务类型仅限于加工单发料和计划外出库
 (tr_type='iss-wo' or tr_type='iss-unp')
2)工单号第3位部门代码为1,工单类型包括:正常工单和试产工单;或者单号以B1开始;或者计划外出库单号以I开始,且部门代码为3110
 (tr_nbr like 'WO1%' or tr_nbr like 'WP1%' or tr_nbr like 'B1%' or (tr_nbr like 'I%' and tr_so_job='3110'))
3)排除委外加工镁原料发料、其它采购镁原料不良品、炉喷报废料
 (tr_loc<>'X3M01' and tr_loc<>'X3MQ2' and tr_loc<>'X3MQ3')
4)排除物料类型代码为3S、3M、以3F开始、以3T开始、以1或2开始
 (pt_part_type<>'3S' and pt_part_type<>'3M' and pt_part_type not like '3F%' and pt_part_type not like '3T%' and pt_part_type not like '1%' and pt_part_type not like '2%')
物料退回数量统计条件:
1)事务类型仅限于计划外入库
 (tr_type='rct-unp')
2)计划外入库单号以F1开始
 (tr_nbr like 'F1%')
3)物料类型代码以3B开始
 (pt_part_type like '3B%')
CNC 物料领用数量统计条件:
1)事务类型仅限于加工单发料和计划外出库
 (tr_type='iss-wo' or tr_type='iss-unp')
2)工单号第3位部门代码为2,工单类型包括:正常工单和试产工单;或者单号以B2开始;或者计划外出库单号以I开始,且部门代码为3120
 (tr_nbr like 'WO2%' or tr_nbr like 'WP2%' or tr_nbr like 'B2%' or (tr_nbr like 'I%' and tr_so_job='3120'))
3)排除委外加工镁原料发料、其它采购镁原料不良品、炉喷报废料
 (tr_loc<>'X3M01' and tr_loc<>'X3MQ2' and tr_loc<>'X3MQ3')
4)排除物料类型代码为3S、3M、以3F开始、以3T开始、以1或2开始
 (pt_part_type<>'3S' and pt_part_type<>'3M' and pt_part_type not like '3F%' and pt_part_type not like '3T%' and pt_part_type not like '1%' and pt_part_type not like '2%')
物料退回数量统计条件:
1)事务类型仅限于计划外入库
 (tr_type='rct-unp')
2)计划外入库单号以F1开始
 (tr_nbr like 'F2%')
3)物料类型代码以3B开始
 (pt_part_type like '3B%')
手工化成 物料领用数量统计条件:
1)事务类型仅限于加工单发料和计划外出库
 (tr_type='iss-wo' or tr_type='iss-unp')
2)工单号第3位部门代码为3或4,工单类型包括:正常工单和试产工单;或者单号以B3或B4开始;或者计划外出库单号以I开始,且部门代码为3130或3140
 (tr_nbr like 'WO3%' or tr_nbr like 'WP3%' or tr_nbr like 'WO4%' or tr_nbr like 'WP4%' or tr_nbr like 'B3%' or tr_nbr like 'B4%' or (tr_nbr like 'I%' and (tr_so_job='3130' or tr_so_job='3140')))
3)排除委外加工镁原料发料、其它采购镁原料不良品、炉喷报废料
 (tr_loc<>'X3M01' and tr_loc<>'X3MQ2' and tr_loc<>'X3MQ3')
4)排除物料类型代码为3S、3M、以3F开始、以3T开始、以1或2开始
 (pt_part_type<>'3S' and pt_part_type<>'3M' and pt_part_type not like '3F%' and pt_part_type not like '3T%' and pt_part_type not like '1%' and pt_part_type not like '2%')
物料退回数量统计条件:
1)事务类型仅限于计划外入库
 (tr_type='rct-unp')
2)计划外入库单号以F3或F4开始
 (tr_nbr like 'F3%' or tr_nbr like 'F4%')
3)物料类型代码以3B开始
 (pt_part_type like '3B%')
涂装喷漆 物料领用数量统计条件:
1)事务类型仅限于加工单发料和计划外出库
 (tr_type='iss-wo' or tr_type='iss-unp')
2)工单号第3位部门代码为5,工单类型包括:正常工单和试产工单;或者单号以B5开始;或者计划外出库单号以I开始,且部门代码为3150
 (tr_nbr like 'WO5%' or tr_nbr like 'WP5%' or tr_nbr like 'B5%' or (tr_nbr like 'I%' and tr_so_job='3150'))
3)排除委外加工镁原料发料、其它采购镁原料不良品、炉喷报废料
 (tr_loc<>'X3M01' and tr_loc<>'X3MQ2' and tr_loc<>'X3MQ3')
4)排除物料类型代码为3S、3M、以3F开始、以3T开始、以1或2开始
 (pt_part_type<>'3S' and pt_part_type<>'3M' and pt_part_type not like '3F%' and pt_part_type not like '3T%' and pt_part_type not like '1%' and pt_part_type not like '2%')
物料退回数量统计条件:
1)事务类型仅限于计划外入库
 (tr_type='rct-unp')
2)计划外入库单号以F5开始
 (tr_nbr like 'F5%')
3)物料类型代码以3B开始
 (pt_part_type like '3B%')
涂装组立 物料领用数量统计条件:
1)事务类型仅限于加工单发料和计划外出库
 (tr_type='iss-wo' or tr_type='iss-unp')
2)工单号第3位部门代码为6,工单类型包括:正常工单和试产工单;或者单号以B6开始;或者计划外出库单号以I开始,且部门代码为3160
 (tr_nbr like 'WO6%' or tr_nbr like 'WP6%' or tr_nbr like 'B6%' or (tr_nbr like 'I%' and tr_so_job='3160'))
3)排除委外加工镁原料发料、其它采购镁原料不良品、炉喷报废料
 (tr_loc<>'X3M01' and tr_loc<>'X3MQ2' and tr_loc<>'X3MQ3')
4)排除物料类型代码为3S、3M、以3F开始、以3T开始、以1或2开始
 (pt_part_type<>'3S' and pt_part_type<>'3M' and pt_part_type not like '3F%' and pt_part_type not like '3T%' and pt_part_type not like '1%' and pt_part_type not like '2%')
物料退回数量统计条件:
1)事务类型仅限于计划外入库
 (tr_type='rct-unp')
2)计划外入库单号以F6开始
 (tr_nbr like 'F6%')
3)物料类型代码以3B开始
 (pt_part_type like '3B%')

发表评论:

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。

日历

最新评论及回复

最近发表

Powered By Z-Blog 1.8 Walle Build 100427 |

Copyright 2009-2012 LZY'Blog. | ICP:蜀ICP备05027543号