[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2283 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO67325_35 | 981F-41CE-8A | PO7859144943 | 100 | 287 | 465 | 221 | 4 | 2024-06-03 | 44.08 | 1.10 | 2024-05-22 | 3 | 9.16 | 1 | 44.08 | 35 | SO67325 | 2024-05-29 | 3.53 | 27.48 | 14.69 | |||
SO50748_3 | 5FBE-4B52-B2 | PO6786143310 | 100 | 281 | 453 | 3 | 4 | 2023-08-03 | 71.99 | 1.80 | 2023-07-22 | 2 | 24.75 | 1 | 71.99 | 3 | SO50748 | 2023-07-29 | 5.76 | 49.49 | 35.99 | |||
SO71952_19 | 9490-4552-81 | PO9715163911 | 100 | 281 | 525 | 490 | 4 | 2024-08-03 | 158.43 | 3.96 | 2024-07-22 | 1 | 144.59 | 1 | 158.43 | 19 | SO71952 | 2024-07-29 | 12.67 | 144.59 | 158.43 | |||
SO44095_7 | 97A5-4FCA-88 | PO14964184959 | 100 | 287 | 292 | 581 | 4 | 2021-11-03 | 818.70 | 20.47 | 2021-10-22 | 1 | 706.81 | 1 | 818.70 | 7 | SO44095 | 2021-10-29 | 65.50 | 706.81 | 818.70 | |||
SO51153_31 | AC8D-4688-81 | PO5626119823 | 100 | 281 | 580 | 2 | 166 | 4 | 276.24 | 2023-09-02 | 13812.04 | 338.40 | 2023-08-21 | 14 | 1082.51 | 1 | 13535.80 | 31 | SO51153 | 2023-08-28 | 1082.86 | 15155.14 | 986.57 | 0.02 |
SO49132_6 | 3562-4169-86 | PO3799126007 | 100 | 282 | 366 | 312 | 4 | 2023-04-05 | 647.99 | 16.20 | 2023-03-24 | 1 | 598.44 | 1 | 647.99 | 6 | SO49132 | 2023-03-31 | 51.84 | 598.44 | 647.99 | |||
SO46049_15 | 2C79-41BD-8A | PO15689114654 | 100 | 283 | 262 | 328 | 4 | 2022-07-03 | 551.81 | 13.80 | 2022-06-21 | 3 | 181.49 | 1 | 551.81 | 15 | SO46049 | 2022-06-28 | 44.15 | 544.46 | 183.94 | |||
SO46625_17 | 361B-4CAF-A2 | PO13688113829 | 100 | 282 | 365 | 475 | 4 | 2022-09-02 | 2591.98 | 64.80 | 2022-08-21 | 4 | 598.44 | 1 | 2591.98 | 17 | SO46625 | 2022-08-28 | 207.36 | 2393.74 | 647.99 | |||
SO58992_2 | 1646-48B2-8A | PO16182112796 | 100 | 287 | 474 | 23 | 4 | 2024-02-02 | 251.96 | 6.30 | 2024-01-21 | 6 | 26.18 | 1 | 251.96 | 2 | SO58992 | 2024-01-28 | 20.16 | 157.06 | 41.99 | |||
SO46370_12 | 7E21-402F-BF | PO4640115047 | 100 | 287 | 350 | 7 | 648 | 4 | 590.62 | 2022-08-03 | 1687.50 | 27.42 | 2022-07-22 | 2 | 1898.09 | 1 | 1096.87 | 12 | SO46370 | 2022-07-29 | 87.75 | 3796.19 | 843.75 | 0.35 |
SO49472_6 | 653C-45A9-B1 | PO2697138792 | 100 | 282 | 420 | 187 | 4 | 2023-05-03 | 283.23 | 7.08 | 2023-04-21 | 2 | 104.80 | 1 | 283.23 | 6 | SO49472 | 2023-04-28 | 22.66 | 209.59 | 141.62 | |||
SO48373_25 | 4C9A-49DD-BA | PO5539129597 | 100 | 282 | 412 | 61 | 4 | 2023-02-02 | 720.52 | 18.01 | 2023-01-21 | 4 | 133.30 | 1 | 720.52 | 25 | SO48373 | 2023-01-28 | 57.64 | 533.18 | 180.13 | |||
SO47439_17 | D4B6-4746-BE | PO6786128920 | 100 | 283 | 445 | 3 | 4 | 2022-11-03 | 107.98 | 2.70 | 2022-10-22 | 3 | 24.75 | 1 | 107.98 | 17 | SO47439 | 2022-10-29 | 8.64 | 74.24 | 35.99 | |||
SO44791_18 | CA2D-49E4-BD | PO6786162636 | 100 | 283 | 232 | 3 | 4 | 2022-02-02 | 115.36 | 2.88 | 2022-01-21 | 4 | 31.72 | 1 | 115.36 | 18 | SO44791 | 2022-01-28 | 9.23 | 126.90 | 28.84 | |||
SO53546_30 | 57CF-465D-B2 | PO16269114010 | 100 | 287 | 287 | 624 | 4 | 2023-11-03 | 404.66 | 10.12 | 2023-10-22 | 2 | 204.63 | 1 | 404.66 | 30 | SO53546 | 2023-10-29 | 32.37 | 409.25 | 202.33 | |||
SO58907_19 | F365-4683-97 | PO19372175613 | 100 | 282 | 577 | 582 | 4 | 2024-02-02 | 728.91 | 18.22 | 2024-01-21 | 1 | 755.15 | 1 | 728.91 | 19 | SO58907 | 2024-01-28 | 58.31 | 755.15 | 728.91 | |||
SO48054_3 | 25A4-4780-B1 | PO4553174748 | 100 | 282 | 343 | 313 | 4 | 2023-01-03 | 939.59 | 23.49 | 2022-12-22 | 2 | 486.71 | 1 | 939.59 | 3 | SO48054 | 2022-12-29 | 75.17 | 973.41 | 469.79 | |||
SO46341_21 | 7717-4086-86 | PO15138183971 | 100 | 283 | 253 | 93 | 4 | 2022-08-03 | 357.16 | 8.93 | 2022-07-22 | 2 | 176.20 | 1 | 357.16 | 21 | SO46341 | 2022-07-29 | 28.57 | 352.40 | 178.58 | |||
SO44113_13 | B9C7-4334-81 | PO2697181021 | 100 | 282 | 307 | 187 | 4 | 2021-11-03 | 722.59 | 18.06 | 2021-10-22 | 1 | 623.84 | 1 | 722.59 | 13 | SO44113 | 2021-10-29 | 57.81 | 623.84 | 722.59 | |||
SO51106_20 | 3D96-4D27-92 | PO12528166058 | 100 | 282 | 570 | 13 | 331 | 4 | 200.43 | 2023-09-02 | 1336.23 | 28.39 | 2023-08-21 | 4 | 461.44 | 1 | 1135.80 | 20 | SO51106 | 2023-08-28 | 90.86 | 1845.78 | 334.06 | 0.15 |
SO46970_23 | 01AF-420A-B9 | PO15196114472 | 100 | 282 | 263 | 258 | 4 | 2022-10-03 | 202.33 | 5.06 | 2022-09-21 | 1 | 187.16 | 1 | 202.33 | 23 | SO46970 | 2022-09-28 | 16.19 | 187.16 | 202.33 | |||
SO47355_13 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 458 | 2 | 24 | 4 | 10.44 | 2022-11-03 | 521.93 | 12.79 | 2022-10-22 | 12 | 30.93 | 1 | 511.49 | 13 | SO47355 | 2022-10-29 | 40.92 | 371.20 | 43.49 | 0.02 |
SO57168_37 | B6D5-41ED-B9 | PO3480129742 | 100 | 281 | 488 | 436 | 4 | 2024-01-03 | 194.36 | 4.86 | 2023-12-22 | 6 | 41.57 | 1 | 194.36 | 37 | SO57168 | 2023-12-29 | 15.55 | 249.43 | 32.39 | |||
SO51842_24 | 2A39-4E97-9A | PO4843199898 | 100 | 287 | 491 | 257 | 4 | 2023-10-03 | 97.18 | 2.43 | 2023-09-21 | 3 | 41.57 | 1 | 97.18 | 24 | SO51842 | 2023-09-28 | 7.77 | 124.72 | 32.39 | |||
SO47989_9 | A1B2-4EFB-A7 | PO15921198782 | 100 | 287 | 327 | 77 | 4 | 2023-01-03 | 939.59 | 23.49 | 2022-12-22 | 2 | 486.71 | 1 | 939.59 | 9 | SO47989 | 2022-12-29 | 75.17 | 973.41 | 469.79 | |||
SO53616_31 | A692-4827-93 | PO6786150961 | 100 | 281 | 491 | 2 | 3 | 4 | 6.89 | 2023-11-03 | 344.46 | 8.44 | 2023-10-22 | 11 | 41.57 | 1 | 337.57 | 31 | SO53616 | 2023-10-29 | 27.01 | 457.30 | 31.31 | 0.02 |
SO71782_37 | CA08-4A9B-8D | PO19372114749 | 100 | 282 | 488 | 582 | 4 | 2024-08-03 | 194.36 | 4.86 | 2024-07-22 | 6 | 41.57 | 1 | 194.36 | 37 | SO71782 | 2024-07-29 | 15.55 | 249.43 | 32.39 | |||
SO50226_16 | 75E5-4EFD-A7 | PO12499165634 | 100 | 282 | 368 | 78 | 4 | 2023-07-03 | 2932.02 | 73.30 | 2023-06-21 | 2 | 1518.79 | 1 | 2932.02 | 16 | SO50226 | 2023-06-28 | 234.56 | 3037.57 | 1466.01 | |||
SO48041_2 | 5338-4283-B9 | PO2320117440 | 100 | 282 | 414 | 529 | 4 | 2023-01-03 | 298.06 | 7.45 | 2022-12-22 | 2 | 110.28 | 1 | 298.06 | 2 | SO48041 | 2022-12-29 | 23.85 | 220.57 | 149.03 | |||
SO48012_46 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 453 | 78 | 4 | 2023-01-03 | 143.98 | 3.60 | 2022-12-22 | 4 | 24.75 | 1 | 143.98 | 46 | SO48012 | 2022-12-29 | 11.52 | 98.98 | 35.99 |
Generated 2024-09-20 11:42:08.863 UTC