[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 142 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43904_9 | BB8E-4008-B7 | PO6351158788 | 100 | 283 | 270 | 255 | 4 | 2021-10-04 | 183.94 | 4.60 | 2021-09-22 | 1 | 181.49 | 1 | 183.94 | 9 | SO43904 | 2021-09-29 | 14.72 | 181.49 | 183.94 | |||
SO58993_10 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 586 | 627 | 5 | 2024-02-03 | 445.41 | 11.14 | 2024-01-22 | 1 | 461.44 | 1 | 445.41 | 10 | SO58993 | 2024-01-29 | 35.63 | 461.44 | 445.41 | |||
SO50252_25 | B5DA-491E-A9 | PO2523194031 | 100 | 287 | 387 | 167 | 4 | 2023-07-04 | 2401.05 | 60.03 | 2023-06-22 | 4 | 605.65 | 1 | 2401.05 | 25 | SO50252 | 2023-06-29 | 192.08 | 2422.60 | 600.26 | |||
SO58950_15 | E67E-435E-9F | PO11455199372 | 100 | 283 | 547 | 72 | 2 | 2024-02-03 | 194.38 | 4.86 | 2024-01-22 | 4 | 35.96 | 1 | 194.38 | 15 | SO58950 | 2024-01-29 | 15.55 | 143.84 | 48.59 | |||
SO67263_19 | EFEC-4A80-8F | PO17197178016 | 100 | 283 | 593 | 125 | 2 | 2024-06-04 | 338.99 | 8.47 | 2024-05-23 | 1 | 308.22 | 1 | 338.99 | 19 | SO67263 | 2024-05-30 | 27.12 | 308.22 | 338.99 | |||
SO71851_43 | AABE-4443-91 | PO18299133687 | 19 | 291 | 531 | 118 | 6 | 2024-08-04 | 299.75 | 7.49 | 2024-07-23 | 2 | 136.79 | 1 | 299.75 | 43 | SO71851 | 2024-07-30 | 23.98 | 273.57 | 149.87 | |||
SO46990_2 | 330A-4243-8E | PO11919154763 | 100 | 286 | 412 | 73 | 1 | 2022-10-04 | 180.13 | 4.50 | 2022-09-22 | 1 | 133.30 | 1 | 180.13 | 2 | SO46990 | 2022-09-29 | 14.41 | 133.30 | 180.13 | |||
SO46940_34 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 369 | 479 | 6 | 2022-10-04 | 4398.03 | 109.95 | 2022-09-22 | 3 | 1518.79 | 1 | 4398.03 | 34 | SO46940 | 2022-09-29 | 351.84 | 4556.36 | 1466.01 | |||
SO55252_6 | 1F1C-4667-AE | PO13340115824 | 100 | 292 | 590 | 355 | 7 | 2023-12-04 | 461.69 | 11.54 | 2023-11-22 | 1 | 419.78 | 1 | 461.69 | 6 | SO55252 | 2023-11-29 | 36.94 | 419.78 | 461.69 | |||
SO71798_2 | AFA9-4B18-AD | PO16994135863 | 100 | 283 | 378 | 306 | 3 | 2024-08-04 | 1466.01 | 36.65 | 2024-07-23 | 1 | 1554.95 | 1 | 1466.01 | 2 | SO71798 | 2024-07-30 | 117.28 | 1554.95 | 1466.01 | |||
SO47008_28 | FD36-4D89-AB | PO1595170889 | 19 | 284 | 447 | 426 | 6 | 2022-10-04 | 105.00 | 2.63 | 2022-09-22 | 7 | 10.31 | 1 | 105.00 | 28 | SO47008 | 2022-09-29 | 8.40 | 72.19 | 15.00 | |||
SO59044_31 | 7F7E-4EA6-97 | PO1131159849 | 36 | 290 | 523 | 536 | 8 | 2024-02-03 | 94.75 | 2.37 | 2024-01-22 | 3 | 23.37 | 1 | 94.75 | 31 | SO59044 | 2024-01-29 | 7.58 | 70.12 | 31.58 | |||
SO49065_2 | E9BC-440A-9D | PO1508143526 | 98 | 288 | 379 | 430 | 10 | 2023-04-06 | 2617.88 | 65.45 | 2023-03-25 | 2 | 1320.68 | 1 | 2617.88 | 2 | SO49065 | 2023-04-01 | 209.43 | 2641.37 | 1308.94 | |||
SO57141_25 | 5DE1-45D6-8B | PO3625112721 | 100 | 283 | 547 | 666 | 2 | 2024-01-04 | 97.19 | 2.43 | 2023-12-23 | 2 | 35.96 | 1 | 97.19 | 25 | SO57141 | 2023-12-30 | 7.78 | 71.92 | 48.59 | |||
SO50314_29 | 5D9A-4B55-81 | PO7627146177 | 100 | 293 | 343 | 433 | 1 | 2023-07-04 | 939.59 | 23.49 | 2023-06-22 | 2 | 486.71 | 1 | 939.59 | 29 | SO50314 | 2023-06-29 | 75.17 | 973.41 | 469.79 | |||
SO71824_21 | BBB4-42D9-86 | PO11455162600 | 100 | 283 | 580 | 72 | 2 | 2024-08-04 | 6123.56 | 153.09 | 2024-07-23 | 6 | 1082.51 | 1 | 6123.56 | 21 | SO71824 | 2024-07-30 | 489.89 | 6495.06 | 1020.59 | |||
SO51094_1 | 39DF-419F-B9 | PO14616117012 | 6 | 296 | 564 | 14 | 634 | 9 | 190.73 | 2023-09-03 | 953.63 | 19.07 | 2023-08-22 | 1 | 1481.94 | 1 | 762.90 | 1 | SO51094 | 2023-08-29 | 61.03 | 1481.94 | 953.63 | 0.20 |
SO71805_43 | 99FD-47B9-97 | PO14703194514 | 6 | 296 | 493 | 573 | 9 | 2024-08-04 | 600.16 | 15.00 | 2024-07-23 | 3 | 199.85 | 1 | 600.16 | 43 | SO71805 | 2024-07-30 | 48.01 | 599.56 | 200.05 | |||
SO71784_17 | B186-4413-B4 | PO19285135919 | 98 | 288 | 463 | 448 | 10 | 2024-08-04 | 88.16 | 2.20 | 2024-07-23 | 6 | 9.16 | 1 | 88.16 | 17 | SO71784 | 2024-07-30 | 7.05 | 54.96 | 14.69 | |||
SO53477_9 | F1BC-4EF4-85 | PO15544120937 | 19 | 284 | 556 | 282 | 6 | 2023-11-04 | 315.88 | 7.90 | 2023-10-23 | 3 | 77.92 | 1 | 315.88 | 9 | SO53477 | 2023-10-30 | 25.27 | 233.75 | 105.29 | |||
SO46956_3 | 158F-43CB-95 | PO16849143827 | 100 | 281 | 460 | 198 | 3 | 2022-10-04 | 53.99 | 1.35 | 2022-09-22 | 1 | 37.12 | 1 | 53.99 | 3 | SO46956 | 2022-09-29 | 4.32 | 37.12 | 53.99 | |||
SO58982_13 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 240 | 311 | 4 | 2024-02-03 | 858.90 | 21.47 | 2024-01-22 | 1 | 868.63 | 1 | 858.90 | 13 | SO58982 | 2024-01-29 | 68.71 | 868.63 | 858.90 | |||
SO61240_24 | 16E9-4057-BF | PO6467181082 | 100 | 283 | 465 | 660 | 3 | 2024-03-05 | 102.86 | 2.57 | 2024-02-22 | 7 | 9.16 | 1 | 102.86 | 24 | SO61240 | 2024-02-29 | 8.23 | 64.12 | 14.69 | |||
SO71836_4 | E41E-40C1-84 | PO841118259 | 100 | 286 | 543 | 254 | 1 | 2024-08-04 | 149.02 | 3.73 | 2024-07-23 | 4 | 27.57 | 1 | 149.02 | 4 | SO71836 | 2024-07-30 | 11.92 | 110.27 | 37.25 | |||
SO47400_46 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 221 | 3 | 133 | 4 | 19.43 | 2022-11-04 | 388.59 | 9.23 | 2022-10-23 | 21 | 13.88 | 1 | 369.16 | 46 | SO47400 | 2022-10-30 | 29.53 | 291.44 | 18.50 | 0.05 |
SO48336_36 | 48F2-4141-9A | PO11455111823 | 100 | 281 | 370 | 72 | 2 | 2023-02-03 | 2932.02 | 73.30 | 2023-01-22 | 2 | 1518.79 | 1 | 2932.02 | 36 | SO48336 | 2023-01-29 | 234.56 | 3037.57 | 1466.01 | |||
SO51704_30 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 501 | 264 | 6 | 2023-10-04 | 72.88 | 1.82 | 2023-09-22 | 1 | 53.93 | 1 | 72.88 | 30 | SO51704 | 2023-09-29 | 5.83 | 53.93 | 72.88 | |||
SO47058_3 | B93E-451C-8E | PO7714171239 | 100 | 285 | 323 | 495 | 5 | 2022-10-04 | 469.79 | 11.74 | 2022-09-22 | 1 | 486.71 | 1 | 469.79 | 3 | SO47058 | 2022-09-29 | 37.58 | 486.71 | 469.79 |
Generated 2024-09-21 06:27:03.938 UTC