temp test

sale

"l_sale_t"."id" is '主键';
"l_sale_t"."validflag" is '状态标记0作废1正常 2正在执行8完成  5暂停';
"l_sale_t"."stepflag" is '0作废,1;录入过秤单,2配货费确认,3车号确认  ,4打印装车单,5装货确认,6计量完成出厂,7打印质保书,8,9结算完成';
"l_sale_t"."planid" is '计划号';
"l_sale_t"."unitname" is '开单单位';
"l_sale_t"."orderitemid" is '订单子表id';
"l_sale_t"."carno" is '车号,客户自提一车一个,多个车号用逗号隔开';
"l_sale_t"."contractno" is '合同号(录入,允许重复,允许不录入)';
"l_sale_t"."ordertype" is '订单类型:0:汽运自提、1汽运送货、2集港销售、3火车销售、4销售退货、5先结后发';
"l_sale_t"."transitway" is '运输方式(c:汽车,t:火车)';
"l_sale_t"."tradetype" is '贸易类型:0:内贸,1:外贸,只有集港的才有效,其他的默认值为0';
"l_sale_t"."sourcename" is '发货单位名称(与s_storename_t关联)';
"l_sale_t"."sourcecode" is '发货单位编码';
"l_sale_t"."targetcode" is '客户编码';
"l_sale_t"."targetname" is '客户名称';
"l_sale_t"."targetaddrcode" is '收货地点编码(集港的是港口,火车是到站名)';
"l_sale_t"."targetaddrname" is '收货地点名称(集港的是港口,火车是到站名)';
"l_sale_t"."materialtype" is '物资类型0副产品 1产品  2废旧物资';
"l_sale_t"."materialcode" is '物资编码';
"l_sale_t"."materialname" is '物资名(与d_material_t关联)';
"l_sale_t"."steelname" is '钢号';
"l_sale_t"."materialspeccode" is '物资规格编码';
"l_sale_t"."materialspec" is '物资规格(与d_materalspec_t关联)';
"l_sale_t"."materialsize" is '尺寸';
"l_sale_t"."price" is '单价';
"l_sale_t"."pricetype" is '价格类型:0一票制,1运费+单价';
"l_sale_t"."istheory" is '是否单件计重(0否下线秤重进行结算, 1是汽车衡称重结算)';
"l_sale_t"."transitprice" is '运费';
"l_sale_t"."iscompare" is '是否复磅(0否,1是),单件计重否时,必须为1是';
"l_sale_t"."planamount" is '计划提货数量';
"l_sale_t"."plancount" is '计划提货重量';
"l_sale_t"."begintime" is '提单执行开始时间';
"l_sale_t"."endtime" is '提单执行结束时间';
"l_sale_t"."memo" is '备注';
"l_sale_t"."carnoman" is '车号录入人';
"l_sale_t"."carnodate" is '车号录入时间';
"l_sale_t"."confirmmoney" is '配货费';
"l_sale_t"."confirmman" is '确认人,确认交配货费';
"l_sale_t"."confirmdate" is '确认时间,确认交配货费';
"l_sale_t"."createman" is '创建人';
"l_sale_t"."createdate" is '创建时间';
"l_sale_t"."updateman" is '修改人';
"l_sale_t"."updatedate" is '修改时间';
"l_sale_t"."matchexcise" is '配货费单价';
"l_sale_t"."productline" is '产线';
"l_sale_t"."productlinecode" is '产线编码';
"l_sale_t"."materiallength" is '长';
"l_sale_t"."materialwidth" is '宽';
"l_sale_t"."materialthick" is '厚';
"l_sale_t"."company" is '开单公司';
"l_sale_t"."businessman" is '业务员';
"l_sale_t"."businessunit" is '业务部门';
"l_sale_t"."orderno" is '销售计划号';
"l_sale_t"."shdw" is '收货单位';
"l_sale_t"."shdwbm" is '收货单位编码';
"l_sale_t"."isstandard" is '定尺与非定尺 0非定尺,1定尺, -1代表无此属性';
"l_sale_t"."zuofeiman" is '作废人';
"l_sale_t"."zuofeidate" is '作废时间';
"l_sale_t"."settleflag" is '0未结算 1正在结算 2结算完成';
"l_sale_t"."oldplanid" is '旧过秤单号';
"l_sale_t"."planid_b" is '关联过秤单号 yymmdd(开单)+4位流水号';
"l_sale_t"."isused" is '此过秤单是否被关联使用 0未关联 1已关联';
"l_sale_t"."weight_b" is '剩余量';
"l_sale_t"."autoupdate" is '自动执行存储过秤更新出账表的预支记录(实重乘以单价)0未更新 1已更新';
"l_sale_t"."shipname" is '船名';
"l_sale_t"."zyx" is '专用线';
"l_sale_t"."carcount" is '车数';
"l_sale_t"."shmt" is '收货码头,发货码头';
"l_sale_t"."yscd" is '运输车队';
"l_sale_t"."lxr" is '联系人';
"l_sale_t"."zxbz" is '国标和冶标
';
comment on column "mfis_user"."l_sale_t"."ordernoids" is '计划子表id';
comment on table "mfis_user"."l_sale_t" is '销售过秤单表。';

