[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2626 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47400_6 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 213 | 133 | 4 | 2022-12-24 | 201.87 | 5.05 | 2022-12-12 | 10 | 13.88 | 1 | 201.87 | 6 | SO47400 | 2022-12-19 | 16.15 | 138.78 | 20.19 | |||
SO67273_4 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 601 | 475 | 4 | 2024-07-24 | 97.18 | 2.43 | 2024-07-12 | 3 | 23.97 | 1 | 97.18 | 4 | SO67273 | 2024-07-19 | 7.77 | 71.91 | 32.39 | |||
SO47437_1 | 96F0-4452-AA | PO5974115616 | 100 | 282 | 424 | 330 | 4 | 2022-12-24 | 214.24 | 5.36 | 2022-12-12 | 1 | 158.53 | 1 | 214.24 | 1 | SO47437 | 2022-12-19 | 17.14 | 158.53 | 214.24 | |||
SO69545_38 | 2C06-44D9-96 | PO3480123333 | 100 | 272 | 584 | 436 | 4 | 2024-08-23 | 971.98 | 24.30 | 2024-08-11 | 3 | 343.65 | 1 | 971.98 | 38 | SO69545 | 2024-08-18 | 77.76 | 1030.95 | 323.99 | |||
SO49540_6 | FD60-4F29-B7 | PO6757123714 | 100 | 281 | 365 | 21 | 4 | 2023-06-23 | 647.99 | 16.20 | 2023-06-11 | 1 | 598.44 | 1 | 647.99 | 6 | SO49540 | 2023-06-18 | 51.84 | 598.44 | 647.99 | |||
SO50663_52 | 286E-4915-89 | PO19343130555 | 100 | 282 | 230 | 2 | 24 | 4 | 6.13 | 2023-09-23 | 306.67 | 7.51 | 2023-09-11 | 11 | 29.08 | 1 | 300.54 | 52 | SO50663 | 2023-09-18 | 24.04 | 319.89 | 27.88 | 0.02 |
SO61236_1 | 1CCD-453C-A4 | PO10237145027 | 100 | 287 | 471 | 41 | 4 | 2024-04-24 | 76.20 | 1.91 | 2024-04-12 | 2 | 23.75 | 1 | 76.20 | 1 | SO61236 | 2024-04-19 | 6.10 | 47.50 | 38.10 | |||
SO43906_11 | BA78-4228-89 | PO6438197212 | 100 | 283 | 349 | 309 | 4 | 2021-11-23 | 6074.98 | 151.87 | 2021-11-11 | 3 | 1898.09 | 1 | 6074.98 | 11 | SO43906 | 2021-11-18 | 486.00 | 5694.28 | 2024.99 | |||
SO48071_14 | E6F7-41F8-92 | PO6525193011 | 100 | 283 | 297 | 345 | 4 | 2023-02-23 | 1472.29 | 36.81 | 2023-02-11 | 2 | 653.70 | 1 | 1472.29 | 14 | SO48071 | 2023-02-18 | 117.78 | 1307.39 | 736.15 | |||
SO46380_21 | C4E3-4894-81 | PO7569183330 | 100 | 287 | 304 | 608 | 4 | 2022-09-23 | 2144.11 | 53.60 | 2022-09-11 | 3 | 617.03 | 1 | 2144.11 | 21 | SO46380 | 2022-09-18 | 171.53 | 1851.08 | 714.70 | |||
SO44314_14 | 6FDF-4206-A7 | PO5626111923 | 100 | 283 | 336 | 166 | 4 | 2022-01-23 | 838.92 | 20.97 | 2022-01-11 | 2 | 413.15 | 1 | 838.92 | 14 | SO44314 | 2022-01-18 | 67.11 | 826.29 | 419.46 | |||
SO48740_10 | 158B-4BBF-9F | PO551143768 | 100 | 281 | 321 | 4 | 4 | 2023-04-25 | 3758.35 | 93.96 | 2023-04-13 | 8 | 486.71 | 1 | 3758.35 | 10 | SO48740 | 2023-04-20 | 300.67 | 3893.65 | 469.79 | |||
SO43913_3 | AD88-49ED-90 | PO7830112696 | 100 | 283 | 232 | 40 | 4 | 2021-11-23 | 28.84 | 0.72 | 2021-11-11 | 1 | 31.72 | 1 | 28.84 | 3 | SO43913 | 2021-11-18 | 2.31 | 31.72 | 28.84 | |||
SO48066_22 | F00E-4B06-9D | PO5684167807 | 100 | 282 | 366 | 385 | 4 | 2023-02-23 | 2591.98 | 64.80 | 2023-02-11 | 4 | 598.44 | 1 | 2591.98 | 22 | SO48066 | 2023-02-18 | 207.36 | 2393.74 | 647.99 | |||
SO57085_29 | D1E5-454C-85 | PO2523188219 | 100 | 287 | 380 | 167 | 4 | 2024-02-23 | 2932.02 | 73.30 | 2024-02-11 | 2 | 1554.95 | 1 | 2932.02 | 29 | SO57085 | 2024-02-18 | 234.56 | 3109.90 | 1466.01 | |||
SO69545_9 | 2C06-44D9-96 | PO3480123333 | 100 | 272 | 465 | 436 | 4 | 2024-08-23 | 73.47 | 1.84 | 2024-08-11 | 5 | 9.16 | 1 | 73.47 | 9 | SO69545 | 2024-08-18 | 5.88 | 45.80 | 14.69 | |||
SO47400_19 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 412 | 133 | 4 | 2022-12-24 | 540.39 | 13.51 | 2022-12-12 | 3 | 133.30 | 1 | 540.39 | 19 | SO47400 | 2022-12-19 | 43.23 | 399.89 | 180.13 | |||
SO50753_26 | 8073-4F97-BA | PO7569170218 | 100 | 287 | 305 | 608 | 4 | 2023-09-23 | 3680.73 | 92.02 | 2023-09-11 | 5 | 653.70 | 1 | 3680.73 | 26 | SO50753 | 2023-09-18 | 294.46 | 3268.49 | 736.15 | |||
SO65209_4 | B869-4DFD-AB | PO2697179473 | 100 | 282 | 353 | 187 | 4 | 2024-06-23 | 1391.99 | 34.80 | 2024-06-11 | 1 | 1265.62 | 1 | 1391.99 | 4 | SO65209 | 2024-06-18 | 111.36 | 1265.62 | 1391.99 | |||
SO55256_28 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 572 | 331 | 4 | 2024-01-23 | 445.41 | 11.14 | 2024-01-11 | 1 | 461.44 | 1 | 445.41 | 28 | SO55256 | 2024-01-18 | 35.63 | 461.44 | 445.41 | |||
SO48052_9 | FBD0-4407-84 | PO3654150499 | 100 | 283 | 470 | 435 | 4 | 2023-02-23 | 113.97 | 2.85 | 2023-02-11 | 5 | 15.67 | 1 | 113.97 | 9 | SO48052 | 2023-02-18 | 9.12 | 78.35 | 22.79 | |||
SO57085_32 | D1E5-454C-85 | PO2523188219 | 100 | 287 | 376 | 167 | 4 | 2024-02-23 | 1466.01 | 36.65 | 2024-02-11 | 1 | 1554.95 | 1 | 1466.01 | 32 | SO57085 | 2024-02-18 | 117.28 | 1554.95 | 1466.01 | |||
SO71890_2 | D31D-413E-BB | PO5510169156 | 100 | 287 | 547 | 5 | 4 | 2024-09-23 | 48.59 | 1.21 | 2024-09-11 | 1 | 35.96 | 1 | 48.59 | 2 | SO71890 | 2024-09-18 | 3.89 | 35.96 | 48.59 | |||
SO57144_21 | 074E-478C-99 | PO3799111077 | 100 | 282 | 472 | 312 | 4 | 2024-02-23 | 190.50 | 4.76 | 2024-02-11 | 5 | 23.75 | 1 | 190.50 | 21 | SO57144 | 2024-02-18 | 15.24 | 118.75 | 38.10 | |||
SO55264_20 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 606 | 491 | 4 | 2024-01-23 | 971.98 | 24.30 | 2024-01-11 | 3 | 343.65 | 1 | 971.98 | 20 | SO55264 | 2024-01-18 | 77.76 | 1030.95 | 323.99 | |||
SO47355_44 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 381 | 24 | 4 | 2022-12-24 | 4802.10 | 120.05 | 2022-12-12 | 8 | 605.65 | 1 | 4802.10 | 44 | SO47355 | 2022-12-19 | 384.17 | 4845.19 | 600.26 | |||
SO49127_23 | 01A1-43AB-A2 | PO3480145572 | 100 | 272 | 375 | 436 | 4 | 2023-05-26 | 1308.94 | 32.72 | 2023-05-14 | 1 | 1320.68 | 1 | 1308.94 | 23 | SO49127 | 2023-05-21 | 104.72 | 1320.68 | 1308.94 | |||
SO47438_21 | 69E0-4082-B4 | PO6757114691 | 100 | 283 | 394 | 21 | 4 | 2022-12-24 | 61.56 | 1.54 | 2022-12-12 | 3 | 15.18 | 1 | 61.56 | 21 | SO47438 | 2022-12-19 | 4.92 | 45.55 | 20.52 | |||
SO47018_43 | E622-43B1-98 | PO2523197473 | 100 | 287 | 221 | 167 | 4 | 2022-11-23 | 121.12 | 3.03 | 2022-11-11 | 6 | 13.88 | 1 | 121.12 | 43 | SO47018 | 2022-11-18 | 9.69 | 83.27 | 20.19 | |||
SO50292_19 | E329-4164-85 | PO3654177485 | 100 | 281 | 364 | 435 | 4 | 2023-08-23 | 1295.99 | 32.40 | 2023-08-11 | 2 | 598.44 | 1 | 1295.99 | 19 | SO50292 | 2023-08-18 | 103.68 | 1196.87 | 647.99 | |||
SO71782_40 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 472 | 582 | 4 | 2024-09-23 | 152.40 | 3.81 | 2024-09-11 | 4 | 23.75 | 1 | 152.40 | 40 | SO71782 | 2024-09-18 | 12.19 | 95.00 | 38.10 |
Generated 2024-11-10 09:32:25.678 UTC