• 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 '修改重量后,报错原始重量';
    
  • 相关阅读:
    使用Jquery的Ajax调用后台方法
    FileUpload与UpdatePanel
    OnClick与OnClientClick的时序和条件
    LinQ使用积累
    If...Else转换为Action的写法
    淘宝对接(二)
    淘宝对接(一)
    dialog传值
    android sdk开发包国内下载地址合集
    admob android
  • 原文地址:https://www.cnblogs.com/zhuxiang1633/p/12460547.html
Copyright © 2020-2023  润新知