[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 473 > < TAKE 28 >
28 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45076_3 | 4F79-4FD4-98 | PO9657156121 | 100 | 285 | 232 | 315 | 5 | 2022-03-06 | 28.84 | 0.72 | 2022-02-22 | 1 | 31.72 | 1 | 28.84 | 3 | SO45076 | 2022-03-01 | 2.31 | 31.72 | 28.84 |
SO53568_2 | 4523-4AB4-99 | PO9222138547 | 100 | 285 | 231 | 171 | 5 | 2023-11-04 | 29.99 | 0.75 | 2023-10-23 | 1 | 38.49 | 1 | 29.99 | 2 | SO53568 | 2023-10-30 | 2.40 | 38.49 | 29.99 |
SO47042_38 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 213 | 566 | 5 | 2022-10-04 | 161.49 | 4.04 | 2022-09-22 | 8 | 13.88 | 1 | 161.49 | 38 | SO47042 | 2022-09-29 | 12.92 | 111.03 | 20.19 |
SO46387_4 | 5AA4-4F68-A1 | PO9599173396 | 100 | 285 | 338 | 170 | 5 | 2022-08-04 | 1677.84 | 41.95 | 2022-07-23 | 4 | 413.15 | 1 | 1677.84 | 4 | SO46387 | 2022-07-30 | 134.23 | 1652.59 | 419.46 |
SO58974_20 | FB64-4792-81 | PO2813115918 | 100 | 283 | 482 | 90 | 5 | 2024-02-03 | 16.18 | 0.40 | 2024-01-22 | 3 | 3.36 | 1 | 16.18 | 20 | SO58974 | 2024-01-29 | 1.29 | 10.09 | 5.39 |
SO44552_5 | 79A1-4836-9F | PO5858149301 | 100 | 285 | 351 | 566 | 5 | 2022-01-04 | 4049.99 | 101.25 | 2021-12-23 | 2 | 1898.09 | 1 | 4049.99 | 5 | SO44552 | 2021-12-30 | 324.00 | 3796.19 | 2024.99 |
SO51824_18 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 298 | 63 | 5 | 2023-10-04 | 809.76 | 20.24 | 2023-09-22 | 1 | 739.04 | 1 | 809.76 | 18 | SO51824 | 2023-09-29 | 64.78 | 739.04 | 809.76 |
SO45543_1 | 213B-4D78-95 | PO11977169841 | 100 | 285 | 272 | 675 | 5 | 2022-05-04 | 367.88 | 9.20 | 2022-04-22 | 2 | 181.49 | 1 | 367.88 | 1 | SO45543 | 2022-04-29 | 29.43 | 362.97 | 183.94 |
SO51760_6 | 2C2D-41C9-8C | PO9918180623 | 100 | 285 | 579 | 260 | 5 | 2023-10-04 | 2186.73 | 54.67 | 2023-09-22 | 3 | 755.15 | 1 | 2186.73 | 6 | SO51760 | 2023-09-29 | 174.94 | 2265.45 | 728.91 |
SO67281_1 | 2C37-4CD5-AE | PO12615134054 | 100 | 285 | 517 | 440 | 5 | 2024-06-04 | 31.58 | 0.79 | 2024-05-23 | 1 | 23.37 | 1 | 31.58 | 1 | SO67281 | 2024-05-30 | 2.53 | 23.37 | 31.58 |
SO53563_36 | C955-44BD-A8 | PO9599165865 | 100 | 285 | 583 | 170 | 5 | 2023-11-04 | 8164.75 | 204.12 | 2023-10-23 | 8 | 1082.51 | 1 | 8164.75 | 36 | SO53563 | 2023-10-30 | 653.18 | 8660.08 | 1020.59 |
SO43685_1 | C519-4AB3-88 | PO4176124783 | 100 | 285 | 332 | 458 | 5 | 2021-09-03 | 1258.38 | 31.46 | 2021-08-22 | 3 | 413.15 | 1 | 1258.38 | 1 | SO43685 | 2021-08-29 | 100.67 | 1239.44 | 419.46 |
SO46099_4 | 7E3B-4362-99 | PO7598165395 | 100 | 285 | 342 | 45 | 5 | 2022-07-04 | 2097.29 | 52.43 | 2022-06-22 | 5 | 413.15 | 1 | 2097.29 | 4 | SO46099 | 2022-06-29 | 167.78 | 2065.73 | 419.46 |
SO46056_10 | 4B9A-4022-AA | PO12586180466 | 100 | 285 | 235 | 278 | 5 | 2022-07-04 | 28.84 | 0.72 | 2022-06-22 | 1 | 31.72 | 1 | 28.84 | 10 | SO46056 | 2022-06-29 | 2.31 | 31.72 | 28.84 |
SO47726_20 | 7256-4599-93 | PO9657190563 | 100 | 285 | 354 | 315 | 5 | 2022-12-04 | 6214.26 | 155.36 | 2022-11-22 | 5 | 1117.86 | 1 | 6214.26 | 20 | SO47726 | 2022-11-29 | 497.14 | 5589.28 | 1242.85 |
SO51824_20 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 474 | 63 | 5 | 2023-10-04 | 251.96 | 6.30 | 2023-09-22 | 6 | 26.18 | 1 | 251.96 | 20 | SO51824 | 2023-09-29 | 20.16 | 157.06 | 41.99 |
SO49159_1 | 15B4-4CCD-9A | PO7598122487 | 100 | 285 | 454 | 45 | 5 | 2023-04-06 | 71.99 | 1.80 | 2023-03-25 | 2 | 24.75 | 1 | 71.99 | 1 | SO49159 | 2023-04-01 | 5.76 | 49.49 | 35.99 |
SO50191_11 | 1DDA-4B5A-95 | PO19546193423 | 100 | 285 | 286 | 206 | 5 | 2023-07-04 | 551.81 | 13.80 | 2023-06-22 | 3 | 170.14 | 1 | 551.81 | 11 | SO50191 | 2023-06-29 | 44.15 | 510.43 | 183.94 |
SO49869_4 | A2BD-4A89-93 | PO9657193666 | 100 | 285 | 464 | 315 | 5 | 2023-06-04 | 28.26 | 0.71 | 2023-05-23 | 2 | 9.71 | 1 | 28.26 | 4 | SO49869 | 2023-05-30 | 2.26 | 19.43 | 14.13 |
SO48794_1 | 1382-407C-90 | PO9947140408 | 100 | 285 | 329 | 603 | 5 | 2023-03-06 | 469.79 | 11.74 | 2023-02-22 | 1 | 486.71 | 1 | 469.79 | 1 | SO48794 | 2023-03-01 | 37.58 | 486.71 | 469.79 |
SO51718_9 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 477 | 207 | 5 | 2023-10-04 | 8.98 | 0.22 | 2023-09-22 | 3 | 1.87 | 1 | 8.98 | 9 | SO51718 | 2023-09-29 | 0.72 | 5.60 | 2.99 |
SO57118_20 | 69CB-481B-8D | PO5800191707 | 100 | 285 | 531 | 63 | 5 | 2024-01-04 | 749.37 | 18.73 | 2023-12-23 | 5 | 136.79 | 1 | 749.37 | 20 | SO57118 | 2023-12-30 | 59.95 | 683.93 | 149.87 |
SO51824_40 | A1F7-477E-BA | PO5800114202 | 100 | 285 | 475 | 63 | 5 | 2023-10-04 | 41.99 | 1.05 | 2023-09-22 | 1 | 26.18 | 1 | 41.99 | 40 | SO51824 | 2023-09-29 | 3.36 | 26.18 | 41.99 |
SO46387_1 | 5AA4-4F68-A1 | PO9599173396 | 100 | 285 | 311 | 170 | 5 | 2022-08-04 | 2146.96 | 53.67 | 2022-07-23 | 1 | 2171.29 | 1 | 2146.96 | 1 | SO46387 | 2022-07-30 | 171.76 | 2171.29 | 2146.96 |
SO49822_33 | 191D-4AD7-93 | PO522119337 | 100 | 285 | 447 | 676 | 5 | 2023-06-04 | 90.00 | 2.25 | 2023-05-23 | 6 | 10.31 | 1 | 90.00 | 33 | SO49822 | 2023-05-30 | 7.20 | 61.88 | 15.00 |
SO47454_20 | E249-41EE-95 | PO9570119946 | 100 | 285 | 420 | 585 | 5 | 2022-11-04 | 283.23 | 7.08 | 2022-10-23 | 2 | 104.80 | 1 | 283.23 | 20 | SO47454 | 2022-10-30 | 22.66 | 209.59 | 141.62 |
SO71948_1 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 606 | 170 | 5 | 2024-08-04 | 971.98 | 24.30 | 2024-07-23 | 3 | 343.65 | 1 | 971.98 | 1 | SO71948 | 2024-07-30 | 77.76 | 1030.95 | 323.99 |
SO46630_33 | F512-40F2-91 | PO12644161356 | 100 | 285 | 412 | 530 | 5 | 2022-09-03 | 540.39 | 13.51 | 2022-08-22 | 3 | 133.30 | 1 | 540.39 | 33 | SO46630 | 2022-08-29 | 43.23 | 399.89 | 180.13 |
Generated 2024-09-21 03:15:42.792 UTC