[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 2187 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO50231_9 | B2CA-498D-9B | PO11571129150 | 100 | 285 | 331 | 512 | 5 | 2023-08-27 | 1879.18 | 46.98 | 2023-08-15 | 4 | 486.71 | 1 | 1879.18 | 9 | SO50231 | 2023-08-22 | 150.33 | 1946.83 | 469.79 | |||
| SO65283_2 | 8C3A-4D5E-9D | PO4089118931 | 100 | 285 | 359 | 368 | 5 | 2024-06-27 | 2753.99 | 68.85 | 2024-06-15 | 2 | 1251.98 | 1 | 2753.99 | 2 | SO65283 | 2024-06-22 | 220.32 | 2503.96 | 1376.99 | |||
| SO51718_7 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 474 | 3 | 207 | 5 | 38.49 | 2023-11-27 | 769.89 | 18.28 | 2023-11-15 | 20 | 26.18 | 1 | 731.40 | 7 | SO51718 | 2023-11-22 | 58.51 | 523.53 | 38.49 | 0.05 |
| SO46045_7 | 9345-48CB-A5 | PO16327127643 | 100 | 285 | 315 | 584 | 5 | 2022-08-27 | 1749.59 | 43.74 | 2022-08-15 | 2 | 884.71 | 1 | 1749.59 | 7 | SO46045 | 2022-08-22 | 139.97 | 1769.42 | 874.79 | |||
| SO46104_1 | 3388-4086-90 | PO7714117703 | 100 | 285 | 322 | 495 | 5 | 2022-08-27 | 419.46 | 10.49 | 2022-08-15 | 1 | 413.15 | 1 | 419.46 | 1 | SO46104 | 2022-08-22 | 33.56 | 413.15 | 419.46 | |||
| SO50293_7 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 410 | 476 | 5 | 2023-08-27 | 72.89 | 1.82 | 2023-08-15 | 2 | 26.97 | 1 | 72.89 | 7 | SO50293 | 2023-08-22 | 5.83 | 53.94 | 36.45 | |||
| SO61173_2 | 6B8D-47B8-8E | PO522171689 | 100 | 285 | 599 | 676 | 5 | 2024-04-28 | 647.99 | 16.20 | 2024-04-16 | 2 | 294.58 | 1 | 647.99 | 2 | SO61173 | 2024-04-23 | 51.84 | 589.16 | 323.99 | |||
| SO46045_14 | 9345-48CB-A5 | PO16327127643 | 100 | 285 | 223 | 584 | 5 | 2022-08-27 | 31.12 | 0.78 | 2022-08-15 | 6 | 5.71 | 1 | 31.12 | 14 | SO46045 | 2022-08-22 | 2.49 | 34.23 | 5.19 | |||
| SO46943_2 | 6F43-4A10-80 | PO18560122957 | 100 | 285 | 343 | 531 | 5 | 2022-11-27 | 469.79 | 11.74 | 2022-11-15 | 1 | 486.71 | 1 | 469.79 | 2 | SO46943 | 2022-11-22 | 37.58 | 486.71 | 469.79 | |||
| SO67340_1 | 429B-48A6-9C | PO4176157624 | 100 | 285 | 382 | 458 | 5 | 2024-07-28 | 672.29 | 16.81 | 2024-07-16 | 1 | 713.08 | 1 | 672.29 | 1 | SO67340 | 2024-07-23 | 53.78 | 713.08 | 672.29 | |||
| SO50276_2 | BB3F-4E95-B8 | PO9512139148 | 100 | 285 | 233 | 135 | 5 | 2023-08-27 | 115.36 | 2.88 | 2023-08-15 | 4 | 29.08 | 1 | 115.36 | 2 | SO50276 | 2023-08-22 | 9.23 | 116.32 | 28.84 | |||
| SO53563_35 | C955-44BD-A8 | PO9599165865 | 100 | 285 | 384 | 170 | 5 | 2023-12-28 | 3361.47 | 84.04 | 2023-12-16 | 5 | 713.08 | 1 | 3361.47 | 35 | SO53563 | 2023-12-23 | 268.92 | 3565.40 | 672.29 | |||
| SO57126_1 | 6350-4E4D-85 | PO7598164370 | 100 | 285 | 378 | 45 | 5 | 2024-02-27 | 2932.02 | 73.30 | 2024-02-15 | 2 | 1554.95 | 1 | 2932.02 | 1 | SO57126 | 2024-02-22 | 234.56 | 3109.90 | 1466.01 | |||
| SO51081_25 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 217 | 11 | 676 | 5 | 14.17 | 2023-10-27 | 94.47 | 2.01 | 2023-10-15 | 6 | 13.09 | 1 | 80.30 | 25 | SO51081 | 2023-10-22 | 6.42 | 78.52 | 15.75 | 0.15 |
| SO65283_1 | 8C3A-4D5E-9D | PO4089118931 | 100 | 285 | 475 | 368 | 5 | 2024-06-27 | 125.98 | 3.15 | 2024-06-15 | 3 | 26.18 | 1 | 125.98 | 1 | SO65283 | 2024-06-22 | 10.08 | 78.53 | 41.99 | |||
| SO46091_7 | 6DCB-4063-BA | PO6293193126 | 100 | 285 | 313 | 612 | 5 | 2022-08-27 | 2146.96 | 53.67 | 2022-08-15 | 1 | 2171.29 | 1 | 2146.96 | 7 | SO46091 | 2022-08-22 | 171.76 | 2171.29 | 2146.96 | |||
| SO57104_11 | D4EE-4716-83 | PO18560117786 | 100 | 285 | 481 | 531 | 5 | 2024-02-27 | 21.58 | 0.54 | 2024-02-15 | 4 | 3.36 | 1 | 21.58 | 11 | SO57104 | 2024-02-22 | 1.73 | 13.45 | 5.39 | |||
| SO50293_3 | D649-4CE8-91 | PO3596144572 | 100 | 285 | 365 | 476 | 5 | 2023-08-27 | 1295.99 | 32.40 | 2023-08-15 | 2 | 598.44 | 1 | 1295.99 | 3 | SO50293 | 2023-08-22 | 103.68 | 1196.87 | 647.99 | |||
| SO48063_7 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 456 | 566 | 5 | 2023-02-27 | 359.95 | 9.00 | 2023-02-15 | 8 | 30.93 | 1 | 359.95 | 7 | SO48063 | 2023-02-22 | 28.80 | 247.47 | 44.99 | |||
| SO51824_30 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 543 | 63 | 5 | 2023-11-27 | 37.25 | 0.93 | 2023-11-15 | 1 | 27.57 | 1 | 37.25 | 30 | SO51824 | 2023-11-22 | 2.98 | 27.57 | 37.25 | |||
| SO47040_12 | 5A71-45F5-B9 | PO5568168365 | 100 | 285 | 221 | 422 | 5 | 2022-11-27 | 60.56 | 1.51 | 2022-11-15 | 3 | 13.88 | 1 | 60.56 | 12 | SO47040 | 2022-11-22 | 4.84 | 41.63 | 20.19 | |||
| SO50306_36 | D376-4A40-86 | PO5858194676 | 100 | 285 | 230 | 566 | 5 | 2023-08-27 | 144.20 | 3.61 | 2023-08-15 | 5 | 29.08 | 1 | 144.20 | 36 | SO50306 | 2023-08-22 | 11.54 | 145.40 | 28.84 | |||
| SO44488_23 | 18BD-4C15-81 | PO19546136242 | 100 | 285 | 314 | 206 | 5 | 2022-02-27 | 2146.96 | 53.67 | 2022-02-15 | 1 | 2171.29 | 1 | 2146.96 | 23 | SO44488 | 2022-02-22 | 171.76 | 2171.29 | 2146.96 | |||
| SO46387_11 | 5AA4-4F68-A1 | PO9599173396 | 100 | 285 | 313 | 170 | 5 | 2022-09-27 | 4293.92 | 107.35 | 2022-09-15 | 2 | 2171.29 | 1 | 4293.92 | 11 | SO46387 | 2022-09-22 | 343.51 | 4342.59 | 2146.96 | |||
| SO47725_17 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 381 | 81 | 5 | 2023-01-27 | 1800.79 | 45.02 | 2023-01-15 | 3 | 605.65 | 1 | 1800.79 | 17 | SO47725 | 2023-01-22 | 144.06 | 1816.95 | 600.26 | |||
| SO51147_14 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 436 | 81 | 5 | 2023-10-27 | 713.80 | 17.84 | 2023-10-15 | 2 | 360.94 | 1 | 713.80 | 14 | SO51147 | 2023-10-22 | 57.10 | 721.89 | 356.90 | |||
| SO71948_20 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 582 | 170 | 5 | 2024-09-27 | 5102.97 | 127.57 | 2024-09-15 | 5 | 1082.51 | 1 | 5102.97 | 20 | SO71948 | 2024-09-22 | 408.24 | 5412.55 | 1020.59 | |||
| SO46996_8 | 775B-42D6-A5 | PO11571149031 | 100 | 285 | 331 | 512 | 5 | 2022-11-27 | 1409.38 | 35.23 | 2022-11-15 | 3 | 486.71 | 1 | 1409.38 | 8 | SO46996 | 2022-11-22 | 112.75 | 1460.12 | 469.79 | |||
| SO50307_9 | C275-40B9-98 | PO6293157460 | 100 | 285 | 435 | 612 | 5 | 2023-08-27 | 973.36 | 24.33 | 2023-08-15 | 3 | 300.12 | 1 | 973.36 | 9 | SO50307 | 2023-08-22 | 77.87 | 900.36 | 324.45 | |||
| SO43676_5 | 11BA-4D19-B7 | PO11861165059 | 100 | 281 | 218 | 17 | 5 | 2021-10-27 | 22.80 | 0.57 | 2021-10-15 | 4 | 3.40 | 1 | 22.80 | 5 | SO43676 | 2021-10-22 | 1.82 | 13.59 | 5.70 | |||
| SO44555_1 | 51FA-451D-A2 | PO6293176988 | 100 | 285 | 332 | 612 | 5 | 2022-02-27 | 1258.38 | 31.46 | 2022-02-15 | 3 | 413.15 | 1 | 1258.38 | 1 | SO44555 | 2022-02-22 | 100.67 | 1239.44 | 419.46 |
Generated 2024-11-14 04:38:02.655 UTC