[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SHUFFLE < SKIP 2633 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49870_21 | 7E0A-4D6E-9E | PO6467181139 | 100 | 283 | 422 | 660 | 3 | 2023-07-28 | 135.08 | 3.38 | 2023-07-16 | 2 | 49.98 | 1 | 135.08 | 21 | SO49870 | 2023-07-23 | 10.81 | 99.96 | 67.54 | |||
SO46325_2 | D29B-490E-A9 | PO19488134185 | 100 | 283 | 212 | 57 | 3 | 2022-09-27 | 141.31 | 3.53 | 2022-09-15 | 7 | 12.03 | 1 | 141.31 | 2 | SO46325 | 2022-09-22 | 11.30 | 84.19 | 20.19 | |||
SO49870_29 | 7E0A-4D6E-9E | PO6467181139 | 100 | 283 | 369 | 660 | 3 | 2023-07-28 | 1466.01 | 36.65 | 2023-07-16 | 1 | 1518.79 | 1 | 1466.01 | 29 | SO49870 | 2023-07-23 | 117.28 | 1518.79 | 1466.01 | |||
SO47041_15 | C543-4932-83 | PO5771188676 | 100 | 282 | 448 | 79 | 3 | 2022-11-27 | 23.99 | 0.60 | 2022-11-15 | 2 | 8.25 | 1 | 23.99 | 15 | SO47041 | 2022-11-22 | 1.92 | 16.49 | 11.99 | |||
SO46344_23 | BB3A-4D16-9E | PO14268133810 | 100 | 283 | 340 | 418 | 3 | 2022-09-27 | 419.46 | 10.49 | 2022-09-15 | 1 | 413.15 | 1 | 419.46 | 23 | SO46344 | 2022-09-22 | 33.56 | 413.15 | 419.46 | |||
SO47409_21 | FC23-4384-86 | PO1624119173 | 100 | 283 | 370 | 579 | 3 | 2022-12-28 | 1466.01 | 36.65 | 2022-12-16 | 1 | 1518.79 | 1 | 1466.01 | 21 | SO47409 | 2022-12-23 | 117.28 | 1518.79 | 1466.01 | |||
SO46087_21 | 7F79-4A44-AB | PO5191162942 | 100 | 283 | 314 | 364 | 3 | 2022-08-27 | 2146.96 | 53.67 | 2022-08-15 | 1 | 2171.29 | 1 | 2146.96 | 21 | SO46087 | 2022-08-22 | 171.76 | 2171.29 | 2146.96 | |||
SO71864_10 | 2987-40A6-86 | PO14268188903 | 100 | 281 | 372 | 418 | 3 | 2024-09-27 | 2932.02 | 73.30 | 2024-09-15 | 2 | 1554.95 | 1 | 2932.02 | 10 | SO71864 | 2024-09-22 | 234.56 | 3109.90 | 1466.01 | |||
SO46325_8 | D29B-490E-A9 | PO19488134185 | 100 | 283 | 270 | 57 | 3 | 2022-09-27 | 367.88 | 9.20 | 2022-09-15 | 2 | 181.49 | 1 | 367.88 | 8 | SO46325 | 2022-09-22 | 29.43 | 362.97 | 183.94 | |||
SO53526_6 | 6EEB-4506-89 | PO1624140151 | 100 | 281 | 386 | 579 | 3 | 2023-12-28 | 672.29 | 16.81 | 2023-12-16 | 1 | 713.08 | 1 | 672.29 | 6 | SO53526 | 2023-12-23 | 53.78 | 713.08 | 672.29 | |||
SO69418_31 | D0CE-41AD-AA | PO15370180703 | 100 | 281 | 516 | 381 | 3 | 2024-08-27 | 140.90 | 3.52 | 2024-08-15 | 6 | 17.38 | 1 | 140.90 | 31 | SO69418 | 2024-08-22 | 11.27 | 104.27 | 23.48 | |||
SO44517_22 | 47C8-4635-A6 | PO13572181174 | 100 | 287 | 270 | 527 | 3 | 2022-02-27 | 551.81 | 13.80 | 2022-02-15 | 3 | 181.49 | 1 | 551.81 | 22 | SO44517 | 2022-02-22 | 44.15 | 544.46 | 183.94 | |||
SO69393_14 | 3E84-4AA4-B6 | PO19923114948 | 100 | 283 | 595 | 16 | 18 | 3 | 45.20 | 2024-08-27 | 113.00 | 1.70 | 2024-08-15 | 1 | 308.22 | 1 | 67.80 | 14 | SO69393 | 2024-08-22 | 5.42 | 308.22 | 113.00 | 0.40 |
SO69503_38 | 559D-4568-82 | PO5771124379 | 100 | 282 | 222 | 79 | 3 | 2024-08-27 | 146.96 | 3.67 | 2024-08-15 | 7 | 13.09 | 1 | 146.96 | 38 | SO69503 | 2024-08-22 | 11.76 | 91.60 | 20.99 | |||
SO46931_22 | EE3D-4B0A-B6 | PO19923131204 | 100 | 281 | 470 | 18 | 3 | 2022-11-27 | 91.18 | 2.28 | 2022-11-15 | 4 | 15.67 | 1 | 91.18 | 22 | SO46931 | 2022-11-22 | 7.29 | 62.68 | 22.79 | |||
SO55324_26 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 418 | 523 | 3 | 2024-01-27 | 1427.59 | 35.69 | 2024-01-15 | 4 | 360.94 | 1 | 1427.59 | 26 | SO55324 | 2024-01-22 | 114.21 | 1443.77 | 356.90 | |||
SO63160_2 | 7984-48B8-A7 | PO13572115420 | 100 | 287 | 547 | 527 | 3 | 2024-05-29 | 97.19 | 2.43 | 2024-05-17 | 2 | 35.96 | 1 | 97.19 | 2 | SO63160 | 2024-05-24 | 7.78 | 71.92 | 48.59 | |||
SO50304_6 | 9338-4FCD-A5 | PO5771132420 | 100 | 282 | 224 | 79 | 3 | 2023-08-27 | 31.12 | 0.78 | 2023-08-15 | 6 | 5.23 | 1 | 31.12 | 6 | SO50304 | 2023-08-22 | 2.49 | 31.38 | 5.19 | |||
SO49116_17 | 5844-47DC-B2 | PO13572169665 | 100 | 287 | 369 | 527 | 3 | 2023-05-30 | 1466.01 | 36.65 | 2023-05-18 | 1 | 1518.79 | 1 | 1466.01 | 17 | SO49116 | 2023-05-25 | 117.28 | 1518.79 | 1466.01 | |||
SO71803_26 | 9C57-4821-9B | PO15341174104 | 100 | 281 | 525 | 327 | 3 | 2024-09-27 | 158.43 | 3.96 | 2024-09-15 | 1 | 144.59 | 1 | 158.43 | 26 | SO71803 | 2024-09-22 | 12.67 | 144.59 | 158.43 | |||
SO46358_29 | 3BC7-40F4-99 | PO1624111969 | 100 | 283 | 232 | 579 | 3 | 2022-09-27 | 28.84 | 0.72 | 2022-09-15 | 1 | 31.72 | 1 | 28.84 | 29 | SO46358 | 2022-09-22 | 2.31 | 31.72 | 28.84 | |||
SO53480_1 | 36E1-4FCF-B4 | PO15341137525 | 100 | 281 | 542 | 327 | 3 | 2023-12-28 | 24.29 | 0.61 | 2023-12-16 | 1 | 17.98 | 1 | 24.29 | 1 | SO53480 | 2023-12-23 | 1.94 | 17.98 | 24.29 | |||
SO46621_3 | DCA1-4F74-BD | PO13949117076 | 100 | 281 | 415 | 643 | 3 | 2022-10-27 | 198.04 | 4.95 | 2022-10-15 | 1 | 146.55 | 1 | 198.04 | 3 | SO46621 | 2022-10-22 | 15.84 | 146.55 | 198.04 | |||
SO61174_1 | 2605-4DC1-84 | PO19314179996 | 100 | 281 | 471 | 622 | 3 | 2024-04-28 | 114.30 | 2.86 | 2024-04-16 | 3 | 23.75 | 1 | 114.30 | 1 | SO61174 | 2024-04-23 | 9.14 | 71.25 | 38.10 | |||
SO51720_40 | E39F-4680-AC | PO15370128892 | 100 | 281 | 475 | 381 | 3 | 2023-11-27 | 41.99 | 1.05 | 2023-11-15 | 1 | 26.18 | 1 | 41.99 | 40 | SO51720 | 2023-11-22 | 3.36 | 26.18 | 41.99 | |||
SO65221_22 | 0AC4-40AE-B6 | PO15341198427 | 100 | 281 | 589 | 327 | 3 | 2024-06-27 | 923.39 | 23.08 | 2024-06-15 | 2 | 419.78 | 1 | 923.39 | 22 | SO65221 | 2024-06-22 | 73.87 | 839.56 | 461.69 | |||
SO48786_38 | D12C-42C5-83 | PO6467115913 | 100 | 283 | 464 | 660 | 3 | 2023-04-29 | 70.64 | 1.77 | 2023-04-17 | 5 | 9.71 | 1 | 70.64 | 38 | SO48786 | 2023-04-24 | 5.65 | 48.57 | 14.13 | |||
SO53454_15 | 278D-445A-99 | PO19633151350 | 100 | 287 | 598 | 149 | 3 | 2023-12-28 | 323.99 | 8.10 | 2023-12-16 | 1 | 294.58 | 1 | 323.99 | 15 | SO53454 | 2023-12-23 | 25.92 | 294.58 | 323.99 |
Generated 2024-11-14 08:36:17.174 UTC