[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 291 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46607_15 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 271 | 227 | 6 | 2022-10-23 | 1213.99 | 30.35 | 2022-10-11 | 6 | 187.16 | 1 | 1213.99 | 15 | SO46607 | 2022-10-18 | 97.12 | 1122.94 | 202.33 | |||
SO67268_2 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 287 | 299 | 6 | 2024-07-24 | 404.66 | 10.12 | 2024-07-12 | 2 | 204.63 | 1 | 404.66 | 2 | SO67268 | 2024-07-19 | 32.37 | 409.25 | 202.33 | |||
SO69398_2 | 29DF-4EAC-8D | PO17632193764 | 19 | 291 | 488 | 28 | 6 | 2024-08-23 | 161.97 | 4.05 | 2024-08-11 | 5 | 41.57 | 1 | 161.97 | 2 | SO69398 | 2024-08-18 | 12.96 | 207.86 | 32.39 | |||
SO47413_11 | E274-4280-9B | PO1885161774 | 19 | 284 | 412 | 588 | 6 | 2022-12-24 | 540.39 | 13.51 | 2022-12-12 | 3 | 133.30 | 1 | 540.39 | 11 | SO47413 | 2022-12-19 | 43.23 | 399.89 | 180.13 | |||
SO48306_17 | EA27-471A-9D | PO17574166075 | 19 | 291 | 354 | 2 | 678 | 6 | 312.37 | 2023-03-25 | 15618.50 | 382.65 | 2023-03-13 | 13 | 1117.86 | 1 | 15306.13 | 17 | SO48306 | 2023-03-20 | 1224.49 | 14532.13 | 1201.42 | 0.02 |
SO71841_45 | 1544-4561-AB | PO1798133189 | 19 | 291 | 589 | 10 | 6 | 2024-09-23 | 3231.86 | 80.80 | 2024-09-11 | 7 | 419.78 | 1 | 3231.86 | 45 | SO71841 | 2024-09-18 | 258.55 | 2938.45 | 461.69 | |||
SO46326_22 | EDD8-4703-B2 | PO19401160698 | 19 | 288 | 316 | 173 | 6 | 2022-09-23 | 874.79 | 21.87 | 2022-09-11 | 1 | 884.71 | 1 | 874.79 | 22 | SO46326 | 2022-09-18 | 69.98 | 884.71 | 874.79 | |||
SO51704_18 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 523 | 264 | 6 | 2023-11-23 | 63.17 | 1.58 | 2023-11-11 | 2 | 23.37 | 1 | 63.17 | 18 | SO51704 | 2023-11-18 | 5.05 | 46.74 | 31.58 | |||
SO47399_8 | B5FA-4CC2-8C | PO10962177551 | 19 | 284 | 468 | 685 | 6 | 2022-12-24 | 22.79 | 0.57 | 2022-12-12 | 1 | 15.67 | 1 | 22.79 | 8 | SO47399 | 2022-12-19 | 1.82 | 15.67 | 22.79 | |||
SO44496_6 | 6ADA-4A25-AA | PO18415194469 | 19 | 288 | 270 | 191 | 6 | 2022-02-23 | 183.94 | 4.60 | 2022-02-11 | 1 | 181.49 | 1 | 183.94 | 6 | SO44496 | 2022-02-18 | 14.72 | 181.49 | 183.94 | |||
SO43886_2 | CE58-49B5-82 | PO1827149671 | 19 | 288 | 328 | 317 | 6 | 2021-11-23 | 419.46 | 10.49 | 2021-11-11 | 1 | 413.15 | 1 | 419.46 | 2 | SO43886 | 2021-11-18 | 33.56 | 413.15 | 419.46 | |||
SO49848_19 | 31E6-4A3B-9C | PO1711148241 | 19 | 291 | 294 | 245 | 6 | 2023-07-24 | 1488.55 | 37.21 | 2023-07-12 | 2 | 660.91 | 1 | 1488.55 | 19 | SO49848 | 2023-07-19 | 119.08 | 1321.83 | 744.27 | |||
SO46645_18 | F857-4A6D-9C | PO1711132491 | 19 | 291 | 410 | 245 | 6 | 2022-10-23 | 182.24 | 4.56 | 2022-10-11 | 5 | 26.97 | 1 | 182.24 | 18 | SO46645 | 2022-10-18 | 14.58 | 134.85 | 36.45 | |||
SO45313_14 | 181D-4E05-8D | PO1827151513 | 19 | 288 | 215 | 317 | 6 | 2022-05-26 | 20.19 | 0.50 | 2022-05-14 | 1 | 12.03 | 1 | 20.19 | 14 | SO45313 | 2022-05-21 | 1.61 | 12.03 | 20.19 | |||
SO61204_24 | E810-4164-82 | PO15312134209 | 19 | 291 | 418 | 299 | 6 | 2024-04-24 | 356.90 | 8.92 | 2024-04-12 | 1 | 360.94 | 1 | 356.90 | 24 | SO61204 | 2024-04-19 | 28.55 | 360.94 | 356.90 | |||
SO49468_10 | DB7C-4159-88 | PO1885116335 | 19 | 284 | 367 | 588 | 6 | 2023-06-23 | 1943.98 | 48.60 | 2023-06-11 | 3 | 598.44 | 1 | 1943.98 | 10 | SO49468 | 2023-06-18 | 155.52 | 1795.31 | 647.99 | |||
SO44526_5 | 9F1A-4CE0-93 | PO11020190357 | 19 | 284 | 253 | 336 | 6 | 2022-02-23 | 178.58 | 4.46 | 2022-02-11 | 1 | 176.20 | 1 | 178.58 | 5 | SO44526 | 2022-02-18 | 14.29 | 176.20 | 178.58 | |||
SO49100_13 | BD42-4470-A8 | PO17603154869 | 19 | 284 | 460 | 12 | 6 | 2023-05-26 | 107.99 | 2.70 | 2023-05-14 | 2 | 37.12 | 1 | 107.99 | 13 | SO49100 | 2023-05-21 | 8.64 | 74.24 | 53.99 | |||
SO51704_48 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 586 | 13 | 264 | 6 | 100.22 | 2023-11-23 | 668.12 | 14.20 | 2023-11-11 | 2 | 461.44 | 1 | 567.90 | 48 | SO51704 | 2023-11-18 | 45.43 | 922.89 | 334.06 | 0.15 |
SO53536_47 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 222 | 2 | 118 | 6 | 4.46 | 2023-12-24 | 223.24 | 5.47 | 2023-12-12 | 11 | 13.09 | 1 | 218.77 | 47 | SO53536 | 2023-12-19 | 17.50 | 143.95 | 20.29 | 0.02 |
SO58925_6 | ACBD-43C3-A2 | PO15544139465 | 19 | 284 | 523 | 282 | 6 | 2024-03-24 | 126.34 | 3.16 | 2024-03-12 | 4 | 23.37 | 1 | 126.34 | 6 | SO58925 | 2024-03-19 | 10.11 | 93.49 | 31.58 | |||
SO63269_7 | B1E2-43BD-84 | PO2030137986 | 19 | 284 | 599 | 661 | 6 | 2024-05-25 | 323.99 | 8.10 | 2024-05-13 | 1 | 294.58 | 1 | 323.99 | 7 | SO63269 | 2024-05-20 | 25.92 | 294.58 | 323.99 | |||
SO51850_42 | 57A9-4C32-8B | PO1856170170 | 19 | 291 | 471 | 263 | 6 | 2023-11-23 | 266.70 | 6.67 | 2023-11-11 | 7 | 23.75 | 1 | 266.70 | 42 | SO51850 | 2023-11-18 | 21.34 | 166.24 | 38.10 | |||
SO48299_29 | ABFA-41A9-A7 | PO18299110324 | 19 | 291 | 230 | 118 | 6 | 2023-03-25 | 201.88 | 5.05 | 2023-03-13 | 7 | 29.08 | 1 | 201.88 | 29 | SO48299 | 2023-03-20 | 16.15 | 203.56 | 28.84 | |||
SO46940_15 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 371 | 479 | 6 | 2022-11-23 | 1308.94 | 32.72 | 2022-11-11 | 1 | 1320.68 | 1 | 1308.94 | 15 | SO46940 | 2022-11-18 | 104.72 | 1320.68 | 1308.94 | |||
SO44745_2 | 5CFC-4DD5-A7 | PO18299187625 | 19 | 288 | 300 | 118 | 6 | 2022-03-25 | 809.76 | 20.24 | 2022-03-13 | 1 | 699.09 | 1 | 809.76 | 2 | SO44745 | 2022-03-20 | 64.78 | 699.09 | 809.76 | |||
SO49855_27 | 0C94-4D84-A4 | PO18473166459 | 19 | 291 | 428 | 442 | 6 | 2023-07-24 | 837.02 | 20.93 | 2023-07-12 | 4 | 185.82 | 1 | 837.02 | 27 | SO49855 | 2023-07-19 | 66.96 | 743.28 | 209.26 | |||
SO45794_9 | 945F-4477-83 | PO12760191318 | 19 | 288 | 232 | 83 | 6 | 2022-07-24 | 230.72 | 5.77 | 2022-07-12 | 8 | 31.72 | 1 | 230.72 | 9 | SO45794 | 2022-07-19 | 18.46 | 253.80 | 28.84 |
Generated 2024-11-10 08:01:45.519 UTC