[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 2562 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO58911_8 | C991-4920-91 | PO19401135315 | 19 | 291 | 376 | 173 | 6 | 2024-02-02 | 4398.03 | 109.95 | 2024-01-21 | 3 | 1554.95 | 1 | 4398.03 | 8 | SO58911 | 2024-01-28 | 351.84 | 4664.84 | 1466.01 | |||
SO67304_6 | 5E78-4926-A4 | PO18444191982 | 19 | 291 | 374 | 227 | 6 | 2024-06-03 | 1466.01 | 36.65 | 2024-05-22 | 1 | 1554.95 | 1 | 1466.01 | 6 | SO67304 | 2024-05-29 | 117.28 | 1554.95 | 1466.01 | |||
SO45323_16 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 338 | 84 | 6 | 2022-04-05 | 419.46 | 10.49 | 2022-03-24 | 1 | 413.15 | 1 | 419.46 | 16 | SO45323 | 2022-03-31 | 33.56 | 413.15 | 419.46 | |||
SO71794_52 | C39A-4835-99 | PO17574111985 | 19 | 291 | 234 | 678 | 6 | 2024-08-03 | 59.99 | 1.50 | 2024-07-22 | 2 | 38.49 | 1 | 59.99 | 52 | SO71794 | 2024-07-29 | 4.80 | 76.98 | 29.99 | |||
SO50284_2 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 221 | 84 | 6 | 2023-07-03 | 121.12 | 3.03 | 2023-06-21 | 6 | 13.88 | 1 | 121.12 | 2 | SO50284 | 2023-06-28 | 9.69 | 83.27 | 20.19 | |||
SO53456_18 | 9F7E-451F-8E | PO19401178762 | 19 | 291 | 547 | 173 | 6 | 2023-11-03 | 242.97 | 6.07 | 2023-10-22 | 5 | 35.96 | 1 | 242.97 | 18 | SO53456 | 2023-10-29 | 19.44 | 179.80 | 48.59 | |||
SO71808_6 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 217 | 2 | 408 | 6 | 5.28 | 2024-08-03 | 263.82 | 6.46 | 2024-07-22 | 13 | 13.09 | 1 | 258.55 | 6 | SO71808 | 2024-07-29 | 20.68 | 170.12 | 20.29 | 0.02 |
SO44533_5 | 6A24-4735-B2 | PO1827111566 | 19 | 288 | 275 | 317 | 6 | 2022-01-03 | 356.90 | 8.92 | 2021-12-22 | 1 | 352.14 | 1 | 356.90 | 5 | SO44533 | 2021-12-29 | 28.55 | 352.14 | 356.90 | |||
SO51160_45 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 463 | 496 | 6 | 2023-09-02 | 102.86 | 2.57 | 2023-08-21 | 7 | 9.16 | 1 | 102.86 | 45 | SO51160 | 2023-08-28 | 8.23 | 64.12 | 14.69 | |||
SO71847_26 | 3A74-467E-8B | PO18502143784 | 19 | 291 | 500 | 154 | 6 | 2024-08-03 | 3614.08 | 90.35 | 2024-07-22 | 6 | 601.74 | 1 | 3614.08 | 26 | SO71847 | 2024-07-29 | 289.13 | 3610.46 | 602.35 | |||
SO45305_8 | AC1B-4242-9C | PO11600132440 | 19 | 288 | 338 | 569 | 6 | 2022-04-05 | 419.46 | 10.49 | 2022-03-24 | 1 | 413.15 | 1 | 419.46 | 8 | SO45305 | 2022-03-31 | 33.56 | 413.15 | 419.46 | |||
SO47662_41 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 213 | 442 | 6 | 2022-12-03 | 20.19 | 0.50 | 2022-11-21 | 1 | 13.88 | 1 | 20.19 | 41 | SO47662 | 2022-11-28 | 1.61 | 13.88 | 20.19 | |||
SO71794_44 | C39A-4835-99 | PO17574111985 | 19 | 291 | 516 | 678 | 6 | 2024-08-03 | 164.39 | 4.11 | 2024-07-22 | 7 | 17.38 | 1 | 164.39 | 44 | SO71794 | 2024-07-29 | 13.15 | 121.65 | 23.48 | |||
SO69401_21 | 5377-4B5B-80 | PO17603155358 | 19 | 284 | 237 | 12 | 6 | 2024-07-03 | 29.99 | 0.75 | 2024-06-21 | 1 | 38.49 | 1 | 29.99 | 21 | SO69401 | 2024-06-28 | 2.40 | 38.49 | 29.99 | |||
SO50668_21 | A5FC-4831-B4 | PO17574113752 | 19 | 291 | 447 | 678 | 6 | 2023-08-03 | 45.00 | 1.13 | 2023-07-22 | 3 | 10.31 | 1 | 45.00 | 21 | SO50668 | 2023-07-29 | 3.60 | 30.94 | 15.00 | |||
SO49484_6 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 233 | 118 | 6 | 2023-05-03 | 144.20 | 3.61 | 2023-04-21 | 5 | 29.08 | 1 | 144.20 | 6 | SO49484 | 2023-04-28 | 11.54 | 145.40 | 28.84 | |||
SO67268_15 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 547 | 299 | 6 | 2024-06-03 | 145.78 | 3.64 | 2024-05-22 | 3 | 35.96 | 1 | 145.78 | 15 | SO67268 | 2024-05-29 | 11.66 | 107.88 | 48.59 | |||
SO49484_7 | B25F-4DF4-8E | PO18299142683 | 19 | 291 | 221 | 118 | 6 | 2023-05-03 | 121.12 | 3.03 | 2023-04-21 | 6 | 13.88 | 1 | 121.12 | 7 | SO49484 | 2023-04-28 | 9.69 | 83.27 | 20.19 | |||
SO61177_12 | DA64-4BC0-A0 | PO18473117778 | 19 | 291 | 532 | 442 | 6 | 2024-03-04 | 449.62 | 11.24 | 2024-02-21 | 3 | 136.79 | 1 | 449.62 | 12 | SO61177 | 2024-02-28 | 35.97 | 410.36 | 149.87 | |||
SO50242_24 | A651-4343-86 | PO1595193228 | 19 | 284 | 375 | 426 | 6 | 2023-07-03 | 1308.94 | 32.72 | 2023-06-21 | 1 | 1320.68 | 1 | 1308.94 | 24 | SO50242 | 2023-06-28 | 104.72 | 1320.68 | 1308.94 | |||
SO45527_23 | 610E-44BC-87 | PO17545114353 | 19 | 288 | 320 | 155 | 6 | 2022-05-03 | 2516.75 | 62.92 | 2022-04-21 | 6 | 413.15 | 1 | 2516.75 | 23 | SO45527 | 2022-04-28 | 201.34 | 2478.88 | 419.46 | |||
SO55297_29 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 357 | 496 | 6 | 2023-12-03 | 8351.96 | 208.80 | 2023-11-21 | 6 | 1265.62 | 1 | 8351.96 | 29 | SO55297 | 2023-11-28 | 668.16 | 7593.72 | 1391.99 | |||
SO46953_7 | C650-4C32-BE | PO17603154442 | 19 | 284 | 466 | 12 | 6 | 2022-10-03 | 28.26 | 0.71 | 2022-09-21 | 2 | 9.71 | 1 | 28.26 | 7 | SO46953 | 2022-09-28 | 2.26 | 19.43 | 14.13 | |||
SO45313_16 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 253 | 317 | 6 | 2022-04-05 | 357.16 | 8.93 | 2022-03-24 | 2 | 176.20 | 1 | 357.16 | 16 | SO45313 | 2022-03-31 | 28.57 | 352.40 | 178.58 | |||
SO55275_28 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 363 | 245 | 6 | 2023-12-03 | 5507.98 | 137.70 | 2023-11-21 | 4 | 1251.98 | 1 | 5507.98 | 28 | SO55275 | 2023-11-28 | 440.64 | 5007.93 | 1376.99 | |||
SO51793_43 | D763-4929-9B | PO18705168707 | 19 | 291 | 384 | 479 | 6 | 2023-10-03 | 2016.88 | 50.42 | 2023-09-21 | 3 | 713.08 | 1 | 2016.88 | 43 | SO51793 | 2023-09-28 | 161.35 | 2139.24 | 672.29 | |||
SO45272_3 | 72C5-49C2-BA | PO19227144019 | 19 | 284 | 322 | 210 | 6 | 2022-04-05 | 1677.84 | 41.95 | 2022-03-24 | 4 | 413.15 | 1 | 1677.84 | 3 | SO45272 | 2022-03-31 | 134.23 | 1652.59 | 419.46 | |||
SO47662_43 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 236 | 442 | 6 | 2022-12-03 | 201.88 | 5.05 | 2022-11-21 | 7 | 29.08 | 1 | 201.88 | 43 | SO47662 | 2022-11-28 | 16.15 | 203.56 | 28.84 | |||
SO47668_25 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 383 | 299 | 6 | 2022-12-03 | 1200.53 | 30.01 | 2022-11-21 | 2 | 605.65 | 1 | 1200.53 | 25 | SO47668 | 2022-11-28 | 96.04 | 1211.30 | 600.26 | |||
SO46930_19 | 73DA-4549-8B | PO20039167979 | 19 | 291 | 216 | 65 | 6 | 2022-10-03 | 40.37 | 1.01 | 2022-09-21 | 2 | 13.88 | 1 | 40.37 | 19 | SO46930 | 2022-09-28 | 3.23 | 27.76 | 20.19 | |||
SO55297_42 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 472 | 2 | 496 | 6 | 9.58 | 2023-12-03 | 478.79 | 11.73 | 2023-11-21 | 13 | 23.75 | 1 | 469.21 | 42 | SO55297 | 2023-11-28 | 37.54 | 308.74 | 36.83 | 0.02 |
Generated 2024-09-20 03:49:31.515 UTC