[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 0 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55241_33 | F7DC-49D7-89 | PO16588188882 | 100 | 289 | 587 | 146 | 1 | 2023-09-20 | 4155.25 | 103.88 | 2023-09-08 | 9 | 419.78 | 1 | 4155.25 | 33 | SO55241 | 2023-09-15 | 332.42 | 3778.01 | 461.69 | |||
SO67294_9 | 85E2-46A1-BE | PO899165491 | 100 | 289 | 546 | 290 | 1 | 2024-03-21 | 37.25 | 0.93 | 2024-03-09 | 1 | 27.57 | 1 | 37.25 | 9 | SO67294 | 2024-03-16 | 2.98 | 27.57 | 37.25 | |||
SO53452_23 | B555-4FD7-8B | PO870113712 | 100 | 286 | 555 | 621 | 1 | 2023-08-21 | 511.20 | 12.78 | 2023-08-09 | 8 | 47.29 | 1 | 511.20 | 23 | SO53452 | 2023-08-16 | 40.90 | 378.29 | 63.90 | |||
SO57030_42 | 373C-4C0F-88 | PO16414180321 | 100 | 289 | 511 | 236 | 1 | 2023-10-21 | 873.82 | 21.85 | 2023-10-09 | 4 | 199.38 | 1 | 873.82 | 42 | SO57030 | 2023-10-16 | 69.91 | 797.50 | 218.45 | |||
SO59010_32 | 2350-42CD-B1 | PO6815132533 | 100 | 293 | 476 | 3 | 109 | 1 | 36.57 | 2023-11-20 | 731.40 | 17.37 | 2023-11-08 | 19 | 26.18 | 1 | 694.83 | 32 | SO59010 | 2023-11-15 | 55.59 | 497.35 | 38.49 | 0.05 |
SO53613_19 | 4A10-4F98-84 | PO6815195063 | 100 | 293 | 589 | 109 | 1 | 2023-08-21 | 1846.78 | 46.17 | 2023-08-09 | 4 | 419.78 | 1 | 1846.78 | 19 | SO53613 | 2023-08-16 | 147.74 | 1679.11 | 461.69 | |||
SO47066_34 | 5E42-48DE-80 | PO8816154123 | 100 | 289 | 377 | 218 | 1 | 2022-07-21 | 3926.81 | 98.17 | 2022-07-09 | 3 | 1320.68 | 1 | 3926.81 | 34 | SO47066 | 2022-07-16 | 314.15 | 3962.05 | 1308.94 | |||
SO47403_39 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 447 | 254 | 1 | 2022-08-21 | 30.00 | 0.75 | 2022-08-09 | 2 | 10.31 | 1 | 30.00 | 39 | SO47403 | 2022-08-16 | 2.40 | 20.63 | 15.00 | |||
SO46105_15 | 2590-40A7-BB | PO8816169858 | 100 | 289 | 317 | 218 | 1 | 2022-04-20 | 3499.18 | 87.48 | 2022-04-08 | 4 | 884.71 | 1 | 3499.18 | 15 | SO46105 | 2022-04-15 | 279.93 | 3538.83 | 874.79 | |||
SO53623_6 | 7BBF-43AA-B5 | PO8903169981 | 100 | 293 | 287 | 235 | 1 | 2023-08-21 | 607.00 | 15.17 | 2023-08-09 | 3 | 204.63 | 1 | 607.00 | 6 | SO53623 | 2023-08-16 | 48.56 | 613.88 | 202.33 | |||
SO51712_44 | 910D-4560-A7 | PO16675134576 | 100 | 293 | 477 | 361 | 1 | 2023-07-21 | 17.96 | 0.45 | 2023-07-09 | 6 | 1.87 | 1 | 17.96 | 44 | SO51712 | 2023-07-16 | 1.44 | 11.20 | 2.99 | |||
SO45303_1 | 72FC-4DAD-BA | PO11919121030 | 100 | 286 | 345 | 73 | 1 | 2022-01-21 | 4079.99 | 102.00 | 2022-01-09 | 2 | 1912.15 | 1 | 4079.99 | 1 | SO45303 | 2022-01-16 | 326.40 | 3824.31 | 2039.99 | |||
SO48310_4 | B389-4D7D-85 | PO17139173607 | 100 | 293 | 333 | 644 | 1 | 2022-11-20 | 939.59 | 23.49 | 2022-11-08 | 2 | 486.71 | 1 | 939.59 | 4 | SO48310 | 2022-11-15 | 75.17 | 973.41 | 469.79 | |||
SO51721_35 | 9429-430D-89 | PO14500124798 | 100 | 282 | 513 | 650 | 1 | 2023-07-21 | 655.36 | 16.38 | 2023-07-09 | 3 | 199.38 | 1 | 655.36 | 35 | SO51721 | 2023-07-16 | 52.43 | 598.13 | 218.45 | |||
SO46966_1 | 8FBD-4E87-82 | PO15631150454 | 100 | 282 | 221 | 43 | 1 | 2022-07-21 | 20.19 | 0.50 | 2022-07-09 | 1 | 13.88 | 1 | 20.19 | 1 | SO46966 | 2022-07-16 | 1.61 | 13.88 | 20.19 | |||
SO43895_15 | 5233-4CB8-BC | PO2900121738 | 100 | 286 | 215 | 469 | 1 | 2021-07-21 | 60.56 | 1.51 | 2021-07-09 | 3 | 12.03 | 1 | 60.56 | 15 | SO43895 | 2021-07-16 | 4.84 | 36.08 | 20.19 | |||
SO57151_1 | 017C-41CB-BB | PO5162182690 | 100 | 289 | 281 | 669 | 1 | 2023-10-21 | 202.33 | 5.06 | 2023-10-09 | 1 | 204.63 | 1 | 202.33 | 1 | SO57151 | 2023-10-16 | 16.19 | 204.63 | 202.33 | |||
SO47999_30 | DF06-4F6A-9D | PO14500121568 | 100 | 282 | 470 | 650 | 1 | 2022-10-21 | 113.97 | 2.85 | 2022-10-09 | 5 | 15.67 | 1 | 113.97 | 30 | SO47999 | 2022-10-16 | 9.12 | 78.35 | 22.79 | |||
SO69413_23 | E8F8-4282-9E | PO15631191114 | 100 | 282 | 593 | 16 | 43 | 1 | 90.40 | 2024-04-20 | 226.00 | 3.39 | 2024-04-08 | 2 | 308.22 | 1 | 135.60 | 23 | SO69413 | 2024-04-15 | 10.85 | 616.44 | 113.00 | 0.40 |
SO47992_35 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 462 | 487 | 1 | 2022-10-21 | 14.13 | 0.35 | 2022-10-09 | 1 | 9.71 | 1 | 14.13 | 35 | SO47992 | 2022-10-16 | 1.13 | 9.71 | 14.13 | |||
SO50218_25 | B8E9-4FE2-8B | PO14442144367 | 100 | 293 | 230 | 127 | 1 | 2023-04-20 | 144.20 | 3.61 | 2023-04-08 | 5 | 29.08 | 1 | 144.20 | 25 | SO50218 | 2023-04-15 | 11.54 | 145.40 | 28.84 | |||
SO53518_28 | 5712-444B-BC | PO841197199 | 100 | 286 | 597 | 254 | 1 | 2023-08-21 | 1619.97 | 40.50 | 2023-08-09 | 5 | 294.58 | 1 | 1619.97 | 28 | SO53518 | 2023-08-16 | 129.60 | 1472.90 | 323.99 | |||
SO57109_4 | C4FF-4694-96 | PO14529190471 | 100 | 293 | 474 | 289 | 1 | 2023-10-21 | 125.98 | 3.15 | 2023-10-09 | 3 | 26.18 | 1 | 125.98 | 4 | SO57109 | 2023-10-16 | 10.08 | 78.53 | 41.99 | |||
SO49464_12 | C383-45FE-83 | PO841195010 | 100 | 286 | 308 | 254 | 1 | 2023-02-18 | 2232.82 | 55.82 | 2023-02-06 | 3 | 660.91 | 1 | 2232.82 | 12 | SO49464 | 2023-02-13 | 178.63 | 1982.74 | 744.27 | |||
SO58961_9 | 0848-4E9B-81 | PO10411162031 | 100 | 289 | 573 | 182 | 1 | 2023-11-20 | 4291.33 | 107.28 | 2023-11-08 | 3 | 1481.94 | 1 | 4291.33 | 9 | SO58961 | 2023-11-15 | 343.31 | 4445.81 | 1430.44 | |||
SO49092_30 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 224 | 127 | 1 | 2023-01-21 | 46.68 | 1.17 | 2023-01-09 | 9 | 5.23 | 1 | 46.68 | 30 | SO49092 | 2023-01-16 | 3.73 | 47.07 | 5.19 | |||
SO69413_6 | E8F8-4282-9E | PO15631191114 | 100 | 282 | 476 | 2 | 43 | 1 | 9.74 | 2024-04-20 | 487.13 | 11.93 | 2024-04-08 | 12 | 26.18 | 1 | 477.39 | 6 | SO69413 | 2024-04-15 | 38.19 | 314.12 | 40.59 | 0.02 |
SO47368_18 | 7A90-4975-A2 | PO17487188099 | 100 | 286 | 286 | 692 | 1 | 2022-08-21 | 735.75 | 18.39 | 2022-08-09 | 4 | 170.14 | 1 | 735.75 | 18 | SO47368 | 2022-08-16 | 58.86 | 680.57 | 183.94 | |||
SO58940_17 | 72B7-4C82-8A | PO13543115032 | 100 | 287 | 531 | 293 | 1 | 2023-11-20 | 299.75 | 7.49 | 2023-11-08 | 2 | 136.79 | 1 | 299.75 | 17 | SO58940 | 2023-11-15 | 23.98 | 273.57 | 149.87 | |||
SO57105_1 | 3AE1-4A72-91 | PO18676113963 | 100 | 282 | 590 | 697 | 1 | 2023-10-21 | 3693.55 | 92.34 | 2023-10-09 | 8 | 419.78 | 1 | 3693.55 | 1 | SO57105 | 2023-10-16 | 295.48 | 3358.23 | 461.69 | |||
SO44285_6 | 33BA-457C-B7 | PO16617120120 | 100 | 286 | 351 | 397 | 1 | 2021-09-20 | 4049.99 | 101.25 | 2021-09-08 | 2 | 1898.09 | 1 | 4049.99 | 6 | SO44285 | 2021-09-15 | 324.00 | 3796.19 | 2024.99 |
Generated 2024-07-08 14:29:59.705 UTC