[ROOT] dt FactResellerSale < WHERE DimProductId EQ ALL SHUFFLE < SKIP 1657 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53475_13 | FFE3-4820-88 | PO15515192405 | 100 | 292 | 243 | 481 | 7 | 2023-11-02 | 1717.80 | 42.95 | 2023-10-21 | 2 | 868.63 | 1 | 1717.80 | 13 | SO53475 | 2023-10-28 | 137.42 | 1737.27 | 858.90 | |||
SO45071_4 | BD58-4690-B0 | PO6235158205 | 100 | 281 | 322 | 431 | 3 | 2022-03-04 | 419.46 | 10.49 | 2022-02-20 | 1 | 413.15 | 1 | 419.46 | 4 | SO45071 | 2022-02-27 | 33.56 | 413.15 | 419.46 | |||
SO46608_3 | ACF1-4852-B7 | PO18473177913 | 19 | 291 | 466 | 442 | 6 | 2022-09-01 | 42.39 | 1.06 | 2022-08-20 | 3 | 9.71 | 1 | 42.39 | 3 | SO46608 | 2022-08-27 | 3.39 | 29.14 | 14.13 | |||
SO45342_4 | 9E99-4922-A4 | PO7917111421 | 100 | 287 | 349 | 401 | 1 | 2022-04-04 | 4049.99 | 101.25 | 2022-03-23 | 2 | 1898.09 | 1 | 4049.99 | 4 | SO45342 | 2022-03-30 | 324.00 | 3796.19 | 2024.99 | |||
SO51845_1 | 6AB8-4CEA-A9 | PO3799111961 | 100 | 282 | 516 | 312 | 4 | 2023-10-02 | 70.45 | 1.76 | 2023-09-20 | 3 | 17.38 | 1 | 70.45 | 1 | SO51845 | 2023-09-27 | 5.64 | 52.13 | 23.48 | |||
SO48356_2 | 3E64-467F-90 | PO2697152207 | 100 | 282 | 352 | 187 | 4 | 2023-02-01 | 1242.85 | 31.07 | 2023-01-20 | 1 | 1117.86 | 1 | 1242.85 | 2 | SO48356 | 2023-01-27 | 99.43 | 1117.86 | 1242.85 | |||
SO47703_6 | 0E62-43AC-8E | PO3741184156 | 100 | 285 | 343 | 404 | 5 | 2022-12-02 | 1409.38 | 35.23 | 2022-11-20 | 3 | 486.71 | 1 | 1409.38 | 6 | SO47703 | 2022-11-27 | 112.75 | 1460.12 | 469.79 | |||
SO46348_7 | CF4C-437D-97 | PO13543132672 | 100 | 287 | 307 | 293 | 1 | 2022-08-02 | 2167.78 | 54.19 | 2022-07-21 | 3 | 623.84 | 1 | 2167.78 | 7 | SO46348 | 2022-07-28 | 173.42 | 1871.52 | 722.59 | |||
SO67276_7 | 9FD9-4B05-AA | PO13340158801 | 100 | 292 | 357 | 355 | 7 | 2024-06-02 | 4175.98 | 104.40 | 2024-05-21 | 3 | 1265.62 | 1 | 4175.98 | 7 | SO67276 | 2024-05-28 | 334.08 | 3796.86 | 1391.99 | |||
SO43845_5 | 2E65-4D8B-9A | PO19546184286 | 100 | 285 | 324 | 206 | 5 | 2021-10-02 | 838.92 | 20.97 | 2021-09-20 | 2 | 413.15 | 1 | 838.92 | 5 | SO43845 | 2021-09-27 | 67.11 | 826.29 | 419.46 | |||
SO45278_9 | 7EE7-4F70-81 | PO18415191281 | 19 | 288 | 336 | 191 | 6 | 2022-04-04 | 419.46 | 10.49 | 2022-03-23 | 1 | 413.15 | 1 | 419.46 | 9 | SO45278 | 2022-03-30 | 33.56 | 413.15 | 419.46 | |||
SO46091_2 | 6DCB-4063-BA | PO6293193126 | 100 | 285 | 328 | 612 | 5 | 2022-07-02 | 1258.38 | 31.46 | 2022-06-20 | 3 | 413.15 | 1 | 1258.38 | 2 | SO46091 | 2022-06-27 | 100.67 | 1239.44 | 419.46 | |||
SO47973_25 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 433 | 479 | 6 | 2023-01-02 | 324.45 | 8.11 | 2022-12-21 | 1 | 300.12 | 1 | 324.45 | 25 | SO47973 | 2022-12-28 | 25.96 | 300.12 | 324.45 | |||
SO48048_45 | B414-46CB-BA | PO3480117933 | 100 | 283 | 453 | 436 | 4 | 2023-01-02 | 179.97 | 4.50 | 2022-12-21 | 5 | 24.75 | 1 | 179.97 | 45 | SO48048 | 2022-12-28 | 14.40 | 123.73 | 35.99 | |||
SO47439_28 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 447 | 3 | 4 | 2022-11-02 | 120.00 | 3.00 | 2022-10-21 | 8 | 10.31 | 1 | 120.00 | 28 | SO47439 | 2022-10-28 | 9.60 | 82.50 | 15.00 | |||
SO69460_8 | D5C8-450E-9F | PO1595193276 | 19 | 284 | 434 | 426 | 6 | 2024-07-02 | 1070.69 | 26.77 | 2024-06-20 | 3 | 360.94 | 1 | 1070.69 | 8 | SO69460 | 2024-06-27 | 85.66 | 1082.83 | 356.90 | |||
SO51170_7 | C764-4927-87 | PO5423111367 | 36 | 290 | 384 | 639 | 8 | 2023-09-01 | 672.29 | 16.81 | 2023-08-20 | 1 | 713.08 | 1 | 672.29 | 7 | SO51170 | 2023-08-27 | 53.78 | 713.08 | 672.29 | |||
SO51691_12 | 8F72-4342-A4 | PO19923122474 | 100 | 283 | 531 | 18 | 3 | 2023-10-02 | 299.75 | 7.49 | 2023-09-20 | 2 | 136.79 | 1 | 299.75 | 12 | SO51691 | 2023-09-27 | 23.98 | 273.57 | 149.87 | |||
SO65200_21 | C4A9-49C4-AE | PO841148607 | 100 | 286 | 295 | 254 | 1 | 2024-05-02 | 818.70 | 20.47 | 2024-04-20 | 1 | 747.20 | 1 | 818.70 | 21 | SO65200 | 2024-04-27 | 65.50 | 747.20 | 818.70 | |||
SO43884_22 | 728A-44AB-A8 | PO10440182311 | 100 | 283 | 229 | 623 | 3 | 2021-10-02 | 28.84 | 0.72 | 2021-09-20 | 1 | 31.72 | 1 | 28.84 | 22 | SO43884 | 2021-09-27 | 2.31 | 31.72 | 28.84 | |||
SO51741_5 | 96BB-4004-AE | PO12383191952 | 100 | 283 | 482 | 3 | 89 | 2 | 4.70 | 2023-10-02 | 93.95 | 2.23 | 2023-09-20 | 19 | 3.36 | 1 | 89.25 | 5 | SO51741 | 2023-09-27 | 7.14 | 63.88 | 4.94 | 0.05 |
SO67316_17 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 355 | 496 | 6 | 2024-06-02 | 8351.96 | 208.80 | 2024-05-21 | 6 | 1265.62 | 1 | 8351.96 | 17 | SO67316 | 2024-05-28 | 668.16 | 7593.72 | 1391.99 | |||
SO69415_15 | 3D39-4844-B5 | PO15080175978 | 100 | 292 | 572 | 283 | 7 | 2024-07-02 | 445.41 | 11.14 | 2024-06-20 | 1 | 461.44 | 1 | 445.41 | 15 | SO69415 | 2024-06-27 | 35.63 | 461.44 | 445.41 | |||
SO47033_45 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 423 | 343 | 1 | 2022-10-02 | 165.23 | 4.13 | 2022-09-20 | 1 | 122.27 | 1 | 165.23 | 45 | SO47033 | 2022-09-27 | 13.22 | 122.27 | 165.23 | |||
SO50297_27 | 5199-40AD-90 | PO4727113542 | 100 | 293 | 387 | 343 | 1 | 2023-07-02 | 3001.31 | 75.03 | 2023-06-20 | 5 | 605.65 | 1 | 3001.31 | 27 | SO50297 | 2023-06-27 | 240.11 | 3028.25 | 600.26 | |||
SO45779_5 | 983F-42E3-90 | PO522162183 | 100 | 285 | 307 | 676 | 5 | 2022-06-02 | 722.59 | 18.06 | 2022-05-21 | 1 | 623.84 | 1 | 722.59 | 5 | SO45779 | 2022-05-28 | 57.81 | 623.84 | 722.59 | |||
SO50759_1 | E56C-42C1-A9 | PO9744159893 | 100 | 285 | 358 | 98 | 5 | 2023-08-02 | 1229.46 | 30.74 | 2023-07-21 | 1 | 1105.81 | 1 | 1229.46 | 1 | SO50759 | 2023-07-28 | 98.36 | 1105.81 | 1229.46 | |||
SO57154_35 | 464B-46A4-B6 | PO1856185040 | 19 | 291 | 463 | 263 | 6 | 2024-01-02 | 73.47 | 1.84 | 2023-12-21 | 5 | 9.16 | 1 | 73.47 | 35 | SO57154 | 2023-12-28 | 5.88 | 45.80 | 14.69 | |||
SO59058_1 | 98B6-49AA-A5 | PO7047118388 | 100 | 281 | 533 | 544 | 3 | 2024-02-01 | 149.87 | 3.75 | 2024-01-20 | 1 | 136.79 | 1 | 149.87 | 1 | SO59058 | 2024-01-27 | 11.99 | 136.79 | 149.87 | |||
SO61229_34 | AC88-46DA-A3 | PO10324197030 | 98 | 288 | 295 | 196 | 10 | 2024-03-03 | 818.70 | 20.47 | 2024-02-20 | 1 | 747.20 | 1 | 818.70 | 34 | SO61229 | 2024-02-27 | 65.50 | 747.20 | 818.70 | |||
SO53586_5 | 37CB-4A82-96 | PO4002170204 | 100 | 282 | 477 | 674 | 4 | 2023-11-02 | 14.97 | 0.37 | 2023-10-21 | 5 | 1.87 | 1 | 14.97 | 5 | SO53586 | 2023-10-28 | 1.20 | 9.33 | 2.99 |
Generated 2024-09-19 14:46:17.175 UTC