[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ ALL SKIP 3000 SHUFFLE < SKIP 844 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46356_12 | 30BA-40DA-B4 | PO783139385 | 100 | 286 | 235 | 91 | 1 | 2022-09-23 | 28.84 | 0.72 | 2022-09-11 | 1 | 31.72 | 1 | 28.84 | 12 | SO46356 | 2022-09-18 | 2.31 | 31.72 | 28.84 | |||
SO48341_2 | A747-471B-97 | PO10701176180 | 100 | 282 | 233 | 133 | 4 | 2023-03-25 | 230.72 | 5.77 | 2023-03-13 | 8 | 29.08 | 1 | 230.72 | 2 | SO48341 | 2023-03-20 | 18.46 | 232.65 | 28.84 | |||
SO71874_1 | CEF3-4107-B2 | PO8990155201 | 6 | 294 | 576 | 501 | 9 | 2024-09-23 | 1430.44 | 35.76 | 2024-09-11 | 1 | 1481.94 | 1 | 1430.44 | 1 | SO71874 | 2024-09-18 | 114.44 | 1481.94 | 1430.44 | |||
SO59064_18 | AE68-4CAD-B8 | PO8671111477 | 98 | 290 | 558 | 502 | 10 | 2024-03-24 | 971.98 | 24.30 | 2024-03-12 | 4 | 179.82 | 1 | 971.98 | 18 | SO59064 | 2024-03-19 | 77.76 | 719.26 | 242.99 | |||
SO63136_13 | 0873-484A-AE | PO18328125904 | 19 | 284 | 374 | 552 | 6 | 2024-05-25 | 2932.02 | 73.30 | 2024-05-13 | 2 | 1554.95 | 1 | 2932.02 | 13 | SO63136 | 2024-05-20 | 234.56 | 3109.90 | 1466.01 | |||
SO47359_19 | 8BC9-458A-82 | PO18299145297 | 19 | 291 | 421 | 2 | 118 | 6 | 41.75 | 2022-12-24 | 2087.63 | 51.15 | 2022-12-12 | 11 | 145.28 | 1 | 2045.88 | 19 | SO47359 | 2022-12-19 | 163.67 | 1598.12 | 189.78 | 0.02 |
SO67339_30 | E214-4902-AC | PO3509143630 | 36 | 292 | 237 | 139 | 7 | 2024-07-24 | 149.97 | 3.75 | 2024-07-12 | 5 | 38.49 | 1 | 149.97 | 30 | SO67339 | 2024-07-19 | 12.00 | 192.46 | 29.99 | |||
SO45323_2 | 8E16-4834-8A | PO4901118407 | 19 | 284 | 334 | 84 | 6 | 2022-05-26 | 419.46 | 10.49 | 2022-05-14 | 1 | 413.15 | 1 | 419.46 | 2 | SO45323 | 2022-05-21 | 33.56 | 413.15 | 419.46 | |||
SO47716_5 | 619E-46D6-98 | PO6467148836 | 100 | 281 | 381 | 660 | 3 | 2023-01-23 | 1800.79 | 45.02 | 2023-01-11 | 3 | 605.65 | 1 | 1800.79 | 5 | SO47716 | 2023-01-18 | 144.06 | 1816.95 | 600.26 | |||
SO47992_40 | 3F55-4354-BD | PO15573158216 | 100 | 293 | 365 | 487 | 1 | 2023-02-23 | 2591.98 | 64.80 | 2023-02-11 | 4 | 598.44 | 1 | 2591.98 | 40 | SO47992 | 2023-02-18 | 207.36 | 2393.74 | 647.99 | |||
SO46626_28 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 461 | 355 | 7 | 2022-10-23 | 269.97 | 6.75 | 2022-10-11 | 5 | 37.12 | 1 | 269.97 | 28 | SO46626 | 2022-10-18 | 21.60 | 185.60 | 53.99 | |||
SO46668_19 | 6711-47BE-BF | PO7859142972 | 100 | 287 | 325 | 221 | 4 | 2022-10-23 | 2818.76 | 70.47 | 2022-10-11 | 6 | 486.71 | 1 | 2818.76 | 19 | SO46668 | 2022-10-18 | 225.50 | 2920.24 | 469.79 | |||
SO51145_6 | BBD2-4A22-8C | PO7105118870 | 100 | 293 | 231 | 668 | 1 | 2023-10-23 | 149.97 | 3.75 | 2023-10-11 | 5 | 38.49 | 1 | 149.97 | 6 | SO51145 | 2023-10-18 | 12.00 | 192.46 | 29.99 | |||
SO47994_31 | 284B-45A1-94 | PO15196121630 | 100 | 282 | 381 | 258 | 4 | 2023-02-23 | 600.26 | 15.01 | 2023-02-11 | 1 | 605.65 | 1 | 600.26 | 31 | SO47994 | 2023-02-18 | 48.02 | 605.65 | 600.26 | |||
SO71894_38 | 8013-4FC0-B4 | PO7685115663 | 100 | 283 | 574 | 539 | 2 | 2024-09-23 | 7152.21 | 178.81 | 2024-09-11 | 5 | 1481.94 | 1 | 7152.21 | 38 | SO71894 | 2024-09-18 | 572.18 | 7409.69 | 1430.44 | |||
SO59071_12 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 376 | 170 | 5 | 2024-03-24 | 1466.01 | 36.65 | 2024-03-12 | 1 | 1554.95 | 1 | 1466.01 | 12 | SO59071 | 2024-03-19 | 117.28 | 1554.95 | 1466.01 | |||
SO55303_6 | 5C9C-4B35-B8 | PO5626137276 | 100 | 281 | 408 | 166 | 4 | 2024-01-23 | 72.16 | 1.80 | 2024-01-11 | 1 | 53.40 | 1 | 72.16 | 6 | SO55303 | 2024-01-18 | 5.77 | 53.40 | 72.16 | |||
SO46645_26 | F857-4A6D-9C | PO1711132491 | 19 | 291 | 367 | 245 | 6 | 2022-10-23 | 5831.95 | 145.80 | 2022-10-11 | 9 | 598.44 | 1 | 5831.95 | 26 | SO46645 | 2022-10-18 | 466.56 | 5385.92 | 647.99 | |||
SO67302_8 | E4B2-462D-AC | PO18473194134 | 19 | 291 | 558 | 442 | 6 | 2024-07-24 | 242.99 | 6.07 | 2024-07-12 | 1 | 179.82 | 1 | 242.99 | 8 | SO67302 | 2024-07-19 | 19.44 | 179.82 | 242.99 | |||
SO49092_24 | 72CE-4E29-82 | PO14442163644 | 100 | 293 | 236 | 127 | 1 | 2023-05-26 | 86.52 | 2.16 | 2023-05-14 | 3 | 29.08 | 1 | 86.52 | 24 | SO49092 | 2023-05-21 | 6.92 | 87.24 | 28.84 | |||
SO47067_10 | DDEC-4319-8A | PO9512118933 | 100 | 285 | 325 | 135 | 5 | 2022-11-23 | 469.79 | 11.74 | 2022-11-11 | 1 | 486.71 | 1 | 469.79 | 10 | SO47067 | 2022-11-18 | 37.58 | 486.71 | 469.79 | |||
SO51773_13 | 14B1-48BF-A0 | PO2523163173 | 100 | 287 | 472 | 167 | 4 | 2023-11-23 | 266.70 | 6.67 | 2023-11-11 | 7 | 23.75 | 1 | 266.70 | 13 | SO51773 | 2023-11-18 | 21.34 | 166.24 | 38.10 | |||
SO53603_1 | D324-4435-B1 | PO3277197939 | 100 | 293 | 482 | 604 | 1 | 2023-12-24 | 48.55 | 1.21 | 2023-12-12 | 9 | 3.36 | 1 | 48.55 | 1 | SO53603 | 2023-12-19 | 3.88 | 30.26 | 5.39 | |||
SO49133_1 | 50D5-4F65-92 | PO9512136037 | 100 | 285 | 333 | 135 | 5 | 2023-05-26 | 469.79 | 11.74 | 2023-05-14 | 1 | 486.71 | 1 | 469.79 | 1 | SO49133 | 2023-05-21 | 37.58 | 486.71 | 469.79 | |||
SO46105_24 | 2590-40A7-BB | PO8816169858 | 100 | 289 | 270 | 218 | 1 | 2022-08-23 | 551.81 | 13.80 | 2022-08-11 | 3 | 181.49 | 1 | 551.81 | 24 | SO46105 | 2022-08-18 | 44.15 | 544.46 | 183.94 | |||
SO51151_3 | D7A9-4DF6-B9 | PO8787179219 | 100 | 282 | 386 | 523 | 3 | 2023-10-23 | 2016.88 | 50.42 | 2023-10-11 | 3 | 713.08 | 1 | 2016.88 | 3 | SO51151 | 2023-10-18 | 161.35 | 2139.24 | 672.29 | |||
SO47995_11 | E14D-40EA-B3 | PO15254116423 | 100 | 281 | 233 | 377 | 3 | 2023-02-23 | 28.84 | 0.72 | 2023-02-11 | 1 | 29.08 | 1 | 28.84 | 11 | SO47995 | 2023-02-18 | 2.31 | 29.08 | 28.84 | |||
SO46992_18 | C958-4FD6-A0 | PO11745117547 | 100 | 282 | 435 | 97 | 4 | 2022-11-23 | 1622.26 | 40.56 | 2022-11-11 | 5 | 300.12 | 1 | 1622.26 | 18 | SO46992 | 2022-11-18 | 129.78 | 1500.59 | 324.45 | |||
SO71808_16 | 2E63-4616-B1 | PO14761198562 | 19 | 284 | 568 | 408 | 6 | 2024-09-23 | 890.82 | 22.27 | 2024-09-11 | 2 | 461.44 | 1 | 890.82 | 16 | SO71808 | 2024-09-18 | 71.27 | 922.89 | 445.41 | |||
SO46378_1 | 9841-4556-A9 | PO6873118856 | 100 | 283 | 322 | 238 | 3 | 2022-09-23 | 838.92 | 20.97 | 2022-09-11 | 2 | 413.15 | 1 | 838.92 | 1 | SO46378 | 2022-09-18 | 67.11 | 826.29 | 419.46 | |||
SO45283_17 | 07F7-44C2-BA | PO16646111452 | 100 | 286 | 312 | 1 | 1 | 2022-05-26 | 2146.96 | 53.67 | 2022-05-14 | 1 | 2171.29 | 1 | 2146.96 | 17 | SO45283 | 2022-05-21 | 171.76 | 2171.29 | 2146.96 |
Generated 2024-11-10 07:51:27.992 UTC