[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 1031 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50674_1 | 0316-488D-80 | PO14906132898 | 19 | 291 | 236 | 424 | 6 | 2023-09-22 | 115.36 | 2.88 | 2023-09-10 | 4 | 29.08 | 1 | 115.36 | 1 | SO50674 | 2023-09-17 | 9.23 | 116.32 | 28.84 | |||
SO51691_17 | 8F72-4342-A4 | PO19923122474 | 100 | 283 | 295 | 18 | 3 | 2023-11-22 | 818.70 | 20.47 | 2023-11-10 | 1 | 747.20 | 1 | 818.70 | 17 | SO51691 | 2023-11-17 | 65.50 | 747.20 | 818.70 | |||
SO51131_23 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 499 | 3 | 599 | 4 | 634.97 | 2023-10-22 | 12699.46 | 301.61 | 2023-10-10 | 23 | 601.74 | 1 | 12064.49 | 23 | SO51131 | 2023-10-17 | 965.16 | 13840.11 | 552.15 | 0.05 |
SO71791_10 | AB1B-4CE2-BA | PO17139191080 | 100 | 293 | 440 | 644 | 1 | 2024-09-22 | 2576.70 | 64.42 | 2024-09-10 | 3 | 868.63 | 1 | 2576.70 | 10 | SO71791 | 2024-09-17 | 206.14 | 2605.90 | 858.90 | |||
SO44797_20 | 4297-4DF9-A8 | PO9483142524 | 100 | 281 | 314 | 54 | 2 | 2022-03-24 | 8587.85 | 214.70 | 2022-03-12 | 4 | 2171.29 | 1 | 8587.85 | 20 | SO44797 | 2022-03-19 | 687.03 | 8685.18 | 2146.96 | |||
SO50297_51 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 265 | 343 | 1 | 2023-08-22 | 404.66 | 10.12 | 2023-08-10 | 2 | 187.16 | 1 | 404.66 | 51 | SO50297 | 2023-08-17 | 32.37 | 374.31 | 202.33 | |||
SO51858_28 | 3089-4603-B3 | PO3567120722 | 100 | 292 | 500 | 193 | 7 | 2023-11-22 | 1204.69 | 30.12 | 2023-11-10 | 2 | 601.74 | 1 | 1204.69 | 28 | SO51858 | 2023-11-17 | 96.38 | 1203.49 | 602.35 | |||
SO44799_4 | 2146-417A-8D | PO9106161251 | 100 | 285 | 351 | 602 | 5 | 2022-03-24 | 4049.99 | 101.25 | 2022-03-12 | 2 | 1898.09 | 1 | 4049.99 | 4 | SO44799 | 2022-03-19 | 324.00 | 3796.19 | 2024.99 | |||
SO63214_8 | 5C93-4C23-8D | PO11368112676 | 36 | 295 | 559 | 687 | 8 | 2024-05-24 | 12.14 | 0.30 | 2024-05-12 | 1 | 8.99 | 1 | 12.14 | 8 | SO63214 | 2024-05-19 | 0.97 | 8.99 | 12.14 | |||
SO47403_8 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 453 | 254 | 1 | 2022-12-23 | 143.98 | 3.60 | 2022-12-11 | 4 | 24.75 | 1 | 143.98 | 8 | SO47403 | 2022-12-18 | 11.52 | 98.98 | 35.99 | |||
SO49484_11 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 396 | 118 | 6 | 2023-06-22 | 149.68 | 3.74 | 2023-06-10 | 2 | 55.38 | 1 | 149.68 | 11 | SO49484 | 2023-06-17 | 11.97 | 110.76 | 74.84 | |||
SO61229_18 | AC88-46DA-A3 | PO10324197030 | 98 | 288 | 517 | 196 | 10 | 2024-04-23 | 31.58 | 0.79 | 2024-04-11 | 1 | 23.37 | 1 | 31.58 | 18 | SO61229 | 2024-04-18 | 2.53 | 23.37 | 31.58 | |||
SO65236_20 | 46EF-4D44-A9 | PO9483140017 | 100 | 283 | 465 | 54 | 2 | 2024-06-22 | 88.16 | 2.20 | 2024-06-10 | 6 | 9.16 | 1 | 88.16 | 20 | SO65236 | 2024-06-17 | 7.05 | 54.96 | 14.69 | |||
SO71806_29 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 353 | 497 | 6 | 2024-09-22 | 2783.99 | 69.60 | 2024-09-10 | 2 | 1265.62 | 1 | 2783.99 | 29 | SO71806 | 2024-09-17 | 222.72 | 2531.24 | 1391.99 | |||
SO58991_3 | D7E6-4630-81 | PO16530115443 | 100 | 282 | 565 | 601 | 1 | 2024-03-23 | 890.82 | 22.27 | 2024-03-11 | 2 | 461.44 | 1 | 890.82 | 3 | SO58991 | 2024-03-18 | 71.27 | 922.89 | 445.41 | |||
SO50280_27 | 7938-4E14-A7 | PO11658187917 | 100 | 283 | 410 | 233 | 2 | 2023-08-22 | 72.89 | 1.82 | 2023-08-10 | 2 | 26.97 | 1 | 72.89 | 27 | SO50280 | 2023-08-17 | 5.83 | 53.94 | 36.45 | |||
SO65206_22 | 6CD1-4BEC-A0 | PO1798192797 | 19 | 291 | 592 | 10 | 6 | 2024-06-22 | 2372.96 | 59.32 | 2024-06-10 | 7 | 308.22 | 1 | 2372.96 | 22 | SO65206 | 2024-06-17 | 189.84 | 2157.53 | 338.99 | |||
SO49464_1 | C383-45FE-83 | PO841195010 | 100 | 286 | 366 | 254 | 1 | 2023-06-22 | 647.99 | 16.20 | 2023-06-10 | 1 | 598.44 | 1 | 647.99 | 1 | SO49464 | 2023-06-17 | 51.84 | 598.44 | 647.99 | |||
SO57056_5 | EE54-4BF3-BD | PO12731191306 | 36 | 290 | 476 | 247 | 7 | 2024-02-22 | 335.95 | 8.40 | 2024-02-10 | 8 | 26.18 | 1 | 335.95 | 5 | SO57056 | 2024-02-17 | 26.88 | 209.41 | 41.99 | |||
SO71832_22 | 269D-4F59-82 | PO10353140756 | 98 | 288 | 353 | 88 | 10 | 2024-09-22 | 1391.99 | 34.80 | 2024-09-10 | 1 | 1265.62 | 1 | 1391.99 | 22 | SO71832 | 2024-09-17 | 111.36 | 1265.62 | 1391.99 | |||
SO67333_23 | B219-43D3-AA | PO4524133435 | 36 | 295 | 547 | 482 | 8 | 2024-07-23 | 97.19 | 2.43 | 2024-07-11 | 2 | 35.96 | 1 | 97.19 | 23 | SO67333 | 2024-07-18 | 7.78 | 71.92 | 48.59 | |||
SO71794_12 | C39A-4835-99 | PO17574111985 | 19 | 291 | 559 | 678 | 6 | 2024-09-22 | 24.29 | 0.61 | 2024-09-10 | 2 | 8.99 | 1 | 24.29 | 12 | SO71794 | 2024-09-17 | 1.94 | 17.97 | 12.14 | |||
SO48374_1 | 6271-4D04-BE | PO5510147369 | 100 | 287 | 422 | 5 | 4 | 2023-03-24 | 135.08 | 3.38 | 2023-03-12 | 2 | 49.98 | 1 | 135.08 | 1 | SO48374 | 2023-03-19 | 10.81 | 99.96 | 67.54 | |||
SO48769_6 | A39E-4380-A6 | PO7859190388 | 100 | 287 | 343 | 221 | 4 | 2023-04-24 | 1879.18 | 46.98 | 2023-04-12 | 4 | 486.71 | 1 | 1879.18 | 6 | SO48769 | 2023-04-19 | 150.33 | 1946.83 | 469.79 | |||
SO49084_8 | 438B-42C5-B0 | PO18183187957 | 100 | 283 | 352 | 667 | 2 | 2023-05-25 | 4971.41 | 124.29 | 2023-05-13 | 4 | 1117.86 | 1 | 4971.41 | 8 | SO49084 | 2023-05-20 | 397.71 | 4471.42 | 1242.85 | |||
SO61204_3 | E810-4164-82 | PO15312134209 | 19 | 291 | 390 | 299 | 6 | 2024-04-23 | 1344.59 | 33.61 | 2024-04-11 | 2 | 713.08 | 1 | 1344.59 | 3 | SO61204 | 2024-04-18 | 107.57 | 1426.16 | 672.29 | |||
SO44078_1 | 6487-4A93-82 | PO19169159771 | 100 | 289 | 293 | 272 | 1 | 2021-12-23 | 722.59 | 18.06 | 2021-12-11 | 1 | 623.84 | 1 | 722.59 | 1 | SO44078 | 2021-12-18 | 57.81 | 623.84 | 722.59 | |||
SO48017_34 | 40DA-4972-BB | PO11658177389 | 100 | 281 | 358 | 233 | 2 | 2023-02-22 | 3688.38 | 92.21 | 2023-02-10 | 3 | 1105.81 | 1 | 3688.38 | 34 | SO48017 | 2023-02-17 | 295.07 | 3317.43 | 1229.46 | |||
SO43671_1 | DFD9-41B7-94 | PO13978119376 | 100 | 289 | 314 | 200 | 1 | 2021-10-22 | 2146.96 | 53.67 | 2021-10-10 | 1 | 2171.29 | 1 | 2146.96 | 1 | SO43671 | 2021-10-17 | 171.76 | 2171.29 | 2146.96 | |||
SO49479_39 | 12BA-4BD1-BB | PO11455112131 | 100 | 283 | 435 | 72 | 2 | 2023-06-22 | 648.91 | 16.22 | 2023-06-10 | 2 | 300.12 | 1 | 648.91 | 39 | SO49479 | 2023-06-17 | 51.91 | 600.24 | 324.45 | |||
SO49118_32 | 532A-4BAE-8C | PO13427116278 | 100 | 292 | 368 | 638 | 7 | 2023-05-25 | 8796.06 | 219.90 | 2023-05-13 | 6 | 1518.79 | 1 | 8796.06 | 32 | SO49118 | 2023-05-20 | 703.68 | 9112.72 | 1466.01 | |||
SO46964_40 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 403 | 328 | 4 | 2022-11-22 | 97.18 | 2.43 | 2022-11-10 | 4 | 17.98 | 1 | 97.18 | 40 | SO46964 | 2022-11-17 | 7.77 | 71.91 | 24.29 | |||
SO45797_5 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 330 | 679 | 6 | 2022-07-23 | 419.46 | 10.49 | 2022-07-11 | 1 | 413.15 | 1 | 419.46 | 5 | SO45797 | 2022-07-18 | 33.56 | 413.15 | 419.46 | |||
SO47999_7 | DF06-4F6A-9D | PO14500121568 | 100 | 282 | 308 | 650 | 1 | 2023-02-22 | 744.27 | 18.61 | 2023-02-10 | 1 | 660.91 | 1 | 744.27 | 7 | SO47999 | 2023-02-17 | 59.54 | 660.91 | 744.27 | |||
SO51763_2 | CDB1-4311-8D | PO957124084 | 98 | 288 | 599 | 376 | 10 | 2023-11-22 | 323.99 | 8.10 | 2023-11-10 | 1 | 294.58 | 1 | 323.99 | 2 | SO51763 | 2023-11-17 | 25.92 | 294.58 | 323.99 | |||
SO51822_60 | EEEE-45C1-87 | PO8845178563 | 100 | 282 | 517 | 546 | 3 | 2023-11-22 | 126.34 | 3.16 | 2023-11-10 | 4 | 23.37 | 1 | 126.34 | 60 | SO51822 | 2023-11-17 | 10.11 | 93.49 | 31.58 | |||
SO49893_37 | 99ED-4EEC-9C | PO8787173621 | 100 | 282 | 263 | 523 | 3 | 2023-07-23 | 404.66 | 10.12 | 2023-07-11 | 2 | 187.16 | 1 | 404.66 | 37 | SO49893 | 2023-07-18 | 32.37 | 374.31 | 202.33 | |||
SO71933_27 | 11D0-4CAD-81 | PO8033133106 | 6 | 296 | 551 | 15 | 9 | 2024-09-22 | 316.86 | 7.92 | 2024-09-10 | 2 | 144.59 | 1 | 316.86 | 27 | SO71933 | 2024-09-17 | 25.35 | 289.19 | 158.43 | |||
SO48032_6 | 6326-4EBF-93 | PO1218188435 | 98 | 288 | 414 | 412 | 10 | 2023-02-22 | 149.03 | 3.73 | 2023-02-10 | 1 | 110.28 | 1 | 149.03 | 6 | SO48032 | 2023-02-17 | 11.92 | 110.28 | 149.03 | |||
SO71847_18 | 3A74-467E-8B | PO18502143784 | 19 | 291 | 569 | 154 | 6 | 2024-09-22 | 3563.28 | 89.08 | 2024-09-10 | 8 | 461.44 | 1 | 3563.28 | 18 | SO71847 | 2024-09-17 | 285.06 | 3691.56 | 445.41 | |||
SO48378_6 | 2FD7-4721-9D | PO6786131738 | 100 | 283 | 464 | 3 | 4 | 2023-03-24 | 28.26 | 0.71 | 2023-03-12 | 2 | 9.71 | 1 | 28.26 | 6 | SO48378 | 2023-03-19 | 2.26 | 19.43 | 14.13 | |||
SO44309_16 | F0DB-4889-AC | PO3393112350 | 100 | 285 | 324 | 549 | 5 | 2022-01-22 | 419.46 | 10.49 | 2022-01-10 | 1 | 413.15 | 1 | 419.46 | 16 | SO44309 | 2022-01-17 | 33.56 | 413.15 | 419.46 | |||
SO51126_9 | 7A9E-43B4-B3 | PO2755153471 | 100 | 282 | 507 | 205 | 4 | 2023-10-22 | 800.21 | 20.01 | 2023-10-10 | 4 | 199.85 | 1 | 800.21 | 9 | SO51126 | 2023-10-17 | 64.02 | 799.41 | 200.05 | |||
SO46996_16 | 775B-42D6-A5 | PO11571149031 | 100 | 285 | 439 | 512 | 5 | 2022-11-22 | 1561.64 | 39.04 | 2022-11-10 | 2 | 722.26 | 1 | 1561.64 | 16 | SO46996 | 2022-11-17 | 124.93 | 1444.51 | 780.82 | |||
SO43688_11 | 16F4-456B-9A | PO5365136389 | 100 | 281 | 314 | 161 | 2 | 2021-10-22 | 4293.92 | 107.35 | 2021-10-10 | 2 | 2171.29 | 1 | 4293.92 | 11 | SO43688 | 2021-10-17 | 343.51 | 4342.59 | 2146.96 | |||
SO43671_7 | DFD9-41B7-94 | PO13978119376 | 100 | 289 | 316 | 200 | 1 | 2021-10-22 | 1749.59 | 43.74 | 2021-10-10 | 2 | 884.71 | 1 | 1749.59 | 7 | SO43671 | 2021-10-17 | 139.97 | 1769.42 | 874.79 | |||
SO46608_20 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 233 | 442 | 6 | 2022-10-22 | 173.04 | 4.33 | 2022-10-10 | 6 | 29.08 | 1 | 173.04 | 20 | SO46608 | 2022-10-17 | 13.84 | 174.48 | 28.84 | |||
SO48051_9 | D18B-421F-99 | PO3596190178 | 100 | 285 | 421 | 476 | 5 | 2023-02-22 | 392.66 | 9.82 | 2023-02-10 | 2 | 145.28 | 1 | 392.66 | 9 | SO48051 | 2023-02-17 | 31.41 | 290.57 | 196.33 | |||
SO61230_6 | B9F1-4FF8-B4 | PO12644163346 | 100 | 285 | 217 | 530 | 5 | 2024-04-23 | 62.98 | 1.57 | 2024-04-11 | 3 | 13.09 | 1 | 62.98 | 6 | SO61230 | 2024-04-18 | 5.04 | 39.26 | 20.99 | |||
SO49125_6 | D58B-4B43-AA | PO3654156335 | 100 | 281 | 356 | 435 | 4 | 2023-05-25 | 2485.70 | 62.14 | 2023-05-13 | 2 | 1117.86 | 1 | 2485.70 | 6 | SO49125 | 2023-05-20 | 198.86 | 2235.71 | 1242.85 | |||
SO46036_8 | DBE7-4B0A-93 | PO18386134137 | 100 | 281 | 336 | 558 | 2 | 2022-08-22 | 419.46 | 10.49 | 2022-08-10 | 1 | 413.15 | 1 | 419.46 | 8 | SO46036 | 2022-08-17 | 33.56 | 413.15 | 419.46 | |||
SO44744_25 | 6D80-4E9D-83 | PO19401124443 | 19 | 288 | 317 | 173 | 6 | 2022-03-24 | 874.79 | 21.87 | 2022-03-12 | 1 | 884.71 | 1 | 874.79 | 25 | SO44744 | 2022-03-19 | 69.98 | 884.71 | 874.79 | |||
SO65269_23 | 999D-45C9-AA | PO4640162431 | 100 | 287 | 597 | 648 | 4 | 2024-06-22 | 971.98 | 24.30 | 2024-06-10 | 3 | 294.58 | 1 | 971.98 | 23 | SO65269 | 2024-06-17 | 77.76 | 883.74 | 323.99 | |||
SO53514_36 | 8580-40F8-81 | PO10411179199 | 100 | 289 | 499 | 182 | 1 | 2023-12-23 | 3614.08 | 90.35 | 2023-12-11 | 6 | 601.74 | 1 | 3614.08 | 36 | SO53514 | 2023-12-18 | 289.13 | 3610.46 | 602.35 | |||
SO58956_19 | 36A4-4154-AB | PO11194174095 | 19 | 284 | 579 | 48 | 6 | 2024-03-23 | 2186.73 | 54.67 | 2024-03-11 | 3 | 755.15 | 1 | 2186.73 | 19 | SO58956 | 2024-03-18 | 174.94 | 2265.45 | 728.91 | |||
SO47402_4 | 1B50-4114-8C | PO10295132665 | 98 | 288 | 420 | 322 | 10 | 2022-12-23 | 141.62 | 3.54 | 2022-12-11 | 1 | 104.80 | 1 | 141.62 | 4 | SO47402 | 2022-12-18 | 11.33 | 104.80 | 141.62 | |||
SO63280_11 | C73E-4203-80 | PO3654118854 | 100 | 281 | 559 | 435 | 4 | 2024-05-24 | 12.14 | 0.30 | 2024-05-12 | 1 | 8.99 | 1 | 12.14 | 11 | SO63280 | 2024-05-19 | 0.97 | 8.99 | 12.14 | |||
SO59012_2 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 487 | 539 | 2 | 2024-03-23 | 164.97 | 4.12 | 2024-03-11 | 5 | 20.57 | 1 | 164.97 | 2 | SO59012 | 2024-03-18 | 13.20 | 102.83 | 32.99 | |||
SO47065_33 | D00A-426C-9B | PO8845147622 | 100 | 282 | 401 | 546 | 3 | 2022-11-22 | 131.20 | 3.28 | 2022-11-10 | 2 | 48.55 | 1 | 131.20 | 33 | SO47065 | 2022-11-17 | 10.50 | 97.09 | 65.60 | |||
SO46609_1 | 87E3-4F5C-AC | PO17458117152 | 100 | 286 | 242 | 577 | 1 | 2022-10-22 | 1561.64 | 39.04 | 2022-10-10 | 2 | 722.26 | 1 | 1561.64 | 1 | SO46609 | 2022-10-17 | 124.93 | 1444.51 | 780.82 | |||
SO50210_18 | 6347-4C03-9B | PO15631112842 | 100 | 282 | 447 | 43 | 1 | 2023-08-22 | 30.00 | 0.75 | 2023-08-10 | 2 | 10.31 | 1 | 30.00 | 18 | SO50210 | 2023-08-17 | 2.40 | 20.63 | 15.00 | |||
SO51739_24 | AF60-4F2F-9B | PO12702124697 | 100 | 292 | 476 | 175 | 7 | 2023-11-22 | 251.96 | 6.30 | 2023-11-10 | 6 | 26.18 | 1 | 251.96 | 24 | SO51739 | 2023-11-17 | 20.16 | 157.06 | 41.99 |
Generated 2024-11-10 02:39:51.296 UTC