materialflow

"l_materialflow_t"."matchid" is '物流id(14位=业务类型+00yymmdd00000)';
"l_materialflow_t"."rfid_no" is 'rfid卡卡号';
"l_materialflow_t"."icno" is 'ic卡卡号';
"carno" is '车号';
"operatype" is '业务类型(0-厂内 ,8销售. 91 采购.92废钢采购.93辅料采购.94港口采购.95火车采购.1跨区域调拨.9 4销售退货 5采购退货)';
"entryflag" is '进厂标记(0-未进厂 1-进厂)';
"suttleflag" is '计量标记(0-未计量 1-计量 2-计量完成)';
"outflag" is '出厂标记(0-未出厂 1-已出厂)';
"timeout" is '进厂时间限制';
"leaveflag" is '是否直接出厂,如果进厂未计量,此时直接打此标记不需要走复磅即可出厂';
"driver" is '司机姓名';
"chedui" is '车辆所属车队';
"address" is '送货地址';
"tell" is '电话';
"unitname" is '当前单位(制卡中心单位,权限配置传入的参数)';
"validflag" is '0作废 1有效 8完成';
"createman" is '创建人';
"createdate" is '创建时间';
"updateman" is '修改人';
"updatedate" is '修改时间';
"memo" is '备注';
 '物流主表';

materialflowitem

"matchid" is '子表matchid(主表matchid+1位)';
"validflag" is '0作废,1正常';
"refmatchid" is '主表matchid(14)';
"planid" is '计划号';
"sourcecode" is '来源单位编码';
"sourcename" is '来源单位名称';
"sourceplace" is '供货地点/船名/发站';
"supplyer" is '供货人';
"targetcode" is '去向单位编码';
"targetname" is '去向单位名称';
"materialname" is '物料名称';
"materialcode" is '物料编码';
"materialspec" is '物料规格';
"materialspeccode" is '物料规格编码';
"bgross" is '对方毛重';
"btare" is '对方皮重';
"bsuttle" is '对方净重';
"count" is '支数';
"eachweight" is '单件重,供辅料使用';
"suttle" is '计量净重';
"othersourcename" is '混装单位';
"settlement" is '结算单位';
"storeinflag" is '入库标记(0-未入库,1-已确认、8入库完成)';
"storeoutflag" is '出库标记(0-为出库,1-已确认、8出库完成)';
"mqflag" is '质检标记(0-未取样,1-已取样,2已编批,8质检完成)';
"backflag" is '(复磅标记) 1-复磅标记';
"createman" is '创建人';
"createdate" is '创建时间';
"updatedate" is '修改时间';
"updateman" is '修改人';
"memo" is '行表备注';
"systemmeo" is '系统备注';
"batchno" is '炉批号/质检批号';
"weight" is '出库重量(单件重量)';
"saleid" is '预报id';
"lizhong" is '理重';
"materialsize" is '尺寸';
'物流行表';

