[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 0 SHUFFLE < SKIP 1043 > < TAKE 60 >
60 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50716_1 | 0B80-45BD-98 | PO18299117393 | 19 | 291 | 294 | 118 | 6 | 2023-09-23 | 744.27 | 18.61 | 2023-09-11 | 1 | 660.91 | 1 | 744.27 | 1 | SO50716 | 2023-09-18 | 59.54 | 660.91 | 744.27 |
SO46333_4 | B042-408B-A8 | PO17545158984 | 19 | 288 | 312 | 155 | 6 | 2022-09-23 | 6440.89 | 161.02 | 2022-09-11 | 3 | 2171.29 | 1 | 6440.89 | 4 | SO46333 | 2022-09-18 | 515.27 | 6513.88 | 2146.96 |
SO53508_9 | 38E7-428D-9B | PO11194139565 | 19 | 284 | 499 | 48 | 6 | 2023-12-24 | 3614.08 | 90.35 | 2023-12-12 | 6 | 601.74 | 1 | 3614.08 | 9 | SO53508 | 2023-12-19 | 289.13 | 3610.46 | 602.35 |
SO47398_8 | 283C-414B-A2 | PO10614138214 | 19 | 291 | 254 | 461 | 6 | 2022-12-24 | 183.94 | 4.60 | 2022-12-12 | 1 | 170.14 | 1 | 183.94 | 8 | SO47398 | 2022-12-19 | 14.72 | 170.14 | 183.94 |
SO50668_16 | A5FC-4831-B4 | PO17574113752 | 19 | 291 | 466 | 678 | 6 | 2023-09-23 | 28.26 | 0.71 | 2023-09-11 | 2 | 9.71 | 1 | 28.26 | 16 | SO50668 | 2023-09-18 | 2.26 | 19.43 | 14.13 |
SO63177_12 | 87AD-4113-AD | PO1856115383 | 19 | 291 | 463 | 263 | 6 | 2024-05-25 | 88.16 | 2.20 | 2024-05-13 | 6 | 9.16 | 1 | 88.16 | 12 | SO63177 | 2024-05-20 | 7.05 | 54.96 | 14.69 |
SO71806_24 | 26A7-4E95-9B | PO14790111844 | 19 | 291 | 511 | 497 | 6 | 2024-09-23 | 218.45 | 5.46 | 2024-09-11 | 1 | 199.38 | 1 | 218.45 | 24 | SO71806 | 2024-09-18 | 17.48 | 199.38 | 218.45 |
SO46037_2 | EFA9-4271-AE | PO17777167791 | 19 | 288 | 253 | 208 | 6 | 2022-08-23 | 178.58 | 4.46 | 2022-08-11 | 1 | 176.20 | 1 | 178.58 | 2 | SO46037 | 2022-08-18 | 14.29 | 176.20 | 178.58 |
SO48754_10 | FC6A-4A9E-83 | PO18473150383 | 19 | 291 | 445 | 442 | 6 | 2023-04-25 | 107.98 | 2.70 | 2023-04-13 | 3 | 24.75 | 1 | 107.98 | 10 | SO48754 | 2023-04-20 | 8.64 | 74.24 | 35.99 |
SO44504_11 | CFE2-4C08-B0 | PO16733198490 | 19 | 288 | 311 | 533 | 6 | 2022-02-23 | 2146.96 | 53.67 | 2022-02-11 | 1 | 2171.29 | 1 | 2146.96 | 11 | SO44504 | 2022-02-18 | 171.76 | 2171.29 | 2146.96 |
SO46607_38 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 424 | 227 | 6 | 2022-10-23 | 856.94 | 21.42 | 2022-10-11 | 4 | 158.53 | 1 | 856.94 | 38 | SO46607 | 2022-10-18 | 68.56 | 634.14 | 214.24 |
SO49468_5 | DB7C-4159-88 | PO1885116335 | 19 | 284 | 428 | 588 | 6 | 2023-06-23 | 209.26 | 5.23 | 2023-06-11 | 1 | 185.82 | 1 | 209.26 | 5 | SO49468 | 2023-06-18 | 16.74 | 185.82 | 209.26 |
SO44490_1 | 0CC4-4097-80 | PO19227160482 | 19 | 284 | 322 | 210 | 6 | 2022-02-23 | 419.46 | 10.49 | 2022-02-11 | 1 | 413.15 | 1 | 419.46 | 1 | SO44490 | 2022-02-18 | 33.56 | 413.15 | 419.46 |
SO47398_44 | 283C-414B-A2 | PO10614138214 | 19 | 291 | 368 | 461 | 6 | 2022-12-24 | 8796.06 | 219.90 | 2022-12-12 | 6 | 1518.79 | 1 | 8796.06 | 44 | SO47398 | 2022-12-19 | 703.68 | 9112.72 | 1466.01 |
SO49513_3 | 1A8D-4D25-AE | PO10962181499 | 19 | 284 | 354 | 685 | 6 | 2023-06-23 | 4971.41 | 124.29 | 2023-06-11 | 4 | 1117.86 | 1 | 4971.41 | 3 | SO49513 | 2023-06-18 | 397.71 | 4471.42 | 1242.85 |
SO63290_17 | 0F43-405E-B8 | PO9077159728 | 19 | 291 | 532 | 100 | 6 | 2024-05-25 | 749.37 | 18.73 | 2024-05-13 | 5 | 136.79 | 1 | 749.37 | 17 | SO63290 | 2024-05-20 | 59.95 | 683.93 | 149.87 |
SO51818_29 | B8CE-4C91-A9 | PO9077115532 | 19 | 291 | 533 | 100 | 6 | 2023-11-23 | 449.62 | 11.24 | 2023-11-11 | 3 | 136.79 | 1 | 449.62 | 29 | SO51818 | 2023-11-18 | 35.97 | 410.36 | 149.87 |
SO67302_28 | E4B2-462D-AC | PO18473194134 | 19 | 291 | 601 | 442 | 6 | 2024-07-24 | 32.39 | 0.81 | 2024-07-12 | 1 | 23.97 | 1 | 32.39 | 28 | SO67302 | 2024-07-19 | 2.59 | 23.97 | 32.39 |
SO46953_21 | C650-4C32-BE | PO17603154442 | 19 | 284 | 445 | 12 | 6 | 2022-11-23 | 143.98 | 3.60 | 2022-11-11 | 4 | 24.75 | 1 | 143.98 | 21 | SO46953 | 2022-11-18 | 11.52 | 98.98 | 35.99 |
SO69538_6 | 631A-4D82-A8 | PO2117162793 | 19 | 284 | 476 | 444 | 6 | 2024-08-23 | 83.99 | 2.10 | 2024-08-11 | 2 | 26.18 | 1 | 83.99 | 6 | SO69538 | 2024-08-18 | 6.72 | 52.35 | 41.99 |
SO51116_21 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 225 | 480 | 6 | 2023-10-23 | 21.58 | 0.54 | 2023-10-11 | 4 | 6.92 | 1 | 21.58 | 21 | SO51116 | 2023-10-18 | 1.73 | 27.69 | 5.39 |
SO61186_13 | C662-487E-B0 | PO14732152217 | 19 | 291 | 547 | 514 | 6 | 2024-04-24 | 145.78 | 3.64 | 2024-04-12 | 3 | 35.96 | 1 | 145.78 | 13 | SO61186 | 2024-04-19 | 11.66 | 107.88 | 48.59 |
SO44773_7 | D4D3-4657-AC | PO1740125070 | 19 | 288 | 253 | 460 | 6 | 2022-03-25 | 357.16 | 8.93 | 2022-03-13 | 2 | 176.20 | 1 | 357.16 | 7 | SO44773 | 2022-03-20 | 28.57 | 352.40 | 178.58 |
SO47359_45 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 358 | 118 | 6 | 2022-12-24 | 4917.84 | 122.95 | 2022-12-12 | 4 | 1105.81 | 1 | 4917.84 | 45 | SO47359 | 2022-12-19 | 393.43 | 4423.24 | 1229.46 |
SO69399_8 | BEA9-4703-91 | PO17661173810 | 19 | 284 | 214 | 264 | 6 | 2024-08-23 | 125.96 | 3.15 | 2024-08-11 | 6 | 13.09 | 1 | 125.96 | 8 | SO69399 | 2024-08-18 | 10.08 | 78.52 | 20.99 |
SO46959_4 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 459 | 533 | 6 | 2022-11-23 | 323.96 | 8.10 | 2022-11-11 | 6 | 37.12 | 1 | 323.96 | 4 | SO46959 | 2022-11-18 | 25.92 | 222.73 | 53.99 |
SO57019_13 | D018-44A0-BF | PO18879140423 | 19 | 291 | 578 | 64 | 6 | 2024-02-23 | 728.91 | 18.22 | 2024-02-11 | 1 | 755.15 | 1 | 728.91 | 13 | SO57019 | 2024-02-18 | 58.31 | 755.15 | 728.91 |
SO57120_16 | 058D-436F-BF | PO4466170177 | 19 | 291 | 400 | 352 | 6 | 2024-02-23 | 111.46 | 2.79 | 2024-02-11 | 3 | 27.49 | 1 | 111.46 | 16 | SO57120 | 2024-02-18 | 8.92 | 82.48 | 37.15 |
SO43857_8 | 0CD4-4091-9B | PO16733124458 | 19 | 288 | 262 | 533 | 6 | 2021-11-23 | 183.94 | 4.60 | 2021-11-11 | 1 | 181.49 | 1 | 183.94 | 8 | SO43857 | 2021-11-18 | 14.72 | 181.49 | 183.94 |
SO61204_31 | E810-4164-82 | PO15312134209 | 19 | 291 | 287 | 299 | 6 | 2024-04-24 | 202.33 | 5.06 | 2024-04-12 | 1 | 204.63 | 1 | 202.33 | 31 | SO61204 | 2024-04-19 | 16.19 | 204.63 | 202.33 |
SO50664_36 | 85F5-458B-8D | PO19401149024 | 19 | 291 | 341 | 173 | 6 | 2023-09-23 | 939.59 | 23.49 | 2023-09-11 | 2 | 486.71 | 1 | 939.59 | 36 | SO50664 | 2023-09-18 | 75.17 | 973.41 | 469.79 |
SO50664_25 | 85F5-458B-8D | PO19401149024 | 19 | 291 | 448 | 173 | 6 | 2023-09-23 | 35.98 | 0.90 | 2023-09-11 | 3 | 8.25 | 1 | 35.98 | 25 | SO50664 | 2023-09-18 | 2.88 | 24.74 | 11.99 |
SO53464_17 | E113-419B-8F | PO17545119283 | 19 | 291 | 520 | 155 | 6 | 2023-12-24 | 63.17 | 1.58 | 2023-12-12 | 2 | 23.37 | 1 | 63.17 | 17 | SO53464 | 2023-12-19 | 5.05 | 46.74 | 31.58 |
SO63138_6 | 3BDB-40B5-A6 | PO17806142534 | 19 | 291 | 471 | 101 | 6 | 2024-05-25 | 38.10 | 0.95 | 2024-05-13 | 1 | 23.75 | 1 | 38.10 | 6 | SO63138 | 2024-05-20 | 3.05 | 23.75 | 38.10 |
SO69391_3 | BB46-4CDA-BD | PO19691125027 | 19 | 291 | 476 | 353 | 6 | 2024-08-23 | 83.99 | 2.10 | 2024-08-11 | 2 | 26.18 | 1 | 83.99 | 3 | SO69391 | 2024-08-18 | 6.72 | 52.35 | 41.99 |
SO49501_24 | EF67-4713-BD | PO17574111786 | 19 | 291 | 453 | 678 | 6 | 2023-06-23 | 143.98 | 3.60 | 2023-06-11 | 4 | 24.75 | 1 | 143.98 | 24 | SO49501 | 2023-06-18 | 11.52 | 98.98 | 35.99 |
SO47397_17 | B964-4D2F-B3 | PO11107130091 | 19 | 284 | 224 | 156 | 6 | 2022-12-24 | 25.93 | 0.65 | 2022-12-12 | 5 | 5.23 | 1 | 25.93 | 17 | SO47397 | 2022-12-19 | 2.07 | 26.15 | 5.19 |
SO45522_16 | DB6E-40EF-A4 | PO19401195812 | 19 | 288 | 334 | 173 | 6 | 2022-06-23 | 419.46 | 10.49 | 2022-06-11 | 1 | 413.15 | 1 | 419.46 | 16 | SO45522 | 2022-06-18 | 33.56 | 413.15 | 419.46 |
SO47413_3 | E274-4280-9B | PO1885161774 | 19 | 284 | 421 | 588 | 6 | 2022-12-24 | 588.99 | 14.72 | 2022-12-12 | 3 | 145.28 | 1 | 588.99 | 3 | SO47413 | 2022-12-19 | 47.12 | 435.85 | 196.33 |
SO46930_1 | 73DA-4549-8B | PO20039167979 | 19 | 291 | 224 | 65 | 6 | 2022-11-23 | 15.56 | 0.39 | 2022-11-11 | 3 | 5.23 | 1 | 15.56 | 1 | SO46930 | 2022-11-18 | 1.24 | 15.69 | 5.19 |
SO57161_17 | 5BA9-4418-9F | PO1827135302 | 19 | 291 | 581 | 317 | 6 | 2024-02-23 | 3061.78 | 76.54 | 2024-02-11 | 3 | 1082.51 | 1 | 3061.78 | 17 | SO57161 | 2024-02-18 | 244.94 | 3247.53 | 1020.59 |
SO46997_23 | 9714-4035-90 | PO11020181604 | 19 | 284 | 422 | 336 | 6 | 2022-11-23 | 202.62 | 5.07 | 2022-11-11 | 3 | 49.98 | 1 | 202.62 | 23 | SO46997 | 2022-11-18 | 16.21 | 149.94 | 67.54 |
SO58972_11 | 07C8-43BD-85 | PO1798131785 | 19 | 291 | 355 | 10 | 6 | 2024-03-24 | 4175.98 | 104.40 | 2024-03-12 | 3 | 1265.62 | 1 | 4175.98 | 11 | SO58972 | 2024-03-19 | 334.08 | 3796.86 | 1391.99 |
SO69397_21 | 1339-46CA-AC | PO18879152551 | 19 | 291 | 563 | 64 | 6 | 2024-08-23 | 1430.44 | 35.76 | 2024-08-11 | 1 | 1481.94 | 1 | 1430.44 | 21 | SO69397 | 2024-08-18 | 114.44 | 1481.94 | 1430.44 |
SO49140_10 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 329 | 84 | 6 | 2023-05-26 | 1409.38 | 35.23 | 2023-05-14 | 3 | 486.71 | 1 | 1409.38 | 10 | SO49140 | 2023-05-21 | 112.75 | 1460.12 | 469.79 |
SO51132_17 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 374 | 227 | 6 | 2023-10-23 | 8796.06 | 219.90 | 2023-10-11 | 6 | 1554.95 | 1 | 8796.06 | 17 | SO51132 | 2023-10-18 | 703.68 | 9329.69 | 1466.01 |
SO53527_56 | 0EBE-4ACB-B5 | PO1798140946 | 19 | 291 | 488 | 10 | 6 | 2023-12-24 | 194.36 | 4.86 | 2023-12-12 | 6 | 41.57 | 1 | 194.36 | 56 | SO53527 | 2023-12-19 | 15.55 | 249.43 | 32.39 |
SO55275_26 | 72C3-4048-BC | PO1711122362 | 19 | 291 | 474 | 245 | 6 | 2024-01-23 | 83.99 | 2.10 | 2024-01-11 | 2 | 26.18 | 1 | 83.99 | 26 | SO55275 | 2024-01-18 | 6.72 | 52.35 | 41.99 |
SO49140_32 | EFF3-483D-BE | PO4901154744 | 19 | 284 | 373 | 84 | 6 | 2023-05-26 | 1308.94 | 32.72 | 2023-05-14 | 1 | 1320.68 | 1 | 1308.94 | 32 | SO49140 | 2023-05-21 | 104.72 | 1320.68 | 1308.94 |
SO67304_25 | 5E78-4926-A4 | PO18444191982 | 19 | 291 | 477 | 227 | 6 | 2024-07-24 | 5.99 | 0.15 | 2024-07-12 | 2 | 1.87 | 1 | 5.99 | 25 | SO67304 | 2024-07-19 | 0.48 | 3.73 | 2.99 |
SO45797_26 | B3FE-4436-96 | PO11049120115 | 19 | 284 | 264 | 679 | 6 | 2022-07-24 | 183.94 | 4.60 | 2022-07-12 | 1 | 181.49 | 1 | 183.94 | 26 | SO45797 | 2022-07-19 | 14.72 | 181.49 | 183.94 |
SO58981_11 | 2B52-4247-AF | PO18299143459 | 19 | 291 | 474 | 118 | 6 | 2024-03-24 | 209.97 | 5.25 | 2024-03-12 | 5 | 26.18 | 1 | 209.97 | 11 | SO58981 | 2024-03-19 | 16.80 | 130.88 | 41.99 |
SO46071_16 | 1563-4F33-9D | PO1827148074 | 19 | 288 | 322 | 317 | 6 | 2022-08-23 | 2097.29 | 52.43 | 2022-08-11 | 5 | 413.15 | 1 | 2097.29 | 16 | SO46071 | 2022-08-18 | 167.78 | 2065.73 | 419.46 |
SO63120_3 | 7EBB-40A6-BC | PO20039185694 | 19 | 291 | 476 | 65 | 6 | 2024-05-25 | 83.99 | 2.10 | 2024-05-13 | 2 | 26.18 | 1 | 83.99 | 3 | SO63120 | 2024-05-20 | 6.72 | 52.35 | 41.99 |
SO50664_3 | 85F5-458B-8D | PO19401149024 | 19 | 291 | 379 | 173 | 6 | 2023-09-23 | 1308.94 | 32.72 | 2023-09-11 | 1 | 1320.68 | 1 | 1308.94 | 3 | SO50664 | 2023-09-18 | 104.72 | 1320.68 | 1308.94 |
SO47037_28 | C1AE-48A5-9F | PO4901170321 | 19 | 284 | 385 | 84 | 6 | 2022-11-23 | 600.26 | 15.01 | 2022-11-11 | 1 | 605.65 | 1 | 600.26 | 28 | SO47037 | 2022-11-18 | 48.02 | 605.65 | 600.26 |
SO51755_13 | 46F4-477C-A7 | PO11020169365 | 19 | 284 | 546 | 336 | 6 | 2023-11-23 | 223.52 | 5.59 | 2023-11-11 | 6 | 27.57 | 1 | 223.52 | 13 | SO51755 | 2023-11-18 | 17.88 | 165.41 | 37.25 |
SO53536_59 | 5C09-4051-92 | PO18299189909 | 19 | 291 | 467 | 118 | 6 | 2023-12-24 | 132.25 | 3.31 | 2023-12-12 | 9 | 9.16 | 1 | 132.25 | 59 | SO53536 | 2023-12-19 | 10.58 | 82.43 | 14.69 |
SO57019_23 | D018-44A0-BF | PO18879140423 | 19 | 291 | 555 | 64 | 6 | 2024-02-23 | 63.90 | 1.60 | 2024-02-11 | 1 | 47.29 | 1 | 63.90 | 23 | SO57019 | 2024-02-18 | 5.11 | 47.29 | 63.90 |
SO61204_21 | E810-4164-82 | PO15312134209 | 19 | 291 | 472 | 299 | 6 | 2024-04-24 | 266.70 | 6.67 | 2024-04-12 | 7 | 23.75 | 1 | 266.70 | 21 | SO61204 | 2024-04-19 | 21.34 | 166.24 | 38.10 |
Generated 2024-11-10 17:41:50.675 UTC