Sample of contents of tables in PhilFactor-AdventureWorks2012

  1. [dbo].[AWBuildVersion]
  2. [dbo].[DatabaseLog]
  3. [dbo].[ErrorLog]
  4. [dbo].[OurStuff]
  5. [HumanResources].[Department]
  6. [HumanResources].[Employee]
  7. [HumanResources].[EmployeeDepartmentHistory]
  8. [HumanResources].[EmployeePayHistory]
  9. [HumanResources].[JobCandidate]
  10. [HumanResources].[Shift]
  11. [Person].[Address]
  12. [Person].[AddressType]
  13. [Person].[BusinessEntity]
  14. [Person].[BusinessEntityAddress]
  15. [Person].[BusinessEntityContact]
  16. [Person].[ContactType]
  17. [Person].[CountryRegion]
  18. [Person].[EmailAddress]
  19. [Person].[Password]
  20. [Person].[Person]
  21. [Person].[PersonPhone]
  22. [Person].[PhoneNumberType]
  23. [Person].[StateProvince]
  24. [Production].[BillOfMaterials]
  25. [Production].[Culture]
  26. [Production].[Document]
  27. [Production].[Illustration]
  28. [Production].[Location]
  29. [Production].[Product]
  30. [Production].[ProductCategory]
  31. [Production].[ProductCostHistory]
  32. [Production].[ProductDescription]
  33. [Production].[ProductDocument]
  34. [Production].[ProductInventory]
  35. [Production].[ProductListPriceHistory]
  36. [Production].[ProductModel]
  37. [Production].[ProductModelIllustration]
  38. [Production].[ProductModelProductDescriptionCulture]
  39. [Production].[ProductPhoto]
  40. [Production].[ProductProductPhoto]
  41. [Production].[ProductReview]
  42. [Production].[ProductSubcategory]
  43. [Production].[ScrapReason]
  44. [Production].[TransactionHistory]
  45. [Production].[TransactionHistoryArchive]
  46. [Production].[UnitMeasure]
  47. [Production].[WorkOrder]
  48. [Production].[WorkOrderRouting]
  49. [Purchasing].[ProductVendor]
  50. [Purchasing].[PurchaseOrderDetail]
  51. [Purchasing].[PurchaseOrderHeader]
  52. [Purchasing].[ShipMethod]
  53. [Purchasing].[Vendor]
  54. [Sales].[CountryRegionCurrency]
  55. [Sales].[CreditCard]
  56. [Sales].[Currency]
  57. [Sales].[CurrencyRate]
  58. [Sales].[Customer]
  59. [Sales].[PersonCreditCard]
  60. [Sales].[SalesOrderDetail]
  61. [Sales].[SalesOrderHeader]
  62. [Sales].[SalesOrderHeaderSalesReason]
  63. [Sales].[SalesPerson]
  64. [Sales].[SalesPersonQuotaHistory]
  65. [Sales].[SalesReason]
  66. [Sales].[SalesTaxRate]
  67. [Sales].[SalesTerritory]
  68. [Sales].[SalesTerritoryHistory]
  69. [Sales].[ShoppingCartItem]
  70. [Sales].[SpecialOffer]
  71. [Sales].[SpecialOfferProduct]
  72. [Sales].[Store]