storeout

"validflag" is '0作废   1正常,8完成';
"matchid" is '子物流号';
"refmatchid" is '主物流号';
"carno" is '车号';
"planid" is '计划号(执行销售部计划,存储销售部计划号;执行运输部计划,存储运输部计划号)';
"taskcode" is '业务号';
"storecode" is '库房编码';
"storename" is '库房名称';
"storepos" is '库位(产品用)';
"operatype" is '出库类型 0-调拨出库   5采购退货,8销售';
"targetcode" is '去向单位编码';
"targetname" is '去向单位名称';
"materialcode" is '物料编码';
"materialname" is '物料名称';
"materialspec" is '物料规格名称';
"materialspeccode" is '物料规格编码';
"weight" is '出库重量(不需要录入,关联计量数据)';
"counts" is '出库数量(不用)';
"createdate" is '创建时间(进库房时间)';
"updatedate" is '修改时间';
"createman" is '创建人(出库人)';
"updateman" is '修改人';
"memo" is '备注';
"transitway" is '运输方式  汽运 - c 船运 - s 火运 - t 汽车转火车 - ct  ';
"postionid" is '库位id';
"batchno" is '批号(产品:炉批号+件次号),多个批,使用逗号隔开';
"entruckman" is '钢号';
"hycarno" is '火车车号';
"ckfdate" is '出库时间(出库房时间)';
"materialsize" is '尺寸';
"zxbz" is '执行标准';
"ctmatchid" is '(汽车装火车)火车出库编号';
"shdwbm" is '收货单位编码';
"shdw" is '收货单位';
"orderno" is '销售部计划号';
"lizhong" is '成品理重';

saleorder

"id" is '主键';
"validflag" is '0作废,1正常,2,执行,8完成';
"orderno" is '订单号(录入,不允许重复)合同号';
"ordertype" is '物资类型(,0副产品1产品2废旧物资)';
"transitway" is '运输方式(0 汽运自提,1汽运送货,2集港销售,3火运销售,4销售退货,5先结后发)';
"unitcode" is '当前单位编码(下合同的部门编码)';
"unitname" is '当前单位(下合同的部门)';
"customercode" is '客户编码(购货人编码) 客户表读取,火运时为专用线';
"customername" is '客户名称(购货人)客户表读取';
"validtype" is '有效类型0-长期有效,1-一车有效,2按时间范围(备用)';
"begintime" is '开始时间(添加时当前)(备用)';
"endtime" is '结束时间(当前+30)(备用)';
"blanceunitcode" is '结算单位编码(备用)';
"blanceunitname" is '结算单位名称(备用)';
"createman" is '创建人';
"createdate" is '创建时间';
"updateman" is '修改人';
"updatedate" is '修改时间';
"memo" is '备注';
"contractno" is '合同号';
"tradetype" is '贸易类型  0内贸1外贸';
"targetname" is '到站地点(集港的为港口)';
"targetcode" is '到站地点编码';
"shdw" is '收货单位';
"shdwbm" is '收货单位编码';
"carno" is '车号(组成形式:鲁a123,鲁b123)';
"lxr" is '联系人及电话';
"zyx" is '专用线(火运)';
"carcount" is '车数(火运)';
"saletype" is '销售类型 0 定向 1 普通';
"shipname" is '船名';
"carnumber" is '车数(火运)';
s '销售订单表';

sale order item

