[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 2481 > < TAKE 48 >
48 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51756_1 | 94CE-456E-89 | PO10469141722 | 19 | 291 | 517 | 335 | 6 | 2023-11-27 | 31.58 | 0.79 | 2023-11-15 | 1 | 23.37 | 1 | 31.58 | 1 | SO51756 | 2023-11-22 | 2.53 | 23.37 | 31.58 | |||
SO51757_1 | 5056-414C-86 | PO10498137557 | 19 | 291 | 511 | 316 | 6 | 2023-11-27 | 436.91 | 10.92 | 2023-11-15 | 2 | 199.38 | 1 | 436.91 | 1 | SO51757 | 2023-11-22 | 34.95 | 398.75 | 218.45 | |||
SO51757_2 | 5056-414C-86 | PO10498137557 | 19 | 291 | 544 | 316 | 6 | 2023-11-27 | 48.59 | 1.21 | 2023-11-15 | 1 | 35.96 | 1 | 48.59 | 2 | SO51757 | 2023-11-22 | 3.89 | 35.96 | 48.59 | |||
SO51757_3 | 5056-414C-86 | PO10498137557 | 19 | 291 | 483 | 316 | 6 | 2023-11-27 | 72.00 | 1.80 | 2023-11-15 | 1 | 44.88 | 1 | 72.00 | 3 | SO51757 | 2023-11-22 | 5.76 | 44.88 | 72.00 | |||
SO51757_4 | 5056-414C-86 | PO10498137557 | 19 | 291 | 476 | 316 | 6 | 2023-11-27 | 125.98 | 3.15 | 2023-11-15 | 3 | 26.18 | 1 | 125.98 | 4 | SO51757 | 2023-11-22 | 10.08 | 78.53 | 41.99 | |||
SO51757_5 | 5056-414C-86 | PO10498137557 | 19 | 291 | 542 | 316 | 6 | 2023-11-27 | 72.88 | 1.82 | 2023-11-15 | 3 | 17.98 | 1 | 72.88 | 5 | SO51757 | 2023-11-22 | 5.83 | 53.93 | 24.29 | |||
SO51766_1 | 1118-4A2A-80 | PO638122353 | 19 | 291 | 475 | 280 | 6 | 2023-11-27 | 83.99 | 2.10 | 2023-11-15 | 2 | 26.18 | 1 | 83.99 | 1 | SO51766 | 2023-11-22 | 6.72 | 52.35 | 41.99 | |||
SO51766_2 | 1118-4A2A-80 | PO638122353 | 19 | 291 | 214 | 280 | 6 | 2023-11-27 | 83.98 | 2.10 | 2023-11-15 | 4 | 13.09 | 1 | 83.98 | 2 | SO51766 | 2023-11-22 | 6.72 | 52.35 | 20.99 | |||
SO51766_3 | 1118-4A2A-80 | PO638122353 | 19 | 291 | 544 | 280 | 6 | 2023-11-27 | 97.19 | 2.43 | 2023-11-15 | 2 | 35.96 | 1 | 97.19 | 3 | SO51766 | 2023-11-22 | 7.78 | 71.92 | 48.59 | |||
SO51766_4 | 1118-4A2A-80 | PO638122353 | 19 | 291 | 542 | 280 | 6 | 2023-11-27 | 72.88 | 1.82 | 2023-11-15 | 3 | 17.98 | 1 | 72.88 | 4 | SO51766 | 2023-11-22 | 5.83 | 53.93 | 24.29 | |||
SO51766_5 | 1118-4A2A-80 | PO638122353 | 19 | 291 | 465 | 280 | 6 | 2023-11-27 | 73.47 | 1.84 | 2023-11-15 | 5 | 9.16 | 1 | 73.47 | 5 | SO51766 | 2023-11-22 | 5.88 | 45.80 | 14.69 | |||
SO51766_6 | 1118-4A2A-80 | PO638122353 | 19 | 291 | 474 | 280 | 6 | 2023-11-27 | 167.98 | 4.20 | 2023-11-15 | 4 | 26.18 | 1 | 167.98 | 6 | SO51766 | 2023-11-22 | 13.44 | 104.71 | 41.99 | |||
SO51766_7 | 1118-4A2A-80 | PO638122353 | 19 | 291 | 477 | 280 | 6 | 2023-11-27 | 2.99 | 0.07 | 2023-11-15 | 1 | 1.87 | 1 | 2.99 | 7 | SO51766 | 2023-11-22 | 0.24 | 1.87 | 2.99 | |||
SO51766_8 | 1118-4A2A-80 | PO638122353 | 19 | 291 | 517 | 280 | 6 | 2023-11-27 | 31.58 | 0.79 | 2023-11-15 | 1 | 23.37 | 1 | 31.58 | 8 | SO51766 | 2023-11-22 | 2.53 | 23.37 | 31.58 | |||
SO51766_9 | 1118-4A2A-80 | PO638122353 | 19 | 291 | 511 | 280 | 6 | 2023-11-27 | 436.91 | 10.92 | 2023-11-15 | 2 | 199.38 | 1 | 436.91 | 9 | SO51766 | 2023-11-22 | 34.95 | 398.75 | 218.45 | |||
SO44547_4 | 801C-4288-87 | PO4901179982 | 19 | 284 | 338 | 84 | 6 | 2022-02-27 | 1677.84 | 41.95 | 2022-02-15 | 4 | 413.15 | 1 | 1677.84 | 4 | SO44547 | 2022-02-22 | 134.23 | 1652.59 | 419.46 | |||
SO44547_5 | 801C-4288-87 | PO4901179982 | 19 | 284 | 316 | 84 | 6 | 2022-02-27 | 4373.97 | 109.35 | 2022-02-15 | 5 | 884.71 | 1 | 4373.97 | 5 | SO44547 | 2022-02-22 | 349.92 | 4423.54 | 874.79 | |||
SO44547_6 | 801C-4288-87 | PO4901179982 | 19 | 284 | 332 | 84 | 6 | 2022-02-27 | 1677.84 | 41.95 | 2022-02-15 | 4 | 413.15 | 1 | 1677.84 | 6 | SO44547 | 2022-02-22 | 134.23 | 1652.59 | 419.46 | |||
SO44547_7 | 801C-4288-87 | PO4901179982 | 19 | 284 | 319 | 84 | 6 | 2022-02-27 | 6998.35 | 174.96 | 2022-02-15 | 8 | 884.71 | 1 | 6998.35 | 7 | SO44547 | 2022-02-22 | 559.87 | 7077.67 | 874.79 | |||
SO44547_8 | 801C-4288-87 | PO4901179982 | 19 | 284 | 285 | 84 | 6 | 2022-02-27 | 535.74 | 13.39 | 2022-02-15 | 3 | 176.20 | 1 | 535.74 | 8 | SO44547 | 2022-02-22 | 42.86 | 528.60 | 178.58 | |||
SO44547_9 | 801C-4288-87 | PO4901179982 | 19 | 284 | 314 | 84 | 6 | 2022-02-27 | 12881.77 | 322.04 | 2022-02-15 | 6 | 2171.29 | 1 | 12881.77 | 9 | SO44547 | 2022-02-22 | 1030.54 | 13027.77 | 2146.96 | |||
SO44547_10 | 801C-4288-87 | PO4901179982 | 19 | 284 | 310 | 84 | 6 | 2022-02-27 | 10734.81 | 268.37 | 2022-02-15 | 5 | 2171.29 | 1 | 10734.81 | 10 | SO44547 | 2022-02-22 | 858.78 | 10856.47 | 2146.96 | |||
SO44547_11 | 801C-4288-87 | PO4901179982 | 19 | 284 | 232 | 84 | 6 | 2022-02-27 | 173.04 | 4.33 | 2022-02-15 | 6 | 31.72 | 1 | 173.04 | 11 | SO44547 | 2022-02-22 | 13.84 | 190.35 | 28.84 | |||
SO44547_12 | 801C-4288-87 | PO4901179982 | 19 | 284 | 317 | 84 | 6 | 2022-02-27 | 2624.38 | 65.61 | 2022-02-15 | 3 | 884.71 | 1 | 2624.38 | 12 | SO44547 | 2022-02-22 | 209.95 | 2654.12 | 874.79 | |||
SO44547_13 | 801C-4288-87 | PO4901179982 | 19 | 284 | 253 | 84 | 6 | 2022-02-27 | 357.16 | 8.93 | 2022-02-15 | 2 | 176.20 | 1 | 357.16 | 13 | SO44547 | 2022-02-22 | 28.57 | 352.40 | 178.58 | |||
SO44547_14 | 801C-4288-87 | PO4901179982 | 19 | 284 | 275 | 84 | 6 | 2022-02-27 | 713.80 | 17.84 | 2022-02-15 | 2 | 352.14 | 1 | 713.80 | 14 | SO44547 | 2022-02-22 | 57.10 | 704.28 | 356.90 | |||
SO44547_15 | 801C-4288-87 | PO4901179982 | 19 | 284 | 326 | 84 | 6 | 2022-02-27 | 2097.29 | 52.43 | 2022-02-15 | 5 | 413.15 | 1 | 2097.29 | 15 | SO44547 | 2022-02-22 | 167.78 | 2065.73 | 419.46 | |||
SO44547_16 | 801C-4288-87 | PO4901179982 | 19 | 284 | 235 | 84 | 6 | 2022-02-27 | 57.68 | 1.44 | 2022-02-15 | 2 | 31.72 | 1 | 57.68 | 16 | SO44547 | 2022-02-22 | 4.61 | 63.45 | 28.84 | |||
SO44547_17 | 801C-4288-87 | PO4901179982 | 19 | 284 | 229 | 84 | 6 | 2022-02-27 | 115.36 | 2.88 | 2022-02-15 | 4 | 31.72 | 1 | 115.36 | 17 | SO44547 | 2022-02-22 | 9.23 | 126.90 | 28.84 | |||
SO44547_18 | 801C-4288-87 | PO4901179982 | 19 | 284 | 270 | 84 | 6 | 2022-02-27 | 367.88 | 9.20 | 2022-02-15 | 2 | 181.49 | 1 | 367.88 | 18 | SO44547 | 2022-02-22 | 29.43 | 362.97 | 183.94 | |||
SO44547_19 | 801C-4288-87 | PO4901179982 | 19 | 284 | 264 | 84 | 6 | 2022-02-27 | 183.94 | 4.60 | 2022-02-15 | 1 | 181.49 | 1 | 183.94 | 19 | SO44547 | 2022-02-22 | 14.72 | 181.49 | 183.94 | |||
SO44547_20 | 801C-4288-87 | PO4901179982 | 19 | 284 | 330 | 84 | 6 | 2022-02-27 | 1677.84 | 41.95 | 2022-02-15 | 4 | 413.15 | 1 | 1677.84 | 20 | SO44547 | 2022-02-22 | 134.23 | 1652.59 | 419.46 | |||
SO44547_21 | 801C-4288-87 | PO4901179982 | 19 | 284 | 322 | 84 | 6 | 2022-02-27 | 2097.29 | 52.43 | 2022-02-15 | 5 | 413.15 | 1 | 2097.29 | 21 | SO44547 | 2022-02-22 | 167.78 | 2065.73 | 419.46 | |||
SO44547_22 | 801C-4288-87 | PO4901179982 | 19 | 284 | 328 | 84 | 6 | 2022-02-27 | 838.92 | 20.97 | 2022-02-15 | 2 | 413.15 | 1 | 838.92 | 22 | SO44547 | 2022-02-22 | 67.11 | 826.29 | 419.46 | |||
SO44547_23 | 801C-4288-87 | PO4901179982 | 19 | 284 | 215 | 84 | 6 | 2022-02-27 | 181.68 | 4.54 | 2022-02-15 | 9 | 12.03 | 1 | 181.68 | 23 | SO44547 | 2022-02-22 | 14.53 | 108.25 | 20.19 | |||
SO44547_24 | 801C-4288-87 | PO4901179982 | 19 | 284 | 324 | 84 | 6 | 2022-02-27 | 2936.21 | 73.41 | 2022-02-15 | 7 | 413.15 | 1 | 2936.21 | 24 | SO44547 | 2022-02-22 | 234.90 | 2892.02 | 419.46 | |||
SO44547_25 | 801C-4288-87 | PO4901179982 | 19 | 284 | 276 | 84 | 6 | 2022-02-27 | 1070.69 | 26.77 | 2022-02-15 | 3 | 352.14 | 1 | 1070.69 | 25 | SO44547 | 2022-02-22 | 85.66 | 1056.42 | 356.90 | |||
SO44547_26 | 801C-4288-87 | PO4901179982 | 19 | 284 | 342 | 84 | 6 | 2022-02-27 | 2516.75 | 62.92 | 2022-02-15 | 6 | 413.15 | 1 | 2516.75 | 26 | SO44547 | 2022-02-22 | 201.34 | 2478.88 | 419.46 | |||
SO44547_27 | 801C-4288-87 | PO4901179982 | 19 | 284 | 272 | 84 | 6 | 2022-02-27 | 551.81 | 13.80 | 2022-02-15 | 3 | 181.49 | 1 | 551.81 | 27 | SO44547 | 2022-02-22 | 44.15 | 544.46 | 183.94 | |||
SO44547_28 | 801C-4288-87 | PO4901179982 | 19 | 284 | 315 | 2 | 84 | 6 | 219.86 | 2022-02-27 | 10993.24 | 269.33 | 2022-02-15 | 13 | 884.71 | 1 | 10773.38 | 28 | SO44547 | 2022-02-22 | 861.87 | 11501.21 | 845.63 | 0.02 |
SO44547_29 | 801C-4288-87 | PO4901179982 | 19 | 284 | 223 | 84 | 6 | 2022-02-27 | 51.87 | 1.30 | 2022-02-15 | 10 | 5.71 | 1 | 51.87 | 29 | SO44547 | 2022-02-22 | 4.15 | 57.05 | 5.19 | |||
SO44560_1 | CED4-47AE-86 | PO6960179699 | 19 | 288 | 279 | 532 | 6 | 2022-02-27 | 178.58 | 4.46 | 2022-02-15 | 1 | 176.20 | 1 | 178.58 | 1 | SO44560 | 2022-02-22 | 14.29 | 176.20 | 178.58 | |||
SO44560_2 | CED4-47AE-86 | PO6960179699 | 19 | 288 | 241 | 532 | 6 | 2022-02-27 | 758.08 | 18.95 | 2022-02-15 | 1 | 747.97 | 1 | 758.08 | 2 | SO44560 | 2022-02-22 | 60.65 | 747.97 | 758.08 | |||
SO44744_1 | 6D80-4E9D-83 | PO19401124443 | 19 | 288 | 310 | 173 | 6 | 2022-03-29 | 4293.92 | 107.35 | 2022-03-17 | 2 | 2171.29 | 1 | 4293.92 | 1 | SO44744 | 2022-03-24 | 343.51 | 4342.59 | 2146.96 | |||
SO44744_2 | 6D80-4E9D-83 | PO19401124443 | 19 | 288 | 223 | 173 | 6 | 2022-03-29 | 15.56 | 0.39 | 2022-03-17 | 3 | 5.71 | 1 | 15.56 | 2 | SO44744 | 2022-03-24 | 1.24 | 17.12 | 5.19 | |||
SO44744_3 | 6D80-4E9D-83 | PO19401124443 | 19 | 288 | 220 | 173 | 6 | 2022-03-29 | 20.19 | 0.50 | 2022-03-17 | 1 | 12.03 | 1 | 20.19 | 3 | SO44744 | 2022-03-24 | 1.61 | 12.03 | 20.19 | |||
SO44744_4 | 6D80-4E9D-83 | PO19401124443 | 19 | 288 | 235 | 173 | 6 | 2022-03-29 | 144.20 | 3.61 | 2022-03-17 | 5 | 31.72 | 1 | 144.20 | 4 | SO44744 | 2022-03-24 | 11.54 | 158.62 | 28.84 | |||
SO44744_5 | 6D80-4E9D-83 | PO19401124443 | 19 | 288 | 338 | 173 | 6 | 2022-03-29 | 419.46 | 10.49 | 2022-03-17 | 1 | 413.15 | 1 | 419.46 | 5 | SO44744 | 2022-03-24 | 33.56 | 413.15 | 419.46 |
Generated 2024-11-14 17:01:35.942 UTC