[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 5562 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46351_1 | 9218-4521-8F | PO11107115959 | 19 | 284 | 315 | 156 | 6 | 2022-09-23 | 874.79 | 21.87 | 2022-09-11 | 1 | 884.71 | 1 | 874.79 | 1 | SO46351 | 2022-09-18 | 69.98 | 884.71 | 874.79 | |||
SO46953_27 | C650-4C32-BE | PO17603154442 | 19 | 284 | 236 | 2 | 12 | 6 | 6.69 | 2022-11-23 | 334.55 | 8.20 | 2022-11-11 | 12 | 29.08 | 1 | 327.86 | 27 | SO46953 | 2022-11-18 | 26.23 | 348.97 | 27.88 | 0.02 |
SO58932_8 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 480 | 408 | 6 | 2024-03-24 | 5.50 | 0.14 | 2024-03-12 | 4 | 0.86 | 1 | 5.50 | 8 | SO58932 | 2024-03-19 | 0.44 | 3.43 | 1.37 | |||
SO45553_4 | 87C3-40D7-80 | PO1885177550 | 19 | 284 | 349 | 588 | 6 | 2022-06-23 | 10124.97 | 253.12 | 2022-06-11 | 5 | 1898.09 | 1 | 10124.97 | 4 | SO45553 | 2022-06-18 | 810.00 | 9490.47 | 2024.99 | |||
SO51791_39 | DAF1-41B6-96 | PO18328158624 | 19 | 284 | 546 | 552 | 6 | 2023-11-23 | 74.51 | 1.86 | 2023-11-11 | 2 | 27.57 | 1 | 74.51 | 39 | SO51791 | 2023-11-18 | 5.96 | 55.14 | 37.25 | |||
SO46064_6 | EC45-4C82-8B | PO11020129544 | 19 | 284 | 322 | 336 | 6 | 2022-08-23 | 2097.29 | 52.43 | 2022-08-11 | 5 | 413.15 | 1 | 2097.29 | 6 | SO46064 | 2022-08-18 | 167.78 | 2065.73 | 419.46 | |||
SO71829_10 | 427E-46EE-B0 | PO10962123279 | 19 | 284 | 591 | 16 | 685 | 6 | 90.40 | 2024-09-23 | 226.00 | 3.39 | 2024-09-11 | 2 | 308.22 | 1 | 135.60 | 10 | SO71829 | 2024-09-18 | 10.85 | 616.44 | 113.00 | 0.40 |
SO46953_28 | C650-4C32-BE | PO17603154442 | 19 | 284 | 415 | 12 | 6 | 2022-11-23 | 792.14 | 19.80 | 2022-11-11 | 4 | 146.55 | 1 | 792.14 | 28 | SO46953 | 2022-11-18 | 63.37 | 586.19 | 198.04 | |||
SO55245_21 | B5AD-476D-B4 | PO14732112185 | 19 | 291 | 243 | 514 | 6 | 2024-01-23 | 1717.80 | 42.95 | 2024-01-11 | 2 | 868.63 | 1 | 1717.80 | 21 | SO55245 | 2024-01-18 | 137.42 | 1737.27 | 858.90 | |||
SO58914_19 | 8547-437A-B2 | PO17545129441 | 19 | 291 | 378 | 155 | 6 | 2024-03-24 | 10262.07 | 256.55 | 2024-03-12 | 7 | 1554.95 | 1 | 10262.07 | 19 | SO58914 | 2024-03-19 | 820.97 | 10884.64 | 1466.01 | |||
SO49879_31 | 7A79-4FB0-85 | PO4495112714 | 19 | 291 | 305 | 496 | 6 | 2023-07-24 | 2208.44 | 55.21 | 2023-07-12 | 3 | 653.70 | 1 | 2208.44 | 31 | SO49879 | 2023-07-19 | 176.67 | 1961.09 | 736.15 | |||
SO58957_9 | 13BB-49DB-84 | PO10962177270 | 19 | 284 | 596 | 685 | 6 | 2024-03-24 | 323.99 | 8.10 | 2024-03-12 | 1 | 294.58 | 1 | 323.99 | 9 | SO58957 | 2024-03-19 | 25.92 | 294.58 | 323.99 | |||
SO43888_7 | 7AED-4154-93 | PO2088113013 | 19 | 288 | 314 | 136 | 6 | 2021-11-23 | 2146.96 | 53.67 | 2021-11-11 | 1 | 2171.29 | 1 | 2146.96 | 7 | SO43888 | 2021-11-18 | 171.76 | 2171.29 | 2146.96 | |||
SO51703_17 | 53F7-4B59-AA | PO17603160217 | 19 | 284 | 287 | 12 | 6 | 2023-11-23 | 404.66 | 10.12 | 2023-11-11 | 2 | 204.63 | 1 | 404.66 | 17 | SO51703 | 2023-11-18 | 32.37 | 409.25 | 202.33 | |||
SO53463_3 | 39D5-46C9-80 | PO17690192070 | 19 | 291 | 474 | 2 | 47 | 6 | 8.93 | 2023-12-24 | 446.54 | 10.94 | 2023-12-12 | 11 | 26.18 | 1 | 437.61 | 3 | SO53463 | 2023-12-19 | 35.01 | 287.94 | 40.59 | 0.02 |
SO48761_31 | E39C-4A4E-A3 | PO15312195795 | 19 | 291 | 263 | 299 | 6 | 2023-04-25 | 607.00 | 15.17 | 2023-04-13 | 3 | 187.16 | 1 | 607.00 | 31 | SO48761 | 2023-04-20 | 48.56 | 561.47 | 202.33 | |||
SO67295_9 | D785-46A0-BC | PO1711155302 | 19 | 291 | 353 | 245 | 6 | 2024-07-24 | 8351.96 | 208.80 | 2024-07-12 | 6 | 1265.62 | 1 | 8351.96 | 9 | SO67295 | 2024-07-19 | 668.16 | 7593.72 | 1391.99 | |||
SO45792_5 | D5D3-43B4-A2 | PO13862173868 | 19 | 288 | 292 | 119 | 6 | 2022-07-24 | 1637.40 | 40.94 | 2022-07-12 | 2 | 706.81 | 1 | 1637.40 | 5 | SO45792 | 2022-07-19 | 130.99 | 1413.62 | 818.70 | |||
SO44103_4 | 5754-4536-B8 | PO11107175113 | 19 | 284 | 232 | 156 | 6 | 2021-12-24 | 28.84 | 0.72 | 2021-12-12 | 1 | 31.72 | 1 | 28.84 | 4 | SO44103 | 2021-12-19 | 2.31 | 31.72 | 28.84 | |||
SO46940_30 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 381 | 479 | 6 | 2022-11-23 | 1800.79 | 45.02 | 2022-11-11 | 3 | 605.65 | 1 | 1800.79 | 30 | SO46940 | 2022-11-18 | 144.06 | 1816.95 | 600.26 | |||
SO63177_18 | 87AD-4113-AD | PO1856115383 | 19 | 291 | 492 | 263 | 6 | 2024-05-25 | 1204.69 | 30.12 | 2024-05-13 | 2 | 601.74 | 1 | 1204.69 | 18 | SO63177 | 2024-05-20 | 96.38 | 1203.49 | 602.35 | |||
SO44282_12 | 57B6-44F8-98 | PO18473177808 | 19 | 288 | 296 | 442 | 6 | 2022-01-23 | 714.70 | 17.87 | 2022-01-11 | 1 | 617.03 | 1 | 714.70 | 12 | SO44282 | 2022-01-18 | 57.18 | 617.03 | 714.70 | |||
SO61248_30 | 67A0-4D10-87 | PO4495126386 | 19 | 291 | 400 | 496 | 6 | 2024-04-24 | 111.46 | 2.79 | 2024-04-12 | 3 | 27.49 | 1 | 111.46 | 30 | SO61248 | 2024-04-19 | 8.92 | 82.48 | 37.15 | |||
SO46614_57 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 385 | 299 | 6 | 2022-10-23 | 1800.79 | 45.02 | 2022-10-11 | 3 | 605.65 | 1 | 1800.79 | 57 | SO46614 | 2022-10-18 | 144.06 | 1816.95 | 600.26 | |||
SO51132_34 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 481 | 227 | 6 | 2023-10-23 | 5.39 | 0.13 | 2023-10-11 | 1 | 3.36 | 1 | 5.39 | 34 | SO51132 | 2023-10-18 | 0.43 | 3.36 | 5.39 | |||
SO50250_5 | D67C-4BB1-92 | PO2117115526 | 19 | 284 | 224 | 444 | 6 | 2023-08-23 | 5.19 | 0.13 | 2023-08-11 | 1 | 5.23 | 1 | 5.19 | 5 | SO50250 | 2023-08-18 | 0.41 | 5.23 | 5.19 | |||
SO46035_1 | F6D4-48D1-A2 | PO18270199753 | 19 | 288 | 219 | 11 | 6 | 2022-08-23 | 11.40 | 0.29 | 2022-08-11 | 2 | 3.40 | 1 | 11.40 | 1 | SO46035 | 2022-08-18 | 0.91 | 6.79 | 5.70 | |||
SO71828_16 | 73A0-490C-B1 | PO11194153355 | 19 | 284 | 503 | 48 | 6 | 2024-09-23 | 200.05 | 5.00 | 2024-09-11 | 1 | 199.85 | 1 | 200.05 | 16 | SO71828 | 2024-09-18 | 16.00 | 199.85 | 200.05 | |||
SO48036_25 | AB80-4ACE-AF | PO1914139946 | 19 | 284 | 335 | 66 | 6 | 2023-02-23 | 939.59 | 23.49 | 2023-02-11 | 2 | 486.71 | 1 | 939.59 | 25 | SO48036 | 2023-02-18 | 75.17 | 973.41 | 469.79 | |||
SO46086_15 | 56A8-4607-A0 | PO4901123378 | 19 | 284 | 324 | 84 | 6 | 2022-08-23 | 838.92 | 20.97 | 2022-08-11 | 2 | 413.15 | 1 | 838.92 | 15 | SO46086 | 2022-08-18 | 67.11 | 826.29 | 419.46 | |||
SO46657_54 | CA71-4EDF-A1 | PO4495116659 | 19 | 291 | 213 | 8 | 496 | 6 | 8.41 | 2022-10-23 | 84.11 | 1.89 | 2022-10-11 | 5 | 13.88 | 1 | 75.70 | 54 | SO46657 | 2022-10-18 | 6.06 | 69.39 | 16.82 | 0.10 |
Generated 2024-11-10 12:09:51.990 UTC