[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 587 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71866_25 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 548 | 627 | 5 | 2024-08-03 | 48.59 | 1.21 | 2024-07-22 | 1 | 35.96 | 1 | 48.59 | 25 | SO71866 | 2024-07-29 | 3.89 | 35.96 | 48.59 | |||
SO48015_3 | AA12-417E-B1 | PO11803141907 | 100 | 285 | 358 | 513 | 5 | 2023-01-03 | 1229.46 | 30.74 | 2022-12-22 | 1 | 1105.81 | 1 | 1229.46 | 3 | SO48015 | 2022-12-29 | 98.36 | 1105.81 | 1229.46 | |||
SO45288_18 | D4D0-4662-A9 | PO16327170541 | 100 | 285 | 223 | 584 | 5 | 2022-04-05 | 31.12 | 0.78 | 2022-03-24 | 6 | 5.71 | 1 | 31.12 | 18 | SO45288 | 2022-03-31 | 2.49 | 34.23 | 5.19 | |||
SO47053_19 | 686D-414B-82 | PO7598127510 | 100 | 285 | 242 | 45 | 5 | 2022-10-03 | 3123.27 | 78.08 | 2022-09-21 | 4 | 722.26 | 1 | 3123.27 | 19 | SO47053 | 2022-09-28 | 249.86 | 2889.03 | 780.82 | |||
SO44562_14 | 1856-47B2-AD | PO7598190472 | 100 | 285 | 338 | 45 | 5 | 2022-01-03 | 838.92 | 20.97 | 2021-12-22 | 2 | 413.15 | 1 | 838.92 | 14 | SO44562 | 2021-12-29 | 67.11 | 826.29 | 419.46 | |||
SO67277_10 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 598 | 530 | 5 | 2024-06-03 | 647.99 | 16.20 | 2024-05-22 | 2 | 294.58 | 1 | 647.99 | 10 | SO67277 | 2024-05-29 | 51.84 | 589.16 | 323.99 | |||
SO57104_7 | D4EE-4716-83 | PO18560117786 | 100 | 285 | 482 | 2 | 531 | 5 | 1.15 | 2024-01-03 | 57.36 | 1.41 | 2023-12-22 | 11 | 3.36 | 1 | 56.21 | 7 | SO57104 | 2023-12-29 | 4.50 | 36.99 | 5.21 | 0.02 |
SO46996_24 | 775B-42D6-A5 | PO11571149031 | 100 | 285 | 370 | 512 | 5 | 2022-10-03 | 8796.06 | 219.90 | 2022-09-21 | 6 | 1518.79 | 1 | 8796.06 | 24 | SO46996 | 2022-09-28 | 703.68 | 9112.72 | 1466.01 | |||
SO44305_15 | E906-4DF2-BE | PO522153226 | 100 | 285 | 215 | 676 | 5 | 2021-12-03 | 20.19 | 0.50 | 2021-11-21 | 1 | 12.03 | 1 | 20.19 | 15 | SO44305 | 2021-11-28 | 1.61 | 12.03 | 20.19 | |||
SO57039_3 | 34D9-46BE-B4 | PO15051154053 | 100 | 285 | 471 | 207 | 5 | 2024-01-03 | 76.20 | 1.91 | 2023-12-22 | 2 | 23.75 | 1 | 76.20 | 3 | SO57039 | 2023-12-29 | 6.10 | 47.50 | 38.10 | |||
SO47042_18 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 468 | 566 | 5 | 2022-10-03 | 22.79 | 0.57 | 2022-09-21 | 1 | 15.67 | 1 | 22.79 | 18 | SO47042 | 2022-09-28 | 1.82 | 15.67 | 22.79 | |||
SO47042_12 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 461 | 566 | 5 | 2022-10-03 | 323.96 | 8.10 | 2022-09-21 | 6 | 37.12 | 1 | 323.96 | 12 | SO47042 | 2022-09-28 | 25.92 | 222.73 | 53.99 | |||
SO44488_4 | 18BD-4C15-81 | PO19546136242 | 100 | 285 | 334 | 206 | 5 | 2022-01-03 | 838.92 | 20.97 | 2021-12-22 | 2 | 413.15 | 1 | 838.92 | 4 | SO44488 | 2021-12-29 | 67.11 | 826.29 | 419.46 | |||
SO44555_21 | 51FA-451D-A2 | PO6293176988 | 100 | 285 | 336 | 612 | 5 | 2022-01-03 | 419.46 | 10.49 | 2021-12-22 | 1 | 413.15 | 1 | 419.46 | 21 | SO44555 | 2021-12-29 | 33.56 | 413.15 | 419.46 | |||
SO50726_29 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 273 | 170 | 5 | 2023-08-03 | 809.33 | 20.23 | 2023-07-22 | 4 | 187.16 | 1 | 809.33 | 29 | SO50726 | 2023-07-29 | 64.75 | 748.63 | 202.33 | |||
SO55260_5 | 0097-43FD-B7 | PO11861162351 | 100 | 283 | 483 | 17 | 5 | 2023-12-03 | 504.00 | 12.60 | 2023-11-21 | 7 | 44.88 | 1 | 504.00 | 5 | SO55260 | 2023-11-28 | 40.32 | 314.16 | 72.00 | |||
SO50703_34 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 230 | 90 | 5 | 2023-08-03 | 115.36 | 2.88 | 2023-07-22 | 4 | 29.08 | 1 | 115.36 | 34 | SO50703 | 2023-07-29 | 9.23 | 116.32 | 28.84 | |||
SO61173_14 | 6B8D-47B8-8E | PO522171689 | 100 | 285 | 474 | 676 | 5 | 2024-03-04 | 209.97 | 5.25 | 2024-02-21 | 5 | 26.18 | 1 | 209.97 | 14 | SO61173 | 2024-02-28 | 16.80 | 130.88 | 41.99 | |||
SO44552_16 | 79A1-4836-9F | PO5858149301 | 100 | 285 | 288 | 566 | 5 | 2022-01-03 | 1445.19 | 36.13 | 2021-12-22 | 2 | 623.84 | 1 | 1445.19 | 16 | SO44552 | 2021-12-29 | 115.62 | 1247.68 | 722.59 | |||
SO44488_2 | 18BD-4C15-81 | PO19546136242 | 100 | 285 | 338 | 206 | 5 | 2022-01-03 | 419.46 | 10.49 | 2021-12-22 | 1 | 413.15 | 1 | 419.46 | 2 | SO44488 | 2021-12-29 | 33.56 | 413.15 | 419.46 | |||
SO47693_3 | 3962-4A1A-93 | PO522165713 | 100 | 285 | 366 | 676 | 5 | 2022-12-03 | 647.99 | 16.20 | 2022-11-21 | 1 | 598.44 | 1 | 647.99 | 3 | SO47693 | 2022-11-28 | 51.84 | 598.44 | 647.99 | |||
SO50726_38 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 407 | 170 | 5 | 2023-08-03 | 328.01 | 8.20 | 2023-07-22 | 5 | 48.55 | 1 | 328.01 | 38 | SO50726 | 2023-07-29 | 26.24 | 242.73 | 65.60 | |||
SO50230_7 | E4FB-421B-A5 | PO11542120242 | 100 | 285 | 460 | 62 | 5 | 2023-07-03 | 107.99 | 2.70 | 2023-06-21 | 2 | 37.12 | 1 | 107.99 | 7 | SO50230 | 2023-06-28 | 8.64 | 74.24 | 53.99 | |||
SO45337_9 | C8D2-41D4-AF | PO7598166612 | 100 | 285 | 328 | 45 | 5 | 2022-04-05 | 419.46 | 10.49 | 2022-03-24 | 1 | 413.15 | 1 | 419.46 | 9 | SO45337 | 2022-03-31 | 33.56 | 413.15 | 419.46 | |||
SO61228_30 | 06C7-43A1-85 | PO9831151400 | 100 | 285 | 463 | 81 | 5 | 2024-03-04 | 14.69 | 0.37 | 2024-02-21 | 1 | 9.16 | 1 | 14.69 | 30 | SO61228 | 2024-02-28 | 1.18 | 9.16 | 14.69 | |||
SO45300_9 | 650B-4342-95 | PO12586158748 | 100 | 285 | 292 | 278 | 5 | 2022-04-05 | 1637.40 | 40.94 | 2022-03-24 | 2 | 706.81 | 1 | 1637.40 | 9 | SO45300 | 2022-03-31 | 130.99 | 1413.62 | 818.70 | |||
SO46996_1 | 775B-42D6-A5 | PO11571149031 | 100 | 285 | 433 | 512 | 5 | 2022-10-03 | 1622.26 | 40.56 | 2022-09-21 | 5 | 300.12 | 1 | 1622.26 | 1 | SO46996 | 2022-09-28 | 129.78 | 1500.59 | 324.45 | |||
SO44101_1 | F33F-41D4-81 | PO11977181307 | 100 | 285 | 270 | 675 | 5 | 2021-11-03 | 183.94 | 4.60 | 2021-10-22 | 1 | 181.49 | 1 | 183.94 | 1 | SO44101 | 2021-10-29 | 14.72 | 181.49 | 183.94 | |||
SO51718_17 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 225 | 207 | 5 | 2023-10-03 | 10.79 | 0.27 | 2023-09-21 | 2 | 6.92 | 1 | 10.79 | 17 | SO51718 | 2023-09-28 | 0.86 | 13.84 | 5.39 | |||
SO55328_15 | 577D-4DE9-B6 | PO9831188161 | 100 | 285 | 581 | 81 | 5 | 2023-12-03 | 4082.38 | 102.06 | 2023-11-21 | 4 | 1082.51 | 1 | 4082.38 | 15 | SO55328 | 2023-11-28 | 326.59 | 4330.04 | 1020.59 |
Generated 2024-09-21 00:08:19.275 UTC