[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE SKIP 2298 < SKIP 1000 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51722_15 | 735D-4C32-A1 | PO15196144426 | 100 | 282 | 372 | 258 | 4 | 2023-10-04 | 1466.01 | 36.65 | 2023-09-22 | 1 | 1554.95 | 1 | 1466.01 | 15 | SO51722 | 2023-09-29 | 117.28 | 1554.95 | 1466.01 | |||
SO59013_22 | C224-4535-BA | PO5597199820 | 100 | 281 | 501 | 75 | 4 | 2024-02-03 | 145.75 | 3.64 | 2024-01-22 | 2 | 53.93 | 1 | 145.75 | 22 | SO59013 | 2024-01-29 | 11.66 | 107.86 | 72.88 | |||
SO53460_1 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 255 | 24 | 4 | 2023-11-04 | 809.33 | 20.23 | 2023-10-23 | 4 | 204.63 | 1 | 809.33 | 1 | SO53460 | 2023-10-30 | 64.75 | 818.50 | 202.33 | |||
SO53539_8 | 2B21-4FAC-8C | PO18763121730 | 100 | 287 | 561 | 14 | 59 | 4 | 381.45 | 2023-11-04 | 1907.26 | 38.15 | 2023-10-23 | 2 | 1481.94 | 1 | 1525.80 | 8 | SO53539 | 2023-10-30 | 122.06 | 2963.88 | 953.63 | 0.20 |
SO51833_5 | 67A5-4BBC-8F | PO5684113634 | 100 | 282 | 511 | 385 | 4 | 2023-10-04 | 436.91 | 10.92 | 2023-09-22 | 2 | 199.38 | 1 | 436.91 | 5 | SO51833 | 2023-09-29 | 34.95 | 398.75 | 218.45 | |||
SO48080_25 | 4DC7-4772-87 | PO7656157590 | 100 | 282 | 460 | 403 | 4 | 2023-01-04 | 215.98 | 5.40 | 2022-12-23 | 4 | 37.12 | 1 | 215.98 | 25 | SO48080 | 2022-12-30 | 17.28 | 148.48 | 53.99 | |||
SO51090_43 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 306 | 475 | 4 | 2023-09-03 | 2429.28 | 60.73 | 2023-08-22 | 3 | 739.04 | 1 | 2429.28 | 43 | SO51090 | 2023-08-29 | 194.34 | 2217.12 | 809.76 | |||
SO50252_6 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 335 | 167 | 4 | 2023-07-04 | 2348.97 | 58.72 | 2023-06-22 | 5 | 486.71 | 1 | 2348.97 | 6 | SO50252 | 2023-06-29 | 187.92 | 2433.53 | 469.79 | |||
SO69546_10 | A1BC-4567-82 | PO3219164489 | 100 | 282 | 436 | 493 | 4 | 2024-07-04 | 356.90 | 8.92 | 2024-06-22 | 1 | 360.94 | 1 | 356.90 | 10 | SO69546 | 2024-06-29 | 28.55 | 360.94 | 356.90 | |||
SO46638_17 | 9659-44CE-A2 | PO10817110834 | 100 | 287 | 335 | 203 | 4 | 2022-09-03 | 469.79 | 11.74 | 2022-08-22 | 1 | 486.71 | 1 | 469.79 | 17 | SO46638 | 2022-08-29 | 37.58 | 486.71 | 469.79 | |||
SO71848_9 | 7082-4BF5-AB | PO18763153352 | 100 | 287 | 579 | 59 | 4 | 2024-08-04 | 728.91 | 18.22 | 2024-07-23 | 1 | 755.15 | 1 | 728.91 | 9 | SO71848 | 2024-07-30 | 58.31 | 755.15 | 728.91 | |||
SO47712_29 | 299D-4C8A-BF | PO5626117491 | 100 | 283 | 323 | 2 | 166 | 4 | 99.91 | 2022-12-04 | 4995.48 | 122.39 | 2022-11-22 | 11 | 486.71 | 1 | 4895.57 | 29 | SO47712 | 2022-11-29 | 391.65 | 5353.77 | 454.13 | 0.02 |
SO44521_9 | E46D-4692-AC | PO12557171689 | 100 | 282 | 264 | 240 | 4 | 2022-01-04 | 735.75 | 18.39 | 2021-12-23 | 4 | 181.49 | 1 | 735.75 | 9 | SO44521 | 2021-12-30 | 58.86 | 725.94 | 183.94 | |||
SO61218_9 | 8441-4C6F-89 | PO13688193778 | 100 | 282 | 475 | 475 | 4 | 2024-03-05 | 83.99 | 2.10 | 2024-02-22 | 2 | 26.18 | 1 | 83.99 | 9 | SO61218 | 2024-02-29 | 6.72 | 52.35 | 41.99 | |||
SO51722_2 | 735D-4C32-A1 | PO15196144426 | 100 | 282 | 605 | 258 | 4 | 2023-10-04 | 323.99 | 8.10 | 2023-09-22 | 1 | 343.65 | 1 | 323.99 | 2 | SO51722 | 2023-09-29 | 25.92 | 343.65 | 323.99 | |||
SO71783_38 | 7E03-4B8A-BA | PO19343113609 | 100 | 282 | 472 | 24 | 4 | 2024-08-04 | 381.00 | 9.53 | 2024-07-23 | 10 | 23.75 | 1 | 381.00 | 38 | SO71783 | 2024-07-30 | 30.48 | 237.49 | 38.10 | |||
SO47700_4 | 5C46-42DE-AD | PO2494132198 | 100 | 283 | 396 | 184 | 4 | 2022-12-04 | 149.68 | 3.74 | 2022-11-22 | 2 | 55.38 | 1 | 149.68 | 4 | SO47700 | 2022-11-29 | 11.97 | 110.76 | 74.84 | |||
SO65161_4 | BCDF-4C1D-AB | PO18763178124 | 100 | 287 | 579 | 59 | 4 | 2024-05-04 | 728.91 | 18.22 | 2024-04-22 | 1 | 755.15 | 1 | 728.91 | 4 | SO65161 | 2024-04-29 | 58.31 | 755.15 | 728.91 | |||
SO53533_20 | B8B0-46C0-AF | PO18038134377 | 100 | 287 | 496 | 509 | 4 | 2023-11-04 | 602.35 | 15.06 | 2023-10-23 | 1 | 601.74 | 1 | 602.35 | 20 | SO53533 | 2023-10-30 | 48.19 | 601.74 | 602.35 | |||
SO46992_37 | C958-4FD6-A0 | PO11745117547 | 100 | 282 | 325 | 97 | 4 | 2022-10-04 | 469.79 | 11.74 | 2022-09-22 | 1 | 486.71 | 1 | 469.79 | 37 | SO46992 | 2022-09-29 | 37.58 | 486.71 | 469.79 | |||
SO53606_51 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 400 | 61 | 4 | 2023-11-04 | 37.15 | 0.93 | 2023-10-23 | 1 | 27.49 | 1 | 37.15 | 51 | SO53606 | 2023-10-30 | 2.97 | 27.49 | 37.15 | |||
SO69505_6 | FE34-45B3-8D | PO5684197579 | 100 | 282 | 511 | 385 | 4 | 2024-07-04 | 218.45 | 5.46 | 2024-06-22 | 1 | 199.38 | 1 | 218.45 | 6 | SO69505 | 2024-06-29 | 17.48 | 199.38 | 218.45 | |||
SO53496_9 | 5404-4BB1-95 | PO12992153220 | 100 | 282 | 488 | 295 | 4 | 2023-11-04 | 32.39 | 0.81 | 2023-10-23 | 1 | 41.57 | 1 | 32.39 | 9 | SO53496 | 2023-10-30 | 2.59 | 41.57 | 32.39 | |||
SO69509_2 | 3683-45BF-B7 | PO4611111760 | 100 | 287 | 496 | 131 | 4 | 2024-07-04 | 1807.04 | 45.18 | 2024-06-22 | 3 | 601.74 | 1 | 1807.04 | 2 | SO69509 | 2024-06-29 | 144.56 | 1805.23 | 602.35 | |||
SO48780_10 | F139-41F4-83 | PO5626121558 | 100 | 281 | 327 | 3 | 166 | 4 | 344.52 | 2023-03-06 | 6890.31 | 163.64 | 2023-02-22 | 16 | 486.71 | 1 | 6545.80 | 10 | SO48780 | 2023-03-01 | 523.66 | 7787.31 | 430.64 | 0.05 |
SO48378_10 | 2FD7-4721-9D | PO6786131738 | 100 | 283 | 265 | 3 | 4 | 2023-02-03 | 202.33 | 5.06 | 2023-01-22 | 1 | 187.16 | 1 | 202.33 | 10 | SO48378 | 2023-01-29 | 16.19 | 187.16 | 202.33 | |||
SO53470_1 | 932B-41E0-AF | PO17052111209 | 100 | 282 | 577 | 420 | 4 | 2023-11-04 | 1457.82 | 36.45 | 2023-10-23 | 2 | 755.15 | 1 | 1457.82 | 1 | SO53470 | 2023-10-30 | 116.63 | 1510.30 | 728.91 | |||
SO48052_1 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 308 | 435 | 4 | 2023-01-04 | 744.27 | 18.61 | 2022-12-23 | 1 | 660.91 | 1 | 744.27 | 1 | SO48052 | 2022-12-30 | 59.54 | 660.91 | 744.27 | |||
SO51126_23 | 7A9E-43B4-B3 | PO2755153471 | 100 | 282 | 565 | 13 | 205 | 4 | 150.33 | 2023-09-03 | 1002.17 | 21.30 | 2023-08-22 | 3 | 461.44 | 1 | 851.85 | 23 | SO51126 | 2023-08-29 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO48375_4 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 356 | 75 | 4 | 2023-02-03 | 1242.85 | 31.07 | 2023-01-22 | 1 | 1117.86 | 1 | 1242.85 | 4 | SO48375 | 2023-01-29 | 99.43 | 1117.86 | 1242.85 | |||
SO71783_14 | 7E03-4B8A-BA | PO19343113609 | 100 | 282 | 418 | 24 | 4 | 2024-08-04 | 356.90 | 8.92 | 2024-07-23 | 1 | 360.94 | 1 | 356.90 | 14 | SO71783 | 2024-07-30 | 28.55 | 360.94 | 356.90 |
Generated 2024-09-21 08:35:13.306 UTC