"id" is '主键';
"fid" is '销售订单主表id';
"validflag" is '0作废,1正常,2,执行,8完成';
"sourcename" is '发货单位名称(与s_storename_t关联)';
"sourcecode" is '发货单位编码';
"materialcode" is '物料编码';
"materialname" is '物料名(与d_material_t关联)';
"materialspeccode" is '物料规格编码';
"materialspec" is '物料规格(与d_materalspec_t关联)';
"stocksize" is '尺寸';
"iscompare" is '是否复磅(0否,1是)';
"price" is '单价';
"planamount" is '订单数量';
"plancount" is '订单重量';
"createman" is '创建人';
"createdate" is '创建时间';
"updateman" is '修改人';
"updatedate" is '修改时间';
"memo" is '备注';
"steelno" is '钢号';
"steelnocode" is '钢号编码';
"productline" is '产线';
"productlinecode" is '产线编码';
"isstandard" is '定尺与非定尺 0非定尺 1定尺 ,-1代表无此属性';
"sjcount" is '实际发货数量';
"sjweight" is '实际发货量';
"batchno" is '炉批号';
"bcsize" is '尺寸';
"zxbz" is '国标&冶标';
"sjcarnumber" is '实际车数';
"xsddbh" is '销售订单编号';
s '销售订单子表';

ictemp

"carno" is '车号';
"ic_no" is 'ic卡号';
"matchid" is '验配id';
"operatype" is '业务类型';
"planid" is '计划id';
"orderno" is '订单号';
"taskcode" is '业务号';
"materialcode" is '物料编码';
"materialname" is '物料名称';
"materialspeccode" is '物料规格编码';
"materialspec" is '物料规格';
"shipcode" is '船名编码';
"ship" is '船名';
"sourcecode" is '发货单位编码';
"sourcename" is '发货单位';
"sourcetime" is '发货时间';
"targetcode" is '收货单位编码';
"targetname" is '收货单位';
"targettime" is '收货时间';
"grossa" is '毛重a';
"grosstime" is '毛重时间';
"grossweighid" is '计毛衡器id';
"grossweigh" is '毛重衡器名称';
"grossoperacode" is '计毛计量员编码';
"grossoperaname" is '计毛计量员';
"tarea" is '皮重a';
"taretime" is '皮重时间';
"tareweighid" is '皮重衡器id';
"tareweigh" is '皮重衡器名称';
"tareoperacode" is '皮重计量员编码';
"tareoperaname" is '皮重计量员编码';
"deduction" is '扣重';
"deductiontime" is '扣重时间';
"deductioncode" is '扣重单位编码';
"deductionname" is '扣重单位';
"entertime" is '进厂时间';
"entergate" is '进厂大门编码';
"entergatename" is '进门大门名称';
"leavegatecode" is '出厂大门编码';
"leavegatename" is '出厂大门名称';
"leavetime" is '出厂时间';
"mcount" is '发货总支数';
"matchidb" is '发货id';
"grossb" is '发货毛重';
"tareb" is '发货皮重';
"batchcode" is '尺寸';
"sampletime" is '取样时间';
"samplecode" is '取样单位编码';
"samplemancode" is '取样人编码';
"dflag" is '一车多货标记';
"bflag" is '退货标记/混装标记';
"card_lype" is '卡类型(1 固定卡,0临时卡)';
"card_level" is 'ic卡等级(1公司自己车辆,2公司租赁车辆,3供应商车辆,4客户车辆)';
"card_initflag" is '初始化标记(0:作废、挂失,1:已初始化,2:发给领卡单位,3:发给司机)';
"card_mode" is '发卡模式(0 一车一卡, 1一车多卡)';
"card_unitcode" is '领卡单位编码';
"card_unitname" is '领卡单位';
"bcsize" is '尺寸';
"zxbz" is '执行标准';
"tcode" is '运输单位编码';
"tname" is '执行计划:运输处,销售处';
"createdate" is '记录的添加时间';
"mflag" is '计量标记:1计量,0不计量(理重),-1空车出厂';
"sourceplace" is '供货地点/船名/发站';
"targetaddrname" is '收货地点名称(集港的是港口,火车是到站名)';
"memo" is '备注';
"grossspeed" is '计皮速度';
"tarespeed" is '计毛速度';
"targettime1" is '出库房时间(采购)';
"sourcetime1" is '出库房时间(销售)';
"grosslogid" is '毛重日志id';
"tarelogid" is '皮重日志id';
"lizhong" is '理重';
s 'ic卡内容临时表';

