[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 2875 SHUFFLE < SKIP 783 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO58958_17 | BC3F-443F-B5 | PO10875118816 | 19 | 291 | 488 | 281 | 6 | 2024-02-03 | 64.79 | 1.62 | 2024-01-22 | 2 | 41.57 | 1 | 64.79 | 17 | SO58958 | 2024-01-29 | 5.18 | 83.14 | 32.39 | |||
SO50716_34 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 445 | 118 | 6 | 2023-08-04 | 71.99 | 1.80 | 2023-07-23 | 2 | 24.75 | 1 | 71.99 | 34 | SO50716 | 2023-07-30 | 5.76 | 49.49 | 35.99 | |||
SO46086_3 | 56A8-4607-A0 | PO4901123378 | 19 | 284 | 232 | 2 | 84 | 6 | 7.25 | 2022-07-04 | 362.43 | 8.88 | 2022-06-22 | 13 | 31.72 | 1 | 355.18 | 3 | SO46086 | 2022-06-29 | 28.41 | 412.42 | 27.88 | 0.02 |
SO53536_8 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 542 | 118 | 6 | 2023-11-04 | 24.29 | 0.61 | 2023-10-23 | 1 | 17.98 | 1 | 24.29 | 8 | SO53536 | 2023-10-30 | 1.94 | 17.98 | 24.29 | |||
SO49856_35 | 6ADC-4789-8A | PO18444116791 | 19 | 291 | 381 | 227 | 6 | 2023-06-04 | 3601.58 | 90.04 | 2023-05-23 | 6 | 605.65 | 1 | 3601.58 | 35 | SO49856 | 2023-05-30 | 288.13 | 3633.90 | 600.26 | |||
SO57019_1 | D018-44A0-BF | PO18879140423 | 19 | 291 | 556 | 64 | 6 | 2024-01-04 | 105.29 | 2.63 | 2023-12-23 | 1 | 77.92 | 1 | 105.29 | 1 | SO57019 | 2023-12-30 | 8.42 | 77.92 | 105.29 | |||
SO71829_23 | 427E-46EE-B0 | PO10962123279 | 19 | 284 | 512 | 685 | 6 | 2024-08-04 | 655.36 | 16.38 | 2024-07-23 | 3 | 199.38 | 1 | 655.36 | 23 | SO71829 | 2024-07-30 | 52.43 | 598.13 | 218.45 | |||
SO47366_28 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 433 | 155 | 6 | 2022-11-04 | 1946.72 | 48.67 | 2022-10-23 | 6 | 300.12 | 1 | 1946.72 | 28 | SO47366 | 2022-10-30 | 155.74 | 1800.71 | 324.45 | |||
SO51850_14 | 57A9-4C32-8B | PO1856170170 | 19 | 291 | 467 | 263 | 6 | 2023-10-04 | 88.16 | 2.20 | 2023-09-22 | 6 | 9.16 | 1 | 88.16 | 14 | SO51850 | 2023-09-29 | 7.05 | 54.96 | 14.69 | |||
SO65174_35 | E2AA-4EEC-93 | PO17574133893 | 19 | 291 | 234 | 678 | 6 | 2024-05-04 | 179.96 | 4.50 | 2024-04-22 | 6 | 38.49 | 1 | 179.96 | 35 | SO65174 | 2024-04-29 | 14.40 | 230.95 | 29.99 | |||
SO53503_6 | 3066-4F29-8B | PO11165175744 | 19 | 291 | 511 | 586 | 6 | 2023-11-04 | 436.91 | 10.92 | 2023-10-23 | 2 | 199.38 | 1 | 436.91 | 6 | SO53503 | 2023-10-30 | 34.95 | 398.75 | 218.45 | |||
SO51793_39 | D763-4929-9B | PO18705168707 | 19 | 291 | 388 | 479 | 6 | 2023-10-04 | 1344.59 | 33.61 | 2023-09-22 | 2 | 713.08 | 1 | 1344.59 | 39 | SO51793 | 2023-09-29 | 107.57 | 1426.16 | 672.29 | |||
SO67316_48 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 552 | 496 | 6 | 2024-06-04 | 384.26 | 9.61 | 2024-05-23 | 7 | 40.62 | 1 | 384.26 | 48 | SO67316 | 2024-05-30 | 30.74 | 284.35 | 54.89 | |||
SO63176_5 | 2922-4BD0-90 | PO1595183976 | 19 | 284 | 374 | 426 | 6 | 2024-04-05 | 1466.01 | 36.65 | 2024-03-24 | 1 | 1554.95 | 1 | 1466.01 | 5 | SO63176 | 2024-03-31 | 117.28 | 1554.95 | 1466.01 | |||
SO49066_17 | 4065-4B0A-A2 | PO1595117888 | 19 | 284 | 216 | 426 | 6 | 2023-04-06 | 80.75 | 2.02 | 2023-03-25 | 4 | 13.88 | 1 | 80.75 | 17 | SO49066 | 2023-04-01 | 6.46 | 55.51 | 20.19 | |||
SO58980_11 | 8985-4B66-AD | PO18502175539 | 19 | 291 | 560 | 154 | 6 | 2024-02-03 | 1457.82 | 36.45 | 2024-01-22 | 2 | 755.15 | 1 | 1457.82 | 11 | SO58980 | 2024-01-29 | 116.63 | 1510.30 | 728.91 | |||
SO46940_49 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 242 | 479 | 6 | 2022-10-04 | 780.82 | 19.52 | 2022-09-22 | 1 | 722.26 | 1 | 780.82 | 49 | SO46940 | 2022-09-29 | 62.47 | 722.26 | 780.82 | |||
SO49480_1 | BA71-43B7-82 | PO19401115391 | 19 | 291 | 458 | 173 | 6 | 2023-05-04 | 134.98 | 3.37 | 2023-04-22 | 3 | 30.93 | 1 | 134.98 | 1 | SO49480 | 2023-04-29 | 10.80 | 92.80 | 44.99 | |||
SO57022_6 | 9202-4FEB-88 | PO17806175482 | 19 | 291 | 546 | 101 | 6 | 2024-01-04 | 111.76 | 2.79 | 2023-12-23 | 3 | 27.57 | 1 | 111.76 | 6 | SO57022 | 2023-12-30 | 8.94 | 82.70 | 37.25 | |||
SO67304_9 | 5E78-4926-A4 | PO18444191982 | 19 | 291 | 545 | 227 | 6 | 2024-06-04 | 97.18 | 2.43 | 2024-05-23 | 4 | 17.98 | 1 | 97.18 | 9 | SO67304 | 2024-05-30 | 7.77 | 71.91 | 24.29 | |||
SO46950_8 | AAC1-43D9-A3 | PO17806144306 | 19 | 291 | 286 | 101 | 6 | 2022-10-04 | 183.94 | 4.60 | 2022-09-22 | 1 | 170.14 | 1 | 183.94 | 8 | SO46950 | 2022-09-29 | 14.72 | 170.14 | 183.94 | |||
SO46359_19 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 317 | 460 | 6 | 2022-08-04 | 5248.76 | 131.22 | 2022-07-23 | 6 | 884.71 | 1 | 5248.76 | 19 | SO46359 | 2022-07-30 | 419.90 | 5308.25 | 874.79 | |||
SO50233_3 | 1FF6-48A6-A7 | PO10469158272 | 19 | 291 | 470 | 335 | 6 | 2023-07-04 | 68.38 | 1.71 | 2023-06-22 | 3 | 15.67 | 1 | 68.38 | 3 | SO50233 | 2023-06-29 | 5.47 | 47.01 | 22.79 | |||
SO50716_20 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 356 | 118 | 6 | 2023-08-04 | 2485.70 | 62.14 | 2023-07-23 | 2 | 1117.86 | 1 | 2485.70 | 20 | SO50716 | 2023-07-30 | 198.86 | 2235.71 | 1242.85 | |||
SO58981_48 | 2B52-4247-AF | PO18299143459 | 19 | 291 | 601 | 118 | 6 | 2024-02-03 | 97.18 | 2.43 | 2024-01-22 | 3 | 23.97 | 1 | 97.18 | 48 | SO58981 | 2024-01-29 | 7.77 | 71.91 | 32.39 | |||
SO71794_9 | C39A-4835-99 | PO17574111985 | 19 | 291 | 214 | 2 | 678 | 6 | 5.68 | 2024-08-04 | 284.12 | 6.96 | 2024-07-23 | 14 | 13.09 | 1 | 278.44 | 9 | SO71794 | 2024-07-30 | 22.27 | 183.21 | 20.29 | 0.02 |
SO46326_16 | EDD8-4703-B2 | PO19401160698 | 19 | 288 | 334 | 173 | 6 | 2022-08-04 | 419.46 | 10.49 | 2022-07-23 | 1 | 413.15 | 1 | 419.46 | 16 | SO46326 | 2022-07-30 | 33.56 | 413.15 | 419.46 | |||
SO46607_43 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 329 | 2 | 227 | 6 | 127.16 | 2022-09-03 | 6357.88 | 155.77 | 2022-08-22 | 14 | 486.71 | 1 | 6230.72 | 43 | SO46607 | 2022-08-29 | 498.46 | 6813.89 | 454.13 | 0.02 |
SO51694_6 | 75B1-457C-8C | PO19691118743 | 19 | 291 | 475 | 353 | 6 | 2023-10-04 | 83.99 | 2.10 | 2023-09-22 | 2 | 26.18 | 1 | 83.99 | 6 | SO51694 | 2023-09-29 | 6.72 | 52.35 | 41.99 | |||
SO71794_16 | C39A-4835-99 | PO17574111985 | 19 | 291 | 472 | 2 | 678 | 6 | 9.58 | 2024-08-04 | 478.79 | 11.73 | 2024-07-23 | 13 | 23.75 | 1 | 469.21 | 16 | SO71794 | 2024-07-30 | 37.54 | 308.74 | 36.83 | 0.02 |
SO55245_4 | B5AD-476D-B4 | PO14732112185 | 19 | 291 | 546 | 514 | 6 | 2023-12-04 | 37.25 | 0.93 | 2023-11-22 | 1 | 27.57 | 1 | 37.25 | 4 | SO55245 | 2023-11-29 | 2.98 | 27.57 | 37.25 |
Generated 2024-09-21 12:47:48.618 UTC