[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SKIP 0 < SKIP 4259 > < TAKE 28 >
28 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48314_6 | A003-4969-BC | PO16124161457 | 100 | 282 | 221 | 649 | 4 | 2023-03-29 | 20.19 | 0.50 | 2023-03-17 | 1 | 13.88 | 1 | 20.19 | 6 | SO48314 | 2023-03-24 | 1.61 | 13.88 | 20.19 |
SO51855_24 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 490 | 436 | 4 | 2023-11-27 | 226.76 | 5.67 | 2023-11-15 | 7 | 41.57 | 1 | 226.76 | 24 | SO51855 | 2023-11-22 | 18.14 | 291.01 | 32.39 |
SO45074_21 | 7225-40DF-B0 | PO7859191751 | 100 | 287 | 270 | 221 | 4 | 2022-04-29 | 735.75 | 18.39 | 2022-04-17 | 4 | 181.49 | 1 | 735.75 | 21 | SO45074 | 2022-04-24 | 58.86 | 725.94 | 183.94 |
SO48314_7 | A003-4969-BC | PO16124161457 | 100 | 282 | 323 | 649 | 4 | 2023-03-29 | 469.79 | 11.74 | 2023-03-17 | 1 | 486.71 | 1 | 469.79 | 7 | SO48314 | 2023-03-24 | 37.58 | 486.71 | 469.79 |
SO51855_25 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 217 | 436 | 4 | 2023-11-27 | 41.99 | 1.05 | 2023-11-15 | 2 | 13.09 | 1 | 41.99 | 25 | SO51855 | 2023-11-22 | 3.36 | 26.17 | 20.99 |
SO45074_22 | 7225-40DF-B0 | PO7859191751 | 100 | 287 | 315 | 221 | 4 | 2022-04-29 | 874.79 | 21.87 | 2022-04-17 | 1 | 884.71 | 1 | 874.79 | 22 | SO45074 | 2022-04-24 | 69.98 | 884.71 | 874.79 |
SO48315_1 | 7A6D-43FF-A1 | PO15979199129 | 100 | 282 | 411 | 349 | 4 | 2023-03-29 | 250.83 | 6.27 | 2023-03-17 | 2 | 92.81 | 1 | 250.83 | 1 | SO48315 | 2023-03-24 | 20.07 | 185.61 | 125.42 |
SO51855_26 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 440 | 436 | 4 | 2023-11-27 | 858.90 | 21.47 | 2023-11-15 | 1 | 868.63 | 1 | 858.90 | 26 | SO51855 | 2023-11-22 | 68.71 | 868.63 | 858.90 |
SO45074_23 | 7225-40DF-B0 | PO7859191751 | 100 | 287 | 223 | 221 | 4 | 2022-04-29 | 25.93 | 0.65 | 2022-04-17 | 5 | 5.71 | 1 | 25.93 | 23 | SO45074 | 2022-04-24 | 2.07 | 28.53 | 5.19 |
SO48316_1 | CE6D-4B56-A3 | PO15805128976 | 100 | 283 | 433 | 382 | 4 | 2023-03-29 | 324.45 | 8.11 | 2023-03-17 | 1 | 300.12 | 1 | 324.45 | 1 | SO48316 | 2023-03-24 | 25.96 | 300.12 | 324.45 |
SO51855_27 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 231 | 436 | 4 | 2023-11-27 | 179.96 | 4.50 | 2023-11-15 | 6 | 38.49 | 1 | 179.96 | 27 | SO51855 | 2023-11-22 | 14.40 | 230.95 | 29.99 |
SO45074_24 | 7225-40DF-B0 | PO7859191751 | 100 | 287 | 342 | 221 | 4 | 2022-04-29 | 1677.84 | 41.95 | 2022-04-17 | 4 | 413.15 | 1 | 1677.84 | 24 | SO45074 | 2022-04-24 | 134.23 | 1652.59 | 419.46 |
SO48327_1 | 2906-4A58-AF | PO13717142928 | 100 | 287 | 370 | 473 | 4 | 2023-03-29 | 1466.01 | 36.65 | 2023-03-17 | 1 | 1518.79 | 1 | 1466.01 | 1 | SO48327 | 2023-03-24 | 117.28 | 1518.79 | 1466.01 |
SO51855_28 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 234 | 436 | 4 | 2023-11-27 | 119.98 | 3.00 | 2023-11-15 | 4 | 38.49 | 1 | 119.98 | 28 | SO51855 | 2023-11-22 | 9.60 | 153.97 | 29.99 |
SO45286_1 | AE6F-4379-99 | PO16762133534 | 100 | 282 | 315 | 259 | 4 | 2022-05-30 | 874.79 | 21.87 | 2022-05-18 | 1 | 884.71 | 1 | 874.79 | 1 | SO45286 | 2022-05-25 | 69.98 | 884.71 | 874.79 |
SO48327_2 | 2906-4A58-AF | PO13717142928 | 100 | 287 | 265 | 473 | 4 | 2023-03-29 | 1213.99 | 30.35 | 2023-03-17 | 6 | 187.16 | 1 | 1213.99 | 2 | SO48327 | 2023-03-24 | 97.12 | 1122.94 | 202.33 |
SO51855_29 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 436 | 436 | 4 | 2023-11-27 | 1070.69 | 26.77 | 2023-11-15 | 3 | 360.94 | 1 | 1070.69 | 29 | SO51855 | 2023-11-22 | 85.66 | 1082.83 | 356.90 |
SO45286_2 | AE6F-4379-99 | PO16762133534 | 100 | 282 | 324 | 259 | 4 | 2022-05-30 | 838.92 | 20.97 | 2022-05-18 | 2 | 413.15 | 1 | 838.92 | 2 | SO45286 | 2022-05-25 | 67.11 | 826.29 | 419.46 |
SO48327_3 | 2906-4A58-AF | PO13717142928 | 100 | 287 | 254 | 473 | 4 | 2023-03-29 | 183.94 | 4.60 | 2023-03-17 | 1 | 170.14 | 1 | 183.94 | 3 | SO48327 | 2023-03-24 | 14.72 | 170.14 | 183.94 |
SO51855_30 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 222 | 436 | 4 | 2023-11-27 | 167.95 | 4.20 | 2023-11-15 | 8 | 13.09 | 1 | 167.95 | 30 | SO51855 | 2023-11-22 | 13.44 | 104.69 | 20.99 |
SO45286_3 | AE6F-4379-99 | PO16762133534 | 100 | 282 | 342 | 259 | 4 | 2022-05-30 | 838.92 | 20.97 | 2022-05-18 | 2 | 413.15 | 1 | 838.92 | 3 | SO45286 | 2022-05-25 | 67.11 | 826.29 | 419.46 |
SO48327_4 | 2906-4A58-AF | PO13717142928 | 100 | 287 | 407 | 473 | 4 | 2023-03-29 | 196.81 | 4.92 | 2023-03-17 | 3 | 48.55 | 1 | 196.81 | 4 | SO48327 | 2023-03-24 | 15.74 | 145.64 | 65.60 |
SO51855_31 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 604 | 436 | 4 | 2023-11-27 | 2591.95 | 64.80 | 2023-11-15 | 8 | 343.65 | 1 | 2591.95 | 31 | SO51855 | 2023-11-22 | 207.36 | 2749.20 | 323.99 |
SO45286_4 | AE6F-4379-99 | PO16762133534 | 100 | 282 | 319 | 259 | 4 | 2022-05-30 | 874.79 | 21.87 | 2022-05-18 | 1 | 884.71 | 1 | 874.79 | 4 | SO45286 | 2022-05-25 | 69.98 | 884.71 | 874.79 |
SO48327_5 | 2906-4A58-AF | PO13717142928 | 100 | 287 | 435 | 473 | 4 | 2023-03-29 | 324.45 | 8.11 | 2023-03-17 | 1 | 300.12 | 1 | 324.45 | 5 | SO48327 | 2023-03-24 | 25.96 | 300.12 | 324.45 |
SO51855_32 | 8551-4CDF-A1 | PO3480115731 | 100 | 281 | 583 | 436 | 4 | 2023-11-27 | 1020.59 | 25.51 | 2023-11-15 | 1 | 1082.51 | 1 | 1020.59 | 32 | SO51855 | 2023-11-22 | 81.65 | 1082.51 | 1020.59 |
SO45286_5 | AE6F-4379-99 | PO16762133534 | 100 | 282 | 322 | 259 | 4 | 2022-05-30 | 419.46 | 10.49 | 2022-05-18 | 1 | 413.15 | 1 | 419.46 | 5 | SO45286 | 2022-05-25 | 33.56 | 413.15 | 419.46 |
SO48327_6 | 2906-4A58-AF | PO13717142928 | 100 | 287 | 464 | 473 | 4 | 2023-03-29 | 42.39 | 1.06 | 2023-03-17 | 3 | 9.71 | 1 | 42.39 | 6 | SO48327 | 2023-03-24 | 3.39 | 29.14 | 14.13 |
Generated 2024-11-14 18:02:07.111 UTC