[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE < SKIP 807 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49888_43 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 435 | 234 | 2 | 2023-06-03 | 648.91 | 16.22 | 2023-05-22 | 2 | 300.12 | 1 | 648.91 | 43 | SO49888 | 2023-05-29 | 51.91 | 600.24 | 324.45 | |||
SO67314_16 | 6653-491A-80 | PO3828116396 | 100 | 283 | 357 | 414 | 2 | 2024-06-03 | 2783.99 | 69.60 | 2024-05-22 | 2 | 1265.62 | 1 | 2783.99 | 16 | SO67314 | 2024-05-29 | 222.72 | 2531.24 | 1391.99 | |||
SO45517_6 | 1980-4886-B0 | PO20213190120 | 100 | 281 | 328 | 216 | 2 | 2022-05-03 | 1677.84 | 41.95 | 2022-04-21 | 4 | 413.15 | 1 | 1677.84 | 6 | SO45517 | 2022-04-28 | 134.23 | 1652.59 | 419.46 | |||
SO46666_30 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 417 | 234 | 2 | 2022-09-02 | 973.36 | 24.33 | 2022-08-21 | 3 | 300.12 | 1 | 973.36 | 30 | SO46666 | 2022-08-28 | 77.87 | 900.36 | 324.45 | |||
SO50235_26 | 20B9-4308-A5 | PO10121141993 | 100 | 283 | 329 | 684 | 2 | 2023-07-03 | 469.79 | 11.74 | 2023-06-21 | 1 | 486.71 | 1 | 469.79 | 26 | SO50235 | 2023-06-28 | 37.58 | 486.71 | 469.79 | |||
SO50290_16 | 241B-4766-8D | PO3625125287 | 100 | 283 | 242 | 666 | 2 | 2023-07-03 | 3123.27 | 78.08 | 2023-06-21 | 4 | 722.26 | 1 | 3123.27 | 16 | SO50290 | 2023-06-28 | 249.86 | 2889.03 | 780.82 | |||
SO50259_10 | 2D7F-444F-AE | PO18386133550 | 100 | 283 | 460 | 558 | 2 | 2023-07-03 | 323.96 | 8.10 | 2023-06-21 | 6 | 37.12 | 1 | 323.96 | 10 | SO50259 | 2023-06-28 | 25.92 | 222.73 | 53.99 | |||
SO47450_27 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 341 | 54 | 2 | 2022-11-03 | 469.79 | 11.74 | 2022-10-22 | 1 | 486.71 | 1 | 469.79 | 27 | SO47450 | 2022-10-29 | 37.58 | 486.71 | 469.79 | |||
SO46994_21 | 5E92-4A19-9E | PO11629171210 | 100 | 281 | 294 | 396 | 2 | 2022-10-03 | 2232.82 | 55.82 | 2022-09-21 | 3 | 660.91 | 1 | 2232.82 | 21 | SO46994 | 2022-09-28 | 178.63 | 1982.74 | 744.27 | |||
SO53570_19 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 434 | 54 | 2 | 2023-11-03 | 1427.59 | 35.69 | 2023-10-22 | 4 | 360.94 | 1 | 1427.59 | 19 | SO53570 | 2023-10-29 | 114.21 | 1443.77 | 356.90 | |||
SO61239_22 | 6459-4F99-96 | PO3828136274 | 100 | 283 | 488 | 414 | 2 | 2024-03-04 | 129.58 | 3.24 | 2024-02-21 | 4 | 41.57 | 1 | 129.58 | 22 | SO61239 | 2024-02-28 | 10.37 | 166.29 | 32.39 | |||
SO48776_9 | 81D9-4651-84 | PO3828123354 | 100 | 283 | 393 | 414 | 2 | 2023-03-05 | 275.39 | 6.88 | 2023-02-21 | 2 | 101.89 | 1 | 275.39 | 9 | SO48776 | 2023-02-28 | 22.03 | 203.79 | 137.69 | |||
SO59012_16 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 578 | 539 | 2 | 2024-02-02 | 728.91 | 18.22 | 2024-01-21 | 1 | 755.15 | 1 | 728.91 | 16 | SO59012 | 2024-01-28 | 58.31 | 755.15 | 728.91 | |||
SO67263_4 | EFEC-4A80-8F | PO17197178016 | 100 | 283 | 600 | 125 | 2 | 2024-06-03 | 971.98 | 24.30 | 2024-05-22 | 3 | 294.58 | 1 | 971.98 | 4 | SO67263 | 2024-05-29 | 77.76 | 883.74 | 323.99 | |||
SO59012_39 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 471 | 2 | 539 | 2 | 9.58 | 2024-02-02 | 478.79 | 11.73 | 2024-01-21 | 13 | 23.75 | 1 | 469.21 | 39 | SO59012 | 2024-01-28 | 37.54 | 308.74 | 36.83 | 0.02 |
SO47432_5 | 781D-4AED-A2 | PO4756164192 | 100 | 281 | 458 | 126 | 2 | 2022-11-03 | 89.99 | 2.25 | 2022-10-22 | 2 | 30.93 | 1 | 89.99 | 5 | SO47432 | 2022-10-29 | 7.20 | 61.87 | 44.99 | |||
SO69462_3 | 05B6-4501-9B | PO1769122113 | 100 | 283 | 583 | 540 | 2 | 2024-07-03 | 2041.19 | 51.03 | 2024-06-21 | 2 | 1082.51 | 1 | 2041.19 | 3 | SO69462 | 2024-06-28 | 163.30 | 2165.02 | 1020.59 | |||
SO69467_4 | A38D-4E1B-93 | PO2871181396 | 100 | 283 | 586 | 522 | 2 | 2024-07-03 | 890.82 | 22.27 | 2024-06-21 | 2 | 461.44 | 1 | 890.82 | 4 | SO69467 | 2024-06-28 | 71.27 | 922.89 | 445.41 | |||
SO46620_41 | FEE3-4994-8E | PO13775143788 | 100 | 281 | 377 | 618 | 2 | 2022-09-02 | 3926.81 | 98.17 | 2022-08-21 | 3 | 1320.68 | 1 | 3926.81 | 41 | SO46620 | 2022-08-28 | 314.15 | 3962.05 | 1308.94 | |||
SO50727_4 | 5DD5-4A9A-B1 | PO9483181443 | 100 | 283 | 448 | 54 | 2 | 2023-08-03 | 23.99 | 0.60 | 2023-07-22 | 2 | 8.25 | 1 | 23.99 | 4 | SO50727 | 2023-07-29 | 1.92 | 16.49 | 11.99 | |||
SO48392_33 | B9C7-4F4D-82 | PO9483147187 | 100 | 281 | 381 | 54 | 2 | 2023-02-02 | 4201.84 | 105.05 | 2023-01-21 | 7 | 605.65 | 1 | 4201.84 | 33 | SO48392 | 2023-01-28 | 336.15 | 4239.54 | 600.26 | |||
SO53560_13 | 3D25-4203-A4 | PO7685199983 | 100 | 283 | 463 | 539 | 2 | 2023-11-03 | 146.94 | 3.67 | 2023-10-22 | 10 | 9.16 | 1 | 146.94 | 13 | SO53560 | 2023-10-29 | 11.76 | 91.59 | 14.69 | |||
SO44129_23 | CE0D-4824-A6 | PO9483186106 | 100 | 281 | 342 | 54 | 2 | 2021-11-03 | 1258.38 | 31.46 | 2021-10-22 | 3 | 413.15 | 1 | 1258.38 | 23 | SO44129 | 2021-10-29 | 100.67 | 1239.44 | 419.46 | |||
SO59075_16 | 1ED6-419E-AF | PO9628136689 | 100 | 283 | 487 | 179 | 2 | 2024-02-02 | 98.98 | 2.47 | 2024-01-21 | 3 | 20.57 | 1 | 98.98 | 16 | SO59075 | 2024-01-28 | 7.92 | 61.70 | 32.99 | |||
SO48776_5 | 81D9-4651-84 | PO3828123354 | 100 | 283 | 469 | 414 | 2 | 2023-03-05 | 45.59 | 1.14 | 2023-02-21 | 2 | 15.67 | 1 | 45.59 | 5 | SO48776 | 2023-02-28 | 3.65 | 31.34 | 22.79 | |||
SO55301_49 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 359 | 414 | 2 | 2023-12-03 | 4130.98 | 103.27 | 2023-11-21 | 3 | 1251.98 | 1 | 4130.98 | 49 | SO55301 | 2023-11-28 | 330.48 | 3755.94 | 1376.99 | |||
SO47675_14 | 8515-427F-B6 | PO13775136623 | 100 | 281 | 271 | 618 | 2 | 2022-12-03 | 404.66 | 10.12 | 2022-11-21 | 2 | 187.16 | 1 | 404.66 | 14 | SO47675 | 2022-11-28 | 32.37 | 374.31 | 202.33 | |||
SO53570_25 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 240 | 54 | 2 | 2023-11-03 | 1717.80 | 42.95 | 2023-10-22 | 2 | 868.63 | 1 | 1717.80 | 25 | SO53570 | 2023-10-29 | 137.42 | 1737.27 | 858.90 |
Generated 2024-09-20 16:32:06.240 UTC