[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 1508 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57085_32 | D1E5-454C-85 | PO2523188219 | 100 | 287 | 376 | 167 | 4 | 2024-01-04 | 1466.01 | 36.65 | 2023-12-23 | 1 | 1554.95 | 1 | 1466.01 | 32 | SO57085 | 2023-12-30 | 117.28 | 1554.95 | 1466.01 | |||
SO58919_7 | AF42-4FCB-BB | PO17052190887 | 100 | 282 | 498 | 420 | 4 | 2024-02-03 | 602.35 | 15.06 | 2024-01-22 | 1 | 601.74 | 1 | 602.35 | 7 | SO58919 | 2024-01-29 | 48.19 | 601.74 | 602.35 | |||
SO65315_2 | 0FFB-4EB5-A3 | PO6757194680 | 100 | 281 | 556 | 21 | 4 | 2024-05-04 | 210.59 | 5.26 | 2024-04-22 | 2 | 77.92 | 1 | 210.59 | 2 | SO65315 | 2024-04-29 | 16.85 | 155.84 | 105.29 | |||
SO71858_14 | 32BA-49C8-8B | PO16153112278 | 100 | 282 | 576 | 186 | 4 | 2024-08-04 | 1430.44 | 35.76 | 2024-07-23 | 1 | 1481.94 | 1 | 1430.44 | 14 | SO71858 | 2024-07-30 | 114.44 | 1481.94 | 1430.44 | |||
SO46660_4 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 339 | 166 | 4 | 2022-09-03 | 3758.35 | 93.96 | 2022-08-22 | 8 | 486.71 | 1 | 3758.35 | 4 | SO46660 | 2022-08-29 | 300.67 | 3893.65 | 469.79 | |||
SO55251_24 | 2481-4FF1-80 | PO13659159365 | 100 | 287 | 474 | 2 | 437 | 4 | 10.55 | 2023-12-04 | 527.72 | 12.93 | 2023-11-22 | 13 | 26.18 | 1 | 517.17 | 24 | SO55251 | 2023-11-29 | 41.37 | 340.29 | 40.59 | 0.02 |
SO71782_29 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 560 | 582 | 4 | 2024-08-04 | 728.91 | 18.22 | 2024-07-23 | 1 | 755.15 | 1 | 728.91 | 29 | SO71782 | 2024-07-30 | 58.31 | 755.15 | 728.91 | |||
SO48295_17 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 327 | 2 | 24 | 4 | 127.16 | 2023-02-03 | 6357.88 | 155.77 | 2023-01-22 | 14 | 486.71 | 1 | 6230.72 | 17 | SO48295 | 2023-01-29 | 498.46 | 6813.89 | 454.13 | 0.02 |
SO46988_29 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 327 | 9 | 78 | 4 | 916.10 | 2022-10-04 | 3053.66 | 53.44 | 2022-09-22 | 13 | 486.71 | 1 | 2137.56 | 29 | SO46988 | 2022-09-29 | 171.01 | 6327.19 | 234.90 | 0.30 |
SO47369_45 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 456 | 239 | 4 | 2022-11-04 | 359.95 | 9.00 | 2022-10-23 | 8 | 30.93 | 1 | 359.95 | 45 | SO47369 | 2022-10-30 | 28.80 | 247.47 | 44.99 | |||
SO50738_47 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 466 | 130 | 4 | 2023-08-04 | 14.13 | 0.35 | 2023-07-23 | 1 | 9.71 | 1 | 14.13 | 47 | SO50738 | 2023-07-30 | 1.13 | 9.71 | 14.13 | |||
SO69412_33 | 14B1-47FE-BF | PO15689112657 | 100 | 281 | 372 | 328 | 4 | 2024-07-04 | 5864.04 | 146.60 | 2024-06-22 | 4 | 1554.95 | 1 | 5864.04 | 33 | SO69412 | 2024-06-29 | 469.12 | 6219.79 | 1466.01 | |||
SO45301_27 | 0BA8-4928-A7 | PO12499190711 | 100 | 282 | 319 | 78 | 4 | 2022-04-06 | 1749.59 | 43.74 | 2022-03-25 | 2 | 884.71 | 1 | 1749.59 | 27 | SO45301 | 2022-04-01 | 139.97 | 1769.42 | 874.79 | |||
SO49444_2 | 200A-4484-AF | PO261147999 | 100 | 281 | 254 | 647 | 4 | 2023-05-04 | 183.94 | 4.60 | 2023-04-22 | 1 | 170.14 | 1 | 183.94 | 2 | SO49444 | 2023-04-29 | 14.72 | 170.14 | 183.94 | |||
SO55296_1 | 7C52-4939-AE | PO6380144343 | 100 | 281 | 575 | 597 | 4 | 2023-12-04 | 1430.44 | 35.76 | 2023-11-22 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO55296 | 2023-11-29 | 114.44 | 1481.94 | 1430.44 | |||
SO55303_24 | 5C9C-4B35-B8 | PO5626137276 | 100 | 281 | 434 | 166 | 4 | 2023-12-04 | 2855.18 | 71.38 | 2023-11-22 | 8 | 360.94 | 1 | 2855.18 | 24 | SO55303 | 2023-11-29 | 228.41 | 2887.54 | 356.90 | |||
SO69509_16 | 3683-45BF-B7 | PO4611111760 | 100 | 287 | 577 | 131 | 4 | 2024-07-04 | 728.91 | 18.22 | 2024-06-22 | 1 | 755.15 | 1 | 728.91 | 16 | SO69509 | 2024-06-29 | 58.31 | 755.15 | 728.91 | |||
SO47439_26 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 377 | 3 | 4 | 2022-11-04 | 1308.94 | 32.72 | 2022-10-23 | 1 | 1320.68 | 1 | 1308.94 | 26 | SO47439 | 2022-10-30 | 104.72 | 1320.68 | 1308.94 | |||
SO45339_2 | 1F94-40D0-86 | PO7656113434 | 100 | 282 | 330 | 403 | 4 | 2022-04-06 | 419.46 | 10.49 | 2022-03-25 | 1 | 413.15 | 1 | 419.46 | 2 | SO45339 | 2022-04-01 | 33.56 | 413.15 | 419.46 | |||
SO63252_13 | 4233-41A9-B7 | PO6438150148 | 100 | 281 | 593 | 309 | 4 | 2024-04-05 | 677.99 | 16.95 | 2024-03-24 | 2 | 308.22 | 1 | 677.99 | 13 | SO63252 | 2024-03-31 | 54.24 | 616.44 | 338.99 | |||
SO71811_4 | F24F-44FF-A5 | PO13717180066 | 100 | 287 | 436 | 473 | 4 | 2024-08-04 | 713.80 | 17.84 | 2024-07-23 | 2 | 360.94 | 1 | 713.80 | 4 | SO71811 | 2024-07-30 | 57.10 | 721.89 | 356.90 | |||
SO44756_9 | 7857-4221-BA | PO15138192148 | 100 | 283 | 316 | 93 | 4 | 2022-02-03 | 874.79 | 21.87 | 2022-01-22 | 1 | 884.71 | 1 | 874.79 | 9 | SO44756 | 2022-01-29 | 69.98 | 884.71 | 874.79 | |||
SO71858_6 | 32BA-49C8-8B | PO16153112278 | 100 | 282 | 564 | 186 | 4 | 2024-08-04 | 1430.44 | 35.76 | 2024-07-23 | 1 | 1481.94 | 1 | 1430.44 | 6 | SO71858 | 2024-07-30 | 114.44 | 1481.94 | 1430.44 | |||
SO57138_13 | CD80-4144-8A | PO5684168325 | 100 | 282 | 357 | 385 | 4 | 2024-01-04 | 2783.99 | 69.60 | 2023-12-23 | 2 | 1265.62 | 1 | 2783.99 | 13 | SO57138 | 2023-12-30 | 222.72 | 2531.24 | 1391.99 | |||
SO63240_11 | AC0A-4F08-91 | PO4611157476 | 100 | 287 | 603 | 131 | 4 | 2024-04-05 | 218.68 | 5.47 | 2024-03-24 | 3 | 53.94 | 1 | 218.68 | 11 | SO63240 | 2024-03-31 | 17.49 | 161.82 | 72.89 | |||
SO48016_7 | 0FF6-4F4B-B4 | PO11745112366 | 100 | 282 | 335 | 97 | 4 | 2023-01-04 | 2348.97 | 58.72 | 2022-12-23 | 5 | 486.71 | 1 | 2348.97 | 7 | SO48016 | 2022-12-30 | 187.92 | 2433.53 | 469.79 | |||
SO46355_6 | D579-4B15-AB | PO261195016 | 100 | 283 | 324 | 647 | 4 | 2022-08-04 | 2097.29 | 52.43 | 2022-07-23 | 5 | 413.15 | 1 | 2097.29 | 6 | SO46355 | 2022-07-30 | 167.78 | 2065.73 | 419.46 | |||
SO48016_2 | 0FF6-4F4B-B4 | PO11745112366 | 100 | 282 | 339 | 97 | 4 | 2023-01-04 | 1409.38 | 35.23 | 2022-12-23 | 3 | 486.71 | 1 | 1409.38 | 2 | SO48016 | 2022-12-30 | 112.75 | 1460.12 | 469.79 | |||
SO67279_1 | 5395-4C5C-A0 | PO12528190770 | 100 | 282 | 574 | 331 | 4 | 2024-06-04 | 4291.33 | 107.28 | 2024-05-23 | 3 | 1481.94 | 1 | 4291.33 | 1 | SO67279 | 2024-05-30 | 343.31 | 4445.81 | 1430.44 | |||
SO50313_20 | B452-44E9-91 | PO7656143984 | 100 | 282 | 407 | 403 | 4 | 2023-07-04 | 196.81 | 4.92 | 2023-06-22 | 3 | 48.55 | 1 | 196.81 | 20 | SO50313 | 2023-06-29 | 15.74 | 145.64 | 65.60 | |||
SO48370_6 | 2BBA-46FF-BD | PO4640118571 | 100 | 287 | 399 | 648 | 4 | 2023-02-03 | 67.55 | 1.69 | 2023-01-22 | 2 | 24.99 | 1 | 67.55 | 6 | SO48370 | 2023-01-29 | 5.40 | 49.99 | 33.77 | |||
SO45571_5 | BAA6-412D-87 | PO7569141774 | 100 | 287 | 223 | 608 | 4 | 2022-05-04 | 15.56 | 0.39 | 2022-04-22 | 3 | 5.71 | 1 | 15.56 | 5 | SO45571 | 2022-04-29 | 1.24 | 17.12 | 5.19 | |||
SO50226_43 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 377 | 78 | 4 | 2023-07-04 | 5235.75 | 130.89 | 2023-06-22 | 4 | 1320.68 | 1 | 5235.75 | 43 | SO50226 | 2023-06-29 | 418.86 | 5282.74 | 1308.94 | |||
SO46675_5 | 1ED0-48BC-93 | PO10237173444 | 100 | 287 | 213 | 8 | 41 | 4 | 6.73 | 2022-09-03 | 67.29 | 1.51 | 2022-08-22 | 4 | 13.88 | 1 | 60.56 | 5 | SO46675 | 2022-08-29 | 4.84 | 55.51 | 16.82 | 0.10 |
SO46338_15 | 0BAC-4D7E-AD | PO15834128897 | 100 | 283 | 315 | 417 | 4 | 2022-08-04 | 2624.38 | 65.61 | 2022-07-23 | 3 | 884.71 | 1 | 2624.38 | 15 | SO46338 | 2022-07-30 | 209.95 | 2654.12 | 874.79 | |||
SO49058_12 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 433 | 78 | 4 | 2023-04-06 | 324.45 | 8.11 | 2023-03-25 | 1 | 300.12 | 1 | 324.45 | 12 | SO49058 | 2023-04-01 | 25.96 | 300.12 | 324.45 | |||
SO53552_18 | C686-48BD-B0 | PO16182115085 | 100 | 287 | 475 | 23 | 4 | 2023-11-04 | 335.95 | 8.40 | 2023-10-23 | 8 | 26.18 | 1 | 335.95 | 18 | SO53552 | 2023-10-30 | 26.88 | 209.41 | 41.99 | |||
SO49490_16 | 0396-4322-83 | PO19343175441 | 100 | 282 | 458 | 2 | 24 | 4 | 11.31 | 2023-05-04 | 565.42 | 13.85 | 2023-04-22 | 13 | 30.93 | 1 | 554.12 | 16 | SO49490 | 2023-04-29 | 44.33 | 402.13 | 43.49 | 0.02 |
SO46089_10 | 5E3C-4A0D-BD | PO5684142532 | 100 | 282 | 229 | 385 | 4 | 2022-07-04 | 86.52 | 2.16 | 2022-06-22 | 3 | 31.72 | 1 | 86.52 | 10 | SO46089 | 2022-06-29 | 6.92 | 95.17 | 28.84 | |||
SO59023_25 | 9975-4F2A-A7 | PO5539149469 | 100 | 282 | 517 | 61 | 4 | 2024-02-03 | 126.34 | 3.16 | 2024-01-22 | 4 | 23.37 | 1 | 126.34 | 25 | SO59023 | 2024-01-29 | 10.11 | 93.49 | 31.58 | |||
SO50747_38 | A59F-46DA-BE | PO5597196496 | 100 | 281 | 469 | 75 | 4 | 2023-08-04 | 45.59 | 1.14 | 2023-07-23 | 2 | 15.67 | 1 | 45.59 | 38 | SO50747 | 2023-07-30 | 3.65 | 31.34 | 22.79 | |||
SO47994_24 | 284B-45A1-94 | PO15196121630 | 100 | 282 | 325 | 258 | 4 | 2023-01-04 | 469.79 | 11.74 | 2022-12-23 | 1 | 486.71 | 1 | 469.79 | 24 | SO47994 | 2022-12-30 | 37.58 | 486.71 | 469.79 | |||
SO50226_34 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 273 | 78 | 4 | 2023-07-04 | 202.33 | 5.06 | 2023-06-22 | 1 | 187.16 | 1 | 202.33 | 34 | SO50226 | 2023-06-29 | 16.19 | 187.16 | 202.33 | |||
SO69514_7 | 587C-4C47-B9 | PO4553146799 | 100 | 282 | 481 | 313 | 4 | 2024-07-04 | 10.79 | 0.27 | 2024-06-22 | 2 | 3.36 | 1 | 10.79 | 7 | SO69514 | 2024-06-29 | 0.86 | 6.72 | 5.39 | |||
SO50663_52 | 286E-4915-89 | PO19343130555 | 100 | 282 | 230 | 2 | 24 | 4 | 6.13 | 2023-08-04 | 306.67 | 7.51 | 2023-07-23 | 11 | 29.08 | 1 | 300.54 | 52 | SO50663 | 2023-07-30 | 24.04 | 319.89 | 27.88 | 0.02 |
SO49884_20 | 822A-428D-94 | PO5626129805 | 100 | 281 | 415 | 166 | 4 | 2023-06-04 | 594.11 | 14.85 | 2023-05-23 | 3 | 146.55 | 1 | 594.11 | 20 | SO49884 | 2023-05-30 | 47.53 | 439.64 | 198.04 | |||
SO67273_57 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 467 | 475 | 4 | 2024-06-04 | 58.78 | 1.47 | 2024-05-23 | 4 | 9.16 | 1 | 58.78 | 57 | SO67273 | 2024-05-30 | 4.70 | 36.64 | 14.69 | |||
SO49890_43 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 466 | 221 | 4 | 2023-06-04 | 56.52 | 1.41 | 2023-05-23 | 4 | 9.71 | 1 | 56.52 | 43 | SO49890 | 2023-05-30 | 4.52 | 38.85 | 14.13 | |||
SO50748_16 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 417 | 3 | 4 | 2023-08-04 | 1297.81 | 32.45 | 2023-07-23 | 4 | 300.12 | 1 | 1297.81 | 16 | SO50748 | 2023-07-30 | 103.82 | 1200.48 | 324.45 | |||
SO46347_4 | 33F9-487C-A3 | PO13717117301 | 100 | 287 | 272 | 473 | 4 | 2022-08-04 | 183.94 | 4.60 | 2022-07-23 | 1 | 181.49 | 1 | 183.94 | 4 | SO46347 | 2022-07-30 | 14.72 | 181.49 | 183.94 | |||
SO47990_27 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 433 | 328 | 4 | 2023-01-04 | 2595.62 | 64.89 | 2022-12-23 | 8 | 300.12 | 1 | 2595.62 | 27 | SO47990 | 2022-12-30 | 207.65 | 2400.95 | 324.45 | |||
SO46364_2 | BC3C-4FE8-AC | PO3248115921 | 100 | 282 | 350 | 7 | 366 | 4 | 1476.56 | 2022-08-04 | 4218.74 | 68.55 | 2022-07-23 | 5 | 1898.09 | 1 | 2742.18 | 2 | SO46364 | 2022-07-30 | 219.37 | 9490.47 | 843.75 | 0.35 |
SO51845_26 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 361 | 312 | 4 | 2023-10-04 | 5507.98 | 137.70 | 2023-09-22 | 4 | 1251.98 | 1 | 5507.98 | 26 | SO51845 | 2023-09-29 | 440.64 | 5007.93 | 1376.99 | |||
SO57137_38 | 9401-4518-A4 | PO6438194874 | 100 | 281 | 490 | 309 | 4 | 2024-01-04 | 161.97 | 4.05 | 2023-12-23 | 5 | 41.57 | 1 | 161.97 | 38 | SO57137 | 2023-12-30 | 12.96 | 207.86 | 32.39 | |||
SO44317_2 | BE9B-42BA-87 | PO7859142280 | 100 | 287 | 319 | 221 | 4 | 2021-12-04 | 2624.38 | 65.61 | 2021-11-22 | 3 | 884.71 | 1 | 2624.38 | 2 | SO44317 | 2021-11-29 | 209.95 | 2654.12 | 874.79 | |||
SO53538_5 | D7FE-4E54-BD | PO18125134677 | 100 | 287 | 430 | 311 | 4 | 2023-11-04 | 356.90 | 8.92 | 2023-10-23 | 1 | 360.94 | 1 | 356.90 | 5 | SO53538 | 2023-10-30 | 28.55 | 360.94 | 356.90 | |||
SO50663_4 | 286E-4915-89 | PO19343130555 | 100 | 282 | 263 | 24 | 4 | 2023-08-04 | 809.33 | 20.23 | 2023-07-23 | 4 | 187.16 | 1 | 809.33 | 4 | SO50663 | 2023-07-30 | 64.75 | 748.63 | 202.33 | |||
SO67273_27 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 363 | 2 | 475 | 4 | 292.84 | 2024-06-04 | 14642.04 | 358.73 | 2024-05-23 | 11 | 1251.98 | 1 | 14349.20 | 27 | SO67273 | 2024-05-30 | 1147.94 | 13771.79 | 1331.09 | 0.02 |
SO71902_16 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 542 | 61 | 4 | 2024-08-04 | 97.18 | 2.43 | 2024-07-23 | 4 | 17.98 | 1 | 97.18 | 16 | SO71902 | 2024-07-30 | 7.77 | 71.91 | 24.29 | |||
SO55322_30 | D600-436A-B7 | PO7859118281 | 100 | 287 | 231 | 221 | 4 | 2023-12-04 | 269.95 | 6.75 | 2023-11-22 | 9 | 38.49 | 1 | 269.95 | 30 | SO55322 | 2023-11-29 | 21.60 | 346.43 | 29.99 | |||
SO50745_12 | 02DB-4CC5-85 | PO5539140407 | 100 | 282 | 216 | 61 | 4 | 2023-08-04 | 80.75 | 2.02 | 2023-07-23 | 4 | 13.88 | 1 | 80.75 | 12 | SO50745 | 2023-07-30 | 6.46 | 55.51 | 20.19 | |||
SO50748_36 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 273 | 3 | 4 | 2023-08-04 | 202.33 | 5.06 | 2023-07-23 | 1 | 187.16 | 1 | 202.33 | 36 | SO50748 | 2023-07-30 | 16.19 | 187.16 | 202.33 |
Generated 2024-09-21 08:48:15.795 UTC