[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE < SKIP 6250 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57099_36 | 410F-45E9-9C | PO18618199656 | 100 | 286 | 231 | 605 | 1 | 2024-01-03 | 29.99 | 0.75 | 2023-12-22 | 1 | 38.49 | 1 | 29.99 | 36 | SO57099 | 2023-12-29 | 2.40 | 38.49 | 29.99 | |||
SO49503_10 | 1FD6-48BE-A1 | PO13543189827 | 100 | 287 | 297 | 293 | 1 | 2023-05-03 | 1472.29 | 36.81 | 2023-04-21 | 2 | 653.70 | 1 | 1472.29 | 10 | SO49503 | 2023-04-28 | 117.78 | 1307.39 | 736.15 | |||
SO57136_14 | 0031-4C10-84 | PO7627163680 | 100 | 272 | 376 | 433 | 1 | 2024-01-03 | 8796.06 | 219.90 | 2023-12-22 | 6 | 1554.95 | 1 | 8796.06 | 14 | SO57136 | 2023-12-29 | 703.68 | 9329.69 | 1466.01 | |||
SO67322_10 | 1881-4634-82 | PO6612121393 | 100 | 286 | 585 | 110 | 1 | 2024-06-03 | 1336.23 | 33.41 | 2024-05-22 | 3 | 461.44 | 1 | 1336.23 | 10 | SO67322 | 2024-05-29 | 106.90 | 1384.33 | 445.41 | |||
SO71904_3 | DBF0-4665-A7 | PO5017189568 | 100 | 289 | 560 | 308 | 1 | 2024-08-03 | 728.91 | 18.22 | 2024-07-22 | 1 | 755.15 | 1 | 728.91 | 3 | SO71904 | 2024-07-29 | 58.31 | 755.15 | 728.91 | |||
SO48001_8 | 02F1-4434-99 | PO14442151969 | 100 | 293 | 362 | 127 | 1 | 2023-01-03 | 1229.46 | 30.74 | 2022-12-22 | 1 | 1105.81 | 1 | 1229.46 | 8 | SO48001 | 2022-12-29 | 98.36 | 1105.81 | 1229.46 | |||
SO48741_20 | 5AA4-4194-B9 | PO899196006 | 100 | 289 | 445 | 290 | 1 | 2023-03-05 | 71.99 | 1.80 | 2023-02-21 | 2 | 24.75 | 1 | 71.99 | 20 | SO48741 | 2023-02-28 | 5.76 | 49.49 | 35.99 | |||
SO63131_22 | E035-4732-84 | PO18676136384 | 100 | 282 | 355 | 697 | 1 | 2024-04-04 | 12527.95 | 313.20 | 2024-03-23 | 9 | 1265.62 | 1 | 12527.95 | 22 | SO63131 | 2024-03-30 | 1002.24 | 11390.58 | 1391.99 | |||
SO69408_2 | 8DF5-4377-9D | PO16414161428 | 100 | 289 | 603 | 236 | 1 | 2024-07-03 | 364.47 | 9.11 | 2024-06-21 | 5 | 53.94 | 1 | 364.47 | 2 | SO69408 | 2024-06-28 | 29.16 | 269.71 | 72.89 | |||
SO50715_3 | 2C43-4B41-B4 | PO14065128023 | 100 | 293 | 273 | 379 | 1 | 2023-08-03 | 809.33 | 20.23 | 2023-07-22 | 4 | 187.16 | 1 | 809.33 | 3 | SO50715 | 2023-07-29 | 64.75 | 748.63 | 202.33 | |||
SO71833_43 | 8525-4645-AB | PO10411123072 | 100 | 289 | 496 | 182 | 1 | 2024-08-03 | 1204.69 | 30.12 | 2024-07-22 | 2 | 601.74 | 1 | 1204.69 | 43 | SO71833 | 2024-07-29 | 96.38 | 1203.49 | 602.35 | |||
SO43911_8 | EB9C-47A4-AC | PO7627190040 | 100 | 286 | 223 | 433 | 1 | 2021-10-03 | 10.37 | 0.26 | 2021-09-21 | 2 | 5.71 | 1 | 10.37 | 8 | SO43911 | 2021-09-28 | 0.83 | 11.41 | 5.19 | |||
SO53613_28 | 4A10-4F98-84 | PO6815195063 | 100 | 293 | 588 | 109 | 1 | 2023-11-03 | 923.39 | 23.08 | 2023-10-22 | 2 | 419.78 | 1 | 923.39 | 28 | SO53613 | 2023-10-29 | 73.87 | 839.56 | 461.69 | |||
SO48782_1 | 2EF6-431D-98 | PO5075195178 | 100 | 289 | 327 | 344 | 1 | 2023-03-05 | 469.79 | 11.74 | 2023-02-21 | 1 | 486.71 | 1 | 469.79 | 1 | SO48782 | 2023-02-28 | 37.58 | 486.71 | 469.79 | |||
SO58910_25 | A209-4ADD-98 | PO19169152738 | 100 | 289 | 555 | 272 | 1 | 2024-02-02 | 191.70 | 4.79 | 2024-01-21 | 3 | 47.29 | 1 | 191.70 | 25 | SO58910 | 2024-01-28 | 15.34 | 141.86 | 63.90 | |||
SO71785_15 | 28F9-4101-A1 | PO19169115427 | 100 | 289 | 555 | 272 | 1 | 2024-08-03 | 63.90 | 1.60 | 2024-07-22 | 1 | 47.29 | 1 | 63.90 | 15 | SO71785 | 2024-07-29 | 5.11 | 47.29 | 63.90 | |||
SO61199_18 | EFA0-4D12-A2 | PO2552199779 | 100 | 286 | 596 | 506 | 1 | 2024-03-04 | 971.98 | 24.30 | 2024-02-21 | 3 | 294.58 | 1 | 971.98 | 18 | SO61199 | 2024-02-28 | 77.76 | 883.74 | 323.99 | |||
SO71925_4 | 9291-44AD-BD | PO3277150701 | 100 | 293 | 545 | 604 | 1 | 2024-08-03 | 24.29 | 0.61 | 2024-07-22 | 1 | 17.98 | 1 | 24.29 | 4 | SO71925 | 2024-07-29 | 1.94 | 17.98 | 24.29 | |||
SO58991_1 | D7E6-4630-81 | PO16530115443 | 100 | 282 | 552 | 601 | 1 | 2024-02-02 | 109.79 | 2.74 | 2024-01-21 | 2 | 40.62 | 1 | 109.79 | 1 | SO58991 | 2024-01-28 | 8.78 | 81.24 | 54.89 | |||
SO46105_30 | 2590-40A7-BB | PO8816169858 | 100 | 289 | 328 | 218 | 1 | 2022-07-03 | 1258.38 | 31.46 | 2022-06-21 | 3 | 413.15 | 1 | 1258.38 | 30 | SO46105 | 2022-06-28 | 100.67 | 1239.44 | 419.46 | |||
SO71836_33 | E41E-40C1-84 | PO841118259 | 100 | 286 | 591 | 16 | 254 | 1 | 135.60 | 2024-08-03 | 338.99 | 5.08 | 2024-07-22 | 3 | 308.22 | 1 | 203.40 | 33 | SO71836 | 2024-07-29 | 16.27 | 924.65 | 113.00 | 0.40 |
SO47057_10 | 0D4D-45B2-91 | PO7917141916 | 100 | 287 | 354 | 401 | 1 | 2022-10-03 | 2485.70 | 62.14 | 2022-09-21 | 2 | 1117.86 | 1 | 2485.70 | 10 | SO47057 | 2022-09-28 | 198.86 | 2235.71 | 1242.85 | |||
SO45273_4 | E67F-4741-8D | PO18908136254 | 100 | 289 | 350 | 164 | 1 | 2022-04-05 | 12149.96 | 303.75 | 2022-03-24 | 6 | 1898.09 | 1 | 12149.96 | 4 | SO45273 | 2022-03-31 | 972.00 | 11388.57 | 2024.99 | |||
SO71833_6 | 8525-4645-AB | PO10411123072 | 100 | 289 | 560 | 182 | 1 | 2024-08-03 | 728.91 | 18.22 | 2024-07-22 | 1 | 755.15 | 1 | 728.91 | 6 | SO71833 | 2024-07-29 | 58.31 | 755.15 | 728.91 | |||
SO47992_18 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 410 | 487 | 1 | 2023-01-03 | 36.45 | 0.91 | 2022-12-22 | 1 | 26.97 | 1 | 36.45 | 18 | SO47992 | 2022-12-29 | 2.92 | 26.97 | 36.45 | |||
SO46611_20 | 93A4-4A4D-99 | PO16588117269 | 100 | 289 | 356 | 146 | 1 | 2022-09-02 | 7457.11 | 186.43 | 2022-08-21 | 6 | 1117.86 | 1 | 7457.11 | 20 | SO46611 | 2022-08-28 | 596.57 | 6707.14 | 1242.85 | |||
SO48328_15 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 470 | 293 | 1 | 2023-02-02 | 68.38 | 1.71 | 2023-01-21 | 3 | 15.67 | 1 | 68.38 | 15 | SO48328 | 2023-01-28 | 5.47 | 47.01 | 22.79 | |||
SO71941_2 | EF95-4DC0-B4 | PO8903143014 | 100 | 293 | 234 | 235 | 1 | 2024-08-03 | 29.99 | 0.75 | 2024-07-22 | 1 | 38.49 | 1 | 29.99 | 2 | SO71941 | 2024-07-29 | 2.40 | 38.49 | 29.99 | |||
SO50321_6 | 6B3D-47E0-99 | PO8816191637 | 100 | 289 | 271 | 218 | 1 | 2023-07-03 | 607.00 | 15.17 | 2023-06-21 | 3 | 187.16 | 1 | 607.00 | 6 | SO50321 | 2023-06-28 | 48.56 | 561.47 | 202.33 | |||
SO49503_5 | 1FD6-48BE-A1 | PO13543189827 | 100 | 287 | 428 | 293 | 1 | 2023-05-03 | 209.26 | 5.23 | 2023-04-21 | 1 | 185.82 | 1 | 209.26 | 5 | SO49503 | 2023-04-28 | 16.74 | 185.82 | 209.26 | |||
SO48383_4 | 2788-4429-AB | PO7395199388 | 100 | 286 | 412 | 542 | 1 | 2023-02-02 | 180.13 | 4.50 | 2023-01-21 | 1 | 133.30 | 1 | 180.13 | 4 | SO48383 | 2023-01-28 | 14.41 | 133.30 | 180.13 |
Generated 2024-09-20 03:40:18.705 UTC