[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 245 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46359_12 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 324 | 460 | 6 | 2022-08-03 | 838.92 | 20.97 | 2022-07-22 | 2 | 413.15 | 1 | 838.92 | 12 | SO46359 | 2022-07-29 | 67.11 | 826.29 | 419.46 | |||
SO67302_30 | E4B2-462D-AC | PO18473194134 | 19 | 291 | 516 | 442 | 6 | 2024-06-03 | 93.94 | 2.35 | 2024-05-22 | 4 | 17.38 | 1 | 93.94 | 30 | SO67302 | 2024-05-29 | 7.51 | 69.51 | 23.48 | |||
SO51781_13 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 474 | 65 | 6 | 2023-10-03 | 335.95 | 8.40 | 2023-09-21 | 8 | 26.18 | 1 | 335.95 | 13 | SO51781 | 2023-09-28 | 26.88 | 209.41 | 41.99 | |||
SO43668_20 | 365D-4C9A-BE | PO14732180295 | 19 | 288 | 338 | 514 | 6 | 2021-09-02 | 838.92 | 20.97 | 2021-08-21 | 2 | 413.15 | 1 | 838.92 | 20 | SO43668 | 2021-08-28 | 67.11 | 826.29 | 419.46 | |||
SO45527_20 | 610E-44BC-87 | PO17545114353 | 19 | 288 | 338 | 155 | 6 | 2022-05-03 | 1677.84 | 41.95 | 2022-04-21 | 4 | 413.15 | 1 | 1677.84 | 20 | SO45527 | 2022-04-28 | 134.23 | 1652.59 | 419.46 | |||
SO58918_25 | C811-4D40-80 | PO17574131484 | 19 | 291 | 465 | 678 | 6 | 2024-02-02 | 117.55 | 2.94 | 2024-01-21 | 8 | 9.16 | 1 | 117.55 | 25 | SO58918 | 2024-01-28 | 9.40 | 73.27 | 14.69 | |||
SO48033_40 | BC9E-4246-AC | PO1595118269 | 19 | 284 | 448 | 426 | 6 | 2023-01-03 | 47.98 | 1.20 | 2022-12-22 | 4 | 8.25 | 1 | 47.98 | 40 | SO48033 | 2022-12-29 | 3.84 | 32.98 | 11.99 | |||
SO44294_11 | F4DE-4BA0-B1 | PO13862172262 | 19 | 288 | 346 | 119 | 6 | 2021-12-03 | 4079.99 | 102.00 | 2021-11-21 | 2 | 1912.15 | 1 | 4079.99 | 11 | SO44294 | 2021-11-28 | 326.40 | 3824.31 | 2039.99 | |||
SO45038_2 | 2001-401A-83 | PO18473129920 | 19 | 288 | 232 | 442 | 6 | 2022-03-05 | 115.36 | 2.88 | 2022-02-21 | 4 | 31.72 | 1 | 115.36 | 2 | SO45038 | 2022-02-28 | 9.23 | 126.90 | 28.84 | |||
SO61177_21 | DA64-4BC0-A0 | PO18473117778 | 19 | 291 | 517 | 442 | 6 | 2024-03-04 | 31.58 | 0.79 | 2024-02-21 | 1 | 23.37 | 1 | 31.58 | 21 | SO61177 | 2024-02-28 | 2.53 | 23.37 | 31.58 | |||
SO50687_12 | DF8C-416B-BA | PO10962187340 | 19 | 284 | 362 | 685 | 6 | 2023-08-03 | 4917.84 | 122.95 | 2023-07-22 | 4 | 1105.81 | 1 | 4917.84 | 12 | SO50687 | 2023-07-29 | 393.43 | 4423.24 | 1229.46 | |||
SO51793_5 | D763-4929-9B | PO18705168707 | 19 | 291 | 583 | 479 | 6 | 2023-10-03 | 3061.78 | 76.54 | 2023-09-21 | 3 | 1082.51 | 1 | 3061.78 | 5 | SO51793 | 2023-09-28 | 244.94 | 3247.53 | 1020.59 | |||
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 | |||
SO67316_35 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 501 | 496 | 6 | 2024-06-03 | 145.75 | 3.64 | 2024-05-22 | 2 | 53.93 | 1 | 145.75 | 35 | SO67316 | 2024-05-29 | 11.66 | 107.86 | 72.88 | |||
SO46038_14 | D7B6-499A-87 | PO17748117802 | 19 | 284 | 316 | 102 | 6 | 2022-07-03 | 874.79 | 21.87 | 2022-06-21 | 1 | 884.71 | 1 | 874.79 | 14 | SO46038 | 2022-06-28 | 69.98 | 884.71 | 874.79 | |||
SO44525_2 | E0C6-40AA-AD | PO11600189203 | 19 | 288 | 342 | 569 | 6 | 2022-01-03 | 1677.84 | 41.95 | 2021-12-22 | 4 | 413.15 | 1 | 1677.84 | 2 | SO44525 | 2021-12-29 | 134.23 | 1652.59 | 419.46 | |||
SO51772_10 | 7800-4280-A7 | PO1827195162 | 19 | 291 | 382 | 317 | 6 | 2023-10-03 | 1344.59 | 33.61 | 2023-09-21 | 2 | 713.08 | 1 | 1344.59 | 10 | SO51772 | 2023-09-28 | 107.57 | 1426.16 | 672.29 | |||
SO47708_11 | 86B1-46A5-95 | PO4495147689 | 19 | 291 | 459 | 496 | 6 | 2022-12-03 | 215.98 | 5.40 | 2022-11-21 | 4 | 37.12 | 1 | 215.98 | 11 | SO47708 | 2022-11-28 | 17.28 | 148.48 | 53.99 | |||
SO47366_54 | DD3E-4DAA-BA | PO17545115575 | 19 | 291 | 242 | 155 | 6 | 2022-11-03 | 2342.45 | 58.56 | 2022-10-22 | 3 | 722.26 | 1 | 2342.45 | 54 | SO47366 | 2022-10-29 | 187.40 | 2166.77 | 780.82 | |||
SO57070_9 | A915-448D-82 | PO11020121552 | 19 | 284 | 546 | 336 | 6 | 2024-01-03 | 111.76 | 2.79 | 2023-12-22 | 3 | 27.57 | 1 | 111.76 | 9 | SO57070 | 2023-12-29 | 8.94 | 82.70 | 37.25 | |||
SO53508_6 | 38E7-428D-9B | PO11194139565 | 19 | 284 | 554 | 48 | 6 | 2023-11-03 | 54.94 | 1.37 | 2023-10-22 | 1 | 40.66 | 1 | 54.94 | 6 | SO53508 | 2023-10-29 | 4.40 | 40.66 | 54.94 | |||
SO49827_31 | E4F0-4B91-84 | PO15312199090 | 19 | 291 | 286 | 299 | 6 | 2023-06-03 | 551.81 | 13.80 | 2023-05-22 | 3 | 170.14 | 1 | 551.81 | 31 | SO49827 | 2023-05-29 | 44.15 | 510.43 | 183.94 | |||
SO55297_65 | 2455-4B60-A5 | PO4495126679 | 19 | 291 | 501 | 496 | 6 | 2023-12-03 | 145.75 | 3.64 | 2023-11-21 | 2 | 53.93 | 1 | 145.75 | 65 | SO55297 | 2023-11-28 | 11.66 | 107.86 | 72.88 | |||
SO50676_31 | 66F1-4A9A-97 | PO14790188963 | 19 | 291 | 356 | 497 | 6 | 2023-08-03 | 4971.41 | 124.29 | 2023-07-22 | 4 | 1117.86 | 1 | 4971.41 | 31 | SO50676 | 2023-07-29 | 397.71 | 4471.42 | 1242.85 | |||
SO47359_23 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 447 | 2 | 118 | 6 | 3.19 | 2022-11-03 | 159.50 | 3.91 | 2022-10-22 | 11 | 10.31 | 1 | 156.31 | 23 | SO47359 | 2022-10-29 | 12.50 | 113.44 | 14.50 | 0.02 |
SO44537_1 | 583D-4D33-9D | PO2175178820 | 19 | 288 | 229 | 137 | 6 | 2022-01-03 | 57.68 | 1.44 | 2021-12-22 | 2 | 31.72 | 1 | 57.68 | 1 | SO44537 | 2021-12-29 | 4.61 | 63.45 | 28.84 | |||
SO63237_4 | 0A83-4E05-B5 | PO11020119867 | 19 | 284 | 583 | 336 | 6 | 2024-04-04 | 3061.78 | 76.54 | 2024-03-23 | 3 | 1082.51 | 1 | 3061.78 | 4 | SO63237 | 2024-03-30 | 244.94 | 3247.53 | 1020.59 | |||
SO47960_1 | 04C4-49AA-9A | PO20039187120 | 19 | 291 | 458 | 65 | 6 | 2023-01-03 | 89.99 | 2.25 | 2022-12-22 | 2 | 30.93 | 1 | 89.99 | 1 | SO47960 | 2022-12-29 | 7.20 | 61.87 | 44.99 |
Generated 2024-09-21 02:47:23.490 UTC