查询增加更新打印删除字段单价数量金额成本属性单据锁单转出群组部门
DSP APD UPD PRT DEL R_MENU R_CST R_QTY R_AMT R_TAX R_OTH1R_USR R_OTH2R_GO DEPRO_NO
TA受订采购
TAJ采购单
TAL采购单报表
TALA采购单明细表
TALB采购单统计表
TB进货
TBA进货单
TBD进货单报表
TBDA进货明细表
TBDB进货统计表
TBM暂估单
TBO暂估报表
TBOA暂估入库明细表
ZBB人员班别设置T F F T F T F T F F T12T insert into update pswd1 set dsp=
ZBE人员班别明细表T T T T T T F T F F T12T insert into update pswd1 set dsp=
ZBK员工班别明细表T T T T T T F T F F T12T insert into update pswd1 set dsp=
T T T T T T F T F F T12T insert into update pswd1 set dsp= ZBDF员工请假单批次作业
ZBDB员工请假单登录T T T T T T F T F F T12T insert into update pswd1 set dsp=
T T T T T T F T F F T12T insert into update pswd1 set dsp= ZBG未(忘)打卡补单明细
ZBH员工假单登录明细表
T T T T T T F T F F T12T insert into update pswd1 set dsp=
T T T T T T F T F F T12T insert into update pswd1 set dsp= ZBI员工假单登录统计表
ZBJ补特休管理明细表T T T T T T F T F F T12T insert into update pswd1 set dsp=
ZCE每日出勤状况明细表
T T T T T T F T F F T12T insert into update pswd1 set dsp=
T T T T T T F T F F T12T insert into update pswd1 set dsp= ZCEA每日出勤状况明细表
T T T T T T F T F F T12T insert into update pswd1 set dsp= ZCEB每日出勤状况明细表
T T T T T T F T F F T12T insert into update pswd1 set dsp= ZCEC每日出勤状况分析表
ZCED每日出勤明细表三T T T T T T F T F F T12T insert into update pswd1 set dsp=
ZCN个人考勤清册T T T T T T F T F F T12T insert into update pswd1 set dsp=
YCD奖惩异动输入T T T T T T F T F F T12T insert into update pswd1 set dsp=
YCQ奖惩异动明细表T T T T T T F T F F T12T insert into update pswd1 set dsp=
ZCCG加班申请单T T T T T T F T F F T12T insert into update pswd1 set dsp=
ZCCH加班申请单明细表T T T T T T F T F F T12T insert into update pswd1 set dsp=
T T T T T T F T F F T12T insert into update pswd1 set dsp= ZCK加班审核作业统计表
YAE 计件工资单价表T F F T F T F T F F T 12T insert into update pswd1 set dsp=YAK 计件单价明细表T F F T F T T T T T T 12T insert into update pswd1 set dsp=YCCA 计件数量异动输入T F F T F T T T T T T 12T insert into update pswd1 set dsp=YCK 计件数量明细表T F F T F T T T T T T 12T insert into update pswd1 set dsp=YCL 计件数量统计表T F F T F T T T F F T 12T insert into update pswd1 set dsp=YCM 计件货品单价表T F F T F T T T T T T 12T insert into update pswd1 set dsp=
将右边的插入语句COPY转置到用户表(人员清单)再加"')"
触发器防止插入重复Crea
te
dsp='T',APD='F',UPD='F',PRT='T',DEL='F',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no=
pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZBE pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZBK pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZBD pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZBD pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZBG pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZBH pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZBI pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZBJ pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZCE pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZCE pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZCE pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZCE pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZCE pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZCN pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='YCD pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='YCQ pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZCC pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZCC pswd1 set dsp='T',APD='T',UPD='T',PRT='T',DEL='T',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='ZCK
pswd1 set dsp='T',APD='F',UPD='F',PRT='T',DEL='F',r_MENU='T',r_cst='F',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='YAE pswd1 set dsp='T',APD='F',UPD='F',PRT='T',DEL='F',r_MENU='T',r_cst='T',R_QTY='T',R_amt='T',r_tax='T',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='YAK pswd1 set dsp='T',APD='F',UPD='F',PRT='T',DEL='F',r_MENU='T',r_cst='T',R_QTY='T',R_amt='T',r_tax='T',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='YCC pswd1 set dsp='T',APD='F',UPD='F',PRT='T',DEL='F',r_MENU='T',r_cst='T',R_QTY='T',R_amt='T',r_tax='T',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='YCK pswd1 set dsp='T',APD='F',UPD='F',PRT='T',DEL='F',r_MENU='T',r_cst='T',R_QTY='T',R_amt='F',r_tax='F',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='YCL pswd1 set dsp='T',APD='F',UPD='F',PRT='T',DEL='F',r_MENU='T',r_cst='T',R_QTY='T',R_amt='T',r_tax='T',r_oth1='T',r_usr='1',r_oth2='2',r_go='T',depro_no='' where PGM='YCM
o_no='' where PGM='ZBB' and usr not like 'G10%' ='T',depro_no='' where PGM='ZBE' and usr not like 'G10%' ='T',depro_no='' where PGM='ZBK' and usr not like 'G10%' ='T',depro_no='' where PGM='ZBDF' and usr not like 'G10%' ='T',depro_no='' where PGM='ZBDB' and usr not like 'G10%' ='T',depro_no='' where PGM='ZBG' and usr not like 'G10%' ='T',depro_no='' where PGM='ZBH' and usr not like 'G10%' ='T',depro_no='' where PGM='ZBI' and usr not like 'G10%' ='T',depro_no='' where PGM='ZBJ' and usr not like 'G10%' ='T',depro_no='' where PGM='ZCE' and usr not like 'G10%' ='T',depro_no='' where PGM='ZCEA' and usr not like 'G10%' ='T',depro_no='' where PGM='ZCEB' and usr not like 'G10%' ='T',depro_no='' where PGM='ZCEC' and usr not like 'G10%' ='T',depro_no='' where PGM='ZCED' and usr not like 'G10%' ='T',depro_no='' where PGM='ZCN' and usr not like 'G10%' ='T',depro_no='' where PGM='YCD' and usr not like 'G10%' ='T',depro_no='' where PGM='YCQ' and usr not like 'G10%' ='T',depro_no='' where PGM='ZCCG' and usr not like 'G10%' ='T',depro_no='' where PGM='ZCCH' and usr not like 'G10%' ='T',depro_no='' where PGM='ZCK' and usr not like 'G10%'
='T',depro_no='' where PGM='YAE' and usr not like 'G10%' ='T',depro_no='' where PGM='YAK' and usr not like 'G10%' ='T',depro_no='' where PGM='YCCA' and usr not like 'G10%' ='T',depro_no='' where PGM='YCK' and usr not like 'G10%' ='T',depro_no='' where PGM='YCL' and usr not like 'G10%' ='T',depro_no='' where PGM='YCM' and usr not like 'G10%'