[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 0 SHUFFLE < SKIP 1187 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71945_15 | 2AA4-4D12-9F | PO9396160769 | 6 | 296 | 499 | 267 | 9 | 2024-08-02 | 1204.69 | 30.12 | 2024-07-21 | 2 | 601.74 | 1 | 1204.69 | 15 | SO71945 | 2024-07-28 | 96.38 | 1203.49 | 602.35 | |||
SO47434_6 | 6848-4C33-98 | PO5539145068 | 100 | 282 | 401 | 61 | 4 | 2022-11-02 | 131.20 | 3.28 | 2022-10-21 | 2 | 48.55 | 1 | 131.20 | 6 | SO47434 | 2022-10-28 | 10.50 | 97.09 | 65.60 | |||
SO57080_29 | A38F-4C07-81 | PO957167312 | 98 | 288 | 592 | 376 | 10 | 2024-01-02 | 338.99 | 8.47 | 2023-12-21 | 1 | 308.22 | 1 | 338.99 | 29 | SO57080 | 2023-12-28 | 27.12 | 308.22 | 338.99 | |||
SO50748_5 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 286 | 3 | 4 | 2023-08-02 | 367.88 | 9.20 | 2023-07-21 | 2 | 170.14 | 1 | 367.88 | 5 | SO50748 | 2023-07-28 | 29.43 | 340.29 | 183.94 | |||
SO57055_19 | 3CBC-4CD2-B1 | PO13369127604 | 100 | 292 | 386 | 391 | 7 | 2024-01-02 | 3361.47 | 84.04 | 2023-12-21 | 5 | 713.08 | 1 | 3361.47 | 19 | SO57055 | 2023-12-28 | 268.92 | 3565.40 | 672.29 | |||
SO59028_38 | F0C6-4E08-A8 | PO4814117936 | 36 | 295 | 484 | 464 | 8 | 2024-02-01 | 28.62 | 0.72 | 2024-01-20 | 6 | 2.97 | 1 | 28.62 | 38 | SO59028 | 2024-01-27 | 2.29 | 17.84 | 4.77 | |||
SO44488_5 | 18BD-4C15-81 | PO19546136242 | 100 | 285 | 253 | 206 | 5 | 2022-01-02 | 178.58 | 4.46 | 2021-12-21 | 1 | 176.20 | 1 | 178.58 | 5 | SO44488 | 2021-12-28 | 14.29 | 176.20 | 178.58 | |||
SO49499_2 | E899-4E47-A2 | PO15341196181 | 100 | 281 | 360 | 327 | 3 | 2023-05-02 | 4917.84 | 122.95 | 2023-04-20 | 4 | 1105.81 | 1 | 4917.84 | 2 | SO49499 | 2023-04-27 | 393.43 | 4423.24 | 1229.46 | |||
SO46663_4 | 0EA2-42AA-A4 | PO6409112370 | 100 | 283 | 224 | 292 | 4 | 2022-09-01 | 25.93 | 0.65 | 2022-08-20 | 5 | 5.23 | 1 | 25.93 | 4 | SO46663 | 2022-08-27 | 2.07 | 26.15 | 5.19 | |||
SO53531_40 | B1FB-47B2-8E | PO2697181370 | 100 | 282 | 551 | 187 | 4 | 2023-11-02 | 633.72 | 15.84 | 2023-10-21 | 4 | 144.59 | 1 | 633.72 | 40 | SO53531 | 2023-10-28 | 50.70 | 578.38 | 158.43 | |||
SO67290_3 | 763C-4FCC-8E | PO10237115936 | 100 | 287 | 583 | 41 | 4 | 2024-06-02 | 3061.78 | 76.54 | 2024-05-21 | 3 | 1082.51 | 1 | 3061.78 | 3 | SO67290 | 2024-05-28 | 244.94 | 3247.53 | 1020.59 | |||
SO51088_4 | 4E58-4FFA-9F | PO17197140322 | 100 | 283 | 400 | 125 | 2 | 2023-09-01 | 74.30 | 1.86 | 2023-08-20 | 2 | 27.49 | 1 | 74.30 | 4 | SO51088 | 2023-08-27 | 5.94 | 54.99 | 37.15 | |||
SO48016_22 | 0FF6-4F4B-B4 | PO11745112366 | 100 | 282 | 456 | 97 | 4 | 2023-01-02 | 224.97 | 5.62 | 2022-12-21 | 5 | 30.93 | 1 | 224.97 | 22 | SO48016 | 2022-12-28 | 18.00 | 154.67 | 44.99 | |||
SO44306_1 | 464C-43BA-9F | PO1189114917 | 100 | 285 | 310 | 423 | 5 | 2021-12-02 | 4293.92 | 107.35 | 2021-11-20 | 2 | 2171.29 | 1 | 4293.92 | 1 | SO44306 | 2021-11-27 | 343.51 | 4342.59 | 2146.96 | |||
SO49890_3 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 224 | 221 | 4 | 2023-06-02 | 15.56 | 0.39 | 2023-05-21 | 3 | 5.23 | 1 | 15.56 | 3 | SO49890 | 2023-05-28 | 1.24 | 15.69 | 5.19 | |||
SO51147_45 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 440 | 81 | 5 | 2023-09-01 | 858.90 | 21.47 | 2023-08-20 | 1 | 868.63 | 1 | 858.90 | 45 | SO51147 | 2023-08-27 | 68.71 | 868.63 | 858.90 | |||
SO46969_30 | 3C39-4176-A8 | PO15370166954 | 100 | 283 | 397 | 381 | 3 | 2022-10-02 | 48.59 | 1.21 | 2022-09-20 | 2 | 17.98 | 1 | 48.59 | 30 | SO46969 | 2022-09-27 | 3.89 | 35.96 | 24.29 | |||
SO49880_2 | E43C-4D1F-9F | PO4350182387 | 100 | 281 | 233 | 274 | 3 | 2023-06-02 | 144.20 | 3.61 | 2023-05-21 | 5 | 29.08 | 1 | 144.20 | 2 | SO49880 | 2023-05-28 | 11.54 | 145.40 | 28.84 | |||
SO49058_16 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 254 | 78 | 4 | 2023-04-04 | 919.69 | 22.99 | 2023-03-23 | 5 | 170.14 | 1 | 919.69 | 16 | SO49058 | 2023-03-30 | 73.58 | 850.71 | 183.94 | |||
SO61177_21 | DA64-4BC0-A0 | PO18473117778 | 19 | 291 | 517 | 442 | 6 | 2024-03-03 | 31.58 | 0.79 | 2024-02-20 | 1 | 23.37 | 1 | 31.58 | 21 | SO61177 | 2024-02-27 | 2.53 | 23.37 | 31.58 | |||
SO46964_29 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 369 | 328 | 4 | 2022-10-02 | 4398.03 | 109.95 | 2022-09-20 | 3 | 1518.79 | 1 | 4398.03 | 29 | SO46964 | 2022-09-27 | 351.84 | 4556.36 | 1466.01 | |||
SO47377_5 | FA63-499A-AB | PO15515156459 | 100 | 292 | 422 | 481 | 7 | 2022-11-02 | 202.62 | 5.07 | 2022-10-21 | 3 | 49.98 | 1 | 202.62 | 5 | SO47377 | 2022-10-28 | 16.21 | 149.94 | 67.54 | |||
SO48071_15 | E6F7-41F8-92 | PO6525193011 | 100 | 283 | 360 | 345 | 4 | 2023-01-02 | 6147.29 | 153.68 | 2022-12-21 | 5 | 1105.81 | 1 | 6147.29 | 15 | SO48071 | 2022-12-28 | 491.78 | 5529.05 | 1229.46 | |||
SO51157_28 | 927E-4DB1-A3 | PO3828155781 | 100 | 283 | 595 | 414 | 2 | 2023-09-01 | 1016.98 | 25.42 | 2023-08-20 | 3 | 308.22 | 1 | 1016.98 | 28 | SO51157 | 2023-08-27 | 81.36 | 924.65 | 338.99 | |||
SO65241_11 | 1B2B-492F-A9 | PO9396172185 | 6 | 296 | 567 | 267 | 9 | 2024-05-02 | 445.41 | 11.14 | 2024-04-20 | 1 | 461.44 | 1 | 445.41 | 11 | SO65241 | 2024-04-27 | 35.63 | 461.44 | 445.41 | |||
SO55249_13 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 491 | 2 | 475 | 4 | 8.77 | 2023-12-02 | 438.40 | 10.74 | 2023-11-20 | 14 | 41.57 | 1 | 429.63 | 13 | SO55249 | 2023-11-27 | 34.37 | 582.01 | 31.31 | 0.02 |
SO44517_25 | 47C8-4635-A6 | PO13572181174 | 100 | 287 | 342 | 527 | 3 | 2022-01-02 | 838.92 | 20.97 | 2021-12-21 | 2 | 413.15 | 1 | 838.92 | 25 | SO44517 | 2021-12-28 | 67.11 | 826.29 | 419.46 | |||
SO44544_8 | E01E-42FD-93 | PO3799116414 | 100 | 282 | 351 | 312 | 4 | 2022-01-02 | 4049.99 | 101.25 | 2021-12-21 | 2 | 1898.09 | 1 | 4049.99 | 8 | SO44544 | 2021-12-28 | 324.00 | 3796.19 | 2024.99 | |||
SO67278_38 | 22C9-42E1-BC | PO12441152483 | 36 | 295 | 484 | 302 | 8 | 2024-06-02 | 23.85 | 0.60 | 2024-05-21 | 5 | 2.97 | 1 | 23.85 | 38 | SO67278 | 2024-05-28 | 1.91 | 14.87 | 4.77 | |||
SO50224_7 | 729B-4859-AB | PO12731112971 | 36 | 292 | 470 | 247 | 7 | 2023-07-02 | 68.38 | 1.71 | 2023-06-20 | 3 | 15.67 | 1 | 68.38 | 7 | SO50224 | 2023-06-27 | 5.47 | 47.01 | 22.79 |
Generated 2024-09-19 23:17:13.114 UTC