[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 4000 SHUFFLE < SKIP 875 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51848_5 | 1298-4CA7-A6 | PO3219116070 | 100 | 282 | 246 | 493 | 4 | 2023-10-02 | 858.90 | 21.47 | 2023-09-20 | 1 | 868.63 | 1 | 858.90 | 5 | SO51848 | 2023-09-27 | 68.71 | 868.63 | 858.90 | |||
SO50231_10 | B2CA-498D-9B | PO11571129150 | 100 | 285 | 456 | 512 | 5 | 2023-07-02 | 44.99 | 1.12 | 2023-06-20 | 1 | 30.93 | 1 | 44.99 | 10 | SO50231 | 2023-06-27 | 3.60 | 30.93 | 44.99 | |||
SO61217_4 | 9B9A-4C8B-93 | PO9889149314 | 100 | 285 | 363 | 494 | 5 | 2024-03-03 | 2753.99 | 68.85 | 2024-02-20 | 2 | 1251.98 | 1 | 2753.99 | 4 | SO61217 | 2024-02-27 | 220.32 | 2503.96 | 1376.99 | |||
SO49513_4 | 1A8D-4D25-AE | PO10962181499 | 19 | 284 | 352 | 685 | 6 | 2023-05-02 | 2485.70 | 62.14 | 2023-04-20 | 2 | 1117.86 | 1 | 2485.70 | 4 | SO49513 | 2023-04-27 | 198.86 | 2235.71 | 1242.85 | |||
SO58996_10 | 5A1A-4E3D-B2 | PO14268110627 | 100 | 281 | 580 | 418 | 3 | 2024-02-01 | 5102.97 | 127.57 | 2024-01-20 | 5 | 1082.51 | 1 | 5102.97 | 10 | SO58996 | 2024-01-27 | 408.24 | 5412.55 | 1020.59 | |||
SO69503_8 | 559D-4568-82 | PO5771124379 | 100 | 282 | 487 | 79 | 3 | 2024-07-02 | 98.98 | 2.47 | 2024-06-20 | 3 | 20.57 | 1 | 98.98 | 8 | SO69503 | 2024-06-27 | 7.92 | 61.70 | 32.99 | |||
SO55245_4 | B5AD-476D-B4 | PO14732112185 | 19 | 291 | 546 | 514 | 6 | 2023-12-02 | 37.25 | 0.93 | 2023-11-20 | 1 | 27.57 | 1 | 37.25 | 4 | SO55245 | 2023-11-27 | 2.98 | 27.57 | 37.25 | |||
SO59065_11 | C012-48E8-A5 | PO8903194371 | 100 | 293 | 234 | 235 | 1 | 2024-02-01 | 119.98 | 3.00 | 2024-01-20 | 4 | 38.49 | 1 | 119.98 | 11 | SO59065 | 2024-01-27 | 9.60 | 153.97 | 29.99 | |||
SO49099_4 | D567-4CCE-A4 | PO15689170019 | 100 | 281 | 375 | 328 | 4 | 2023-04-04 | 2617.88 | 65.45 | 2023-03-23 | 2 | 1320.68 | 1 | 2617.88 | 4 | SO49099 | 2023-03-30 | 209.43 | 2641.37 | 1308.94 | |||
SO50222_15 | 4FDE-4C03-A9 | PO13427181046 | 100 | 292 | 335 | 638 | 7 | 2023-07-02 | 2348.97 | 58.72 | 2023-06-20 | 5 | 486.71 | 1 | 2348.97 | 15 | SO50222 | 2023-06-27 | 187.92 | 2433.53 | 469.79 | |||
SO50676_10 | 66F1-4A9A-97 | PO14790188963 | 19 | 291 | 464 | 497 | 6 | 2023-08-02 | 28.26 | 0.71 | 2023-07-21 | 2 | 9.71 | 1 | 28.26 | 10 | SO50676 | 2023-07-28 | 2.26 | 19.43 | 14.13 | |||
SO49540_11 | FD60-4F29-B7 | PO6757123714 | 100 | 281 | 308 | 21 | 4 | 2023-05-02 | 2232.82 | 55.82 | 2023-04-20 | 3 | 660.91 | 1 | 2232.82 | 11 | SO49540 | 2023-04-27 | 178.63 | 1982.74 | 744.27 | |||
SO46052_11 | 347B-49F0-A8 | PO14529158983 | 100 | 286 | 351 | 289 | 1 | 2022-07-02 | 4049.99 | 101.25 | 2022-06-20 | 2 | 1898.09 | 1 | 4049.99 | 11 | SO46052 | 2022-06-27 | 324.00 | 3796.19 | 2024.99 | |||
SO49473_23 | EAA2-43E2-87 | PO2813142084 | 100 | 283 | 329 | 90 | 5 | 2023-05-02 | 939.59 | 23.49 | 2023-04-20 | 2 | 486.71 | 1 | 939.59 | 23 | SO49473 | 2023-04-27 | 75.17 | 973.41 | 469.79 | |||
SO45298_12 | 7EEC-41A1-9E | PO13572147445 | 100 | 287 | 338 | 527 | 3 | 2022-04-04 | 419.46 | 10.49 | 2022-03-23 | 1 | 413.15 | 1 | 419.46 | 12 | SO45298 | 2022-03-30 | 33.56 | 413.15 | 419.46 | |||
SO48364_6 | 93FF-4A54-BA | PO3886118778 | 100 | 283 | 333 | 165 | 4 | 2023-02-01 | 1409.38 | 35.23 | 2023-01-20 | 3 | 486.71 | 1 | 1409.38 | 6 | SO48364 | 2023-01-27 | 112.75 | 1460.12 | 469.79 | |||
SO51168_10 | 10E0-426C-9D | PO3509110394 | 36 | 292 | 225 | 3 | 139 | 7 | 4.20 | 2023-09-01 | 84.06 | 2.00 | 2023-08-20 | 17 | 6.92 | 1 | 79.85 | 10 | SO51168 | 2023-08-27 | 6.39 | 117.68 | 4.94 | 0.05 |
SO49891_46 | 78CA-4790-95 | PO8410166354 | 98 | 288 | 453 | 538 | 10 | 2023-06-02 | 107.98 | 2.70 | 2023-05-21 | 3 | 24.75 | 1 | 107.98 | 46 | SO49891 | 2023-05-28 | 8.64 | 74.24 | 35.99 | |||
SO71785_17 | 28F9-4101-A1 | PO19169115427 | 100 | 289 | 363 | 272 | 1 | 2024-08-02 | 2753.99 | 68.85 | 2024-07-21 | 2 | 1251.98 | 1 | 2753.99 | 17 | SO71785 | 2024-07-28 | 220.32 | 2503.96 | 1376.99 | |||
SO53477_10 | F1BC-4EF4-85 | PO15544120937 | 19 | 284 | 559 | 282 | 6 | 2023-11-02 | 24.29 | 0.61 | 2023-10-21 | 2 | 8.99 | 1 | 24.29 | 10 | SO53477 | 2023-10-28 | 1.94 | 17.97 | 12.14 | |||
SO71943_21 | E676-4002-A7 | PO9309168525 | 100 | 293 | 566 | 55 | 1 | 2024-08-02 | 445.41 | 11.14 | 2024-07-21 | 1 | 461.44 | 1 | 445.41 | 21 | SO71943 | 2024-07-28 | 35.63 | 461.44 | 445.41 | |||
SO71781_4 | 2FB9-4F05-82 | PO19401117806 | 19 | 291 | 378 | 173 | 6 | 2024-08-02 | 1466.01 | 36.65 | 2024-07-21 | 1 | 1554.95 | 1 | 1466.01 | 4 | SO71781 | 2024-07-28 | 117.28 | 1554.95 | 1466.01 | |||
SO48340_12 | EC75-4D61-8C | PO10962142990 | 19 | 284 | 411 | 685 | 6 | 2023-02-01 | 376.25 | 9.41 | 2023-01-20 | 3 | 92.81 | 1 | 376.25 | 12 | SO48340 | 2023-01-27 | 30.10 | 278.42 | 125.42 | |||
SO61241_7 | 13FB-4126-88 | PO9338116236 | 100 | 293 | 565 | 451 | 1 | 2024-03-03 | 890.82 | 22.27 | 2024-02-20 | 2 | 461.44 | 1 | 890.82 | 7 | SO61241 | 2024-02-27 | 71.27 | 922.89 | 445.41 | |||
SO45322_4 | 83B9-4E36-B7 | PO3857182032 | 100 | 283 | 315 | 256 | 4 | 2022-04-04 | 2624.38 | 65.61 | 2022-03-23 | 3 | 884.71 | 1 | 2624.38 | 4 | SO45322 | 2022-03-30 | 209.95 | 2654.12 | 874.79 | |||
SO69538_1 | 631A-4D82-A8 | PO2117162793 | 19 | 284 | 491 | 444 | 6 | 2024-07-02 | 64.79 | 1.62 | 2024-06-20 | 2 | 41.57 | 1 | 64.79 | 1 | SO69538 | 2024-06-27 | 5.18 | 83.14 | 32.39 | |||
SO50682_28 | 1145-4AD1-B8 | PO12354142084 | 100 | 283 | 410 | 197 | 3 | 2023-08-02 | 36.45 | 0.91 | 2023-07-21 | 1 | 26.97 | 1 | 36.45 | 28 | SO50682 | 2023-07-28 | 2.92 | 26.97 | 36.45 | |||
SO44518_20 | 359F-48A3-B9 | PO12586169040 | 100 | 285 | 304 | 278 | 5 | 2022-01-02 | 1429.41 | 35.74 | 2021-12-21 | 2 | 617.03 | 1 | 1429.41 | 20 | SO44518 | 2021-12-28 | 114.35 | 1234.06 | 714.70 | |||
SO49849_7 | C8F3-4DDE-A6 | PO2552190786 | 100 | 286 | 460 | 506 | 1 | 2023-06-02 | 53.99 | 1.35 | 2023-05-21 | 1 | 37.12 | 1 | 53.99 | 7 | SO49849 | 2023-05-28 | 4.32 | 37.12 | 53.99 | |||
SO51699_7 | 31D5-494C-BA | PO18879118606 | 19 | 291 | 564 | 14 | 64 | 6 | 190.73 | 2023-10-02 | 953.63 | 19.07 | 2023-09-20 | 1 | 1481.94 | 1 | 762.90 | 7 | SO51699 | 2023-09-27 | 61.03 | 1481.94 | 953.63 | 0.20 |
SO50225_27 | 6F8E-49A2-A5 | PO12702153410 | 100 | 292 | 420 | 175 | 7 | 2023-07-02 | 1132.92 | 28.32 | 2023-06-20 | 8 | 104.80 | 1 | 1132.92 | 27 | SO50225 | 2023-06-27 | 90.63 | 838.36 | 141.62 |
Generated 2024-09-20 01:44:19.229 UTC