[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 1323 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO65189_5 | 985E-4937-94 | PO14761195376 | 19 | 284 | 484 | 408 | 6 | 2024-05-04 | 42.93 | 1.07 | 2024-04-22 | 9 | 2.97 | 1 | 42.93 | 5 | SO65189 | 2024-04-29 | 3.43 | 26.76 | 4.77 | |||
SO47380_30 | EF71-4036-91 | PO14790123967 | 19 | 291 | 447 | 497 | 6 | 2022-11-04 | 45.00 | 1.13 | 2022-10-23 | 3 | 10.31 | 1 | 45.00 | 30 | SO47380 | 2022-10-30 | 3.60 | 30.94 | 15.00 | |||
SO46044_3 | 029B-4675-9A | PO16733123313 | 19 | 288 | 311 | 533 | 6 | 2022-07-04 | 2146.96 | 53.67 | 2022-06-22 | 1 | 2171.29 | 1 | 2146.96 | 3 | SO46044 | 2022-06-29 | 171.76 | 2171.29 | 2146.96 | |||
SO71851_39 | AABE-4443-91 | PO18299133687 | 19 | 291 | 551 | 118 | 6 | 2024-08-04 | 633.72 | 15.84 | 2024-07-23 | 4 | 144.59 | 1 | 633.72 | 39 | SO71851 | 2024-07-30 | 50.70 | 578.38 | 158.43 | |||
SO47008_38 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 422 | 426 | 6 | 2022-10-04 | 67.54 | 1.69 | 2022-09-22 | 1 | 49.98 | 1 | 67.54 | 38 | SO47008 | 2022-09-29 | 5.40 | 49.98 | 67.54 | |||
SO71830_32 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 498 | 281 | 6 | 2024-08-04 | 1204.69 | 30.12 | 2024-07-23 | 2 | 601.74 | 1 | 1204.69 | 32 | SO71830 | 2024-07-30 | 96.38 | 1203.49 | 602.35 | |||
SO55243_31 | 2457-46EE-88 | PO15312160912 | 19 | 291 | 225 | 299 | 6 | 2023-12-04 | 43.15 | 1.08 | 2023-11-22 | 8 | 6.92 | 1 | 43.15 | 31 | SO55243 | 2023-11-29 | 3.45 | 55.38 | 5.39 | |||
SO49042_2 | CCD3-4B59-81 | PO19459119840 | 19 | 291 | 221 | 334 | 6 | 2023-04-06 | 60.56 | 1.51 | 2023-03-25 | 3 | 13.88 | 1 | 60.56 | 2 | SO49042 | 2023-04-01 | 4.84 | 41.63 | 20.19 | |||
SO44490_5 | 0CC4-4097-80 | PO19227160482 | 19 | 284 | 328 | 210 | 6 | 2022-01-04 | 838.92 | 20.97 | 2021-12-23 | 2 | 413.15 | 1 | 838.92 | 5 | SO44490 | 2021-12-30 | 67.11 | 826.29 | 419.46 | |||
SO49855_10 | 0C94-4D84-A4 | PO18473166459 | 19 | 291 | 236 | 442 | 6 | 2023-06-04 | 28.84 | 0.72 | 2023-05-23 | 1 | 29.08 | 1 | 28.84 | 10 | SO49855 | 2023-05-30 | 2.31 | 29.08 | 28.84 | |||
SO48337_1 | BE13-436F-B5 | PO11165163196 | 19 | 291 | 360 | 586 | 6 | 2023-02-03 | 4917.84 | 122.95 | 2023-01-22 | 4 | 1105.81 | 1 | 4917.84 | 1 | SO48337 | 2023-01-29 | 393.43 | 4423.24 | 1229.46 | |||
SO49501_6 | EF67-4713-BD | PO17574111786 | 19 | 291 | 367 | 678 | 6 | 2023-05-04 | 647.99 | 16.20 | 2023-04-22 | 1 | 598.44 | 1 | 647.99 | 6 | SO49501 | 2023-04-29 | 51.84 | 598.44 | 647.99 | |||
SO71841_49 | 1544-4561-AB | PO1798133189 | 19 | 291 | 598 | 10 | 6 | 2024-08-04 | 647.99 | 16.20 | 2024-07-23 | 2 | 294.58 | 1 | 647.99 | 49 | SO71841 | 2024-07-30 | 51.84 | 589.16 | 323.99 | |||
SO57188_13 | BA1D-4480-AA | PO9077120275 | 19 | 291 | 543 | 100 | 6 | 2024-01-04 | 37.25 | 0.93 | 2023-12-23 | 1 | 27.57 | 1 | 37.25 | 13 | SO57188 | 2023-12-30 | 2.98 | 27.57 | 37.25 | |||
SO51124_32 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 298 | 245 | 6 | 2023-09-03 | 4858.56 | 121.46 | 2023-08-22 | 6 | 739.04 | 1 | 4858.56 | 32 | SO51124 | 2023-08-29 | 388.68 | 4434.25 | 809.76 | |||
SO57023_8 | EE6C-4089-A0 | PO17603140236 | 19 | 284 | 490 | 12 | 6 | 2024-01-04 | 259.15 | 6.48 | 2023-12-23 | 8 | 41.57 | 1 | 259.15 | 8 | SO57023 | 2023-12-30 | 20.73 | 332.58 | 32.39 | |||
SO44499_2 | B705-47AD-A4 | PO17313144828 | 19 | 288 | 345 | 389 | 6 | 2022-01-04 | 2039.99 | 51.00 | 2021-12-23 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO44499 | 2021-12-30 | 163.20 | 1912.15 | 2039.99 | |||
SO49879_25 | 7A79-4FB0-85 | PO4495112714 | 19 | 291 | 364 | 496 | 6 | 2023-06-04 | 1295.99 | 32.40 | 2023-05-23 | 2 | 598.44 | 1 | 1295.99 | 25 | SO49879 | 2023-05-30 | 103.68 | 1196.87 | 647.99 | |||
SO45522_12 | DB6E-40EF-A4 | PO19401195812 | 19 | 288 | 310 | 173 | 6 | 2022-05-04 | 2146.96 | 53.67 | 2022-04-22 | 1 | 2171.29 | 1 | 2146.96 | 12 | SO45522 | 2022-04-29 | 171.76 | 2171.29 | 2146.96 | |||
SO46950_4 | AAC1-43D9-A3 | PO17806144306 | 19 | 291 | 216 | 101 | 6 | 2022-10-04 | 40.37 | 1.01 | 2022-09-22 | 2 | 13.88 | 1 | 40.37 | 4 | SO46950 | 2022-09-29 | 3.23 | 27.76 | 20.19 | |||
SO49103_8 | 0B8A-4326-8A | PO17748175932 | 19 | 284 | 375 | 102 | 6 | 2023-04-06 | 1308.94 | 32.72 | 2023-03-25 | 1 | 1320.68 | 1 | 1308.94 | 8 | SO49103 | 2023-04-01 | 104.72 | 1320.68 | 1308.94 | |||
SO55275_8 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 527 | 245 | 6 | 2023-12-04 | 633.72 | 15.84 | 2023-11-22 | 4 | 144.59 | 1 | 633.72 | 8 | SO55275 | 2023-11-29 | 50.70 | 578.38 | 158.43 | |||
SO51818_14 | B8CE-4C91-A9 | PO9077115532 | 19 | 291 | 591 | 100 | 6 | 2023-10-04 | 338.99 | 8.47 | 2023-09-22 | 1 | 308.22 | 1 | 338.99 | 14 | SO51818 | 2023-09-29 | 27.12 | 308.22 | 338.99 | |||
SO49507_15 | 405D-4B85-98 | PO14790133950 | 19 | 291 | 409 | 497 | 6 | 2023-05-04 | 209.26 | 5.23 | 2023-04-22 | 1 | 185.82 | 1 | 209.26 | 15 | SO49507 | 2023-04-29 | 16.74 | 185.82 | 209.26 | |||
SO51781_2 | 63E7-4ABF-A9 | PO20039116715 | 19 | 291 | 477 | 65 | 6 | 2023-10-04 | 11.98 | 0.30 | 2023-09-22 | 4 | 1.87 | 1 | 11.98 | 2 | SO51781 | 2023-09-29 | 0.96 | 7.47 | 2.99 | |||
SO61232_5 | 3450-43E5-B1 | PO11136111699 | 19 | 284 | 573 | 120 | 6 | 2024-03-05 | 1430.44 | 35.76 | 2024-02-22 | 1 | 1481.94 | 1 | 1430.44 | 5 | SO61232 | 2024-02-29 | 114.44 | 1481.94 | 1430.44 | |||
SO49501_20 | EF67-4713-BD | PO17574111786 | 19 | 291 | 427 | 678 | 6 | 2023-05-04 | 209.26 | 5.23 | 2023-04-22 | 1 | 185.82 | 1 | 209.26 | 20 | SO49501 | 2023-04-29 | 16.74 | 185.82 | 209.26 | |||
SO46616_18 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 453 | 2 | 514 | 6 | 7.65 | 2022-09-03 | 382.74 | 9.38 | 2022-08-22 | 11 | 24.75 | 1 | 375.08 | 18 | SO46616 | 2022-08-29 | 30.01 | 272.20 | 34.79 | 0.02 |
SO47988_51 | 3979-4615-A9 | PO16733190266 | 19 | 291 | 415 | 533 | 6 | 2023-01-04 | 396.07 | 9.90 | 2022-12-23 | 2 | 146.55 | 1 | 396.07 | 51 | SO47988 | 2022-12-30 | 31.69 | 293.09 | 198.04 | |||
SO46658_5 | F375-4C62-AB | PO4930144247 | 19 | 291 | 421 | 425 | 6 | 2022-09-03 | 196.33 | 4.91 | 2022-08-22 | 1 | 145.28 | 1 | 196.33 | 5 | SO46658 | 2022-08-29 | 15.71 | 145.28 | 196.33 |
Generated 2024-09-21 07:35:03.602 UTC