[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > SKIP 3000 SHUFFLE SKIP 0 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57086_13 | 9159-4FEC-A8 | PO2668146833 | 100 | 292 | 515 | 535 | 7 | 2024-01-03 | 16.27 | 0.41 | 2023-12-22 | 1 | 12.04 | 1 | 16.27 | 13 | SO57086 | 2023-12-29 | 1.30 | 12.04 | 16.27 | |||
SO57061_52 | C48C-4776-A7 | PO12702183787 | 100 | 292 | 558 | 175 | 7 | 2024-01-03 | 728.98 | 18.22 | 2023-12-22 | 3 | 179.82 | 1 | 728.98 | 52 | SO57061 | 2023-12-29 | 58.32 | 539.45 | 242.99 | |||
SO58943_20 | 8472-486E-87 | PO12673119602 | 100 | 292 | 436 | 499 | 7 | 2024-02-02 | 1784.49 | 44.61 | 2024-01-21 | 5 | 360.94 | 1 | 1784.49 | 20 | SO58943 | 2024-01-28 | 142.76 | 1804.71 | 356.90 | |||
SO71838_1 | C65D-4244-8E | PO1305123041 | 100 | 292 | 576 | 319 | 7 | 2024-08-03 | 1430.44 | 35.76 | 2024-07-22 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO71838 | 2024-07-29 | 114.44 | 1481.94 | 1430.44 | |||
SO58943_13 | 8472-486E-87 | PO12673119602 | 100 | 292 | 583 | 2 | 499 | 7 | 276.24 | 2024-02-02 | 13812.04 | 338.40 | 2024-01-21 | 14 | 1082.51 | 1 | 13535.80 | 13 | SO58943 | 2024-01-28 | 1082.86 | 15155.14 | 986.57 | 0.02 |
SO47391_26 | 8A04-4F3F-97 | PO12673197440 | 100 | 292 | 417 | 499 | 7 | 2022-11-03 | 324.45 | 8.11 | 2022-10-22 | 1 | 300.12 | 1 | 324.45 | 26 | SO47391 | 2022-10-29 | 25.96 | 300.12 | 324.45 | |||
SO57150_2 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 577 | 85 | 7 | 2024-01-03 | 4373.46 | 109.34 | 2023-12-22 | 6 | 755.15 | 1 | 4373.46 | 2 | SO57150 | 2023-12-29 | 349.88 | 4530.90 | 728.91 | |||
SO58927_18 | BEF7-43AF-A2 | PO15515112432 | 100 | 292 | 214 | 2 | 481 | 7 | 4.87 | 2024-02-02 | 243.53 | 5.97 | 2024-01-21 | 12 | 13.09 | 1 | 238.66 | 18 | SO58927 | 2024-01-28 | 19.09 | 157.04 | 20.29 | 0.02 |
SO57068_27 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 532 | 632 | 7 | 2024-01-03 | 299.75 | 7.49 | 2023-12-22 | 2 | 136.79 | 1 | 299.75 | 27 | SO57068 | 2023-12-29 | 23.98 | 273.57 | 149.87 | |||
SO50681_21 | C44A-4F6F-86 | PO12673115760 | 100 | 292 | 286 | 499 | 7 | 2023-08-03 | 367.88 | 9.20 | 2023-07-22 | 2 | 170.14 | 1 | 367.88 | 21 | SO50681 | 2023-07-29 | 29.43 | 340.29 | 183.94 | |||
SO57119_11 | 588B-4457-8A | PO3712174757 | 100 | 292 | 579 | 662 | 7 | 2024-01-03 | 728.91 | 18.22 | 2023-12-22 | 1 | 755.15 | 1 | 728.91 | 11 | SO57119 | 2023-12-29 | 58.31 | 755.15 | 728.91 | |||
SO47377_39 | FA63-499A-AB | PO15515156459 | 100 | 292 | 417 | 481 | 7 | 2022-11-03 | 324.45 | 8.11 | 2022-10-22 | 1 | 300.12 | 1 | 324.45 | 39 | SO47377 | 2022-10-29 | 25.96 | 300.12 | 324.45 | |||
SO57086_57 | 9159-4FEC-A8 | PO2668146833 | 100 | 292 | 555 | 535 | 7 | 2024-01-03 | 255.60 | 6.39 | 2023-12-22 | 4 | 47.29 | 1 | 255.60 | 57 | SO57086 | 2023-12-29 | 20.45 | 189.14 | 63.90 | |||
SO57119_13 | 588B-4457-8A | PO3712174757 | 100 | 292 | 491 | 662 | 7 | 2024-01-03 | 194.36 | 4.86 | 2023-12-22 | 6 | 41.57 | 1 | 194.36 | 13 | SO57119 | 2023-12-29 | 15.55 | 249.43 | 32.39 | |||
SO57068_2 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 595 | 632 | 7 | 2024-01-03 | 677.99 | 16.95 | 2023-12-22 | 2 | 308.22 | 1 | 677.99 | 2 | SO57068 | 2023-12-29 | 54.24 | 616.44 | 338.99 | |||
SO57086_28 | 9159-4FEC-A8 | PO2668146833 | 100 | 292 | 516 | 535 | 7 | 2024-01-03 | 93.94 | 2.35 | 2023-12-22 | 4 | 17.38 | 1 | 93.94 | 28 | SO57086 | 2023-12-29 | 7.51 | 69.51 | 23.48 | |||
SO47377_19 | FA63-499A-AB | PO15515156459 | 100 | 292 | 423 | 481 | 7 | 2022-11-03 | 165.23 | 4.13 | 2022-10-22 | 1 | 122.27 | 1 | 165.23 | 19 | SO47377 | 2022-10-29 | 13.22 | 122.27 | 165.23 | |||
SO57150_36 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 576 | 85 | 7 | 2024-01-03 | 7152.21 | 178.81 | 2023-12-22 | 5 | 1481.94 | 1 | 7152.21 | 36 | SO57150 | 2023-12-29 | 572.18 | 7409.69 | 1430.44 | |||
SO57086_52 | 9159-4FEC-A8 | PO2668146833 | 100 | 292 | 472 | 535 | 7 | 2024-01-03 | 342.90 | 8.57 | 2023-12-22 | 9 | 23.75 | 1 | 342.90 | 52 | SO57086 | 2023-12-29 | 27.43 | 213.74 | 38.10 | |||
SO57150_25 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 603 | 85 | 7 | 2024-01-03 | 364.47 | 9.11 | 2023-12-22 | 5 | 53.94 | 1 | 364.47 | 25 | SO57150 | 2023-12-29 | 29.16 | 269.71 | 72.89 | |||
SO58927_27 | BEF7-43AF-A2 | PO15515112432 | 100 | 292 | 237 | 481 | 7 | 2024-02-02 | 119.98 | 3.00 | 2024-01-21 | 4 | 38.49 | 1 | 119.98 | 27 | SO58927 | 2024-01-28 | 9.60 | 153.97 | 29.99 | |||
SO57068_39 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 306 | 632 | 7 | 2024-01-03 | 1619.52 | 40.49 | 2023-12-22 | 2 | 739.04 | 1 | 1619.52 | 39 | SO57068 | 2023-12-29 | 129.56 | 1478.08 | 809.76 | |||
SO58926_24 | B82A-4380-9C | PO15486118845 | 100 | 292 | 544 | 121 | 7 | 2024-02-02 | 242.97 | 6.07 | 2024-01-21 | 5 | 35.96 | 1 | 242.97 | 24 | SO58926 | 2024-01-28 | 19.44 | 179.80 | 48.59 | |||
SO57061_6 | C48C-4776-A7 | PO12702183787 | 100 | 292 | 544 | 175 | 7 | 2024-01-03 | 388.75 | 9.72 | 2023-12-22 | 8 | 35.96 | 1 | 388.75 | 6 | SO57061 | 2023-12-29 | 31.10 | 287.68 | 48.59 | |||
SO57119_14 | 588B-4457-8A | PO3712174757 | 100 | 292 | 564 | 662 | 7 | 2024-01-03 | 2860.88 | 71.52 | 2023-12-22 | 2 | 1481.94 | 1 | 2860.88 | 14 | SO57119 | 2023-12-29 | 228.87 | 2963.88 | 1430.44 | |||
SO57061_12 | C48C-4776-A7 | PO12702183787 | 100 | 292 | 476 | 175 | 7 | 2024-01-03 | 419.94 | 10.50 | 2023-12-22 | 10 | 26.18 | 1 | 419.94 | 12 | SO57061 | 2023-12-29 | 33.60 | 261.76 | 41.99 | |||
SO57086_53 | 9159-4FEC-A8 | PO2668146833 | 100 | 292 | 588 | 535 | 7 | 2024-01-03 | 1385.08 | 34.63 | 2023-12-22 | 3 | 419.78 | 1 | 1385.08 | 53 | SO57086 | 2023-12-29 | 110.81 | 1259.34 | 461.69 | |||
SO57061_54 | C48C-4776-A7 | PO12702183787 | 100 | 292 | 595 | 175 | 7 | 2024-01-03 | 1694.97 | 42.37 | 2023-12-22 | 5 | 308.22 | 1 | 1694.97 | 54 | SO57061 | 2023-12-29 | 135.60 | 1541.09 | 338.99 |
Generated 2024-09-20 10:34:43.500 UTC