[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 966 > < TAKE 60 >
60 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48090_12 | E7D1-44A3-B2 | PO9512117066 | 100 | 285 | 323 | 135 | 5 | 2023-01-03 | 939.59 | 23.49 | 2022-12-22 | 2 | 486.71 | 1 | 939.59 | 12 | SO48090 | 2022-12-29 | 75.17 | 973.41 | 469.79 | |||
SO48766_21 | A56F-4A7B-AD | PO9831126274 | 100 | 285 | 373 | 81 | 5 | 2023-03-05 | 6544.69 | 163.62 | 2023-02-21 | 5 | 1320.68 | 1 | 6544.69 | 21 | SO48766 | 2023-02-28 | 523.58 | 6603.42 | 1308.94 | |||
SO46630_28 | F512-40F2-91 | PO12644161356 | 100 | 285 | 356 | 530 | 5 | 2022-09-02 | 3728.56 | 93.21 | 2022-08-21 | 3 | 1117.86 | 1 | 3728.56 | 28 | SO46630 | 2022-08-28 | 298.28 | 3353.57 | 1242.85 | |||
SO50273_1 | 8358-4E59-86 | PO16211117741 | 100 | 285 | 308 | 99 | 5 | 2023-07-03 | 744.27 | 18.61 | 2023-06-21 | 1 | 660.91 | 1 | 744.27 | 1 | SO50273 | 2023-06-28 | 59.54 | 660.91 | 744.27 | |||
SO55331_22 | 4195-4A79-A3 | PO9889143385 | 100 | 285 | 588 | 494 | 5 | 2023-12-03 | 923.39 | 23.08 | 2023-11-21 | 2 | 419.78 | 1 | 923.39 | 22 | SO55331 | 2023-11-28 | 73.87 | 839.56 | 461.69 | |||
SO61228_35 | 06C7-43A1-85 | PO9831151400 | 100 | 285 | 484 | 81 | 5 | 2024-03-04 | 33.39 | 0.83 | 2024-02-21 | 7 | 2.97 | 1 | 33.39 | 35 | SO61228 | 2024-02-28 | 2.67 | 20.81 | 4.77 | |||
SO63181_14 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 584 | 700 | 5 | 2024-04-04 | 1619.97 | 40.50 | 2024-03-23 | 5 | 343.65 | 1 | 1619.97 | 14 | SO63181 | 2024-03-30 | 129.60 | 1718.25 | 323.99 | |||
SO67277_5 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 488 | 530 | 5 | 2024-06-03 | 64.79 | 1.62 | 2024-05-22 | 2 | 41.57 | 1 | 64.79 | 5 | SO67277 | 2024-05-29 | 5.18 | 83.14 | 32.39 | |||
SO49170_7 | B501-448E-96 | PO10150180753 | 100 | 285 | 364 | 9 | 5 | 2023-04-05 | 1295.99 | 32.40 | 2023-03-24 | 2 | 598.44 | 1 | 1295.99 | 7 | SO49170 | 2023-03-31 | 103.68 | 1196.87 | 647.99 | |||
SO47725_41 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 273 | 81 | 5 | 2022-12-03 | 404.66 | 10.12 | 2022-11-21 | 2 | 187.16 | 1 | 404.66 | 41 | SO47725 | 2022-11-28 | 32.37 | 374.31 | 202.33 | |||
SO55304_1 | CB2B-4767-9D | PO4176184346 | 100 | 285 | 384 | 458 | 5 | 2023-12-03 | 672.29 | 16.81 | 2023-11-21 | 1 | 713.08 | 1 | 672.29 | 1 | SO55304 | 2023-11-28 | 53.78 | 713.08 | 672.29 | |||
SO71948_18 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 380 | 170 | 5 | 2024-08-03 | 10262.07 | 256.55 | 2024-07-22 | 7 | 1554.95 | 1 | 10262.07 | 18 | SO71948 | 2024-07-29 | 820.97 | 10884.64 | 1466.01 | |||
SO51705_4 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 484 | 441 | 5 | 2023-10-03 | 9.54 | 0.24 | 2023-09-21 | 2 | 2.97 | 1 | 9.54 | 4 | SO51705 | 2023-09-28 | 0.76 | 5.95 | 4.77 | |||
SO47455_31 | 41F3-48C2-B7 | PO9599169586 | 100 | 285 | 423 | 170 | 5 | 2022-11-03 | 330.46 | 8.26 | 2022-10-22 | 2 | 122.27 | 1 | 330.46 | 31 | SO47455 | 2022-10-29 | 26.44 | 244.54 | 165.23 | |||
SO44779_9 | A6CC-4B73-8D | PO4089186617 | 100 | 285 | 346 | 368 | 5 | 2022-02-02 | 2039.99 | 51.00 | 2022-01-21 | 1 | 1912.15 | 1 | 2039.99 | 9 | SO44779 | 2022-01-28 | 163.20 | 1912.15 | 2039.99 | |||
SO69533_13 | AC2B-4C39-84 | PO3596133486 | 100 | 285 | 474 | 2 | 476 | 5 | 11.37 | 2024-07-03 | 568.32 | 13.92 | 2024-06-21 | 14 | 26.18 | 1 | 556.95 | 13 | SO69533 | 2024-06-28 | 44.56 | 366.47 | 40.59 | 0.02 |
SO51718_21 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 471 | 207 | 5 | 2023-10-03 | 190.50 | 4.76 | 2023-09-21 | 5 | 23.75 | 1 | 190.50 | 21 | SO51718 | 2023-09-28 | 15.24 | 118.75 | 38.10 | |||
SO45551_1 | 5C52-4027-BE | PO1943115167 | 100 | 285 | 319 | 525 | 5 | 2022-05-03 | 3499.18 | 87.48 | 2022-04-21 | 4 | 884.71 | 1 | 3499.18 | 1 | SO45551 | 2022-04-28 | 279.93 | 3538.83 | 874.79 | |||
SO48063_23 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 358 | 566 | 5 | 2023-01-03 | 6147.29 | 153.68 | 2022-12-22 | 5 | 1105.81 | 1 | 6147.29 | 23 | SO48063 | 2022-12-29 | 491.78 | 5529.05 | 1229.46 | |||
SO47726_27 | 7256-4599-93 | PO9657190563 | 100 | 285 | 409 | 315 | 5 | 2022-12-03 | 418.51 | 10.46 | 2022-11-21 | 2 | 185.82 | 1 | 418.51 | 27 | SO47726 | 2022-11-28 | 33.48 | 371.64 | 209.26 | |||
SO51137_26 | A47F-4FEF-94 | PO9889144162 | 100 | 285 | 596 | 494 | 5 | 2023-09-02 | 647.99 | 16.20 | 2023-08-21 | 2 | 294.58 | 1 | 647.99 | 26 | SO51137 | 2023-08-28 | 51.84 | 589.16 | 323.99 | |||
SO46099_10 | 7E3B-4362-99 | PO7598165395 | 100 | 285 | 272 | 45 | 5 | 2022-07-03 | 735.75 | 18.39 | 2022-06-21 | 4 | 181.49 | 1 | 735.75 | 10 | SO46099 | 2022-06-28 | 58.86 | 725.94 | 183.94 | |||
SO69518_13 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 400 | 63 | 5 | 2024-07-03 | 74.30 | 1.86 | 2024-06-21 | 2 | 27.49 | 1 | 74.30 | 13 | SO69518 | 2024-06-28 | 5.94 | 54.99 | 37.15 | |||
SO59071_14 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 408 | 170 | 5 | 2024-02-02 | 288.65 | 7.22 | 2024-01-21 | 4 | 53.40 | 1 | 288.65 | 14 | SO59071 | 2024-01-28 | 23.09 | 213.60 | 72.16 | |||
SO46033_5 | 253E-48E3-85 | PO18560157809 | 100 | 285 | 328 | 531 | 5 | 2022-07-03 | 419.46 | 10.49 | 2022-06-21 | 1 | 413.15 | 1 | 419.46 | 5 | SO46033 | 2022-06-28 | 33.56 | 413.15 | 419.46 | |||
SO44801_15 | 4DBD-4E98-A7 | PO9599152040 | 100 | 285 | 332 | 170 | 5 | 2022-02-02 | 419.46 | 10.49 | 2022-01-21 | 1 | 413.15 | 1 | 419.46 | 15 | SO44801 | 2022-01-28 | 33.56 | 413.15 | 419.46 | |||
SO57074_14 | FF65-4261-97 | PO9918191120 | 100 | 285 | 560 | 260 | 5 | 2024-01-03 | 3644.55 | 91.11 | 2023-12-22 | 5 | 755.15 | 1 | 3644.55 | 14 | SO57074 | 2023-12-29 | 291.56 | 3775.75 | 728.91 | |||
SO49878_7 | 3EF0-4F28-B3 | PO3741190259 | 100 | 285 | 224 | 404 | 5 | 2023-06-03 | 20.75 | 0.52 | 2023-05-22 | 4 | 5.23 | 1 | 20.75 | 7 | SO49878 | 2023-05-29 | 1.66 | 20.92 | 5.19 | |||
SO58971_3 | 319A-4CAC-B1 | PO1537134870 | 100 | 285 | 463 | 611 | 5 | 2024-02-02 | 73.47 | 1.84 | 2024-01-21 | 5 | 9.16 | 1 | 73.47 | 3 | SO58971 | 2024-01-28 | 5.88 | 45.80 | 14.69 | |||
SO49865_35 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 333 | 81 | 5 | 2023-06-03 | 1879.18 | 46.98 | 2023-05-22 | 4 | 486.71 | 1 | 1879.18 | 35 | SO49865 | 2023-05-29 | 150.33 | 1946.83 | 469.79 | |||
SO43659_2 | 4911-403C-98 | PO522145787 | 100 | 285 | 350 | 676 | 5 | 2021-09-02 | 6074.98 | 151.87 | 2021-08-21 | 3 | 1898.09 | 1 | 6074.98 | 2 | SO43659 | 2021-08-28 | 486.00 | 5694.28 | 2024.99 | |||
SO50740_6 | 0ACE-4A34-92 | PO4089165876 | 100 | 285 | 352 | 368 | 5 | 2023-08-03 | 1242.85 | 31.07 | 2023-07-22 | 1 | 1117.86 | 1 | 1242.85 | 6 | SO50740 | 2023-07-29 | 99.43 | 1117.86 | 1242.85 | |||
SO45312_3 | FE78-461F-B7 | PO1276154927 | 100 | 285 | 310 | 548 | 5 | 2022-04-05 | 2146.96 | 53.67 | 2022-03-24 | 1 | 2171.29 | 1 | 2146.96 | 3 | SO45312 | 2022-03-31 | 171.76 | 2171.29 | 2146.96 | |||
SO46365_2 | BFDB-4B9A-83 | PO4089182386 | 100 | 285 | 347 | 7 | 368 | 5 | 297.50 | 2022-08-03 | 850.00 | 13.81 | 2022-07-22 | 1 | 1912.15 | 1 | 552.50 | 2 | SO46365 | 2022-07-29 | 44.20 | 1912.15 | 850.00 | 0.35 |
SO53474_32 | E5B6-4103-8D | PO15457187993 | 100 | 285 | 576 | 297 | 5 | 2023-11-03 | 2860.88 | 71.52 | 2023-10-22 | 2 | 1481.94 | 1 | 2860.88 | 32 | SO53474 | 2023-10-29 | 228.87 | 2963.88 | 1430.44 | |||
SO44799_5 | 2146-417A-8D | PO9106161251 | 100 | 285 | 218 | 602 | 5 | 2022-02-02 | 17.10 | 0.43 | 2022-01-21 | 3 | 3.40 | 1 | 17.10 | 5 | SO44799 | 2022-01-28 | 1.37 | 10.19 | 5.70 | |||
SO67260_15 | 6224-4229-B8 | PO522163557 | 100 | 285 | 298 | 676 | 5 | 2024-06-03 | 1619.52 | 40.49 | 2024-05-22 | 2 | 739.04 | 1 | 1619.52 | 15 | SO67260 | 2024-05-29 | 129.56 | 1478.08 | 809.76 | |||
SO69510_3 | 20D6-41A2-8F | PO5568198481 | 100 | 285 | 476 | 422 | 5 | 2024-07-03 | 335.95 | 8.40 | 2024-06-21 | 8 | 26.18 | 1 | 335.95 | 3 | SO69510 | 2024-06-28 | 26.88 | 209.41 | 41.99 | |||
SO50756_26 | C414-447C-84 | PO9570119689 | 100 | 285 | 469 | 3 | 585 | 5 | 15.67 | 2023-08-03 | 313.42 | 7.44 | 2023-07-22 | 15 | 15.67 | 1 | 297.75 | 26 | SO50756 | 2023-07-29 | 23.82 | 235.06 | 20.89 | 0.05 |
SO57162_10 | 83B5-43A6-BD | PO3596174424 | 100 | 285 | 590 | 476 | 5 | 2024-01-03 | 461.69 | 11.54 | 2023-12-22 | 1 | 419.78 | 1 | 461.69 | 10 | SO57162 | 2023-12-29 | 36.94 | 419.78 | 461.69 | |||
SO61228_32 | 06C7-43A1-85 | PO9831151400 | 100 | 285 | 605 | 81 | 5 | 2024-03-04 | 323.99 | 8.10 | 2024-02-21 | 1 | 343.65 | 1 | 323.99 | 32 | SO61228 | 2024-02-28 | 25.92 | 343.65 | 323.99 | |||
SO53595_3 | 4160-4910-92 | PO4089179449 | 100 | 285 | 544 | 368 | 5 | 2023-11-03 | 97.19 | 2.43 | 2023-10-22 | 2 | 35.96 | 1 | 97.19 | 3 | SO53595 | 2023-10-29 | 7.78 | 71.92 | 48.59 | |||
SO46350_2 | AA48-457B-B3 | PO11426174503 | 100 | 285 | 315 | 386 | 5 | 2022-08-03 | 1749.59 | 43.74 | 2022-07-22 | 2 | 884.71 | 1 | 1749.59 | 2 | SO46350 | 2022-07-29 | 139.97 | 1769.42 | 874.79 | |||
SO67260_46 | 6224-4229-B8 | PO522163557 | 100 | 285 | 525 | 676 | 5 | 2024-06-03 | 158.43 | 3.96 | 2024-05-22 | 1 | 144.59 | 1 | 158.43 | 46 | SO67260 | 2024-05-29 | 12.67 | 144.59 | 158.43 | |||
SO69465_13 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 604 | 700 | 5 | 2024-07-03 | 1295.98 | 32.40 | 2024-06-21 | 4 | 343.65 | 1 | 1295.98 | 13 | SO69465 | 2024-06-28 | 103.68 | 1374.60 | 323.99 | |||
SO46995_8 | 9CEA-4AC3-95 | PO11542113352 | 100 | 285 | 286 | 62 | 5 | 2022-10-03 | 183.94 | 4.60 | 2022-09-21 | 1 | 170.14 | 1 | 183.94 | 8 | SO46995 | 2022-09-28 | 14.72 | 170.14 | 183.94 | |||
SO65220_8 | 6D87-4C24-98 | PO15457146892 | 100 | 285 | 559 | 297 | 5 | 2024-05-03 | 12.14 | 0.30 | 2024-04-21 | 1 | 8.99 | 1 | 12.14 | 8 | SO65220 | 2024-04-28 | 0.97 | 8.99 | 12.14 | |||
SO47726_21 | 7256-4599-93 | PO9657190563 | 100 | 285 | 233 | 315 | 5 | 2022-12-03 | 86.52 | 2.16 | 2022-11-21 | 3 | 29.08 | 1 | 86.52 | 21 | SO47726 | 2022-11-28 | 6.92 | 87.24 | 28.84 | |||
SO44799_9 | 2146-417A-8D | PO9106161251 | 100 | 285 | 296 | 602 | 5 | 2022-02-02 | 714.70 | 17.87 | 2022-01-21 | 1 | 617.03 | 1 | 714.70 | 9 | SO44799 | 2022-01-28 | 57.18 | 617.03 | 714.70 | |||
SO46384_6 | 9F38-4366-91 | PO9541189751 | 100 | 285 | 223 | 279 | 5 | 2022-08-03 | 5.19 | 0.13 | 2022-07-22 | 1 | 5.71 | 1 | 5.19 | 6 | SO46384 | 2022-07-29 | 0.41 | 5.71 | 5.19 | |||
SO46933_32 | 4D88-4B51-BF | PO19546168601 | 100 | 285 | 273 | 206 | 5 | 2022-10-03 | 607.00 | 15.17 | 2022-09-21 | 3 | 187.16 | 1 | 607.00 | 32 | SO46933 | 2022-09-28 | 48.56 | 561.47 | 202.33 | |||
SO51693_30 | 6FEB-4D5B-92 | PO19546179477 | 100 | 285 | 287 | 206 | 5 | 2023-10-03 | 607.00 | 15.17 | 2023-09-21 | 3 | 204.63 | 1 | 607.00 | 30 | SO51693 | 2023-09-28 | 48.56 | 613.88 | 202.33 | |||
SO46672_5 | FFCF-4848-99 | PO9831178966 | 100 | 285 | 457 | 81 | 5 | 2022-09-02 | 89.99 | 2.25 | 2022-08-21 | 2 | 30.93 | 1 | 89.99 | 5 | SO46672 | 2022-08-28 | 7.20 | 61.87 | 44.99 | |||
SO49865_25 | E9A6-42D3-91 | PO9831136904 | 100 | 285 | 233 | 81 | 5 | 2023-06-03 | 115.36 | 2.88 | 2023-05-22 | 4 | 29.08 | 1 | 115.36 | 25 | SO49865 | 2023-05-29 | 9.23 | 116.32 | 28.84 | |||
SO44304_2 | D34C-4225-A3 | PO10179168311 | 100 | 285 | 349 | 27 | 5 | 2021-12-03 | 6074.98 | 151.87 | 2021-11-21 | 3 | 1898.09 | 1 | 6074.98 | 2 | SO44304 | 2021-11-28 | 486.00 | 5694.28 | 2024.99 | |||
SO63220_5 | 25AE-42A1-80 | PO9773177410 | 100 | 285 | 568 | 8 | 5 | 2024-04-04 | 445.41 | 11.14 | 2024-03-23 | 1 | 461.44 | 1 | 445.41 | 5 | SO63220 | 2024-03-30 | 35.63 | 461.44 | 445.41 | |||
SO47042_38 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 213 | 566 | 5 | 2022-10-03 | 161.49 | 4.04 | 2022-09-21 | 8 | 13.88 | 1 | 161.49 | 38 | SO47042 | 2022-09-28 | 12.92 | 111.03 | 20.19 | |||
SO45577_20 | 7B09-45DB-A3 | PO9599125078 | 100 | 285 | 270 | 170 | 5 | 2022-05-03 | 551.81 | 13.80 | 2022-04-21 | 3 | 181.49 | 1 | 551.81 | 20 | SO45577 | 2022-04-28 | 44.15 | 544.46 | 183.94 | |||
SO55331_20 | 4195-4A79-A3 | PO9889143385 | 100 | 285 | 475 | 494 | 5 | 2023-12-03 | 41.99 | 1.05 | 2023-11-21 | 1 | 26.18 | 1 | 41.99 | 20 | SO55331 | 2023-11-28 | 3.36 | 26.18 | 41.99 | |||
SO48793_1 | DDED-453E-8B | PO9889169703 | 100 | 285 | 409 | 494 | 5 | 2023-03-05 | 209.26 | 5.23 | 2023-02-21 | 1 | 185.82 | 1 | 209.26 | 1 | SO48793 | 2023-02-28 | 16.74 | 185.82 | 209.26 |
Generated 2024-09-20 14:23:08.691 UTC