s_store_t

id" is '主键';
materialid" is '产品唯一标识号,炉批号+件次号,为条码号;钢坯:炉批号+_+判订子表id';
validflag" is '状态0作废,1待入库,2已入库,3调拨出库在途,4销售出库,5钢坯入炉,-2退货';
qflag" is '质检状态,0未质检,1已质检,2 判废';
matchid" is '下线秤计量id';
storecode" is '库房编码';
storename" is '库房名称';
postionid" is '库位id';
stoerpos" is '库位名称';
materialcode" is '产品编码';
materialname" is '产品(从物料表里取)';
foldercode" is '物料大类编码,90产品,92中间产品,93副产品,11燃料,14原料';
steelcode" is '钢号编码';
steelname" is '钢号';
materialspeccode" is '规格编码';
materialspec" is '规格';
materialsize" is '尺寸';
isstandard" is '是否定尺 0否,1是';
sourcecode" is '产线编码';
sourcename" is '产线名称';
batchno" is '炉批号(下线炉次)';
batchno_xn" is '性能化验批号,产品下线质检用';
lotnumber" is '件次号';
materialtotalcount" is '总支数';
materialtotalweight" is '总下线重量 吨';
materialcount" is '出库总支数';
materialweight" is '出库总重量 吨';
dostandard" is '执行标准';
licence" is '许可证号';
maincomp" is '主要成分,入炉预报时,根据批号从钢坯质检中带出';
ageing" is '时效期';
createman" is '添加人';
createdate" is '添加时间';
updateman" is '修改人';
updatedate" is '修改时间';
memo" is '备注信息';
recordtype" is '入库类型:0:下线入库,1:调拨入库,2销售退货,3:手工录入4:手工出库 5压钢';
testman" is '质检人';
testdate" is '质检时间';
heatno" is '转炉号';
lzjno" is '连铸机号';
poslevel" is '库位层次(1-10层)';
posdirection" is '库位方位(东、西、南、北、中)';
firedcount" is '入炉支数(捆/支)';
zg" is '专供';
rsflag" is '0不热送1热送';
gross" is '毛重';
suttle" is '净重';
checkman" is '检验员';
ordernumber" is '订单号';
steelalias" is '钢种别名';
workgroup" is '班次';
workgroupindex" is '班别';
productattributes" is '产品属性:1正常,2退货加工,3下脚料加工';
countnumber" is '产品单件支数';
printtime" is '打印时间';
tsmemo" is '存放特殊合同钢的备注';
orderno" is '销售计划号';
tgcj" is '特供厂家';
zhixingbiaozhun" is '执行标准';
ygr" is '压钢操作人';
ygdate" is '压钢时间';
hyr" is '还原操作人';
hydate" is '还原时间';
zfr" is '作废操作人';
zfdate" is '作废时间';
ygmemo" is '压钢原因';
pfmemo" is '判废原因';
scjhbiaoji" is '生产计划上传标记';
scjh" is '生产计划';
sdbiaoji" is '锁定';

D_taskcode_


