[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 273 > < TAKE 28 >
28 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45797_18 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 326 | 679 | 6 | 2022-06-04 | 838.92 | 20.97 | 2022-05-23 | 2 | 413.15 | 1 | 838.92 | 18 | SO45797 | 2022-05-30 | 67.11 | 826.29 | 419.46 |
SO47696_19 | B251-4D0B-9C | PO1711162591 | 19 | 291 | 362 | 245 | 6 | 2022-12-04 | 2458.92 | 61.47 | 2022-11-22 | 2 | 1105.81 | 1 | 2458.92 | 19 | SO47696 | 2022-11-29 | 196.71 | 2211.62 | 1229.46 |
SO67272_15 | F467-41BF-8B | PO13862111340 | 19 | 291 | 588 | 119 | 6 | 2024-06-04 | 1385.08 | 34.63 | 2024-05-23 | 3 | 419.78 | 1 | 1385.08 | 15 | SO67272 | 2024-05-30 | 110.81 | 1259.34 | 461.69 |
SO46071_10 | 1563-4F33-9D | PO1827148074 | 19 | 288 | 232 | 317 | 6 | 2022-07-04 | 230.72 | 5.77 | 2022-06-22 | 8 | 31.72 | 1 | 230.72 | 10 | SO46071 | 2022-06-29 | 18.46 | 253.80 | 28.84 |
SO57097_13 | 9A9E-444B-B1 | PO18328123706 | 19 | 284 | 547 | 552 | 6 | 2024-01-04 | 97.19 | 2.43 | 2023-12-23 | 2 | 35.96 | 1 | 97.19 | 13 | SO57097 | 2023-12-30 | 7.78 | 71.92 | 48.59 |
SO58972_8 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 590 | 10 | 6 | 2024-02-03 | 1385.08 | 34.63 | 2024-01-22 | 3 | 419.78 | 1 | 1385.08 | 8 | SO58972 | 2024-01-29 | 110.81 | 1259.34 | 461.69 |
SO47963_3 | 9A95-4541-91 | PO19691179567 | 19 | 291 | 358 | 353 | 6 | 2023-01-04 | 2458.92 | 61.47 | 2022-12-23 | 2 | 1105.81 | 1 | 2458.92 | 3 | SO47963 | 2022-12-30 | 196.71 | 2211.62 | 1229.46 |
SO49855_12 | 0C94-4D84-A4 | PO18473166459 | 19 | 291 | 445 | 442 | 6 | 2023-06-04 | 179.97 | 4.50 | 2023-05-23 | 5 | 24.75 | 1 | 179.97 | 12 | SO49855 | 2023-05-30 | 14.40 | 123.73 | 35.99 |
SO69455_2 | 8DE3-4ABC-86 | PO638130338 | 19 | 291 | 483 | 280 | 6 | 2024-07-04 | 360.00 | 9.00 | 2024-06-22 | 5 | 44.88 | 1 | 360.00 | 2 | SO69455 | 2024-06-29 | 28.80 | 224.40 | 72.00 |
SO47413_7 | E274-4280-9B | PO1885161774 | 19 | 284 | 399 | 588 | 6 | 2022-11-04 | 135.10 | 3.38 | 2022-10-23 | 4 | 24.99 | 1 | 135.10 | 7 | SO47413 | 2022-10-30 | 10.81 | 99.97 | 33.77 |
SO46639_9 | 7CDF-4BF8-8E | PO10527141970 | 19 | 284 | 224 | 480 | 6 | 2022-09-03 | 15.56 | 0.39 | 2022-08-22 | 3 | 5.23 | 1 | 15.56 | 9 | SO46639 | 2022-08-29 | 1.24 | 15.69 | 5.19 |
SO47662_33 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 216 | 442 | 6 | 2022-12-04 | 80.75 | 2.02 | 2022-11-22 | 4 | 13.88 | 1 | 80.75 | 33 | SO47662 | 2022-11-29 | 6.46 | 55.51 | 20.19 |
SO46984_10 | 0C1F-467E-93 | PO12789152571 | 19 | 291 | 469 | 677 | 6 | 2022-10-04 | 45.59 | 1.14 | 2022-09-22 | 2 | 15.67 | 1 | 45.59 | 10 | SO46984 | 2022-09-29 | 3.65 | 31.34 | 22.79 |
SO47668_39 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 369 | 299 | 6 | 2022-12-04 | 2932.02 | 73.30 | 2022-11-22 | 2 | 1518.79 | 1 | 2932.02 | 39 | SO47668 | 2022-11-29 | 234.56 | 3037.57 | 1466.01 |
SO58980_7 | 8985-4B66-AD | PO18502175539 | 19 | 291 | 564 | 154 | 6 | 2024-02-03 | 14304.42 | 357.61 | 2024-01-22 | 10 | 1481.94 | 1 | 14304.42 | 7 | SO58980 | 2024-01-29 | 1144.35 | 14819.38 | 1430.44 |
SO57057_4 | D52B-4914-A5 | PO12789122887 | 19 | 291 | 361 | 677 | 6 | 2024-01-04 | 1376.99 | 34.42 | 2023-12-23 | 1 | 1251.98 | 1 | 1376.99 | 4 | SO57057 | 2023-12-30 | 110.16 | 1251.98 | 1376.99 |
SO55245_15 | B5AD-476D-B4 | PO14732112185 | 19 | 291 | 255 | 514 | 6 | 2023-12-04 | 1011.66 | 25.29 | 2023-11-22 | 5 | 204.63 | 1 | 1011.66 | 15 | SO55245 | 2023-11-29 | 80.93 | 1023.13 | 202.33 |
SO69399_35 | BEA9-4703-91 | PO17661173810 | 19 | 284 | 491 | 264 | 6 | 2024-07-04 | 64.79 | 1.62 | 2024-06-22 | 2 | 41.57 | 1 | 64.79 | 35 | SO69399 | 2024-06-29 | 5.18 | 83.14 | 32.39 |
SO57016_7 | 5FA2-418F-AF | PO19227187256 | 19 | 284 | 547 | 210 | 6 | 2024-01-04 | 97.19 | 2.43 | 2023-12-23 | 2 | 35.96 | 1 | 97.19 | 7 | SO57016 | 2023-12-30 | 7.78 | 71.92 | 48.59 |
SO47003_14 | 2C85-4918-94 | PO638185142 | 19 | 291 | 216 | 280 | 6 | 2022-10-04 | 20.19 | 0.50 | 2022-09-22 | 1 | 13.88 | 1 | 20.19 | 14 | SO47003 | 2022-09-29 | 1.61 | 13.88 | 20.19 |
SO45314_14 | E3E6-417D-A7 | PO2088183646 | 19 | 288 | 317 | 136 | 6 | 2022-04-06 | 874.79 | 21.87 | 2022-03-25 | 1 | 884.71 | 1 | 874.79 | 14 | SO45314 | 2022-04-01 | 69.98 | 884.71 | 874.79 |
SO58972_46 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 298 | 10 | 6 | 2024-02-03 | 3239.04 | 80.98 | 2024-01-22 | 4 | 739.04 | 1 | 3239.04 | 46 | SO58972 | 2024-01-29 | 259.12 | 2956.16 | 809.76 |
SO57023_15 | EE6C-4089-A0 | PO17603140236 | 19 | 284 | 545 | 12 | 6 | 2024-01-04 | 72.88 | 1.82 | 2023-12-23 | 3 | 17.98 | 1 | 72.88 | 15 | SO57023 | 2023-12-30 | 5.83 | 53.93 | 24.29 |
SO43850_7 | EBA6-4C6F-86 | PO18415143340 | 19 | 288 | 270 | 191 | 6 | 2021-10-04 | 183.94 | 4.60 | 2021-09-22 | 1 | 181.49 | 1 | 183.94 | 7 | SO43850 | 2021-09-29 | 14.72 | 181.49 | 183.94 |
SO43668_19 | 365D-4C9A-BE | PO14732180295 | 19 | 288 | 235 | 514 | 6 | 2021-09-03 | 28.84 | 0.72 | 2021-08-22 | 1 | 31.72 | 1 | 28.84 | 19 | SO43668 | 2021-08-29 | 2.31 | 31.72 | 28.84 |
SO48754_10 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 445 | 442 | 6 | 2023-03-06 | 107.98 | 2.70 | 2023-02-22 | 3 | 24.75 | 1 | 107.98 | 10 | SO48754 | 2023-03-01 | 8.64 | 74.24 | 35.99 |
SO49871_5 | 032A-45C4-8D | PO4930185924 | 19 | 291 | 458 | 425 | 6 | 2023-06-04 | 179.98 | 4.50 | 2023-05-23 | 4 | 30.93 | 1 | 179.98 | 5 | SO49871 | 2023-05-30 | 14.40 | 123.73 | 44.99 |
SO58930_13 | 3C7F-464E-B2 | PO14790187151 | 19 | 291 | 594 | 497 | 6 | 2024-02-03 | 338.99 | 8.47 | 2024-01-22 | 1 | 308.22 | 1 | 338.99 | 13 | SO58930 | 2024-01-29 | 27.12 | 308.22 | 338.99 |
Generated 2024-09-21 04:26:26.733 UTC