[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 620 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49828_2 | 8223-49DF-83 | PO14732189078 | 19 | 291 | 323 | 514 | 6 | 2023-06-03 | 2818.76 | 70.47 | 2023-05-22 | 6 | 486.71 | 1 | 2818.76 | 2 | SO49828 | 2023-05-29 | 225.50 | 2920.24 | 469.79 | |||
SO51699_17 | 31D5-494C-BA | PO18879118606 | 19 | 291 | 548 | 64 | 6 | 2023-10-03 | 145.78 | 3.64 | 2023-09-21 | 3 | 35.96 | 1 | 145.78 | 17 | SO51699 | 2023-09-28 | 11.66 | 107.88 | 48.59 | |||
SO49508_2 | C9AF-4F06-88 | PO12876113639 | 19 | 284 | 377 | 300 | 6 | 2023-05-03 | 1308.94 | 32.72 | 2023-04-21 | 1 | 1320.68 | 1 | 1308.94 | 2 | SO49508 | 2023-04-28 | 104.72 | 1320.68 | 1308.94 | |||
SO50668_8 | A5FC-4831-B4 | PO17574113752 | 19 | 291 | 395 | 678 | 6 | 2023-08-03 | 368.24 | 9.21 | 2023-07-22 | 6 | 45.42 | 1 | 368.24 | 8 | SO50668 | 2023-07-29 | 29.46 | 272.50 | 61.37 | |||
SO49066_25 | 4065-4B0A-A2 | PO1595117888 | 19 | 284 | 381 | 426 | 6 | 2023-04-05 | 1800.79 | 45.02 | 2023-03-24 | 3 | 605.65 | 1 | 1800.79 | 25 | SO49066 | 2023-03-31 | 144.06 | 1816.95 | 600.26 | |||
SO57093_39 | 2F7C-4AF6-8B | PO18705165751 | 19 | 291 | 482 | 479 | 6 | 2024-01-03 | 48.55 | 1.21 | 2023-12-22 | 9 | 3.36 | 1 | 48.55 | 39 | SO57093 | 2023-12-29 | 3.88 | 30.26 | 5.39 | |||
SO44534_10 | 07F6-4A99-A3 | PO2146113582 | 19 | 284 | 350 | 2 | 354 | 6 | 469.80 | 2022-01-03 | 23489.93 | 575.50 | 2021-12-22 | 12 | 1898.09 | 1 | 23020.13 | 10 | SO44534 | 2021-12-29 | 1841.61 | 22777.13 | 1957.49 | 0.02 |
SO71841_37 | 1544-4561-AB | PO1798133189 | 19 | 291 | 476 | 2 | 10 | 6 | 11.37 | 2024-08-03 | 568.32 | 13.92 | 2024-07-22 | 14 | 26.18 | 1 | 556.95 | 37 | SO71841 | 2024-07-29 | 44.56 | 366.47 | 40.59 | 0.02 |
SO47988_20 | 3979-4615-A9 | PO16733190266 | 19 | 291 | 447 | 533 | 6 | 2023-01-03 | 60.00 | 1.50 | 2022-12-22 | 4 | 10.31 | 1 | 60.00 | 20 | SO47988 | 2022-12-29 | 4.80 | 41.25 | 15.00 | |||
SO50202_1 | 7271-4930-85 | PO17313159260 | 19 | 291 | 470 | 389 | 6 | 2023-07-03 | 68.38 | 1.71 | 2023-06-21 | 3 | 15.67 | 1 | 68.38 | 1 | SO50202 | 2023-06-28 | 5.47 | 47.01 | 22.79 | |||
SO46645_3 | F857-4A6D-9C | PO1711132491 | 19 | 291 | 395 | 245 | 6 | 2022-09-02 | 306.87 | 7.67 | 2022-08-21 | 5 | 45.42 | 1 | 306.87 | 3 | SO46645 | 2022-08-28 | 24.55 | 227.08 | 61.37 | |||
SO71841_3 | 1544-4561-AB | PO1798133189 | 19 | 291 | 353 | 10 | 6 | 2024-08-03 | 9743.96 | 243.60 | 2024-07-22 | 7 | 1265.62 | 1 | 9743.96 | 3 | SO71841 | 2024-07-29 | 779.52 | 8859.34 | 1391.99 | |||
SO51791_10 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 222 | 552 | 6 | 2023-10-03 | 125.96 | 3.15 | 2023-09-21 | 6 | 13.09 | 1 | 125.96 | 10 | SO51791 | 2023-09-28 | 10.08 | 78.52 | 20.99 | |||
SO51130_4 | F38F-411F-B2 | PO18473180006 | 19 | 291 | 525 | 442 | 6 | 2023-09-02 | 475.29 | 11.88 | 2023-08-21 | 3 | 144.59 | 1 | 475.29 | 4 | SO51130 | 2023-08-28 | 38.02 | 433.78 | 158.43 | |||
SO47668_37 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 254 | 299 | 6 | 2022-12-03 | 367.88 | 9.20 | 2022-11-21 | 2 | 170.14 | 1 | 367.88 | 37 | SO47668 | 2022-11-28 | 29.43 | 340.29 | 183.94 | |||
SO50203_20 | 821E-4862-9A | PO17603125956 | 19 | 284 | 422 | 12 | 6 | 2023-07-03 | 270.16 | 6.75 | 2023-06-21 | 4 | 49.98 | 1 | 270.16 | 20 | SO50203 | 2023-06-28 | 21.61 | 199.92 | 67.54 | |||
SO49066_14 | 4065-4B0A-A2 | PO1595117888 | 19 | 284 | 461 | 426 | 6 | 2023-04-05 | 269.97 | 6.75 | 2023-03-24 | 5 | 37.12 | 1 | 269.97 | 14 | SO49066 | 2023-03-31 | 21.60 | 185.60 | 53.99 | |||
SO63266_22 | 4D6E-4BF2-B9 | PO4466196255 | 19 | 291 | 592 | 352 | 6 | 2024-04-04 | 338.99 | 8.47 | 2024-03-23 | 1 | 308.22 | 1 | 338.99 | 22 | SO63266 | 2024-03-30 | 27.12 | 308.22 | 338.99 | |||
SO51130_28 | F38F-411F-B2 | PO18473180006 | 19 | 291 | 501 | 442 | 6 | 2023-09-02 | 145.75 | 3.64 | 2023-08-21 | 2 | 53.93 | 1 | 145.75 | 28 | SO51130 | 2023-08-28 | 11.66 | 107.86 | 72.88 | |||
SO50716_31 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 360 | 118 | 6 | 2023-08-03 | 1229.46 | 30.74 | 2023-07-22 | 1 | 1105.81 | 1 | 1229.46 | 31 | SO50716 | 2023-07-29 | 98.36 | 1105.81 | 1229.46 | |||
SO45278_9 | 7EE7-4F70-81 | PO18415191281 | 19 | 288 | 336 | 191 | 6 | 2022-04-05 | 419.46 | 10.49 | 2022-03-24 | 1 | 413.15 | 1 | 419.46 | 9 | SO45278 | 2022-03-31 | 33.56 | 413.15 | 419.46 | |||
SO57188_14 | BA1D-4480-AA | PO9077120275 | 19 | 291 | 551 | 100 | 6 | 2024-01-03 | 158.43 | 3.96 | 2023-12-22 | 1 | 144.59 | 1 | 158.43 | 14 | SO57188 | 2023-12-29 | 12.67 | 144.59 | 158.43 | |||
SO63141_6 | 96AB-479F-86 | PO17603143134 | 19 | 284 | 487 | 12 | 6 | 2024-04-04 | 164.97 | 4.12 | 2024-03-23 | 5 | 20.57 | 1 | 164.97 | 6 | SO63141 | 2024-03-30 | 13.20 | 102.83 | 32.99 | |||
SO51786_19 | CB32-4179-97 | PO18357130739 | 19 | 272 | 568 | 13 | 138 | 6 | 100.22 | 2023-10-03 | 668.12 | 14.20 | 2023-09-21 | 2 | 461.44 | 1 | 567.90 | 19 | SO51786 | 2023-09-28 | 45.43 | 922.89 | 334.06 | 0.15 |
SO49839_8 | 3123-41F3-9B | PO10527179463 | 19 | 284 | 325 | 480 | 6 | 2023-06-03 | 469.79 | 11.74 | 2023-05-22 | 1 | 486.71 | 1 | 469.79 | 8 | SO49839 | 2023-05-29 | 37.58 | 486.71 | 469.79 | |||
SO61186_13 | C662-487E-B0 | PO14732152217 | 19 | 291 | 547 | 514 | 6 | 2024-03-04 | 145.78 | 3.64 | 2024-02-21 | 3 | 35.96 | 1 | 145.78 | 13 | SO61186 | 2024-02-28 | 11.66 | 107.88 | 48.59 | |||
SO48754_9 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 397 | 442 | 6 | 2023-03-05 | 24.29 | 0.61 | 2023-02-21 | 1 | 17.98 | 1 | 24.29 | 9 | SO48754 | 2023-02-28 | 1.94 | 17.98 | 24.29 | |||
SO58932_5 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 507 | 408 | 6 | 2024-02-02 | 200.05 | 5.00 | 2024-01-21 | 1 | 199.85 | 1 | 200.05 | 5 | SO58932 | 2024-01-28 | 16.00 | 199.85 | 200.05 |
Generated 2024-09-21 00:17:32.149 UTC