[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 863 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47018_57 | E622-43B1-98 | PO2523197473 | 100 | 287 | 458 | 167 | 4 | 2022-11-27 | 269.96 | 6.75 | 2022-11-15 | 6 | 30.93 | 1 | 269.96 | 57 | SO47018 | 2022-11-22 | 21.60 | 185.60 | 44.99 | |||
SO53490_2 | 48D0-4BD6-8A | PO13717132596 | 100 | 287 | 520 | 473 | 4 | 2023-12-28 | 31.58 | 0.79 | 2023-12-16 | 1 | 23.37 | 1 | 31.58 | 2 | SO53490 | 2023-12-23 | 2.53 | 23.37 | 31.58 | |||
SO53606_23 | 6A19-463C-B7 | PO5539128997 | 100 | 282 | 471 | 61 | 4 | 2023-12-28 | 304.80 | 7.62 | 2023-12-16 | 8 | 23.75 | 1 | 304.80 | 23 | SO53606 | 2023-12-23 | 24.38 | 189.99 | 38.10 | |||
SO45299_16 | 0D55-4B85-AD | PO12557162961 | 100 | 282 | 342 | 240 | 4 | 2022-05-30 | 419.46 | 10.49 | 2022-05-18 | 1 | 413.15 | 1 | 419.46 | 16 | SO45299 | 2022-05-25 | 33.56 | 413.15 | 419.46 | |||
SO46960_11 | F05E-41EB-90 | PO16762181648 | 100 | 282 | 221 | 259 | 4 | 2022-11-27 | 40.37 | 1.01 | 2022-11-15 | 2 | 13.88 | 1 | 40.37 | 11 | SO46960 | 2022-11-22 | 3.23 | 27.76 | 20.19 | |||
SO51131_26 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 237 | 599 | 4 | 2023-10-27 | 59.99 | 1.50 | 2023-10-15 | 2 | 38.49 | 1 | 59.99 | 26 | SO51131 | 2023-10-22 | 4.80 | 76.98 | 29.99 | |||
SO46992_12 | C958-4FD6-A0 | PO11745117547 | 100 | 282 | 461 | 97 | 4 | 2022-11-27 | 161.98 | 4.05 | 2022-11-15 | 3 | 37.12 | 1 | 161.98 | 12 | SO46992 | 2022-11-22 | 12.96 | 111.36 | 53.99 | |||
SO51131_51 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 480 | 599 | 4 | 2023-10-27 | 5.50 | 0.14 | 2023-10-15 | 4 | 0.86 | 1 | 5.50 | 51 | SO51131 | 2023-10-22 | 0.44 | 3.43 | 1.37 | |||
SO46606_1 | 0363-4D92-B0 | PO18009195462 | 100 | 282 | 230 | 510 | 4 | 2022-10-27 | 57.68 | 1.44 | 2022-10-15 | 2 | 29.08 | 1 | 57.68 | 1 | SO46606 | 2022-10-22 | 4.61 | 58.16 | 28.84 | |||
SO50748_19 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 271 | 3 | 4 | 2023-09-27 | 607.00 | 15.17 | 2023-09-15 | 3 | 187.16 | 1 | 607.00 | 19 | SO50748 | 2023-09-22 | 48.56 | 561.47 | 202.33 | |||
SO47056_22 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 389 | 403 | 4 | 2022-11-27 | 4201.84 | 105.05 | 2022-11-15 | 7 | 605.65 | 1 | 4201.84 | 22 | SO47056 | 2022-11-22 | 336.15 | 4239.54 | 600.26 | |||
SO49841_29 | 35A1-40DC-99 | PO10817181706 | 100 | 287 | 236 | 203 | 4 | 2023-07-28 | 28.84 | 0.72 | 2023-07-16 | 1 | 29.08 | 1 | 28.84 | 29 | SO49841 | 2023-07-23 | 2.31 | 29.08 | 28.84 | |||
SO57157_13 | 2435-487B-AC | PO4843135815 | 100 | 287 | 606 | 257 | 4 | 2024-02-27 | 1295.98 | 32.40 | 2024-02-15 | 4 | 343.65 | 1 | 1295.98 | 13 | SO57157 | 2024-02-22 | 103.68 | 1374.60 | 323.99 | |||
SO49127_20 | 01A1-43AB-A2 | PO3480145572 | 100 | 272 | 335 | 436 | 4 | 2023-05-30 | 2348.97 | 58.72 | 2023-05-18 | 5 | 486.71 | 1 | 2348.97 | 20 | SO49127 | 2023-05-25 | 187.92 | 2433.53 | 469.79 | |||
SO53596_1 | 6DDB-4913-AA | PO2349157569 | 100 | 282 | 547 | 6 | 4 | 2023-12-28 | 48.59 | 1.21 | 2023-12-16 | 1 | 35.96 | 1 | 48.59 | 1 | SO53596 | 2023-12-23 | 3.89 | 35.96 | 48.59 | |||
SO63201_7 | 8299-4DE4-AD | PO15689136917 | 100 | 281 | 225 | 328 | 4 | 2024-05-29 | 21.58 | 0.54 | 2024-05-17 | 4 | 6.92 | 1 | 21.58 | 7 | SO63201 | 2024-05-24 | 1.73 | 27.69 | 5.39 | |||
SO51106_2 | 3D96-4D27-92 | PO12528166058 | 100 | 282 | 585 | 13 | 331 | 4 | 250.54 | 2023-10-27 | 1670.29 | 35.49 | 2023-10-15 | 5 | 461.44 | 1 | 1419.74 | 2 | SO51106 | 2023-10-22 | 113.58 | 2307.22 | 334.06 | 0.15 |
SO58909_39 | EBC4-496C-90 | PO19343180161 | 100 | 282 | 378 | 24 | 4 | 2024-03-28 | 2932.02 | 73.30 | 2024-03-16 | 2 | 1554.95 | 1 | 2932.02 | 39 | SO58909 | 2024-03-23 | 234.56 | 3109.90 | 1466.01 | |||
SO50738_48 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 445 | 130 | 4 | 2023-09-27 | 35.99 | 0.90 | 2023-09-15 | 1 | 24.75 | 1 | 35.99 | 48 | SO50738 | 2023-09-22 | 2.88 | 24.75 | 35.99 | |||
SO47434_19 | 6848-4C33-98 | PO5539145068 | 100 | 282 | 459 | 61 | 4 | 2022-12-28 | 161.98 | 4.05 | 2022-12-16 | 3 | 37.12 | 1 | 161.98 | 19 | SO47434 | 2022-12-23 | 12.96 | 111.36 | 53.99 | |||
SO45799_23 | 4DE8-4B9B-A1 | PO10730195041 | 100 | 287 | 313 | 491 | 4 | 2022-07-28 | 2146.96 | 53.67 | 2022-07-16 | 1 | 2171.29 | 1 | 2146.96 | 23 | SO45799 | 2022-07-23 | 171.76 | 2171.29 | 2146.96 | |||
SO47658_31 | C574-484B-83 | PO551177057 | 100 | 283 | 433 | 4 | 4 | 2023-01-27 | 1946.72 | 48.67 | 2023-01-15 | 6 | 300.12 | 1 | 1946.72 | 31 | SO47658 | 2023-01-22 | 155.74 | 1800.71 | 324.45 | |||
SO46093_18 | B221-4D2A-99 | PO6351171482 | 100 | 283 | 285 | 255 | 4 | 2022-08-27 | 178.58 | 4.46 | 2022-08-15 | 1 | 176.20 | 1 | 178.58 | 18 | SO46093 | 2022-08-22 | 14.29 | 176.20 | 178.58 | |||
SO46380_19 | C4E3-4894-81 | PO7569183330 | 100 | 287 | 351 | 7 | 608 | 4 | 1476.56 | 2022-09-27 | 4218.74 | 68.55 | 2022-09-15 | 5 | 1898.09 | 1 | 2742.18 | 19 | SO46380 | 2022-09-22 | 219.37 | 9490.47 | 843.75 | 0.35 |
SO69528_10 | 2644-4747-86 | PO6438163496 | 100 | 272 | 477 | 309 | 4 | 2024-08-27 | 8.98 | 0.22 | 2024-08-15 | 3 | 1.87 | 1 | 8.98 | 10 | SO69528 | 2024-08-22 | 0.72 | 5.60 | 2.99 | |||
SO51131_43 | D489-4DF3-A2 | PO16298169856 | 100 | 287 | 491 | 4 | 599 | 4 | 67.49 | 2023-10-27 | 674.88 | 15.18 | 2023-10-15 | 25 | 41.57 | 1 | 607.39 | 43 | SO51131 | 2023-10-22 | 48.59 | 1039.31 | 27.00 | 0.10 |
SO50743_6 | C1F5-4D36-9F | PO4640120853 | 100 | 287 | 399 | 648 | 4 | 2023-09-27 | 67.55 | 1.69 | 2023-09-15 | 2 | 24.99 | 1 | 67.55 | 6 | SO50743 | 2023-09-22 | 5.40 | 49.99 | 33.77 | |||
SO47458_17 | 5D5A-47FC-AE | PO9686113121 | 100 | 282 | 421 | 457 | 4 | 2022-12-28 | 1177.97 | 29.45 | 2022-12-16 | 6 | 145.28 | 1 | 1177.97 | 17 | SO47458 | 2022-12-23 | 94.24 | 871.70 | 196.33 |
Generated 2024-11-14 07:00:35.249 UTC