[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 5197 > < TAKE 31 >
31 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO44093_6 | 8356-4625-B2 | PO15138128112 | 100 | 283 | 328 | 93 | 4 | 2021-12-24 | 838.92 | 20.97 | 2021-12-12 | 2 | 413.15 | 1 | 838.92 | 6 | SO44093 | 2021-12-19 | 67.11 | 826.29 | 419.46 | |||
| SO47720_35 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 375 | 221 | 4 | 2023-01-23 | 2617.88 | 65.45 | 2023-01-11 | 2 | 1320.68 | 1 | 2617.88 | 35 | SO47720 | 2023-01-18 | 209.43 | 2641.37 | 1308.94 | |||
| SO51147_4 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 258 | 81 | 5 | 2023-10-23 | 202.33 | 5.06 | 2023-10-11 | 1 | 204.63 | 1 | 202.33 | 4 | SO51147 | 2023-10-18 | 16.19 | 204.63 | 202.33 | |||
| SO59028_8 | F0C6-4E08-A8 | PO4814117936 | 36 | 295 | 566 | 464 | 8 | 2024-03-24 | 445.41 | 11.14 | 2024-03-12 | 1 | 461.44 | 1 | 445.41 | 8 | SO59028 | 2024-03-19 | 35.63 | 461.44 | 445.41 | |||
| SO44093_7 | 8356-4625-B2 | PO15138128112 | 100 | 283 | 215 | 93 | 4 | 2021-12-24 | 40.37 | 1.01 | 2021-12-12 | 2 | 12.03 | 1 | 40.37 | 7 | SO44093 | 2021-12-19 | 3.23 | 24.06 | 20.19 | |||
| SO47720_36 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 221 | 221 | 4 | 2023-01-23 | 40.37 | 1.01 | 2023-01-11 | 2 | 13.88 | 1 | 40.37 | 36 | SO47720 | 2023-01-18 | 3.23 | 27.76 | 20.19 | |||
| SO51147_5 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 484 | 3 | 81 | 5 | 3.72 | 2023-10-23 | 74.33 | 1.77 | 2023-10-11 | 17 | 2.97 | 1 | 70.62 | 5 | SO51147 | 2023-10-18 | 5.65 | 50.55 | 4.37 | 0.05 |
| SO59028_9 | F0C6-4E08-A8 | PO4814117936 | 36 | 295 | 603 | 464 | 8 | 2024-03-24 | 72.89 | 1.82 | 2024-03-12 | 1 | 53.94 | 1 | 72.89 | 9 | SO59028 | 2024-03-19 | 5.83 | 53.94 | 72.89 | |||
| SO44093_8 | 8356-4625-B2 | PO15138128112 | 100 | 283 | 264 | 93 | 4 | 2021-12-24 | 367.88 | 9.20 | 2021-12-12 | 2 | 181.49 | 1 | 367.88 | 8 | SO44093 | 2021-12-19 | 29.43 | 362.97 | 183.94 | |||
| SO47720_37 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 433 | 221 | 4 | 2023-01-23 | 324.45 | 8.11 | 2023-01-11 | 1 | 300.12 | 1 | 324.45 | 37 | SO47720 | 2023-01-18 | 25.96 | 300.12 | 324.45 | |||
| SO51147_6 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 378 | 81 | 5 | 2023-10-23 | 2932.02 | 73.30 | 2023-10-11 | 2 | 1554.95 | 1 | 2932.02 | 6 | SO51147 | 2023-10-18 | 234.56 | 3109.90 | 1466.01 | |||
| SO59028_10 | F0C6-4E08-A8 | PO4814117936 | 36 | 295 | 578 | 464 | 8 | 2024-03-24 | 1457.82 | 36.45 | 2024-03-12 | 2 | 755.15 | 1 | 1457.82 | 10 | SO59028 | 2024-03-19 | 116.63 | 1510.30 | 728.91 | |||
| SO44093_9 | 8356-4625-B2 | PO15138128112 | 100 | 283 | 220 | 93 | 4 | 2021-12-24 | 20.19 | 0.50 | 2021-12-12 | 1 | 12.03 | 1 | 20.19 | 9 | SO44093 | 2021-12-19 | 1.61 | 12.03 | 20.19 | |||
| SO47720_38 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 389 | 221 | 4 | 2023-01-23 | 2401.05 | 60.03 | 2023-01-11 | 4 | 605.65 | 1 | 2401.05 | 38 | SO47720 | 2023-01-18 | 192.08 | 2422.60 | 600.26 | |||
| SO51147_7 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 583 | 81 | 5 | 2023-10-23 | 4082.38 | 102.06 | 2023-10-11 | 4 | 1082.51 | 1 | 4082.38 | 7 | SO51147 | 2023-10-18 | 326.59 | 4330.04 | 1020.59 | |||
| SO59028_11 | F0C6-4E08-A8 | PO4814117936 | 36 | 295 | 585 | 464 | 8 | 2024-03-24 | 445.41 | 11.14 | 2024-03-12 | 1 | 461.44 | 1 | 445.41 | 11 | SO59028 | 2024-03-19 | 35.63 | 461.44 | 445.41 | |||
| SO44093_10 | 8356-4625-B2 | PO15138128112 | 100 | 283 | 338 | 93 | 4 | 2021-12-24 | 419.46 | 10.49 | 2021-12-12 | 1 | 413.15 | 1 | 419.46 | 10 | SO44093 | 2021-12-19 | 33.56 | 413.15 | 419.46 | |||
| SO47720_39 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 466 | 221 | 4 | 2023-01-23 | 14.13 | 0.35 | 2023-01-11 | 1 | 9.71 | 1 | 14.13 | 39 | SO47720 | 2023-01-18 | 1.13 | 9.71 | 14.13 | |||
| SO51147_8 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 243 | 81 | 5 | 2023-10-23 | 2576.70 | 64.42 | 2023-10-11 | 3 | 868.63 | 1 | 2576.70 | 8 | SO51147 | 2023-10-18 | 206.14 | 2605.90 | 858.90 | |||
| SO59028_12 | F0C6-4E08-A8 | PO4814117936 | 36 | 295 | 465 | 464 | 8 | 2024-03-24 | 102.86 | 2.57 | 2024-03-12 | 7 | 9.16 | 1 | 102.86 | 12 | SO59028 | 2024-03-19 | 8.23 | 64.12 | 14.69 | |||
| SO44093_11 | 8356-4625-B2 | PO15138128112 | 100 | 283 | 223 | 93 | 4 | 2021-12-24 | 31.12 | 0.78 | 2021-12-12 | 6 | 5.71 | 1 | 31.12 | 11 | SO44093 | 2021-12-19 | 2.49 | 34.23 | 5.19 | |||
| SO47720_40 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 329 | 221 | 4 | 2023-01-23 | 1879.18 | 46.98 | 2023-01-11 | 4 | 486.71 | 1 | 1879.18 | 40 | SO47720 | 2023-01-18 | 150.33 | 1946.83 | 469.79 | |||
| SO51147_9 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 467 | 81 | 5 | 2023-10-23 | 88.16 | 2.20 | 2023-10-11 | 6 | 9.16 | 1 | 88.16 | 9 | SO51147 | 2023-10-18 | 7.05 | 54.96 | 14.69 | |||
| SO59028_13 | F0C6-4E08-A8 | PO4814117936 | 36 | 295 | 564 | 464 | 8 | 2024-03-24 | 1430.44 | 35.76 | 2024-03-12 | 1 | 1481.94 | 1 | 1430.44 | 13 | SO59028 | 2024-03-19 | 114.44 | 1481.94 | 1430.44 | |||
| SO44093_12 | 8356-4625-B2 | PO15138128112 | 100 | 283 | 342 | 93 | 4 | 2021-12-24 | 1258.38 | 31.46 | 2021-12-12 | 3 | 413.15 | 1 | 1258.38 | 12 | SO44093 | 2021-12-19 | 100.67 | 1239.44 | 419.46 | |||
| SO47720_41 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 453 | 221 | 4 | 2023-01-23 | 287.95 | 7.20 | 2023-01-11 | 8 | 24.75 | 1 | 287.95 | 41 | SO47720 | 2023-01-18 | 23.04 | 197.97 | 35.99 | |||
| SO51147_10 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 384 | 81 | 5 | 2023-10-23 | 1344.59 | 33.61 | 2023-10-11 | 2 | 713.08 | 1 | 1344.59 | 10 | SO51147 | 2023-10-18 | 107.57 | 1426.16 | 672.29 | |||
| SO59028_14 | F0C6-4E08-A8 | PO4814117936 | 36 | 295 | 472 | 464 | 8 | 2024-03-24 | 114.30 | 2.86 | 2024-03-12 | 3 | 23.75 | 1 | 114.30 | 14 | SO59028 | 2024-03-19 | 9.14 | 71.25 | 38.10 | |||
| SO44093_13 | 8356-4625-B2 | PO15138128112 | 100 | 283 | 322 | 93 | 4 | 2021-12-24 | 838.92 | 20.97 | 2021-12-12 | 2 | 413.15 | 1 | 838.92 | 13 | SO44093 | 2021-12-19 | 67.11 | 826.29 | 419.46 | |||
| SO47720_42 | 30D0-4EF0-B1 | PO7859164121 | 100 | 287 | 461 | 221 | 4 | 2023-01-23 | 107.99 | 2.70 | 2023-01-11 | 2 | 37.12 | 1 | 107.99 | 42 | SO47720 | 2023-01-18 | 8.64 | 74.24 | 53.99 | |||
| SO51147_11 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 222 | 11 | 81 | 5 | 4.72 | 2023-10-23 | 31.49 | 0.67 | 2023-10-11 | 2 | 13.09 | 1 | 26.77 | 11 | SO51147 | 2023-10-18 | 2.14 | 26.17 | 15.75 | 0.15 |
Generated 2024-11-10 22:09:30.680 UTC