SystemInformationID | Database_Version | VersionDate | ModifiedDate |
---|---|---|---|
1 | 11.0.2100.60 | 2012-03-14T00:00:00 | 2012-03-14T00:00:00 |
DatabaseLogID | PostTime | DatabaseUser | Event | Schema | Object | TSQL | XmlEvent |
---|---|---|---|---|---|---|---|
1 | 2014-04-14T14:44:17.807 | dbo | CREATE_TABLE | dbo | ErrorLog | CREATE TABLE [dbo].[ErrorLog]( [ErrorLogID] [int] IDENTITY (1, 1) NOT NULL, [ErrorTime] [d | NULL |
2 | 2014-04-14T14:44:17.830 | dbo | ALTER_TABLE | dbo | ErrorLog | ALTER TABLE [dbo].[ErrorLog] WITH CHECK ADD CONSTRAINT [PK_ErrorLog_ErrorLogID] PRIMARY KEY CL | NULL |
5 | 2014-04-14T14:44:17.893 | dbo | CREATE_TYPE | dbo | AccountNumber | CREATE TYPE [AccountNumber] FROM nvarchar(15) NULL; | NULL |
ErrorLogID | ErrorTime | UserName | ErrorNumber | ErrorSeverity | ErrorState | ErrorProcedure | ErrorLine | ErrorMessage |
---|
StuffID | StuffName |
---|---|
1 | abc |
2 | def123 |
3 | 456 |
DepartmentID | Name | GroupName | ModifiedDate |
---|---|---|---|
1 | Engineering | Research and Development | 2002-06-01T00:00:00 |
2 | Tool Design | Research and Development | 2002-06-01T00:00:00 |
3 | Sales | Sales and Marketing | 2002-06-01T00:00:00 |
BusinessEntityID | NationalIDNumber | LoginID | OrganizationNode | OrganizationLevel | JobTitle | BirthDate | MaritalStatus | Gender | HireDate | SalariedFlag | VacationHours | SickLeaveHours | CurrentFlag | rowguid | ModifiedDate |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 295847284 | adventure-works\ken0 | / | 0 | Chief Executive Officer | 1963-03-02 | S | M | 2003-02-15 | 1 | 99 | 69 | 1 | F01251E5-96A3-448D-981E-0F99D789110D | 2008-07-31T00:00:00 |
2 | 245797967 | adventure-works\terri0 | /1/ | 1 | Vice President of Engineering | 1965-09-01 | S | F | 2002-03-03 | 1 | 1 | 20 | 1 | 45E8F437-670D-4409-93CB-F9424A40D6EE | 2008-07-31T00:00:00 |
3 | 509647174 | adventure-works\roberto0 | /1/1/ | 2 | Engineering Manager | 1968-12-13 | M | M | 2001-12-12 | 1 | 2 | 21 | 1 | 9BBBFB2C-EFBB-4217-9AB7-F97689328841 | 2008-07-31T00:00:00 |
BusinessEntityID | DepartmentID | ShiftID | StartDate | EndDate | ModifiedDate |
---|---|---|---|---|---|
1 | 16 | 1 | 2003-02-15 | NULL | 2003-02-14T00:00:00 |
2 | 1 | 1 | 2002-03-03 | NULL | 2002-03-02T00:00:00 |
3 | 1 | 1 | 2001-12-12 | NULL | 2001-12-11T00:00:00 |
BusinessEntityID | RateChangeDate | Rate | PayFrequency | ModifiedDate |
---|---|---|---|---|
1 | 2003-02-15T00:00:00 | 125.5000 | 2 | 2008-07-31T00:00:00 |
2 | 2002-03-03T00:00:00 | 63.4615 | 2 | 2008-07-31T00:00:00 |
3 | 2001-12-12T00:00:00 | 43.2692 | 2 | 2008-07-31T00:00:00 |
JobCandidateID | BusinessEntityID | Resume | ModifiedDate |
---|---|---|---|
1 | NULL | NULL | 2001-07-24T00:00:00 |
2 | NULL | NULL | 2001-07-24T00:00:00 |
3 | NULL | NULL | 2001-07-24T00:00:00 |
ShiftID | Name | StartTime | EndTime | ModifiedDate |
---|---|---|---|---|
1 | Day | 07:00:00 | 15:00:00 | 2002-06-01T00:00:00 |
2 | Evening | 15:00:00 | 23:00:00 | 2002-06-01T00:00:00 |
3 | Night | 23:00:00 | 07:00:00 | 2002-06-01T00:00:00 |
AddressID | AddressLine1 | AddressLine2 | City | StateProvinceID | PostalCode | SpatialLocation | rowguid | ModifiedDate |
---|---|---|---|---|---|---|---|---|
1 | 1970 Napa Ct. | NULL | Bothell | 79 | 98011 | POINT (-122.164644615406 47.7869921906598) | 9AADCB0D-36CF-483F-84D8-585C2D4EC6E9 | 2002-01-04T00:00:00 |
2 | 9833 Mt. Dias Blv. | NULL | Bothell | 79 | 98011 | POINT (-122.250185528911 47.6867097047995) | 32A54B9E-E034-4BFB-B573-A71CDE60D8C0 | 2003-01-01T00:00:00 |
3 | 7484 Roundtree Drive | NULL | Bothell | 79 | 98011 | POINT (-122.274625789912 47.7631154083121) | 4C506923-6D1B-452C-A07C-BAA6F5B142A4 | 2007-04-08T00:00:00 |
AddressTypeID | Name | rowguid | ModifiedDate |
---|---|---|---|
1 | Billing | B84F78B1-4EFE-4A0E-8CB7-70E9F112F886 | 2002-06-01T00:00:00 |
2 | Home | 41BC2FF6-F0FC-475F-8EB9-CEC0805AA0F2 | 2002-06-01T00:00:00 |
3 | Main Office | 8EEEC28C-07A2-4FB9-AD0A-42D4A0BBC575 | 2002-06-01T00:00:00 |
BusinessEntityID | rowguid | ModifiedDate |
---|---|---|
1 | 0C7D8F81-D7B1-4CF0-9C0A-4CD8B6B50087 | 2012-01-14T13:20:24.150 |
2 | 6648747F-7843-4002-B317-65389684C398 | 2012-01-14T13:20:24.430 |
3 | 568204DA-93D7-42F4-8A7A-4446A144277D | 2012-01-14T13:20:24.540 |
BusinessEntityID | AddressID | AddressTypeID | rowguid | ModifiedDate |
---|---|---|---|---|
1 | 249 | 2 | 3A5D0A00-6739-4DFE-A8F7-844CD9DEE3DF | 2008-10-13T11:15:06.967 |
2 | 293 | 2 | 84AE7057-EDF4-4C51-8B8D-3AEAEFBFB4A1 | 2008-10-13T11:15:06.967 |
3 | 224 | 2 | 3C915B31-7C05-4A05-9859-0DF663677240 | 2008-10-13T11:15:06.967 |
BusinessEntityID | PersonID | ContactTypeID | rowguid | ModifiedDate |
---|---|---|---|---|
292 | 291 | 11 | 7D4D2DBC-4A44-48F5-911D-A63ABAFD5120 | 2012-01-14T13:21:02.243 |
294 | 293 | 11 | 3EA25B65-9579-4260-977D-D6F00D7D20EE | 2012-01-14T13:21:02.320 |
296 | 295 | 11 | DADAC1FF-3351-4827-9AE0-95004885C193 | 2012-01-14T13:21:02.383 |
ContactTypeID | Name | ModifiedDate |
---|---|---|
1 | Accounting Manager | 2002-06-01T00:00:00 |
2 | Assistant Sales Agent | 2002-06-01T00:00:00 |
3 | Assistant Sales Representative | 2002-06-01T00:00:00 |
CountryRegionCode | Name | ModifiedDate |
---|---|---|
AD | Andorra | 2002-06-01T00:00:00 |
AE | United Arab Emirates | 2002-06-01T00:00:00 |
AF | Afghanistan | 2002-06-01T00:00:00 |
BusinessEntityID | EmailAddressID | EmailAddress | rowguid | ModifiedDate |
---|---|---|---|---|
1 | 1 | ken0@adventure-works.com | 8A1901E4-671B-431A-871C-EADB2942E9EE | 2003-02-08T00:00:00 |
2 | 2 | terri0@adventure-works.com | B5FF9EFD-72A2-4F87-830B-F338FDD4D162 | 2002-02-24T00:00:00 |
3 | 3 | roberto0@adventure-works.com | C8A51084-1C03-4C58-A8B3-55854AE7C499 | 2001-12-05T00:00:00 |
BusinessEntityID | PasswordHash | PasswordSalt | rowguid | ModifiedDate |
---|---|---|---|---|
1 | pbFwXWE99vobT6g+vPWFy93NtUU/orrIWafF01hccfM= | bE3XiWw= | 329EACBE-C883-4F48-B8B6-17AA4627EFFF | 2003-02-08T00:00:00 |
2 | bawRVNrZQYQ05qF05Gz6VLilnviZmrqBReTTAGAudm0= | EjJaC3U= | A4C82398-7466-4FE6-B9EE-CEC34D116F68 | 2002-02-24T00:00:00 |
3 | 8BUXrZfDqO1IyHCWOYzYmqN1IhTUn3CJMpdx/UCQ3iY= | wbPZqMw= | AC3F4536-BB2E-41C5-B70D-454BE460C1BD | 2001-12-05T00:00:00 |
BusinessEntityID | PersonType | NameStyle | Title | FirstName | MiddleName | LastName | Suffix | EmailPromotion | AdditionalContactInfo | Demographics | rowguid | ModifiedDate |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | EM | 0 | NULL | Ken | J | S nchez | NULL | 0 | NULL | NULL | 92C4279F-1207-48A3-8448-4636514EB7E2 | 2003-02-08T00:00:00 |
2 | EM | 0 | NULL | Terri | Lee | Duffy | NULL | 1 | NULL | NULL | D8763459-8AA8-47CC-AFF7-C9079AF79033 | 2002-02-24T00:00:00 |
3 | EM | 0 | NULL | Roberto | NULL | Tamburello | NULL | 0 | NULL | NULL | E1A2555E-0828-434B-A33B-6F38136A37DE | 2001-12-05T00:00:00 |
BusinessEntityID | PhoneNumber | PhoneNumberTypeID | ModifiedDate |
---|---|---|---|
1 | 697-555-0142 | 1 | 2003-02-08T00:00:00 |
2 | 819-555-0175 | 3 | 2002-02-24T00:00:00 |
3 | 212-555-0187 | 1 | 2001-12-05T00:00:00 |
PhoneNumberTypeID | Name | ModifiedDate |
---|---|---|
1 | Cell | 2012-01-14T13:19:22.273 |
2 | Home | 2012-01-14T13:19:22.273 |
3 | Work | 2012-01-14T13:19:22.273 |
StateProvinceID | StateProvinceCode | CountryRegionCode | IsOnlyStateProvinceFlag | Name | TerritoryID | rowguid | ModifiedDate |
---|---|---|---|---|---|---|---|
1 | AB | CA | 0 | Alberta | 6 | 298C2880-AB1C-4982-A5AD-A36EB4BA0D34 | 2008-03-11T10:17:21.587 |
2 | AK | US | 0 | Alaska | 1 | 5B7B8462-A888-4E0B-A3E1-7278F8AF107E | 2008-03-11T10:17:21.587 |
3 | AL | US | 0 | Alabama | 5 | 41B328BE-21AE-45D0-841D-6F8DD71CE626 | 2008-03-11T10:17:21.587 |
BillOfMaterialsID | ProductAssemblyID | ComponentID | StartDate | EndDate | UnitMeasureCode | BOMLevel | PerAssemblyQty | ModifiedDate |
---|---|---|---|---|---|---|---|---|
893 | NULL | 749 | 2004-06-26T00:00:00 | NULL | EA | 0 | 1.00 | 2004-06-12T00:00:00 |
271 | NULL | 750 | 2004-04-04T00:00:00 | 2004-06-03T00:00:00 | EA | 0 | 1.00 | 2004-06-03T00:00:00 |
34 | NULL | 750 | 2004-06-04T00:00:00 | NULL | EA | 0 | 1.00 | 2004-05-21T00:00:00 |
CultureID | Name | ModifiedDate |
---|---|---|
Invariant Language (Invariant Country) | 2002-06-01T00:00:00 | |
ar | Arabic | 2002-06-01T00:00:00 |
en | English | 2002-06-01T00:00:00 |
DocumentNode | DocumentLevel | Title | Owner | FolderFlag | FileName | FileExtension | Revision | ChangeNumber | Status | DocumentSummary | Document | rowguid | ModifiedDate |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
/ | 0 | Documents | 217 | 1 | Documents | NULL | 0 | 0 | 2 | NULL | NULL | 27CF33AF-C338-4842-966C-75CA11AAA6A3 | 2012-01-14T13:58:03.943 |
/1/ | 1 | Overview | 217 | 1 | Overview | NULL | 0 | 0 | 2 | NULL | NULL | 26A266F1-1D23-40E2-AF48-6AB8D954FE37 | 2012-01-14T13:58:03.977 |
/1/1/ | 2 | Introduction 1 | 219 | 0 | Introduction 1.doc | .doc | 4 | 28 | 2 | NULL | 0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAPgADAP7/CQAGAAAAAAAAAAAAAAABAAAANAAAAAAAAAAAEAAANgAAAAEAAAD+////AAAA | 48265174-8451-4967-973A-639C2276CFAF | 2007-07-01T00:00:00 |
IllustrationID | Diagram | ModifiedDate |
---|---|---|
3 | NULL | 2008-02-10T13:06:11.780 |
4 | NULL | 2008-02-10T13:06:11.903 |
5 | NULL | 2008-02-10T13:06:11.950 |
LocationID | Name | CostRate | Availability | ModifiedDate |
---|---|---|---|---|
1 | Tool Crib | 0.0000 | 0.00 | 2002-06-01T00:00:00 |
2 | Sheet Metal Racks | 0.0000 | 0.00 | 2002-06-01T00:00:00 |
3 | Paint Shop | 0.0000 | 0.00 | 2002-06-01T00:00:00 |
ProductID | Name | ProductNumber | MakeFlag | FinishedGoodsFlag | Color | SafetyStockLevel | ReorderPoint | StandardCost | ListPrice | Size | SizeUnitMeasureCode | WeightUnitMeasureCode | Weight | DaysToManufacture | ProductLine | Class | Style | ProductSubcategoryID | ProductModelID | SellStartDate | SellEndDate | DiscontinuedDate | rowguid | ModifiedDate |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Adjustable Race | AR-5381 | 0 | 0 | NULL | 1000 | 750 | 0.0000 | 0.0000 | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | 2002-06-01T00:00:00 | NULL | NULL | 694215B7-08F7-4C0D-ACB1-D734BA44C0C8 | 2008-03-11T10:01:36.827 |
2 | Bearing Ball | BA-8327 | 0 | 0 | NULL | 1000 | 750 | 0.0000 | 0.0000 | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | 2002-06-01T00:00:00 | NULL | NULL | 58AE3C20-4F3A-4749-A7D4-D568806CC537 | 2008-03-11T10:01:36.827 |
3 | BB Ball Bearing | BE-2349 | 1 | 0 | NULL | 800 | 600 | 0.0000 | 0.0000 | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | 2002-06-01T00:00:00 | NULL | NULL | 9C21AED2-5BFA-4F18-BCB8-F11638DC2E4E | 2008-03-11T10:01:36.827 |
ProductCategoryID | Name | rowguid | ModifiedDate |
---|---|---|---|
1 | Bikes | CFBDA25C-DF71-47A7-B81B-64EE161AA37C | 2002-06-01T00:00:00 |
2 | Components | C657828D-D808-4ABA-91A3-AF2CE02300E9 | 2002-06-01T00:00:00 |
3 | Clothing | 10A7C342-CA82-48D4-8A38-46A2EB089B74 | 2002-06-01T00:00:00 |
ProductID | StartDate | EndDate | StandardCost | ModifiedDate |
---|---|---|---|---|
707 | 2005-07-01T00:00:00 | 2006-06-30T00:00:00 | 12.0278 | 2006-06-30T00:00:00 |
707 | 2006-07-01T00:00:00 | 2007-06-30T00:00:00 | 13.8782 | 2007-06-30T00:00:00 |
707 | 2007-07-01T00:00:00 | NULL | 13.0863 | 2007-06-17T00:00:00 |
ProductDescriptionID | Description | rowguid | ModifiedDate |
---|---|---|---|
3 | Chromoly steel. | 301EED3A-1A82-4855-99CB-2AFE8290D641 | 2007-06-01T00:00:00 |
4 | Aluminum alloy cups; large diameter spindle. | DFEBA528-DA11-4650-9D86-CAFDA7294EB0 | 2007-06-01T00:00:00 |
5 | Aluminum alloy cups and a hollow axle. | F7178DA7-1A7E-4997-8470-06737181305E | 2007-06-01T00:00:00 |
ProductID | DocumentNode | ModifiedDate |
---|---|---|
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 |
ProductID | LocationID | Shelf | Bin | Quantity | rowguid | ModifiedDate |
---|---|---|---|---|---|---|
1 | 1 | A | 1 | 408 | 47A24246-6C43-48EB-968F-025738A8A410 | 2008-09-08T00:00:00 |
1 | 6 | B | 5 | 324 | D4544D7D-CAF5-46B3-AB22-5718DCC26B5E | 2008-09-08T00:00:00 |
1 | 50 | A | 5 | 353 | BFF7DC60-96A8-43CA-81A7-D6D2ED3000A8 | 2008-09-08T00:00:00 |
ProductID | StartDate | EndDate | ListPrice | ModifiedDate |
---|---|---|---|---|
707 | 2005-07-01T00:00:00 | 2006-06-30T00:00:00 | 33.6442 | 2006-06-30T00:00:00 |
707 | 2006-07-01T00:00:00 | 2007-06-30T00:00:00 | 33.6442 | 2007-06-30T00:00:00 |
707 | 2007-07-01T00:00:00 | NULL | 34.9900 | 2007-06-10T00:00:00 |
ProductModelID | Name | CatalogDescription | Instructions | rowguid | ModifiedDate |
---|---|---|---|---|---|
1 | Classic Vest | NULL | NULL | 29321D47-1E4C-4AAC-887C-19634328C25E | 2007-06-01T00:00:00 |
2 | Cycling Cap | NULL | NULL | 474FB654-3C96-4CB9-82DF-2152EEFFBDB0 | 2005-06-01T00:00:00 |
3 | Full-Finger Gloves | NULL | NULL | A75483FE-3C47-4AA4-93CF-664B51192987 | 2006-06-01T00:00:00 |
ProductModelID | IllustrationID | ModifiedDate |
---|---|---|
7 | 3 | 2008-02-10T14:41:02.167 |
10 | 3 | 2008-02-10T14:41:02.167 |
47 | 4 | 2008-02-10T14:41:02.183 |
ProductModelID | ProductDescriptionID | CultureID | ModifiedDate |
---|---|---|---|
1 | 1199 | en | 2007-06-01T00:00:00 |
1 | 1467 | ar | 2007-06-01T00:00:00 |
1 | 1589 | fr | 2007-06-01T00:00:00 |
ProductPhotoID | ThumbNailPhoto | ThumbnailPhotoFileName | LargePhoto | LargePhotoFileName | ModifiedDate |
---|---|---|---|---|---|
1 | R0lGODlhUAAxAPcAAAAAAIAAAACAAICAAAAAgIAAgACAgICAgMDAwP8AAAD/AP//AAAA//8A/wD//////wAAAAAAAAAAAAAAAAAA | no_image_available_small.gif | R0lGODlh8ACVAPcAAAAAAIAAAACAAICAAAAAgIAAgACAgICAgMDAwP8AAAD/AP//AAAA//8A/wD//////wAAAAAAAAAAAAAAAAAA | no_image_available_large.gif | 2002-06-01T00:00:00 |
69 | R0lGODlhUAAxAPcAAOPj/Kass/X2/jA9R/j6/e3u/pidovb4/WyGtZmbndPT1eLl6szQ15qiqL2+woaLk6yyuLy8vlpmdFJqkTpA | racer02_black_f_small.gif | R0lGODlh8ACVAPcAANPT/uLj/oaHitvc/tfY55KbqFRWWcnK2LfEzZeZmwMEBXZ6hDZCT4qqzPn6+pajr3GbzXZ3eTo8QFNZY+vz | racer02_black_f_large.gif | 2002-06-01T00:00:00 |
70 | R0lGODlhUAAxAPcAAOPj/Ovs8/X2/pmbne3t/tzj6zdCSbK8z6utsvn6/dPT1Dc8RLu8vuLl6oaLk/n6+qywtsnLzKqrrdzd6tra | racer02_black_small.gif | R0lGODlh8ACVAPcAAIaHiuzt/tfY59PT/uPj/pCaqNzd/lRVWcfI2ZeZm7jEzZair3V2eXSeznZ6gomryvn6+jo8QDhCTGVlaVNZ | racer02_black_large.gif | 2006-11-20T09:56:38.273 |
ProductID | ProductPhotoID | Primary | ModifiedDate |
---|---|---|---|
1 | 1 | 1 | 2002-05-02T00:00:00 |
2 | 1 | 1 | 2002-05-02T00:00:00 |
3 | 1 | 1 | 2002-05-02T00:00:00 |
ProductReviewID | ProductID | ReviewerName | ReviewDate | EmailAddress | Rating | Comments | ModifiedDate |
---|---|---|---|---|---|---|---|
1 | 709 | John Smith | 2007-10-20T00:00:00 | john@fourthcoffee.com | 5 | I 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 |
2 | 937 | David | 2007-12-15T00:00:00 | david@graphicdesigninstitute.com | 4 | A little on the heavy side, but overall the entry/exit is easy in all conditions. I've used these pe | 2007-12-15T00:00:00 |
3 | 937 | Jill | 2007-12-17T00:00:00 | jill@margiestravel.com | 2 | Maybe 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 |
ProductSubcategoryID | ProductCategoryID | Name | rowguid | ModifiedDate |
---|---|---|---|---|
1 | 1 | Mountain Bikes | 2D364ADE-264A-433C-B092-4FCBF3804E01 | 2002-06-01T00:00:00 |
2 | 1 | Road Bikes | 000310C0-BCC8-42C4-B0C3-45AE611AF06B | 2002-06-01T00:00:00 |
3 | 1 | Touring Bikes | 02C5061D-ECDC-4274-B5F1-E91D76BC3F37 | 2002-06-01T00:00:00 |
ScrapReasonID | Name | ModifiedDate |
---|---|---|
1 | Brake assembly not as ordered | 2002-06-01T00:00:00 |
2 | Color incorrect | 2002-06-01T00:00:00 |
3 | Gouge in metal | 2002-06-01T00:00:00 |
TransactionID | ProductID | ReferenceOrderID | ReferenceOrderLineID | TransactionDate | TransactionType | Quantity | ActualCost | ModifiedDate |
---|---|---|---|---|---|---|---|---|
100000 | 784 | 41590 | 0 | 2007-09-01T00:00:00 | W | 2 | 0.0000 | 2007-09-01T00:00:00 |
100001 | 794 | 41591 | 0 | 2007-09-01T00:00:00 | W | 1 | 0.0000 | 2007-09-01T00:00:00 |
100002 | 797 | 41592 | 0 | 2007-09-01T00:00:00 | W | 1 | 0.0000 | 2007-09-01T00:00:00 |
TransactionID | ProductID | ReferenceOrderID | ReferenceOrderLineID | TransactionDate | TransactionType | Quantity | ActualCost | ModifiedDate |
---|---|---|---|---|---|---|---|---|
1 | 1 | 1 | 1 | 2005-05-17T00:00:00 | P | 4 | 50.2600 | 2005-05-17T00:00:00 |
2 | 359 | 2 | 1 | 2005-05-17T00:00:00 | P | 3 | 45.1200 | 2005-05-17T00:00:00 |
3 | 360 | 2 | 2 | 2005-05-17T00:00:00 | P | 3 | 45.5805 | 2005-05-17T00:00:00 |
UnitMeasureCode | Name | ModifiedDate |
---|---|---|
BOX | Boxes | 2002-06-01T00:00:00 |
BTL | Bottle | 2002-06-01T00:00:00 |
C | Celsius | 2002-06-01T00:00:00 |
WorkOrderID | ProductID | OrderQty | StockedQty | ScrappedQty | StartDate | EndDate | DueDate | ScrapReasonID | ModifiedDate |
---|---|---|---|---|---|---|---|---|---|
1 | 722 | 8 | 8 | 0 | 2005-07-04T00:00:00 | 2005-07-14T00:00:00 | 2005-07-15T00:00:00 | NULL | 2005-07-14T00:00:00 |
2 | 725 | 15 | 15 | 0 | 2005-07-04T00:00:00 | 2005-07-14T00:00:00 | 2005-07-15T00:00:00 | NULL | 2005-07-14T00:00:00 |
3 | 726 | 9 | 9 | 0 | 2005-07-04T00:00:00 | 2005-07-14T00:00:00 | 2005-07-15T00:00:00 | NULL | 2005-07-14T00:00:00 |
WorkOrderID | ProductID | OperationSequence | LocationID | ScheduledStartDate | ScheduledEndDate | ActualStartDate | ActualEndDate | ActualResourceHrs | PlannedCost | ActualCost | ModifiedDate |
---|---|---|---|---|---|---|---|---|---|---|---|
13 | 747 | 1 | 10 | 2005-07-04T00:00:00 | 2005-07-15T00:00:00 | 2005-07-04T00:00:00 | 2005-07-20T00:00:00 | 4.1000 | 92.2500 | 92.2500 | 2005-07-20T00:00:00 |
13 | 747 | 2 | 20 | 2005-07-04T00:00:00 | 2005-07-15T00:00:00 | 2005-07-04T00:00:00 | 2005-07-20T00:00:00 | 3.5000 | 87.5000 | 87.5000 | 2005-07-20T00:00:00 |
13 | 747 | 3 | 30 | 2005-07-04T00:00:00 | 2005-07-15T00:00:00 | 2005-07-04T00:00:00 | 2005-07-20T00:00:00 | 1.0000 | 14.5000 | 14.5000 | 2005-07-20T00:00:00 |
ProductID | BusinessEntityID | AverageLeadTime | StandardPrice | LastReceiptCost | LastReceiptDate | MinOrderQty | MaxOrderQty | OnOrderQty | UnitMeasureCode | ModifiedDate |
---|---|---|---|---|---|---|---|---|---|---|
1 | 1580 | 17 | 47.8700 | 50.2635 | 2005-09-29T00:00:00 | 1 | 5 | 3 | CS | 2005-09-29T00:00:00 |
2 | 1688 | 19 | 39.9200 | 41.9160 | 2005-09-29T00:00:00 | 1 | 5 | 3 | CTN | 2005-09-29T00:00:00 |
4 | 1650 | 17 | 54.3100 | 57.0255 | 2005-09-29T00:00:00 | 1 | 5 | NULL | CTN | 2005-09-29T00:00:00 |
PurchaseOrderID | PurchaseOrderDetailID | DueDate | OrderQty | ProductID | UnitPrice | LineTotal | ReceivedQty | RejectedQty | StockedQty | ModifiedDate |
---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 2005-05-31T00:00:00 | 4 | 1 | 50.2600 | 201.0400 | 3.00 | 0.00 | 3.00 | 2005-05-24T00:00:00 |
2 | 2 | 2005-05-31T00:00:00 | 3 | 359 | 45.1200 | 135.3600 | 3.00 | 0.00 | 3.00 | 2005-05-24T00:00:00 |
2 | 3 | 2005-05-31T00:00:00 | 3 | 360 | 45.5805 | 136.7415 | 3.00 | 0.00 | 3.00 | 2005-05-24T00:00:00 |
PurchaseOrderID | RevisionNumber | Status | EmployeeID | VendorID | ShipMethodID | OrderDate | ShipDate | SubTotal | TaxAmt | Freight | TotalDue | ModifiedDate |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 4 | 258 | 1580 | 3 | 2005-05-17T00:00:00 | 2005-05-26T00:00:00 | 201.0400 | 16.0832 | 5.0260 | 222.1492 | 2005-05-26T00:00:00 |
2 | 1 | 1 | 254 | 1496 | 5 | 2005-05-17T00:00:00 | 2005-05-26T00:00:00 | 272.1015 | 21.7681 | 6.8025 | 300.6721 | 2005-05-26T00:00:00 |
3 | 1 | 4 | 257 | 1494 | 2 | 2005-05-17T00:00:00 | 2005-05-26T00:00:00 | 8847.3000 | 707.7840 | 221.1825 | 9776.2665 | 2005-05-26T00:00:00 |
ShipMethodID | Name | ShipBase | ShipRate | rowguid | ModifiedDate |
---|---|---|---|---|---|
1 | XRQ - TRUCK GROUND | 3.9500 | 0.9900 | 6BE756D9-D7BE-4463-8F2C-AE60C710D606 | 2002-06-01T00:00:00 |
2 | ZY - EXPRESS | 9.9500 | 1.9900 | 3455079B-F773-4DC6-8F1E-2A58649C4AB8 | 2002-06-01T00:00:00 |
3 | OVERSEAS - DELUXE | 29.9500 | 2.9900 | 22F4E461-28CF-4ACE-A980-F686CF112EC8 | 2002-06-01T00:00:00 |
BusinessEntityID | AccountNumber | Name | CreditRating | PreferredVendorStatus | ActiveFlag | PurchasingWebServiceURL | ModifiedDate |
---|---|---|---|---|---|---|---|
1492 | AUSTRALI0001 | Australia Bike Retailer | 1 | 1 | 1 | NULL | 2006-01-23T00:00:00 |
1494 | ALLENSON0001 | Allenson Cycles | 2 | 1 | 1 | NULL | 2005-05-26T00:00:00 |
1496 | ADVANCED0001 | Advanced Bicycles | 1 | 1 | 1 | NULL | 2005-05-26T00:00:00 |
CountryRegionCode | CurrencyCode | ModifiedDate |
---|---|---|
AE | AED | 2008-03-11T10:17:21.510 |
AR | ARS | 2008-03-11T10:17:21.510 |
AT | ATS | 2008-03-11T10:17:21.510 |
CreditCardID | CardType | CardNumber | ExpMonth | ExpYear | ModifiedDate |
---|---|---|---|---|---|
1 | SuperiorCard | 33332664695310 | 11 | 2006 | 2007-08-30T00:00:00 |
2 | Distinguish | 55552127249722 | 8 | 2005 | 2008-01-06T00:00:00 |
3 | ColonialVoice | 77778344838353 | 7 | 2005 | 2008-02-15T00:00:00 |
CurrencyCode | Name | ModifiedDate |
---|---|---|
AED | Emirati Dirham | 2002-06-01T00:00:00 |
AFA | Afghani | 2002-06-01T00:00:00 |
ALL | Lek | 2002-06-01T00:00:00 |
CurrencyRateID | CurrencyRateDate | FromCurrencyCode | ToCurrencyCode | AverageRate | EndOfDayRate | ModifiedDate |
---|---|---|---|---|---|---|
1 | 2005-07-01T00:00:00 | USD | ARS | 1.0000 | 1.0002 | 2005-07-01T00:00:00 |
2 | 2005-07-01T00:00:00 | USD | AUD | 1.5491 | 1.5500 | 2005-07-01T00:00:00 |
3 | 2005-07-01T00:00:00 | USD | BRL | 1.9379 | 1.9419 | 2005-07-01T00:00:00 |
CustomerID | PersonID | StoreID | TerritoryID | AccountNumber | rowguid | ModifiedDate |
---|---|---|---|---|---|---|
1 | NULL | 934 | 1 | AW00000001 | 3F5AE95E-B87D-4AED-95B4-C3797AFCB74F | 2008-10-13T11:15:07.263 |
2 | NULL | 1028 | 1 | AW00000002 | E552F657-A9AF-4A7D-A645-C429D6E02491 | 2008-10-13T11:15:07.263 |
3 | NULL | 642 | 4 | AW00000003 | 130774B1-DB21-4EF3-98C8-C104BCD6ED6D | 2008-10-13T11:15:07.263 |
BusinessEntityID | CreditCardID | ModifiedDate |
---|---|---|
293 | 17038 | 2007-09-01T00:00:00 |
295 | 15369 | 2005-09-01T00:00:00 |
297 | 8010 | 2005-09-01T00:00:00 |
SalesOrderID | SalesOrderDetailID | CarrierTrackingNumber | OrderQty | ProductID | SpecialOfferID | UnitPrice | UnitPriceDiscount | LineTotal | rowguid | ModifiedDate |
---|---|---|---|---|---|---|---|---|---|---|
43659 | 1 | 4911-403C-98 | 1 | 776 | 1 | 2024.9940 | 0.0000 | 2024.994000 | B207C96D-D9E6-402B-8470-2CC176C42283 | 2005-07-01T00:00:00 |
43659 | 2 | 4911-403C-98 | 3 | 777 | 1 | 2024.9940 | 0.0000 | 6074.982000 | 7ABB600D-1E77-41BE-9FE5-B9142CFC08FA | 2005-07-01T00:00:00 |
43659 | 3 | 4911-403C-98 | 1 | 778 | 1 | 2024.9940 | 0.0000 | 2024.994000 | 475CF8C6-49F6-486E-B0AD-AFC6A50CDD2F | 2005-07-01T00:00:00 |
SalesOrderID | RevisionNumber | OrderDate | DueDate | ShipDate | Status | OnlineOrderFlag | SalesOrderNumber | PurchaseOrderNumber | AccountNumber | CustomerID | SalesPersonID | TerritoryID | BillToAddressID | ShipToAddressID | ShipMethodID | CreditCardID | CreditCardApprovalCode | CurrencyRateID | SubTotal | TaxAmt | Freight | TotalDue | Comment | rowguid | ModifiedDate |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43659 | 3 | 2005-07-01T00:00:00 | 2005-07-13T00:00:00 | 2005-07-08T00:00:00 | 5 | 0 | SO43659 | PO522145787 | 10-4020-000676 | 29825 | 279 | 5 | 985 | 985 | 5 | 16281 | 105041Vi84182 | NULL | 20565.6206 | 1971.5149 | 616.0984 | 23153.2339 | NULL | 79B65321-39CA-4115-9CBA-8FE0903E12E6 | 2005-07-08T00:00:00 |
43660 | 3 | 2005-07-01T00:00:00 | 2005-07-13T00:00:00 | 2005-07-08T00:00:00 | 5 | 0 | SO43660 | PO18850127500 | 10-4020-000117 | 29672 | 279 | 5 | 921 | 921 | 5 | 5618 | 115213Vi29411 | NULL | 1294.2529 | 124.2483 | 38.8276 | 1457.3288 | NULL | 738DC42D-D03B-48A1-9822-F95A67EA7389 | 2005-07-08T00:00:00 |
43661 | 3 | 2005-07-01T00:00:00 | 2005-07-13T00:00:00 | 2005-07-08T00:00:00 | 5 | 0 | SO43661 | PO18473189620 | 10-4020-000442 | 29734 | 282 | 6 | 517 | 517 | 5 | 1346 | 85274Vi6854 | 4 | 32726.4786 | 3153.7696 | 985.5530 | 36865.8012 | NULL | D91B9131-18A4-4A11-BC3A-90B6F53E9D74 | 2005-07-08T00:00:00 |
SalesOrderID | SalesReasonID | ModifiedDate |
---|---|---|
43697 | 5 | 2005-07-01T00:00:00 |
43697 | 9 | 2005-07-01T00:00:00 |
43702 | 5 | 2005-07-02T00:00:00 |
BusinessEntityID | TerritoryID | SalesQuota | Bonus | CommissionPct | SalesYTD | SalesLastYear | rowguid | ModifiedDate |
---|---|---|---|---|---|---|---|---|
274 | NULL | NULL | 0.0000 | 0.0000 | 559697.5639 | 0.0000 | 48754992-9EE0-4C0E-8C94-9451604E3E02 | 2005-01-28T00:00:00 |
275 | 2 | 300000.0000 | 4100.0000 | 0.0120 | 3763178.1787 | 1750406.4785 | 1E0A7274-3064-4F58-88EE-4C6586C87169 | 2005-06-24T00:00:00 |
276 | 4 | 250000.0000 | 2000.0000 | 0.0150 | 4251368.5497 | 1439156.0291 | 4DD9EEE4-8E81-4F8C-AF97-683394C1F7C0 | 2005-06-24T00:00:00 |
BusinessEntityID | QuotaDate | SalesQuota | rowguid | ModifiedDate |
---|---|---|---|---|
274 | 2005-07-01T00:00:00 | 28000.0000 | 99109BBF-8693-4587-BC23-6036EC89E1BE | 2005-05-17T00:00:00 |
274 | 2005-10-01T00:00:00 | 7000.0000 | DFD01444-8900-461C-8D6F-04598DAE01D4 | 2005-08-17T00:00:00 |
274 | 2006-01-01T00:00:00 | 91000.0000 | 0A69F453-9689-4CCF-A08C-C644670F5668 | 2005-11-17T00:00:00 |
SalesReasonID | Name | ReasonType | ModifiedDate |
---|---|---|---|
1 | Price | Other | 2002-06-01T00:00:00 |
2 | On Promotion | Promotion | 2002-06-01T00:00:00 |
3 | Magazine Advertisement | Marketing | 2002-06-01T00:00:00 |
SalesTaxRateID | StateProvinceID | TaxType | TaxRate | Name | rowguid | ModifiedDate |
---|---|---|---|---|---|---|
1 | 1 | 1 | 14.0000 | Canadian GST + Alberta Provincial Tax | 683DE5DD-521A-47D4-A573-06A3CDB1BC5D | 2002-06-01T00:00:00 |
2 | 57 | 1 | 14.2500 | Canadian GST + Ontario Provincial Tax | 05C4FFDB-4F84-4CDF-ABE5-FDF3216EA74E | 2002-06-01T00:00:00 |
3 | 63 | 1 | 14.2500 | Canadian GST + Quebec Provincial Tax | D4EDB557-56D7-403C-B538-4DF5E7302588 | 2002-06-01T00:00:00 |
TerritoryID | Name | CountryRegionCode | Group | SalesYTD | SalesLastYear | CostYTD | CostLastYear | rowguid | ModifiedDate |
---|---|---|---|---|---|---|---|---|---|
1 | Northwest | US | North America | 7887186.7882 | 3298694.4938 | 0.0000 | 0.0000 | 43689A10-E30B-497F-B0DE-11DE20267FF7 | 2002-06-01T00:00:00 |
2 | Northeast | US | North America | 2402176.8476 | 3607148.9371 | 0.0000 | 0.0000 | 00FB7309-96CC-49E2-8363-0A1BA72486F2 | 2002-06-01T00:00:00 |
3 | Central | US | North America | 3072175.1180 | 3205014.0767 | 0.0000 | 0.0000 | DF6E7FD8-1A8D-468C-B103-ED8ADDB452C1 | 2002-06-01T00:00:00 |
BusinessEntityID | TerritoryID | StartDate | EndDate | rowguid | ModifiedDate |
---|---|---|---|---|---|
275 | 2 | 2005-07-01T00:00:00 | 2006-12-31T00:00:00 | 8563CE6A-00FF-47D7-BA4D-3C3E1CDEF531 | 2006-12-24T00:00:00 |
275 | 3 | 2007-01-01T00:00:00 | NULL | 2F44304C-EE87-4C72-813E-CA75C5F61F4C | 2006-12-25T00:00:00 |
276 | 4 | 2005-07-01T00:00:00 | NULL | 64BCB1B3-A793-40BA-9859-D90F78C3F167 | 2005-06-24T00:00:00 |
ShoppingCartItemID | ShoppingCartID | Quantity | ProductID | DateCreated | ModifiedDate |
---|---|---|---|---|---|
2 | 14951 | 3 | 862 | 2007-12-11T17:54:07.603 | 2007-12-11T17:54:07.603 |
4 | 20621 | 4 | 881 | 2007-12-11T17:54:07.603 | 2007-12-11T17:54:07.603 |
5 | 20621 | 7 | 874 | 2007-12-11T17:54:07.603 | 2007-12-11T17:54:07.603 |
SpecialOfferID | Description | DiscountPct | Type | Category | StartDate | EndDate | MinQty | MaxQty | rowguid | ModifiedDate |
---|---|---|---|---|---|---|---|---|---|---|
1 | No Discount | 0.0000 | No Discount | No Discount | 2005-06-01T00:00:00 | 2008-12-31T00:00:00 | 0 | NULL | 0290C4F5-191F-4337-AB6B-0A2DDE03CBF9 | 2005-05-02T00:00:00 |
2 | Volume Discount 11 to 14 | 0.0200 | Volume Discount | Reseller | 2005-07-01T00:00:00 | 2008-06-30T00:00:00 | 11 | 14 | D7542EE7-15DB-4541-985C-5CC27AEF26D6 | 2005-06-01T00:00:00 |
3 | Volume Discount 15 to 24 | 0.0500 | Volume Discount | Reseller | 2005-07-01T00:00:00 | 2008-06-30T00:00:00 | 15 | 24 | 4BDBCC01-8CF7-40A9-B643-40EC5B717491 | 2005-06-01T00:00:00 |
SpecialOfferID | ProductID | rowguid | ModifiedDate |
---|---|---|---|
1 | 680 | BB30B868-D86C-4557-8DB2-4B2D0A83A0FB | 2005-05-02T00:00:00 |
1 | 706 | B3C9A4B1-2AE6-4CBA-B552-1F206C9F4C1F | 2005-05-02T00:00:00 |
1 | 707 | 27B711FE-0B77-4EA4-AD1A-7C239956BEF4 | 2005-05-02T00:00:00 |
BusinessEntityID | Name | SalesPersonID | Demographics | rowguid | ModifiedDate |
---|---|---|---|---|---|
292 | Next-Door Bike Store | 279 | NULL | A22517E3-848D-4EBE-B9D9-7437F3432304 | 2008-10-13T11:15:07.497 |
294 | Professional Sales and Service | 276 | NULL | B50CA50B-C601-4A13-B07E-2C63862D71B4 | 2008-10-13T11:15:07.497 |
296 | Riders Company | 277 | NULL | 337C3688-1339-4E1A-A08A-B54B23566E49 | 2008-10-13T11:15:07.497 |