[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 1375 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71844_3 | 410D-4079-9E | PO2813198985 | 100 | 283 | 465 | 2 | 90 | 5 | 3.41 | 2024-08-19 | 170.45 | 4.18 | 2024-08-07 | 12 | 9.16 | 1 | 167.04 | 3 | SO71844 | 2024-08-14 | 13.36 | 109.91 | 14.20 | 0.02 |
SO44552_4 | 79A1-4836-9F | PO5858149301 | 100 | 285 | 307 | 566 | 5 | 2022-01-19 | 722.59 | 18.06 | 2022-01-07 | 1 | 623.84 | 1 | 722.59 | 4 | SO44552 | 2022-01-14 | 57.81 | 623.84 | 722.59 | |||
SO45285_1 | 91C9-46BD-A9 | PO16791139915 | 100 | 281 | 338 | 36 | 2 | 2022-04-21 | 419.46 | 10.49 | 2022-04-09 | 1 | 413.15 | 1 | 419.46 | 1 | SO45285 | 2022-04-16 | 33.56 | 413.15 | 419.46 | |||
SO53573_31 | F674-4899-B9 | PO8671117198 | 98 | 288 | 298 | 502 | 10 | 2023-11-19 | 4858.56 | 121.46 | 2023-11-07 | 6 | 739.04 | 1 | 4858.56 | 31 | SO53573 | 2023-11-14 | 388.68 | 4434.25 | 809.76 | |||
SO47398_34 | 283C-414B-A2 | PO10614138214 | 19 | 291 | 343 | 461 | 6 | 2022-11-19 | 939.59 | 23.49 | 2022-11-07 | 2 | 486.71 | 1 | 939.59 | 34 | SO47398 | 2022-11-14 | 75.17 | 973.41 | 469.79 | |||
SO44517_3 | 47C8-4635-A6 | PO13572181174 | 100 | 287 | 332 | 527 | 3 | 2022-01-19 | 838.92 | 20.97 | 2022-01-07 | 2 | 413.15 | 1 | 838.92 | 3 | SO44517 | 2022-01-14 | 67.11 | 826.29 | 419.46 | |||
SO47384_44 | 8780-4D54-85 | PO14268113342 | 100 | 283 | 337 | 418 | 3 | 2022-11-19 | 939.59 | 23.49 | 2022-11-07 | 2 | 486.71 | 1 | 939.59 | 44 | SO47384 | 2022-11-14 | 75.17 | 973.41 | 469.79 | |||
SO51845_30 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 471 | 312 | 4 | 2023-10-19 | 304.80 | 7.62 | 2023-10-07 | 8 | 23.75 | 1 | 304.80 | 30 | SO51845 | 2023-10-14 | 24.38 | 189.99 | 38.10 | |||
SO67260_13 | 6224-4229-B8 | PO522163557 | 100 | 285 | 524 | 676 | 5 | 2024-06-19 | 158.43 | 3.96 | 2024-06-07 | 1 | 144.59 | 1 | 158.43 | 13 | SO67260 | 2024-06-14 | 12.67 | 144.59 | 158.43 | |||
SO53505_1 | B522-40FD-B5 | PO11397144048 | 36 | 295 | 484 | 176 | 8 | 2023-11-19 | 14.31 | 0.36 | 2023-11-07 | 3 | 2.97 | 1 | 14.31 | 1 | SO53505 | 2023-11-14 | 1.14 | 8.92 | 4.77 | |||
SO48336_5 | 48F2-4141-9A | PO11455111823 | 100 | 281 | 216 | 72 | 2 | 2023-02-18 | 121.12 | 3.03 | 2023-02-06 | 6 | 13.88 | 1 | 121.12 | 5 | SO48336 | 2023-02-13 | 9.69 | 83.27 | 20.19 | |||
SO55234_8 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 363 | 676 | 5 | 2023-12-19 | 1376.99 | 34.42 | 2023-12-07 | 1 | 1251.98 | 1 | 1376.99 | 8 | SO55234 | 2023-12-14 | 110.16 | 1251.98 | 1376.99 | |||
SO57012_45 | BE3B-4D30-A7 | PO580126740 | 36 | 295 | 492 | 230 | 8 | 2024-01-19 | 1807.04 | 45.18 | 2024-01-07 | 3 | 601.74 | 1 | 1807.04 | 45 | SO57012 | 2024-01-14 | 144.56 | 1805.23 | 602.35 | |||
SO45786_8 | C4AF-4371-B7 | PO14732192241 | 19 | 288 | 316 | 514 | 6 | 2022-06-19 | 1749.59 | 43.74 | 2022-06-07 | 2 | 884.71 | 1 | 1749.59 | 8 | SO45786 | 2022-06-14 | 139.97 | 1769.42 | 874.79 | |||
SO47054_26 | E4B1-4C58-AE | PO7627150376 | 100 | 286 | 329 | 433 | 1 | 2022-10-19 | 469.79 | 11.74 | 2022-10-07 | 1 | 486.71 | 1 | 469.79 | 26 | SO47054 | 2022-10-14 | 37.58 | 486.71 | 469.79 | |||
SO51155_5 | 33E2-431A-A1 | PO4524147322 | 36 | 295 | 255 | 482 | 8 | 2023-09-18 | 202.33 | 5.06 | 2023-09-06 | 1 | 204.63 | 1 | 202.33 | 5 | SO51155 | 2023-09-13 | 16.19 | 204.63 | 202.33 | |||
SO49868_7 | 6BF3-4FD0-B5 | PO11861146173 | 100 | 283 | 224 | 17 | 5 | 2023-06-19 | 31.12 | 0.78 | 2023-06-07 | 6 | 5.23 | 1 | 31.12 | 7 | SO49868 | 2023-06-14 | 2.49 | 31.38 | 5.19 | |||
SO51773_21 | 14B1-48BF-A0 | PO2523163173 | 100 | 287 | 463 | 167 | 4 | 2023-10-19 | 73.47 | 1.84 | 2023-10-07 | 5 | 9.16 | 1 | 73.47 | 21 | SO51773 | 2023-10-14 | 5.88 | 45.80 | 14.69 | |||
SO47422_38 | 9D8D-4481-B6 | PO3915123127 | 100 | 283 | 236 | 130 | 4 | 2022-11-19 | 86.52 | 2.16 | 2022-11-07 | 3 | 29.08 | 1 | 86.52 | 38 | SO47422 | 2022-11-14 | 6.92 | 87.24 | 28.84 | |||
SO45555_13 | B11A-41CE-84 | PO3248155143 | 100 | 282 | 218 | 366 | 4 | 2022-05-19 | 11.40 | 0.29 | 2022-05-07 | 2 | 3.40 | 1 | 11.40 | 13 | SO45555 | 2022-05-14 | 0.91 | 6.79 | 5.70 | |||
SO55245_20 | B5AD-476D-B4 | PO14732112185 | 19 | 291 | 605 | 2 | 514 | 6 | 75.17 | 2023-12-19 | 3758.33 | 92.08 | 2023-12-07 | 12 | 343.65 | 1 | 3683.16 | 20 | SO55245 | 2023-12-14 | 294.65 | 4123.80 | 313.19 | 0.02 |
SO67292_12 | 09EF-4688-BB | PO551144976 | 100 | 281 | 604 | 4 | 4 | 2024-06-19 | 971.98 | 24.30 | 2024-06-07 | 3 | 343.65 | 1 | 971.98 | 12 | SO67292 | 2024-06-14 | 77.76 | 1030.95 | 323.99 | |||
SO67289_56 | 5B09-42E8-A1 | PO10324110444 | 98 | 288 | 222 | 196 | 10 | 2024-06-19 | 125.96 | 3.15 | 2024-06-07 | 6 | 13.09 | 1 | 125.96 | 56 | SO67289 | 2024-06-14 | 10.08 | 78.52 | 20.99 | |||
SO63280_28 | C73E-4203-80 | PO3654118854 | 100 | 281 | 517 | 435 | 4 | 2024-04-20 | 31.58 | 0.79 | 2024-04-08 | 1 | 23.37 | 1 | 31.58 | 28 | SO63280 | 2024-04-15 | 2.53 | 23.37 | 31.58 | |||
SO51786_3 | CB32-4179-97 | PO18357130739 | 19 | 272 | 576 | 138 | 6 | 2023-10-19 | 4291.33 | 107.28 | 2023-10-07 | 3 | 1481.94 | 1 | 4291.33 | 3 | SO51786 | 2023-10-14 | 343.31 | 4445.81 | 1430.44 | |||
SO44120_10 | E001-437D-A1 | PO5597155510 | 100 | 283 | 304 | 75 | 4 | 2021-11-19 | 2144.11 | 53.60 | 2021-11-07 | 3 | 617.03 | 1 | 2144.11 | 10 | SO44120 | 2021-11-14 | 171.53 | 1851.08 | 714.70 | |||
SO58950_14 | E67E-435E-9F | PO11455199372 | 100 | 283 | 243 | 72 | 2 | 2024-02-18 | 1717.80 | 42.95 | 2024-02-06 | 2 | 868.63 | 1 | 1717.80 | 14 | SO58950 | 2024-02-13 | 137.42 | 1737.27 | 858.90 | |||
SO67276_2 | 9FD9-4B05-AA | PO13340158801 | 100 | 292 | 484 | 355 | 7 | 2024-06-19 | 19.08 | 0.48 | 2024-06-07 | 4 | 2.97 | 1 | 19.08 | 2 | SO67276 | 2024-06-14 | 1.53 | 11.89 | 4.77 | |||
SO69461_35 | F8C1-4A85-91 | PO1508119064 | 98 | 288 | 484 | 430 | 10 | 2024-07-19 | 47.70 | 1.19 | 2024-07-07 | 10 | 2.97 | 1 | 47.70 | 35 | SO69461 | 2024-07-14 | 3.82 | 29.73 | 4.77 | |||
SO53559_1 | AB95-4CCE-9C | PO13195185360 | 100 | 292 | 569 | 13 | 553 | 7 | 50.11 | 2023-11-19 | 334.06 | 7.10 | 2023-11-07 | 1 | 461.44 | 1 | 283.95 | 1 | SO53559 | 2023-11-14 | 22.72 | 461.44 | 334.06 | 0.15 |
SO65158_32 | 3613-4FA2-B8 | PO19285194632 | 98 | 288 | 225 | 448 | 10 | 2024-05-19 | 37.76 | 0.94 | 2024-05-07 | 7 | 6.92 | 1 | 37.76 | 32 | SO65158 | 2024-05-14 | 3.02 | 48.46 | 5.39 | |||
SO44282_6 | 57B6-44F8-98 | PO18473177808 | 19 | 288 | 229 | 442 | 6 | 2021-12-19 | 86.52 | 2.16 | 2021-12-07 | 3 | 31.72 | 1 | 86.52 | 6 | SO44282 | 2021-12-14 | 6.92 | 95.17 | 28.84 | |||
SO61189_23 | 1A25-4A8C-8B | PO12412183085 | 100 | 281 | 382 | 670 | 3 | 2024-03-20 | 2016.88 | 50.42 | 2024-03-08 | 3 | 713.08 | 1 | 2016.88 | 23 | SO61189 | 2024-03-15 | 161.35 | 2139.24 | 672.29 | |||
SO51845_23 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 551 | 312 | 4 | 2023-10-19 | 158.43 | 3.96 | 2023-10-07 | 1 | 144.59 | 1 | 158.43 | 23 | SO51845 | 2023-10-14 | 12.67 | 144.59 | 158.43 | |||
SO63252_35 | 4233-41A9-B7 | PO6438150148 | 100 | 281 | 222 | 309 | 4 | 2024-04-20 | 104.97 | 2.62 | 2024-04-08 | 5 | 13.09 | 1 | 104.97 | 35 | SO63252 | 2024-04-15 | 8.40 | 65.43 | 20.99 | |||
SO69561_2 | BBC0-4CA4-A2 | PO8845186382 | 100 | 282 | 231 | 546 | 3 | 2024-07-19 | 89.98 | 2.25 | 2024-07-07 | 3 | 38.49 | 1 | 89.98 | 2 | SO69561 | 2024-07-14 | 7.20 | 115.48 | 29.99 | |||
SO49828_27 | 8223-49DF-83 | PO14732189078 | 19 | 291 | 239 | 514 | 6 | 2023-06-19 | 3123.27 | 78.08 | 2023-06-07 | 4 | 722.26 | 1 | 3123.27 | 27 | SO49828 | 2023-06-14 | 249.86 | 2889.03 | 780.82 | |||
SO53621_43 | 9324-4A3D-83 | PO9715186811 | 100 | 281 | 516 | 490 | 4 | 2023-11-19 | 234.84 | 5.87 | 2023-11-07 | 10 | 17.38 | 1 | 234.84 | 43 | SO53621 | 2023-11-14 | 18.79 | 173.78 | 23.48 | |||
SO51768_1 | 7D1E-40EB-9E | PO1218111298 | 98 | 288 | 404 | 412 | 10 | 2023-10-19 | 26.72 | 0.67 | 2023-10-07 | 1 | 19.78 | 1 | 26.72 | 1 | SO51768 | 2023-10-14 | 2.14 | 19.78 | 26.72 | |||
SO53455_13 | ACD7-4AF3-84 | PO19604185529 | 98 | 288 | 543 | 340 | 10 | 2023-11-19 | 111.76 | 2.79 | 2023-11-07 | 3 | 27.57 | 1 | 111.76 | 13 | SO53455 | 2023-11-14 | 8.94 | 82.70 | 37.25 | |||
SO44127_3 | E778-471D-8A | PO7569162058 | 100 | 287 | 293 | 608 | 4 | 2021-11-19 | 4335.57 | 108.39 | 2021-11-07 | 6 | 623.84 | 1 | 4335.57 | 3 | SO44127 | 2021-11-14 | 346.85 | 3743.04 | 722.59 | |||
SO49485_21 | 9EA5-4DEF-B8 | PO17545171443 | 19 | 291 | 377 | 155 | 6 | 2023-05-19 | 9162.56 | 229.06 | 2023-05-07 | 7 | 1320.68 | 1 | 9162.56 | 21 | SO49485 | 2023-05-14 | 733.01 | 9244.79 | 1308.94 | |||
SO50297_16 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 271 | 343 | 1 | 2023-07-19 | 809.33 | 20.23 | 2023-07-07 | 4 | 187.16 | 1 | 809.33 | 16 | SO50297 | 2023-07-14 | 64.75 | 748.63 | 202.33 | |||
SO48386_6 | 7AB1-4817-8F | PO8468170337 | 98 | 288 | 453 | 16 | 10 | 2023-02-18 | 107.98 | 2.70 | 2023-02-06 | 3 | 24.75 | 1 | 107.98 | 6 | SO48386 | 2023-02-13 | 8.64 | 74.24 | 35.99 | |||
SO51084_4 | 3C77-43D1-83 | PO19575195218 | 98 | 288 | 559 | 34 | 10 | 2023-09-18 | 60.72 | 1.52 | 2023-09-06 | 5 | 8.99 | 1 | 60.72 | 4 | SO51084 | 2023-09-13 | 4.86 | 44.93 | 12.14 | |||
SO47988_19 | 3979-4615-A9 | PO16733190266 | 19 | 291 | 325 | 533 | 6 | 2023-01-19 | 1879.18 | 46.98 | 2023-01-07 | 4 | 486.71 | 1 | 1879.18 | 19 | SO47988 | 2023-01-14 | 150.33 | 1946.83 | 469.79 | |||
SO47400_5 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 391 | 133 | 4 | 2022-11-19 | 533.59 | 13.34 | 2022-11-07 | 6 | 65.81 | 1 | 533.59 | 5 | SO47400 | 2022-11-14 | 42.69 | 394.86 | 88.93 | |||
SO50222_19 | 4FDE-4C03-A9 | PO13427181046 | 100 | 292 | 422 | 638 | 7 | 2023-07-19 | 270.16 | 6.75 | 2023-07-07 | 4 | 49.98 | 1 | 270.16 | 19 | SO50222 | 2023-07-14 | 21.61 | 199.92 | 67.54 | |||
SO59071_11 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 580 | 170 | 5 | 2024-02-18 | 1020.59 | 25.51 | 2024-02-06 | 1 | 1082.51 | 1 | 1020.59 | 11 | SO59071 | 2024-02-13 | 81.65 | 1082.51 | 1020.59 | |||
SO61193_20 | DFEB-4C0D-88 | PO551160749 | 100 | 281 | 482 | 2 | 4 | 4 | 1.25 | 2024-03-20 | 62.57 | 1.53 | 2024-03-08 | 12 | 3.36 | 1 | 61.32 | 20 | SO61193 | 2024-03-15 | 4.91 | 40.35 | 5.21 | 0.02 |
SO50703_27 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 333 | 90 | 5 | 2023-08-19 | 2348.97 | 58.72 | 2023-08-07 | 5 | 486.71 | 1 | 2348.97 | 27 | SO50703 | 2023-08-14 | 187.92 | 2433.53 | 469.79 | |||
SO44509_13 | FAD7-4A4C-B0 | PO15689158248 | 100 | 283 | 336 | 328 | 4 | 2022-01-19 | 419.46 | 10.49 | 2022-01-07 | 1 | 413.15 | 1 | 419.46 | 13 | SO44509 | 2022-01-14 | 33.56 | 413.15 | 419.46 | |||
SO63181_8 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 482 | 700 | 5 | 2024-04-20 | 26.97 | 0.67 | 2024-04-08 | 5 | 3.36 | 1 | 26.97 | 8 | SO63181 | 2024-04-15 | 2.16 | 16.81 | 5.39 | |||
SO57138_1 | CD80-4144-8A | PO5684168325 | 100 | 282 | 359 | 385 | 4 | 2024-01-19 | 8261.96 | 206.55 | 2024-01-07 | 6 | 1251.98 | 1 | 8261.96 | 1 | SO57138 | 2024-01-14 | 660.96 | 7511.89 | 1376.99 | |||
SO69422_51 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 237 | 650 | 1 | 2024-07-19 | 179.96 | 4.50 | 2024-07-07 | 6 | 38.49 | 1 | 179.96 | 51 | SO69422 | 2024-07-14 | 14.40 | 230.95 | 29.99 | |||
SO45343_11 | 9A71-4101-BA | PO8874137222 | 100 | 282 | 304 | 348 | 3 | 2022-04-21 | 714.70 | 17.87 | 2022-04-09 | 1 | 617.03 | 1 | 714.70 | 11 | SO45343 | 2022-04-16 | 57.18 | 617.03 | 714.70 | |||
SO46654_11 | 2FEC-47CC-84 | PO3741124832 | 100 | 285 | 343 | 404 | 5 | 2022-09-18 | 1409.38 | 35.23 | 2022-09-06 | 3 | 486.71 | 1 | 1409.38 | 11 | SO46654 | 2022-09-13 | 112.75 | 1460.12 | 469.79 | |||
SO50722_31 | 126E-410B-A5 | PO8468186428 | 98 | 290 | 373 | 16 | 10 | 2023-08-19 | 2617.88 | 65.45 | 2023-08-07 | 2 | 1320.68 | 1 | 2617.88 | 31 | SO50722 | 2023-08-14 | 209.43 | 2641.37 | 1308.94 | |||
SO48339_33 | EAB2-42EA-9C | PO10614150674 | 19 | 291 | 385 | 461 | 6 | 2023-02-18 | 1200.53 | 30.01 | 2023-02-06 | 2 | 605.65 | 1 | 1200.53 | 33 | SO48339 | 2023-02-13 | 96.04 | 1211.30 | 600.26 | |||
SO57086_11 | 9159-4FEC-A8 | PO2668146833 | 100 | 292 | 471 | 535 | 7 | 2024-01-19 | 228.60 | 5.72 | 2024-01-07 | 6 | 23.75 | 1 | 228.60 | 11 | SO57086 | 2024-01-14 | 18.29 | 142.49 | 38.10 | |||
SO51791_36 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 217 | 552 | 6 | 2023-10-19 | 146.96 | 3.67 | 2023-10-07 | 7 | 13.09 | 1 | 146.96 | 36 | SO51791 | 2023-10-14 | 11.76 | 91.60 | 20.99 | |||
SO65182_2 | 130D-4FE9-83 | PO16385138124 | 6 | 296 | 560 | 249 | 9 | 2024-05-19 | 728.91 | 18.22 | 2024-05-07 | 1 | 755.15 | 1 | 728.91 | 2 | SO65182 | 2024-05-14 | 58.31 | 755.15 | 728.91 |
Generated 2024-10-06 16:22:54.341 UTC