[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 265 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45810_7 | 2A16-4AA7-89 | PO5626186069 | 100 | 283 | 262 | 166 | 4 | 2022-07-24 | 735.75 | 18.39 | 2022-07-12 | 4 | 181.49 | 1 | 735.75 | 7 | SO45810 | 2022-07-19 | 58.86 | 725.94 | 183.94 | |||
SO46341_9 | 7717-4086-86 | PO15138183971 | 100 | 283 | 314 | 93 | 4 | 2022-09-23 | 4293.92 | 107.35 | 2022-09-11 | 2 | 2171.29 | 1 | 4293.92 | 9 | SO46341 | 2022-09-18 | 343.51 | 4342.59 | 2146.96 | |||
SO45554_12 | 24D3-4CD4-AB | PO2697134276 | 100 | 282 | 344 | 187 | 4 | 2022-06-23 | 4079.99 | 102.00 | 2022-06-11 | 2 | 1912.15 | 1 | 4079.99 | 12 | SO45554 | 2022-06-18 | 326.40 | 3824.31 | 2039.99 | |||
SO59027_38 | C142-4AAA-AB | PO6757122081 | 100 | 281 | 501 | 21 | 4 | 2024-03-24 | 72.88 | 1.82 | 2024-03-12 | 1 | 53.93 | 1 | 72.88 | 38 | SO59027 | 2024-03-19 | 5.83 | 53.93 | 72.88 | |||
SO49490_23 | 0396-4322-83 | PO19343175441 | 100 | 282 | 236 | 24 | 4 | 2023-06-23 | 115.36 | 2.88 | 2023-06-11 | 4 | 29.08 | 1 | 115.36 | 23 | SO49490 | 2023-06-18 | 9.23 | 116.32 | 28.84 | |||
SO69441_9 | F156-4EE0-B0 | PO11745165450 | 100 | 282 | 386 | 97 | 4 | 2024-08-23 | 2016.88 | 50.42 | 2024-08-11 | 3 | 713.08 | 1 | 2016.88 | 9 | SO69441 | 2024-08-18 | 161.35 | 2139.24 | 672.29 | |||
SO43904_3 | BB8E-4008-B7 | PO6351158788 | 100 | 283 | 275 | 255 | 4 | 2021-11-23 | 356.90 | 8.92 | 2021-11-11 | 1 | 352.14 | 1 | 356.90 | 3 | SO43904 | 2021-11-18 | 28.55 | 352.14 | 356.90 | |||
SO61243_7 | 0370-4B1B-9D | PO7859152962 | 100 | 287 | 222 | 221 | 4 | 2024-04-24 | 83.98 | 2.10 | 2024-04-12 | 4 | 13.09 | 1 | 83.98 | 7 | SO61243 | 2024-04-19 | 6.72 | 52.35 | 20.99 | |||
SO49160_16 | 60E2-486C-AE | PO7656113690 | 100 | 282 | 368 | 403 | 4 | 2023-05-26 | 1466.01 | 36.65 | 2023-05-14 | 1 | 1518.79 | 1 | 1466.01 | 16 | SO49160 | 2023-05-21 | 117.28 | 1518.79 | 1466.01 | |||
SO51842_18 | 2A39-4E97-9A | PO4843199898 | 100 | 287 | 378 | 257 | 4 | 2023-11-23 | 2932.02 | 73.30 | 2023-11-11 | 2 | 1554.95 | 1 | 2932.02 | 18 | SO51842 | 2023-11-18 | 234.56 | 3109.90 | 1466.01 | |||
SO46624_15 | 12A0-4CA7-93 | PO13659199342 | 100 | 287 | 397 | 437 | 4 | 2022-10-23 | 24.29 | 0.61 | 2022-10-11 | 1 | 17.98 | 1 | 24.29 | 15 | SO46624 | 2022-10-18 | 1.94 | 17.98 | 24.29 | |||
SO48012_5 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 343 | 78 | 4 | 2023-02-23 | 1409.38 | 35.23 | 2023-02-11 | 3 | 486.71 | 1 | 1409.38 | 5 | SO48012 | 2023-02-18 | 112.75 | 1460.12 | 469.79 | |||
SO47423_3 | 091B-4715-B2 | PO3886127119 | 100 | 283 | 325 | 165 | 4 | 2022-12-24 | 939.59 | 23.49 | 2022-12-12 | 2 | 486.71 | 1 | 939.59 | 3 | SO47423 | 2022-12-19 | 75.17 | 973.41 | 469.79 | |||
SO47427_15 | 61AA-44CA-99 | PO4640137176 | 100 | 287 | 401 | 648 | 4 | 2022-12-24 | 196.81 | 4.92 | 2022-12-12 | 3 | 48.55 | 1 | 196.81 | 15 | SO47427 | 2022-12-19 | 15.74 | 145.64 | 65.60 | |||
SO48048_48 | B414-46CB-BA | PO3480117933 | 100 | 283 | 343 | 436 | 4 | 2023-02-23 | 939.59 | 23.49 | 2023-02-11 | 2 | 486.71 | 1 | 939.59 | 48 | SO48048 | 2023-02-18 | 75.17 | 973.41 | 469.79 | |||
SO55264_34 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 214 | 2 | 491 | 4 | 4.87 | 2024-01-23 | 243.53 | 5.97 | 2024-01-11 | 12 | 13.09 | 1 | 238.66 | 34 | SO55264 | 2024-01-18 | 19.09 | 157.04 | 20.29 | 0.02 |
SO48295_47 | 12F9-466B-B0 | PO19343197973 | 100 | 282 | 343 | 3 | 24 | 4 | 366.05 | 2023-03-25 | 7320.96 | 173.87 | 2023-03-13 | 17 | 486.71 | 1 | 6954.91 | 47 | SO48295 | 2023-03-20 | 556.39 | 8274.01 | 430.64 | 0.05 |
SO69514_2 | 587C-4C47-B9 | PO4553146799 | 100 | 282 | 580 | 313 | 4 | 2024-08-23 | 2041.19 | 51.03 | 2024-08-11 | 2 | 1082.51 | 1 | 2041.19 | 2 | SO69514 | 2024-08-18 | 163.30 | 2165.02 | 1020.59 | |||
SO51122_28 | D915-4225-97 | PO551181465 | 100 | 281 | 408 | 4 | 4 | 2023-10-23 | 144.32 | 3.61 | 2023-10-11 | 2 | 53.40 | 1 | 144.32 | 28 | SO51122 | 2023-10-18 | 11.55 | 106.80 | 72.16 | |||
SO51842_7 | 2A39-4E97-9A | PO4843199898 | 100 | 287 | 583 | 257 | 4 | 2023-11-23 | 4082.38 | 102.06 | 2023-11-11 | 4 | 1082.51 | 1 | 4082.38 | 7 | SO51842 | 2023-11-18 | 326.59 | 4330.04 | 1020.59 | |||
SO49445_3 | 943B-43E1-AE | PO174113233 | 100 | 282 | 323 | 277 | 4 | 2023-06-23 | 939.59 | 23.49 | 2023-06-11 | 2 | 486.71 | 1 | 939.59 | 3 | SO49445 | 2023-06-18 | 75.17 | 973.41 | 469.79 | |||
SO46638_1 | 9659-44CE-A2 | PO10817110834 | 100 | 287 | 333 | 203 | 4 | 2022-10-23 | 939.59 | 23.49 | 2022-10-11 | 2 | 486.71 | 1 | 939.59 | 1 | SO46638 | 2022-10-18 | 75.17 | 973.41 | 469.79 | |||
SO50252_10 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 213 | 167 | 4 | 2023-08-23 | 60.56 | 1.51 | 2023-08-11 | 3 | 13.88 | 1 | 60.56 | 10 | SO50252 | 2023-08-18 | 4.84 | 41.63 | 20.19 | |||
SO44557_2 | 2D19-4C49-B1 | PO6351122593 | 100 | 283 | 336 | 255 | 4 | 2022-02-23 | 838.92 | 20.97 | 2022-02-11 | 2 | 413.15 | 1 | 838.92 | 2 | SO44557 | 2022-02-18 | 67.11 | 826.29 | 419.46 | |||
SO44120_11 | E001-437D-A1 | PO5597155510 | 100 | 283 | 296 | 75 | 4 | 2021-12-24 | 714.70 | 17.87 | 2021-12-12 | 1 | 617.03 | 1 | 714.70 | 11 | SO44120 | 2021-12-19 | 57.18 | 617.03 | 714.70 | |||
SO49490_28 | 0396-4322-83 | PO19343175441 | 100 | 282 | 286 | 24 | 4 | 2023-06-23 | 183.94 | 4.60 | 2023-06-11 | 1 | 170.14 | 1 | 183.94 | 28 | SO49490 | 2023-06-18 | 14.72 | 170.14 | 183.94 | |||
SO65299_1 | 2FED-4E5A-B6 | PO3770146082 | 100 | 282 | 353 | 151 | 4 | 2024-06-23 | 1391.99 | 34.80 | 2024-06-11 | 1 | 1265.62 | 1 | 1391.99 | 1 | SO65299 | 2024-06-18 | 111.36 | 1265.62 | 1391.99 | |||
SO59013_20 | C224-4535-BA | PO5597199820 | 100 | 281 | 363 | 75 | 4 | 2024-03-24 | 2753.99 | 68.85 | 2024-03-12 | 2 | 1251.98 | 1 | 2753.99 | 20 | SO59013 | 2024-03-19 | 220.32 | 2503.96 | 1376.99 |
Generated 2024-11-10 14:14:51.541 UTC