"d_taskcode_t"."validflag" is '有效标记0-作废1-有效';
"d_taskcode_t"."taskcode" is '业务号 业务类型+5位流水号';
"d_taskcode_t"."sourcecode" is '来源编码';
"d_taskcode_t"."sourcename" is '来源名称';
"d_taskcode_t"."materialcode" is '物料编码';
"d_taskcode_t"."materialname" is '物料名称';
"d_taskcode_t"."targetcode" is '去向编码';
"d_taskcode_t"."targetname" is '去向名称';
"d_taskcode_t"."transitway" is '运输方式  s--船运  t--火运  c--汽运';
"d_taskcode_t"."sampleway" is '取样方式 1入库取样,2入库前取样,3质检后入库,4不取样';
"d_taskcode_t"."operatype" is '业务类型 0-厂内调拨  ,1-跨区调拨 2-港口调拨  3-车站调拨  9-采购  5-采购退货 8-销售 4-销售退货 7-服务  11-生产投料入库  12-生产投料出库  13-完工入库 14-完工出库';
"d_taskcode_t"."mflag" is '计量流程标记 0不限制,1先毛后皮,2先皮后毛';
"d_taskcode_t"."sflag" is '是否出入库 0不限制,1出库,2入库,3出入库';
"d_taskcode_t"."mqflag" is '计质量标记';
"d_taskcode_t"."tarehour" is '皮重有效期 -1不限制,0一车一皮,>n n小时有效';
"d_taskcode_t"."printnum" is '打印页数';
"d_taskcode_t"."measureinterval" is '计量时间间隔  分钟数 0表示不限制';
"d_taskcode_t"."recordtype" is '0=自动生成,1=手工维护';
"d_taskcode_t"."kqflag" is '厂际调拨标识 0厂内调拨,1厂际调拨';
"d_taskcode_t"."grossstand" is '毛重标准 0第一次毛重为主,1第二次毛重为主';
"d_taskcode_t"."isplan" is '是否执行计划0-不执行 1-执行';
"d_taskcode_t"."issupple" is '是否发货(1-刷卡发货、2-无卡发货、0-不做发货确认)';
"d_taskcode_t"."isselect" is '是否挑库1-不挑库 2-挑库';
"d_taskcode_t"."isget" is '是否收货(1-刷卡收货、2-无卡收货、0-不做收货确认)';
"d_taskcode_t"."createman" is '添加人';
"d_taskcode_t"."createdate" is '添加时间';
"d_taskcode_t"."memo" is '备注';
"d_taskcode_t"."updateman" is '修改人';
"d_taskcode_t"."updatedate" is '修改时间';
"d_taskcode_t"."materialspeccode" is '物料规格编码';
"d_taskcode_t"."materialspec" is '物料规格';
"d_taskcode_t"."weightcoefficient" is '扣重系数';
"d_taskcode_t" is '业务号表';

L_ic_dbtemp


