[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SKIP 0 SHUFFLE < SKIP 1051 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57026_12 | CD5A-4300-81 | PO16675118038 | 100 | 293 | 499 | 361 | 1 | 2024-01-04 | 1807.04 | 45.18 | 2023-12-23 | 3 | 601.74 | 1 | 1807.04 | 12 | SO57026 | 2023-12-30 | 144.56 | 1805.23 | 602.35 | |||
SO45342_1 | 9E99-4922-A4 | PO7917111421 | 100 | 287 | 350 | 401 | 1 | 2022-04-06 | 8099.98 | 202.50 | 2022-03-25 | 4 | 1898.09 | 1 | 8099.98 | 1 | SO45342 | 2022-04-01 | 648.00 | 7592.38 | 2024.99 | |||
SO44121_1 | FE2E-4885-B3 | PO5220129819 | 100 | 282 | 293 | 169 | 1 | 2021-11-04 | 722.59 | 18.06 | 2021-10-23 | 1 | 623.84 | 1 | 722.59 | 1 | SO44121 | 2021-10-30 | 57.81 | 623.84 | 722.59 | |||
SO53514_58 | 8580-40F8-81 | PO10411179199 | 100 | 289 | 563 | 14 | 182 | 1 | 381.45 | 2023-11-04 | 1907.26 | 38.15 | 2023-10-23 | 2 | 1481.94 | 1 | 1525.80 | 58 | SO53514 | 2023-10-30 | 122.06 | 2963.88 | 953.63 | 0.20 |
SO45283_5 | 07F7-44C2-BA | PO16646111452 | 100 | 286 | 328 | 1 | 1 | 2022-04-06 | 1677.84 | 41.95 | 2022-03-25 | 4 | 413.15 | 1 | 1677.84 | 5 | SO45283 | 2022-04-01 | 134.23 | 1652.59 | 419.46 | |||
SO53623_17 | 7BBF-43AA-B5 | PO8903169981 | 100 | 293 | 231 | 235 | 1 | 2023-11-04 | 59.99 | 1.50 | 2023-10-23 | 2 | 38.49 | 1 | 59.99 | 17 | SO53623 | 2023-10-30 | 4.80 | 76.98 | 29.99 | |||
SO58962_25 | 12B1-4451-9A | PO870180310 | 100 | 286 | 578 | 621 | 1 | 2024-02-03 | 3644.55 | 91.11 | 2024-01-22 | 5 | 755.15 | 1 | 3644.55 | 25 | SO58962 | 2024-01-29 | 291.56 | 3775.75 | 728.91 | |||
SO53493_22 | F767-491F-84 | PO13543118174 | 100 | 287 | 525 | 293 | 1 | 2023-11-04 | 158.43 | 3.96 | 2023-10-23 | 1 | 144.59 | 1 | 158.43 | 22 | SO53493 | 2023-10-30 | 12.67 | 144.59 | 158.43 | |||
SO69508_32 | 387A-4EC2-A7 | PO7627176234 | 100 | 293 | 386 | 433 | 1 | 2024-07-04 | 4033.76 | 100.84 | 2024-06-22 | 6 | 713.08 | 1 | 4033.76 | 32 | SO69508 | 2024-06-29 | 322.70 | 4278.48 | 672.29 | |||
SO71812_20 | 3257-4AE0-A8 | PO13543115747 | 100 | 287 | 400 | 293 | 1 | 2024-08-04 | 111.46 | 2.79 | 2024-07-23 | 3 | 27.49 | 1 | 111.46 | 20 | SO71812 | 2024-07-30 | 8.92 | 82.48 | 37.15 | |||
SO57176_1 | 6881-42A1-B6 | PO7917176909 | 100 | 287 | 491 | 401 | 1 | 2024-01-04 | 161.97 | 4.05 | 2023-12-23 | 5 | 41.57 | 1 | 161.97 | 1 | SO57176 | 2023-12-30 | 12.96 | 207.86 | 32.39 | |||
SO51826_11 | DBF7-4FCA-86 | PO6148188136 | 100 | 289 | 553 | 693 | 1 | 2023-10-04 | 27.65 | 0.69 | 2023-09-22 | 1 | 20.46 | 1 | 27.65 | 11 | SO51826 | 2023-09-29 | 2.21 | 20.46 | 27.65 | |||
SO50270_23 | A828-45A2-8B | PO18676112371 | 100 | 282 | 469 | 3 | 697 | 1 | 24.03 | 2023-07-04 | 480.57 | 11.41 | 2023-06-22 | 23 | 15.67 | 1 | 456.54 | 23 | SO50270 | 2023-06-29 | 36.52 | 360.43 | 20.89 | 0.05 |
SO47033_44 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 417 | 343 | 1 | 2022-10-04 | 1946.72 | 48.67 | 2022-09-22 | 6 | 300.12 | 1 | 1946.72 | 44 | SO47033 | 2022-09-29 | 155.74 | 1800.71 | 324.45 | |||
SO49105_21 | B762-4BA5-A0 | PO14500175804 | 100 | 282 | 308 | 650 | 1 | 2023-04-06 | 2977.09 | 74.43 | 2023-03-25 | 4 | 660.91 | 1 | 2977.09 | 21 | SO49105 | 2023-04-01 | 238.17 | 2643.66 | 744.27 | |||
SO47992_29 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 445 | 487 | 1 | 2023-01-04 | 107.98 | 2.70 | 2022-12-23 | 3 | 24.75 | 1 | 107.98 | 29 | SO47992 | 2022-12-30 | 8.64 | 74.24 | 35.99 | |||
SO63149_14 | 7EF2-4565-86 | PO16414166653 | 100 | 289 | 511 | 236 | 1 | 2024-04-05 | 655.36 | 16.38 | 2024-03-24 | 3 | 199.38 | 1 | 655.36 | 14 | SO63149 | 2024-03-31 | 52.43 | 598.13 | 218.45 | |||
SO47387_20 | 4FFC-4663-AC | PO13543169662 | 100 | 287 | 397 | 293 | 1 | 2022-11-04 | 97.18 | 2.43 | 2022-10-23 | 4 | 17.98 | 1 | 97.18 | 20 | SO47387 | 2022-10-30 | 7.77 | 71.91 | 24.29 | |||
SO47387_24 | 4FFC-4663-AC | PO13543169662 | 100 | 287 | 468 | 293 | 1 | 2022-11-04 | 45.59 | 1.14 | 2022-10-23 | 2 | 15.67 | 1 | 45.59 | 24 | SO47387 | 2022-10-30 | 3.65 | 31.34 | 22.79 | |||
SO48057_19 | 53D7-4BA4-AB | PO4727174880 | 100 | 293 | 460 | 343 | 1 | 2023-01-04 | 269.97 | 6.75 | 2022-12-23 | 5 | 37.12 | 1 | 269.97 | 19 | SO48057 | 2022-12-30 | 21.60 | 185.60 | 53.99 | |||
SO48057_34 | 53D7-4BA4-AB | PO4727174880 | 100 | 293 | 335 | 343 | 1 | 2023-01-04 | 939.59 | 23.49 | 2022-12-23 | 2 | 486.71 | 1 | 939.59 | 34 | SO48057 | 2022-12-30 | 75.17 | 973.41 | 469.79 | |||
SO58916_3 | E928-4943-BC | PO17139180025 | 100 | 293 | 376 | 644 | 1 | 2024-02-03 | 1466.01 | 36.65 | 2024-01-22 | 1 | 1554.95 | 1 | 1466.01 | 3 | SO58916 | 2024-01-29 | 117.28 | 1554.95 | 1466.01 | |||
SO47066_30 | 5E42-48DE-80 | PO8816154123 | 100 | 289 | 381 | 218 | 1 | 2022-10-04 | 1200.53 | 30.01 | 2022-09-22 | 2 | 605.65 | 1 | 1200.53 | 30 | SO47066 | 2022-09-29 | 96.04 | 1211.30 | 600.26 | |||
SO46030_1 | 8D5D-4CBC-8F | PO18908181698 | 100 | 289 | 346 | 164 | 1 | 2022-07-04 | 4079.99 | 102.00 | 2022-06-22 | 2 | 1912.15 | 1 | 4079.99 | 1 | SO46030 | 2022-06-29 | 326.40 | 3824.31 | 2039.99 | |||
SO44762_16 | 553E-437E-92 | PO13543176259 | 100 | 287 | 232 | 293 | 1 | 2022-02-03 | 86.52 | 2.16 | 2022-01-22 | 3 | 31.72 | 1 | 86.52 | 16 | SO44762 | 2022-01-29 | 6.92 | 95.17 | 28.84 | |||
SO46356_19 | 30BA-40DA-B4 | PO783139385 | 100 | 286 | 340 | 91 | 1 | 2022-08-04 | 838.92 | 20.97 | 2022-07-23 | 2 | 413.15 | 1 | 838.92 | 19 | SO46356 | 2022-07-30 | 67.11 | 826.29 | 419.46 | |||
SO53623_12 | 7BBF-43AA-B5 | PO8903169981 | 100 | 293 | 491 | 235 | 1 | 2023-11-04 | 129.58 | 3.24 | 2023-10-23 | 4 | 41.57 | 1 | 129.58 | 12 | SO53623 | 2023-10-30 | 10.37 | 166.29 | 32.39 | |||
SO71818_1 | 2FCA-4131-BD | PO12470139718 | 100 | 287 | 499 | 672 | 1 | 2024-08-04 | 4818.77 | 120.47 | 2024-07-23 | 8 | 601.74 | 1 | 4818.77 | 1 | SO71818 | 2024-07-30 | 385.50 | 4813.95 | 602.35 | |||
SO51830_39 | EBE1-4015-AE | PO7627127132 | 100 | 272 | 583 | 433 | 1 | 2023-10-04 | 3061.78 | 76.54 | 2023-09-22 | 3 | 1082.51 | 1 | 3061.78 | 39 | SO51830 | 2023-09-29 | 244.94 | 3247.53 | 1020.59 | |||
SO51726_18 | 9BC5-4281-AF | PO14587157005 | 100 | 293 | 507 | 199 | 1 | 2023-10-04 | 600.16 | 15.00 | 2023-09-22 | 3 | 199.85 | 1 | 600.16 | 18 | SO51726 | 2023-09-29 | 48.01 | 599.56 | 200.05 |
Generated 2024-09-21 09:40:52.000 UTC