[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE SKIP 2000 < SKIP 500 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO65239_1 | 05CB-4E4A-AC | PO13717153710 | 100 | 287 | 483 | 473 | 4 | 2024-06-23 | 72.00 | 1.80 | 2024-06-11 | 1 | 44.88 | 1 | 72.00 | 1 | SO65239 | 2024-06-18 | 5.76 | 44.88 | 72.00 |
SO63262_19 | 3368-4317-8F | PO6351144702 | 100 | 281 | 382 | 255 | 4 | 2024-05-25 | 672.29 | 16.81 | 2024-05-13 | 1 | 713.08 | 1 | 672.29 | 19 | SO63262 | 2024-05-20 | 53.78 | 713.08 | 672.29 |
SO47045_11 | 9DDC-4176-90 | PO6438144434 | 100 | 283 | 419 | 309 | 4 | 2022-11-23 | 105.29 | 2.63 | 2022-11-11 | 2 | 38.96 | 1 | 105.29 | 11 | SO47045 | 2022-11-18 | 8.42 | 77.92 | 52.65 |
SO71902_30 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 471 | 61 | 4 | 2024-09-23 | 228.60 | 5.72 | 2024-09-11 | 6 | 23.75 | 1 | 228.60 | 30 | SO71902 | 2024-09-18 | 18.29 | 142.49 | 38.10 |
SO53552_5 | C686-48BD-B0 | PO16182115085 | 100 | 287 | 359 | 23 | 4 | 2023-12-24 | 4130.98 | 103.27 | 2023-12-12 | 3 | 1251.98 | 1 | 4130.98 | 5 | SO53552 | 2023-12-19 | 330.48 | 3755.94 | 1376.99 |
SO47024_1 | F254-4053-A3 | PO3654136382 | 100 | 283 | 366 | 435 | 4 | 2022-11-23 | 2591.98 | 64.80 | 2022-11-11 | 4 | 598.44 | 1 | 2591.98 | 1 | SO47024 | 2022-11-18 | 207.36 | 2393.74 | 647.99 |
SO46642_22 | 0A4E-465C-BB | PO551133122 | 100 | 283 | 368 | 4 | 4 | 2022-10-23 | 7330.05 | 183.25 | 2022-10-11 | 5 | 1518.79 | 1 | 7330.05 | 22 | SO46642 | 2022-10-18 | 586.40 | 7593.93 | 1466.01 |
SO45301_4 | 0BA8-4928-A7 | PO12499190711 | 100 | 282 | 324 | 78 | 4 | 2022-05-26 | 3355.67 | 83.89 | 2022-05-14 | 8 | 413.15 | 1 | 3355.67 | 4 | SO45301 | 2022-05-21 | 268.45 | 3305.17 | 419.46 |
SO53538_5 | D7FE-4E54-BD | PO18125134677 | 100 | 287 | 430 | 311 | 4 | 2023-12-24 | 356.90 | 8.92 | 2023-12-12 | 1 | 360.94 | 1 | 356.90 | 5 | SO53538 | 2023-12-19 | 28.55 | 360.94 | 356.90 |
SO46992_9 | C958-4FD6-A0 | PO11745117547 | 100 | 282 | 271 | 97 | 4 | 2022-11-23 | 202.33 | 5.06 | 2022-11-11 | 1 | 187.16 | 1 | 202.33 | 9 | SO46992 | 2022-11-18 | 16.19 | 187.16 | 202.33 |
SO63212_1 | B54D-4C63-85 | PO5684113881 | 100 | 282 | 484 | 385 | 4 | 2024-05-25 | 23.85 | 0.60 | 2024-05-13 | 5 | 2.97 | 1 | 23.85 | 1 | SO63212 | 2024-05-20 | 1.91 | 14.87 | 4.77 |
SO49831_7 | 8BCC-466B-AB | PO13688123267 | 100 | 282 | 289 | 475 | 4 | 2023-07-24 | 2977.09 | 74.43 | 2023-07-12 | 4 | 660.91 | 1 | 2977.09 | 7 | SO49831 | 2023-07-19 | 238.17 | 2643.66 | 744.27 |
SO50226_42 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 325 | 78 | 4 | 2023-08-23 | 469.79 | 11.74 | 2023-08-11 | 1 | 486.71 | 1 | 469.79 | 42 | SO50226 | 2023-08-18 | 37.58 | 486.71 | 469.79 |
SO49841_1 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 331 | 203 | 4 | 2023-07-24 | 939.59 | 23.49 | 2023-07-12 | 2 | 486.71 | 1 | 939.59 | 1 | SO49841 | 2023-07-19 | 75.17 | 973.41 | 469.79 |
SO49152_24 | 52FC-4E8F-B0 | PO6525119586 | 100 | 272 | 305 | 345 | 4 | 2023-05-26 | 1472.29 | 36.81 | 2023-05-14 | 2 | 653.70 | 1 | 1472.29 | 24 | SO49152 | 2023-05-21 | 117.78 | 1307.39 | 736.15 |
SO44755_1 | 3B0A-428C-99 | PO15167120207 | 100 | 283 | 322 | 273 | 4 | 2022-03-25 | 419.46 | 10.49 | 2022-03-13 | 1 | 413.15 | 1 | 419.46 | 1 | SO44755 | 2022-03-20 | 33.56 | 413.15 | 419.46 |
SO45799_15 | 4DE8-4B9B-A1 | PO10730195041 | 100 | 287 | 212 | 491 | 4 | 2022-07-24 | 20.19 | 0.50 | 2022-07-12 | 1 | 12.03 | 1 | 20.19 | 15 | SO45799 | 2022-07-19 | 1.61 | 12.03 | 20.19 |
SO51090_4 | EBDE-4A71-8E | PO13688110947 | 100 | 282 | 484 | 475 | 4 | 2023-10-23 | 28.62 | 0.72 | 2023-10-11 | 6 | 2.97 | 1 | 28.62 | 4 | SO51090 | 2023-10-18 | 2.29 | 17.84 | 4.77 |
SO47369_6 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 375 | 239 | 4 | 2022-12-24 | 5235.75 | 130.89 | 2022-12-12 | 4 | 1320.68 | 1 | 5235.75 | 6 | SO47369 | 2022-12-19 | 418.86 | 5282.74 | 1308.94 |
SO50663_10 | 286E-4915-89 | PO19343130555 | 100 | 282 | 433 | 24 | 4 | 2023-09-23 | 648.91 | 16.22 | 2023-09-11 | 2 | 300.12 | 1 | 648.91 | 10 | SO50663 | 2023-09-18 | 51.91 | 600.24 | 324.45 |
SO47990_12 | 7D80-4D9E-9A | PO15689162700 | 100 | 283 | 371 | 328 | 4 | 2023-02-23 | 5235.75 | 130.89 | 2023-02-11 | 4 | 1320.68 | 1 | 5235.75 | 12 | SO47990 | 2023-02-18 | 418.86 | 5282.74 | 1308.94 |
SO46355_9 | D579-4B15-AB | PO261195016 | 100 | 283 | 310 | 647 | 4 | 2022-09-23 | 6440.89 | 161.02 | 2022-09-11 | 3 | 2171.29 | 1 | 6440.89 | 9 | SO46355 | 2022-09-18 | 515.27 | 6513.88 | 2146.96 |
SO51856_27 | E170-419C-92 | PO3654183134 | 100 | 281 | 594 | 435 | 4 | 2023-11-23 | 1016.98 | 25.42 | 2023-11-11 | 3 | 308.22 | 1 | 1016.98 | 27 | SO51856 | 2023-11-18 | 81.36 | 924.65 | 338.99 |
SO44090_3 | D65B-43FF-AD | PO15834170093 | 100 | 283 | 232 | 417 | 4 | 2021-12-24 | 201.88 | 5.05 | 2021-12-12 | 7 | 31.72 | 1 | 201.88 | 3 | SO44090 | 2021-12-19 | 16.15 | 222.07 | 28.84 |
SO50721_6 | E836-480F-AA | PO16182137721 | 100 | 287 | 468 | 23 | 4 | 2023-09-23 | 45.59 | 1.14 | 2023-09-11 | 2 | 15.67 | 1 | 45.59 | 6 | SO50721 | 2023-09-18 | 3.65 | 31.34 | 22.79 |
SO48052_15 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 395 | 435 | 4 | 2023-02-23 | 368.24 | 9.21 | 2023-02-11 | 6 | 45.42 | 1 | 368.24 | 15 | SO48052 | 2023-02-18 | 29.46 | 272.50 | 61.37 |
SO46058_2 | FA37-4F46-97 | PO12557123934 | 100 | 282 | 322 | 240 | 4 | 2022-08-23 | 419.46 | 10.49 | 2022-08-11 | 1 | 413.15 | 1 | 419.46 | 2 | SO46058 | 2022-08-18 | 33.56 | 413.15 | 419.46 |
SO55303_21 | 5C9C-4B35-B8 | PO5626137276 | 100 | 281 | 581 | 166 | 4 | 2024-01-23 | 6123.56 | 153.09 | 2024-01-11 | 6 | 1082.51 | 1 | 6123.56 | 21 | SO55303 | 2024-01-18 | 489.89 | 6495.06 | 1020.59 |
Generated 2024-11-10 09:42:03.227 UTC