"l_ic_dbtemp_t"."carno" is '车号';
"l_ic_dbtemp_t"."ic_no" is 'ic卡号';
"l_ic_dbtemp_t"."matchid" is '验配id';
"l_ic_dbtemp_t"."operatype" is '业务类型';
"l_ic_dbtemp_t"."planid" is '计划id';
"l_ic_dbtemp_t"."orderno" is '订单号';
"l_ic_dbtemp_t"."taskcode" is '业务号';
"l_ic_dbtemp_t"."materialcode" is '物料编码';
"l_ic_dbtemp_t"."materialname" is '物料名称';
"l_ic_dbtemp_t"."materialspeccode" is '物料规格编码';
"l_ic_dbtemp_t"."materialspec" is '物料规格';
"l_ic_dbtemp_t"."shipcode" is '船名编码';
"l_ic_dbtemp_t"."ship" is '船名';
"l_ic_dbtemp_t"."sourcecode" is '发货单位编码';
"l_ic_dbtemp_t"."sourcename" is '发货单位';
"l_ic_dbtemp_t"."sourcetime" is '发货时间';
"l_ic_dbtemp_t"."targetcode" is '收货单位编码';
"l_ic_dbtemp_t"."targetname" is '收货单位';
"l_ic_dbtemp_t"."targettime" is '收货时间';
"l_ic_dbtemp_t"."grossa" is '毛重a';
"l_ic_dbtemp_t"."grosstime" is '毛重时间';
"l_ic_dbtemp_t"."grossweighid" is '计毛衡器id';
"l_ic_dbtemp_t"."grossweigh" is '毛重衡器名称';
"l_ic_dbtemp_t"."grossoperacode" is '计毛计量员编码';
"l_ic_dbtemp_t"."grossoperaname" is '计毛计量员';
"l_ic_dbtemp_t"."tarea" is '皮重a';
"l_ic_dbtemp_t"."taretime" is '皮重时间';
"l_ic_dbtemp_t"."tareweighid" is '皮重衡器id';
"l_ic_dbtemp_t"."tareweigh" is '皮重衡器名称';
"l_ic_dbtemp_t"."tareoperacode" is '皮重计量员编码';
"l_ic_dbtemp_t"."tareoperaname" is '皮重计量员编码';
"l_ic_dbtemp_t"."deduction" is '扣重';
"l_ic_dbtemp_t"."deductiontime" is '扣重时间';
"l_ic_dbtemp_t"."deductioncode" is '扣重单位编码';
"l_ic_dbtemp_t"."deductionname" is '扣重单位';
"l_ic_dbtemp_t"."entertime" is '进厂时间';
"l_ic_dbtemp_t"."entergate" is '进厂大门编码';
"l_ic_dbtemp_t"."entergatename" is '进门大门名称';
"l_ic_dbtemp_t"."leavegatecode" is '出厂大门编码';
"l_ic_dbtemp_t"."leavegatename" is '出厂大门名称';
"l_ic_dbtemp_t"."leavetime" is '出厂时间';
"l_ic_dbtemp_t"."mcount" is '发货总支数';
"l_ic_dbtemp_t"."matchidb" is '发货id';
"l_ic_dbtemp_t"."grossb" is '发货毛重';
"l_ic_dbtemp_t"."tareb" is '发货皮重';
"l_ic_dbtemp_t"."batchcode" is '批号';
"l_ic_dbtemp_t"."sampletime" is '取样时间';
"l_ic_dbtemp_t"."samplecode" is '取样单位编码';
"l_ic_dbtemp_t"."samplemancode" is '取样人编码';
"l_ic_dbtemp_t"."dflag" is '一车多货标记';
"l_ic_dbtemp_t"."bflag" is '退货标记';
"l_ic_dbtemp_t"."card_lype" is '卡类型(1 固定卡,0临时卡)';
"l_ic_dbtemp_t"."card_level" is 'ic卡等级(1公司自己车辆,2公司租赁车辆,3供应商车辆,4客户车辆)';
"l_ic_dbtemp_t"."card_initflag" is '初始化标记(0:作废、挂失,1:已初始化,2:发给领卡单位,3:发给司机)';
"l_ic_dbtemp_t"."card_mode" is '发卡模式(0 一车一卡, 1一车多卡)';
"l_ic_dbtemp_t"."card_unitcode" is '领卡单位编码';
"l_ic_dbtemp_t"."card_unitname" is '领卡单位';
"l_ic_dbtemp_t"."bcsize" is '司机编码';
"l_ic_dbtemp_t"."zxbz" is '司机';
"l_ic_dbtemp_t"."tcode" is '运输单位编码';
"l_ic_dbtemp_t"."tname" is '运输单位';
"l_ic_dbtemp_t"."createdate" is '记录的添加时间';
"l_ic_dbtemp_t"."mflag" is '计量标记:1计量,0不计量(理重),-1空车出厂';
"l_ic_dbtemp_t"."sourceplace" is '供货地点/船名/发站';
"l_ic_dbtemp_t"."targetaddrname" is '收货地点名称(集港的是港口,火车是到站名)';
"l_ic_dbtemp_t"."memo" is '备注';
"l_ic_dbtemp_t"."grossspeed" is '计皮速度';
"l_ic_dbtemp_t"."tarespeed" is '计毛速度';
"l_ic_dbtemp_t"."targettime1" is '出库房时间(采购)';
"l_ic_dbtemp_t"."sourcetime1" is '出库房时间(销售)';
"l_ic_dbtemp_t"."grosslogid" is '毛重日志id';
"l_ic_dbtemp_t"."tarelogid" is '皮重日志id';
"l_ic_dbtemp_t"."lizhong" is '理重';
"l_ic_dbtemp_t" is 'ic卡内容临时表';

