关于WMS随货同行单的保存位置和文件处理方法

这个表中TEMPLATE_FILE字段，存的是锐浪报表文件的TXT内容。

将字段的文本内容另存为扩展名为.grf的锐浪报表格式就可以重新使用。

  SELECT  T.*,ROWID FROM FRAME.SYS_PRINT_TEMPLATE   T WHERE T.TEMPLATE_ID='shtxd_lryy633';

这个表然后模板是存的 clob 类型的文件

Object Report
    Version='5.8.0.5'
    Tag='pdfFactory Pro'
    Title='你的报表标题'
    Object Font
        Name='宋体'
        Size=105000,0
        Weight=400
        Charset=134
    End
    Object Printer
        Size=256
        Width=30
        Height=14
        LeftMargin=0
        TopMargin=0.5
        RightMargin=0
        BottomMargin=0
        PrintOffsetX=0.3
    End
    Object DetailGrid
        CenterView=F
        AppendBlankRow=T
        Object Recordset
            ConnectionString='currentReport.DetailGrid.Recordset.ConnectionString'
            QuerySQL='SELECT T_HDR.BUSINESSBILL_NO,\r\n       T_HDR.BUSINESSMAN,\r\n       T_HDR.PRINT_TIMES,\r\n       FNC_UTL_GETFLD('PRINT_OWNER_NAME',T_HDR.OWNER_NO,'LC001')PRINT_OWNER_NAME,\r\n       T_HDR.INVOICE_TIME,\r\n       TO_CHAR(NVL(T_HDR.INCHK_COMPLETED_TIME,T_HDR.ISSUE_TIME),'YYYY-MM-DD') INCHK_COMPLETED_TIME,\r\n       --T_HDR.TRANSPORT_TYPE,\r\n       DECODE(T_HDR.OWNER_NO,'6003',NVL((SELECT FLD.VALUE_DATA\r\n          FROM FD_FIELD_DTL FLD\r\n         WHERE FLD.field_name = 'TRANSPORT_TYPE'\r\n           AND FLD.VALUE_DATA = T_HDR.TRANSPORT_TYPE),'自提'),(SELECT FLD.VALUE_DATA\r\n          FROM FD_FIELD_DTL FLD\r\n         WHERE FLD.field_name = 'TRANSPORT_TYPE'\r\n           AND FLD.VALUE_DATA = T_HDR.TRANSPORT_TYPE)) TRANSPORT_TYPE,\r\n       T_DTL.MANUFACTURER_NAME,\r\n       T_SUP.SSA_NAME,\r\n       T_HDR.MANUFACTURER_ADDRESS,\r\n       T_HDR.SSA_STORE_ADDR,\r\n       T_DTL.MARKETINGAUTHORISATIONHOLDER,\r\n       T_DTL.MARKETINGAUTHORISATIONHOLDER MARKETINGAH,\r\n       T_DTL.LOGISTICS_DESC,\r\n       substr(T_G.GOODS_NO,5)GOODS_NO,\r\n       T_DTL.DRUG_SPEC,\r\n       T_DTL.DOSAGE_FORM,\r\n       T_DTL.APPROVAL_NO,\r\n       T_G.MANUFACTURER_LICENSE MANUFACTURER_LICENSE_1, \r\n       --非器械单据时显示\r\n       DECODE(T_HDR.PRODUCTGROUP ,'20','',T_DTL.Approval_No)  APPROVAL_NO1,\r\n       --器械单据时显示\r\n       DECODE(T_HDR.PRODUCTGROUP ,'20',T_DTL.Approval_No,'') MANUFACTURER_LICENSE,\r\n       T_DTL.BASEUNIT_DESC,\r\n        SUM(T_CMD.PLANNED_QTY)PLANNED_QTY,\r\n       SUM(T_CMD.ACTUAL_QTY)ACTUAL_QTY,\r\n       -- FLOOR(SUM(T_CMD.ACTUAL_QTY)/T_L.PACKAGE_QTY) ACTUAL_PCS,\r\n       decode(rtrim(T_CMD.combatch_sign),\r\n              null,\r\n              FLOOR(SUM(T_CMD.ACTUAL_QTY) / T_L.PACKAGE_QTY),\r\n              null) ACTUAL_PCS,\r\n       T_DTL.PRICE,\r\n       SUM(T_CMD.ACTUAL_QTY) * T_DTL.PRICE AMOUNT,\r\n       DECODE(T_G.PURCHASECHANNAME,'Y',NVL(T_L.SUPPLIER_LOT,T_L.GOODS_LOTNO),T_L.GOODS_LOTNO) GOODS_LOTNO,\r\n       to_char(T_L.PRODUCTION_DATE,'yyyy.mm.dd') PRODUCTION_DATE,\r\n       decode(substr(T_G.goods_group,1,4),'2001',to_char(T_L.VALID_UNTIL,'yyyy.mm'),'2011',to_char(T_L.VALID_UNTIL,'yyyy.mm'),to_char(T_L.VALID_UNTIL,'yyyy.mm.dd'))VALID_UNTIL,\r\n       T_HDR.OPERATOR,\r\n       T_HDR.REPORTBILL_CLERK,\r\n       T_HDR.TEL,\r\n       FNC_UTL_GETFLD('PRINT_SHTXD_ZHIDR',T_HDR.OWNER_NO,'LC001') PRINT_SHTXD_ZHIDR,\r\n       FNC_UTL_GETFLD('PRINT_SHTXD_PEIHR',T_HDR.OWNER_NO,'LC001') PRINT_SHTXD_PEIHR,\r\n       FNC_UTL_GETFLD('PRINT_SHTXD_FAHR',T_HDR.OWNER_NO,'LC001') PRINT_SHTXD_FAHR,\r\n       FNC_UTL_GETFLD('PRINT_SHTXD_FUHR',T_HDR.OWNER_NO,'LC001') PRINT_SHTXD_FUHR, \r\n       FNC_UTL_GETFLD('PRINT_JHD_FHR',T_HDR.OWNER_NO,'LC001') PRINT_JHD_FHR,\r\n       FNC_UTL_GETFLD('PRINT_JHD_FAHR',T_HDR.OWNER_NO,'LC001') PRINT_JHD_FAHR,\r\n       FNC_UTL_GETFLD('PRINT_JHD_ZHIDR',T_HDR.OWNER_NO,'LC001') PRINT_JHD_ZHIDR,\r\n       FNC_UTL_GETFLD('PRINT_PARAM','ZHUG','LC001') ZHUG,\r\n       FNC_UTL_GETFLD('PRINT_PARAM','SHENGHR','LC001') SHENGHR,\r\n       FNC_UTL_GETFLD('PRINT_PARAM','ZHIDR','LC001') ZHIDR,\r\n       FNC_UTL_GETFLD('PRINT_JHD_JINGBR', T_HDR.OWNER_NO, 'LC001') PRINT_JINGBR,\r\n       FNC_UTL_GETFLD('PRINT_JHD_ZHUG', T_HDR.OWNER_NO, 'LC001') PRINT_ZHUG,\r\n       case when instr(T_HDR.SSA_STORE_ADDR,'北京')>0\r\n         then FNC_UTL_GETFLD('PRINT_PARAM','BJSHR','LC001')\r\n           else FNC_UTL_GETFLD('PRINT_PARAM','FBJSHR','LC001')\r\n             end SONGHR,\r\n       T_DTL.STOCK_STATUS,\r\n       T_HDR.OWNER_NO,\r\n       T_HDR.RECEIVING_CLERK, \r\n       T_DTL.RAUBE STORAGE_CONDITION,\r\n       et_owner_cfg(OwnerNo=>T_HDR.OWNER_NO).BILL_PRODUCER BILL_PRODUCER, \r\n       et_owner_cfg(OwnerNo=>T_HDR.OWNER_NO).PRINT_TITLE_SHTXD  PRINT_TITLE_SHTXD,\r\n       decode(T_HDR.move_type,'601',T_HDR.BUSINESSMAN,'643' ,et_owner_cfg(OwnerNo=>T_HDR.OWNER_NO).BUSINESSMAN ) BUSINESSMAN2 ,\r\n       T_DTL.ZZMEDERE,\r\n       T_DTL.ZZYYZCH,\r\n       FNC_GET_PCS(T_CMD.Bill_Hdr_Id,'F') ZJS,\r\n       T_DTL.PRODUCT_CODE\r\n  FROM RPT.CMD_OPERATION          T_CMD,\r\n       FD_GOODS               T_G,\r\n       FD_LOTNO               T_L,\r\n       RPT.BILL_OUTSTOREHOUSE_HDR T_HDR,\r\n       FD_SUPPLYSALESAGENCY   T_SUP,\r\n       RPT.BILL_OUTSTOREHOUSE_DTL T_DTL\r\n WHERE T_CMD.GOODS_ID = T_G.GOODS_ID\r\n   AND T_CMD.LOTNO_ID = T_L.LOTNO_ID\r\n   AND T_CMD.BILL_DTL_ID = T_DTL.BILL_DTL_ID\r\n   AND T_CMD.BILL_HDR_ID = T_HDR.BILL_HDR_ID\r\n   AND T_HDR.SSA_ID = T_SUP.SSA_ID\r\n   AND T_CMD.ACTUAL_QTY > 0\r\n\r\n   AND t_hdr.BUSINESSBILL_NO = '80180942'\r\nGROUP BY \r\n       T_HDR.BUSINESSBILL_NO,\r\n       T_HDR.BUSINESSMAN,\r\n       T_HDR.PRINT_TIMES,\r\n       T_HDR.INVOICE_TIME,\r\n       TO_CHAR(NVL(T_HDR.INCHK_COMPLETED_TIME,T_HDR.ISSUE_TIME),'YYYY-MM-DD'),\r\n       T_HDR.TRANSPORT_TYPE,\r\n       T_DTL.MANUFACTURER_NAME,\r\n       T_SUP.SSA_NAME,\r\n       T_HDR.MANUFACTURER_ADDRESS,\r\n       T_HDR.SSA_STORE_ADDR,\r\n       T_DTL.MARKETINGAUTHORISATIONHOLDER,\r\n       T_HDR.move_type,\r\n       T_DTL.LOGISTICS_DESC,\r\n       T_DTL.DRUG_SPEC,\r\n       T_DTL.DOSAGE_FORM,\r\n       T_DTL.APPROVAL_NO,\r\n       T_DTL.BASEUNIT_DESC,\r\n       T_DTL.PRICE,\r\n       T_L.GOODS_LOTNO,\r\n       T_L.PRODUCTION_DATE,\r\n       T_L.VALID_UNTIL,\r\n       T_HDR.OPERATOR,\r\n       T_G.GOODS_NO,\r\n       T_G.goods_group,\r\n       T_L.PACKAGE_QTY,\r\n       T_HDR.OWNER_NO,\r\n       T_DTL.STOCK_STATUS,\r\n       T_HDR.RECEIVING_CLERK,\r\n       T_G.MANUFACTURER_LICENSE,\r\n       T_HDR.TEL,\r\n       T_DTL.RAUBE,\r\n       T_DTL.ZZMEDERE,\r\n       T_DTL.ZZYYZCH,\r\n       T_HDR.REPORTBILL_CLERK,\r\n       T_HDR.PRODUCTGROUP,\r\n       rtrim(T_CMD.combatch_sign),\r\n       T_CMD.Bill_Hdr_Id,\r\n       T_CMD.Combatch_Sign,\r\n       T_G.PURCHASECHANNAME,\r\n       T_L.SUPPLIER_LOT,\r\n       T_DTL.PRODUCT_CODE\r\nORDER BY substr(T_G.GOODS_NO,5),T_CMD.Combatch_Sign, T_L.Goods_Lotno'
            Items Field
                Item
                    Name='BUSINESSBILL_NO'
                End
                Item
                    Name='BUSINESSMAN'
                End
                Item
                    Name='INCHK_COMPLETED_TIME'
                    Type=DateTime
                    Format='yyyy-MM-dd'
                End
                Item
                    Name='TRANSPORT_TYPE'
                End
                Item
                    Name='MANUFACTURER_NAME'
                End
                Item
                    Name='SSA_NAME'
                End
                Item
                    Name='MANUFACTURER_ADDRESS'
                End
                Item
                    Name='SSA_STORE_ADDR'
                End
                Item
                    Name='MARKETINGAUTHORISATIONHOLDER'
                End
                Item
                    Name='LOGISTICS_DESC'
                End
                Item
                    Name='DRUG_SPEC'
                End
                Item
                    Name='DOSAGE_FORM'
                End
                Item
                    Name='APPROVAL_NO'
                End
                Item
                    Name='APPROVAL_NO1'
                End
                Item
                    Name='BASEUNIT_DESC'
                End
                Item
                    Name='ACTUAL_PCS'
                End
                Item
                    Name='ACTUAL_QTY'
                End
                Item
                    Name='PRICE'
                End
                Item
                    Name='AMOUNT'
                End
                Item
                    Name='GOODS_LOTNO'
                End
                Item
                    Name='VALID_UNTIL'
                End
                Item
                    Name='OPERATOR'
                End
                Item
                    Name='Reportbill_Clerk'
                End
                Item
                    Name='tel'
                End
                Item
                    Name='PRINT_SHTXD_FAHR'
                End
                Item
                    Name='PRINT_SHTXD_FUHR'
                End
                Item
                    Name='stock_status'
                End
                Item
                    Name='OWNER_NO'
                End
                Item
                    Name='RECEIVING_CLERK'
                End
                Item
                    Name='MANUFACTURER_LICENSE'
                End
                Item
                    Name='STORAGE_CONDITION'
                End
                Item
                    Name='PRINT_TIMES'
                End
                Item
                    Name='PRODUCTION_DATE'
                End
                Item
                    Name='INVOICE_TIME'
                    Type=DateTime
                    Format='yyyy/MM/dd'
                End
                Item
                    Name='ZJS'
                End
                Item
                    Name='PRODUCT_CODE'
                End
                Item
                    Name='HZD_SIGN'
                End
                Item
                    Name='SETTLEUP_PRICE'
                End
            End
        End
        Items Column
            Item
                Name='AMOUNT'
                Width=2.1
            End
            Item
                Name='MNEMONIC_CODE'
                Width=2.2
            End
            Item
                Name='Column1'
                Width=1.40229
            End
            Item
                Name='Column2'
                Width=2.19604
            End
            Item
                Name='Column3'
                Width=1.75
            End
            Item
                Name='Column5'
                Width=1.3
            End
            Item
                Name='Column8'
                Width=1
            End
            Item
                Name='Column9'
                Width=1.4
            End
            Item
                Name='Column10'
                Width=2
            End
            Item
                Name='Column11'
                Width=1.6
            End
            Item
                Name='Column12'
                Width=1.00542
            End
            Item
                Name='Column13'
                Width=1.56104
            End
            Item
                Name='Column14'
                Width=1.65
            End
            Item
                Name='Column15'
                Width=1.5
            End
            Item
                Name='Column16'
                Width=0.9
            End
            Item
                Name='Column17'
                Width=2.1
            End
            Item
                Name='Column18'
                Width=1.37583
            End
        End
        Object ColumnContent
            Height=1.2
            Object Font
                Name='宋体'
                Size=90000,0
                Weight=400
                Charset=134
            End
            AdjustRowHeight=F
            RowsPerPage=6
            Items ColumnContentCell
                Item
                    Column='AMOUNT'
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='LOGISTICS_DESC'
                End
                Item
                    Column='MNEMONIC_CODE'
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='DRUG_SPEC'
                End
                Item
                    Column='Column1'
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='DOSAGE_FORM'
                End
                Item
                    Column='Column2'
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='MARKETINGAUTHORISATIONHOLDER'
                End
                Item
                    Column='Column3'
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='APPROVAL_NO'
                End
                Item
                    Column='Column5'
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='ACTUAL_QTY'
                End
                Item
                    Column='Column8'
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='BASEUNIT_DESC'
                End
                Item
                    Column='Column9'
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='PRICE'
                End
                Item
                    Column='Column10'
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='MANUFACTURER_NAME'
                End
                Item
                    Column='Column11'
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='AMOUNT'
                End
                Item
                    Column='Column12'
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='ACTUAL_PCS'
                End
                Item
                    Column='Column13'
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='GOODS_LOTNO'
                End
                Item
                    Column='Column14'
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='PRODUCTION_DATE'
                End
                Item
                    Column='Column15'
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='VALID_UNTIL'
                End
                Item
                    Column='Column16'
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='stock_status'
                End
                Item
                    Column='Column17'
                    WordWrap=T
                    DataField='PRODUCT_CODE'
                End
                Item
                    Column='Column18'
                    TextAlign=MiddleCenter
                    DataField='SETTLEUP_PRICE'
                End
            End
        End
        Object ColumnTitle
            Height=0.8
            Object Font
                Name='宋体'
                Size=90000,0
                Weight=400
                Charset=134
            End
            RepeatStyle=OnPage
            Items ColumnTitleCell
                Item
                    GroupTitle=F
                    Column='Column17'
                    TextAlign=MiddleCenter
                    Text='产品代码'
                End
                Item
                    GroupTitle=F
                    Column='AMOUNT'
                    TextAlign=MiddleCenter
                    Text='通用名称'
                End
                Item
                    GroupTitle=F
                    Column='MNEMONIC_CODE'
                    TextAlign=MiddleCenter
                    Text='规格'
                End
                Item
                    GroupTitle=F
                    Column='Column2'
                    WordWrap=T
                    TextAlign=MiddleCenter
                    ShrinkFontToFit=T
                    Text='药品上市许可持有人'
                End
                Item
                    GroupTitle=F
                    Column='Column10'
                    TextAlign=MiddleCenter
                    Text='生产厂商'
                End
                Item
                    GroupTitle=F
                    Column='Column1'
                    TextAlign=MiddleCenter
                    Text='剂型'
                End
                Item
                    GroupTitle=F
                    Column='Column3'
                    TextAlign=MiddleCenter
                    Text='批准文号'
                End
                Item
                    GroupTitle=F
                    Column='Column8'
                    TextAlign=MiddleCenter
                    Text='单位'
                End
                Item
                    GroupTitle=F
                    Column='Column5'
                    TextAlign=MiddleCenter
                    Text='数量'
                End
                Item
                    GroupTitle=F
                    Column='Column9'
                    TextAlign=MiddleCenter
                    Text='单价'
                End
                Item
                    GroupTitle=F
                    Column='Column18'
                    TextAlign=MiddleCenter
                    Text='折让'
                End
                Item
                    GroupTitle=F
                    Column='Column11'
                    TextAlign=MiddleCenter
                    Text='金额'
                End
                Item
                    GroupTitle=F
                    Column='Column12'
                    TextAlign=MiddleCenter
                    Text='件数'
                End
                Item
                    GroupTitle=F
                    Column='Column13'
                    TextAlign=MiddleCenter
                    Text='批号'
                End
                Item
                    GroupTitle=F
                    Column='Column14'
                    TextAlign=MiddleCenter
                    Text='生产日期'
                End
                Item
                    GroupTitle=F
                    Column='Column15'
                    TextAlign=MiddleCenter
                    Text='有效期至'
                End
                Item
                    GroupTitle=F
                    Column='Column16'
                    TextAlign=MiddleCenter
                    Text='质量\r\n状况'
                End
            End
        End
    End
    Items Section
        Item
            Type=ReportHeader
            Name='ReportHeader1'
            Height=4.20688
            Object Font
                Name='宋体'
                Size=120000,0
                Weight=400
                Charset=134
            End
            Items Control
                Item
                    Type=MemoBox
                    Name='MemoBox2'
                    Left=7.40833
                    Top=0.211667
                    Width=14.2081
                    Height=0.978958
                    Object Font
                        Name='宋体'
                        Size=180000,0
                        Bold=T
                        Charset=134
                    End
                    TextAlign=MiddleCenter
                    Text='河南羚锐医药有限公司销售结算单'
                End
                Item
                    Type=StaticBox
                    Name='StaticBox8'
                    Left=20.4788
                    Top=1.5875
                    Width=2.09021
                    Height=0.65
                    Object Font
                        Name='宋体'
                        Size=90000,0
                        Weight=400
                        Charset=134
                    End
                    Text='收货人：'
                End
                Item
                    Type=StaticBox
                    Name='StaticBox9'
                    Left=0.211667
                    Top=1.5875
                    Width=1.905
                    Height=0.65
                    Object Font
                        Name='宋体'
                        Size=90000,0
                        Weight=400
                        Charset=134
                    End
                    Text='收货单位：'
                End
                Item
                    Type=FieldBox
                    Name='FieldBox14'
                    Left=2.27542
                    Top=1.5875
                    Width=17.8065
                    Height=0.65
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    TextAlign=MiddleCenter
                    DataField='SSA_NAME'
                End
                Item
                    Type=FieldBox
                    Name='FieldBox43'
                    Left=22.9923
                    Top=1.5875
                    Width=3.81
                    Height=0.65
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    TextAlign=MiddleCenter
                    DataField='RECEIVING_CLERK'
                End
                Item
                    Type=StaticBox
                    Name='StaticBox27'
                    Left=0.21
                    Top=2.19604
                    Width=1.905
                    Height=1.21708
                    Object Font
                        Name='宋体'
                        Size=90000,0
                        Weight=400
                        Charset=134
                    End
                    Text='收货地址：'
                End
                Item
                    Type=FieldBox
                    Name='FieldBox45'
                    Left=2.28
                    Top=2.19604
                    Width=17.7271
                    Height=1.21708
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='SSA_STORE_ADDR'
                End
                Item
                    Type=Line
                    Name='Line1'
                    Top=2.19604
                    Width=27.05
                End
                Item
                    Type=Line
                    Name='Line3'
                    Left=27.014
                    Top=1.57
                    Height=2.64
                End
                Item
                    Type=Line
                    Name='Line4'
                    Top=1.57
                    Height=2.63
                End
                Item
                    Type=Line
                    Name='Line7'
                    Top=1.57
                    Width=27.05
                End
                Item
                    Type=StaticBox
                    Name='StaticBox38'
                    Left=0.21
                    Top=3.41313
                    Width=1.59
                    Height=0.79375
                    Object Font
                        Name='宋体'
                        Size=90000,0
                        Weight=400
                        Charset=134
                    End
                    Text='业务员：'
                End
                Item
                    Type=FieldBox
                    Name='FieldBox48'
                    Left=2.06375
                    Top=3.41313
                    Width=2.09021
                    Height=0.79375
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='BUSINESSMAN'
                End
                Item
                    Type=StaticBox
                    Name='StaticBox39'
                    Left=5.21229
                    Top=3.41313
                    Width=1.8
                    Height=0.79375
                    Object Font
                        Name='宋体'
                        Size=90000,0
                        Weight=400
                        Charset=134
                    End
                    Text='运输方式：'
                End
                Item
                    Type=FieldBox
                    Name='FieldBox49'
                    Left=7.19667
                    Top=3.41313
                    Width=5.60917
                    Height=0.79375
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='TRANSPORT_TYPE'
                End
                Item
                    Type=StaticBox
                    Name='StaticBox40'
                    Left=14.2081
                    Top=3.41313
                    Width=1.905
                    Height=0.79375
                    Object Font
                        Name='宋体'
                        Size=90000,0
                        Weight=400
                        Charset=134
                    End
                    Text='销售日期：'
                End
                Item
                    Type=FieldBox
                    Name='FieldBox50'
                    Left=16.1925
                    Top=3.41313
                    Width=2.83104
                    Height=0.79375
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    WordWrap=T
                    DataField='INVOICE_TIME'
                End
                Item
                    Type=StaticBox
                    Name='StaticBox41'
                    Left=20.48
                    Top=3.41313
                    Width=2.03729
                    Height=0.79375
                    Object Font
                        Name='宋体'
                        Size=90000,0
                        Weight=400
                        Charset=134
                    End
                    Text='单据编号：'
                End
                Item
                    Type=Line
                    Name='Line10'
                    Left=4.20688
                    Top=3.41313
                    Height=0.8
                End
                Item
                    Type=Line
                    Name='Line11'
                    Left=13.7319
                    Top=3.41
                    Height=0.8
                End
                Item
                    Type=Line
                    Name='Line13'
                    Left=2.1
                    Top=1.57
                    Height=2.65
                End
                Item
                    Type=Line
                    Name='Line14'
                    Left=20.3729
                    Top=1.5875
                    Height=2.61938
                End
                Item
                    Type=StaticBox
                    Name='StaticBox42'
                    Left=20.48
                    Top=2.40771
                    Width=1.61396
                    Height=0.79375
                    Object Font
                        Name='宋体'
                        Size=90000,0
                        Weight=400
                        Charset=134
                    End
                    Text='电话：'
                End
                Item
                    Type=FieldBox
                    Name='FieldBox51'
                    Left=22.99
                    Top=2.40771
                    Width=3.81
                    Height=0.79375
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='tel'
                End
                Item
                    Type=FieldBox
                    Name='FieldBox52'
                    Left=22.99
                    Top=3.41313
                    Width=3.81
                    Height=0.79375
                    WordWrap=T
                    TextAlign=MiddleCenter
                    DataField='BUSINESSBILL_NO'
                End
                Item
                    Type=StaticBox
                    Name='StaticBox46'
                    Left=23.495
                    Top=0.79375
                    Width=2.01083
                    Height=0.65
                    Object Font
                        Name='宋体'
                        Size=105000,0
                        Weight=400
                        Charset=134
                    End
                    Text='打印次数：'
                End
                Item
                    Type=FieldBox
                    Name='FieldBox56'
                    Left=25.3735
                    Top=0.79375
                    Width=1.37583
                    Height=0.65
                    DataField='PRINT_TIMES'
                End
                Item
                    Type=Line
                    Name='Line26'
                    Left=22.9394
                    Top=1.5875
                    Height=2.62563
                End
                Item
                    Type=Line
                    Name='Line8'
                    Top=3.41313
                    Width=27.05
                End
                Item
                    Type=FieldBox
                    Name='FieldBox57'
                    Left=0.264583
                    Top=0.687917
                    Width=6.64104
                    Height=0.873125
                    Object Font
                        Name='宋体'
                        Size=90000,0
                        Weight=400
                        Charset=134
                    End
                    WordWrap=T
                    TextAlign=TopLeft
                    DataField='HZD_SIGN'
                End
            End
            RepeatOnPage=T
            CenterWithDetailGrid=F
        End
        Item
            Type=ReportFooter
            Name='ReportFooter1'
            Height=2.19604
            Object Font
                Name='宋体'
                Size=90000,0
                Weight=400
                Charset=134
            End
            Items Control
                Item
                    Type=SystemVarBox
                    Name='SystemVarBox1'
                    Left=18.8119
                    Top=1.40229
                    Width=2.59292
                    Height=0.608542
                    Visible=F
                    GetDisplayTextScript='if(Report.FieldByName("BUSINESSBILL_NO").AsString == "")\r\n{\r\n    Sender.DisplayText ="";\r\n}'
                    Format='yyyy/MM/dd'
                    SystemVar=CurrentDateTime
                End
                Item
                    Type=FieldBox
                    Name='FieldBox12'
                    Left=23.0981
                    Top=0.105833
                    Width=3.73063
                    Height=0.79375
                    Object Font
                        Name='宋体'
                        Weight=400
                        Charset=134
                    End
                    ShrinkFontToFit=T
                    TextAlign=MiddleCenter
                    DataField='ZJS'
                End
                Item
                    Type=SummaryBox
                    Name='SummaryBox10'
                    Left=2.11667
                    Width=12.2238
                    Height=1.00542
                    TextAlign=MiddleCenter
                    GetDisplayTextScript='if(Report.FieldByName("BUSINESSBILL_NO").AsString == "")\r\n{\r\n    Sender.DisplayText ="";\r\n}'
                    DataField='AMOUNT'
                    Format='$$'
                End
                Item
                    Type=StaticBox
                    Name='StaticBox47'
                    BorderStyles=[DrawLeft|DrawRight]
                    Width=2.1
                    Height=1
                    WordWrap=T
                    TextAlign=MiddleCenter
                    Text='合计金额(大写)'
                End
                Item
                    Type=StaticBox
                    Name='StaticBox48'
                    Left=14.896
                    Width=1.05833
                    Height=1.00542
                    Object Font
                        Name='宋体'
                        Weight=400
                        Charset=134
                    End
                    WordWrap=T
                    TextAlign=MiddleCenter
                    Text='合计金额'
                End
                Item
                    Type=SummaryBox
                    Name='SummaryBox11'
                    Left=16.219
                    Width=4.1275
                    Height=1.00542
                    TextAlign=MiddleCenter
                    GetDisplayTextScript='if(Report.FieldByName("BUSINESSBILL_NO").AsString == "")\r\n{\r\n    Sender.DisplayText ="";\r\n}'
                    DataField='AMOUNT'
                    Format='0.00'
                End
                Item
                    Type=StaticBox
                    Name='StaticBox49'
                    Left=20.7963
                    Width=1.79917
                    Height=1.00542
                    Object Font
                        Name='宋体'
                        Weight=400
                        Charset=134
                    End
                    TextAlign=MiddleCenter
                    Text='合计件数'
                End
                Item
                    Type=FieldBox
                    Name='FieldBox46'
                    Left=1.19063
                    Top=1.19063
                    Width=4.20688
                    Height=0.608542
                    DataField='PRINT_SHTXD_FUHR'
                End
                Item
                    Type=StaticBox
                    Name='StaticBox28'
                    Top=1.19063
                    Width=1.00542
                    Height=0.608542
                    Text='复核：'
                End
                Item
                    Type=StaticBox
                    Name='StaticBox29'
                    Left=7.40833
                    Top=1.19063
                    Width=1.19063
                    Height=0.608542
                    Text='发货员：'
                End
                Item
                    Type=StaticBox
                    Name='StaticBox30'
                    Left=13.9965
                    Top=1.19063
                    Width=1.61396
                    Height=0.608542
                    Text='发货日期：'
                End
                Item
                    Type=FieldBox
                    Name='FieldBox53'
                    Left=8.81062
                    Top=1.19063
                    Width=3.99521
                    Height=0.608542
                    DataField='PRINT_SHTXD_FAHR'
                End
                Item
                    Type=StaticBox
                    Name='StaticBox45'
                    Left=20.664
                    Top=1.08479
                    Width=1.61396
                    Height=0.608542
                    Text='公司地址：'
                End
                Item
                    Type=FieldBox
                    Name='FieldBox55'
                    Left=22.2515
                    Top=1.16417
                    Width=4.73604
                    Height=0.873125
                    TextAlign=TopLeft
                    DataField='MANUFACTURER_ADDRESS'
                End
                Item
                    Type=Line
                    Name='Line20'
                    Left=22.9394
                    Height=1
                End
                Item
                    Type=Line
                    Name='Line21'
                    Left=20.3994
                    Height=1
                End
                Item
                    Type=Line
                    Name='Line22'
                    Left=14.7373
                    Height=1
                End
                Item
                    Type=Line
                    Name='Line23'
                    Left=16.0338
                    Height=1
                End
                Item
                    Type=Line
                    Name='Line24'
                    Top=1.00542
                    Width=27.05
                End
                Item
                    Type=Line
                    Name='Line25'
                    Left=27.01
                    Height=1
                End
                Item
                    Type=FieldBox
                    Name='FieldBox58'
                    Left=15.8485
                    Top=1.21708
                    Width=2.80458
                    Height=0.582083
                    TextAlign=MiddleCenter
                    DataField='INCHK_COMPLETED_TIME'
                End
            End
            KeepTogether=F
            RepeatOnPage=T
            CenterWithDetailGrid=F
        End
    End
End