[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE SKIP 2000 < SKIP 967 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO69462_5 | 05B6-4501-9B | PO1769122113 | 100 | 283 | 482 | 540 | 2 | 2024-08-23 | 32.36 | 0.81 | 2024-08-11 | 6 | 3.36 | 1 | 32.36 | 5 | SO69462 | 2024-08-18 | 2.59 | 20.17 | 5.39 | |||
| SO45803_7 | 6F0B-4638-93 | PO1566112039 | 100 | 281 | 342 | 486 | 2 | 2022-07-24 | 1258.38 | 31.46 | 2022-07-12 | 3 | 413.15 | 1 | 1258.38 | 7 | SO45803 | 2022-07-19 | 100.67 | 1239.44 | 419.46 | |||
| SO45561_7 | D3C4-4FED-A4 | PO4408154584 | 100 | 281 | 328 | 143 | 2 | 2022-06-23 | 838.92 | 20.97 | 2022-06-11 | 2 | 413.15 | 1 | 838.92 | 7 | SO45561 | 2022-06-18 | 67.11 | 826.29 | 419.46 | |||
| SO47432_9 | 781D-4AED-A2 | PO4756164192 | 100 | 281 | 327 | 126 | 2 | 2022-12-24 | 469.79 | 11.74 | 2022-12-12 | 1 | 486.71 | 1 | 469.79 | 9 | SO47432 | 2022-12-19 | 37.58 | 486.71 | 469.79 | |||
| SO47718_17 | B391-4A07-98 | PO6699137967 | 100 | 281 | 333 | 234 | 2 | 2023-01-23 | 3758.35 | 93.96 | 2023-01-11 | 8 | 486.71 | 1 | 3758.35 | 17 | SO47718 | 2023-01-18 | 300.67 | 3893.65 | 469.79 | |||
| SO46666_9 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 407 | 234 | 2 | 2022-10-23 | 459.21 | 11.48 | 2022-10-11 | 7 | 48.55 | 1 | 459.21 | 9 | SO46666 | 2022-10-18 | 36.74 | 339.82 | 65.60 | |||
| SO57065_32 | B68A-407E-99 | PO11658151711 | 100 | 283 | 237 | 233 | 2 | 2024-02-23 | 149.97 | 3.75 | 2024-02-11 | 5 | 38.49 | 1 | 149.97 | 32 | SO57065 | 2024-02-18 | 12.00 | 192.46 | 29.99 | |||
| SO50243_1 | A9CB-4732-9E | PO1769116006 | 100 | 283 | 433 | 540 | 2 | 2023-08-23 | 973.36 | 24.33 | 2023-08-11 | 3 | 300.12 | 1 | 973.36 | 1 | SO50243 | 2023-08-18 | 77.87 | 900.36 | 324.45 | |||
| SO51101_38 | 5853-46B4-AC | PO13775166153 | 100 | 283 | 217 | 11 | 618 | 2 | 9.45 | 2023-10-23 | 62.98 | 1.34 | 2023-10-11 | 4 | 13.09 | 1 | 53.53 | 38 | SO51101 | 2023-10-18 | 4.28 | 52.35 | 15.75 | 0.15 |
| SO55261_9 | 130D-46E9-9B | PO11484193890 | 100 | 283 | 587 | 594 | 2 | 2024-01-23 | 461.69 | 11.54 | 2024-01-11 | 1 | 419.78 | 1 | 461.69 | 9 | SO55261 | 2024-01-18 | 36.94 | 419.78 | 461.69 | |||
| SO44531_19 | E4D9-426B-8B | PO10121174343 | 100 | 281 | 322 | 684 | 2 | 2022-02-23 | 1677.84 | 41.95 | 2022-02-11 | 4 | 413.15 | 1 | 1677.84 | 19 | SO44531 | 2022-02-18 | 134.23 | 1652.59 | 419.46 | |||
| SO49518_2 | AF02-4E4D-BA | PO9483189305 | 100 | 283 | 213 | 54 | 2 | 2023-06-23 | 100.93 | 2.52 | 2023-06-11 | 5 | 13.88 | 1 | 100.93 | 2 | SO49518 | 2023-06-18 | 8.07 | 69.39 | 20.19 | |||
| SO47975_30 | 5E8C-4BD8-B5 | PO18386179371 | 100 | 281 | 453 | 558 | 2 | 2023-02-23 | 71.99 | 1.80 | 2023-02-11 | 2 | 24.75 | 1 | 71.99 | 30 | SO47975 | 2023-02-18 | 5.76 | 49.49 | 35.99 | |||
| SO48776_2 | 81D9-4651-84 | PO3828123354 | 100 | 283 | 362 | 414 | 2 | 2023-04-25 | 1229.46 | 30.74 | 2023-04-13 | 1 | 1105.81 | 1 | 1229.46 | 2 | SO48776 | 2023-04-20 | 98.36 | 1105.81 | 1229.46 | |||
| SO51741_7 | 96BB-4004-AE | PO12383191952 | 100 | 283 | 545 | 89 | 2 | 2023-11-23 | 48.59 | 1.21 | 2023-11-11 | 2 | 17.98 | 1 | 48.59 | 7 | SO51741 | 2023-11-18 | 3.89 | 35.96 | 24.29 | |||
| SO71947_8 | 7269-4186-92 | PO9628115897 | 100 | 283 | 570 | 179 | 2 | 2024-09-23 | 890.82 | 22.27 | 2024-09-11 | 2 | 461.44 | 1 | 890.82 | 8 | SO71947 | 2024-09-18 | 71.27 | 922.89 | 445.41 | |||
| SO50280_41 | 7938-4E14-A7 | PO11658187917 | 100 | 283 | 445 | 233 | 2 | 2023-08-23 | 107.98 | 2.70 | 2023-08-11 | 3 | 24.75 | 1 | 107.98 | 41 | SO50280 | 2023-08-18 | 8.64 | 74.24 | 35.99 | |||
| SO50311_37 | E09E-4D02-9F | PO7453115958 | 100 | 283 | 389 | 108 | 2 | 2023-08-23 | 1800.79 | 45.02 | 2023-08-11 | 3 | 605.65 | 1 | 1800.79 | 37 | SO50311 | 2023-08-18 | 144.06 | 1816.95 | 600.26 | |||
| SO67284_22 | 8286-4B8D-89 | PO11484111023 | 100 | 283 | 357 | 594 | 2 | 2024-07-24 | 1391.99 | 34.80 | 2024-07-12 | 1 | 1265.62 | 1 | 1391.99 | 22 | SO67284 | 2024-07-19 | 111.36 | 1265.62 | 1391.99 | |||
| SO69544_16 | 89F3-4833-92 | PO3625111592 | 100 | 283 | 376 | 666 | 2 | 2024-08-23 | 2932.02 | 73.30 | 2024-08-11 | 2 | 1554.95 | 1 | 2932.02 | 16 | SO69544 | 2024-08-18 | 234.56 | 3109.90 | 1466.01 | |||
| SO46054_3 | 425B-4504-93 | PO14326187575 | 100 | 281 | 326 | 107 | 2 | 2022-08-23 | 419.46 | 10.49 | 2022-08-11 | 1 | 413.15 | 1 | 419.46 | 3 | SO46054 | 2022-08-18 | 33.56 | 413.15 | 419.46 | |||
| SO47395_27 | 98F1-44B4-97 | PO11455133549 | 100 | 281 | 389 | 3 | 72 | 2 | 440.19 | 2022-12-24 | 8803.85 | 209.09 | 2022-12-12 | 16 | 605.65 | 1 | 8363.66 | 27 | SO47395 | 2022-12-19 | 669.09 | 9690.39 | 550.24 | 0.05 |
| SO49479_1 | 12BA-4BD1-BB | PO11455112131 | 100 | 283 | 375 | 72 | 2 | 2023-06-23 | 11780.44 | 294.51 | 2023-06-11 | 9 | 1320.68 | 1 | 11780.44 | 1 | SO49479 | 2023-06-18 | 942.44 | 11886.15 | 1308.94 | |||
| SO65237_8 | 5F94-404B-AE | PO11455137092 | 100 | 283 | 546 | 72 | 2 | 2024-06-23 | 74.51 | 1.86 | 2024-06-11 | 2 | 27.57 | 1 | 74.51 | 8 | SO65237 | 2024-06-18 | 5.96 | 55.14 | 37.25 | |||
| SO44313_13 | 6613-4427-84 | PO5365138960 | 100 | 281 | 318 | 161 | 2 | 2022-01-23 | 874.79 | 21.87 | 2022-01-11 | 1 | 884.71 | 1 | 874.79 | 13 | SO44313 | 2022-01-18 | 69.98 | 884.71 | 874.79 | |||
| SO46620_20 | FEE3-4994-8E | PO13775143788 | 100 | 281 | 321 | 618 | 2 | 2022-10-23 | 469.79 | 11.74 | 2022-10-11 | 1 | 486.71 | 1 | 469.79 | 20 | SO46620 | 2022-10-18 | 37.58 | 486.71 | 469.79 | |||
| SO49117_3 | 9786-4FB8-81 | PO11629122690 | 100 | 283 | 420 | 396 | 2 | 2023-05-26 | 283.23 | 7.08 | 2023-05-14 | 2 | 104.80 | 1 | 283.23 | 3 | SO49117 | 2023-05-21 | 22.66 | 209.59 | 141.62 | |||
| SO50280_5 | 7938-4E14-A7 | PO11658187917 | 100 | 283 | 409 | 233 | 2 | 2023-08-23 | 418.51 | 10.46 | 2023-08-11 | 2 | 185.82 | 1 | 418.51 | 5 | SO50280 | 2023-08-18 | 33.48 | 371.64 | 209.26 | |||
| SO46948_39 | B040-4261-B3 | PO18386128096 | 100 | 281 | 464 | 558 | 2 | 2022-11-23 | 84.77 | 2.12 | 2022-11-11 | 6 | 9.71 | 1 | 84.77 | 39 | SO46948 | 2022-11-18 | 6.78 | 58.28 | 14.13 | |||
| SO61224_27 | 3D8E-4C8E-B7 | PO13775159907 | 100 | 283 | 374 | 618 | 2 | 2024-04-24 | 1466.01 | 36.65 | 2024-04-12 | 1 | 1554.95 | 1 | 1466.01 | 27 | SO61224 | 2024-04-19 | 117.28 | 1554.95 | 1466.01 | |||
| SO45575_21 | 358D-446A-9A | PO9483193232 | 100 | 281 | 334 | 54 | 2 | 2022-06-23 | 838.92 | 20.97 | 2022-06-11 | 2 | 413.15 | 1 | 838.92 | 21 | SO45575 | 2022-06-18 | 67.11 | 826.29 | 419.46 |
Generated 2024-11-10 07:42:43.858 UTC