[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SHUFFLE < SKIP 150 > < TAKE 24 >
24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71798_3 | AFA9-4B18-AD | PO16994135863 | 100 | 283 | 434 | 306 | 3 | 2024-09-23 | 356.90 | 8.92 | 2024-09-11 | 1 | 360.94 | 1 | 356.90 | 3 | SO71798 | 2024-09-18 | 28.55 | 360.94 | 356.90 | |||
SO47394_11 | 7FC9-4002-83 | PO12354143510 | 100 | 281 | 411 | 197 | 3 | 2022-12-24 | 376.25 | 9.41 | 2022-12-12 | 3 | 92.81 | 1 | 376.25 | 11 | SO47394 | 2022-12-19 | 30.10 | 278.42 | 125.42 | |||
SO53526_29 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 408 | 579 | 3 | 2023-12-24 | 72.16 | 1.80 | 2023-12-12 | 1 | 53.40 | 1 | 72.16 | 29 | SO53526 | 2023-12-19 | 5.77 | 53.40 | 72.16 | |||
SO44517_17 | 47C8-4635-A6 | PO13572181174 | 100 | 287 | 275 | 527 | 3 | 2022-02-23 | 356.90 | 8.92 | 2022-02-11 | 1 | 352.14 | 1 | 356.90 | 17 | SO44517 | 2022-02-18 | 28.55 | 352.14 | 356.90 | |||
SO53590_22 | E7FF-4C04-9E | PO4118162346 | 100 | 281 | 553 | 454 | 3 | 2023-12-24 | 55.31 | 1.38 | 2023-12-12 | 2 | 20.46 | 1 | 55.31 | 22 | SO53590 | 2023-12-19 | 4.42 | 40.93 | 27.65 | |||
SO53471_21 | 7B7E-4C32-B2 | PO16994189676 | 100 | 283 | 382 | 306 | 3 | 2023-12-24 | 1344.59 | 33.61 | 2023-12-12 | 2 | 713.08 | 1 | 1344.59 | 21 | SO53471 | 2023-12-19 | 107.57 | 1426.16 | 672.29 | |||
SO45298_4 | 7EEC-41A1-9E | PO13572147445 | 100 | 287 | 316 | 527 | 3 | 2022-05-26 | 1749.59 | 43.74 | 2022-05-14 | 2 | 884.71 | 1 | 1749.59 | 4 | SO45298 | 2022-05-21 | 139.97 | 1769.42 | 874.79 | |||
SO46931_13 | EE3D-4B0A-B6 | PO19923131204 | 100 | 281 | 411 | 18 | 3 | 2022-11-23 | 250.83 | 6.27 | 2022-11-11 | 2 | 92.81 | 1 | 250.83 | 13 | SO46931 | 2022-11-18 | 20.07 | 185.61 | 125.42 | |||
SO47409_10 | FC23-4384-86 | PO1624119173 | 100 | 283 | 321 | 579 | 3 | 2022-12-24 | 939.59 | 23.49 | 2022-12-12 | 2 | 486.71 | 1 | 939.59 | 10 | SO47409 | 2022-12-19 | 75.17 | 973.41 | 469.79 | |||
SO47352_28 | 9DF5-4A88-9C | PO19633111392 | 100 | 287 | 352 | 149 | 3 | 2022-12-24 | 7457.11 | 186.43 | 2022-12-12 | 6 | 1117.86 | 1 | 7457.11 | 28 | SO47352 | 2022-12-19 | 596.57 | 6707.14 | 1242.85 | |||
SO47352_19 | 9DF5-4A88-9C | PO19633111392 | 100 | 287 | 216 | 149 | 3 | 2022-12-24 | 80.75 | 2.02 | 2022-12-12 | 4 | 13.88 | 1 | 80.75 | 19 | SO47352 | 2022-12-19 | 6.46 | 55.51 | 20.19 | |||
SO51140_20 | 0583-4C94-BA | PO6467148715 | 100 | 283 | 483 | 2 | 660 | 3 | 19.49 | 2023-10-23 | 974.40 | 23.87 | 2023-10-11 | 14 | 44.88 | 1 | 954.91 | 20 | SO51140 | 2023-10-18 | 76.39 | 628.32 | 69.60 | 0.02 |
SO45343_14 | 9A71-4101-BA | PO8874137222 | 100 | 282 | 347 | 348 | 3 | 2022-05-26 | 2039.99 | 51.00 | 2022-05-14 | 1 | 1912.15 | 1 | 2039.99 | 14 | SO45343 | 2022-05-21 | 163.20 | 1912.15 | 2039.99 | |||
SO46107_15 | 75E6-43D6-92 | PO8874169089 | 100 | 282 | 349 | 348 | 3 | 2022-08-23 | 4049.99 | 101.25 | 2022-08-11 | 2 | 1898.09 | 1 | 4049.99 | 15 | SO46107 | 2022-08-18 | 324.00 | 3796.19 | 2024.99 | |||
SO71819_24 | DBA3-430C-8B | PO12354153257 | 100 | 283 | 490 | 197 | 3 | 2024-09-23 | 259.15 | 6.48 | 2024-09-11 | 8 | 41.57 | 1 | 259.15 | 24 | SO71819 | 2024-09-18 | 20.73 | 332.58 | 32.39 | |||
SO47352_4 | 9DF5-4A88-9C | PO19633111392 | 100 | 287 | 364 | 149 | 3 | 2022-12-24 | 1943.98 | 48.60 | 2022-12-12 | 3 | 598.44 | 1 | 1943.98 | 4 | SO47352 | 2022-12-19 | 155.52 | 1795.31 | 647.99 | |||
SO43899_10 | 79F2-434F-97 | PO5191115657 | 100 | 283 | 342 | 364 | 3 | 2021-11-23 | 838.92 | 20.97 | 2021-11-11 | 2 | 413.15 | 1 | 838.92 | 10 | SO43899 | 2021-11-18 | 67.11 | 826.29 | 419.46 | |||
SO51716_13 | 232B-4C4C-97 | PO15283150425 | 100 | 281 | 564 | 14 | 363 | 3 | 1335.08 | 2023-11-23 | 6675.40 | 133.51 | 2023-11-11 | 7 | 1481.94 | 1 | 5340.32 | 13 | SO51716 | 2023-11-18 | 427.23 | 10373.57 | 953.63 | 0.20 |
SO51716_3 | 232B-4C4C-97 | PO15283150425 | 100 | 281 | 507 | 363 | 3 | 2023-11-23 | 200.05 | 5.00 | 2023-11-11 | 1 | 199.85 | 1 | 200.05 | 3 | SO51716 | 2023-11-18 | 16.00 | 199.85 | 200.05 | |||
SO46055_6 | DDC5-498B-87 | PO13572168536 | 100 | 287 | 310 | 527 | 3 | 2022-08-23 | 4293.92 | 107.35 | 2022-08-11 | 2 | 2171.29 | 1 | 4293.92 | 6 | SO46055 | 2022-08-18 | 343.51 | 4342.59 | 2146.96 | |||
SO44530_15 | 46CE-47C5-B3 | PO10440138648 | 100 | 283 | 300 | 623 | 3 | 2022-02-23 | 1619.52 | 40.49 | 2022-02-11 | 2 | 699.09 | 1 | 1619.52 | 15 | SO44530 | 2022-02-18 | 129.56 | 1398.19 | 809.76 | |||
SO46629_30 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 323 | 670 | 3 | 2022-10-23 | 2818.76 | 70.47 | 2022-10-11 | 6 | 486.71 | 1 | 2818.76 | 30 | SO46629 | 2022-10-18 | 225.50 | 2920.24 | 469.79 | |||
SO45045_1 | B017-4F1A-A7 | PO15428115744 | 100 | 283 | 218 | 646 | 3 | 2022-04-25 | 11.40 | 0.29 | 2022-04-13 | 2 | 3.40 | 1 | 11.40 | 1 | SO45045 | 2022-04-20 | 0.91 | 6.79 | 5.70 | |||
SO45550_10 | 0A3A-4E54-9A | PO1624140031 | 100 | 283 | 320 | 579 | 3 | 2022-06-23 | 1258.38 | 31.46 | 2022-06-11 | 3 | 413.15 | 1 | 1258.38 | 10 | SO45550 | 2022-06-18 | 100.67 | 1239.44 | 419.46 |
Generated 2024-11-10 20:53:52.265 UTC