HEX
Server: Apache/2.4.46 (Win64) OpenSSL/1.1.1j PHP/8.4.25
System: Windows NT DESKTOP-4TAV2RJ 10.0 build 19045 (Windows 10) AMD64
User: fred (0)
PHP: 8.4.25
Disabled: NONE
Upload Files
File: C:/Program Files (x86)/PremiumSoft/Navicat MySQL/report_sample/report_sample/invoice.rtm
object ppReport: TppReport
  AutoStop = False
  DataPipeline = plCustomer
  PassSetting = psTwoPass
  PrinterSetup.BinName = 'Default'
  PrinterSetup.DocumentName = 'Report'
  PrinterSetup.PaperName = 'Letter'
  PrinterSetup.PrinterName = 'Default'
  PrinterSetup.mmMarginBottom = 6350
  PrinterSetup.mmMarginLeft = 6350
  PrinterSetup.mmMarginRight = 6350
  PrinterSetup.mmMarginTop = 6350
  PrinterSetup.mmPaperHeight = 279401
  PrinterSetup.mmPaperWidth = 215900
  PrinterSetup.PaperSize = 1
  SaveAsTemplate = True
  Template.FileName = 'C:\WINDOWS\DESKTOP\nick\report_sample\invoice.rtm'
  Template.Format = ftASCII
  DeviceType = 'Screen'
  Icon.Data = {
    0000010001002020100000000000E80200001600000028000000200000004000
    0000010004000000000080020000000000000000000000000000000000000000
    000000008000008000000080800080000000800080008080000080808000C0C0
    C0000000FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF000000
    0000000008870000000000000000000000000087700000008800000000000000
    0000000555507700757700000000000007000005555000585550080000000000
    0008877555555555555000000000000070000555555555555500800000000008
    0550555555555555555070000000000755555555555555555555070800000005
    5555555555555555555555757000000055555555555555555555555557000008
    5555555555555555555555555070000055555555555555555555555500700080
    5555555555500555555555500000770555555555500000055555555000000005
    5555555550780700555555557000005555555555000000705555555570007055
    5555555507000070555555558000755555555555570007005555555555800555
    5F55555557770005555555555580088755F55555550005555555555550800007
    55FF5555555555555555555050800008057FF555555555555555550000000000
    705FFF555555555555555508700000008055FFFFF55555555555570000000008
    00555FFFFF55555555555800000000000055555FF85555555555558000000000
    8005555555555555505555800000000000858870555555550005080000000000
    0000000800555588880080000000000000000000805555000088000000000000
    000000008000070000000000000000000000000008800000000000000000FFF8
    FFFFFFC0F3FFFFE030FFFBE0003FF800007FF000007FE000007FE000002FE000
    0007F0000003E0000001E0000001C000000300000007000080070003C0070003
    C007000380018000000180000001E0000001E0000003F0000003F000003FE000
    003FE000001FF000001FFC00003FFFE0007FFFF03CFFFFF03FFFFFF9FFFF}
  Left = 209
  Top = 164
  Version = '5.55'
  mmColumnWidth = 0
  object ppHeaderBand1: TppHeaderBand
    mmBottomOffset = 0
    mmHeight = 28575
    mmPrintPosition = 0
    object ppLine1: TppLine
      UserName = 'Line1'
      Pen.Color = clNavy
      Pen.Width = 2
      ParentWidth = True
      Position = lpBottom
      Weight = 1.5
      mmHeight = 3969
      mmLeft = 0
      mmTop = 24606
      mmWidth = 203200
      BandType = 0
    end
    object ppLabel2: TppLabel
      UserName = 'Label2'
      Caption = 'Company'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clTeal
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 0
      mmTop = 22754
      mmWidth = 15875
      BandType = 0
    end
    object ppLabel3: TppLabel
      UserName = 'Label3'
      Caption = 'Contact'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clTeal
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 50800
      mmTop = 22754
      mmWidth = 12700
      BandType = 0
    end
    object ppLabel4: TppLabel
      UserName = 'Label4'
      Caption = 'Order No.'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clTeal
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4763
      mmLeft = 104775
      mmTop = 22754
      mmWidth = 16933
      BandType = 0
    end
    object ppLabel5: TppLabel
      UserName = 'Label5'
      Caption = 'Amount Paid'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clTeal
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4763
      mmLeft = 134409
      mmTop = 22754
      mmWidth = 21696
      BandType = 0
    end
    object ppLabel1: TppLabel
      UserName = 'Label1'
      Caption = 'Invoice'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clTeal
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 20
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 8202
      mmLeft = 0
      mmTop = 0
      mmWidth = 21960
      BandType = 0
    end
  end
  object ppDetailBand1: TppDetailBand
    mmBottomOffset = 0
    mmHeight = 6085
    mmPrintPosition = 0
    object ppDBText3: TppDBText
      UserName = 'DBText3'
      DataField = 'OrderNo'
      DataPipeline = plCustomer
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3703
      mmLeft = 104775
      mmTop = 1270
      mmWidth = 16934
      BandType = 4
    end
    object ppDBText4: TppDBText
      UserName = 'DBText4'
      DataField = 'AmountPaid'
      DataPipeline = plCustomer
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3703
      mmLeft = 139172
      mmTop = 1270
      mmWidth = 16934
      BandType = 4
    end
  end
  object ppFooterBand1: TppFooterBand
    mmBottomOffset = 0
    mmHeight = 7144
    mmPrintPosition = 0
    object ppLine2: TppLine
      UserName = 'Line2'
      Pen.Color = clGray
      Pen.Width = 2
      Weight = 1.5
      mmHeight = 3969
      mmLeft = 1323
      mmTop = 5821
      mmWidth = 200555
      BandType = 8
    end
    object ppSystemVariable1: TppSystemVariable
      UserName = 'SystemVariable1'
      VarType = vtPrintDateTime
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clTeal
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 9
      Font.Style = []
      Transparent = True
      mmHeight = 3969
      mmLeft = 1323
      mmTop = 1323
      mmWidth = 26194
      BandType = 8
    end
    object ppSystemVariable2: TppSystemVariable
      UserName = 'SystemVariable2'
      VarType = vtPageSetDesc
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clTeal
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 9
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3969
      mmLeft = 187855
      mmTop = 1323
      mmWidth = 14023
      BandType = 8
    end
  end
  object ppGroup1: TppGroup
    BreakName = 'Company'
    DataPipeline = plCustomer
    NewPage = True
    ResetPageNo = True
    UserName = 'Group1'
    mmNewColumnThreshold = 0
    mmNewPageThreshold = 0
    object ppGroupHeaderBand1: TppGroupHeaderBand
      mmBottomOffset = 0
      mmHeight = 7620
      mmPrintPosition = 0
      object ppShape1: TppShape
        UserName = 'Shape1'
        Brush.Color = clAqua
        ParentHeight = True
        ParentWidth = True
        mmHeight = 7620
        mmLeft = 0
        mmTop = 0
        mmWidth = 203200
        BandType = 3
        GroupNo = 0
      end
      object ppDBText1: TppDBText
        UserName = 'DBText1'
        DataField = 'Company'
        DataPipeline = plCustomer
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        mmHeight = 3704
        mmLeft = 1323
        mmTop = 1852
        mmWidth = 48683
        BandType = 3
        GroupNo = 0
      end
      object ppDBText2: TppDBText
        UserName = 'DBText2'
        DataField = 'Contact'
        DataPipeline = plCustomer
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        mmHeight = 3704
        mmLeft = 51329
        mmTop = 1852
        mmWidth = 32808
        BandType = 3
        GroupNo = 0
      end
    end
    object ppGroupFooterBand1: TppGroupFooterBand
      mmBottomOffset = 0
      mmHeight = 7620
      mmPrintPosition = 0
      object ppShape2: TppShape
        UserName = 'Shape2'
        Brush.Color = clTeal
        ParentHeight = True
        ParentWidth = True
        mmHeight = 7620
        mmLeft = 0
        mmTop = 0
        mmWidth = 203200
        BandType = 5
        GroupNo = 0
      end
      object ppDBCalc1: TppDBCalc
        UserName = 'DBCalc1'
        AutoSize = True
        DataField = 'AmountPaid'
        DataPipeline = plCustomer
        DisplayFormat = '$#,0.00;($#,0.00)'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWhite
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        ResetGroup = ppGroup1
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3175
        mmLeft = 132821
        mmTop = 3704
        mmWidth = 23283
        BandType = 5
        GroupNo = 0
      end
    end
  end
  object daDataModule1: TdaDataModule
    object daMySQLQueryDataView1: TdaMySQLQueryDataView
      Report = ppReport
      UserName = 'Query_plCustomer'
      Height = 443
      Left = 10
      NameColumnWidth = 105
      SizeColumnWidth = 35
      SortMode = 0
      Top = 10
      TypeColumnWidth = 52
      Width = 200
      AutoSearchTabOrder = 0
      object plCustomer: TppChildDBPipeline
        AutoCreateFields = False
        UserName = 'plCustomer'
        object ppField1: TppField
          FieldAlias = 'Addr1'
          FieldName = 'Addr1'
          FieldLength = 30
          DisplayWidth = 30
          Position = 0
        end
        object ppField2: TppField
          FieldAlias = 'Addr2'
          FieldName = 'Addr2'
          FieldLength = 30
          DisplayWidth = 30
          Position = 1
        end
        object ppField3: TppField
          FieldAlias = 'City'
          FieldName = 'City'
          FieldLength = 15
          DisplayWidth = 15
          Position = 2
        end
        object ppField4: TppField
          FieldAlias = 'Company'
          FieldName = 'Company'
          FieldLength = 30
          DisplayWidth = 30
          Position = 3
        end
        object ppField5: TppField
          FieldAlias = 'Contact'
          FieldName = 'Contact'
          FieldLength = 20
          DisplayWidth = 20
          Position = 4
        end
        object ppField6: TppField
          FieldAlias = 'Country'
          FieldName = 'Country'
          FieldLength = 20
          DisplayWidth = 20
          Position = 5
        end
        object ppField7: TppField
          FieldAlias = 'CustNo_2'
          FieldName = 'CustNo_2'
          FieldLength = 0
          DataType = dtDouble
          DisplayWidth = 10
          Position = 6
        end
        object ppField8: TppField
          FieldAlias = 'FAX'
          FieldName = 'FAX'
          FieldLength = 15
          DisplayWidth = 15
          Position = 7
        end
        object ppField9: TppField
          FieldAlias = 'LastInvoiceDate'
          FieldName = 'LastInvoiceDate'
          FieldLength = 0
          DataType = dtDateTime
          DisplayWidth = 18
          Position = 8
        end
        object ppField10: TppField
          FieldAlias = 'Phone'
          FieldName = 'Phone'
          FieldLength = 15
          DisplayWidth = 15
          Position = 9
        end
        object ppField11: TppField
          FieldAlias = 'State'
          FieldName = 'State'
          FieldLength = 20
          DisplayWidth = 20
          Position = 10
        end
        object ppField12: TppField
          FieldAlias = 'TaxRate_2'
          FieldName = 'TaxRate_2'
          FieldLength = 0
          DataType = dtDouble
          DisplayWidth = 10
          Position = 11
        end
        object ppField13: TppField
          FieldAlias = 'Zip'
          FieldName = 'Zip'
          FieldLength = 10
          DisplayWidth = 10
          Position = 12
        end
        object ppField14: TppField
          FieldAlias = 'AmountPaid'
          FieldName = 'AmountPaid'
          FieldLength = 0
          DataType = dtDouble
          DisplayWidth = 10
          Position = 13
        end
        object ppField15: TppField
          FieldAlias = 'CustNo'
          FieldName = 'CustNo'
          FieldLength = 0
          DataType = dtDouble
          DisplayWidth = 10
          Position = 14
        end
        object ppField16: TppField
          FieldAlias = 'EmpNo'
          FieldName = 'EmpNo'
          FieldLength = 0
          DataType = dtLongint
          DisplayWidth = 15
          Position = 15
        end
        object ppField17: TppField
          FieldAlias = 'Freight'
          FieldName = 'Freight'
          FieldLength = 0
          DataType = dtDouble
          DisplayWidth = 10
          Position = 16
        end
        object ppField18: TppField
          FieldAlias = 'ItemsTotal'
          FieldName = 'ItemsTotal'
          FieldLength = 0
          DataType = dtDouble
          DisplayWidth = 10
          Position = 17
        end
        object ppField19: TppField
          FieldAlias = 'OrderNo'
          FieldName = 'OrderNo'
          FieldLength = 0
          DataType = dtDouble
          DisplayWidth = 10
          Position = 18
        end
        object ppField20: TppField
          FieldAlias = 'PO'
          FieldName = 'PO'
          FieldLength = 15
          DisplayWidth = 15
          Position = 19
        end
        object ppField21: TppField
          FieldAlias = 'PaymentMethod'
          FieldName = 'PaymentMethod'
          FieldLength = 7
          DisplayWidth = 7
          Position = 20
        end
        object ppField22: TppField
          FieldAlias = 'SaleDate'
          FieldName = 'SaleDate'
          FieldLength = 0
          DataType = dtDateTime
          DisplayWidth = 18
          Position = 21
        end
        object ppField23: TppField
          FieldAlias = 'ShipDate'
          FieldName = 'ShipDate'
          FieldLength = 0
          DataType = dtDateTime
          DisplayWidth = 18
          Position = 22
        end
        object ppField24: TppField
          FieldAlias = 'ShipToAddr1'
          FieldName = 'ShipToAddr1'
          FieldLength = 30
          DisplayWidth = 30
          Position = 23
        end
        object ppField25: TppField
          FieldAlias = 'ShipToAddr2'
          FieldName = 'ShipToAddr2'
          FieldLength = 30
          DisplayWidth = 30
          Position = 24
        end
        object ppField26: TppField
          FieldAlias = 'ShipToCity'
          FieldName = 'ShipToCity'
          FieldLength = 15
          DisplayWidth = 15
          Position = 25
        end
        object ppField27: TppField
          FieldAlias = 'ShipToContact'
          FieldName = 'ShipToContact'
          FieldLength = 20
          DisplayWidth = 20
          Position = 26
        end
        object ppField28: TppField
          FieldAlias = 'ShipToCountry'
          FieldName = 'ShipToCountry'
          FieldLength = 20
          DisplayWidth = 20
          Position = 27
        end
        object ppField29: TppField
          FieldAlias = 'ShipToPhone'
          FieldName = 'ShipToPhone'
          FieldLength = 15
          DisplayWidth = 15
          Position = 28
        end
        object ppField30: TppField
          FieldAlias = 'ShipToState'
          FieldName = 'ShipToState'
          FieldLength = 20
          DisplayWidth = 20
          Position = 29
        end
        object ppField31: TppField
          FieldAlias = 'ShipToZip'
          FieldName = 'ShipToZip'
          FieldLength = 10
          DisplayWidth = 10
          Position = 30
        end
        object ppField32: TppField
          FieldAlias = 'ShipVIA'
          FieldName = 'ShipVIA'
          FieldLength = 7
          DisplayWidth = 7
          Position = 31
        end
        object ppField33: TppField
          FieldAlias = 'TaxRate'
          FieldName = 'TaxRate'
          FieldLength = 0
          DataType = dtDouble
          DisplayWidth = 10
          Position = 32
        end
        object ppField34: TppField
          FieldAlias = 'Terms'
          FieldName = 'Terms'
          FieldLength = 6
          DisplayWidth = 6
          Position = 33
        end
      end
      object daSQL1: TdaSQL
        DatabaseName = 'report_sample'
        DatabaseType = dtMySQL
        DataPipelineName = 'plCustomer'
        EditSQLAsText = True
        LinkColor = clBlack
        MaxSQLFieldAliasLength = 0
        SQLText.Strings = (
          'SELECT customer.Addr1, customer.Addr2, '
          '       customer.City, customer.Company, '
          '       customer.Contact, customer.Country, '
          '       customer.CustNo CustNo_2, customer.FAX, '
          '       customer.LastInvoiceDate, customer.Phone, '
          '       customer.State, '
          '       customer.TaxRate TaxRate_2, customer.Zip, '
          '       orders.AmountPaid, orders.CustNo, '
          '       orders.EmpNo, orders.Freight, '
          '       orders.ItemsTotal, orders.OrderNo, '
          '       orders.PO, orders.PaymentMethod, '
          '       orders.SaleDate, orders.ShipDate, '
          '       orders.ShipToAddr1, orders.ShipToAddr2, '
          '       orders.ShipToCity, orders.ShipToContact, '
          '       orders.ShipToCountry, orders.ShipToPhone, '
          '       orders.ShipToState, orders.ShipToZip, '
          '       orders.ShipVIA, orders.TaxRate, '
          '       orders.Terms'
          'FROM customer customer, orders orders'
          'WHERE (orders.CustNo = customer.CustNo)'
          'ORDER BY customer.Company, orders.OrderNo')
        SQLType = sqSQL2
        object TdaField
          Alias = 'Addr1'
          DisplayWidth = 30
          FieldAlias = 'Addr1'
          FieldLength = 30
          FieldName = 'Addr1'
          SQLFieldName = 'Addr1'
        end
        object TdaField
          Alias = 'Addr2'
          DisplayWidth = 30
          FieldAlias = 'Addr2'
          FieldLength = 30
          FieldName = 'Addr2'
          SQLFieldName = 'Addr2'
        end
        object TdaField
          Alias = 'City'
          DisplayWidth = 15
          FieldAlias = 'City'
          FieldLength = 15
          FieldName = 'City'
          SQLFieldName = 'City'
        end
        object TdaField
          Alias = 'Company'
          DisplayWidth = 30
          FieldAlias = 'Company'
          FieldLength = 30
          FieldName = 'Company'
          SQLFieldName = 'Company'
        end
        object TdaField
          Alias = 'Contact'
          DisplayWidth = 20
          FieldAlias = 'Contact'
          FieldLength = 20
          FieldName = 'Contact'
          SQLFieldName = 'Contact'
        end
        object TdaField
          Alias = 'Country'
          DisplayWidth = 20
          FieldAlias = 'Country'
          FieldLength = 20
          FieldName = 'Country'
          SQLFieldName = 'Country'
        end
        object TdaField
          Alias = 'CustNo_2'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'CustNo_2'
          FieldLength = 0
          FieldName = 'CustNo_2'
          SQLFieldName = 'CustNo_2'
        end
        object TdaField
          Alias = 'FAX'
          DisplayWidth = 15
          FieldAlias = 'FAX'
          FieldLength = 15
          FieldName = 'FAX'
          SQLFieldName = 'FAX'
        end
        object TdaField
          Alias = 'LastInvoiceDate'
          DataType = dtDateTime
          DisplayWidth = 18
          FieldAlias = 'LastInvoiceDate'
          FieldLength = 0
          FieldName = 'LastInvoiceDate'
          SQLFieldName = 'LastInvoiceDate'
        end
        object TdaField
          Alias = 'Phone'
          DisplayWidth = 15
          FieldAlias = 'Phone'
          FieldLength = 15
          FieldName = 'Phone'
          SQLFieldName = 'Phone'
        end
        object TdaField
          Alias = 'State'
          DisplayWidth = 20
          FieldAlias = 'State'
          FieldLength = 20
          FieldName = 'State'
          SQLFieldName = 'State'
        end
        object TdaField
          Alias = 'TaxRate_2'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'TaxRate_2'
          FieldLength = 0
          FieldName = 'TaxRate_2'
          SQLFieldName = 'TaxRate_2'
        end
        object TdaField
          Alias = 'Zip'
          DisplayWidth = 10
          FieldAlias = 'Zip'
          FieldLength = 10
          FieldName = 'Zip'
          SQLFieldName = 'Zip'
        end
        object TdaField
          Alias = 'AmountPaid'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'AmountPaid'
          FieldLength = 0
          FieldName = 'AmountPaid'
          SQLFieldName = 'AmountPaid'
        end
        object TdaField
          Alias = 'CustNo'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'CustNo'
          FieldLength = 0
          FieldName = 'CustNo'
          SQLFieldName = 'CustNo'
        end
        object TdaField
          Alias = 'EmpNo'
          DataType = dtLongint
          DisplayWidth = 15
          FieldAlias = 'EmpNo'
          FieldLength = 0
          FieldName = 'EmpNo'
          SQLFieldName = 'EmpNo'
        end
        object TdaField
          Alias = 'Freight'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'Freight'
          FieldLength = 0
          FieldName = 'Freight'
          SQLFieldName = 'Freight'
        end
        object TdaField
          Alias = 'ItemsTotal'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'ItemsTotal'
          FieldLength = 0
          FieldName = 'ItemsTotal'
          SQLFieldName = 'ItemsTotal'
        end
        object TdaField
          Alias = 'OrderNo'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'OrderNo'
          FieldLength = 0
          FieldName = 'OrderNo'
          SQLFieldName = 'OrderNo'
        end
        object TdaField
          Alias = 'PO'
          DisplayWidth = 15
          FieldAlias = 'PO'
          FieldLength = 15
          FieldName = 'PO'
          SQLFieldName = 'PO'
        end
        object TdaField
          Alias = 'PaymentMethod'
          DisplayWidth = 7
          FieldAlias = 'PaymentMethod'
          FieldLength = 7
          FieldName = 'PaymentMethod'
          SQLFieldName = 'PaymentMethod'
        end
        object TdaField
          Alias = 'SaleDate'
          DataType = dtDateTime
          DisplayWidth = 18
          FieldAlias = 'SaleDate'
          FieldLength = 0
          FieldName = 'SaleDate'
          SQLFieldName = 'SaleDate'
        end
        object TdaField
          Alias = 'ShipDate'
          DataType = dtDateTime
          DisplayWidth = 18
          FieldAlias = 'ShipDate'
          FieldLength = 0
          FieldName = 'ShipDate'
          SQLFieldName = 'ShipDate'
        end
        object TdaField
          Alias = 'ShipToAddr1'
          DisplayWidth = 30
          FieldAlias = 'ShipToAddr1'
          FieldLength = 30
          FieldName = 'ShipToAddr1'
          SQLFieldName = 'ShipToAddr1'
        end
        object TdaField
          Alias = 'ShipToAddr2'
          DisplayWidth = 30
          FieldAlias = 'ShipToAddr2'
          FieldLength = 30
          FieldName = 'ShipToAddr2'
          SQLFieldName = 'ShipToAddr2'
        end
        object TdaField
          Alias = 'ShipToCity'
          DisplayWidth = 15
          FieldAlias = 'ShipToCity'
          FieldLength = 15
          FieldName = 'ShipToCity'
          SQLFieldName = 'ShipToCity'
        end
        object TdaField
          Alias = 'ShipToContact'
          DisplayWidth = 20
          FieldAlias = 'ShipToContact'
          FieldLength = 20
          FieldName = 'ShipToContact'
          SQLFieldName = 'ShipToContact'
        end
        object TdaField
          Alias = 'ShipToCountry'
          DisplayWidth = 20
          FieldAlias = 'ShipToCountry'
          FieldLength = 20
          FieldName = 'ShipToCountry'
          SQLFieldName = 'ShipToCountry'
        end
        object TdaField
          Alias = 'ShipToPhone'
          DisplayWidth = 15
          FieldAlias = 'ShipToPhone'
          FieldLength = 15
          FieldName = 'ShipToPhone'
          SQLFieldName = 'ShipToPhone'
        end
        object TdaField
          Alias = 'ShipToState'
          DisplayWidth = 20
          FieldAlias = 'ShipToState'
          FieldLength = 20
          FieldName = 'ShipToState'
          SQLFieldName = 'ShipToState'
        end
        object TdaField
          Alias = 'ShipToZip'
          DisplayWidth = 10
          FieldAlias = 'ShipToZip'
          FieldLength = 10
          FieldName = 'ShipToZip'
          SQLFieldName = 'ShipToZip'
        end
        object TdaField
          Alias = 'ShipVIA'
          DisplayWidth = 7
          FieldAlias = 'ShipVIA'
          FieldLength = 7
          FieldName = 'ShipVIA'
          SQLFieldName = 'ShipVIA'
        end
        object TdaField
          Alias = 'TaxRate'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'TaxRate'
          FieldLength = 0
          FieldName = 'TaxRate'
          SQLFieldName = 'TaxRate'
        end
        object TdaField
          Alias = 'Terms'
          DisplayWidth = 6
          FieldAlias = 'Terms'
          FieldLength = 6
          FieldName = 'Terms'
          SQLFieldName = 'Terms'
        end
      end
    end
  end
end