CSVTitle DBColumn CZCaption DBDefinition DBType Example1 Example2 Country Country Země [Country] [nvarchar](4) NULL, [nvarchar](4) CZ CZ Store Store Prodejna [Store] [int] NULL, [int] 178 178 Create Date CreateDate Datum vytvoření [CreateDate] [datetime] NULL, [datetime] 10.11.2014 10.11.2014 Create Time CreateTime Čas vytvoření [CreateTime] [datetime] NULL, [datetime] 9:46 9:49 OrderNo OrderNo Číslo objednávky [OrderNo] [int] NULL, [int] 597568527 597569467 ServiceNo ServiceNo Číslo služby [ServiceNo] [int] NULL, [int] 8165526 8165436 Goods value GoodsValue Hodnota zboží [GoodsValue] [int] NULL, [int] 115818 25886 Booked Qty BookedQty Množství zboží [BookedQty] [int] NULL, [int] 1 1 Service Value ServiceValue Hodnota služby [ServiceValue] [int] NULL, [int] 2990 1990 Volume(m3) VolumeM3 Objem(m3) [VolumeM3] [float] NULL, [float] 3,239436 0,705087 Weight(kg) WeightKg Váha(kg) [WeightKg] [float] NULL, [float] 856,476 237,128 No of pack NoOfPack Balíků [NoOfPack] [int] NULL, [int] 146 55 Article No ArticleNo Číslo zboží [ArticleNo] [int] NULL, [int] 30000536 30000536 Service Type ServiceType Druh služby [ServiceType] [nvarchar](255) NULL, [nvarchar](255) Zličín - doprava zboží nad 50 000 zóna 1 s donáškou Zličín - doprava zboží 25 001 - 50 000 zóna 1 s donáškou Service Provider ServiceProvider Společnost [ServiceProvider] [nvarchar](64) NULL, [nvarchar](64) Dopravna spolecnost Dopravna spolecnost Service status ServiceStatus Status služby [ServiceStatus] [nvarchar](32) NULL, [nvarchar](32) CREATED CREATED Date of status change DateOfStatusChange Datum změny [DateOfStatusChange] [datetime] NULL, [datetime] 10.11.2014 10.11.2014 Payment status PaymentStatus Platba [PaymentStatus] [nvarchar](16) NULL, [nvarchar](16) PAID PAID Payment method PaymentMethod Metoda platby [PaymentMethod] [nvarchar](32) NULL, [nvarchar](32) CASH_ON_DATE CASH_ON_DATE Customer name CustomerName Jméno [CustomerName] [nvarchar](64) NULL, [nvarchar](64) Michal Test FIRMA xyz Street name StreetName Ulice [StreetName] [nvarchar](64) NULL, [nvarchar](64) Skandinavska Řevnická Street no StreetNo Číslo [StreetNo] [nvarchar](16) NULL, [nvarchar](16) nr: 15 nr: 170/4 Zip code ZipCode PSČ [ZipCode] [nvarchar](6) NULL, [nvarchar](6) 15500 15521 City City Město [City] [nvarchar](64) NULL, [nvarchar](64) Praha 515 Praha 517 Customer type CustomerType Typ zákazníka [CustomerType] [nvarchar](16) NULL, [nvarchar](16) PRIVATE BUSINESS Delivery destination phone DeliveryDestinationPhone Telefon1 [DeliveryDestinationPhone] [nvarchar](16) NULL, [nvarchar](16) Contact info phone ContactInfoPhone Telefon2 [ContactInfoPhone] [nvarchar](32) NULL, [nvarchar](32) 727 871 500 Delivery destination email DeliveryDestinationEmail Email1 [DeliveryDestinationEmail] [nvarchar](64) NULL, [nvarchar](64) Contact info email ContactInfoEmail Email2 [ContactInfoEmail] [nvarchar](64) NULL, [nvarchar](64) Invoice destination fax InvoiceDestinationFax Fax [InvoiceDestinationFax] [nvarchar](32) NULL, [nvarchar](32) Home phone HomePhone Telefon3 [HomePhone] [nvarchar](32) NULL, [nvarchar](32) Work phone WorkPhone Telefon4 [WorkPhone] [nvarchar](32) NULL, [nvarchar](32) Mobile phone MobilePhone Telefon5 [MobilePhone] [nvarchar](32) NULL, [nvarchar](32) 773610948 Home email HomeEmail Email3 [HomeEmail] [nvarchar](64) NULL, [nvarchar](64) Work email WorkEmail Email4 [WorkEmail] [nvarchar](64) NULL, [nvarchar](64) Wish date/Service WishDateService Datum doručení [WishDateService] [datetime] NULL, [datetime] 11.11.2014 11.11.2014 Wish date start time /Service WishDateStartTimeService Čas doručení OD [WishDateStartTimeService] [datetime] NULL, [datetime] 9:00 9:00 Wish date end time /Service WishDateEndTimeService Čas doručení DO [WishDateEndTimeService] [datetime] NULL, [datetime] 15:00 15:00 Agreed date/Service AgreedDateService Akceptované datum doručení [AgreedDateService] [datetime] NULL, [datetime] Agreed date start time/Service AgreedDateStartTimeService Akceptovaný čas doručení OD [AgreedDateStartTimeService] [datetime] NULL, [datetime] Agreed date end time /Service AgreedDateEndTimeService Akceptované čas doručení DO [AgreedDateEndTimeService] [datetime] NULL, [datetime] Related order RelatedOrder Související objednávka [RelatedOrder] [int] NULL, [int] 597566136 597568624 Message on order confirmation MessageOnOrderConfirmation Zpráva [MessageOnOrderConfirmation] [nvarchar](255) NULL, [nvarchar](255) /597566136/ /12/ /597026920/ z exteru