[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 188 > < TAKE 31 >
31 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO46387_13 | 5AA4-4F68-A1 | PO9599173396 | 100 | 285 | 326 | 170 | 5 | 2022-09-22 | 1258.38 | 31.46 | 2022-09-10 | 3 | 413.15 | 1 | 1258.38 | 13 | SO46387 | 2022-09-17 | 100.67 | 1239.44 | 419.46 | |||
| SO50303_1 | 5CEE-4EB6-93 | PO5800164494 | 100 | 285 | 396 | 63 | 5 | 2023-08-22 | 74.84 | 1.87 | 2023-08-10 | 1 | 55.38 | 1 | 74.84 | 1 | SO50303 | 2023-08-17 | 5.99 | 55.38 | 74.84 | |||
| SO69518_3 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 474 | 63 | 5 | 2024-08-22 | 209.97 | 5.25 | 2024-08-10 | 5 | 26.18 | 1 | 209.97 | 3 | SO69518 | 2024-08-17 | 16.80 | 130.88 | 41.99 | |||
| SO57074_15 | FF65-4261-97 | PO9918191120 | 100 | 285 | 548 | 260 | 5 | 2024-02-22 | 48.59 | 1.21 | 2024-02-10 | 1 | 35.96 | 1 | 48.59 | 15 | SO57074 | 2024-02-17 | 3.89 | 35.96 | 48.59 | |||
| SO67260_15 | 6224-4229-B8 | PO522163557 | 100 | 285 | 298 | 676 | 5 | 2024-07-23 | 1619.52 | 40.49 | 2024-07-11 | 2 | 739.04 | 1 | 1619.52 | 15 | SO67260 | 2024-07-18 | 129.56 | 1478.08 | 809.76 | |||
| SO69394_11 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 546 | 206 | 5 | 2024-08-22 | 111.76 | 2.79 | 2024-08-10 | 3 | 27.57 | 1 | 111.76 | 11 | SO69394 | 2024-08-17 | 8.94 | 82.70 | 37.25 | |||
| SO47693_27 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 468 | 676 | 5 | 2023-01-22 | 68.38 | 1.71 | 2023-01-10 | 3 | 15.67 | 1 | 68.38 | 27 | SO47693 | 2023-01-17 | 5.47 | 47.01 | 22.79 | |||
| SO46088_3 | 9E24-49CE-A7 | PO5568122777 | 100 | 285 | 219 | 422 | 5 | 2022-08-22 | 5.70 | 0.14 | 2022-08-10 | 1 | 3.40 | 1 | 5.70 | 3 | SO46088 | 2022-08-17 | 0.46 | 3.40 | 5.70 | |||
| SO48062_3 | DB45-43CB-82 | PO5568119115 | 100 | 285 | 456 | 422 | 5 | 2023-02-22 | 134.98 | 3.37 | 2023-02-10 | 3 | 30.93 | 1 | 134.98 | 3 | SO48062 | 2023-02-17 | 10.80 | 92.80 | 44.99 | |||
| SO71844_18 | 410D-4079-9E | PO2813198985 | 100 | 283 | 382 | 90 | 5 | 2024-09-22 | 2689.18 | 67.23 | 2024-09-10 | 4 | 713.08 | 1 | 2689.18 | 18 | SO71844 | 2024-09-17 | 215.13 | 2852.32 | 672.29 | |||
| SO55253_38 | C58B-49D8-9F | PO12644132539 | 100 | 285 | 474 | 3 | 530 | 5 | 32.72 | 2024-01-22 | 654.41 | 15.54 | 2024-01-10 | 17 | 26.18 | 1 | 621.69 | 38 | SO55253 | 2024-01-17 | 49.73 | 445.00 | 38.49 | 0.05 |
| SO43694_9 | EC3D-48E0-A6 | PO9657130250 | 100 | 285 | 346 | 315 | 5 | 2021-10-22 | 4079.99 | 102.00 | 2021-10-10 | 2 | 1912.15 | 1 | 4079.99 | 9 | SO43694 | 2021-10-17 | 326.40 | 3824.31 | 2039.99 | |||
| SO51864_2 | 2389-4E32-92 | PO5568126648 | 100 | 285 | 477 | 422 | 5 | 2023-11-22 | 5.99 | 0.15 | 2023-11-10 | 2 | 1.87 | 1 | 5.99 | 2 | SO51864 | 2023-11-17 | 0.48 | 3.73 | 2.99 | |||
| SO53474_11 | E5B6-4103-8D | PO15457187993 | 100 | 285 | 548 | 297 | 5 | 2023-12-23 | 97.19 | 2.43 | 2023-12-11 | 2 | 35.96 | 1 | 97.19 | 11 | SO53474 | 2023-12-18 | 7.78 | 71.92 | 48.59 | |||
| SO69452_1 | 5ADC-4093-86 | PO10150198555 | 100 | 285 | 588 | 9 | 5 | 2024-08-22 | 461.69 | 11.54 | 2024-08-10 | 1 | 419.78 | 1 | 461.69 | 1 | SO69452 | 2024-08-17 | 36.94 | 419.78 | 461.69 | |||
| SO50726_7 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 381 | 170 | 5 | 2023-09-22 | 2401.05 | 60.03 | 2023-09-10 | 4 | 605.65 | 1 | 2401.05 | 7 | SO50726 | 2023-09-17 | 192.08 | 2422.60 | 600.26 | |||
| SO53530_37 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 436 | 90 | 5 | 2023-12-23 | 1427.59 | 35.69 | 2023-12-11 | 4 | 360.94 | 1 | 1427.59 | 37 | SO53530 | 2023-12-18 | 114.21 | 1443.77 | 356.90 | |||
| SO46673_29 | 578D-4F7B-A6 | PO9657163155 | 100 | 285 | 421 | 315 | 5 | 2022-10-22 | 392.66 | 9.82 | 2022-10-10 | 2 | 145.28 | 1 | 392.66 | 29 | SO46673 | 2022-10-17 | 31.41 | 290.57 | 196.33 | |||
| SO53618_4 | 6596-437F-A7 | PO9251170624 | 100 | 272 | 521 | 351 | 5 | 2023-12-23 | 48.82 | 1.22 | 2023-12-11 | 3 | 12.04 | 1 | 48.82 | 4 | SO53618 | 2023-12-18 | 3.91 | 36.12 | 16.27 | |||
| SO67331_3 | F7D7-49F2-83 | PO3741116971 | 100 | 285 | 547 | 404 | 5 | 2024-07-23 | 48.59 | 1.21 | 2024-07-11 | 1 | 35.96 | 1 | 48.59 | 3 | SO67331 | 2024-07-18 | 3.89 | 35.96 | 48.59 | |||
| SO47693_29 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 224 | 676 | 5 | 2023-01-22 | 31.12 | 0.78 | 2023-01-10 | 6 | 5.23 | 1 | 31.12 | 29 | SO47693 | 2023-01-17 | 2.49 | 31.38 | 5.19 | |||
| SO51137_10 | A47F-4FEF-94 | PO9889144162 | 100 | 285 | 402 | 494 | 5 | 2023-10-22 | 72.16 | 1.80 | 2023-10-10 | 1 | 53.40 | 1 | 72.16 | 10 | SO51137 | 2023-10-17 | 5.77 | 53.40 | 72.16 | |||
| SO51108_11 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 309 | 530 | 5 | 2023-10-22 | 2456.10 | 61.40 | 2023-10-10 | 3 | 747.20 | 1 | 2456.10 | 11 | SO51108 | 2023-10-17 | 196.49 | 2241.60 | 818.70 | |||
| SO58924_22 | D17F-4E31-90 | PO15457121920 | 100 | 285 | 560 | 297 | 5 | 2024-03-23 | 728.91 | 18.22 | 2024-03-11 | 1 | 755.15 | 1 | 728.91 | 22 | SO58924 | 2024-03-18 | 58.31 | 755.15 | 728.91 | |||
| SO65210_8 | 08E4-4CC9-A7 | PO2813181442 | 100 | 283 | 231 | 90 | 5 | 2024-06-22 | 179.96 | 4.50 | 2024-06-10 | 6 | 38.49 | 1 | 179.96 | 8 | SO65210 | 2024-06-17 | 14.40 | 230.95 | 29.99 | |||
| SO69565_3 | F165-437F-B9 | PO9773181473 | 100 | 285 | 565 | 8 | 5 | 2024-08-22 | 890.82 | 22.27 | 2024-08-10 | 2 | 461.44 | 1 | 890.82 | 3 | SO69565 | 2024-08-17 | 71.27 | 922.89 | 445.41 | |||
| SO50726_4 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 327 | 170 | 5 | 2023-09-22 | 1879.18 | 46.98 | 2023-09-10 | 4 | 486.71 | 1 | 1879.18 | 4 | SO50726 | 2023-09-17 | 150.33 | 1946.83 | 469.79 | |||
| SO67277_5 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 488 | 530 | 5 | 2024-07-23 | 64.79 | 1.62 | 2024-07-11 | 2 | 41.57 | 1 | 64.79 | 5 | SO67277 | 2024-07-18 | 5.18 | 83.14 | 32.39 | |||
| SO51147_31 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 382 | 81 | 5 | 2023-10-22 | 1344.59 | 33.61 | 2023-10-10 | 2 | 713.08 | 1 | 1344.59 | 31 | SO51147 | 2023-10-17 | 107.57 | 1426.16 | 672.29 | |||
| SO47414_1 | 945A-493D-BF | PO2407179130 | 100 | 285 | 325 | 225 | 5 | 2022-12-23 | 469.79 | 11.74 | 2022-12-11 | 1 | 486.71 | 1 | 469.79 | 1 | SO47414 | 2022-12-18 | 37.58 | 486.71 | 469.79 | |||
| SO48365_6 | F100-46F1-98 | PO4089137383 | 100 | 285 | 354 | 368 | 5 | 2023-03-24 | 1242.85 | 31.07 | 2023-03-12 | 1 | 1117.86 | 1 | 1242.85 | 6 | SO48365 | 2023-03-19 | 99.43 | 1117.86 | 1242.85 |
Generated 2024-11-09 22:43:09.142 UTC