[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 907 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46671_5 | 13F6-4858-8D | PO8787194061 | 100 | 282 | 375 | 523 | 3 | 2022-08-31 | 5235.75 | 130.89 | 2022-08-19 | 4 | 1320.68 | 1 | 5235.75 | 5 | SO46671 | 2022-08-26 | 418.86 | 5282.74 | 1308.94 | |||
SO51100_20 | A159-4950-A0 | PO13862191766 | 19 | 291 | 542 | 119 | 6 | 2023-08-31 | 72.88 | 1.82 | 2023-08-19 | 3 | 17.98 | 1 | 72.88 | 20 | SO51100 | 2023-08-26 | 5.83 | 53.93 | 24.29 | |||
SO48307_41 | 7DE5-4D74-A7 | PO17545123793 | 19 | 291 | 230 | 155 | 6 | 2023-01-31 | 230.72 | 5.77 | 2023-01-19 | 8 | 29.08 | 1 | 230.72 | 41 | SO48307 | 2023-01-26 | 18.46 | 232.65 | 28.84 | |||
SO50245_8 | 28E4-4CC9-BF | PO1914152990 | 19 | 284 | 216 | 66 | 6 | 2023-07-01 | 121.12 | 3.03 | 2023-06-19 | 6 | 13.88 | 1 | 121.12 | 8 | SO50245 | 2023-06-26 | 9.69 | 83.27 | 20.19 | |||
SO51706_11 | EC0B-4A2D-A1 | PO16762139224 | 100 | 282 | 488 | 259 | 4 | 2023-10-01 | 129.58 | 3.24 | 2023-09-19 | 4 | 41.57 | 1 | 129.58 | 11 | SO51706 | 2023-09-26 | 10.37 | 166.29 | 32.39 | |||
SO47991_6 | 0F2E-4E6D-8E | PO15631116034 | 100 | 282 | 352 | 43 | 1 | 2023-01-01 | 7457.11 | 186.43 | 2022-12-20 | 6 | 1117.86 | 1 | 7457.11 | 6 | SO47991 | 2022-12-27 | 596.57 | 6707.14 | 1242.85 | |||
SO49063_2 | 3E8C-4275-B6 | PO609128703 | 100 | 282 | 470 | 492 | 4 | 2023-04-03 | 91.18 | 2.28 | 2023-03-22 | 4 | 15.67 | 1 | 91.18 | 2 | SO49063 | 2023-03-29 | 7.29 | 62.68 | 22.79 | |||
SO51168_25 | 10E0-426C-9D | PO3509110394 | 36 | 292 | 463 | 139 | 7 | 2023-08-31 | 44.08 | 1.10 | 2023-08-19 | 3 | 9.16 | 1 | 44.08 | 25 | SO51168 | 2023-08-26 | 3.53 | 27.48 | 14.69 | |||
SO49834_8 | 633E-4103-A3 | PO13485138907 | 100 | 292 | 360 | 265 | 7 | 2023-06-01 | 1229.46 | 30.74 | 2023-05-20 | 1 | 1105.81 | 1 | 1229.46 | 8 | SO49834 | 2023-05-27 | 98.36 | 1105.81 | 1229.46 | |||
SO51109_3 | 0EFE-4639-BE | PO12441177944 | 36 | 295 | 507 | 302 | 8 | 2023-08-31 | 200.05 | 5.00 | 2023-08-19 | 1 | 199.85 | 1 | 200.05 | 3 | SO51109 | 2023-08-26 | 16.00 | 199.85 | 200.05 | |||
SO46662_5 | 07F7-472E-AC | PO6467187386 | 100 | 281 | 335 | 660 | 3 | 2022-08-31 | 4228.15 | 105.70 | 2022-08-19 | 9 | 486.71 | 1 | 4228.15 | 5 | SO46662 | 2022-08-26 | 338.25 | 4380.36 | 469.79 | |||
SO65251_1 | 21EB-4282-A4 | PO11107110635 | 19 | 284 | 481 | 156 | 6 | 2024-05-01 | 21.58 | 0.54 | 2024-04-19 | 4 | 3.36 | 1 | 21.58 | 1 | SO65251 | 2024-04-26 | 1.73 | 13.45 | 5.39 | |||
SO45546_5 | B424-4A7F-B4 | PO10585114494 | 19 | 272 | 350 | 498 | 6 | 2022-05-01 | 2024.99 | 50.62 | 2022-04-19 | 1 | 1898.09 | 1 | 2024.99 | 5 | SO45546 | 2022-04-26 | 162.00 | 1898.09 | 2024.99 | |||
SO69408_30 | 8DF5-4377-9D | PO16414161428 | 100 | 289 | 592 | 16 | 236 | 1 | 135.60 | 2024-07-01 | 338.99 | 5.08 | 2024-06-19 | 3 | 308.22 | 1 | 203.40 | 30 | SO69408 | 2024-06-26 | 16.27 | 924.65 | 113.00 | 0.40 |
SO47052_36 | 1AAD-4284-B8 | PO7424197138 | 100 | 281 | 453 | 642 | 2 | 2022-10-01 | 143.98 | 3.60 | 2022-09-19 | 4 | 24.75 | 1 | 143.98 | 36 | SO47052 | 2022-09-26 | 11.52 | 98.98 | 35.99 | |||
SO69465_36 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 372 | 700 | 5 | 2024-07-01 | 1466.01 | 36.65 | 2024-06-19 | 1 | 1554.95 | 1 | 1466.01 | 36 | SO69465 | 2024-06-26 | 117.28 | 1554.95 | 1466.01 | |||
SO47002_8 | BC9F-453B-99 | PO609116671 | 100 | 282 | 469 | 492 | 4 | 2022-10-01 | 91.18 | 2.28 | 2022-09-19 | 4 | 15.67 | 1 | 91.18 | 8 | SO47002 | 2022-09-26 | 7.29 | 62.68 | 22.79 | |||
SO69450_15 | 7050-466D-9B | PO10121172172 | 100 | 283 | 580 | 684 | 2 | 2024-07-01 | 10205.94 | 255.15 | 2024-06-19 | 10 | 1082.51 | 1 | 10205.94 | 15 | SO69450 | 2024-06-26 | 816.48 | 10825.10 | 1020.59 | |||
SO49877_4 | 493D-497C-AB | PO3828147687 | 100 | 283 | 397 | 414 | 2 | 2023-06-01 | 24.29 | 0.61 | 2023-05-20 | 1 | 17.98 | 1 | 24.29 | 4 | SO49877 | 2023-05-27 | 1.94 | 17.98 | 24.29 | |||
SO57086_8 | 9159-4FEC-A8 | PO2668146833 | 100 | 292 | 359 | 535 | 7 | 2024-01-01 | 8261.96 | 206.55 | 2023-12-20 | 6 | 1251.98 | 1 | 8261.96 | 8 | SO57086 | 2023-12-27 | 660.96 | 7511.89 | 1376.99 | |||
SO61258_19 | 9DCB-43A8-8D | PO3509137345 | 36 | 292 | 463 | 139 | 7 | 2024-03-02 | 102.86 | 2.57 | 2024-02-19 | 7 | 9.16 | 1 | 102.86 | 19 | SO61258 | 2024-02-26 | 8.23 | 64.12 | 14.69 | |||
SO69426_17 | 4194-45D7-B6 | PO13427130433 | 100 | 292 | 225 | 638 | 7 | 2024-07-01 | 32.36 | 0.81 | 2024-06-19 | 6 | 6.92 | 1 | 32.36 | 17 | SO69426 | 2024-06-26 | 2.59 | 41.53 | 5.39 | |||
SO47714_6 | 884B-4F33-A1 | PO6235113773 | 100 | 281 | 458 | 431 | 3 | 2022-12-01 | 179.98 | 4.50 | 2022-11-19 | 4 | 30.93 | 1 | 179.98 | 6 | SO47714 | 2022-11-26 | 14.40 | 123.73 | 44.99 | |||
SO48080_7 | 4DC7-4772-87 | PO7656157590 | 100 | 282 | 254 | 403 | 4 | 2023-01-01 | 1103.63 | 27.59 | 2022-12-20 | 6 | 170.14 | 1 | 1103.63 | 7 | SO48080 | 2022-12-27 | 88.29 | 1020.86 | 183.94 | |||
SO50292_14 | E329-4164-85 | PO3654177485 | 100 | 281 | 366 | 435 | 4 | 2023-07-01 | 1943.98 | 48.60 | 2023-06-19 | 3 | 598.44 | 1 | 1943.98 | 14 | SO50292 | 2023-06-26 | 155.52 | 1795.31 | 647.99 | |||
SO49159_2 | 15B4-4CCD-9A | PO7598122487 | 100 | 285 | 422 | 45 | 5 | 2023-04-03 | 202.62 | 5.07 | 2023-03-22 | 3 | 49.98 | 1 | 202.62 | 2 | SO49159 | 2023-03-29 | 16.21 | 149.94 | 67.54 | |||
SO65221_5 | 0AC4-40AE-B6 | PO15341198427 | 100 | 281 | 357 | 327 | 3 | 2024-05-01 | 2783.99 | 69.60 | 2024-04-19 | 2 | 1265.62 | 1 | 2783.99 | 5 | SO65221 | 2024-04-26 | 222.72 | 2531.24 | 1391.99 | |||
SO45793_6 | 0B18-49B2-96 | PO13775113238 | 100 | 281 | 326 | 618 | 2 | 2022-06-01 | 419.46 | 10.49 | 2022-05-20 | 1 | 413.15 | 1 | 419.46 | 6 | SO45793 | 2022-05-27 | 33.56 | 413.15 | 419.46 | |||
SO48772_5 | 5F71-41A2-93 | PO14355132784 | 98 | 288 | 333 | 286 | 10 | 2023-03-03 | 939.59 | 23.49 | 2023-02-19 | 2 | 486.71 | 1 | 939.59 | 5 | SO48772 | 2023-02-26 | 75.17 | 973.41 | 469.79 | |||
SO69533_23 | AC2B-4C39-84 | PO3596133486 | 100 | 285 | 353 | 2 | 476 | 5 | 296.03 | 2024-07-01 | 14801.54 | 362.64 | 2024-06-19 | 11 | 1265.62 | 1 | 14505.51 | 23 | SO69533 | 2024-06-26 | 1160.44 | 13921.81 | 1345.59 | 0.02 |
SO59075_41 | 1ED6-419E-AF | PO9628136689 | 100 | 283 | 471 | 2 | 179 | 2 | 8.10 | 2024-01-31 | 405.13 | 9.93 | 2024-01-19 | 11 | 23.75 | 1 | 397.03 | 41 | SO59075 | 2024-01-26 | 31.76 | 261.24 | 36.83 | 0.02 |
Generated 2024-09-18 22:36:11.335 UTC