[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 318 > < TAKE 28 >
28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50261_5 | 6142-4396-B8 | PO20039145643 | 19 | 291 | 360 | 65 | 6 | 2023-07-03 | 1229.46 | 30.74 | 2023-06-21 | 1 | 1105.81 | 1 | 1229.46 | 5 | SO50261 | 2023-06-28 | 98.36 | 1105.81 | 1229.46 | |||
SO47673_19 | AFCF-4DA6-99 | PO13862175462 | 19 | 291 | 297 | 119 | 6 | 2022-12-03 | 1472.29 | 36.81 | 2022-11-21 | 2 | 653.70 | 1 | 1472.29 | 19 | SO47673 | 2022-11-28 | 117.78 | 1307.39 | 736.15 | |||
SO71916_5 | A839-4E9B-82 | PO1972110209 | 19 | 291 | 591 | 16 | 190 | 6 | 90.40 | 2024-08-03 | 226.00 | 3.39 | 2024-07-22 | 2 | 308.22 | 1 | 135.60 | 5 | SO71916 | 2024-07-29 | 10.85 | 616.44 | 113.00 | 0.40 |
SO51694_6 | 75B1-457C-8C | PO19691118743 | 19 | 291 | 475 | 353 | 6 | 2023-10-03 | 83.99 | 2.10 | 2023-09-21 | 2 | 26.18 | 1 | 83.99 | 6 | SO51694 | 2023-09-28 | 6.72 | 52.35 | 41.99 | |||
SO49827_2 | E4F0-4B91-84 | PO15312199090 | 19 | 291 | 460 | 299 | 6 | 2023-06-03 | 269.97 | 6.75 | 2023-05-22 | 5 | 37.12 | 1 | 269.97 | 2 | SO49827 | 2023-05-29 | 21.60 | 185.60 | 53.99 | |||
SO65238_35 | 896A-4ED1-B1 | PO10875188169 | 19 | 291 | 487 | 281 | 6 | 2024-05-03 | 131.98 | 3.30 | 2024-04-21 | 4 | 20.57 | 1 | 131.98 | 35 | SO65238 | 2024-04-28 | 10.56 | 82.27 | 32.99 | |||
SO47365_47 | 4535-457B-B0 | PO17574153673 | 19 | 291 | 469 | 678 | 6 | 2022-11-03 | 182.35 | 4.56 | 2022-10-22 | 8 | 15.67 | 1 | 182.35 | 47 | SO47365 | 2022-10-29 | 14.59 | 125.37 | 22.79 | |||
SO49879_6 | 7A79-4FB0-85 | PO4495112714 | 19 | 291 | 421 | 496 | 6 | 2023-06-03 | 785.32 | 19.63 | 2023-05-22 | 4 | 145.28 | 1 | 785.32 | 6 | SO49879 | 2023-05-29 | 62.83 | 581.13 | 196.33 | |||
SO63178_4 | 63E5-40BB-9E | PO2117138284 | 19 | 284 | 475 | 444 | 6 | 2024-04-04 | 83.99 | 2.10 | 2024-03-23 | 2 | 26.18 | 1 | 83.99 | 4 | SO63178 | 2024-03-30 | 6.72 | 52.35 | 41.99 | |||
SO61186_12 | C662-487E-B0 | PO14732152217 | 19 | 291 | 382 | 514 | 6 | 2024-03-04 | 1344.59 | 33.61 | 2024-02-21 | 2 | 713.08 | 1 | 1344.59 | 12 | SO61186 | 2024-02-28 | 107.57 | 1426.16 | 672.29 | |||
SO65156_15 | 3295-4FC6-BC | PO19401176373 | 19 | 291 | 374 | 173 | 6 | 2024-05-03 | 5864.04 | 146.60 | 2024-04-21 | 4 | 1554.95 | 1 | 5864.04 | 15 | SO65156 | 2024-04-28 | 469.12 | 6219.79 | 1466.01 | |||
SO48053_27 | 69FC-4D14-B1 | PO4466199959 | 19 | 291 | 456 | 352 | 6 | 2023-01-03 | 134.98 | 3.37 | 2022-12-22 | 3 | 30.93 | 1 | 134.98 | 27 | SO48053 | 2022-12-29 | 10.80 | 92.80 | 44.99 | |||
SO47012_29 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 368 | 66 | 6 | 2022-10-03 | 1466.01 | 36.65 | 2022-09-21 | 1 | 1518.79 | 1 | 1466.01 | 29 | SO47012 | 2022-09-28 | 117.28 | 1518.79 | 1466.01 | |||
SO50295_15 | 575E-4F7A-9C | PO4466165095 | 19 | 291 | 233 | 352 | 6 | 2023-07-03 | 86.52 | 2.16 | 2023-06-21 | 3 | 29.08 | 1 | 86.52 | 15 | SO50295 | 2023-06-28 | 6.92 | 87.24 | 28.84 | |||
SO48779_2 | 1E4A-4963-9E | PO4930175427 | 19 | 291 | 470 | 425 | 6 | 2023-03-05 | 136.76 | 3.42 | 2023-02-21 | 6 | 15.67 | 1 | 136.76 | 2 | SO48779 | 2023-02-28 | 10.94 | 94.03 | 22.79 | |||
SO50284_9 | F8D1-49E1-A5 | PO4901178867 | 19 | 284 | 422 | 84 | 6 | 2023-07-03 | 67.54 | 1.69 | 2023-06-21 | 1 | 49.98 | 1 | 67.54 | 9 | SO50284 | 2023-06-28 | 5.40 | 49.98 | 67.54 | |||
SO47662_29 | 9790-4A85-BE | PO18473142607 | 19 | 291 | 354 | 442 | 6 | 2022-12-03 | 2485.70 | 62.14 | 2022-11-21 | 2 | 1117.86 | 1 | 2485.70 | 29 | SO47662 | 2022-11-28 | 198.86 | 2235.71 | 1242.85 | |||
SO50200_8 | C47A-4C44-97 | PO17806151620 | 19 | 291 | 233 | 101 | 6 | 2023-07-03 | 57.68 | 1.44 | 2023-06-21 | 2 | 29.08 | 1 | 57.68 | 8 | SO50200 | 2023-06-28 | 4.61 | 58.16 | 28.84 | |||
SO47668_37 | 7CB5-4904-AD | PO15312152020 | 19 | 291 | 254 | 299 | 6 | 2022-12-03 | 367.88 | 9.20 | 2022-11-21 | 2 | 170.14 | 1 | 367.88 | 37 | SO47668 | 2022-11-28 | 29.43 | 340.29 | 183.94 | |||
SO44765_3 | 54D5-4FF7-BB | PO11107155025 | 19 | 284 | 328 | 156 | 6 | 2022-02-02 | 419.46 | 10.49 | 2022-01-21 | 1 | 413.15 | 1 | 419.46 | 3 | SO44765 | 2022-01-28 | 33.56 | 413.15 | 419.46 | |||
SO51092_29 | FB68-47B7-9D | PO15312133079 | 19 | 291 | 488 | 3 | 299 | 6 | 22.27 | 2023-09-02 | 445.42 | 10.58 | 2023-08-21 | 15 | 41.57 | 1 | 423.15 | 29 | SO51092 | 2023-08-28 | 33.85 | 623.58 | 29.69 | 0.05 |
SO57057_7 | D52B-4914-A5 | PO12789122887 | 19 | 291 | 471 | 677 | 6 | 2024-01-03 | 190.50 | 4.76 | 2023-12-22 | 5 | 23.75 | 1 | 190.50 | 7 | SO57057 | 2023-12-29 | 15.24 | 118.75 | 38.10 | |||
SO47354_24 | 6E1C-48C6-89 | PO19401144959 | 19 | 291 | 337 | 173 | 6 | 2022-11-03 | 1409.38 | 35.23 | 2022-10-22 | 3 | 486.71 | 1 | 1409.38 | 24 | SO47354 | 2022-10-29 | 112.75 | 1460.12 | 469.79 | |||
SO51124_23 | 5EEF-4271-BB | PO1711177181 | 19 | 291 | 400 | 245 | 6 | 2023-09-02 | 74.30 | 1.86 | 2023-08-21 | 2 | 27.49 | 1 | 74.30 | 23 | SO51124 | 2023-08-28 | 5.94 | 54.99 | 37.15 | |||
SO49089_1 | 41D5-4730-84 | PO12789114136 | 19 | 291 | 358 | 677 | 6 | 2023-04-05 | 1229.46 | 30.74 | 2023-03-24 | 1 | 1105.81 | 1 | 1229.46 | 1 | SO49089 | 2023-03-31 | 98.36 | 1105.81 | 1229.46 | |||
SO45522_4 | DB6E-40EF-A4 | PO19401195812 | 19 | 288 | 313 | 173 | 6 | 2022-05-03 | 2146.96 | 53.67 | 2022-04-21 | 1 | 2171.29 | 1 | 2146.96 | 4 | SO45522 | 2022-04-28 | 171.76 | 2171.29 | 2146.96 | |||
SO53465_16 | D859-4DF3-84 | PO17574192592 | 19 | 272 | 601 | 678 | 6 | 2023-11-03 | 32.39 | 0.81 | 2023-10-22 | 1 | 23.97 | 1 | 32.39 | 16 | SO53465 | 2023-10-29 | 2.59 | 23.97 | 32.39 | |||
SO50265_38 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 265 | 479 | 6 | 2023-07-03 | 1011.66 | 25.29 | 2023-06-21 | 5 | 187.16 | 1 | 1011.66 | 38 | SO50265 | 2023-06-28 | 80.93 | 935.79 | 202.33 |
Generated 2024-09-20 10:34:25.224 UTC