[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE SKIP 2000 < SKIP 657 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO59068_35 | B7CC-4A9D-86 | PO9715112509 | 100 | 281 | 488 | 490 | 4 | 2024-03-24 | 32.39 | 0.81 | 2024-03-12 | 1 | 41.57 | 1 | 32.39 | 35 | SO59068 | 2024-03-19 | 2.59 | 41.57 | 32.39 | |||
SO61212_3 | AF3E-4757-86 | PO13833118509 | 100 | 287 | 560 | 95 | 4 | 2024-04-24 | 728.91 | 18.22 | 2024-04-12 | 1 | 755.15 | 1 | 728.91 | 3 | SO61212 | 2024-04-19 | 58.31 | 755.15 | 728.91 | |||
SO61193_17 | DFEB-4C0D-88 | PO551160749 | 100 | 281 | 606 | 4 | 4 | 2024-04-24 | 971.98 | 24.30 | 2024-04-12 | 3 | 343.65 | 1 | 971.98 | 17 | SO61193 | 2024-04-19 | 77.76 | 1030.95 | 323.99 | |||
SO63263_1 | 1E1A-44EE-94 | PO4843118280 | 100 | 287 | 237 | 257 | 4 | 2024-05-25 | 29.99 | 0.75 | 2024-05-13 | 1 | 38.49 | 1 | 29.99 | 1 | SO63263 | 2024-05-20 | 2.40 | 38.49 | 29.99 | |||
SO50672_7 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 433 | 239 | 4 | 2023-09-23 | 324.45 | 8.11 | 2023-09-11 | 1 | 300.12 | 1 | 324.45 | 7 | SO50672 | 2023-09-18 | 25.96 | 300.12 | 324.45 | |||
SO50313_22 | B452-44E9-91 | PO7656143984 | 100 | 282 | 236 | 403 | 4 | 2023-08-23 | 144.20 | 3.61 | 2023-08-11 | 5 | 29.08 | 1 | 144.20 | 22 | SO50313 | 2023-08-18 | 11.54 | 145.40 | 28.84 | |||
SO53459_32 | 9828-4F27-B0 | PO19372154638 | 100 | 282 | 502 | 582 | 4 | 2023-12-24 | 400.10 | 10.00 | 2023-12-12 | 2 | 199.85 | 1 | 400.10 | 32 | SO53459 | 2023-12-19 | 32.01 | 399.70 | 200.05 | |||
SO53460_44 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 240 | 24 | 4 | 2023-12-24 | 4294.50 | 107.36 | 2023-12-12 | 5 | 868.63 | 1 | 4294.50 | 44 | SO53460 | 2023-12-19 | 343.56 | 4343.17 | 858.90 | |||
SO50672_16 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 343 | 2 | 239 | 4 | 99.91 | 2023-09-23 | 4995.48 | 122.39 | 2023-09-11 | 11 | 486.71 | 1 | 4895.57 | 16 | SO50672 | 2023-09-18 | 391.65 | 5353.77 | 454.13 | 0.02 |
SO49890_9 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 462 | 221 | 4 | 2023-07-24 | 28.26 | 0.71 | 2023-07-12 | 2 | 9.71 | 1 | 28.26 | 9 | SO49890 | 2023-07-19 | 2.26 | 19.43 | 14.13 | |||
SO69505_10 | FE34-45B3-8D | PO5684197579 | 100 | 282 | 532 | 385 | 4 | 2024-08-23 | 149.87 | 3.75 | 2024-08-11 | 1 | 136.79 | 1 | 149.87 | 10 | SO69505 | 2024-08-18 | 11.99 | 136.79 | 149.87 | |||
SO53621_50 | 9324-4A3D-83 | PO9715186811 | 100 | 281 | 474 | 4 | 490 | 4 | 87.49 | 2023-12-24 | 874.88 | 19.68 | 2023-12-12 | 25 | 26.18 | 1 | 787.39 | 50 | SO53621 | 2023-12-19 | 62.99 | 654.41 | 35.00 | 0.10 |
SO45534_1 | F5A4-4CEE-97 | PO14964111594 | 100 | 287 | 346 | 581 | 4 | 2022-06-23 | 6119.98 | 153.00 | 2022-06-11 | 3 | 1912.15 | 1 | 6119.98 | 1 | SO45534 | 2022-06-18 | 489.60 | 5736.46 | 2039.99 | |||
SO58909_10 | EBC4-496C-90 | PO19343180161 | 100 | 282 | 434 | 24 | 4 | 2024-03-24 | 713.80 | 17.84 | 2024-03-12 | 2 | 360.94 | 1 | 713.80 | 10 | SO58909 | 2024-03-19 | 57.10 | 721.89 | 356.90 | |||
SO61218_33 | 8441-4C6F-89 | PO13688193778 | 100 | 282 | 398 | 475 | 4 | 2024-04-24 | 53.45 | 1.34 | 2024-04-12 | 2 | 19.78 | 1 | 53.45 | 33 | SO61218 | 2024-04-19 | 4.28 | 39.55 | 26.72 | |||
SO46338_15 | 0BAC-4D7E-AD | PO15834128897 | 100 | 283 | 315 | 417 | 4 | 2022-09-23 | 2624.38 | 65.61 | 2022-09-11 | 3 | 884.71 | 1 | 2624.38 | 15 | SO46338 | 2022-09-18 | 209.95 | 2654.12 | 874.79 | |||
SO65168_18 | 7CDD-4B4A-AE | PO18038110078 | 100 | 287 | 569 | 509 | 4 | 2024-06-23 | 445.41 | 11.14 | 2024-06-11 | 1 | 461.44 | 1 | 445.41 | 18 | SO65168 | 2024-06-18 | 35.63 | 461.44 | 445.41 | |||
SO59023_37 | 9975-4F2A-A7 | PO5539149469 | 100 | 282 | 475 | 61 | 4 | 2024-03-24 | 125.98 | 3.15 | 2024-03-12 | 3 | 26.18 | 1 | 125.98 | 37 | SO59023 | 2024-03-19 | 10.08 | 78.53 | 41.99 | |||
SO44314_12 | 6FDF-4206-A7 | PO5626111923 | 100 | 283 | 316 | 166 | 4 | 2022-01-23 | 1749.59 | 43.74 | 2022-01-11 | 2 | 884.71 | 1 | 1749.59 | 12 | SO44314 | 2022-01-18 | 139.97 | 1769.42 | 874.79 | |||
SO47720_20 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 383 | 221 | 4 | 2023-01-23 | 1200.53 | 30.01 | 2023-01-11 | 2 | 605.65 | 1 | 1200.53 | 20 | SO47720 | 2023-01-18 | 96.04 | 1211.30 | 600.26 | |||
SO48341_46 | A747-471B-97 | PO10701176180 | 100 | 282 | 308 | 133 | 4 | 2023-03-25 | 2977.09 | 74.43 | 2023-03-13 | 4 | 660.91 | 1 | 2977.09 | 46 | SO48341 | 2023-03-20 | 238.17 | 2643.66 | 744.27 | |||
SO51153_32 | AC8D-4688-81 | PO5626119823 | 100 | 281 | 246 | 166 | 4 | 2023-10-23 | 1717.80 | 42.95 | 2023-10-11 | 2 | 868.63 | 1 | 1717.80 | 32 | SO51153 | 2023-10-18 | 137.42 | 1737.27 | 858.90 | |||
SO50743_8 | C1F5-4D36-9F | PO4640120853 | 100 | 287 | 411 | 648 | 4 | 2023-09-23 | 250.83 | 6.27 | 2023-09-11 | 2 | 92.81 | 1 | 250.83 | 8 | SO50743 | 2023-09-18 | 20.07 | 185.61 | 125.42 | |||
SO44093_9 | 8356-4625-B2 | PO15138128112 | 100 | 283 | 220 | 93 | 4 | 2021-12-24 | 20.19 | 0.50 | 2021-12-12 | 1 | 12.03 | 1 | 20.19 | 9 | SO44093 | 2021-12-19 | 1.61 | 12.03 | 20.19 | |||
SO50252_44 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 230 | 167 | 4 | 2023-08-23 | 144.20 | 3.61 | 2023-08-11 | 5 | 29.08 | 1 | 144.20 | 44 | SO50252 | 2023-08-18 | 11.54 | 145.40 | 28.84 | |||
SO47994_26 | 284B-45A1-94 | PO15196121630 | 100 | 282 | 422 | 258 | 4 | 2023-02-23 | 270.16 | 6.75 | 2023-02-11 | 4 | 49.98 | 1 | 270.16 | 26 | SO47994 | 2023-02-18 | 21.61 | 199.92 | 67.54 | |||
SO53546_11 | 57CF-465D-B2 | PO16269114010 | 100 | 287 | 604 | 624 | 4 | 2023-12-24 | 971.98 | 24.30 | 2023-12-12 | 3 | 343.65 | 1 | 971.98 | 11 | SO53546 | 2023-12-19 | 77.76 | 1030.95 | 323.99 | |||
SO49127_10 | 01A1-43AB-A2 | PO3480145572 | 100 | 272 | 216 | 436 | 4 | 2023-05-26 | 20.19 | 0.50 | 2023-05-14 | 1 | 13.88 | 1 | 20.19 | 10 | SO49127 | 2023-05-21 | 1.61 | 13.88 | 20.19 | |||
SO45554_6 | 24D3-4CD4-AB | PO2697134276 | 100 | 282 | 220 | 187 | 4 | 2022-06-23 | 40.37 | 1.01 | 2022-06-11 | 2 | 12.03 | 1 | 40.37 | 6 | SO45554 | 2022-06-18 | 3.23 | 24.06 | 20.19 | |||
SO45060_19 | 39B0-42BB-92 | PO10817172372 | 100 | 287 | 332 | 203 | 4 | 2022-04-25 | 1258.38 | 31.46 | 2022-04-13 | 3 | 413.15 | 1 | 1258.38 | 19 | SO45060 | 2022-04-20 | 100.67 | 1239.44 | 419.46 | |||
SO69528_5 | 2644-4747-86 | PO6438163496 | 100 | 272 | 532 | 309 | 4 | 2024-08-23 | 299.75 | 7.49 | 2024-08-11 | 2 | 136.79 | 1 | 299.75 | 5 | SO69528 | 2024-08-18 | 23.98 | 273.57 | 149.87 |
Generated 2024-11-10 09:51:40.335 UTC