[ROOT] dt FactResellerSale < WHERE DimCurrency.AlternateKey EQ 'USD' > SHUFFLE SKIP 0 > < TAKE 62 >
62 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO67277_49 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 484 | 530 | 5 | 2024-03-18 | 14.31 | 0.36 | 2024-03-06 | 3 | 2.97 | 1 | 14.31 | 49 | SO67277 | 2024-03-13 | 1.14 | 8.92 | 4.77 | |||
SO47403_15 | 60A2-4F08-8B | PO841143108 | 100 | 286 | 297 | 254 | 1 | 2022-08-18 | 5153.02 | 128.83 | 2022-08-06 | 7 | 653.70 | 1 | 5153.02 | 15 | SO47403 | 2022-08-13 | 412.24 | 4575.88 | 736.15 | |||
SO50696_3 | C32F-4FEE-A3 | PO1624119214 | 100 | 281 | 381 | 579 | 3 | 2023-05-18 | 1800.79 | 45.02 | 2023-05-06 | 3 | 605.65 | 1 | 1800.79 | 3 | SO50696 | 2023-05-13 | 144.06 | 1816.95 | 600.26 | |||
SO65311_19 | 8732-477D-BC | PO7047142102 | 100 | 281 | 551 | 544 | 3 | 2024-02-16 | 475.29 | 11.88 | 2024-02-04 | 3 | 144.59 | 1 | 475.29 | 19 | SO65311 | 2024-02-11 | 38.02 | 433.78 | 158.43 | |||
SO57162_9 | 83B5-43A6-BD | PO3596174424 | 100 | 285 | 551 | 476 | 5 | 2023-10-18 | 316.86 | 7.92 | 2023-10-06 | 2 | 144.59 | 1 | 316.86 | 9 | SO57162 | 2023-10-13 | 25.35 | 289.19 | 158.43 | |||
SO50208_27 | 6993-49B4-8B | PO15689114248 | 100 | 281 | 383 | 328 | 4 | 2023-04-17 | 1200.53 | 30.01 | 2023-04-05 | 2 | 605.65 | 1 | 1200.53 | 27 | SO50208 | 2023-04-12 | 96.04 | 1211.30 | 600.26 | |||
SO44093_3 | 8356-4625-B2 | PO15138128112 | 100 | 283 | 317 | 93 | 4 | 2021-08-18 | 874.79 | 21.87 | 2021-08-06 | 1 | 884.71 | 1 | 874.79 | 3 | SO44093 | 2021-08-13 | 69.98 | 884.71 | 874.79 | |||
SO51739_24 | AF60-4F2F-9B | PO12702124697 | 100 | 292 | 476 | 175 | 7 | 2023-07-18 | 251.96 | 6.30 | 2023-07-06 | 6 | 26.18 | 1 | 251.96 | 24 | SO51739 | 2023-07-13 | 20.16 | 157.06 | 41.99 | |||
SO43858_3 | 8FFA-4339-B7 | PO16791124272 | 100 | 281 | 342 | 36 | 2 | 2021-07-18 | 2097.29 | 52.43 | 2021-07-06 | 5 | 413.15 | 1 | 2097.29 | 3 | SO43858 | 2021-07-13 | 167.78 | 2065.73 | 419.46 | |||
SO49114_6 | 354C-48D4-9B | PO15631175128 | 100 | 282 | 358 | 43 | 1 | 2023-01-18 | 4917.84 | 122.95 | 2023-01-06 | 4 | 1105.81 | 1 | 4917.84 | 6 | SO49114 | 2023-01-13 | 393.43 | 4423.24 | 1229.46 | |||
SO44130_6 | A870-450A-8A | PO9106111486 | 100 | 285 | 220 | 602 | 5 | 2021-08-18 | 20.19 | 0.50 | 2021-08-06 | 1 | 12.03 | 1 | 20.19 | 6 | SO44130 | 2021-08-13 | 1.61 | 12.03 | 20.19 | |||
SO48753_12 | 1DDA-42B2-AF | PO17197151135 | 100 | 283 | 428 | 125 | 2 | 2022-12-18 | 418.51 | 10.46 | 2022-12-06 | 2 | 185.82 | 1 | 418.51 | 12 | SO48753 | 2022-12-13 | 33.48 | 371.64 | 209.26 | |||
SO53493_10 | F767-491F-84 | PO13543118174 | 100 | 287 | 298 | 293 | 1 | 2023-08-18 | 2429.28 | 60.73 | 2023-08-06 | 3 | 739.04 | 1 | 2429.28 | 10 | SO53493 | 2023-08-13 | 194.34 | 2217.12 | 809.76 | |||
SO51714_43 | D33A-4EAE-B1 | PO15689195197 | 100 | 281 | 240 | 328 | 4 | 2023-07-18 | 1717.80 | 42.95 | 2023-07-06 | 2 | 868.63 | 1 | 1717.80 | 43 | SO51714 | 2023-07-13 | 137.42 | 1737.27 | 858.90 | |||
SO53454_43 | 278D-445A-99 | PO19633151350 | 100 | 287 | 357 | 149 | 3 | 2023-08-18 | 6959.97 | 174.00 | 2023-08-06 | 5 | 1265.62 | 1 | 6959.97 | 43 | SO53454 | 2023-08-13 | 556.80 | 6328.10 | 1391.99 | |||
SO47041_28 | C543-4932-83 | PO5771188676 | 100 | 282 | 458 | 79 | 3 | 2022-07-18 | 179.98 | 4.50 | 2022-07-06 | 4 | 30.93 | 1 | 179.98 | 28 | SO47041 | 2022-07-13 | 14.40 | 123.73 | 44.99 | |||
SO50758_4 | 23D8-44CE-96 | PO8903112353 | 100 | 293 | 323 | 235 | 1 | 2023-05-18 | 1409.38 | 35.23 | 2023-05-06 | 3 | 486.71 | 1 | 1409.38 | 4 | SO50758 | 2023-05-13 | 112.75 | 1460.12 | 469.79 | |||
SO47352_11 | 9DF5-4A88-9C | PO19633111392 | 100 | 287 | 354 | 149 | 3 | 2022-08-18 | 1242.85 | 31.07 | 2022-08-06 | 1 | 1117.86 | 1 | 1242.85 | 11 | SO47352 | 2022-08-13 | 99.43 | 1117.86 | 1242.85 | |||
SO46675_6 | 1ED0-48BC-93 | PO10237173444 | 100 | 287 | 458 | 41 | 4 | 2022-06-17 | 224.97 | 5.62 | 2022-06-05 | 5 | 30.93 | 1 | 224.97 | 6 | SO46675 | 2022-06-12 | 18.00 | 154.67 | 44.99 | |||
SO51111_11 | 5E49-4F77-BB | PO11484190487 | 100 | 283 | 474 | 4 | 594 | 2 | 108.48 | 2023-06-17 | 1084.85 | 24.41 | 2023-06-05 | 31 | 26.18 | 1 | 976.36 | 11 | SO51111 | 2023-06-12 | 78.11 | 811.47 | 35.00 | 0.10 |
SO50214_3 | 97D5-41D3-8F | PO15196120916 | 100 | 282 | 263 | 258 | 4 | 2023-04-17 | 404.66 | 10.12 | 2023-04-05 | 2 | 187.16 | 1 | 404.66 | 3 | SO50214 | 2023-04-12 | 32.37 | 374.31 | 202.33 | |||
SO57042_9 | 52C4-4348-BC | PO15196150289 | 100 | 282 | 481 | 258 | 4 | 2023-10-18 | 32.36 | 0.81 | 2023-10-06 | 6 | 3.36 | 1 | 32.36 | 9 | SO57042 | 2023-10-13 | 2.59 | 20.17 | 5.39 | |||
SO47041_3 | C543-4932-83 | PO5771188676 | 100 | 282 | 339 | 79 | 3 | 2022-07-18 | 1409.38 | 35.23 | 2022-07-06 | 3 | 486.71 | 1 | 1409.38 | 3 | SO47041 | 2022-07-13 | 112.75 | 1460.12 | 469.79 | |||
SO49099_26 | D567-4CCE-A4 | PO15689170019 | 100 | 281 | 224 | 328 | 4 | 2023-01-18 | 15.56 | 0.39 | 2023-01-06 | 3 | 5.23 | 1 | 15.56 | 26 | SO49099 | 2023-01-13 | 1.24 | 15.69 | 5.19 | |||
SO50230_4 | E4FB-421B-A5 | PO11542120242 | 100 | 285 | 343 | 62 | 5 | 2023-04-17 | 1879.18 | 46.98 | 2023-04-05 | 4 | 486.71 | 1 | 1879.18 | 4 | SO50230 | 2023-04-12 | 150.33 | 1946.83 | 469.79 | |||
SO63212_2 | B54D-4C63-85 | PO5684113881 | 100 | 282 | 361 | 385 | 4 | 2024-01-18 | 11015.95 | 275.40 | 2024-01-06 | 8 | 1251.98 | 1 | 11015.95 | 2 | SO63212 | 2024-01-13 | 881.28 | 10015.85 | 1376.99 | |||
SO46617_2 | 3FDB-4564-98 | PO14413119944 | 100 | 287 | 433 | 383 | 4 | 2022-06-17 | 648.91 | 16.22 | 2022-06-05 | 2 | 300.12 | 1 | 648.91 | 2 | SO46617 | 2022-06-12 | 51.91 | 600.24 | 324.45 | |||
SO47455_43 | 41F3-48C2-B7 | PO9599169586 | 100 | 285 | 323 | 170 | 5 | 2022-08-18 | 1409.38 | 35.23 | 2022-08-06 | 3 | 486.71 | 1 | 1409.38 | 43 | SO47455 | 2022-08-13 | 112.75 | 1460.12 | 469.79 | |||
SO69545_6 | 2C06-44D9-96 | PO3480123333 | 100 | 272 | 222 | 436 | 4 | 2024-04-17 | 83.98 | 2.10 | 2024-04-05 | 4 | 13.09 | 1 | 83.98 | 6 | SO69545 | 2024-04-12 | 6.72 | 52.35 | 20.99 | |||
SO51778_17 | 420A-4268-A8 | PO3161175221 | 100 | 283 | 491 | 359 | 2 | 2023-07-18 | 97.18 | 2.43 | 2023-07-06 | 3 | 41.57 | 1 | 97.18 | 17 | SO51778 | 2023-07-13 | 7.77 | 124.72 | 32.39 | |||
SO48327_3 | 2906-4A58-AF | PO13717142928 | 100 | 287 | 254 | 473 | 4 | 2022-11-17 | 183.94 | 4.60 | 2022-11-05 | 1 | 170.14 | 1 | 183.94 | 3 | SO48327 | 2022-11-12 | 14.72 | 170.14 | 183.94 | |||
SO51095_1 | 9E89-4758-94 | PO14413190533 | 100 | 287 | 547 | 383 | 4 | 2023-06-17 | 97.19 | 2.43 | 2023-06-05 | 2 | 35.96 | 1 | 97.19 | 1 | SO51095 | 2023-06-12 | 7.78 | 71.92 | 48.59 | |||
SO45055_5 | 0C6F-4406-A0 | PO12412126535 | 100 | 283 | 311 | 670 | 3 | 2021-12-18 | 2146.96 | 53.67 | 2021-12-06 | 1 | 2171.29 | 1 | 2146.96 | 5 | SO45055 | 2021-12-13 | 171.76 | 2171.29 | 2146.96 | |||
SO46621_8 | DCA1-4F74-BD | PO13949117076 | 100 | 281 | 327 | 9 | 643 | 3 | 211.41 | 2022-06-17 | 704.69 | 12.33 | 2022-06-05 | 3 | 486.71 | 1 | 493.28 | 8 | SO46621 | 2022-06-12 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO55324_33 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 214 | 523 | 3 | 2023-09-17 | 125.96 | 3.15 | 2023-09-05 | 6 | 13.09 | 1 | 125.96 | 33 | SO55324 | 2023-09-12 | 10.08 | 78.52 | 20.99 | |||
SO67346_18 | 545C-4C6E-88 | PO9338145989 | 100 | 293 | 503 | 451 | 1 | 2024-03-18 | 400.10 | 10.00 | 2024-03-06 | 2 | 199.85 | 1 | 400.10 | 18 | SO67346 | 2024-03-13 | 32.01 | 399.70 | 200.05 | |||
SO57068_39 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 306 | 632 | 7 | 2023-10-18 | 1619.52 | 40.49 | 2023-10-06 | 2 | 739.04 | 1 | 1619.52 | 39 | SO57068 | 2023-10-13 | 129.56 | 1478.08 | 809.76 | |||
SO44500_3 | E9A4-477A-83 | PO16762152605 | 100 | 282 | 326 | 259 | 4 | 2021-10-18 | 838.92 | 20.97 | 2021-10-06 | 2 | 413.15 | 1 | 838.92 | 3 | SO44500 | 2021-10-13 | 67.11 | 826.29 | 419.46 | |||
SO46613_3 | D7EC-42C8-AF | PO15602156182 | 100 | 272 | 421 | 7 | 1 | 2022-06-17 | 196.33 | 4.91 | 2022-06-05 | 1 | 145.28 | 1 | 196.33 | 3 | SO46613 | 2022-06-12 | 15.71 | 145.28 | 196.33 | |||
SO57118_24 | 69CB-481B-8D | PO5800191707 | 100 | 285 | 306 | 63 | 5 | 2023-10-18 | 3239.04 | 80.98 | 2023-10-06 | 4 | 739.04 | 1 | 3239.04 | 24 | SO57118 | 2023-10-13 | 259.12 | 2956.16 | 809.76 | |||
SO57043_8 | F448-4B5D-89 | PO15080130371 | 100 | 292 | 573 | 283 | 7 | 2023-10-18 | 1430.44 | 35.76 | 2023-10-06 | 1 | 1481.94 | 1 | 1430.44 | 8 | SO57043 | 2023-10-13 | 114.44 | 1481.94 | 1430.44 | |||
SO55276_8 | 81AA-41E5-B0 | PO2755182998 | 100 | 282 | 506 | 205 | 4 | 2023-09-17 | 800.21 | 20.01 | 2023-09-05 | 4 | 199.85 | 1 | 800.21 | 8 | SO55276 | 2023-09-12 | 64.02 | 799.41 | 200.05 | |||
SO43895_12 | 5233-4CB8-BC | PO2900121738 | 100 | 286 | 345 | 469 | 1 | 2021-07-18 | 4079.99 | 102.00 | 2021-07-06 | 2 | 1912.15 | 1 | 4079.99 | 12 | SO43895 | 2021-07-13 | 326.40 | 3824.31 | 2039.99 | |||
SO55269_28 | C087-4A55-8D | PO899192335 | 100 | 289 | 234 | 290 | 1 | 2023-09-17 | 239.95 | 6.00 | 2023-09-05 | 8 | 38.49 | 1 | 239.95 | 28 | SO55269 | 2023-09-12 | 19.20 | 307.94 | 29.99 | |||
SO47992_42 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 453 | 487 | 1 | 2022-10-18 | 215.96 | 5.40 | 2022-10-06 | 6 | 24.75 | 1 | 215.96 | 42 | SO47992 | 2022-10-13 | 17.28 | 148.48 | 35.99 | |||
SO59060_1 | 2E96-412E-AE | PO7163154454 | 100 | 289 | 587 | 470 | 1 | 2023-11-17 | 923.39 | 23.08 | 2023-11-05 | 2 | 419.78 | 1 | 923.39 | 1 | SO59060 | 2023-11-12 | 73.87 | 839.56 | 461.69 | |||
SO55314_2 | A6ED-4B1A-BF | PO3016114503 | 100 | 281 | 361 | 183 | 3 | 2023-09-17 | 2753.99 | 68.85 | 2023-09-05 | 2 | 1251.98 | 1 | 2753.99 | 2 | SO55314 | 2023-09-12 | 220.32 | 2503.96 | 1376.99 | |||
SO69493_6 | FA5D-44EF-A7 | PO12383119310 | 100 | 283 | 477 | 89 | 2 | 2024-04-17 | 11.98 | 0.30 | 2024-04-05 | 4 | 1.87 | 1 | 11.98 | 6 | SO69493 | 2024-04-12 | 0.96 | 7.47 | 2.99 | |||
SO69513_3 | 21F8-4626-B9 | PO7598121355 | 100 | 285 | 382 | 45 | 5 | 2024-04-17 | 2016.88 | 50.42 | 2024-04-05 | 3 | 713.08 | 1 | 2016.88 | 3 | SO69513 | 2024-04-12 | 161.35 | 2139.24 | 672.29 | |||
SO67305_6 | CBB5-42BF-9E | PO16298111473 | 100 | 287 | 562 | 599 | 4 | 2024-03-18 | 4291.33 | 107.28 | 2024-03-06 | 3 | 1481.94 | 1 | 4291.33 | 6 | SO67305 | 2024-03-13 | 343.31 | 4445.81 | 1430.44 | |||
SO63153_10 | 9812-4AF8-8C | PO15080177922 | 100 | 292 | 586 | 283 | 7 | 2024-01-18 | 445.41 | 11.14 | 2024-01-06 | 1 | 461.44 | 1 | 445.41 | 10 | SO63153 | 2024-01-13 | 35.63 | 461.44 | 445.41 | |||
SO69464_13 | 8924-465B-BE | PO2668146931 | 100 | 292 | 295 | 535 | 7 | 2024-04-17 | 1637.40 | 40.94 | 2024-04-05 | 2 | 747.20 | 1 | 1637.40 | 13 | SO69464 | 2024-04-12 | 130.99 | 1494.40 | 818.70 | |||
SO48087_26 | 2285-4C77-9B | PO8816162044 | 100 | 289 | 325 | 218 | 1 | 2022-10-18 | 939.59 | 23.49 | 2022-10-06 | 2 | 486.71 | 1 | 939.59 | 26 | SO48087 | 2022-10-13 | 75.17 | 973.41 | 469.79 | |||
SO53534_19 | F0B1-423E-8B | PO20213153510 | 100 | 283 | 287 | 216 | 2 | 2023-08-18 | 202.33 | 5.06 | 2023-08-06 | 1 | 204.63 | 1 | 202.33 | 19 | SO53534 | 2023-08-13 | 16.19 | 204.63 | 202.33 | |||
SO48004_24 | DC8C-40DC-8F | PO13572118942 | 100 | 287 | 327 | 527 | 3 | 2022-10-18 | 939.59 | 23.49 | 2022-10-06 | 2 | 486.71 | 1 | 939.59 | 24 | SO48004 | 2022-10-13 | 75.17 | 973.41 | 469.79 | |||
SO49864_8 | D282-4C24-9B | PO13775121562 | 100 | 283 | 333 | 618 | 2 | 2023-03-18 | 1409.38 | 35.23 | 2023-03-06 | 3 | 486.71 | 1 | 1409.38 | 8 | SO49864 | 2023-03-13 | 112.75 | 1460.12 | 469.79 | |||
SO44123_1 | 9F0F-4FBC-9A | PO6322187277 | 100 | 281 | 316 | 503 | 2 | 2021-08-18 | 874.79 | 21.87 | 2021-08-06 | 1 | 884.71 | 1 | 874.79 | 1 | SO44123 | 2021-08-13 | 69.98 | 884.71 | 874.79 | |||
SO46028_16 | 7BBE-413C-83 | PO19546126425 | 100 | 285 | 229 | 206 | 5 | 2022-04-17 | 28.84 | 0.72 | 2022-04-05 | 1 | 31.72 | 1 | 28.84 | 16 | SO46028 | 2022-04-12 | 2.31 | 31.72 | 28.84 | |||
SO55256_8 | 686E-4D36-8B | PO12528136439 | 100 | 282 | 601 | 331 | 4 | 2023-09-17 | 97.18 | 2.43 | 2023-09-05 | 3 | 23.97 | 1 | 97.18 | 8 | SO55256 | 2023-09-12 | 7.77 | 71.91 | 32.39 | |||
SO46965_4 | C9A7-4125-95 | PO15921113146 | 100 | 287 | 224 | 77 | 4 | 2022-07-18 | 20.75 | 0.52 | 2022-07-06 | 4 | 5.23 | 1 | 20.75 | 4 | SO46965 | 2022-07-13 | 1.66 | 20.92 | 5.19 | |||
SO48012_6 | AF9F-4901-9E | PO12499156458 | 100 | 282 | 341 | 78 | 4 | 2022-10-18 | 469.79 | 11.74 | 2022-10-06 | 1 | 486.71 | 1 | 469.79 | 6 | SO48012 | 2022-10-13 | 37.58 | 486.71 | 469.79 | |||
SO51147_5 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 484 | 3 | 81 | 5 | 3.72 | 2023-06-17 | 74.33 | 1.77 | 2023-06-05 | 17 | 2.97 | 1 | 70.62 | 5 | SO51147 | 2023-06-12 | 5.65 | 50.55 | 4.37 | 0.05 |
Generated 2024-07-05 23:08:48.877 UTC