[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > < SKIP 4406 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47432_8 | 781D-4AED-A2 | PO4756164192 | 100 | 281 | 415 | 126 | 2 | 2022-12-27 | 396.07 | 9.90 | 2022-12-15 | 2 | 146.55 | 1 | 396.07 | 8 | SO47432 | 2022-12-22 | 31.69 | 293.09 | 198.04 | |||
SO47432_9 | 781D-4AED-A2 | PO4756164192 | 100 | 281 | 327 | 126 | 2 | 2022-12-27 | 469.79 | 11.74 | 2022-12-15 | 1 | 486.71 | 1 | 469.79 | 9 | SO47432 | 2022-12-22 | 37.58 | 486.71 | 469.79 | |||
SO47432_10 | 781D-4AED-A2 | PO4756164192 | 100 | 281 | 414 | 126 | 2 | 2022-12-27 | 596.12 | 14.90 | 2022-12-15 | 4 | 110.28 | 1 | 596.12 | 10 | SO47432 | 2022-12-22 | 47.69 | 441.13 | 149.03 | |||
SO47432_11 | 781D-4AED-A2 | PO4756164192 | 100 | 281 | 333 | 126 | 2 | 2022-12-27 | 2348.97 | 58.72 | 2022-12-15 | 5 | 486.71 | 1 | 2348.97 | 11 | SO47432 | 2022-12-22 | 187.92 | 2433.53 | 469.79 | |||
SO47432_12 | 781D-4AED-A2 | PO4756164192 | 100 | 281 | 325 | 126 | 2 | 2022-12-27 | 469.79 | 11.74 | 2022-12-15 | 1 | 486.71 | 1 | 469.79 | 12 | SO47432 | 2022-12-22 | 37.58 | 486.71 | 469.79 | |||
SO47446_1 | 3EF6-46D8-87 | PO8352178578 | 100 | 281 | 424 | 636 | 2 | 2022-12-27 | 214.24 | 5.36 | 2022-12-15 | 1 | 158.53 | 1 | 214.24 | 1 | SO47446 | 2022-12-22 | 17.14 | 158.53 | 214.24 | |||
SO47446_2 | 3EF6-46D8-87 | PO8352178578 | 100 | 281 | 423 | 636 | 2 | 2022-12-27 | 165.23 | 4.13 | 2022-12-15 | 1 | 122.27 | 1 | 165.23 | 2 | SO47446 | 2022-12-22 | 13.22 | 122.27 | 165.23 | |||
SO47450_1 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 221 | 54 | 2 | 2022-12-27 | 141.31 | 3.53 | 2022-12-15 | 7 | 13.88 | 1 | 141.31 | 1 | SO47450 | 2022-12-22 | 11.30 | 97.15 | 20.19 | |||
SO47450_2 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 385 | 54 | 2 | 2022-12-27 | 1200.53 | 30.01 | 2022-12-15 | 2 | 605.65 | 1 | 1200.53 | 2 | SO47450 | 2022-12-22 | 96.04 | 1211.30 | 600.26 | |||
SO47450_3 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 424 | 54 | 2 | 2022-12-27 | 214.24 | 5.36 | 2022-12-15 | 1 | 158.53 | 1 | 214.24 | 3 | SO47450 | 2022-12-22 | 17.14 | 158.53 | 214.24 | |||
SO47450_4 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 403 | 54 | 2 | 2022-12-27 | 48.59 | 1.21 | 2022-12-15 | 2 | 17.98 | 1 | 48.59 | 4 | SO47450 | 2022-12-22 | 3.89 | 35.96 | 24.29 | |||
SO47450_5 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 433 | 54 | 2 | 2022-12-27 | 1946.72 | 48.67 | 2022-12-15 | 6 | 300.12 | 1 | 1946.72 | 5 | SO47450 | 2022-12-22 | 155.74 | 1800.71 | 324.45 | |||
SO47450_6 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 429 | 54 | 2 | 2022-12-27 | 1297.81 | 32.45 | 2022-12-15 | 4 | 300.12 | 1 | 1297.81 | 6 | SO47450 | 2022-12-22 | 103.82 | 1200.48 | 324.45 | |||
SO47450_7 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 327 | 2 | 54 | 2 | 118.07 | 2022-12-27 | 5903.74 | 144.64 | 2022-12-15 | 13 | 486.71 | 1 | 5785.67 | 7 | SO47450 | 2022-12-22 | 462.85 | 6327.19 | 454.13 | 0.02 |
SO47450_8 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 325 | 3 | 54 | 2 | 322.98 | 2022-12-27 | 6459.67 | 153.42 | 2022-12-15 | 15 | 486.71 | 1 | 6136.68 | 8 | SO47450 | 2022-12-22 | 490.93 | 7300.60 | 430.64 | 0.05 |
SO47450_9 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 373 | 54 | 2 | 2022-12-27 | 2617.88 | 65.45 | 2022-12-15 | 2 | 1320.68 | 1 | 2617.88 | 9 | SO47450 | 2022-12-22 | 209.43 | 2641.37 | 1308.94 | |||
SO47450_10 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 339 | 54 | 2 | 2022-12-27 | 1879.18 | 46.98 | 2022-12-15 | 4 | 486.71 | 1 | 1879.18 | 10 | SO47450 | 2022-12-22 | 150.33 | 1946.83 | 469.79 | |||
SO47450_11 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 460 | 54 | 2 | 2022-12-27 | 431.95 | 10.80 | 2022-12-15 | 8 | 37.12 | 1 | 431.95 | 11 | SO47450 | 2022-12-22 | 34.56 | 296.97 | 53.99 | |||
SO65245_27 | 80F6-437F-84 | PO9628129233 | 100 | 283 | 566 | 179 | 2 | 2024-06-26 | 445.41 | 11.14 | 2024-06-14 | 1 | 461.44 | 1 | 445.41 | 27 | SO65245 | 2024-06-21 | 35.63 | 461.44 | 445.41 | |||
SO65245_28 | 80F6-437F-84 | PO9628129233 | 100 | 283 | 217 | 179 | 2 | 2024-06-26 | 62.98 | 1.57 | 2024-06-14 | 3 | 13.09 | 1 | 62.98 | 28 | SO65245 | 2024-06-21 | 5.04 | 39.26 | 20.99 | |||
SO65245_29 | 80F6-437F-84 | PO9628129233 | 100 | 283 | 563 | 179 | 2 | 2024-06-26 | 1430.44 | 35.76 | 2024-06-14 | 1 | 1481.94 | 1 | 1430.44 | 29 | SO65245 | 2024-06-21 | 114.44 | 1481.94 | 1430.44 | |||
SO65245_30 | 80F6-437F-84 | PO9628129233 | 100 | 283 | 571 | 179 | 2 | 2024-06-26 | 890.82 | 22.27 | 2024-06-14 | 2 | 461.44 | 1 | 890.82 | 30 | SO65245 | 2024-06-21 | 71.27 | 922.89 | 445.41 | |||
SO65257_1 | 4659-4DD9-90 | PO7685190459 | 100 | 283 | 603 | 539 | 2 | 2024-06-26 | 72.89 | 1.82 | 2024-06-14 | 1 | 53.94 | 1 | 72.89 | 1 | SO65257 | 2024-06-21 | 5.83 | 53.94 | 72.89 | |||
SO65257_2 | 4659-4DD9-90 | PO7685190459 | 100 | 283 | 570 | 539 | 2 | 2024-06-26 | 890.82 | 22.27 | 2024-06-14 | 2 | 461.44 | 1 | 890.82 | 2 | SO65257 | 2024-06-21 | 71.27 | 922.89 | 445.41 | |||
SO65257_3 | 4659-4DD9-90 | PO7685190459 | 100 | 283 | 561 | 539 | 2 | 2024-06-26 | 5721.77 | 143.04 | 2024-06-14 | 4 | 1481.94 | 1 | 5721.77 | 3 | SO65257 | 2024-06-21 | 457.74 | 5927.75 | 1430.44 | |||
SO65257_4 | 4659-4DD9-90 | PO7685190459 | 100 | 283 | 490 | 539 | 2 | 2024-06-26 | 194.36 | 4.86 | 2024-06-14 | 6 | 41.57 | 1 | 194.36 | 4 | SO65257 | 2024-06-21 | 15.55 | 249.43 | 32.39 | |||
SO65257_5 | 4659-4DD9-90 | PO7685190459 | 100 | 283 | 563 | 539 | 2 | 2024-06-26 | 2860.88 | 71.52 | 2024-06-14 | 2 | 1481.94 | 1 | 2860.88 | 5 | SO65257 | 2024-06-21 | 228.87 | 2963.88 | 1430.44 | |||
SO65257_6 | 4659-4DD9-90 | PO7685190459 | 100 | 283 | 565 | 539 | 2 | 2024-06-26 | 1781.64 | 44.54 | 2024-06-14 | 4 | 461.44 | 1 | 1781.64 | 6 | SO65257 | 2024-06-21 | 142.53 | 1845.78 | 445.41 | |||
SO65257_7 | 4659-4DD9-90 | PO7685190459 | 100 | 283 | 585 | 539 | 2 | 2024-06-26 | 445.41 | 11.14 | 2024-06-14 | 1 | 461.44 | 1 | 445.41 | 7 | SO65257 | 2024-06-21 | 35.63 | 461.44 | 445.41 | |||
SO65257_8 | 4659-4DD9-90 | PO7685190459 | 100 | 283 | 566 | 539 | 2 | 2024-06-26 | 1336.23 | 33.41 | 2024-06-14 | 3 | 461.44 | 1 | 1336.23 | 8 | SO65257 | 2024-06-21 | 106.90 | 1384.33 | 445.41 |
Generated 2024-11-13 06:45:30.930 UTC