[dbo].[AWBuildVersion]
SystemInformationIDDatabase_VersionVersionDateModifiedDate
111.0.2100.602012-03-14T00:00:002012-03-14T00:00:00
[dbo].[DatabaseLog]
DatabaseLogIDPostTimeDatabaseUserEventSchemaObjectTSQLXmlEvent
12014-04-14T14:44:17.807dboCREATE_TABLEdboErrorLogCREATE TABLE [dbo].[ErrorLog]( [ErrorLogID] [int] IDENTITY (1, 1) NOT NULL, [ErrorTime] [dNULL
22014-04-14T14:44:17.830dboALTER_TABLEdboErrorLogALTER TABLE [dbo].[ErrorLog] WITH CHECK ADD CONSTRAINT [PK_ErrorLog_ErrorLogID] PRIMARY KEY CLNULL
52014-04-14T14:44:17.893dboCREATE_TYPEdboAccountNumberCREATE TYPE [AccountNumber] FROM nvarchar(15) NULL; NULL
[dbo].[ErrorLog]
ErrorLogID ErrorTime UserName ErrorNumber ErrorSeverity ErrorState ErrorProcedure ErrorLine ErrorMessage
[dbo].[OurStuff]
StuffIDStuffName
1abc
2def123
3456
[HumanResources].[Department]
DepartmentIDNameGroupNameModifiedDate
1EngineeringResearch and Development2002-06-01T00:00:00
2Tool DesignResearch and Development2002-06-01T00:00:00
3SalesSales and Marketing2002-06-01T00:00:00
[HumanResources].[Employee]
BusinessEntityIDNationalIDNumberLoginIDOrganizationNodeOrganizationLevelJobTitleBirthDateMaritalStatusGenderHireDateSalariedFlagVacationHoursSickLeaveHoursCurrentFlagrowguidModifiedDate
1295847284adventure-works\ken0/0Chief Executive Officer1963-03-02SM2003-02-15199691F01251E5-96A3-448D-981E-0F99D789110D2008-07-31T00:00:00
2245797967adventure-works\terri0/1/1Vice President of Engineering1965-09-01SF2002-03-031120145E8F437-670D-4409-93CB-F9424A40D6EE2008-07-31T00:00:00
3509647174adventure-works\roberto0/1/1/2Engineering Manager1968-12-13MM2001-12-12122119BBBFB2C-EFBB-4217-9AB7-F976893288412008-07-31T00:00:00
[HumanResources].[EmployeeDepartmentHistory]
BusinessEntityIDDepartmentIDShiftIDStartDateEndDateModifiedDate
11612003-02-15NULL2003-02-14T00:00:00
2112002-03-03NULL2002-03-02T00:00:00
3112001-12-12NULL2001-12-11T00:00:00
[HumanResources].[EmployeePayHistory]
BusinessEntityIDRateChangeDateRatePayFrequencyModifiedDate
12003-02-15T00:00:00125.500022008-07-31T00:00:00
22002-03-03T00:00:0063.461522008-07-31T00:00:00
32001-12-12T00:00:0043.269222008-07-31T00:00:00
[HumanResources].[JobCandidate]
JobCandidateIDBusinessEntityIDResumeModifiedDate
1NULLNULL2001-07-24T00:00:00
2NULLNULL2001-07-24T00:00:00
3NULLNULL2001-07-24T00:00:00
[HumanResources].[Shift]
ShiftIDNameStartTimeEndTimeModifiedDate
1Day07:00:0015:00:002002-06-01T00:00:00
2Evening15:00:0023:00:002002-06-01T00:00:00
3Night23:00:0007:00:002002-06-01T00:00:00
[Person].[Address]
AddressIDAddressLine1AddressLine2CityStateProvinceIDPostalCodeSpatialLocationrowguidModifiedDate
11970 Napa Ct.NULLBothell7998011POINT (-122.164644615406 47.7869921906598)9AADCB0D-36CF-483F-84D8-585C2D4EC6E92002-01-04T00:00:00
29833 Mt. Dias Blv.NULLBothell7998011POINT (-122.250185528911 47.6867097047995)32A54B9E-E034-4BFB-B573-A71CDE60D8C02003-01-01T00:00:00
37484 Roundtree DriveNULLBothell7998011POINT (-122.274625789912 47.7631154083121)4C506923-6D1B-452C-A07C-BAA6F5B142A42007-04-08T00:00:00
[Person].[AddressType]
AddressTypeIDNamerowguidModifiedDate
1BillingB84F78B1-4EFE-4A0E-8CB7-70E9F112F8862002-06-01T00:00:00
2Home41BC2FF6-F0FC-475F-8EB9-CEC0805AA0F22002-06-01T00:00:00
3Main Office8EEEC28C-07A2-4FB9-AD0A-42D4A0BBC5752002-06-01T00:00:00
[Person].[BusinessEntity]
BusinessEntityIDrowguidModifiedDate
10C7D8F81-D7B1-4CF0-9C0A-4CD8B6B500872012-01-14T13:20:24.150
26648747F-7843-4002-B317-65389684C3982012-01-14T13:20:24.430
3568204DA-93D7-42F4-8A7A-4446A144277D2012-01-14T13:20:24.540
[Person].[BusinessEntityAddress]
BusinessEntityIDAddressIDAddressTypeIDrowguidModifiedDate
124923A5D0A00-6739-4DFE-A8F7-844CD9DEE3DF2008-10-13T11:15:06.967
2293284AE7057-EDF4-4C51-8B8D-3AEAEFBFB4A12008-10-13T11:15:06.967
322423C915B31-7C05-4A05-9859-0DF6636772402008-10-13T11:15:06.967
[Person].[BusinessEntityContact]
BusinessEntityIDPersonIDContactTypeIDrowguidModifiedDate
292291117D4D2DBC-4A44-48F5-911D-A63ABAFD51202012-01-14T13:21:02.243
294293113EA25B65-9579-4260-977D-D6F00D7D20EE2012-01-14T13:21:02.320
29629511DADAC1FF-3351-4827-9AE0-95004885C1932012-01-14T13:21:02.383
[Person].[ContactType]
ContactTypeIDNameModifiedDate
1Accounting Manager2002-06-01T00:00:00
2Assistant Sales Agent2002-06-01T00:00:00
3Assistant Sales Representative2002-06-01T00:00:00
[Person].[CountryRegion]
CountryRegionCodeNameModifiedDate
ADAndorra2002-06-01T00:00:00
AEUnited Arab Emirates2002-06-01T00:00:00
AFAfghanistan2002-06-01T00:00:00
[Person].[EmailAddress]
BusinessEntityIDEmailAddressIDEmailAddressrowguidModifiedDate
11ken0@adventure-works.com8A1901E4-671B-431A-871C-EADB2942E9EE2003-02-08T00:00:00
22terri0@adventure-works.comB5FF9EFD-72A2-4F87-830B-F338FDD4D1622002-02-24T00:00:00
33roberto0@adventure-works.comC8A51084-1C03-4C58-A8B3-55854AE7C4992001-12-05T00:00:00
[Person].[Password]
BusinessEntityIDPasswordHashPasswordSaltrowguidModifiedDate
1pbFwXWE99vobT6g+vPWFy93NtUU/orrIWafF01hccfM=bE3XiWw=329EACBE-C883-4F48-B8B6-17AA4627EFFF2003-02-08T00:00:00
2bawRVNrZQYQ05qF05Gz6VLilnviZmrqBReTTAGAudm0=EjJaC3U=A4C82398-7466-4FE6-B9EE-CEC34D116F682002-02-24T00:00:00
38BUXrZfDqO1IyHCWOYzYmqN1IhTUn3CJMpdx/UCQ3iY=wbPZqMw=AC3F4536-BB2E-41C5-B70D-454BE460C1BD2001-12-05T00:00:00
[Person].[Person]
BusinessEntityIDPersonTypeNameStyleTitleFirstNameMiddleNameLastNameSuffixEmailPromotionAdditionalContactInfoDemographicsrowguidModifiedDate
1EM0NULLKenJS nchezNULL0NULLNULL92C4279F-1207-48A3-8448-4636514EB7E22003-02-08T00:00:00
2EM0NULLTerriLeeDuffyNULL1NULLNULLD8763459-8AA8-47CC-AFF7-C9079AF790332002-02-24T00:00:00
3EM0NULLRobertoNULLTamburelloNULL0NULLNULLE1A2555E-0828-434B-A33B-6F38136A37DE2001-12-05T00:00:00
[Person].[PersonPhone]
BusinessEntityIDPhoneNumberPhoneNumberTypeIDModifiedDate
1697-555-014212003-02-08T00:00:00
2819-555-017532002-02-24T00:00:00
3212-555-018712001-12-05T00:00:00
[Person].[PhoneNumberType]
PhoneNumberTypeIDNameModifiedDate
1Cell2012-01-14T13:19:22.273
2Home2012-01-14T13:19:22.273
3Work2012-01-14T13:19:22.273
[Person].[StateProvince]
StateProvinceIDStateProvinceCodeCountryRegionCodeIsOnlyStateProvinceFlagNameTerritoryIDrowguidModifiedDate
1AB CA0Alberta6298C2880-AB1C-4982-A5AD-A36EB4BA0D342008-03-11T10:17:21.587
2AK US0Alaska15B7B8462-A888-4E0B-A3E1-7278F8AF107E2008-03-11T10:17:21.587
3AL US0Alabama541B328BE-21AE-45D0-841D-6F8DD71CE6262008-03-11T10:17:21.587
[Production].[BillOfMaterials]
BillOfMaterialsIDProductAssemblyIDComponentIDStartDateEndDateUnitMeasureCodeBOMLevelPerAssemblyQtyModifiedDate
893NULL7492004-06-26T00:00:00NULLEA 01.002004-06-12T00:00:00
271NULL7502004-04-04T00:00:002004-06-03T00:00:00EA 01.002004-06-03T00:00:00
34NULL7502004-06-04T00:00:00NULLEA 01.002004-05-21T00:00:00
[Production].[Culture]
CultureIDNameModifiedDate
Invariant Language (Invariant Country)2002-06-01T00:00:00
ar Arabic2002-06-01T00:00:00
en English2002-06-01T00:00:00
[Production].[Document]
DocumentNodeDocumentLevelTitleOwnerFolderFlagFileNameFileExtensionRevisionChangeNumberStatusDocumentSummaryDocumentrowguidModifiedDate
/0Documents2171DocumentsNULL0 02NULLNULL27CF33AF-C338-4842-966C-75CA11AAA6A32012-01-14T13:58:03.943
/1/1Overview2171OverviewNULL0 02NULLNULL26A266F1-1D23-40E2-AF48-6AB8D954FE372012-01-14T13:58:03.977
/1/1/2Introduction 12190Introduction 1.doc.doc4 282NULL0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAPgADAP7/CQAGAAAAAAAAAAAAAAABAAAANAAAAAAAAAAAEAAANgAAAAEAAAD+////AAAA48265174-8451-4967-973A-639C2276CFAF2007-07-01T00:00:00
[Production].[Illustration]
IllustrationIDDiagramModifiedDate
3NULL2008-02-10T13:06:11.780
4NULL2008-02-10T13:06:11.903
5NULL2008-02-10T13:06:11.950
[Production].[Location]
LocationIDNameCostRateAvailabilityModifiedDate
1Tool Crib0.00000.002002-06-01T00:00:00
2Sheet Metal Racks0.00000.002002-06-01T00:00:00
3Paint Shop0.00000.002002-06-01T00:00:00
[Production].[Product]
ProductIDNameProductNumberMakeFlagFinishedGoodsFlagColorSafetyStockLevelReorderPointStandardCostListPriceSizeSizeUnitMeasureCodeWeightUnitMeasureCodeWeightDaysToManufactureProductLineClassStyleProductSubcategoryIDProductModelIDSellStartDateSellEndDateDiscontinuedDaterowguidModifiedDate
1Adjustable RaceAR-538100NULL10007500.00000.0000NULLNULLNULLNULL0NULLNULLNULLNULLNULL2002-06-01T00:00:00NULLNULL694215B7-08F7-4C0D-ACB1-D734BA44C0C82008-03-11T10:01:36.827
2Bearing BallBA-832700NULL10007500.00000.0000NULLNULLNULLNULL0NULLNULLNULLNULLNULL2002-06-01T00:00:00NULLNULL58AE3C20-4F3A-4749-A7D4-D568806CC5372008-03-11T10:01:36.827
3BB Ball BearingBE-234910NULL8006000.00000.0000NULLNULLNULLNULL1NULLNULLNULLNULLNULL2002-06-01T00:00:00NULLNULL9C21AED2-5BFA-4F18-BCB8-F11638DC2E4E2008-03-11T10:01:36.827
[Production].[ProductCategory]
ProductCategoryIDNamerowguidModifiedDate
1BikesCFBDA25C-DF71-47A7-B81B-64EE161AA37C2002-06-01T00:00:00
2ComponentsC657828D-D808-4ABA-91A3-AF2CE02300E92002-06-01T00:00:00
3Clothing10A7C342-CA82-48D4-8A38-46A2EB089B742002-06-01T00:00:00
[Production].[ProductCostHistory]
ProductIDStartDateEndDateStandardCostModifiedDate
7072005-07-01T00:00:002006-06-30T00:00:0012.02782006-06-30T00:00:00
7072006-07-01T00:00:002007-06-30T00:00:0013.87822007-06-30T00:00:00
7072007-07-01T00:00:00NULL13.08632007-06-17T00:00:00
[Production].[ProductDescription]
ProductDescriptionIDDescriptionrowguidModifiedDate
3Chromoly steel.301EED3A-1A82-4855-99CB-2AFE8290D6412007-06-01T00:00:00
4Aluminum alloy cups; large diameter spindle.DFEBA528-DA11-4650-9D86-CAFDA7294EB02007-06-01T00:00:00
5Aluminum alloy cups and a hollow axle.F7178DA7-1A7E-4997-8470-06737181305E2007-06-01T00:00:00
[Production].[ProductDocument]
ProductIDDocumentNodeModifiedDate
317/2/1/2008-01-30T13:51:58.103
318/2/1/2008-01-30T13:51:58.103
319/2/1/2008-01-30T13:51:58.103
[Production].[ProductInventory]
ProductIDLocationIDShelfBinQuantityrowguidModifiedDate
11A140847A24246-6C43-48EB-968F-025738A8A4102008-09-08T00:00:00
16B5324D4544D7D-CAF5-46B3-AB22-5718DCC26B5E2008-09-08T00:00:00
150A5353BFF7DC60-96A8-43CA-81A7-D6D2ED3000A82008-09-08T00:00:00
[Production].[ProductListPriceHistory]
ProductIDStartDateEndDateListPriceModifiedDate
7072005-07-01T00:00:002006-06-30T00:00:0033.64422006-06-30T00:00:00
7072006-07-01T00:00:002007-06-30T00:00:0033.64422007-06-30T00:00:00
7072007-07-01T00:00:00NULL34.99002007-06-10T00:00:00
[Production].[ProductModel]
ProductModelIDNameCatalogDescriptionInstructionsrowguidModifiedDate
1Classic VestNULLNULL29321D47-1E4C-4AAC-887C-19634328C25E2007-06-01T00:00:00
2Cycling CapNULLNULL474FB654-3C96-4CB9-82DF-2152EEFFBDB02005-06-01T00:00:00
3Full-Finger GlovesNULLNULLA75483FE-3C47-4AA4-93CF-664B511929872006-06-01T00:00:00
[Production].[ProductModelIllustration]
ProductModelIDIllustrationIDModifiedDate
732008-02-10T14:41:02.167
1032008-02-10T14:41:02.167
4742008-02-10T14:41:02.183
[Production].[ProductModelProductDescriptionCulture]
ProductModelIDProductDescriptionIDCultureIDModifiedDate
11199en 2007-06-01T00:00:00
11467ar 2007-06-01T00:00:00
11589fr 2007-06-01T00:00:00
[Production].[ProductPhoto]
ProductPhotoIDThumbNailPhotoThumbnailPhotoFileNameLargePhotoLargePhotoFileNameModifiedDate
1R0lGODlhUAAxAPcAAAAAAIAAAACAAICAAAAAgIAAgACAgICAgMDAwP8AAAD/AP//AAAA//8A/wD//////wAAAAAAAAAAAAAAAAAAno_image_available_small.gifR0lGODlh8ACVAPcAAAAAAIAAAACAAICAAAAAgIAAgACAgICAgMDAwP8AAAD/AP//AAAA//8A/wD//////wAAAAAAAAAAAAAAAAAAno_image_available_large.gif2002-06-01T00:00:00
69R0lGODlhUAAxAPcAAOPj/Kass/X2/jA9R/j6/e3u/pidovb4/WyGtZmbndPT1eLl6szQ15qiqL2+woaLk6yyuLy8vlpmdFJqkTpAracer02_black_f_small.gifR0lGODlh8ACVAPcAANPT/uLj/oaHitvc/tfY55KbqFRWWcnK2LfEzZeZmwMEBXZ6hDZCT4qqzPn6+pajr3GbzXZ3eTo8QFNZY+vzracer02_black_f_large.gif2002-06-01T00:00:00
70R0lGODlhUAAxAPcAAOPj/Ovs8/X2/pmbne3t/tzj6zdCSbK8z6utsvn6/dPT1Dc8RLu8vuLl6oaLk/n6+qywtsnLzKqrrdzd6traracer02_black_small.gifR0lGODlh8ACVAPcAAIaHiuzt/tfY59PT/uPj/pCaqNzd/lRVWcfI2ZeZm7jEzZair3V2eXSeznZ6gomryvn6+jo8QDhCTGVlaVNZracer02_black_large.gif2006-11-20T09:56:38.273
[Production].[ProductProductPhoto]
ProductIDProductPhotoIDPrimaryModifiedDate
1112002-05-02T00:00:00
2112002-05-02T00:00:00
3112002-05-02T00:00:00
[Production].[ProductReview]
ProductReviewIDProductIDReviewerNameReviewDateEmailAddressRatingCommentsModifiedDate
1709John Smith2007-10-20T00:00:00john@fourthcoffee.com5I can't believe I'm singing the praises of a pair of socks, but I just came back from a grueling 3-2007-10-20T00:00:00
2937David2007-12-15T00:00:00david@graphicdesigninstitute.com4A little on the heavy side, but overall the entry/exit is easy in all conditions. I've used these pe2007-12-15T00:00:00
3937Jill2007-12-17T00:00:00jill@margiestravel.com2Maybe it's just because I'm new to mountain biking, but I had a terrible time getting use to these 2007-12-17T00:00:00
[Production].[ProductSubcategory]
ProductSubcategoryIDProductCategoryIDNamerowguidModifiedDate
11Mountain Bikes2D364ADE-264A-433C-B092-4FCBF3804E012002-06-01T00:00:00
21Road Bikes000310C0-BCC8-42C4-B0C3-45AE611AF06B2002-06-01T00:00:00
31Touring Bikes02C5061D-ECDC-4274-B5F1-E91D76BC3F372002-06-01T00:00:00
[Production].[ScrapReason]
ScrapReasonIDNameModifiedDate
1Brake assembly not as ordered2002-06-01T00:00:00
2Color incorrect2002-06-01T00:00:00
3Gouge in metal2002-06-01T00:00:00
[Production].[TransactionHistory]
TransactionIDProductIDReferenceOrderIDReferenceOrderLineIDTransactionDateTransactionTypeQuantityActualCostModifiedDate
1000007844159002007-09-01T00:00:00W20.00002007-09-01T00:00:00
1000017944159102007-09-01T00:00:00W10.00002007-09-01T00:00:00
1000027974159202007-09-01T00:00:00W10.00002007-09-01T00:00:00
[Production].[TransactionHistoryArchive]
TransactionIDProductIDReferenceOrderIDReferenceOrderLineIDTransactionDateTransactionTypeQuantityActualCostModifiedDate
11112005-05-17T00:00:00P450.26002005-05-17T00:00:00
2359212005-05-17T00:00:00P345.12002005-05-17T00:00:00
3360222005-05-17T00:00:00P345.58052005-05-17T00:00:00
[Production].[UnitMeasure]
UnitMeasureCodeNameModifiedDate
BOXBoxes2002-06-01T00:00:00
BTLBottle2002-06-01T00:00:00
C Celsius2002-06-01T00:00:00
[Production].[WorkOrder]
WorkOrderIDProductIDOrderQtyStockedQtyScrappedQtyStartDateEndDateDueDateScrapReasonIDModifiedDate
17228802005-07-04T00:00:002005-07-14T00:00:002005-07-15T00:00:00NULL2005-07-14T00:00:00
2725151502005-07-04T00:00:002005-07-14T00:00:002005-07-15T00:00:00NULL2005-07-14T00:00:00
37269902005-07-04T00:00:002005-07-14T00:00:002005-07-15T00:00:00NULL2005-07-14T00:00:00
[Production].[WorkOrderRouting]
WorkOrderIDProductIDOperationSequenceLocationIDScheduledStartDateScheduledEndDateActualStartDateActualEndDateActualResourceHrsPlannedCostActualCostModifiedDate
137471102005-07-04T00:00:002005-07-15T00:00:002005-07-04T00:00:002005-07-20T00:00:004.100092.250092.25002005-07-20T00:00:00
137472202005-07-04T00:00:002005-07-15T00:00:002005-07-04T00:00:002005-07-20T00:00:003.500087.500087.50002005-07-20T00:00:00
137473302005-07-04T00:00:002005-07-15T00:00:002005-07-04T00:00:002005-07-20T00:00:001.000014.500014.50002005-07-20T00:00:00
[Purchasing].[ProductVendor]
ProductIDBusinessEntityIDAverageLeadTimeStandardPriceLastReceiptCostLastReceiptDateMinOrderQtyMaxOrderQtyOnOrderQtyUnitMeasureCodeModifiedDate
115801747.870050.26352005-09-29T00:00:00153CS 2005-09-29T00:00:00
216881939.920041.91602005-09-29T00:00:00153CTN2005-09-29T00:00:00
416501754.310057.02552005-09-29T00:00:0015NULLCTN2005-09-29T00:00:00
[Purchasing].[PurchaseOrderDetail]
PurchaseOrderIDPurchaseOrderDetailIDDueDateOrderQtyProductIDUnitPriceLineTotalReceivedQtyRejectedQtyStockedQtyModifiedDate
112005-05-31T00:00:004150.2600201.04003.000.003.002005-05-24T00:00:00
222005-05-31T00:00:00335945.1200135.36003.000.003.002005-05-24T00:00:00
232005-05-31T00:00:00336045.5805136.74153.000.003.002005-05-24T00:00:00
[Purchasing].[PurchaseOrderHeader]
PurchaseOrderIDRevisionNumberStatusEmployeeIDVendorIDShipMethodIDOrderDateShipDateSubTotalTaxAmtFreightTotalDueModifiedDate
114258158032005-05-17T00:00:002005-05-26T00:00:00201.040016.08325.0260222.14922005-05-26T00:00:00
211254149652005-05-17T00:00:002005-05-26T00:00:00272.101521.76816.8025300.67212005-05-26T00:00:00
314257149422005-05-17T00:00:002005-05-26T00:00:008847.3000707.7840221.18259776.26652005-05-26T00:00:00
[Purchasing].[ShipMethod]
ShipMethodIDNameShipBaseShipRaterowguidModifiedDate
1XRQ - TRUCK GROUND3.95000.99006BE756D9-D7BE-4463-8F2C-AE60C710D6062002-06-01T00:00:00
2ZY - EXPRESS9.95001.99003455079B-F773-4DC6-8F1E-2A58649C4AB82002-06-01T00:00:00
3OVERSEAS - DELUXE29.95002.990022F4E461-28CF-4ACE-A980-F686CF112EC82002-06-01T00:00:00
[Purchasing].[Vendor]
BusinessEntityIDAccountNumberNameCreditRatingPreferredVendorStatusActiveFlagPurchasingWebServiceURLModifiedDate
1492AUSTRALI0001Australia Bike Retailer111NULL2006-01-23T00:00:00
1494ALLENSON0001Allenson Cycles211NULL2005-05-26T00:00:00
1496ADVANCED0001Advanced Bicycles111NULL2005-05-26T00:00:00
[Sales].[CountryRegionCurrency]
CountryRegionCodeCurrencyCodeModifiedDate
AEAED2008-03-11T10:17:21.510
ARARS2008-03-11T10:17:21.510
ATATS2008-03-11T10:17:21.510
[Sales].[CreditCard]
CreditCardIDCardTypeCardNumberExpMonthExpYearModifiedDate
1SuperiorCard333326646953101120062007-08-30T00:00:00
2Distinguish55552127249722820052008-01-06T00:00:00
3ColonialVoice77778344838353720052008-02-15T00:00:00
[Sales].[Currency]
CurrencyCodeNameModifiedDate
AEDEmirati Dirham2002-06-01T00:00:00
AFAAfghani2002-06-01T00:00:00
ALLLek2002-06-01T00:00:00
[Sales].[CurrencyRate]
CurrencyRateIDCurrencyRateDateFromCurrencyCodeToCurrencyCodeAverageRateEndOfDayRateModifiedDate
12005-07-01T00:00:00USDARS1.00001.00022005-07-01T00:00:00
22005-07-01T00:00:00USDAUD1.54911.55002005-07-01T00:00:00
32005-07-01T00:00:00USDBRL1.93791.94192005-07-01T00:00:00
[Sales].[Customer]
CustomerIDPersonIDStoreIDTerritoryIDAccountNumberrowguidModifiedDate
1NULL9341AW000000013F5AE95E-B87D-4AED-95B4-C3797AFCB74F2008-10-13T11:15:07.263
2NULL10281AW00000002E552F657-A9AF-4A7D-A645-C429D6E024912008-10-13T11:15:07.263
3NULL6424AW00000003130774B1-DB21-4EF3-98C8-C104BCD6ED6D2008-10-13T11:15:07.263
[Sales].[PersonCreditCard]
BusinessEntityIDCreditCardIDModifiedDate
293170382007-09-01T00:00:00
295153692005-09-01T00:00:00
29780102005-09-01T00:00:00
[Sales].[SalesOrderDetail]
SalesOrderIDSalesOrderDetailIDCarrierTrackingNumberOrderQtyProductIDSpecialOfferIDUnitPriceUnitPriceDiscountLineTotalrowguidModifiedDate
4365914911-403C-98177612024.99400.00002024.994000B207C96D-D9E6-402B-8470-2CC176C422832005-07-01T00:00:00
4365924911-403C-98377712024.99400.00006074.9820007ABB600D-1E77-41BE-9FE5-B9142CFC08FA2005-07-01T00:00:00
4365934911-403C-98177812024.99400.00002024.994000475CF8C6-49F6-486E-B0AD-AFC6A50CDD2F2005-07-01T00:00:00
[Sales].[SalesOrderHeader]
SalesOrderIDRevisionNumberOrderDateDueDateShipDateStatusOnlineOrderFlagSalesOrderNumberPurchaseOrderNumberAccountNumberCustomerIDSalesPersonIDTerritoryIDBillToAddressIDShipToAddressIDShipMethodIDCreditCardIDCreditCardApprovalCodeCurrencyRateIDSubTotalTaxAmtFreightTotalDueCommentrowguidModifiedDate
4365932005-07-01T00:00:002005-07-13T00:00:002005-07-08T00:00:0050SO43659PO52214578710-4020-000676298252795985985516281105041Vi84182NULL20565.62061971.5149616.098423153.2339NULL79B65321-39CA-4115-9CBA-8FE0903E12E62005-07-08T00:00:00
4366032005-07-01T00:00:002005-07-13T00:00:002005-07-08T00:00:0050SO43660PO1885012750010-4020-00011729672279592192155618115213Vi29411NULL1294.2529124.248338.82761457.3288NULL738DC42D-D03B-48A1-9822-F95A67EA73892005-07-08T00:00:00
4366132005-07-01T00:00:002005-07-13T00:00:002005-07-08T00:00:0050SO43661PO1847318962010-4020-0004422973428265175175134685274Vi6854432726.47863153.7696985.553036865.8012NULLD91B9131-18A4-4A11-BC3A-90B6F53E9D742005-07-08T00:00:00
[Sales].[SalesOrderHeaderSalesReason]
SalesOrderIDSalesReasonIDModifiedDate
4369752005-07-01T00:00:00
4369792005-07-01T00:00:00
4370252005-07-02T00:00:00
[Sales].[SalesPerson]
BusinessEntityIDTerritoryIDSalesQuotaBonusCommissionPctSalesYTDSalesLastYearrowguidModifiedDate
274NULLNULL0.00000.0000559697.56390.000048754992-9EE0-4C0E-8C94-9451604E3E022005-01-28T00:00:00
2752300000.00004100.00000.01203763178.17871750406.47851E0A7274-3064-4F58-88EE-4C6586C871692005-06-24T00:00:00
2764250000.00002000.00000.01504251368.54971439156.02914DD9EEE4-8E81-4F8C-AF97-683394C1F7C02005-06-24T00:00:00
[Sales].[SalesPersonQuotaHistory]
BusinessEntityIDQuotaDateSalesQuotarowguidModifiedDate
2742005-07-01T00:00:0028000.000099109BBF-8693-4587-BC23-6036EC89E1BE2005-05-17T00:00:00
2742005-10-01T00:00:007000.0000DFD01444-8900-461C-8D6F-04598DAE01D42005-08-17T00:00:00
2742006-01-01T00:00:0091000.00000A69F453-9689-4CCF-A08C-C644670F56682005-11-17T00:00:00
[Sales].[SalesReason]
SalesReasonIDNameReasonTypeModifiedDate
1PriceOther2002-06-01T00:00:00
2On PromotionPromotion2002-06-01T00:00:00
3Magazine AdvertisementMarketing2002-06-01T00:00:00
[Sales].[SalesTaxRate]
SalesTaxRateIDStateProvinceIDTaxTypeTaxRateNamerowguidModifiedDate
11114.0000Canadian GST + Alberta Provincial Tax683DE5DD-521A-47D4-A573-06A3CDB1BC5D2002-06-01T00:00:00
257114.2500Canadian GST + Ontario Provincial Tax05C4FFDB-4F84-4CDF-ABE5-FDF3216EA74E2002-06-01T00:00:00
363114.2500Canadian GST + Quebec Provincial TaxD4EDB557-56D7-403C-B538-4DF5E73025882002-06-01T00:00:00
[Sales].[SalesTerritory]
TerritoryIDNameCountryRegionCodeGroupSalesYTDSalesLastYearCostYTDCostLastYearrowguidModifiedDate
1NorthwestUSNorth America7887186.78823298694.49380.00000.000043689A10-E30B-497F-B0DE-11DE20267FF72002-06-01T00:00:00
2NortheastUSNorth America2402176.84763607148.93710.00000.000000FB7309-96CC-49E2-8363-0A1BA72486F22002-06-01T00:00:00
3CentralUSNorth America3072175.11803205014.07670.00000.0000DF6E7FD8-1A8D-468C-B103-ED8ADDB452C12002-06-01T00:00:00
[Sales].[SalesTerritoryHistory]
BusinessEntityIDTerritoryIDStartDateEndDaterowguidModifiedDate
27522005-07-01T00:00:002006-12-31T00:00:008563CE6A-00FF-47D7-BA4D-3C3E1CDEF5312006-12-24T00:00:00
27532007-01-01T00:00:00NULL2F44304C-EE87-4C72-813E-CA75C5F61F4C2006-12-25T00:00:00
27642005-07-01T00:00:00NULL64BCB1B3-A793-40BA-9859-D90F78C3F1672005-06-24T00:00:00
[Sales].[ShoppingCartItem]
ShoppingCartItemIDShoppingCartIDQuantityProductIDDateCreatedModifiedDate
21495138622007-12-11T17:54:07.6032007-12-11T17:54:07.603
42062148812007-12-11T17:54:07.6032007-12-11T17:54:07.603
52062178742007-12-11T17:54:07.6032007-12-11T17:54:07.603
[Sales].[SpecialOffer]
SpecialOfferIDDescriptionDiscountPctTypeCategoryStartDateEndDateMinQtyMaxQtyrowguidModifiedDate
1No Discount0.0000No DiscountNo Discount2005-06-01T00:00:002008-12-31T00:00:000NULL0290C4F5-191F-4337-AB6B-0A2DDE03CBF92005-05-02T00:00:00
2Volume Discount 11 to 140.0200Volume DiscountReseller2005-07-01T00:00:002008-06-30T00:00:001114D7542EE7-15DB-4541-985C-5CC27AEF26D62005-06-01T00:00:00
3Volume Discount 15 to 240.0500Volume DiscountReseller2005-07-01T00:00:002008-06-30T00:00:0015244BDBCC01-8CF7-40A9-B643-40EC5B7174912005-06-01T00:00:00
[Sales].[SpecialOfferProduct]
SpecialOfferIDProductIDrowguidModifiedDate
1680BB30B868-D86C-4557-8DB2-4B2D0A83A0FB2005-05-02T00:00:00
1706B3C9A4B1-2AE6-4CBA-B552-1F206C9F4C1F2005-05-02T00:00:00
170727B711FE-0B77-4EA4-AD1A-7C239956BEF42005-05-02T00:00:00
[Sales].[Store]
BusinessEntityIDNameSalesPersonIDDemographicsrowguidModifiedDate
292Next-Door Bike Store279NULLA22517E3-848D-4EBE-B9D9-7437F34323042008-10-13T11:15:07.497
294Professional Sales and Service276NULLB50CA50B-C601-4A13-B07E-2C63862D71B42008-10-13T11:15:07.497
296Riders Company277NULL337C3688-1339-4E1A-A08A-B54B23566E492008-10-13T11:15:07.497