[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 438 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO67346_9 | 545C-4C6E-88 | PO9338145989 | 100 | 293 | 562 | 451 | 1 | 2024-06-02 | 1430.44 | 35.76 | 2024-05-21 | 1 | 1481.94 | 1 | 1430.44 | 9 | SO67346 | 2024-05-28 | 114.44 | 1481.94 | 1430.44 | |||
SO49053_34 | 5BE4-4969-A1 | PO16414175823 | 100 | 289 | 216 | 236 | 1 | 2023-04-04 | 100.93 | 2.52 | 2023-03-23 | 5 | 13.88 | 1 | 100.93 | 34 | SO49053 | 2023-03-30 | 8.07 | 69.39 | 20.19 | |||
SO44121_6 | FE2E-4885-B3 | PO5220129819 | 100 | 282 | 347 | 169 | 1 | 2021-11-02 | 4079.99 | 102.00 | 2021-10-21 | 2 | 1912.15 | 1 | 4079.99 | 6 | SO44121 | 2021-10-28 | 326.40 | 3824.31 | 2039.99 | |||
SO49101_6 | 0549-4175-A0 | PO15573181395 | 100 | 293 | 358 | 487 | 1 | 2023-04-04 | 4917.84 | 122.95 | 2023-03-23 | 4 | 1105.81 | 1 | 4917.84 | 6 | SO49101 | 2023-03-30 | 393.43 | 4423.24 | 1229.46 | |||
SO71833_18 | 8525-4645-AB | PO10411123072 | 100 | 289 | 465 | 182 | 1 | 2024-08-02 | 44.08 | 1.10 | 2024-07-21 | 3 | 9.16 | 1 | 44.08 | 18 | SO71833 | 2024-07-28 | 3.53 | 27.48 | 14.69 | |||
SO46944_20 | 7854-48E8-92 | PO18676186070 | 100 | 282 | 470 | 3 | 697 | 1 | 16.72 | 2022-10-02 | 334.31 | 7.94 | 2022-09-20 | 16 | 15.67 | 1 | 317.60 | 20 | SO46944 | 2022-09-27 | 25.41 | 250.73 | 20.89 | 0.05 |
SO46348_8 | CF4C-437D-97 | PO13543132672 | 100 | 287 | 215 | 293 | 1 | 2022-08-02 | 181.68 | 4.54 | 2022-07-21 | 9 | 12.03 | 1 | 181.68 | 8 | SO46348 | 2022-07-28 | 14.53 | 108.25 | 20.19 | |||
SO51711_10 | 5CB8-480D-A1 | PO16414129790 | 100 | 289 | 306 | 236 | 1 | 2023-10-02 | 4858.56 | 121.46 | 2023-09-20 | 6 | 739.04 | 1 | 4858.56 | 10 | SO51711 | 2023-09-27 | 388.68 | 4434.25 | 809.76 | |||
SO59010_28 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 589 | 109 | 1 | 2024-02-01 | 1385.08 | 34.63 | 2024-01-20 | 3 | 419.78 | 1 | 1385.08 | 28 | SO59010 | 2024-01-27 | 110.81 | 1259.34 | 461.69 | |||
SO44100_18 | D5BC-4BB2-BF | PO13543119495 | 100 | 287 | 348 | 293 | 1 | 2021-11-02 | 8099.98 | 202.50 | 2021-10-21 | 4 | 1898.09 | 1 | 8099.98 | 18 | SO44100 | 2021-10-28 | 648.00 | 7592.38 | 2024.99 | |||
SO44075_2 | 2920-4332-89 | PO20155139653 | 100 | 289 | 344 | 92 | 1 | 2021-11-02 | 8159.98 | 204.00 | 2021-10-21 | 4 | 1912.15 | 1 | 8159.98 | 2 | SO44075 | 2021-10-28 | 652.80 | 7648.62 | 2039.99 | |||
SO51789_42 | A5AF-4504-83 | PO18618169495 | 100 | 286 | 467 | 605 | 1 | 2023-10-02 | 73.47 | 1.84 | 2023-09-20 | 5 | 9.16 | 1 | 73.47 | 42 | SO51789 | 2023-09-27 | 5.88 | 45.80 | 14.69 | |||
SO51127_15 | D321-4FEA-80 | PO2552155165 | 100 | 286 | 513 | 506 | 1 | 2023-09-01 | 218.45 | 5.46 | 2023-08-20 | 1 | 199.38 | 1 | 218.45 | 15 | SO51127 | 2023-08-27 | 17.48 | 199.38 | 218.45 | |||
SO48001_27 | 02F1-4434-99 | PO14442151969 | 100 | 293 | 419 | 127 | 1 | 2023-01-02 | 105.29 | 2.63 | 2022-12-21 | 2 | 38.96 | 1 | 105.29 | 27 | SO48001 | 2022-12-28 | 8.42 | 77.92 | 52.65 | |||
SO45283_2 | 07F7-44C2-BA | PO16646111452 | 100 | 286 | 319 | 1 | 1 | 2022-04-04 | 2624.38 | 65.61 | 2022-03-23 | 3 | 884.71 | 1 | 2624.38 | 2 | SO45283 | 2022-03-30 | 209.95 | 2654.12 | 874.79 | |||
SO53500_22 | BEF0-4525-AF | PO12470126979 | 100 | 287 | 500 | 672 | 1 | 2023-11-02 | 1204.69 | 30.12 | 2023-10-21 | 2 | 601.74 | 1 | 1204.69 | 22 | SO53500 | 2023-10-28 | 96.38 | 1203.49 | 602.35 | |||
SO67322_12 | 1881-4634-82 | PO6612121393 | 100 | 286 | 603 | 110 | 1 | 2024-06-02 | 218.68 | 5.47 | 2024-05-21 | 3 | 53.94 | 1 | 218.68 | 12 | SO67322 | 2024-05-28 | 17.49 | 161.82 | 72.89 | |||
SO48328_5 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 395 | 293 | 1 | 2023-02-01 | 306.87 | 7.67 | 2023-01-20 | 5 | 45.42 | 1 | 306.87 | 5 | SO48328 | 2023-01-27 | 24.55 | 227.08 | 61.37 | |||
SO69422_18 | BF3A-4F54-82 | PO14500139823 | 100 | 282 | 476 | 650 | 1 | 2024-07-02 | 125.98 | 3.15 | 2024-06-20 | 3 | 26.18 | 1 | 125.98 | 18 | SO69422 | 2024-06-27 | 10.08 | 78.53 | 41.99 | |||
SO53605_6 | 6D2A-486B-AC | PO5017132122 | 100 | 289 | 497 | 308 | 1 | 2023-11-02 | 602.35 | 15.06 | 2023-10-21 | 1 | 601.74 | 1 | 602.35 | 6 | SO53605 | 2023-10-28 | 48.19 | 601.74 | 602.35 | |||
SO51783_43 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 359 | 697 | 1 | 2023-10-02 | 12392.95 | 309.82 | 2023-09-20 | 9 | 1251.98 | 1 | 12392.95 | 43 | SO51783 | 2023-09-27 | 991.44 | 11267.83 | 1376.99 | |||
SO71893_7 | 9AE1-416A-8F | PO7482196160 | 100 | 293 | 503 | 163 | 1 | 2024-08-02 | 400.10 | 10.00 | 2024-07-21 | 2 | 199.85 | 1 | 400.10 | 7 | SO71893 | 2024-07-28 | 32.01 | 399.70 | 200.05 | |||
SO65175_13 | E1A8-440E-94 | PO17139119772 | 100 | 293 | 580 | 644 | 1 | 2024-05-02 | 2041.19 | 51.03 | 2024-04-20 | 2 | 1082.51 | 1 | 2041.19 | 13 | SO65175 | 2024-04-27 | 163.30 | 2165.02 | 1020.59 | |||
SO47698_31 | 3841-4995-8C | PO2552129685 | 100 | 286 | 233 | 506 | 1 | 2022-12-02 | 86.52 | 2.16 | 2022-11-20 | 3 | 29.08 | 1 | 86.52 | 31 | SO47698 | 2022-11-27 | 6.92 | 87.24 | 28.84 | |||
SO50678_8 | CAED-407A-BA | PO13543174640 | 100 | 287 | 427 | 293 | 1 | 2023-08-02 | 1046.28 | 26.16 | 2023-07-21 | 5 | 185.82 | 1 | 1046.28 | 8 | SO50678 | 2023-07-28 | 83.70 | 929.10 | 209.26 | |||
SO46643_1 | 49E8-4C7A-85 | PO899110603 | 100 | 289 | 343 | 290 | 1 | 2022-09-01 | 3758.35 | 93.96 | 2022-08-20 | 8 | 486.71 | 1 | 3758.35 | 1 | SO46643 | 2022-08-27 | 300.67 | 3893.65 | 469.79 | |||
SO45804_10 | A72B-452A-BA | PO2552178124 | 100 | 289 | 349 | 506 | 1 | 2022-06-02 | 8099.98 | 202.50 | 2022-05-21 | 4 | 1898.09 | 1 | 8099.98 | 10 | SO45804 | 2022-05-28 | 648.00 | 7592.38 | 2024.99 | |||
SO49849_17 | C8F3-4DDE-A6 | PO2552190786 | 100 | 286 | 224 | 506 | 1 | 2023-06-02 | 25.93 | 0.65 | 2023-05-21 | 5 | 5.23 | 1 | 25.93 | 17 | SO49849 | 2023-05-28 | 2.07 | 26.15 | 5.19 | |||
SO57160_12 | 86C3-4E21-9D | PO4727197868 | 100 | 293 | 546 | 343 | 1 | 2024-01-02 | 74.51 | 1.86 | 2023-12-21 | 2 | 27.57 | 1 | 74.51 | 12 | SO57160 | 2023-12-28 | 5.96 | 55.14 | 37.25 | |||
SO51783_31 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 596 | 697 | 1 | 2023-10-02 | 971.98 | 24.30 | 2023-09-20 | 3 | 294.58 | 1 | 971.98 | 31 | SO51783 | 2023-09-27 | 77.76 | 883.74 | 323.99 | |||
SO65200_31 | C4A9-49C4-AE | PO841148607 | 100 | 286 | 531 | 254 | 1 | 2024-05-02 | 599.50 | 14.99 | 2024-04-20 | 4 | 136.79 | 1 | 599.50 | 31 | SO65200 | 2024-04-27 | 47.96 | 547.14 | 149.87 |
Generated 2024-09-19 21:19:47.310 UTC