[ROOT] dt FactResellerSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 2000 < SKIP 343 > < TAKE 31 >
31 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47992_4 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 458 | 487 | 1 | 2023-01-03 | 179.98 | 4.50 | 2022-12-22 | 4 | 30.93 | 1 | 179.98 | 4 | SO47992 | 2022-12-29 | 14.40 | 123.73 | 44.99 |
SO71818_4 | 2FCA-4131-BD | PO12470139718 | 100 | 287 | 494 | 672 | 1 | 2024-08-03 | 1204.69 | 30.12 | 2024-07-22 | 2 | 601.74 | 1 | 1204.69 | 4 | SO71818 | 2024-07-29 | 96.38 | 1203.49 | 602.35 |
SO45338_2 | EA29-4912-A1 | PO7627114520 | 100 | 286 | 317 | 433 | 1 | 2022-04-05 | 2624.38 | 65.61 | 2022-03-24 | 3 | 884.71 | 1 | 2624.38 | 2 | SO45338 | 2022-03-31 | 209.95 | 2654.12 | 874.79 |
SO69413_28 | E8F8-4282-9E | PO15631191114 | 100 | 282 | 533 | 43 | 1 | 2024-07-03 | 299.75 | 7.49 | 2024-06-21 | 2 | 136.79 | 1 | 299.75 | 28 | SO69413 | 2024-06-28 | 23.98 | 273.57 | 149.87 |
SO43849_8 | D0B8-4476-BA | PO18676186169 | 100 | 272 | 345 | 697 | 1 | 2021-10-03 | 2039.99 | 51.00 | 2021-09-21 | 1 | 1912.15 | 1 | 2039.99 | 8 | SO43849 | 2021-09-28 | 163.20 | 1912.15 | 2039.99 |
SO46042_18 | FE13-4E1B-A4 | PO16646156443 | 100 | 286 | 272 | 1 | 1 | 2022-07-03 | 183.94 | 4.60 | 2022-06-21 | 1 | 181.49 | 1 | 183.94 | 18 | SO46042 | 2022-06-28 | 14.72 | 181.49 | 183.94 |
SO53605_25 | 6D2A-486B-AC | PO5017132122 | 100 | 289 | 496 | 308 | 1 | 2023-11-03 | 1204.69 | 30.12 | 2023-10-22 | 2 | 601.74 | 1 | 1204.69 | 25 | SO53605 | 2023-10-29 | 96.38 | 1203.49 | 602.35 |
SO44563_20 | 9AFF-40A9-96 | PO7627161014 | 100 | 286 | 262 | 433 | 1 | 2022-01-03 | 183.94 | 4.60 | 2021-12-22 | 1 | 181.49 | 1 | 183.94 | 20 | SO44563 | 2021-12-29 | 14.72 | 181.49 | 183.94 |
SO48347_18 | 40D2-4DF5-93 | PO841112057 | 100 | 286 | 352 | 254 | 1 | 2023-02-02 | 2485.70 | 62.14 | 2023-01-21 | 2 | 1117.86 | 1 | 2485.70 | 18 | SO48347 | 2023-01-28 | 198.86 | 2235.71 | 1242.85 |
SO69524_3 | B8BC-4D73-8B | PO5162129421 | 100 | 289 | 520 | 669 | 1 | 2024-07-03 | 94.75 | 2.37 | 2024-06-21 | 3 | 23.37 | 1 | 94.75 | 3 | SO69524 | 2024-06-28 | 7.58 | 70.12 | 31.58 |
SO47986_35 | 3373-4C22-A9 | PO16414116972 | 100 | 289 | 458 | 236 | 1 | 2023-01-03 | 359.95 | 9.00 | 2022-12-22 | 8 | 30.93 | 1 | 359.95 | 35 | SO47986 | 2022-12-29 | 28.80 | 247.47 | 44.99 |
SO47054_21 | E4B1-4C58-AE | PO7627150376 | 100 | 286 | 331 | 433 | 1 | 2022-10-03 | 939.59 | 23.49 | 2022-09-21 | 2 | 486.71 | 1 | 939.59 | 21 | SO47054 | 2022-09-28 | 75.17 | 973.41 | 469.79 |
SO71904_1 | DBF0-4665-A7 | PO5017189568 | 100 | 289 | 565 | 308 | 1 | 2024-08-03 | 445.41 | 11.14 | 2024-07-22 | 1 | 461.44 | 1 | 445.41 | 1 | SO71904 | 2024-07-29 | 35.63 | 461.44 | 445.41 |
SO50206_34 | 7656-4E84-B8 | PO16414158832 | 100 | 289 | 393 | 236 | 1 | 2023-07-03 | 550.78 | 13.77 | 2023-06-21 | 4 | 101.89 | 1 | 550.78 | 34 | SO50206 | 2023-06-28 | 44.06 | 407.57 | 137.69 |
SO51826_1 | DBF7-4FCA-86 | PO6148188136 | 100 | 289 | 573 | 693 | 1 | 2023-10-03 | 5721.77 | 143.04 | 2023-09-21 | 4 | 1481.94 | 1 | 5721.77 | 1 | SO51826 | 2023-09-28 | 457.74 | 5927.75 | 1430.44 |
SO50671_4 | 9526-4D73-83 | PO17139132177 | 100 | 293 | 239 | 644 | 1 | 2023-08-03 | 2342.45 | 58.56 | 2023-07-22 | 3 | 722.26 | 1 | 2342.45 | 4 | SO50671 | 2023-07-29 | 187.40 | 2166.77 | 780.82 |
SO48001_42 | 02F1-4434-99 | PO14442151969 | 100 | 293 | 360 | 127 | 1 | 2023-01-03 | 2458.92 | 61.47 | 2022-12-22 | 2 | 1105.81 | 1 | 2458.92 | 42 | SO48001 | 2022-12-29 | 196.71 | 2211.62 | 1229.46 |
SO50321_5 | 6B3D-47E0-99 | PO8816191637 | 100 | 289 | 325 | 218 | 1 | 2023-07-03 | 1879.18 | 46.98 | 2023-06-21 | 4 | 486.71 | 1 | 1879.18 | 5 | SO50321 | 2023-06-28 | 150.33 | 1946.83 | 469.79 |
SO50270_14 | A828-45A2-8B | PO18676112371 | 100 | 282 | 358 | 697 | 1 | 2023-07-03 | 4917.84 | 122.95 | 2023-06-21 | 4 | 1105.81 | 1 | 4917.84 | 14 | SO50270 | 2023-06-28 | 393.43 | 4423.24 | 1229.46 |
SO65263_7 | C0DD-4323-8C | PO7395113656 | 100 | 286 | 474 | 542 | 1 | 2024-05-03 | 209.97 | 5.25 | 2024-04-21 | 5 | 26.18 | 1 | 209.97 | 7 | SO65263 | 2024-04-28 | 16.80 | 130.88 | 41.99 |
SO51715_15 | 2360-48BD-86 | PO15631184297 | 100 | 282 | 597 | 43 | 1 | 2023-10-03 | 323.99 | 8.10 | 2023-09-21 | 1 | 294.58 | 1 | 323.99 | 15 | SO51715 | 2023-09-28 | 25.92 | 294.58 | 323.99 |
SO46372_2 | 236A-4108-B4 | PO5220136009 | 100 | 282 | 293 | 169 | 1 | 2022-08-03 | 722.59 | 18.06 | 2022-07-22 | 1 | 623.84 | 1 | 722.59 | 2 | SO46372 | 2022-07-29 | 57.81 | 623.84 | 722.59 |
SO46967_5 | 6486-4AF8-A6 | PO15573116583 | 100 | 286 | 393 | 487 | 1 | 2022-10-03 | 275.39 | 6.88 | 2022-09-21 | 2 | 101.89 | 1 | 275.39 | 5 | SO46967 | 2022-09-28 | 22.03 | 203.79 | 137.69 |
SO46646_10 | A64B-4F46-92 | PO1421164577 | 100 | 286 | 468 | 325 | 1 | 2022-09-02 | 45.59 | 1.14 | 2022-08-21 | 2 | 15.67 | 1 | 45.59 | 10 | SO46646 | 2022-08-28 | 3.65 | 31.34 | 22.79 |
SO51148_6 | 1D20-490E-98 | PO6612158387 | 100 | 286 | 502 | 110 | 1 | 2023-09-02 | 200.05 | 5.00 | 2023-08-21 | 1 | 199.85 | 1 | 200.05 | 6 | SO51148 | 2023-08-28 | 16.00 | 199.85 | 200.05 |
SO51783_21 | B7A2-49BC-89 | PO18676114917 | 100 | 282 | 592 | 697 | 1 | 2023-10-03 | 677.99 | 16.95 | 2023-09-21 | 2 | 308.22 | 1 | 677.99 | 21 | SO51783 | 2023-09-28 | 54.24 | 616.44 | 338.99 |
SO49114_9 | 354C-48D4-9B | PO15631175128 | 100 | 282 | 354 | 43 | 1 | 2023-04-05 | 1242.85 | 31.07 | 2023-03-24 | 1 | 1117.86 | 1 | 1242.85 | 9 | SO49114 | 2023-03-31 | 99.43 | 1117.86 | 1242.85 |
SO51721_39 | 9429-430D-89 | PO14500124798 | 100 | 282 | 483 | 650 | 1 | 2023-10-03 | 576.00 | 14.40 | 2023-09-21 | 8 | 44.88 | 1 | 576.00 | 39 | SO51721 | 2023-09-28 | 46.08 | 359.04 | 72.00 |
SO49889_8 | 8783-45FC-96 | PO7105112550 | 100 | 293 | 329 | 668 | 1 | 2023-06-03 | 939.59 | 23.49 | 2023-05-22 | 2 | 486.71 | 1 | 939.59 | 8 | SO49889 | 2023-05-29 | 75.17 | 973.41 | 469.79 |
SO43671_5 | DFD9-41B7-94 | PO13978119376 | 100 | 289 | 275 | 200 | 1 | 2021-09-02 | 713.80 | 17.84 | 2021-08-21 | 2 | 352.14 | 1 | 713.80 | 5 | SO43671 | 2021-08-28 | 57.10 | 704.28 | 356.90 |
SO48328_14 | 5992-4AF8-B1 | PO13543152596 | 100 | 287 | 358 | 293 | 1 | 2023-02-02 | 1229.46 | 30.74 | 2023-01-21 | 1 | 1105.81 | 1 | 1229.46 | 14 | SO48328 | 2023-01-28 | 98.36 | 1105.81 | 1229.46 |
Generated 2024-09-20 06:28:56.155 UTC