[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 606 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50716_7 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 236 | 118 | 6 | 2023-08-04 | 144.20 | 3.61 | 2023-07-23 | 5 | 29.08 | 1 | 144.20 | 7 | SO50716 | 2023-07-30 | 11.54 | 145.40 | 28.84 | |||
SO48023_19 | 18BD-4FA3-9F | PO11020197101 | 19 | 284 | 422 | 336 | 6 | 2023-01-04 | 135.08 | 3.38 | 2022-12-23 | 2 | 49.98 | 1 | 135.08 | 19 | SO48023 | 2022-12-30 | 10.81 | 99.96 | 67.54 | |||
SO69400_6 | 761C-4315-82 | PO17806199596 | 19 | 291 | 605 | 101 | 6 | 2024-07-04 | 323.99 | 8.10 | 2024-06-22 | 1 | 343.65 | 1 | 323.99 | 6 | SO69400 | 2024-06-29 | 25.92 | 343.65 | 323.99 | |||
SO47031_3 | 3FA6-4120-BD | PO4466161844 | 19 | 291 | 366 | 352 | 6 | 2022-10-04 | 2591.98 | 64.80 | 2022-09-22 | 4 | 598.44 | 1 | 2591.98 | 3 | SO47031 | 2022-09-29 | 207.36 | 2393.74 | 647.99 | |||
SO65218_14 | 582E-4D6F-9C | PO15544112763 | 19 | 284 | 564 | 282 | 6 | 2024-05-04 | 4291.33 | 107.28 | 2024-04-22 | 3 | 1481.94 | 1 | 4291.33 | 14 | SO65218 | 2024-04-29 | 343.31 | 4445.81 | 1430.44 | |||
SO48036_33 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 381 | 66 | 6 | 2023-01-04 | 3001.31 | 75.03 | 2022-12-23 | 5 | 605.65 | 1 | 3001.31 | 33 | SO48036 | 2022-12-30 | 240.11 | 3028.25 | 600.26 | |||
SO45525_3 | A7C8-47FE-B6 | PO17719132619 | 19 | 284 | 326 | 631 | 6 | 2022-05-04 | 838.92 | 20.97 | 2022-04-22 | 2 | 413.15 | 1 | 838.92 | 3 | SO45525 | 2022-04-29 | 67.11 | 826.29 | 419.46 | |||
SO43898_19 | 420C-4ECE-85 | PO4901196283 | 19 | 284 | 229 | 84 | 6 | 2021-10-04 | 86.52 | 2.16 | 2021-09-22 | 3 | 31.72 | 1 | 86.52 | 19 | SO43898 | 2021-09-29 | 6.92 | 95.17 | 28.84 | |||
SO48768_11 | 590A-4550-A0 | PO13862146668 | 19 | 291 | 470 | 119 | 6 | 2023-03-06 | 227.94 | 5.70 | 2023-02-22 | 10 | 15.67 | 1 | 227.94 | 11 | SO48768 | 2023-03-01 | 18.24 | 156.71 | 22.79 | |||
SO65189_12 | 985E-4937-94 | PO14761195376 | 19 | 284 | 502 | 408 | 6 | 2024-05-04 | 200.05 | 5.00 | 2024-04-22 | 1 | 199.85 | 1 | 200.05 | 12 | SO65189 | 2024-04-29 | 16.00 | 199.85 | 200.05 | |||
SO57188_18 | BA1D-4480-AA | PO9077120275 | 19 | 291 | 476 | 100 | 6 | 2024-01-04 | 251.96 | 6.30 | 2023-12-23 | 6 | 26.18 | 1 | 251.96 | 18 | SO57188 | 2023-12-30 | 20.16 | 157.06 | 41.99 | |||
SO47668_40 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 456 | 299 | 6 | 2022-12-04 | 269.96 | 6.75 | 2022-11-22 | 6 | 30.93 | 1 | 269.96 | 40 | SO47668 | 2022-11-29 | 21.60 | 185.60 | 44.99 | |||
SO48053_22 | 69FC-4D14-B1 | PO4466199959 | 19 | 291 | 460 | 352 | 6 | 2023-01-04 | 107.99 | 2.70 | 2022-12-23 | 2 | 37.12 | 1 | 107.99 | 22 | SO48053 | 2022-12-30 | 8.64 | 74.24 | 53.99 | |||
SO67288_7 | C763-4CCD-AB | PO10527192676 | 19 | 284 | 477 | 480 | 6 | 2024-06-04 | 8.98 | 0.22 | 2024-05-23 | 3 | 1.87 | 1 | 8.98 | 7 | SO67288 | 2024-05-30 | 0.72 | 5.60 | 2.99 | |||
SO48768_10 | 590A-4550-A0 | PO13862146668 | 19 | 291 | 354 | 119 | 6 | 2023-03-06 | 6214.26 | 155.36 | 2023-02-22 | 5 | 1117.86 | 1 | 6214.26 | 10 | SO48768 | 2023-03-01 | 497.14 | 5589.28 | 1242.85 | |||
SO53464_16 | E113-419B-8F | PO17545119283 | 19 | 291 | 386 | 155 | 6 | 2023-11-04 | 2016.88 | 50.42 | 2023-10-23 | 3 | 713.08 | 1 | 2016.88 | 16 | SO53464 | 2023-10-30 | 161.35 | 2139.24 | 672.29 | |||
SO51772_17 | 7800-4280-A7 | PO1827195162 | 19 | 291 | 430 | 317 | 6 | 2023-10-04 | 713.80 | 17.84 | 2023-09-22 | 2 | 360.94 | 1 | 713.80 | 17 | SO51772 | 2023-09-29 | 57.10 | 721.89 | 356.90 | |||
SO51092_46 | FB68-47B7-9D | PO15312133079 | 19 | 291 | 384 | 299 | 6 | 2023-09-03 | 2016.88 | 50.42 | 2023-08-22 | 3 | 713.08 | 1 | 2016.88 | 46 | SO51092 | 2023-08-29 | 161.35 | 2139.24 | 672.29 | |||
SO50246_8 | F243-44EB-B2 | PO1827174701 | 19 | 291 | 439 | 317 | 6 | 2023-07-04 | 2342.45 | 58.56 | 2023-06-22 | 3 | 722.26 | 1 | 2342.45 | 8 | SO50246 | 2023-06-29 | 187.40 | 2166.77 | 780.82 | |||
SO51124_27 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 306 | 245 | 6 | 2023-09-03 | 2429.28 | 60.73 | 2023-08-22 | 3 | 739.04 | 1 | 2429.28 | 27 | SO51124 | 2023-08-29 | 194.34 | 2217.12 | 809.76 | |||
SO58957_1 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 474 | 3 | 685 | 6 | 34.65 | 2024-02-03 | 692.90 | 16.46 | 2024-01-22 | 18 | 26.18 | 1 | 658.26 | 1 | SO58957 | 2024-01-29 | 52.66 | 471.17 | 38.49 | 0.05 |
SO48299_16 | ABFA-41A9-A7 | PO18299110324 | 19 | 291 | 297 | 118 | 6 | 2023-02-03 | 2208.44 | 55.21 | 2023-01-22 | 3 | 653.70 | 1 | 2208.44 | 16 | SO48299 | 2023-01-29 | 176.67 | 1961.09 | 736.15 | |||
SO63140_7 | 0582-4EB7-B7 | PO17661112720 | 19 | 284 | 568 | 264 | 6 | 2024-04-05 | 890.82 | 22.27 | 2024-03-24 | 2 | 461.44 | 1 | 890.82 | 7 | SO63140 | 2024-03-31 | 71.27 | 922.89 | 445.41 | |||
SO49066_2 | 4065-4B0A-A2 | PO1595117888 | 19 | 284 | 333 | 426 | 6 | 2023-04-06 | 939.59 | 23.49 | 2023-03-25 | 2 | 486.71 | 1 | 939.59 | 2 | SO49066 | 2023-04-01 | 75.17 | 973.41 | 469.79 |
Generated 2024-09-21 09:43:50.541 UTC