[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE SKIP 2000 < SKIP 516 > < TAKE 15 >
15 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO69442_2 | 9833-459C-A2 | PO11658194725 | 100 | 283 | 516 | 233 | 2 | 2024-07-02 | 117.42 | 2.94 | 2024-06-20 | 5 | 17.38 | 1 | 117.42 | 2 | SO69442 | 2024-06-27 | 9.39 | 86.89 | 23.48 | |||
SO49113_9 | 4C8B-47E0-A7 | PO11658167469 | 100 | 283 | 459 | 233 | 2 | 2023-04-04 | 431.95 | 10.80 | 2023-03-23 | 8 | 37.12 | 1 | 431.95 | 9 | SO49113 | 2023-03-30 | 34.56 | 296.97 | 53.99 | |||
SO46059_3 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 336 | 270 | 2 | 2022-07-02 | 838.92 | 20.97 | 2022-06-20 | 2 | 413.15 | 1 | 838.92 | 3 | SO46059 | 2022-06-27 | 67.11 | 826.29 | 419.46 | |||
SO59012_30 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 496 | 539 | 2 | 2024-02-01 | 1204.69 | 30.12 | 2024-01-20 | 2 | 601.74 | 1 | 1204.69 | 30 | SO59012 | 2024-01-27 | 96.38 | 1203.49 | 602.35 | |||
SO50311_17 | E09E-4D02-9F | PO7453115958 | 100 | 283 | 230 | 108 | 2 | 2023-07-02 | 144.20 | 3.61 | 2023-06-20 | 5 | 29.08 | 1 | 144.20 | 17 | SO50311 | 2023-06-27 | 11.54 | 145.40 | 28.84 | |||
SO44559_13 | 8618-4A1B-AD | PO6641148111 | 100 | 281 | 253 | 342 | 2 | 2022-01-02 | 357.16 | 8.93 | 2021-12-21 | 2 | 176.20 | 1 | 357.16 | 13 | SO44559 | 2021-12-28 | 28.57 | 352.40 | 178.58 | |||
SO51157_24 | 927E-4DB1-A3 | PO3828155781 | 100 | 283 | 511 | 414 | 2 | 2023-09-01 | 2184.54 | 54.61 | 2023-08-20 | 10 | 199.38 | 1 | 2184.54 | 24 | SO51157 | 2023-08-27 | 174.76 | 1993.76 | 218.45 | |||
SO65152_5 | 9C5B-4E79-98 | PO20213135029 | 100 | 283 | 583 | 216 | 2 | 2024-05-02 | 2041.19 | 51.03 | 2024-04-20 | 2 | 1082.51 | 1 | 2041.19 | 5 | SO65152 | 2024-04-27 | 163.30 | 2165.02 | 1020.59 | |||
SO59012_48 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 560 | 539 | 2 | 2024-02-01 | 4373.46 | 109.34 | 2024-01-20 | 6 | 755.15 | 1 | 4373.46 | 48 | SO59012 | 2024-01-27 | 349.88 | 4530.90 | 728.91 | |||
SO47450_9 | 7E50-416D-A2 | PO9483124566 | 100 | 281 | 373 | 54 | 2 | 2022-11-02 | 2617.88 | 65.45 | 2022-10-21 | 2 | 1320.68 | 1 | 2617.88 | 9 | SO47450 | 2022-10-28 | 209.43 | 2641.37 | 1308.94 | |||
SO45562_2 | 75B5-4F4F-84 | PO4756131313 | 100 | 281 | 324 | 126 | 2 | 2022-05-02 | 419.46 | 10.49 | 2022-04-20 | 1 | 413.15 | 1 | 419.46 | 2 | SO45562 | 2022-04-27 | 33.56 | 413.15 | 419.46 | |||
SO65245_23 | 80F6-437F-84 | PO9628129233 | 100 | 283 | 234 | 179 | 2 | 2024-05-02 | 29.99 | 0.75 | 2024-04-20 | 1 | 38.49 | 1 | 29.99 | 23 | SO65245 | 2024-04-27 | 2.40 | 38.49 | 29.99 | |||
SO51111_11 | 5E49-4F77-BB | PO11484190487 | 100 | 283 | 474 | 4 | 594 | 2 | 108.48 | 2023-09-01 | 1084.85 | 24.41 | 2023-08-20 | 31 | 26.18 | 1 | 976.36 | 11 | SO51111 | 2023-08-27 | 78.11 | 811.47 | 35.00 | 0.10 |
SO48336_38 | 48F2-4141-9A | PO11455111823 | 100 | 281 | 329 | 72 | 2 | 2023-02-01 | 939.59 | 23.49 | 2023-01-20 | 2 | 486.71 | 1 | 939.59 | 38 | SO48336 | 2023-01-27 | 75.17 | 973.41 | 469.79 | |||
SO49113_34 | 4C8B-47E0-A7 | PO11658167469 | 100 | 283 | 395 | 233 | 2 | 2023-04-04 | 122.75 | 3.07 | 2023-03-23 | 2 | 45.42 | 1 | 122.75 | 34 | SO49113 | 2023-03-30 | 9.82 | 90.83 | 61.37 |
Generated 2024-09-20 02:34:22.143 UTC