[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'USD' > SHUFFLE SKIP 0 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO65252_17 | F817-49F6-A9 | PO12470159616 | 100 | 287 | 566 | 672 | 1 | 2024-05-17 | 445.41 | 11.14 | 2024-05-05 | 1 | 461.44 | 1 | 445.41 | 17 | SO65252 | 2024-05-12 | 35.63 | 461.44 | 445.41 | |||
SO50745_9 | 02DB-4CC5-85 | PO5539140407 | 100 | 282 | 401 | 61 | 4 | 2023-08-17 | 196.81 | 4.92 | 2023-08-05 | 3 | 48.55 | 1 | 196.81 | 9 | SO50745 | 2023-08-12 | 15.74 | 145.64 | 65.60 | |||
SO50682_28 | 1145-4AD1-B8 | PO12354142084 | 100 | 283 | 410 | 197 | 3 | 2023-08-17 | 36.45 | 0.91 | 2023-08-05 | 1 | 26.97 | 1 | 36.45 | 28 | SO50682 | 2023-08-12 | 2.92 | 26.97 | 36.45 | |||
SO50304_19 | 9338-4FCD-A5 | PO5771132420 | 100 | 282 | 414 | 79 | 3 | 2023-07-17 | 745.16 | 18.63 | 2023-07-05 | 5 | 110.28 | 1 | 745.16 | 19 | SO50304 | 2023-07-12 | 59.61 | 551.41 | 149.03 | |||
SO55249_54 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 588 | 475 | 4 | 2023-12-17 | 2308.47 | 57.71 | 2023-12-05 | 5 | 419.78 | 1 | 2308.47 | 54 | SO55249 | 2023-12-12 | 184.68 | 2098.89 | 461.69 | |||
SO45273_6 | E67F-4741-8D | PO18908136254 | 100 | 289 | 347 | 164 | 1 | 2022-04-19 | 4079.99 | 102.00 | 2022-04-07 | 2 | 1912.15 | 1 | 4079.99 | 6 | SO45273 | 2022-04-14 | 326.40 | 3824.31 | 2039.99 | |||
SO71882_24 | D5D4-42D4-91 | PO5597123008 | 100 | 281 | 222 | 75 | 4 | 2024-08-17 | 41.99 | 1.05 | 2024-08-05 | 2 | 13.09 | 1 | 41.99 | 24 | SO71882 | 2024-08-12 | 3.36 | 26.17 | 20.99 | |||
SO65232_24 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 357 | 490 | 4 | 2024-05-17 | 1391.99 | 34.80 | 2024-05-05 | 1 | 1265.62 | 1 | 1391.99 | 24 | SO65232 | 2024-05-12 | 111.36 | 1265.62 | 1391.99 | |||
SO51856_10 | E170-419C-92 | PO3654183134 | 100 | 281 | 555 | 435 | 4 | 2023-10-17 | 127.80 | 3.20 | 2023-10-05 | 2 | 47.29 | 1 | 127.80 | 10 | SO51856 | 2023-10-12 | 10.22 | 94.57 | 63.90 | |||
SO48071_10 | E6F7-41F8-92 | PO6525193011 | 100 | 283 | 409 | 345 | 4 | 2023-01-17 | 627.77 | 15.69 | 2023-01-05 | 3 | 185.82 | 1 | 627.77 | 10 | SO48071 | 2023-01-12 | 50.22 | 557.46 | 209.26 | |||
SO44119_10 | 6300-4202-8C | PO4640166555 | 100 | 287 | 215 | 648 | 4 | 2021-11-17 | 60.56 | 1.51 | 2021-11-05 | 3 | 12.03 | 1 | 60.56 | 10 | SO44119 | 2021-11-12 | 4.84 | 36.08 | 20.19 | |||
SO69451_8 | EE16-4615-B7 | PO9918189570 | 100 | 285 | 568 | 260 | 5 | 2024-07-17 | 890.82 | 22.27 | 2024-07-05 | 2 | 461.44 | 1 | 890.82 | 8 | SO69451 | 2024-07-12 | 71.27 | 922.89 | 445.41 | |||
SO55264_21 | 80F3-4A7B-A2 | PO10730163005 | 100 | 287 | 581 | 491 | 4 | 2023-12-17 | 5102.97 | 127.57 | 2023-12-05 | 5 | 1082.51 | 1 | 5102.97 | 21 | SO55264 | 2023-12-12 | 408.24 | 5412.55 | 1020.59 | |||
SO49155_1 | 4D9E-400E-85 | PO6351171296 | 100 | 281 | 377 | 255 | 4 | 2023-04-19 | 1308.94 | 32.72 | 2023-04-07 | 1 | 1320.68 | 1 | 1308.94 | 1 | SO49155 | 2023-04-14 | 104.72 | 1320.68 | 1308.94 | |||
SO71889_17 | 79BB-4639-B8 | PO6786144643 | 100 | 281 | 436 | 3 | 4 | 2024-08-17 | 1070.69 | 26.77 | 2024-08-05 | 3 | 360.94 | 1 | 1070.69 | 17 | SO71889 | 2024-08-12 | 85.66 | 1082.83 | 356.90 | |||
SO51089_35 | A635-4BAF-BC | PO16588151558 | 100 | 289 | 511 | 146 | 1 | 2023-09-16 | 1310.72 | 32.77 | 2023-09-04 | 6 | 199.38 | 1 | 1310.72 | 35 | SO51089 | 2023-09-11 | 104.86 | 1196.25 | 218.45 | |||
SO69450_13 | 7050-466D-9B | PO10121172172 | 100 | 283 | 382 | 684 | 2 | 2024-07-17 | 1344.59 | 33.61 | 2024-07-05 | 2 | 713.08 | 1 | 1344.59 | 13 | SO69450 | 2024-07-12 | 107.57 | 1426.16 | 672.29 | |||
SO45556_6 | A9AB-44F3-9F | PO3190111178 | 100 | 281 | 315 | 575 | 2 | 2022-05-17 | 1749.59 | 43.74 | 2022-05-05 | 2 | 884.71 | 1 | 1749.59 | 6 | SO45556 | 2022-05-12 | 139.97 | 1769.42 | 874.79 | |||
SO49821_30 | 0B9B-460C-BC | PO551117366 | 100 | 281 | 273 | 4 | 4 | 2023-06-17 | 809.33 | 20.23 | 2023-06-05 | 4 | 187.16 | 1 | 809.33 | 30 | SO49821 | 2023-06-12 | 64.75 | 748.63 | 202.33 | |||
SO46058_7 | FA37-4F46-97 | PO12557123934 | 100 | 282 | 316 | 240 | 4 | 2022-07-17 | 2624.38 | 65.61 | 2022-07-05 | 3 | 884.71 | 1 | 2624.38 | 7 | SO46058 | 2022-07-12 | 209.95 | 2654.12 | 874.79 | |||
SO63180_15 | B8CD-47BA-8C | PO2523117609 | 100 | 287 | 225 | 167 | 4 | 2024-04-18 | 5.39 | 0.13 | 2024-04-06 | 1 | 6.92 | 1 | 5.39 | 15 | SO63180 | 2024-04-13 | 0.43 | 6.92 | 5.39 | |||
SO51778_3 | 420A-4268-A8 | PO3161175221 | 100 | 283 | 287 | 359 | 2 | 2023-10-17 | 202.33 | 5.06 | 2023-10-05 | 1 | 204.63 | 1 | 202.33 | 3 | SO51778 | 2023-10-12 | 16.19 | 204.63 | 202.33 | |||
SO67305_11 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 497 | 599 | 4 | 2024-06-17 | 1204.69 | 30.12 | 2024-06-05 | 2 | 601.74 | 1 | 1204.69 | 11 | SO67305 | 2024-06-12 | 96.38 | 1203.49 | 602.35 | |||
SO57030_33 | 373C-4C0F-88 | PO16414180321 | 100 | 289 | 363 | 236 | 1 | 2024-01-17 | 4130.98 | 103.27 | 2024-01-05 | 3 | 1251.98 | 1 | 4130.98 | 33 | SO57030 | 2024-01-12 | 330.48 | 3755.94 | 1376.99 | |||
SO63194_15 | A6B4-4109-B0 | PO15370118285 | 100 | 281 | 517 | 381 | 3 | 2024-04-18 | 63.17 | 1.58 | 2024-04-06 | 2 | 23.37 | 1 | 63.17 | 15 | SO63194 | 2024-04-13 | 5.05 | 46.74 | 31.58 | |||
SO45309_10 | 4B9D-4285-B7 | PO10121162847 | 100 | 281 | 275 | 684 | 2 | 2022-04-19 | 713.80 | 17.84 | 2022-04-07 | 2 | 352.14 | 1 | 713.80 | 10 | SO45309 | 2022-04-14 | 57.10 | 704.28 | 356.90 | |||
SO71845_16 | 4781-4673-85 | PO2697119362 | 100 | 282 | 558 | 187 | 4 | 2024-08-17 | 242.99 | 6.07 | 2024-08-05 | 1 | 179.82 | 1 | 242.99 | 16 | SO71845 | 2024-08-12 | 19.44 | 179.82 | 242.99 | |||
SO47448_2 | C2B1-450C-8E | PO8294198801 | 100 | 289 | 411 | 488 | 1 | 2022-11-17 | 125.42 | 3.14 | 2022-11-05 | 1 | 92.81 | 1 | 125.42 | 2 | SO47448 | 2022-11-12 | 10.03 | 92.81 | 125.42 | |||
SO51857_38 | 918B-493C-BA | PO3683131763 | 100 | 292 | 555 | 2 | 85 | 7 | 16.06 | 2023-10-17 | 803.01 | 19.67 | 2023-10-05 | 13 | 47.29 | 1 | 786.95 | 38 | SO51857 | 2023-10-12 | 62.96 | 614.72 | 61.77 | 0.02 |
SO46377_14 | A45C-4A20-BA | PO6786151653 | 100 | 283 | 253 | 3 | 4 | 2022-08-17 | 357.16 | 8.93 | 2022-08-05 | 2 | 176.20 | 1 | 357.16 | 14 | SO46377 | 2022-08-12 | 28.57 | 352.40 | 178.58 | |||
SO50672_20 | 1BE9-437C-8A | PO16472110144 | 100 | 287 | 286 | 239 | 4 | 2023-08-17 | 367.88 | 9.20 | 2023-08-05 | 2 | 170.14 | 1 | 367.88 | 20 | SO50672 | 2023-08-12 | 29.43 | 340.29 | 183.94 |
Generated 2024-10-04 23:06:34.447 UTC