[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > SHUFFLE < SKIP 3500 > < TAKE 500 >
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51735_27 | 6E95-4EE8-92 | PO13456167695 | 36 | 292 | 502 | 614 | 7 | 2023-10-19 | 1800.47 | 45.01 | 2023-10-07 | 9 | 199.85 | 1 | 1800.47 | 27 | SO51735 | 2023-10-14 | 144.04 | 1798.67 | 200.05 | |||
SO47410_2 | E1AD-4918-86 | PO1450182394 | 100 | 292 | 354 | 571 | 7 | 2022-11-19 | 3728.56 | 93.21 | 2022-11-07 | 3 | 1117.86 | 1 | 3728.56 | 2 | SO47410 | 2022-11-14 | 298.28 | 3353.57 | 1242.85 | |||
SO51733_8 | 5E45-4EBB-89 | PO13108175772 | 100 | 292 | 569 | 13 | 103 | 7 | 100.22 | 2023-10-19 | 668.12 | 14.20 | 2023-10-07 | 2 | 461.44 | 1 | 567.90 | 8 | SO51733 | 2023-10-14 | 45.43 | 922.89 | 334.06 | 0.15 |
SO50673_8 | 5E3E-4044-A0 | PO15515116492 | 100 | 292 | 323 | 481 | 7 | 2023-08-19 | 3758.35 | 93.96 | 2023-08-07 | 8 | 486.71 | 1 | 3758.35 | 8 | SO50673 | 2023-08-14 | 300.67 | 3893.65 | 469.79 | |||
SO58943_2 | 8472-486E-87 | PO12673119602 | 100 | 292 | 390 | 499 | 7 | 2024-02-18 | 5378.35 | 134.46 | 2024-02-06 | 8 | 713.08 | 1 | 5378.35 | 2 | SO58943 | 2024-02-13 | 430.27 | 5704.64 | 672.29 | |||
SO51708_17 | C46E-4C6C-95 | PO16704159960 | 100 | 292 | 483 | 680 | 7 | 2023-10-19 | 144.00 | 3.60 | 2023-10-07 | 2 | 44.88 | 1 | 144.00 | 17 | SO51708 | 2023-10-14 | 11.52 | 89.76 | 72.00 | |||
SO53475_5 | FFE3-4820-88 | PO15515192405 | 100 | 292 | 234 | 481 | 7 | 2023-11-19 | 89.98 | 2.25 | 2023-11-07 | 3 | 38.49 | 1 | 89.98 | 5 | SO53475 | 2023-11-14 | 7.20 | 115.48 | 29.99 | |||
SO49833_26 | 595A-4EFA-AC | PO13340158028 | 100 | 292 | 470 | 355 | 7 | 2023-06-19 | 159.56 | 3.99 | 2023-06-07 | 7 | 15.67 | 1 | 159.56 | 26 | SO49833 | 2023-06-14 | 12.76 | 109.70 | 22.79 | |||
SO69426_5 | 4194-45D7-B6 | PO13427130433 | 100 | 292 | 581 | 638 | 7 | 2024-07-19 | 7144.16 | 178.60 | 2024-07-07 | 7 | 1082.51 | 1 | 7144.16 | 5 | SO69426 | 2024-07-14 | 571.53 | 7577.57 | 1020.59 | |||
SO65213_17 | 67DD-478F-BE | PO15486173227 | 100 | 292 | 551 | 121 | 7 | 2024-05-19 | 633.72 | 15.84 | 2024-05-07 | 4 | 144.59 | 1 | 633.72 | 17 | SO65213 | 2024-05-14 | 50.70 | 578.38 | 158.43 | |||
SO51752_12 | C68C-4AF8-B1 | PO11223127670 | 100 | 292 | 515 | 632 | 7 | 2023-10-19 | 16.27 | 0.41 | 2023-10-07 | 1 | 12.04 | 1 | 16.27 | 12 | SO51752 | 2023-10-14 | 1.30 | 12.04 | 16.27 | |||
SO50681_8 | C44A-4F6F-86 | PO12673115760 | 100 | 292 | 369 | 499 | 7 | 2023-08-19 | 2932.02 | 73.30 | 2023-08-07 | 2 | 1518.79 | 1 | 2932.02 | 8 | SO50681 | 2023-08-14 | 234.56 | 3037.57 | 1466.01 | |||
SO46652_32 | D7E0-44F6-86 | PO3509195138 | 36 | 292 | 263 | 139 | 7 | 2022-09-18 | 1416.32 | 35.41 | 2022-09-06 | 7 | 187.16 | 1 | 1416.32 | 32 | SO46652 | 2022-09-13 | 113.31 | 1310.10 | 202.33 | |||
SO58926_20 | B82A-4380-9C | PO15486118845 | 100 | 292 | 559 | 121 | 7 | 2024-02-18 | 36.43 | 0.91 | 2024-02-06 | 3 | 8.99 | 1 | 36.43 | 20 | SO58926 | 2024-02-13 | 2.91 | 26.96 | 12.14 | |||
SO47377_6 | FA63-499A-AB | PO15515156459 | 100 | 292 | 323 | 3 | 481 | 7 | 387.58 | 2022-11-19 | 7751.60 | 184.10 | 2022-11-07 | 18 | 486.71 | 1 | 7364.02 | 6 | SO47377 | 2022-11-14 | 589.12 | 8760.72 | 430.64 | 0.05 |
SO63210_11 | 4AB9-4525-A2 | PO13369172160 | 100 | 292 | 372 | 391 | 7 | 2024-04-20 | 1466.01 | 36.65 | 2024-04-08 | 1 | 1554.95 | 1 | 1466.01 | 11 | SO63210 | 2024-04-15 | 117.28 | 1554.95 | 1466.01 | |||
SO49118_3 | 532A-4BAE-8C | PO13427116278 | 100 | 292 | 236 | 638 | 7 | 2023-04-21 | 144.20 | 3.61 | 2023-04-09 | 5 | 29.08 | 1 | 144.20 | 3 | SO49118 | 2023-04-16 | 11.54 | 145.40 | 28.84 | |||
SO71820_20 | D332-4AF2-A3 | PO12673129941 | 100 | 292 | 436 | 499 | 7 | 2024-08-19 | 1784.49 | 44.61 | 2024-08-07 | 5 | 360.94 | 1 | 1784.49 | 20 | SO71820 | 2024-08-14 | 142.76 | 1804.71 | 356.90 | |||
SO69464_23 | 8924-465B-BE | PO2668146931 | 100 | 292 | 525 | 535 | 7 | 2024-07-19 | 792.15 | 19.80 | 2024-07-07 | 5 | 144.59 | 1 | 792.15 | 23 | SO69464 | 2024-07-14 | 63.37 | 722.97 | 158.43 | |||
SO53475_4 | FFE3-4820-88 | PO15515192405 | 100 | 292 | 488 | 481 | 7 | 2023-11-19 | 259.15 | 6.48 | 2023-11-07 | 8 | 41.57 | 1 | 259.15 | 4 | SO53475 | 2023-11-14 | 20.73 | 332.58 | 32.39 | |||
SO65253_9 | D4A8-44F8-80 | PO12673115345 | 100 | 292 | 606 | 499 | 7 | 2024-05-19 | 2267.96 | 56.70 | 2024-05-07 | 7 | 343.65 | 1 | 2267.96 | 9 | SO65253 | 2024-05-14 | 181.44 | 2405.55 | 323.99 | |||
SO57086_58 | 9159-4FEC-A8 | PO2668146833 | 100 | 292 | 480 | 535 | 7 | 2024-01-19 | 4.12 | 0.10 | 2024-01-07 | 3 | 0.86 | 1 | 4.12 | 58 | SO57086 | 2024-01-14 | 0.33 | 2.57 | 1.37 | |||
SO53479_2 | 0F6A-4DE7-BC | PO15109129210 | 100 | 292 | 557 | 49 | 7 | 2023-11-19 | 153.89 | 3.85 | 2023-11-07 | 1 | 113.88 | 1 | 153.89 | 2 | SO53479 | 2023-11-14 | 12.31 | 113.88 | 153.89 | |||
SO69464_16 | 8924-465B-BE | PO2668146931 | 100 | 292 | 214 | 535 | 7 | 2024-07-19 | 209.94 | 5.25 | 2024-07-07 | 10 | 13.09 | 1 | 209.94 | 16 | SO69464 | 2024-07-14 | 16.80 | 130.86 | 20.99 | |||
SO57028_8 | E080-4171-A4 | PO16704183706 | 100 | 292 | 361 | 680 | 7 | 2024-01-19 | 2753.99 | 68.85 | 2024-01-07 | 2 | 1251.98 | 1 | 2753.99 | 8 | SO57028 | 2024-01-14 | 220.32 | 2503.96 | 1376.99 | |||
SO53478_29 | 6005-4C44-A8 | PO15486115045 | 100 | 292 | 543 | 121 | 7 | 2023-11-19 | 149.02 | 3.73 | 2023-11-07 | 4 | 27.57 | 1 | 149.02 | 29 | SO53478 | 2023-11-14 | 11.92 | 110.27 | 37.25 | |||
SO50225_40 | 6F8E-49A2-A5 | PO12702153410 | 100 | 292 | 421 | 175 | 7 | 2023-07-19 | 1766.96 | 44.17 | 2023-07-07 | 9 | 145.28 | 1 | 1766.96 | 40 | SO50225 | 2023-07-14 | 141.36 | 1307.55 | 196.33 | |||
SO51734_17 | 9D8E-4873-8B | PO13427111801 | 100 | 292 | 440 | 638 | 7 | 2023-10-19 | 858.90 | 21.47 | 2023-10-07 | 1 | 868.63 | 1 | 858.90 | 17 | SO51734 | 2023-10-14 | 68.71 | 868.63 | 858.90 | |||
SO46652_36 | D7E0-44F6-86 | PO3509195138 | 36 | 292 | 236 | 139 | 7 | 2022-09-18 | 201.88 | 5.05 | 2022-09-06 | 7 | 29.08 | 1 | 201.88 | 36 | SO46652 | 2022-09-13 | 16.15 | 203.56 | 28.84 | |||
SO57051_6 | 0E3B-4DB5-83 | PO13427178709 | 100 | 292 | 471 | 3 | 638 | 7 | 26.19 | 2024-01-19 | 523.88 | 12.44 | 2024-01-07 | 15 | 23.75 | 1 | 497.68 | 6 | SO57051 | 2024-01-14 | 39.81 | 356.24 | 34.93 | 0.05 |
Generated 2024-10-06 13:15:22.132 UTC