[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SKIP 0 SHUFFLE < SKIP 1127 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51844_11 | DE76-4481-AA | PO4553182082 | 100 | 282 | 477 | 313 | 4 | 2023-10-03 | 8.98 | 0.22 | 2023-09-21 | 3 | 1.87 | 1 | 8.98 | 11 | SO51844 | 2023-09-28 | 0.72 | 5.60 | 2.99 | |||
SO71890_4 | D31D-413E-BB | PO5510169156 | 100 | 287 | 481 | 5 | 4 | 2024-08-03 | 10.79 | 0.27 | 2024-07-22 | 2 | 3.36 | 1 | 10.79 | 4 | SO71890 | 2024-07-29 | 0.86 | 6.72 | 5.39 | |||
SO65310_8 | 65CB-474A-9D | PO6786169596 | 100 | 281 | 490 | 3 | 4 | 2024-05-03 | 97.18 | 2.43 | 2024-04-21 | 3 | 41.57 | 1 | 97.18 | 8 | SO65310 | 2024-04-28 | 7.77 | 124.72 | 32.39 | |||
SO46338_12 | 0BAC-4D7E-AD | PO15834128897 | 100 | 283 | 328 | 417 | 4 | 2022-08-03 | 1677.84 | 41.95 | 2022-07-22 | 4 | 413.15 | 1 | 1677.84 | 12 | SO46338 | 2022-07-29 | 134.23 | 1652.59 | 419.46 | |||
SO49527_9 | BFD0-4AA2-AF | PO4640129987 | 100 | 287 | 420 | 648 | 4 | 2023-05-03 | 566.46 | 14.16 | 2023-04-21 | 4 | 104.80 | 1 | 566.46 | 9 | SO49527 | 2023-04-28 | 45.32 | 419.18 | 141.62 | |||
SO51154_11 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 255 | 221 | 4 | 2023-09-02 | 404.66 | 10.12 | 2023-08-21 | 2 | 204.63 | 1 | 404.66 | 11 | SO51154 | 2023-08-28 | 32.37 | 409.25 | 202.33 | |||
SO51809_25 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 234 | 309 | 4 | 2023-10-03 | 239.95 | 6.00 | 2023-09-21 | 8 | 38.49 | 1 | 239.95 | 25 | SO51809 | 2023-09-28 | 19.20 | 307.94 | 29.99 | |||
SO53580_14 | FFE9-4F36-B2 | PO4640164085 | 100 | 287 | 587 | 648 | 4 | 2023-11-03 | 2308.47 | 57.71 | 2023-10-22 | 5 | 419.78 | 1 | 2308.47 | 14 | SO53580 | 2023-10-29 | 184.68 | 2098.89 | 461.69 | |||
SO67287_14 | 3F1F-44DB-96 | PO10730119334 | 100 | 287 | 434 | 491 | 4 | 2024-06-03 | 1427.59 | 35.69 | 2024-05-22 | 4 | 360.94 | 1 | 1427.59 | 14 | SO67287 | 2024-05-29 | 114.21 | 1443.77 | 356.90 | |||
SO53616_2 | A692-4827-93 | PO6786150961 | 100 | 281 | 237 | 3 | 4 | 2023-11-03 | 239.95 | 6.00 | 2023-10-22 | 8 | 38.49 | 1 | 239.95 | 2 | SO53616 | 2023-10-29 | 19.20 | 307.94 | 29.99 | |||
SO47369_3 | B6B6-442B-8B | PO16472118462 | 100 | 287 | 385 | 239 | 4 | 2022-11-03 | 3001.31 | 75.03 | 2022-10-22 | 5 | 605.65 | 1 | 3001.31 | 3 | SO47369 | 2022-10-29 | 240.11 | 3028.25 | 600.26 | |||
SO69532_44 | 27FB-4A86-85 | PO3799165791 | 100 | 282 | 487 | 312 | 4 | 2024-07-03 | 131.98 | 3.30 | 2024-06-21 | 4 | 20.57 | 1 | 131.98 | 44 | SO69532 | 2024-06-28 | 10.56 | 82.27 | 32.99 | |||
SO51714_38 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 584 | 328 | 4 | 2023-10-03 | 971.98 | 24.30 | 2023-09-21 | 3 | 343.65 | 1 | 971.98 | 38 | SO51714 | 2023-09-28 | 77.76 | 1030.95 | 323.99 | |||
SO71796_13 | 9A29-45DE-BF | PO17052159664 | 100 | 282 | 561 | 420 | 4 | 2024-08-03 | 4291.33 | 107.28 | 2024-07-22 | 3 | 1481.94 | 1 | 4291.33 | 13 | SO71796 | 2024-07-29 | 343.31 | 4445.81 | 1430.44 | |||
SO48048_21 | B414-46CB-BA | PO3480117933 | 100 | 283 | 417 | 436 | 4 | 2023-01-03 | 1297.81 | 32.45 | 2022-12-22 | 4 | 300.12 | 1 | 1297.81 | 21 | SO48048 | 2022-12-29 | 103.82 | 1200.48 | 324.45 | |||
SO63252_5 | 4233-41A9-B7 | PO6438150148 | 100 | 281 | 591 | 309 | 4 | 2024-04-04 | 338.99 | 8.47 | 2024-03-23 | 1 | 308.22 | 1 | 338.99 | 5 | SO63252 | 2024-03-30 | 27.12 | 308.22 | 338.99 | |||
SO49058_23 | BD1B-4C7F-A9 | PO12499147561 | 100 | 282 | 456 | 78 | 4 | 2023-04-05 | 134.98 | 3.37 | 2023-03-24 | 3 | 30.93 | 1 | 134.98 | 23 | SO49058 | 2023-03-31 | 10.80 | 92.80 | 44.99 | |||
SO58988_1 | 419B-4310-83 | PO16124114660 | 100 | 282 | 583 | 649 | 4 | 2024-02-02 | 1020.59 | 25.51 | 2024-01-21 | 1 | 1082.51 | 1 | 1020.59 | 1 | SO58988 | 2024-01-28 | 81.65 | 1082.51 | 1020.59 | |||
SO43912_15 | 69B6-46F8-A4 | PO7656175368 | 100 | 282 | 285 | 403 | 4 | 2021-10-03 | 178.58 | 4.46 | 2021-09-21 | 1 | 176.20 | 1 | 178.58 | 15 | SO43912 | 2021-09-28 | 14.29 | 176.20 | 178.58 | |||
SO57145_38 | 4C59-4193-B1 | PO3654153385 | 100 | 281 | 475 | 435 | 4 | 2024-01-03 | 41.99 | 1.05 | 2023-12-22 | 1 | 26.18 | 1 | 41.99 | 38 | SO57145 | 2023-12-29 | 3.36 | 26.18 | 41.99 | |||
SO67305_39 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 483 | 3 | 599 | 4 | 56.10 | 2024-06-03 | 1122.00 | 26.65 | 2024-05-22 | 17 | 44.88 | 1 | 1065.90 | 39 | SO67305 | 2024-05-29 | 85.27 | 762.96 | 66.00 | 0.05 |
SO50313_23 | B452-44E9-91 | PO7656143984 | 100 | 282 | 417 | 403 | 4 | 2023-07-03 | 648.91 | 16.22 | 2023-06-21 | 2 | 300.12 | 1 | 648.91 | 23 | SO50313 | 2023-06-28 | 51.91 | 600.24 | 324.45 | |||
SO45301_4 | 0BA8-4928-A7 | PO12499190711 | 100 | 282 | 324 | 78 | 4 | 2022-04-05 | 3355.67 | 83.89 | 2022-03-24 | 8 | 413.15 | 1 | 3355.67 | 4 | SO45301 | 2022-03-31 | 268.45 | 3305.17 | 419.46 | |||
SO65157_13 | 51FF-4A62-89 | PO19372154832 | 100 | 282 | 471 | 582 | 4 | 2024-05-03 | 152.40 | 3.81 | 2024-04-21 | 4 | 23.75 | 1 | 152.40 | 13 | SO65157 | 2024-04-28 | 12.19 | 95.00 | 38.10 | |||
SO46357_3 | EC98-4DEF-A4 | PO667186827 | 100 | 287 | 319 | 365 | 4 | 2022-08-03 | 2624.38 | 65.61 | 2022-07-22 | 3 | 884.71 | 1 | 2624.38 | 3 | SO46357 | 2022-07-29 | 209.95 | 2654.12 | 874.79 | |||
SO44301_24 | 34BE-4E85-85 | PO10730158868 | 100 | 287 | 232 | 491 | 4 | 2021-12-03 | 57.68 | 1.44 | 2021-11-21 | 2 | 31.72 | 1 | 57.68 | 24 | SO44301 | 2021-11-28 | 4.61 | 63.45 | 28.84 | |||
SO45291_11 | 3865-4B93-A6 | PO15689110696 | 100 | 283 | 332 | 328 | 4 | 2022-04-05 | 1677.84 | 41.95 | 2022-03-24 | 4 | 413.15 | 1 | 1677.84 | 11 | SO45291 | 2022-03-31 | 134.23 | 1652.59 | 419.46 | |||
SO49890_38 | 9B22-4240-83 | PO7859114282 | 100 | 272 | 323 | 221 | 4 | 2023-06-03 | 2818.76 | 70.47 | 2023-05-22 | 6 | 486.71 | 1 | 2818.76 | 38 | SO49890 | 2023-05-29 | 225.50 | 2920.24 | 469.79 | |||
SO44509_4 | FAD7-4A4C-B0 | PO15689158248 | 100 | 283 | 212 | 328 | 4 | 2022-01-03 | 60.56 | 1.51 | 2021-12-22 | 3 | 12.03 | 1 | 60.56 | 4 | SO44509 | 2021-12-29 | 4.84 | 36.08 | 20.19 | |||
SO49160_19 | 60E2-486C-AE | PO7656113690 | 100 | 282 | 373 | 403 | 4 | 2023-04-05 | 2617.88 | 65.45 | 2023-03-24 | 2 | 1320.68 | 1 | 2617.88 | 19 | SO49160 | 2023-03-31 | 209.43 | 2641.37 | 1308.94 | |||
SO67292_14 | 09EF-4688-BB | PO551144976 | 100 | 281 | 382 | 4 | 4 | 2024-06-03 | 1344.59 | 33.61 | 2024-05-22 | 2 | 713.08 | 1 | 1344.59 | 14 | SO67292 | 2024-05-29 | 107.57 | 1426.16 | 672.29 |
Generated 2024-09-20 10:32:14.890 UTC