[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 500 SHUFFLE SKIP 936 < SKIP 625 > < TAKE 62 >
62 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimPromotionId | DimResellerId | DimSalesTerritoryId | DiscountAmount | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice | UnitPriceDiscountPct |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48053_2 | 69FC-4D14-B1 | PO4466199959 | 19 | 291 | 360 | 352 | 6 | 2023-01-04 | 4917.84 | 122.95 | 2022-12-23 | 4 | 1105.81 | 1 | 4917.84 | 2 | SO48053 | 2022-12-30 | 393.43 | 4423.24 | 1229.46 | |||
SO47398_2 | 283C-414B-A2 | PO10614138214 | 19 | 291 | 461 | 461 | 6 | 2022-11-04 | 215.98 | 5.40 | 2022-10-23 | 4 | 37.12 | 1 | 215.98 | 2 | SO47398 | 2022-10-30 | 17.28 | 148.48 | 53.99 | |||
SO47366_12 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 460 | 155 | 6 | 2022-11-04 | 485.95 | 12.15 | 2022-10-23 | 9 | 37.12 | 1 | 485.95 | 12 | SO47366 | 2022-10-30 | 38.88 | 334.09 | 53.99 | |||
SO51740_2 | A7C0-406B-82 | PO12789111329 | 19 | 291 | 544 | 677 | 6 | 2023-10-04 | 145.78 | 3.64 | 2023-09-22 | 3 | 35.96 | 1 | 145.78 | 2 | SO51740 | 2023-09-29 | 11.66 | 107.88 | 48.59 | |||
SO59022_3 | F672-4E69-A9 | PO7366189433 | 19 | 284 | 494 | 372 | 6 | 2024-02-03 | 1204.69 | 30.12 | 2024-01-22 | 2 | 601.74 | 1 | 1204.69 | 3 | SO59022 | 2024-01-29 | 96.38 | 1203.49 | 602.35 | |||
SO47979_8 | 33B2-4238-8F | PO17806159797 | 19 | 291 | 224 | 101 | 6 | 2023-01-04 | 10.37 | 0.26 | 2022-12-23 | 2 | 5.23 | 1 | 10.37 | 8 | SO47979 | 2022-12-30 | 0.83 | 10.46 | 5.19 | |||
SO63174_11 | 0B72-4270-AC | PO1827182060 | 19 | 291 | 390 | 317 | 6 | 2024-04-05 | 2016.88 | 50.42 | 2024-03-24 | 3 | 713.08 | 1 | 2016.88 | 11 | SO63174 | 2024-03-31 | 161.35 | 2139.24 | 672.29 | |||
SO57188_30 | BA1D-4480-AA | PO9077120275 | 19 | 291 | 474 | 100 | 6 | 2024-01-04 | 251.96 | 6.30 | 2023-12-23 | 6 | 26.18 | 1 | 251.96 | 30 | SO57188 | 2023-12-30 | 20.16 | 157.06 | 41.99 | |||
SO49480_1 | BA71-43B7-82 | PO19401115391 | 19 | 291 | 458 | 173 | 6 | 2023-05-04 | 134.98 | 3.37 | 2023-04-22 | 3 | 30.93 | 1 | 134.98 | 1 | SO49480 | 2023-04-29 | 10.80 | 92.80 | 44.99 | |||
SO50694_32 | DAEB-4730-9B | PO17545120609 | 19 | 291 | 233 | 155 | 6 | 2023-08-04 | 173.04 | 4.33 | 2023-07-23 | 6 | 29.08 | 1 | 173.04 | 32 | SO50694 | 2023-07-30 | 13.84 | 174.48 | 28.84 | |||
SO67270_9 | 685A-440D-8C | PO14732111382 | 19 | 291 | 467 | 514 | 6 | 2024-06-04 | 58.78 | 1.47 | 2024-05-23 | 4 | 9.16 | 1 | 58.78 | 9 | SO67270 | 2024-05-30 | 4.70 | 36.64 | 14.69 | |||
SO55287_8 | 4BBD-4DA3-AD | PO13862128497 | 19 | 291 | 596 | 119 | 6 | 2023-12-04 | 971.98 | 24.30 | 2023-11-22 | 3 | 294.58 | 1 | 971.98 | 8 | SO55287 | 2023-11-29 | 77.76 | 883.74 | 323.99 | |||
SO49827_37 | E4F0-4B91-84 | PO15312199090 | 19 | 291 | 377 | 299 | 6 | 2023-06-04 | 1308.94 | 32.72 | 2023-05-23 | 1 | 1320.68 | 1 | 1308.94 | 37 | SO49827 | 2023-05-30 | 104.72 | 1320.68 | 1308.94 | |||
SO46945_1 | 649F-402B-B3 | PO18415191122 | 19 | 291 | 424 | 191 | 6 | 2022-10-04 | 214.24 | 5.36 | 2022-09-22 | 1 | 158.53 | 1 | 214.24 | 1 | SO46945 | 2022-09-29 | 17.14 | 158.53 | 214.24 | |||
SO48306_2 | EA27-471A-9D | PO17574166075 | 19 | 291 | 362 | 678 | 6 | 2023-02-03 | 1229.46 | 30.74 | 2023-01-22 | 1 | 1105.81 | 1 | 1229.46 | 2 | SO48306 | 2023-01-29 | 98.36 | 1105.81 | 1229.46 | |||
SO51769_19 | 4AAC-4066-A6 | PO1595126190 | 19 | 284 | 281 | 426 | 6 | 2023-10-04 | 404.66 | 10.12 | 2023-09-22 | 2 | 204.63 | 1 | 404.66 | 19 | SO51769 | 2023-09-29 | 32.37 | 409.25 | 202.33 | |||
SO45786_16 | C4AF-4371-B7 | PO14732192241 | 19 | 288 | 285 | 514 | 6 | 2022-06-04 | 357.16 | 8.93 | 2022-05-23 | 2 | 176.20 | 1 | 357.16 | 16 | SO45786 | 2022-05-30 | 28.57 | 352.40 | 178.58 | |||
SO61204_11 | E810-4164-82 | PO15312134209 | 19 | 291 | 484 | 299 | 6 | 2024-03-05 | 19.08 | 0.48 | 2024-02-22 | 4 | 2.97 | 1 | 19.08 | 11 | SO61204 | 2024-02-29 | 1.53 | 11.89 | 4.77 | |||
SO50694_52 | DAEB-4730-9B | PO17545120609 | 19 | 291 | 448 | 155 | 6 | 2023-08-04 | 47.98 | 1.20 | 2023-07-23 | 4 | 8.25 | 1 | 47.98 | 52 | SO50694 | 2023-07-30 | 3.84 | 32.98 | 11.99 | |||
SO57024_36 | DED7-4CEF-90 | PO17661138970 | 19 | 284 | 558 | 264 | 6 | 2024-01-04 | 242.99 | 6.07 | 2023-12-23 | 1 | 179.82 | 1 | 242.99 | 36 | SO57024 | 2023-12-30 | 19.44 | 179.82 | 242.99 | |||
SO47359_23 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 447 | 2 | 118 | 6 | 3.19 | 2022-11-04 | 159.50 | 3.91 | 2022-10-23 | 11 | 10.31 | 1 | 156.31 | 23 | SO47359 | 2022-10-30 | 12.50 | 113.44 | 14.50 | 0.02 |
SO45800_2 | 5B67-4FE2-B9 | PO10527156525 | 19 | 284 | 315 | 480 | 6 | 2022-06-04 | 3499.18 | 87.48 | 2022-05-23 | 4 | 884.71 | 1 | 3499.18 | 2 | SO45800 | 2022-05-30 | 279.93 | 3538.83 | 874.79 | |||
SO61232_4 | 3450-43E5-B1 | PO11136111699 | 19 | 284 | 569 | 120 | 6 | 2024-03-05 | 890.82 | 22.27 | 2024-02-22 | 2 | 461.44 | 1 | 890.82 | 4 | SO61232 | 2024-02-29 | 71.27 | 922.89 | 445.41 | |||
SO50204_14 | 4453-4267-A1 | PO16733169352 | 19 | 291 | 460 | 533 | 6 | 2023-07-04 | 323.96 | 8.10 | 2023-06-22 | 6 | 37.12 | 1 | 323.96 | 14 | SO50204 | 2023-06-29 | 25.92 | 222.73 | 53.99 | |||
SO45313_10 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 220 | 317 | 6 | 2022-04-06 | 60.56 | 1.51 | 2022-03-25 | 3 | 12.03 | 1 | 60.56 | 10 | SO45313 | 2022-04-01 | 4.84 | 36.08 | 20.19 | |||
SO49140_4 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 462 | 84 | 6 | 2023-04-06 | 42.39 | 1.06 | 2023-03-25 | 3 | 9.71 | 1 | 42.39 | 4 | SO49140 | 2023-04-01 | 3.39 | 29.14 | 14.13 | |||
SO47708_16 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 352 | 496 | 6 | 2022-12-04 | 1242.85 | 31.07 | 2022-11-22 | 1 | 1117.86 | 1 | 1242.85 | 16 | SO47708 | 2022-11-29 | 99.43 | 1117.86 | 1242.85 | |||
SO51818_25 | B8CE-4C91-A9 | PO9077115532 | 19 | 291 | 309 | 100 | 6 | 2023-10-04 | 818.70 | 20.47 | 2023-09-22 | 1 | 747.20 | 1 | 818.70 | 25 | SO51818 | 2023-09-29 | 65.50 | 747.20 | 818.70 | |||
SO67302_18 | E4B2-462D-AC | PO18473194134 | 19 | 291 | 512 | 442 | 6 | 2024-06-04 | 218.45 | 5.46 | 2024-05-23 | 1 | 199.38 | 1 | 218.45 | 18 | SO67302 | 2024-05-30 | 17.48 | 199.38 | 218.45 | |||
SO71847_22 | 3A74-467E-8B | PO18502143784 | 19 | 291 | 564 | 154 | 6 | 2024-08-04 | 12873.98 | 321.85 | 2024-07-23 | 9 | 1481.94 | 1 | 12873.98 | 22 | SO71847 | 2024-07-30 | 1029.92 | 13337.44 | 1430.44 | |||
SO47012_24 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 216 | 66 | 6 | 2022-10-04 | 40.37 | 1.01 | 2022-09-22 | 2 | 13.88 | 1 | 40.37 | 24 | SO47012 | 2022-09-29 | 3.23 | 27.76 | 20.19 | |||
SO49484_4 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 352 | 118 | 6 | 2023-05-04 | 1242.85 | 31.07 | 2023-04-22 | 1 | 1117.86 | 1 | 1242.85 | 4 | SO49484 | 2023-04-29 | 99.43 | 1117.86 | 1242.85 | |||
SO49485_2 | 9EA5-4DEF-B8 | PO17545171443 | 19 | 291 | 456 | 155 | 6 | 2023-05-04 | 134.98 | 3.37 | 2023-04-22 | 3 | 30.93 | 1 | 134.98 | 2 | SO49485 | 2023-04-29 | 10.80 | 92.80 | 44.99 | |||
SO45524_4 | D7A1-4CAA-B1 | PO18299160578 | 19 | 288 | 218 | 118 | 6 | 2022-05-04 | 22.80 | 0.57 | 2022-04-22 | 4 | 3.40 | 1 | 22.80 | 4 | SO45524 | 2022-04-29 | 1.82 | 13.59 | 5.70 | |||
SO50199_7 | 8C45-47E6-93 | PO17748185472 | 19 | 284 | 381 | 102 | 6 | 2023-07-04 | 1200.53 | 30.01 | 2023-06-22 | 2 | 605.65 | 1 | 1200.53 | 7 | SO50199 | 2023-06-29 | 96.04 | 1211.30 | 600.26 | |||
SO63128_6 | 9486-41CD-91 | PO18879146432 | 19 | 291 | 577 | 64 | 6 | 2024-04-05 | 1457.82 | 36.45 | 2024-03-24 | 2 | 755.15 | 1 | 1457.82 | 6 | SO63128 | 2024-03-31 | 116.63 | 1510.30 | 728.91 | |||
SO53464_4 | E113-419B-8F | PO17545119283 | 19 | 291 | 582 | 155 | 6 | 2023-11-04 | 2041.19 | 51.03 | 2023-10-23 | 2 | 1082.51 | 1 | 2041.19 | 4 | SO53464 | 2023-10-30 | 163.30 | 2165.02 | 1020.59 | |||
SO51156_5 | C598-4D75-B4 | PO4930142451 | 19 | 291 | 474 | 3 | 425 | 6 | 30.80 | 2023-09-03 | 615.91 | 14.63 | 2023-08-22 | 16 | 26.18 | 1 | 585.12 | 5 | SO51156 | 2023-08-29 | 46.81 | 418.82 | 38.49 | 0.05 |
SO71871_2 | DD8F-4CAB-A1 | PO14239120760 | 19 | 291 | 545 | 550 | 6 | 2024-08-04 | 24.29 | 0.61 | 2024-07-23 | 1 | 17.98 | 1 | 24.29 | 2 | SO71871 | 2024-07-30 | 1.94 | 17.98 | 24.29 | |||
SO58958_7 | BC3F-443F-B5 | PO10875118816 | 19 | 291 | 570 | 281 | 6 | 2024-02-03 | 445.41 | 11.14 | 2024-01-22 | 1 | 461.44 | 1 | 445.41 | 7 | SO58958 | 2024-01-29 | 35.63 | 461.44 | 445.41 | |||
SO51740_21 | A7C0-406B-82 | PO12789111329 | 19 | 291 | 490 | 677 | 6 | 2023-10-04 | 32.39 | 0.81 | 2023-09-22 | 1 | 41.57 | 1 | 32.39 | 21 | SO51740 | 2023-09-29 | 2.59 | 41.57 | 32.39 | |||
SO51755_12 | 46F4-477C-A7 | PO11020169365 | 19 | 284 | 287 | 336 | 6 | 2023-10-04 | 404.66 | 10.12 | 2023-09-22 | 2 | 204.63 | 1 | 404.66 | 12 | SO51755 | 2023-09-29 | 32.37 | 409.25 | 202.33 | |||
SO71825_5 | 13EC-4324-90 | PO11165197222 | 19 | 291 | 475 | 586 | 6 | 2024-08-04 | 125.98 | 3.15 | 2024-07-23 | 3 | 26.18 | 1 | 125.98 | 5 | SO71825 | 2024-07-30 | 10.08 | 78.53 | 41.99 | |||
SO46657_53 | CA71-4EDF-A1 | PO4495116659 | 19 | 291 | 364 | 496 | 6 | 2022-09-03 | 3887.96 | 97.20 | 2022-08-22 | 6 | 598.44 | 1 | 3887.96 | 53 | SO46657 | 2022-08-29 | 311.04 | 3590.61 | 647.99 | |||
SO50295_5 | 575E-4F7A-9C | PO4466165095 | 19 | 291 | 456 | 352 | 6 | 2023-07-04 | 224.97 | 5.62 | 2023-06-22 | 5 | 30.93 | 1 | 224.97 | 5 | SO50295 | 2023-06-29 | 18.00 | 154.67 | 44.99 | |||
SO48036_27 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 417 | 66 | 6 | 2023-01-04 | 324.45 | 8.11 | 2022-12-23 | 1 | 300.12 | 1 | 324.45 | 27 | SO48036 | 2022-12-30 | 25.96 | 300.12 | 324.45 | |||
SO46034_17 | BF2B-4539-A2 | PO18415186478 | 19 | 288 | 264 | 191 | 6 | 2022-07-04 | 183.94 | 4.60 | 2022-06-22 | 1 | 181.49 | 1 | 183.94 | 17 | SO46034 | 2022-06-29 | 14.72 | 181.49 | 183.94 | |||
SO45057_14 | 568E-472E-9C | PO11049133413 | 19 | 284 | 338 | 679 | 6 | 2022-03-06 | 419.46 | 10.49 | 2022-02-22 | 1 | 413.15 | 1 | 419.46 | 14 | SO45057 | 2022-03-01 | 33.56 | 413.15 | 419.46 | |||
SO46616_36 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 267 | 514 | 6 | 2022-09-03 | 404.66 | 10.12 | 2022-08-22 | 2 | 187.16 | 1 | 404.66 | 36 | SO46616 | 2022-08-29 | 32.37 | 374.31 | 202.33 | |||
SO45526_2 | A603-42AF-A1 | PO17690133184 | 19 | 272 | 218 | 47 | 6 | 2022-05-04 | 11.40 | 0.29 | 2022-04-22 | 2 | 3.40 | 1 | 11.40 | 2 | SO45526 | 2022-04-29 | 0.91 | 6.79 | 5.70 | |||
SO46038_12 | D7B6-499A-87 | PO17748117802 | 19 | 284 | 317 | 102 | 6 | 2022-07-04 | 2624.38 | 65.61 | 2022-06-22 | 3 | 884.71 | 1 | 2624.38 | 12 | SO46038 | 2022-06-29 | 209.95 | 2654.12 | 874.79 | |||
SO71806_16 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 587 | 497 | 6 | 2024-08-04 | 923.39 | 23.08 | 2024-07-23 | 2 | 419.78 | 1 | 923.39 | 16 | SO71806 | 2024-07-30 | 73.87 | 839.56 | 461.69 | |||
SO44547_13 | 801C-4288-87 | PO4901179982 | 19 | 284 | 253 | 84 | 6 | 2022-01-04 | 357.16 | 8.93 | 2021-12-23 | 2 | 176.20 | 1 | 357.16 | 13 | SO44547 | 2021-12-30 | 28.57 | 352.40 | 178.58 | |||
SO47415_1 | 4C47-41C8-B0 | PO2233131382 | 19 | 291 | 286 | 262 | 6 | 2022-11-04 | 735.75 | 18.39 | 2022-10-23 | 4 | 170.14 | 1 | 735.75 | 1 | SO47415 | 2022-10-30 | 58.86 | 680.57 | 183.94 | |||
SO71792_27 | 5257-4FC4-A5 | PO17545115036 | 19 | 291 | 546 | 155 | 6 | 2024-08-04 | 186.27 | 4.66 | 2024-07-23 | 5 | 27.57 | 1 | 186.27 | 27 | SO71792 | 2024-07-30 | 14.90 | 137.84 | 37.25 | |||
SO46929_1 | F40B-49A9-87 | PO20242176175 | 19 | 284 | 397 | 390 | 6 | 2022-10-04 | 24.29 | 0.61 | 2022-09-22 | 1 | 17.98 | 1 | 24.29 | 1 | SO46929 | 2022-09-29 | 1.94 | 17.98 | 24.29 | |||
SO44496_18 | 6ADA-4A25-AA | PO18415194469 | 19 | 288 | 316 | 191 | 6 | 2022-01-04 | 874.79 | 21.87 | 2021-12-23 | 1 | 884.71 | 1 | 874.79 | 18 | SO44496 | 2021-12-30 | 69.98 | 884.71 | 874.79 | |||
SO45529_11 | 86CC-47BA-B3 | PO17574182721 | 19 | 288 | 293 | 678 | 6 | 2022-05-04 | 1445.19 | 36.13 | 2022-04-22 | 2 | 623.84 | 1 | 1445.19 | 11 | SO45529 | 2022-04-29 | 115.62 | 1247.68 | 722.59 | |||
SO63139_5 | 73B7-47A8-A1 | PO17632187779 | 19 | 291 | 225 | 28 | 6 | 2024-04-05 | 10.79 | 0.27 | 2024-03-24 | 2 | 6.92 | 1 | 10.79 | 5 | SO63139 | 2024-03-31 | 0.86 | 13.84 | 5.39 | |||
SO49501_33 | EF67-4713-BD | PO17574111786 | 19 | 291 | 420 | 678 | 6 | 2023-05-04 | 566.46 | 14.16 | 2023-04-22 | 4 | 104.80 | 1 | 566.46 | 33 | SO49501 | 2023-04-29 | 45.32 | 419.18 | 141.62 | |||
SO47708_30 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 421 | 496 | 6 | 2022-12-04 | 1570.63 | 39.27 | 2022-11-22 | 8 | 145.28 | 1 | 1570.63 | 30 | SO47708 | 2022-11-29 | 125.65 | 1162.27 | 196.33 | |||
SO50242_10 | A651-4343-86 | PO1595193228 | 19 | 284 | 286 | 426 | 6 | 2023-07-04 | 367.88 | 9.20 | 2023-06-22 | 2 | 170.14 | 1 | 367.88 | 10 | SO50242 | 2023-06-29 | 29.43 | 340.29 | 183.94 |
Generated 2024-09-21 11:07:50.418 UTC