[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53530_18 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 606 | 2 | 90 | 5 | 68.90 | 2023-11-02 | 3445.14 | 84.41 | 2023-10-21 | 11 | 343.65 | 1 | 3376.23 | 18 | SO53530 | 2023-10-28 | 270.10 | 3780.15 | 313.19 | 0.02 |
SO44506_2 | CD67-4B07-B6 | PO16327113845 | 100 | 285 | 212 | 584 | 5 | 2022-01-02 | 60.56 | 1.51 | 2021-12-21 | 3 | 12.03 | 1 | 60.56 | 2 | SO44506 | 2021-12-28 | 4.84 | 36.08 | 20.19 | |||
SO46996_36 | 775B-42D6-A5 | PO11571149031 | 100 | 285 | 323 | 512 | 5 | 2022-10-02 | 469.79 | 11.74 | 2022-09-20 | 1 | 486.71 | 1 | 469.79 | 36 | SO46996 | 2022-09-27 | 37.58 | 486.71 | 469.79 | |||
SO51147_27 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 580 | 81 | 5 | 2023-09-01 | 10205.94 | 255.15 | 2023-08-20 | 10 | 1082.51 | 1 | 10205.94 | 27 | SO51147 | 2023-08-27 | 816.48 | 10825.10 | 1020.59 | |||
SO44297_5 | 12D6-4286-A3 | PO11861112978 | 100 | 281 | 223 | 17 | 5 | 2021-12-02 | 15.56 | 0.39 | 2021-11-20 | 3 | 5.71 | 1 | 15.56 | 5 | SO44297 | 2021-11-27 | 1.24 | 17.12 | 5.19 | |||
SO47042_32 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 362 | 566 | 5 | 2022-10-02 | 1229.46 | 30.74 | 2022-09-20 | 1 | 1105.81 | 1 | 1229.46 | 32 | SO47042 | 2022-09-27 | 98.36 | 1105.81 | 1229.46 | |||
SO71839_12 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 579 | 611 | 5 | 2024-08-02 | 7289.10 | 182.23 | 2024-07-21 | 10 | 755.15 | 1 | 7289.10 | 12 | SO71839 | 2024-07-28 | 583.13 | 7551.51 | 728.91 | |||
SO46387_2 | 5AA4-4F68-A1 | PO9599173396 | 100 | 285 | 316 | 170 | 5 | 2022-08-02 | 2624.38 | 65.61 | 2022-07-21 | 3 | 884.71 | 1 | 2624.38 | 2 | SO46387 | 2022-07-28 | 209.95 | 2654.12 | 874.79 | |||
SO57149_3 | C32D-4E78-97 | PO5568130124 | 100 | 285 | 475 | 422 | 5 | 2024-01-02 | 41.99 | 1.05 | 2023-12-21 | 1 | 26.18 | 1 | 41.99 | 3 | SO57149 | 2023-12-28 | 3.36 | 26.18 | 41.99 | |||
SO47454_34 | E249-41EE-95 | PO9570119946 | 100 | 285 | 410 | 585 | 5 | 2022-11-02 | 72.89 | 1.82 | 2022-10-21 | 2 | 26.97 | 1 | 72.89 | 34 | SO47454 | 2022-10-28 | 5.83 | 53.94 | 36.45 | |||
SO46672_37 | FFCF-4848-99 | PO9831178966 | 100 | 285 | 445 | 81 | 5 | 2022-09-01 | 143.98 | 3.60 | 2022-08-20 | 4 | 24.75 | 1 | 143.98 | 37 | SO46672 | 2022-08-27 | 11.52 | 98.98 | 35.99 | |||
SO67348_1 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 593 | 494 | 5 | 2024-06-02 | 338.99 | 8.47 | 2024-05-21 | 1 | 308.22 | 1 | 338.99 | 1 | SO67348 | 2024-05-28 | 27.12 | 308.22 | 338.99 | |||
SO67349_17 | 7BC2-4E87-BA | PO9831186318 | 100 | 285 | 487 | 81 | 5 | 2024-06-02 | 98.98 | 2.47 | 2024-05-21 | 3 | 20.57 | 1 | 98.98 | 17 | SO67349 | 2024-05-28 | 7.92 | 61.70 | 32.99 | |||
SO55331_21 | 4195-4A79-A3 | PO9889143385 | 100 | 285 | 591 | 494 | 5 | 2023-12-02 | 338.99 | 8.47 | 2023-11-20 | 1 | 308.22 | 1 | 338.99 | 21 | SO55331 | 2023-11-27 | 27.12 | 308.22 | 338.99 | |||
SO47703_7 | 0E62-43AC-8E | PO3741184156 | 100 | 285 | 327 | 404 | 5 | 2022-12-02 | 469.79 | 11.74 | 2022-11-20 | 1 | 486.71 | 1 | 469.79 | 7 | SO47703 | 2022-11-27 | 37.58 | 486.71 | 469.79 | |||
SO53474_26 | E5B6-4103-8D | PO15457187993 | 100 | 285 | 585 | 13 | 297 | 5 | 50.11 | 2023-11-02 | 334.06 | 7.10 | 2023-10-21 | 1 | 461.44 | 1 | 283.95 | 26 | SO53474 | 2023-10-28 | 22.72 | 461.44 | 334.06 | 0.15 |
SO48395_11 | 46D3-4C51-AD | PO9570174316 | 100 | 285 | 468 | 585 | 5 | 2023-02-01 | 45.59 | 1.14 | 2023-01-20 | 2 | 15.67 | 1 | 45.59 | 11 | SO48395 | 2023-01-27 | 3.65 | 31.34 | 22.79 | |||
SO57118_14 | 69CB-481B-8D | PO5800191707 | 100 | 285 | 363 | 63 | 5 | 2024-01-02 | 2753.99 | 68.85 | 2023-12-21 | 2 | 1251.98 | 1 | 2753.99 | 14 | SO57118 | 2023-12-28 | 220.32 | 2503.96 | 1376.99 | |||
SO67277_39 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 298 | 530 | 5 | 2024-06-02 | 2429.28 | 60.73 | 2024-05-21 | 3 | 739.04 | 1 | 2429.28 | 39 | SO67277 | 2024-05-28 | 194.34 | 2217.12 | 809.76 | |||
SO45815_10 | 80EF-464E-97 | PO9657174967 | 100 | 285 | 344 | 315 | 5 | 2022-06-02 | 2039.99 | 51.00 | 2022-05-21 | 1 | 1912.15 | 1 | 2039.99 | 10 | SO45815 | 2022-05-28 | 163.20 | 1912.15 | 2039.99 | |||
SO47965_10 | 953F-437D-84 | PO19546111394 | 100 | 285 | 273 | 206 | 5 | 2023-01-02 | 607.00 | 15.17 | 2022-12-21 | 3 | 187.16 | 1 | 607.00 | 10 | SO47965 | 2022-12-28 | 48.56 | 561.47 | 202.33 | |||
SO61217_7 | 9B9A-4C8B-93 | PO9889149314 | 100 | 285 | 511 | 494 | 5 | 2024-03-03 | 218.45 | 5.46 | 2024-02-20 | 1 | 199.38 | 1 | 218.45 | 7 | SO61217 | 2024-02-27 | 17.48 | 199.38 | 218.45 | |||
SO44761_7 | FD24-4EF8-9E | PO13746123317 | 100 | 285 | 349 | 567 | 5 | 2022-02-01 | 4049.99 | 101.25 | 2022-01-20 | 2 | 1898.09 | 1 | 4049.99 | 7 | SO44761 | 2022-01-27 | 324.00 | 3796.19 | 2024.99 | |||
SO51775_25 | 5DF8-4C96-81 | PO2842127356 | 100 | 285 | 380 | 700 | 5 | 2023-10-02 | 1466.01 | 36.65 | 2023-09-20 | 1 | 1554.95 | 1 | 1466.01 | 25 | SO51775 | 2023-09-27 | 117.28 | 1554.95 | 1466.01 | |||
SO50306_12 | D376-4A40-86 | PO5858194676 | 100 | 285 | 457 | 566 | 5 | 2023-07-02 | 44.99 | 1.12 | 2023-06-20 | 1 | 30.93 | 1 | 44.99 | 12 | SO50306 | 2023-06-27 | 3.60 | 30.93 | 44.99 | |||
SO47726_13 | 7256-4599-93 | PO9657190563 | 100 | 285 | 224 | 315 | 5 | 2022-12-02 | 10.37 | 0.26 | 2022-11-20 | 2 | 5.23 | 1 | 10.37 | 13 | SO47726 | 2022-11-27 | 0.83 | 10.46 | 5.19 | |||
SO46604_7 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 354 | 676 | 5 | 2022-09-01 | 4971.41 | 124.29 | 2022-08-20 | 4 | 1117.86 | 1 | 4971.41 | 7 | SO46604 | 2022-08-27 | 397.71 | 4471.42 | 1242.85 | |||
SO63281_10 | 6B19-4C4E-92 | PO3596158829 | 100 | 285 | 595 | 476 | 5 | 2024-04-03 | 677.99 | 16.95 | 2024-03-22 | 2 | 308.22 | 1 | 677.99 | 10 | SO63281 | 2024-03-29 | 54.24 | 616.44 | 338.99 | |||
SO49090_3 | BA90-48D0-89 | PO11571148651 | 100 | 285 | 327 | 512 | 5 | 2023-04-04 | 1409.38 | 35.23 | 2023-03-23 | 3 | 486.71 | 1 | 1409.38 | 3 | SO49090 | 2023-03-30 | 112.75 | 1460.12 | 469.79 | |||
SO46971_17 | 5CEA-463B-A2 | PO15051144269 | 100 | 285 | 399 | 207 | 5 | 2022-10-02 | 67.55 | 1.69 | 2022-09-20 | 2 | 24.99 | 1 | 67.55 | 17 | SO46971 | 2022-09-27 | 5.40 | 49.99 | 33.77 | |||
SO48393_36 | 5B6A-41B6-BF | PO9599137631 | 100 | 285 | 321 | 170 | 5 | 2023-02-01 | 3758.35 | 93.96 | 2023-01-20 | 8 | 486.71 | 1 | 3758.35 | 36 | SO48393 | 2023-01-27 | 300.67 | 3893.65 | 469.79 |
Generated 2024-09-19 23:52:25.195 UTC