[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2157 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46964_51 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 435 | 328 | 4 | 2022-10-02 | 973.36 | 24.33 | 2022-09-20 | 3 | 300.12 | 1 | 973.36 | 51 | SO46964 | 2022-09-27 | 77.87 | 900.36 | 324.45 | |||
SO51842_16 | 2A39-4E97-9A | PO4843199898 | 100 | 287 | 408 | 257 | 4 | 2023-10-02 | 144.32 | 3.61 | 2023-09-20 | 2 | 53.40 | 1 | 144.32 | 16 | SO51842 | 2023-09-27 | 11.55 | 106.80 | 72.16 | |||
SO71845_1 | 4781-4673-85 | PO2697119362 | 100 | 282 | 595 | 16 | 187 | 4 | 90.40 | 2024-08-02 | 226.00 | 3.39 | 2024-07-21 | 2 | 308.22 | 1 | 135.60 | 1 | SO71845 | 2024-07-28 | 10.85 | 616.44 | 113.00 | 0.40 |
SO47687_4 | 738F-43EE-95 | PO10817185499 | 100 | 287 | 456 | 203 | 4 | 2022-12-02 | 314.96 | 7.87 | 2022-11-20 | 7 | 30.93 | 1 | 314.96 | 4 | SO47687 | 2022-11-27 | 25.20 | 216.53 | 44.99 | |||
SO47369_37 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 267 | 239 | 4 | 2022-11-02 | 404.66 | 10.12 | 2022-10-21 | 2 | 187.16 | 1 | 404.66 | 37 | SO47369 | 2022-10-28 | 32.37 | 374.31 | 202.33 | |||
SO53621_53 | 9324-4A3D-83 | PO9715186811 | 100 | 281 | 556 | 490 | 4 | 2023-11-02 | 526.47 | 13.16 | 2023-10-21 | 5 | 77.92 | 1 | 526.47 | 53 | SO53621 | 2023-10-28 | 42.12 | 389.59 | 105.29 | |||
SO71787_5 | 94A7-4406-B3 | PO18038111279 | 100 | 287 | 567 | 509 | 4 | 2024-08-02 | 890.82 | 22.27 | 2024-07-21 | 2 | 461.44 | 1 | 890.82 | 5 | SO71787 | 2024-07-28 | 71.27 | 922.89 | 445.41 | |||
SO49890_12 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 448 | 221 | 4 | 2023-06-02 | 11.99 | 0.30 | 2023-05-21 | 1 | 8.25 | 1 | 11.99 | 12 | SO49890 | 2023-05-28 | 0.96 | 8.25 | 11.99 | |||
SO71848_1 | 7082-4BF5-AB | PO18763153352 | 100 | 287 | 576 | 59 | 4 | 2024-08-02 | 1430.44 | 35.76 | 2024-07-21 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO71848 | 2024-07-28 | 114.44 | 1481.94 | 1430.44 | |||
SO69501_13 | 8A65-4926-A6 | PO6525182870 | 100 | 281 | 558 | 345 | 4 | 2024-07-02 | 728.98 | 18.22 | 2024-06-20 | 3 | 179.82 | 1 | 728.98 | 13 | SO69501 | 2024-06-27 | 58.32 | 539.45 | 242.99 | |||
SO61184_32 | F33C-4C57-BD | PO16298116527 | 100 | 287 | 222 | 599 | 4 | 2024-03-03 | 83.98 | 2.10 | 2024-02-20 | 4 | 13.09 | 1 | 83.98 | 32 | SO61184 | 2024-02-27 | 6.72 | 52.35 | 20.99 | |||
SO47720_12 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 459 | 221 | 4 | 2022-12-02 | 377.96 | 9.45 | 2022-11-20 | 7 | 37.12 | 1 | 377.96 | 12 | SO47720 | 2022-11-27 | 30.24 | 259.85 | 53.99 | |||
SO48375_33 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 297 | 75 | 4 | 2023-02-01 | 2944.58 | 73.61 | 2023-01-20 | 4 | 653.70 | 1 | 2944.58 | 33 | SO48375 | 2023-01-27 | 235.57 | 2614.79 | 736.15 | |||
SO44301_5 | 34BE-4E85-85 | PO10730158868 | 100 | 287 | 318 | 491 | 4 | 2021-12-02 | 2624.38 | 65.61 | 2021-11-20 | 3 | 884.71 | 1 | 2624.38 | 5 | SO44301 | 2021-11-27 | 209.95 | 2654.12 | 874.79 | |||
SO71782_10 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 578 | 582 | 4 | 2024-08-02 | 2915.64 | 72.89 | 2024-07-21 | 4 | 755.15 | 1 | 2915.64 | 10 | SO71782 | 2024-07-28 | 233.25 | 3020.60 | 728.91 | |||
SO46960_10 | F05E-41EB-90 | PO16762181648 | 100 | 282 | 329 | 259 | 4 | 2022-10-02 | 1409.38 | 35.23 | 2022-09-20 | 3 | 486.71 | 1 | 1409.38 | 10 | SO46960 | 2022-09-27 | 112.75 | 1460.12 | 469.79 | |||
SO57042_11 | 52C4-4348-BC | PO15196150289 | 100 | 282 | 604 | 258 | 4 | 2024-01-02 | 647.99 | 16.20 | 2023-12-21 | 2 | 343.65 | 1 | 647.99 | 11 | SO57042 | 2023-12-28 | 51.84 | 687.30 | 323.99 | |||
SO46648_18 | 2073-4051-9E | PO2494191557 | 100 | 283 | 394 | 184 | 4 | 2022-09-01 | 61.56 | 1.54 | 2022-08-20 | 3 | 15.18 | 1 | 61.56 | 18 | SO46648 | 2022-08-27 | 4.92 | 45.55 | 20.52 | |||
SO50310_5 | FCBD-48EE-A9 | PO6438126969 | 100 | 281 | 367 | 309 | 4 | 2023-07-02 | 5831.95 | 145.80 | 2023-06-20 | 9 | 598.44 | 1 | 5831.95 | 5 | SO50310 | 2023-06-27 | 466.56 | 5385.92 | 647.99 | |||
SO50672_12 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 462 | 239 | 4 | 2023-08-02 | 56.52 | 1.41 | 2023-07-21 | 4 | 9.71 | 1 | 56.52 | 12 | SO50672 | 2023-07-28 | 4.52 | 38.85 | 14.13 | |||
SO47434_33 | 6848-4C33-98 | PO5539145068 | 100 | 282 | 470 | 61 | 4 | 2022-11-02 | 182.35 | 4.56 | 2022-10-21 | 8 | 15.67 | 1 | 182.35 | 33 | SO47434 | 2022-10-28 | 14.59 | 125.37 | 22.79 | |||
SO49821_31 | 0B9B-460C-BC | PO551117366 | 100 | 281 | 435 | 4 | 4 | 2023-06-02 | 973.36 | 24.33 | 2023-05-21 | 3 | 300.12 | 1 | 973.36 | 31 | SO49821 | 2023-05-28 | 77.87 | 900.36 | 324.45 | |||
SO47456_18 | 840E-4252-B7 | PO9715175233 | 100 | 283 | 358 | 490 | 4 | 2022-11-02 | 6147.29 | 153.68 | 2022-10-21 | 5 | 1105.81 | 1 | 6147.29 | 18 | SO47456 | 2022-10-28 | 491.78 | 5529.05 | 1229.46 | |||
SO47990_27 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 433 | 328 | 4 | 2023-01-02 | 2595.62 | 64.89 | 2022-12-21 | 8 | 300.12 | 1 | 2595.62 | 27 | SO47990 | 2022-12-28 | 207.65 | 2400.95 | 324.45 | |||
SO50747_30 | A59F-46DA-BE | PO5597196496 | 100 | 281 | 352 | 75 | 4 | 2023-08-02 | 3728.56 | 93.21 | 2023-07-21 | 3 | 1117.86 | 1 | 3728.56 | 30 | SO50747 | 2023-07-28 | 298.28 | 3353.57 | 1242.85 | |||
SO58984_2 | 5D72-43BF-AB | PO16153135798 | 100 | 282 | 552 | 186 | 4 | 2024-02-01 | 109.79 | 2.74 | 2024-01-20 | 2 | 40.62 | 1 | 109.79 | 2 | SO58984 | 2024-01-27 | 8.78 | 81.24 | 54.89 | |||
SO50738_3 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 325 | 130 | 4 | 2023-08-02 | 2348.97 | 58.72 | 2023-07-21 | 5 | 486.71 | 1 | 2348.97 | 3 | SO50738 | 2023-07-28 | 187.92 | 2433.53 | 469.79 | |||
SO45074_11 | 7225-40DF-B0 | PO7859191751 | 100 | 287 | 285 | 221 | 4 | 2022-03-04 | 357.16 | 8.93 | 2022-02-20 | 2 | 176.20 | 1 | 357.16 | 11 | SO45074 | 2022-02-27 | 28.57 | 352.40 | 178.58 | |||
SO51827_27 | B106-4221-AD | PO4611117026 | 100 | 287 | 572 | 13 | 131 | 4 | 200.43 | 2023-10-02 | 1336.23 | 28.39 | 2023-09-20 | 4 | 461.44 | 1 | 1135.80 | 27 | SO51827 | 2023-09-27 | 90.86 | 1845.78 | 334.06 | 0.15 |
SO55276_10 | 81AA-41E5-B0 | PO2755182998 | 100 | 282 | 498 | 205 | 4 | 2023-12-02 | 1204.69 | 30.12 | 2023-11-20 | 2 | 601.74 | 1 | 1204.69 | 10 | SO55276 | 2023-11-27 | 96.38 | 1203.49 | 602.35 | |||
SO48295_16 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 433 | 24 | 4 | 2023-02-01 | 324.45 | 8.11 | 2023-01-20 | 1 | 300.12 | 1 | 324.45 | 16 | SO48295 | 2023-01-27 | 25.96 | 300.12 | 324.45 |
Generated 2024-09-20 01:29:01.992 UTC