rmis_user.m_steelmeasure_t

"rmis_user"."m_steelmeasure_cent"."matchid" is '磅单号';
"rmis_user"."m_steelmeasure_cent"."heatsequence" is '炉批号';
"rmis_user"."m_steelmeasure_cent"."weight" is '重量';
"rmis_user"."m_steelmeasure_cent"."materialcode" is '品名编码';
"rmis_user"."m_steelmeasure_cent"."materialname" is '品名';
"rmis_user"."m_steelmeasure_cent"."steelgradename" is '钢种';
"rmis_user"."m_steelmeasure_cent"."steelsizename" is '钢号';
"rmis_user"."m_steelmeasure_cent"."steellength" is '头数';
"rmis_user"."m_steelmeasure_cent"."unitcode" is '所属单位编码(钢材秤)';
"rmis_user"."m_steelmeasure_cent"."unitname" is '所属单位(钢材秤)';
"rmis_user"."m_steelmeasure_cent"."sourcecode" is '来源单位编码(辊道秤)';
"rmis_user"."m_steelmeasure_cent"."sourcename" is '来源单位(辊道秤)';
"rmis_user"."m_steelmeasure_cent"."targetcode" is '去向单位编码(辊道秤)';
"rmis_user"."m_steelmeasure_cent"."targetname" is '去向单位(辊道秤)';
"rmis_user"."m_steelmeasure_cent"."clientid" is '终端编码(衡器编码)';
"rmis_user"."m_steelmeasure_cent"."clientname" is '终端名称(衡器名称)';
"rmis_user"."m_steelmeasure_cent"."classname" is '班次';
"rmis_user"."m_steelmeasure_cent"."memo" is '备注';
"rmis_user"."m_steelmeasure_cent"."createdate" is '添加时间';
"rmis_user"."m_steelmeasure_cent"."createname" is '添加人';
"rmis_user"."m_steelmeasure_cent"."validflag" is '有效时间0-作废 1-正常 2-待审核 3-审核完成 4-退库';
"rmis_user"."m_steelmeasure_cent"."recordtype" is '0-自动 1-手动';
"rmis_user"."m_steelmeasure_cent"."steelgradecode" is '钢种编码';
"rmis_user"."m_steelmeasure_cent"."steelsizecode" is '钢号编码';
"rmis_user"."m_steelmeasure_cent"."steellengthcode" is '尺度编码';
"rmis_user"."m_steelmeasure_cent"."printflag" is '打印标识 0-未打印 1-已打印';
"rmis_user"."m_steelmeasure_cent"."xh" is '编码';
"rmis_user"."m_steelmeasure_cent"."hookno" is '勾号';
"rmis_user"."m_steelmeasure_cent"."danhao" is '单号';
"rmis_user"."m_steelmeasure_cent"."materialspec" is '规格';
"rmis_user"."m_steelmeasure_cent"."materialspeccode" is '规格编码';
"rmis_user"."m_steelmeasure_cent"."logid" is '日志id';
"rmis_user"."m_steelmeasure_cent"."jhyflag" is '检化验上传标记0-未上传 1-已上传';
"rmis_user"."m_steelmeasure_cent"."headdate" is '生产时间';
"rmis_user"."m_steelmeasure_cent"."printman" is '打印人';
"rmis_user"."m_steelmeasure_cent"."printtime" is '打印时间';
"rmis_user"."m_steelmeasure_cent"."scjhbiaoji" is '生产计划上传标记';
"rmis_user"."m_steelmeasure_cent"."brokenet" is '0网络正常 1断网数据';
"rmis_user"."m_steelmeasure_cent"."can_follow_process" is '是否开启始后道处理';
"rmis_user"."m_steelmeasure_cent"."follow_process_finish" is '后道处理是否完成';
"rmis_user"."m_steelmeasure_cent"."original_weight" is '修改重量后,报错原始重量';
posted @ 2020-03-11 09:42  fight139  阅读(456)  评论(0编辑  收藏  举报