File: C:/Users/fred/OneDrive/Desktop/PremiumSoft/Navicat MySQL/report_sample/report_sample/crosstab.rtm
object ppReport: TppReport
AutoStop = False
DataPipeline = plCustomer
PassSetting = psTwoPass
PrinterSetup.BinName = 'Default'
PrinterSetup.DocumentName = 'Report'
PrinterSetup.Orientation = poLandscape
PrinterSetup.PaperName = 'A4'
PrinterSetup.PrinterName = 'Default'
PrinterSetup.mmMarginBottom = 6350
PrinterSetup.mmMarginLeft = 6350
PrinterSetup.mmMarginRight = 6350
PrinterSetup.mmMarginTop = 6350
PrinterSetup.mmPaperHeight = 210079
PrinterSetup.mmPaperWidth = 297127
PrinterSetup.PaperSize = 9
Template.FileName = 'C:\WINDOWS\DESKTOP\nick\report_sample\crosstab.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 = 13229
mmPrintPosition = 0
object ppLabel1: TppLabel
UserName = 'Label1'
Caption = 'Annual Sales'
Font.Charset = DEFAULT_CHARSET
Font.Color = clBlack
Font.Name = 'Arial'
Font.Size = 12
Font.Style = [fsBold]
Transparent = True
mmHeight = 5027
mmLeft = 0
mmTop = 0
mmWidth = 26458
BandType = 0
end
object ppSystemVariable1: TppSystemVariable
UserName = 'SystemVariable1'
VarType = vtPrintDateTime
Font.Charset = DEFAULT_CHARSET
Font.Color = clBlack
Font.Name = 'Arial'
Font.Size = 10
Font.Style = []
Transparent = True
mmHeight = 4233
mmLeft = 4233
mmTop = 7938
mmWidth = 28310
BandType = 0
end
object ppSystemVariable2: TppSystemVariable
UserName = 'SystemVariable2'
VarType = vtPageSetDesc
Font.Charset = DEFAULT_CHARSET
Font.Color = clBlack
Font.Name = 'Arial'
Font.Size = 10
Font.Style = []
Transparent = True
mmHeight = 4233
mmLeft = 228071
mmTop = 7938
mmWidth = 17463
BandType = 0
end
end
object ppDetailBand1: TppDetailBand
PrintHeight = phDynamic
mmBottomOffset = 0
mmHeight = 13229
mmPrintPosition = 0
object ppCrossTab1: TppCrossTab
UserName = 'CrossTab1'
DataPipeline = plCustomer
Pagination = ctptAcrossThenDown
Stretch = True
Style = 'Standard'
mmHeight = 5027
mmLeft = 0
mmTop = 5292
mmWidth = 284427
BandType = 4
mmBottomOffset = 0
mmOverFlowOffset = 0
mmStopPosition = 0
object TppGrandTotal
ChildType = 6
object TppTotalCaptionDef
ChildType = 4
Alignment = taRightJustify
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
object TppTotalDef
ChildType = 3
Color = clWhite
DisplayFormat = '$#,0.00;($#,0.00)'
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
end
object TppGrandTotal
ChildType = 6
object TppTotalCaptionDef
ChildType = 4
Alignment = taRightJustify
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
object TppTotalDef
ChildType = 3
Color = clWhite
DisplayFormat = '$#,0.00;($#,0.00)'
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
end
object TppGrandTotal
ChildType = 6
object TppTotalCaptionDef
ChildType = 4
Alignment = taRightJustify
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
object TppTotalDef
ChildType = 3
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
end
object TppGrandTotal
ChildType = 7
object TppTotalCaptionDef
ChildType = 4
Color = clWindow
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
object TppTotalDef
ChildType = 3
Color = clSilver
DisplayFormat = '$#,0.00;($#,0.00)'
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
end
object TppGrandTotal
ChildType = 7
object TppTotalCaptionDef
ChildType = 4
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
object TppTotalDef
ChildType = 3
Color = clWhite
DisplayFormat = '$#,0.00;($#,0.00)'
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
end
object TppGrandTotal
ChildType = 7
object TppTotalCaptionDef
ChildType = 4
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
object TppTotalDef
ChildType = 3
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
end
object TppColumnDef
FieldAlias = 'SaleMonth'
FieldName = 'Extract_Month_from_SaleDa'
Color = clWindow
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
object TppSubTotal
ChildType = 5
object TppTotalCaptionDef
ChildType = 4
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
object TppTotalDef
ChildType = 3
Color = clWhite
DisplayFormat = '$#,0.00;($#,0.00)'
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
end
object TppSubTotal
ChildType = 5
object TppTotalCaptionDef
ChildType = 4
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
object TppTotalDef
ChildType = 3
Color = clWhite
DisplayFormat = '$#,0.00;($#,0.00)'
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
end
object TppSubTotal
ChildType = 5
object TppTotalCaptionDef
ChildType = 4
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
object TppTotalDef
ChildType = 3
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
end
end
object TppRowDef
ChildType = 1
FieldAlias = 'State'
FieldName = 'State'
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
object TppSubTotal
ChildType = 5
object TppTotalCaptionDef
ChildType = 4
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
object TppTotalDef
ChildType = 3
Color = clWhite
DisplayFormat = '$#,0.00;($#,0.00)'
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
end
object TppSubTotal
ChildType = 5
object TppTotalCaptionDef
ChildType = 4
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
object TppTotalDef
ChildType = 3
Color = clWhite
DisplayFormat = '$#,0.00;($#,0.00)'
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
end
object TppSubTotal
ChildType = 5
object TppTotalCaptionDef
ChildType = 4
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
object TppTotalDef
ChildType = 3
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
end
end
object TppValueDef
ChildType = 2
FieldAlias = 'Sale Amount'
FieldName = 'AmountPaid'
Color = clWindow
DisplayFormat = '$#,0.00;($#,0.00)'
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
object TppValueCaptionDef
ChildType = 8
CalcType = dcSum
Color = clWindow
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
end
object TppValueDef
ChildType = 2
FieldAlias = 'Sale Amount'
FieldName = 'AmountPaid'
Color = clWhite
DisplayFormat = '$#,0.00;($#,0.00)'
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
object TppValueCaptionDef
ChildType = 8
CalcType = dcAverage
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
end
object TppValueDef
ChildType = 2
FieldAlias = 'Sale Amount'
FieldName = 'AmountPaid'
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
object TppValueCaptionDef
ChildType = 8
CalcType = dcCount
Color = clWhite
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = 'Arial'
Font.Style = []
end
end
end
end
object ppFooterBand1: TppFooterBand
mmBottomOffset = 0
mmHeight = 13229
mmPrintPosition = 0
end
object daDataModule1: TdaDataModule
object daMySQLQueryDataView1: TdaMySQLQueryDataView
Report = ppReport
UserName = 'Query_plCustomer'
Height = 313
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
object ppField35: TppField
FieldAlias = 'Extract_Month_from_SaleDa'
FieldName = 'Extract_Month_from_SaleDa'
FieldLength = 0
DataType = dtLongint
DisplayWidth = 15
Position = 34
end
end
object daSQL1: TdaSQL
DatabaseName = 'report_sample'
DatabaseType = dtMySQL
DataPipelineName = 'plCustomer'
EditSQLAsText = True
LinkColor = clMaroon
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, '
' (Month(SaleDate)) as Extract_Month_from_SaleDa'
'FROM customer customer, orders orders'
'WHERE (orders.CustNo = customer.CustNo)'
'')
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
object TdaField
Alias = 'Extract_Month_from_SaleDa'
DataType = dtLongint
DisplayWidth = 15
FieldAlias = 'Extract_Month_from_SaleDa'
FieldLength = 0
FieldName = 'Extract_Month_from_SaleDa'
SQLFieldName = 'Extract_Month_from_SaleDa'
end
end
end
end
end