[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 0 SHUFFLE < SKIP 594 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51793_25 | D763-4929-9B | PO18705168707 | 19 | 291 | 463 | 479 | 6 | 2023-10-03 | 102.86 | 2.57 | 2023-09-21 | 7 | 9.16 | 1 | 102.86 | 25 | SO51793 | 2023-09-28 | 8.23 | 64.12 | 14.69 | |||
SO53509_20 | 4718-4C12-86 | PO11107182902 | 19 | 284 | 287 | 156 | 6 | 2023-11-03 | 607.00 | 15.17 | 2023-10-22 | 3 | 204.63 | 1 | 607.00 | 20 | SO53509 | 2023-10-29 | 48.56 | 613.88 | 202.33 | |||
SO44086_16 | B4B4-44C7-84 | PO17574175064 | 19 | 288 | 212 | 678 | 6 | 2021-11-03 | 100.93 | 2.52 | 2021-10-22 | 5 | 12.03 | 1 | 100.93 | 16 | SO44086 | 2021-10-29 | 8.07 | 60.14 | 20.19 | |||
SO63174_15 | 0B72-4270-AC | PO1827182060 | 19 | 291 | 483 | 317 | 6 | 2024-04-04 | 504.00 | 12.60 | 2024-03-23 | 7 | 44.88 | 1 | 504.00 | 15 | SO63174 | 2024-03-30 | 40.32 | 314.16 | 72.00 | |||
SO51116_18 | B371-45B5-B0 | PO10527115387 | 19 | 284 | 217 | 11 | 480 | 6 | 7.09 | 2023-09-02 | 47.24 | 1.00 | 2023-08-21 | 3 | 13.09 | 1 | 40.15 | 18 | SO51116 | 2023-08-28 | 3.21 | 39.26 | 15.75 | 0.15 |
SO46359_10 | 95FD-4612-88 | PO1740167502 | 19 | 288 | 342 | 460 | 6 | 2022-08-03 | 838.92 | 20.97 | 2022-07-22 | 2 | 413.15 | 1 | 838.92 | 10 | SO46359 | 2022-07-29 | 67.11 | 826.29 | 419.46 | |||
SO51132_23 | D4A8-472C-A4 | PO18444136544 | 19 | 291 | 583 | 227 | 6 | 2023-09-02 | 8164.75 | 204.12 | 2023-08-21 | 8 | 1082.51 | 1 | 8164.75 | 23 | SO51132 | 2023-08-28 | 653.18 | 8660.08 | 1020.59 | |||
SO46997_7 | 9714-4035-90 | PO11020181604 | 19 | 284 | 389 | 336 | 6 | 2022-10-03 | 2401.05 | 60.03 | 2022-09-21 | 4 | 605.65 | 1 | 2401.05 | 7 | SO46997 | 2022-09-28 | 192.08 | 2422.60 | 600.26 | |||
SO51113_10 | C890-4CA6-90 | PO11136135505 | 19 | 284 | 576 | 120 | 6 | 2023-09-02 | 1430.44 | 35.76 | 2023-08-21 | 1 | 1481.94 | 1 | 1430.44 | 10 | SO51113 | 2023-08-28 | 114.44 | 1481.94 | 1430.44 | |||
SO49041_2 | F980-4BCB-AB | PO19691174434 | 19 | 291 | 468 | 353 | 6 | 2023-04-05 | 45.59 | 1.14 | 2023-03-24 | 2 | 15.67 | 1 | 45.59 | 2 | SO49041 | 2023-03-31 | 3.65 | 31.34 | 22.79 | |||
SO55245_9 | B5AD-476D-B4 | PO14732112185 | 19 | 291 | 463 | 514 | 6 | 2023-12-03 | 14.69 | 0.37 | 2023-11-21 | 1 | 9.16 | 1 | 14.69 | 9 | SO55245 | 2023-11-28 | 1.18 | 9.16 | 14.69 | |||
SO49879_46 | 7A79-4FB0-85 | PO4495112714 | 19 | 291 | 396 | 496 | 6 | 2023-06-03 | 374.19 | 9.35 | 2023-05-22 | 5 | 55.38 | 1 | 374.19 | 46 | SO49879 | 2023-05-29 | 29.94 | 276.90 | 74.84 | |||
SO69460_6 | D5C8-450E-9F | PO1595193276 | 19 | 284 | 376 | 426 | 6 | 2024-07-03 | 2932.02 | 73.30 | 2024-06-21 | 2 | 1554.95 | 1 | 2932.02 | 6 | SO69460 | 2024-06-28 | 234.56 | 3109.90 | 1466.01 | |||
SO57023_23 | EE6C-4089-A0 | PO17603140236 | 19 | 284 | 287 | 12 | 6 | 2024-01-03 | 1011.66 | 25.29 | 2023-12-22 | 5 | 204.63 | 1 | 1011.66 | 23 | SO57023 | 2023-12-29 | 80.93 | 1023.13 | 202.33 | |||
SO57019_20 | D018-44A0-BF | PO18879140423 | 19 | 291 | 514 | 64 | 6 | 2024-01-03 | 127.80 | 3.20 | 2023-12-22 | 2 | 47.29 | 1 | 127.80 | 20 | SO57019 | 2023-12-29 | 10.22 | 94.57 | 63.90 | |||
SO58932_9 | CE5B-4A8C-96 | PO14761124028 | 19 | 284 | 503 | 408 | 6 | 2024-02-02 | 200.05 | 5.00 | 2024-01-21 | 1 | 199.85 | 1 | 200.05 | 9 | SO58932 | 2024-01-28 | 16.00 | 199.85 | 200.05 | |||
SO71808_29 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 480 | 408 | 6 | 2024-08-03 | 4.12 | 0.10 | 2024-07-22 | 3 | 0.86 | 1 | 4.12 | 29 | SO71808 | 2024-07-29 | 0.33 | 2.57 | 1.37 | |||
SO50265_33 | 6C30-435D-9D | PO18705169014 | 19 | 291 | 369 | 479 | 6 | 2023-07-03 | 4398.03 | 109.95 | 2023-06-21 | 3 | 1518.79 | 1 | 4398.03 | 33 | SO50265 | 2023-06-28 | 351.84 | 4556.36 | 1466.01 | |||
SO65187_1 | E489-4A03-98 | PO14935166058 | 19 | 291 | 565 | 443 | 6 | 2024-05-03 | 445.41 | 11.14 | 2024-04-21 | 1 | 461.44 | 1 | 445.41 | 1 | SO65187 | 2024-04-28 | 35.63 | 461.44 | 445.41 | |||
SO44744_10 | 6D80-4E9D-83 | PO19401124443 | 19 | 288 | 312 | 173 | 6 | 2022-02-02 | 4293.92 | 107.35 | 2022-01-21 | 2 | 2171.29 | 1 | 4293.92 | 10 | SO44744 | 2022-01-28 | 343.51 | 4342.59 | 2146.96 | |||
SO57159_2 | DDBB-4887-AA | PO2262133775 | 19 | 291 | 494 | 629 | 6 | 2024-01-03 | 1204.69 | 30.12 | 2023-12-22 | 2 | 601.74 | 1 | 1204.69 | 2 | SO57159 | 2023-12-29 | 96.38 | 1203.49 | 602.35 | |||
SO71830_16 | DA2D-4B00-A4 | PO10875112195 | 19 | 291 | 554 | 281 | 6 | 2024-08-03 | 109.88 | 2.75 | 2024-07-22 | 2 | 40.66 | 1 | 109.88 | 16 | SO71830 | 2024-07-29 | 8.79 | 81.31 | 54.94 | |||
SO47359_1 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 305 | 118 | 6 | 2022-11-03 | 1472.29 | 36.81 | 2022-10-22 | 2 | 653.70 | 1 | 1472.29 | 1 | SO47359 | 2022-10-29 | 117.78 | 1307.39 | 736.15 | |||
SO44496_17 | 6ADA-4A25-AA | PO18415194469 | 19 | 288 | 336 | 191 | 6 | 2022-01-03 | 1258.38 | 31.46 | 2021-12-22 | 3 | 413.15 | 1 | 1258.38 | 17 | SO44496 | 2021-12-29 | 100.67 | 1239.44 | 419.46 | |||
SO48025_4 | AE8D-4A49-83 | PO10469118037 | 19 | 291 | 360 | 335 | 6 | 2023-01-03 | 1229.46 | 30.74 | 2022-12-22 | 1 | 1105.81 | 1 | 1229.46 | 4 | SO48025 | 2022-12-29 | 98.36 | 1105.81 | 1229.46 | |||
SO50680_3 | FA18-4AE1-91 | PO12876114100 | 19 | 284 | 273 | 300 | 6 | 2023-08-03 | 202.33 | 5.06 | 2023-07-22 | 1 | 187.16 | 1 | 202.33 | 3 | SO50680 | 2023-07-29 | 16.19 | 187.16 | 202.33 | |||
SO67268_29 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 484 | 299 | 6 | 2024-06-03 | 47.70 | 1.19 | 2024-05-22 | 10 | 2.97 | 1 | 47.70 | 29 | SO67268 | 2024-05-29 | 3.82 | 29.73 | 4.77 | |||
SO69522_27 | 28C3-4615-8B | PO4901187436 | 19 | 284 | 545 | 84 | 6 | 2024-07-03 | 24.29 | 0.61 | 2024-06-21 | 1 | 17.98 | 1 | 24.29 | 27 | SO69522 | 2024-06-28 | 1.94 | 17.98 | 24.29 | |||
SO47013_17 | 4AB0-4FA0-95 | PO1827132360 | 19 | 291 | 280 | 317 | 6 | 2022-10-03 | 735.75 | 18.39 | 2022-09-21 | 4 | 170.14 | 1 | 735.75 | 17 | SO47013 | 2022-09-28 | 58.86 | 680.57 | 183.94 | |||
SO46607_22 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 370 | 227 | 6 | 2022-09-02 | 4398.03 | 109.95 | 2022-08-21 | 3 | 1518.79 | 1 | 4398.03 | 22 | SO46607 | 2022-08-28 | 351.84 | 4556.36 | 1466.01 |
Generated 2024-09-20 12:47:24.258 UTC