[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 560 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44496_4 | 6ADA-4A25-AA | PO18415194469 | 19 | 288 | 312 | 191 | 6 | 2022-01-03 | 2146.96 | 53.67 | 2021-12-22 | 1 | 2171.29 | 1 | 2146.96 | 4 | SO44496 | 2021-12-29 | 171.76 | 2171.29 | 2146.96 | |||
SO48023_17 | 18BD-4FA3-9F | PO11020197101 | 19 | 284 | 339 | 336 | 6 | 2023-01-03 | 939.59 | 23.49 | 2022-12-22 | 2 | 486.71 | 1 | 939.59 | 17 | SO48023 | 2022-12-29 | 75.17 | 973.41 | 469.79 | |||
SO58930_4 | 3C7F-464E-B2 | PO14790187151 | 19 | 291 | 402 | 497 | 6 | 2024-02-02 | 144.32 | 3.61 | 2024-01-21 | 2 | 53.40 | 1 | 144.32 | 4 | SO58930 | 2024-01-28 | 11.55 | 106.80 | 72.16 | |||
SO67302_34 | E4B2-462D-AC | PO18473194134 | 19 | 291 | 592 | 442 | 6 | 2024-06-03 | 1016.98 | 25.42 | 2024-05-22 | 3 | 308.22 | 1 | 1016.98 | 34 | SO67302 | 2024-05-29 | 81.36 | 924.65 | 338.99 | |||
SO44490_1 | 0CC4-4097-80 | PO19227160482 | 19 | 284 | 322 | 210 | 6 | 2022-01-03 | 419.46 | 10.49 | 2021-12-22 | 1 | 413.15 | 1 | 419.46 | 1 | SO44490 | 2021-12-29 | 33.56 | 413.15 | 419.46 | |||
SO65235_8 | 0A92-4A75-90 | PO10962154595 | 19 | 284 | 587 | 685 | 6 | 2024-05-03 | 461.69 | 11.54 | 2024-04-21 | 1 | 419.78 | 1 | 461.69 | 8 | SO65235 | 2024-04-28 | 36.94 | 419.78 | 461.69 | |||
SO69538_6 | 631A-4D82-A8 | PO2117162793 | 19 | 284 | 476 | 444 | 6 | 2024-07-03 | 83.99 | 2.10 | 2024-06-21 | 2 | 26.18 | 1 | 83.99 | 6 | SO69538 | 2024-06-28 | 6.72 | 52.35 | 41.99 | |||
SO46639_6 | 7CDF-4BF8-8E | PO10527141970 | 19 | 284 | 216 | 8 | 480 | 6 | 8.41 | 2022-09-02 | 84.11 | 1.89 | 2022-08-21 | 5 | 13.88 | 1 | 75.70 | 6 | SO46639 | 2022-08-28 | 6.06 | 69.39 | 16.82 | 0.10 |
SO57016_1 | 5FA2-418F-AF | PO19227187256 | 19 | 284 | 234 | 210 | 6 | 2024-01-03 | 89.98 | 2.25 | 2023-12-22 | 3 | 38.49 | 1 | 89.98 | 1 | SO57016 | 2023-12-29 | 7.20 | 115.48 | 29.99 | |||
SO67268_39 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 491 | 3 | 299 | 6 | 28.21 | 2024-06-03 | 564.20 | 13.40 | 2024-05-22 | 19 | 41.57 | 1 | 535.99 | 39 | SO67268 | 2024-05-29 | 42.88 | 789.87 | 29.69 | 0.05 |
SO47690_3 | B248-4AA7-92 | PO10527158850 | 19 | 284 | 224 | 480 | 6 | 2022-12-03 | 10.37 | 0.26 | 2022-11-21 | 2 | 5.23 | 1 | 10.37 | 3 | SO47690 | 2022-11-28 | 0.83 | 10.46 | 5.19 | |||
SO51092_21 | FB68-47B7-9D | PO15312133079 | 19 | 291 | 465 | 2 | 299 | 6 | 3.41 | 2023-09-02 | 170.45 | 4.18 | 2023-08-21 | 12 | 9.16 | 1 | 167.04 | 21 | SO51092 | 2023-08-28 | 13.36 | 109.91 | 14.20 | 0.02 |
SO50192_8 | A5BA-4696-96 | PO19227162823 | 19 | 284 | 433 | 210 | 6 | 2023-07-03 | 324.45 | 8.11 | 2023-06-21 | 1 | 300.12 | 1 | 324.45 | 8 | SO50192 | 2023-06-28 | 25.96 | 300.12 | 324.45 | |||
SO51100_26 | A159-4950-A0 | PO13862191766 | 19 | 291 | 596 | 119 | 6 | 2023-09-02 | 971.98 | 24.30 | 2023-08-21 | 3 | 294.58 | 1 | 971.98 | 26 | SO51100 | 2023-08-28 | 77.76 | 883.74 | 323.99 | |||
SO51793_36 | D763-4929-9B | PO18705168707 | 19 | 291 | 581 | 479 | 6 | 2023-10-03 | 1020.59 | 25.51 | 2023-09-21 | 1 | 1082.51 | 1 | 1020.59 | 36 | SO51793 | 2023-09-28 | 81.65 | 1082.51 | 1020.59 | |||
SO48299_23 | ABFA-41A9-A7 | PO18299110324 | 19 | 291 | 305 | 118 | 6 | 2023-02-02 | 736.15 | 18.40 | 2023-01-21 | 1 | 653.70 | 1 | 736.15 | 23 | SO48299 | 2023-01-28 | 58.89 | 653.70 | 736.15 | |||
SO45268_2 | 2C70-4779-BC | PO19430121252 | 19 | 284 | 322 | 318 | 6 | 2022-04-05 | 419.46 | 10.49 | 2022-03-24 | 1 | 413.15 | 1 | 419.46 | 2 | SO45268 | 2022-03-31 | 33.56 | 413.15 | 419.46 | |||
SO63290_3 | 0F43-405E-B8 | PO9077159728 | 19 | 291 | 598 | 100 | 6 | 2024-04-04 | 323.99 | 8.10 | 2024-03-23 | 1 | 294.58 | 1 | 323.99 | 3 | SO63290 | 2024-03-30 | 25.92 | 294.58 | 323.99 | |||
SO48033_33 | BC9E-4246-AC | PO1595118269 | 19 | 284 | 464 | 426 | 6 | 2023-01-03 | 56.52 | 1.41 | 2022-12-22 | 4 | 9.71 | 1 | 56.52 | 33 | SO48033 | 2022-12-29 | 4.52 | 38.85 | 14.13 | |||
SO48761_7 | E39C-4A4E-A3 | PO15312195795 | 19 | 291 | 221 | 299 | 6 | 2023-03-05 | 20.19 | 0.50 | 2023-02-21 | 1 | 13.88 | 1 | 20.19 | 7 | SO48761 | 2023-02-28 | 1.61 | 13.88 | 20.19 | |||
SO46930_10 | 73DA-4549-8B | PO20039167979 | 19 | 291 | 460 | 65 | 6 | 2022-10-03 | 215.98 | 5.40 | 2022-09-21 | 4 | 37.12 | 1 | 215.98 | 10 | SO46930 | 2022-09-28 | 17.28 | 148.48 | 53.99 | |||
SO58958_21 | BC3F-443F-B5 | PO10875118816 | 19 | 291 | 507 | 281 | 6 | 2024-02-02 | 200.05 | 5.00 | 2024-01-21 | 1 | 199.85 | 1 | 200.05 | 21 | SO58958 | 2024-01-28 | 16.00 | 199.85 | 200.05 | |||
SO58930_3 | 3C7F-464E-B2 | PO14790187151 | 19 | 291 | 363 | 497 | 6 | 2024-02-02 | 6884.97 | 172.12 | 2024-01-21 | 5 | 1251.98 | 1 | 6884.97 | 3 | SO58930 | 2024-01-28 | 550.80 | 6259.91 | 1376.99 | |||
SO71808_29 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 480 | 408 | 6 | 2024-08-03 | 4.12 | 0.10 | 2024-07-22 | 3 | 0.86 | 1 | 4.12 | 29 | SO71808 | 2024-07-29 | 0.33 | 2.57 | 1.37 | |||
SO45305_21 | AC1B-4242-9C | PO11600132440 | 19 | 288 | 315 | 569 | 6 | 2022-04-05 | 1749.59 | 43.74 | 2022-03-24 | 2 | 884.71 | 1 | 1749.59 | 21 | SO45305 | 2022-03-31 | 139.97 | 1769.42 | 874.79 | |||
SO47662_40 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 362 | 442 | 6 | 2022-12-03 | 2458.92 | 61.47 | 2022-11-21 | 2 | 1105.81 | 1 | 2458.92 | 40 | SO47662 | 2022-11-28 | 196.71 | 2211.62 | 1229.46 | |||
SO50716_30 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 410 | 118 | 6 | 2023-08-03 | 36.45 | 0.91 | 2023-07-22 | 1 | 26.97 | 1 | 36.45 | 30 | SO50716 | 2023-07-29 | 2.92 | 26.97 | 36.45 | |||
SO47690_8 | B248-4AA7-92 | PO10527158850 | 19 | 284 | 456 | 480 | 6 | 2022-12-03 | 89.99 | 2.25 | 2022-11-21 | 2 | 30.93 | 1 | 89.99 | 8 | SO47690 | 2022-11-28 | 7.20 | 61.87 | 44.99 | |||
SO50687_6 | DF8C-416B-BA | PO10962187340 | 19 | 284 | 366 | 685 | 6 | 2023-08-03 | 1943.98 | 48.60 | 2023-07-22 | 3 | 598.44 | 1 | 1943.98 | 6 | SO50687 | 2023-07-29 | 155.52 | 1795.31 | 647.99 | |||
SO46064_2 | EC45-4C82-8B | PO11020129544 | 19 | 284 | 319 | 336 | 6 | 2022-07-03 | 3499.18 | 87.48 | 2022-06-21 | 4 | 884.71 | 1 | 3499.18 | 2 | SO46064 | 2022-06-28 | 279.93 | 3538.83 | 874.79 | |||
SO65206_7 | 6CD1-4BEC-A0 | PO1798192797 | 19 | 291 | 361 | 10 | 6 | 2024-05-03 | 2753.99 | 68.85 | 2024-04-21 | 2 | 1251.98 | 1 | 2753.99 | 7 | SO65206 | 2024-04-28 | 220.32 | 2503.96 | 1376.99 |
Generated 2024-09-20 11:55:17.308 UTC