[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '10' > SHUFFLE SKIP 2000 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47451_14 | 6525-4619-9A | PO8671131661 | 98 | 288 | 410 | 502 | 10 | 2022-11-03 | 218.68 | 5.47 | 2022-10-22 | 6 | 26.97 | 1 | 218.68 | 14 | SO47451 | 2022-10-29 | 17.49 | 161.82 | 36.45 | |||
SO57166_1 | 1E7B-4AA0-99 | PO1218174520 | 98 | 288 | 408 | 412 | 10 | 2024-01-03 | 72.16 | 1.80 | 2023-12-22 | 1 | 53.40 | 1 | 72.16 | 1 | SO57166 | 2023-12-29 | 5.77 | 53.40 | 72.16 | |||
SO65271_12 | 11E0-45B2-93 | PO8468172113 | 98 | 288 | 374 | 16 | 10 | 2024-05-03 | 1466.01 | 36.65 | 2024-04-21 | 1 | 1554.95 | 1 | 1466.01 | 12 | SO65271 | 2024-04-28 | 117.28 | 1554.95 | 1466.01 | |||
SO47402_10 | 1B50-4114-8C | PO10295132665 | 98 | 288 | 358 | 322 | 10 | 2022-11-03 | 2458.92 | 61.47 | 2022-10-22 | 2 | 1105.81 | 1 | 2458.92 | 10 | SO47402 | 2022-10-29 | 196.71 | 2211.62 | 1229.46 | |||
SO47004_47 | BB9D-49AE-A9 | PO928175019 | 98 | 290 | 391 | 484 | 10 | 2022-10-03 | 266.80 | 6.67 | 2022-09-21 | 3 | 65.81 | 1 | 266.80 | 47 | SO47004 | 2022-09-28 | 21.34 | 197.43 | 88.93 | |||
SO55323_11 | 7398-4A3C-BE | PO8410135313 | 98 | 288 | 225 | 2 | 538 | 10 | 1.25 | 2023-12-03 | 62.57 | 1.53 | 2023-11-21 | 12 | 6.92 | 1 | 61.32 | 11 | SO55323 | 2023-11-28 | 4.91 | 83.07 | 5.21 | 0.02 |
SO50281_1 | 165A-47D3-A3 | PO8584140957 | 98 | 288 | 343 | 592 | 10 | 2023-07-03 | 469.79 | 11.74 | 2023-06-21 | 1 | 486.71 | 1 | 469.79 | 1 | SO50281 | 2023-06-28 | 37.58 | 486.71 | 469.79 | |||
SO65271_15 | 11E0-45B2-93 | PO8468172113 | 98 | 288 | 491 | 16 | 10 | 2024-05-03 | 194.36 | 4.86 | 2024-04-21 | 6 | 41.57 | 1 | 194.36 | 15 | SO65271 | 2024-04-28 | 15.55 | 249.43 | 32.39 | |||
SO53455_3 | ACD7-4AF3-84 | PO19604185529 | 98 | 288 | 309 | 340 | 10 | 2023-11-03 | 818.70 | 20.47 | 2023-10-22 | 1 | 747.20 | 1 | 818.70 | 3 | SO53455 | 2023-10-29 | 65.50 | 747.20 | 818.70 | |||
SO63241_12 | 2A80-4F60-8C | PO8642159891 | 98 | 288 | 502 | 520 | 10 | 2024-04-04 | 600.16 | 15.00 | 2024-03-23 | 3 | 199.85 | 1 | 600.16 | 12 | SO63241 | 2024-03-30 | 48.01 | 599.56 | 200.05 | |||
SO53574_13 | A501-443D-A3 | PO6119138590 | 98 | 288 | 214 | 268 | 10 | 2023-11-03 | 41.99 | 1.05 | 2023-10-22 | 2 | 13.09 | 1 | 41.99 | 13 | SO53574 | 2023-10-29 | 3.36 | 26.17 | 20.99 | |||
SO48293_16 | 85D2-4CB9-A6 | PO19604177614 | 98 | 288 | 365 | 340 | 10 | 2023-02-02 | 2591.98 | 64.80 | 2023-01-21 | 4 | 598.44 | 1 | 2591.98 | 16 | SO48293 | 2023-01-28 | 207.36 | 2393.74 | 647.99 | |||
SO49546_2 | 4650-40B4-94 | PO8700111385 | 98 | 288 | 469 | 665 | 10 | 2023-05-03 | 22.79 | 0.57 | 2023-04-21 | 1 | 15.67 | 1 | 22.79 | 2 | SO49546 | 2023-04-28 | 1.82 | 15.67 | 22.79 | |||
SO71936_46 | 95F1-4758-A0 | PO8671170385 | 98 | 288 | 516 | 502 | 10 | 2024-08-03 | 140.90 | 3.52 | 2024-07-22 | 6 | 17.38 | 1 | 140.90 | 46 | SO71936 | 2024-07-29 | 11.27 | 104.27 | 23.48 | |||
SO63241_11 | 2A80-4F60-8C | PO8642159891 | 98 | 288 | 560 | 520 | 10 | 2024-04-04 | 728.91 | 18.22 | 2024-03-23 | 1 | 755.15 | 1 | 728.91 | 11 | SO63241 | 2024-03-30 | 58.31 | 755.15 | 728.91 | |||
SO49062_25 | D3FD-415F-A5 | PO928133820 | 98 | 288 | 459 | 484 | 10 | 2023-04-05 | 161.98 | 4.05 | 2023-03-24 | 3 | 37.12 | 1 | 161.98 | 25 | SO49062 | 2023-03-31 | 12.96 | 111.36 | 53.99 | |||
SO69563_7 | 6FE3-49A9-94 | PO8729151832 | 98 | 288 | 573 | 556 | 10 | 2024-07-03 | 7152.21 | 178.81 | 2024-06-21 | 5 | 1481.94 | 1 | 7152.21 | 7 | SO69563 | 2024-06-28 | 572.18 | 7409.69 | 1430.44 | |||
SO46669_27 | 7080-4FDD-BD | PO8410183627 | 98 | 288 | 335 | 538 | 10 | 2022-09-02 | 1879.18 | 46.98 | 2022-08-21 | 4 | 486.71 | 1 | 1879.18 | 27 | SO46669 | 2022-08-28 | 150.33 | 1946.83 | 469.79 | |||
SO48389_17 | 304D-46A7-8E | PO8671159284 | 98 | 288 | 294 | 502 | 10 | 2023-02-02 | 2977.09 | 74.43 | 2023-01-21 | 4 | 660.91 | 1 | 2977.09 | 17 | SO48389 | 2023-01-28 | 238.17 | 2643.66 | 744.27 | |||
SO49062_20 | D3FD-415F-A5 | PO928133820 | 98 | 288 | 421 | 484 | 10 | 2023-04-05 | 588.99 | 14.72 | 2023-03-24 | 3 | 145.28 | 1 | 588.99 | 20 | SO49062 | 2023-03-31 | 47.12 | 435.85 | 196.33 | |||
SO57180_14 | 32F1-420E-BD | PO8642124468 | 98 | 288 | 565 | 520 | 10 | 2024-01-03 | 3563.28 | 89.08 | 2023-12-22 | 8 | 461.44 | 1 | 3563.28 | 14 | SO57180 | 2023-12-29 | 285.06 | 3691.56 | 445.41 | |||
SO51819_6 | 66F0-43DA-B7 | PO8758166190 | 98 | 288 | 542 | 683 | 10 | 2023-10-03 | 48.59 | 1.21 | 2023-09-21 | 2 | 17.98 | 1 | 48.59 | 6 | SO51819 | 2023-09-28 | 3.89 | 35.96 | 24.29 | |||
SO57083_27 | 37CC-47DA-BC | PO1508182511 | 98 | 288 | 605 | 430 | 10 | 2024-01-03 | 971.98 | 24.30 | 2023-12-22 | 3 | 343.65 | 1 | 971.98 | 27 | SO57083 | 2023-12-29 | 77.76 | 1030.95 | 323.99 | |||
SO59063_24 | 81BA-420E-80 | PO8468196044 | 98 | 288 | 488 | 16 | 10 | 2024-02-02 | 129.58 | 3.24 | 2024-01-21 | 4 | 41.57 | 1 | 129.58 | 24 | SO59063 | 2024-01-28 | 10.37 | 166.29 | 32.39 | |||
SO65177_14 | 1619-495E-81 | PO16501143019 | 98 | 288 | 434 | 142 | 10 | 2024-05-03 | 1784.49 | 44.61 | 2024-04-21 | 5 | 360.94 | 1 | 1784.49 | 14 | SO65177 | 2024-04-28 | 142.76 | 1804.71 | 356.90 | |||
SO53577_12 | A44D-449C-80 | PO5713160840 | 98 | 288 | 560 | 52 | 10 | 2023-11-03 | 1457.82 | 36.45 | 2023-10-22 | 2 | 755.15 | 1 | 1457.82 | 12 | SO53577 | 2023-10-29 | 116.63 | 1510.30 | 728.91 | |||
SO63170_27 | 9588-481B-B3 | PO957184615 | 98 | 288 | 476 | 376 | 10 | 2024-04-04 | 167.98 | 4.20 | 2024-03-23 | 4 | 26.18 | 1 | 167.98 | 27 | SO63170 | 2024-03-30 | 13.44 | 104.71 | 41.99 | |||
SO58959_15 | 1330-4B17-AF | PO10353115061 | 98 | 288 | 531 | 88 | 10 | 2024-02-02 | 149.87 | 3.75 | 2024-01-21 | 1 | 136.79 | 1 | 149.87 | 15 | SO58959 | 2024-01-28 | 11.99 | 136.79 | 149.87 | |||
SO63241_15 | 2A80-4F60-8C | PO8642159891 | 98 | 288 | 569 | 520 | 10 | 2024-04-04 | 890.82 | 22.27 | 2024-03-23 | 2 | 461.44 | 1 | 890.82 | 15 | SO63241 | 2024-03-30 | 71.27 | 922.89 | 445.41 | |||
SO63242_1 | 1658-46BE-99 | PO8758113817 | 98 | 290 | 476 | 683 | 10 | 2024-04-04 | 167.98 | 4.20 | 2024-03-23 | 4 | 26.18 | 1 | 167.98 | 1 | SO63242 | 2024-03-30 | 13.44 | 104.71 | 41.99 | |||
SO67289_41 | 5B09-42E8-A1 | PO10324110444 | 98 | 288 | 309 | 196 | 10 | 2024-06-03 | 2456.10 | 61.40 | 2024-05-22 | 3 | 747.20 | 1 | 2456.10 | 41 | SO67289 | 2024-05-29 | 196.49 | 2241.60 | 818.70 |
Generated 2024-09-20 07:28:23.124 UTC