[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SKIP 0 SHUFFLE < SKIP 1219 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46969_7 | 3C39-4176-A8 | PO15370166954 | 100 | 283 | 366 | 381 | 3 | 2022-10-03 | 1943.98 | 48.60 | 2022-09-21 | 3 | 598.44 | 1 | 1943.98 | 7 | SO46969 | 2022-09-28 | 155.52 | 1795.31 | 647.99 | |||
SO50696_8 | C32F-4FEE-A3 | PO1624119214 | 100 | 281 | 435 | 579 | 3 | 2023-08-03 | 1297.81 | 32.45 | 2023-07-22 | 4 | 300.12 | 1 | 1297.81 | 8 | SO50696 | 2023-07-29 | 103.82 | 1200.48 | 324.45 | |||
SO63286_1 | C23C-4412-B2 | PO4205130185 | 100 | 283 | 595 | 323 | 3 | 2024-04-04 | 338.99 | 8.47 | 2024-03-23 | 1 | 308.22 | 1 | 338.99 | 1 | SO63286 | 2024-03-30 | 27.12 | 308.22 | 338.99 | |||
SO47409_7 | FC23-4384-86 | PO1624119173 | 100 | 283 | 414 | 579 | 3 | 2022-11-03 | 149.03 | 3.73 | 2022-10-22 | 1 | 110.28 | 1 | 149.03 | 7 | SO47409 | 2022-10-29 | 11.92 | 110.28 | 149.03 | |||
SO46325_6 | D29B-490E-A9 | PO19488134185 | 100 | 283 | 229 | 57 | 3 | 2022-08-03 | 86.52 | 2.16 | 2022-07-22 | 3 | 31.72 | 1 | 86.52 | 6 | SO46325 | 2022-07-29 | 6.92 | 95.17 | 28.84 | |||
SO55324_34 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 287 | 523 | 3 | 2023-12-03 | 202.33 | 5.06 | 2023-11-21 | 1 | 204.63 | 1 | 202.33 | 34 | SO55324 | 2023-11-28 | 16.19 | 204.63 | 202.33 | |||
SO55302_7 | 676A-47A8-A0 | PO6235189147 | 100 | 283 | 545 | 431 | 3 | 2023-12-03 | 72.88 | 1.82 | 2023-11-21 | 3 | 17.98 | 1 | 72.88 | 7 | SO55302 | 2023-11-28 | 5.83 | 53.93 | 24.29 | |||
SO43899_13 | 79F2-434F-97 | PO5191115657 | 100 | 283 | 315 | 364 | 3 | 2021-10-03 | 1749.59 | 43.74 | 2021-09-21 | 2 | 884.71 | 1 | 1749.59 | 13 | SO43899 | 2021-09-28 | 139.97 | 1769.42 | 874.79 | |||
SO50221_4 | EAD6-4841-B9 | PO13572116484 | 100 | 287 | 373 | 527 | 3 | 2023-07-03 | 3926.81 | 98.17 | 2023-06-21 | 3 | 1320.68 | 1 | 3926.81 | 4 | SO50221 | 2023-06-28 | 314.15 | 3962.05 | 1308.94 | |||
SO53526_12 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 240 | 579 | 3 | 2023-11-03 | 858.90 | 21.47 | 2023-10-22 | 1 | 868.63 | 1 | 858.90 | 12 | SO53526 | 2023-10-29 | 68.71 | 868.63 | 858.90 | |||
SO47428_3 | 7740-494F-95 | PO4437183290 | 100 | 283 | 441 | 39 | 3 | 2022-11-03 | 780.82 | 19.52 | 2022-10-22 | 1 | 722.26 | 1 | 780.82 | 3 | SO47428 | 2022-10-29 | 62.47 | 722.26 | 780.82 | |||
SO65195_6 | 11FD-44C6-95 | PO12354156814 | 100 | 283 | 361 | 197 | 3 | 2024-05-03 | 1376.99 | 34.42 | 2024-04-21 | 1 | 1251.98 | 1 | 1376.99 | 6 | SO65195 | 2024-04-28 | 110.16 | 1251.98 | 1376.99 | |||
SO48318_22 | 7FD9-425F-A3 | PO15341152410 | 100 | 283 | 308 | 327 | 3 | 2023-02-02 | 744.27 | 18.61 | 2023-01-21 | 1 | 660.91 | 1 | 744.27 | 22 | SO48318 | 2023-01-28 | 59.54 | 660.91 | 744.27 | |||
SO51151_24 | D7A9-4DF6-B9 | PO8787179219 | 100 | 282 | 580 | 523 | 3 | 2023-09-02 | 9185.35 | 229.63 | 2023-08-21 | 9 | 1082.51 | 1 | 9185.35 | 24 | SO51151 | 2023-08-28 | 734.83 | 9742.59 | 1020.59 | |||
SO49080_2 | 3270-44AE-82 | PO3074196924 | 100 | 281 | 460 | 237 | 3 | 2023-04-05 | 53.99 | 1.35 | 2023-03-24 | 1 | 37.12 | 1 | 53.99 | 2 | SO49080 | 2023-03-31 | 4.32 | 37.12 | 53.99 | |||
SO48379_8 | 703B-461C-A7 | PO7018165155 | 100 | 283 | 469 | 695 | 3 | 2023-02-02 | 91.18 | 2.28 | 2023-01-21 | 4 | 15.67 | 1 | 91.18 | 8 | SO48379 | 2023-01-28 | 7.29 | 62.68 | 22.79 | |||
SO53590_13 | E7FF-4C04-9E | PO4118162346 | 100 | 281 | 569 | 13 | 454 | 3 | 400.87 | 2023-11-03 | 2672.46 | 56.79 | 2023-10-22 | 8 | 461.44 | 1 | 2271.59 | 13 | SO53590 | 2023-10-29 | 181.73 | 3691.56 | 334.06 | 0.15 |
SO57037_16 | F0A9-4A16-B9 | PO15370120234 | 100 | 281 | 353 | 381 | 3 | 2024-01-03 | 12527.95 | 313.20 | 2023-12-22 | 9 | 1265.62 | 1 | 12527.95 | 16 | SO57037 | 2023-12-29 | 1002.24 | 11390.58 | 1391.99 | |||
SO47041_24 | C543-4932-83 | PO5771188676 | 100 | 282 | 327 | 9 | 79 | 3 | 493.28 | 2022-10-03 | 1644.28 | 28.77 | 2022-09-21 | 7 | 486.71 | 1 | 1151.00 | 24 | SO47041 | 2022-09-28 | 92.08 | 3406.95 | 234.90 | 0.30 |
SO50189_22 | 6D35-41E2-A6 | PO19923188059 | 100 | 283 | 470 | 18 | 3 | 2023-07-03 | 159.56 | 3.99 | 2023-06-21 | 7 | 15.67 | 1 | 159.56 | 22 | SO50189 | 2023-06-28 | 12.76 | 109.70 | 22.79 | |||
SO65195_1 | 11FD-44C6-95 | PO12354156814 | 100 | 283 | 225 | 197 | 3 | 2024-05-03 | 16.18 | 0.40 | 2024-04-21 | 3 | 6.92 | 1 | 16.18 | 1 | SO65195 | 2024-04-28 | 1.29 | 20.77 | 5.39 | |||
SO45539_7 | B54E-42F9-AB | PO13920158775 | 100 | 281 | 349 | 180 | 3 | 2022-05-03 | 2024.99 | 50.62 | 2022-04-21 | 1 | 1898.09 | 1 | 2024.99 | 7 | SO45539 | 2022-04-28 | 162.00 | 1898.09 | 2024.99 | |||
SO49499_15 | E899-4E47-A2 | PO15341196181 | 100 | 281 | 458 | 327 | 3 | 2023-05-03 | 134.98 | 3.37 | 2023-04-21 | 3 | 30.93 | 1 | 134.98 | 15 | SO49499 | 2023-04-28 | 10.80 | 92.80 | 44.99 | |||
SO71907_16 | D656-4305-83 | PO4118115030 | 100 | 281 | 523 | 454 | 3 | 2024-08-03 | 31.58 | 0.79 | 2024-07-22 | 1 | 23.37 | 1 | 31.58 | 16 | SO71907 | 2024-07-29 | 2.53 | 23.37 | 31.58 | |||
SO58996_1 | 5A1A-4E3D-B2 | PO14268110627 | 100 | 281 | 481 | 418 | 3 | 2024-02-02 | 21.58 | 0.54 | 2024-01-21 | 4 | 3.36 | 1 | 21.58 | 1 | SO58996 | 2024-01-28 | 1.73 | 13.45 | 5.39 | |||
SO47394_27 | 7FC9-4002-83 | PO12354143510 | 100 | 281 | 410 | 197 | 3 | 2022-11-03 | 36.45 | 0.91 | 2022-10-22 | 1 | 26.97 | 1 | 36.45 | 27 | SO47394 | 2022-10-29 | 2.92 | 26.97 | 36.45 | |||
SO49893_40 | 99ED-4EEC-9C | PO8787173621 | 100 | 282 | 323 | 2 | 523 | 3 | 99.91 | 2023-06-03 | 4995.48 | 122.39 | 2023-05-22 | 11 | 486.71 | 1 | 4895.57 | 40 | SO49893 | 2023-05-29 | 391.65 | 5353.77 | 454.13 | 0.02 |
SO50675_27 | 4D87-4C93-9C | PO15341172035 | 100 | 281 | 399 | 327 | 3 | 2023-08-03 | 101.32 | 2.53 | 2023-07-22 | 3 | 24.99 | 1 | 101.32 | 27 | SO50675 | 2023-07-29 | 8.11 | 74.98 | 33.77 | |||
SO69561_14 | BBC0-4CA4-A2 | PO8845186382 | 100 | 282 | 600 | 546 | 3 | 2024-07-03 | 323.99 | 8.10 | 2024-06-21 | 1 | 294.58 | 1 | 323.99 | 14 | SO69561 | 2024-06-28 | 25.92 | 294.58 | 323.99 | |||
SO46671_11 | 13F6-4858-8D | PO8787194061 | 100 | 282 | 414 | 523 | 3 | 2022-09-02 | 298.06 | 7.45 | 2022-08-21 | 2 | 110.28 | 1 | 298.06 | 11 | SO46671 | 2022-08-28 | 23.85 | 220.57 | 149.03 |
Generated 2024-09-20 14:33:24.354 UTC