[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 2706 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50784_1 | 100 | 14498 | 383 | 4 | 2023-09-24 | 25.01 | 2023-09-12 | 1000.44 | 1 | SO50784 | 2023-09-19 | 80.04 | 605.65 | |
SO50788_1 | 100 | 27575 | 354 | 4 | 2023-09-25 | 51.79 | 2023-09-13 | 2071.42 | 1 | SO50788 | 2023-09-20 | 165.71 | 1117.86 | |
SO50792_1 | 100 | 15972 | 323 | 4 | 2023-09-25 | 19.57 | 2023-09-13 | 782.99 | 1 | SO50792 | 2023-09-20 | 62.64 | 486.71 | |
SO50793_1 | 100 | 14457 | 383 | 4 | 2023-09-25 | 25.01 | 2023-09-13 | 1000.44 | 1 | SO50793 | 2023-09-20 | 80.04 | 605.65 | |
SO50801_1 | 100 | 15989 | 335 | 4 | 2023-09-26 | 19.57 | 2023-09-14 | 782.99 | 1 | SO50801 | 2023-09-21 | 62.64 | 486.71 | |
SO50805_1 | 100 | 14471 | 385 | 4 | 2023-09-26 | 25.01 | 2023-09-14 | 1000.44 | 1 | SO50805 | 2023-09-21 | 80.04 | 605.65 | |
SO50809_1 | 100 | 14484 | 387 | 4 | 2023-09-27 | 25.01 | 2023-09-15 | 1000.44 | 1 | SO50809 | 2023-09-22 | 80.04 | 605.65 | |
SO50814_1 | 100 | 27547 | 356 | 4 | 2023-09-28 | 51.79 | 2023-09-16 | 2071.42 | 1 | SO50814 | 2023-09-23 | 165.71 | 1117.86 | |
SO50831_1 | 100 | 15961 | 325 | 4 | 2023-09-29 | 19.57 | 2023-09-17 | 782.99 | 1 | SO50831 | 2023-09-24 | 62.64 | 486.71 | |
SO50832_1 | 100 | 14477 | 381 | 4 | 2023-09-29 | 25.01 | 2023-09-17 | 1000.44 | 1 | SO50832 | 2023-09-24 | 80.04 | 605.65 | |
SO50836_1 | 100 | 27535 | 358 | 4 | 2023-09-30 | 51.23 | 2023-09-18 | 2049.10 | 1 | SO50836 | 2023-09-25 | 163.93 | 1105.81 | |
SO50837_1 | 100 | 27537 | 352 | 4 | 2023-09-30 | 51.79 | 2023-09-18 | 2071.42 | 1 | SO50837 | 2023-09-25 | 165.71 | 1117.86 | |
SO50838_1 | 100 | 27573 | 352 | 4 | 2023-09-30 | 51.79 | 2023-09-18 | 2071.42 | 1 | SO50838 | 2023-09-25 | 165.71 | 1117.86 | |
SO50847_1 | 100 | 15953 | 325 | 4 | 2023-09-30 | 19.57 | 2023-09-18 | 782.99 | 1 | SO50847 | 2023-09-25 | 62.64 | 486.71 | |
SO50848_1 | 100 | 15986 | 335 | 4 | 2023-09-30 | 19.57 | 2023-09-18 | 782.99 | 1 | SO50848 | 2023-09-25 | 62.64 | 486.71 | |
SO50861_1 | 100 | 27534 | 356 | 4 | 2023-10-02 | 51.79 | 2023-09-20 | 2071.42 | 1 | SO50861 | 2023-09-27 | 165.71 | 1117.86 | |
SO50862_1 | 100 | 27541 | 356 | 4 | 2023-10-02 | 51.79 | 2023-09-20 | 2071.42 | 1 | SO50862 | 2023-09-27 | 165.71 | 1117.86 | |
SO50863_1 | 100 | 27552 | 356 | 4 | 2023-10-02 | 51.79 | 2023-09-20 | 2071.42 | 1 | SO50863 | 2023-09-27 | 165.71 | 1117.86 | |
SO50867_1 | 100 | 15964 | 343 | 4 | 2023-10-02 | 19.57 | 2023-09-20 | 782.99 | 1 | SO50867 | 2023-09-27 | 62.64 | 486.71 | |
SO50868_1 | 100 | 14473 | 383 | 4 | 2023-10-02 | 25.01 | 2023-09-20 | 1000.44 | 1 | SO50868 | 2023-09-27 | 80.04 | 605.65 | |
SO50884_1 | 100 | 27543 | 362 | 2 | 4 | 2023-10-04 | 51.23 | 2023-09-22 | 2049.10 | 1 | SO50884 | 2023-09-29 | 163.93 | 1105.81 |
SO50885_1 | 100 | 27572 | 354 | 4 | 2023-10-04 | 51.79 | 2023-09-22 | 2071.42 | 1 | SO50885 | 2023-09-29 | 165.71 | 1117.86 | |
SO50890_1 | 100 | 13984 | 368 | 4 | 2023-10-04 | 61.08 | 2023-09-22 | 2443.35 | 1 | SO50890 | 2023-09-29 | 195.47 | 1518.79 | |
SO50895_1 | 100 | 27555 | 360 | 4 | 2023-10-05 | 51.23 | 2023-09-23 | 2049.10 | 1 | SO50895 | 2023-09-30 | 163.93 | 1105.81 | |
SO50896_1 | 100 | 27569 | 354 | 4 | 2023-10-05 | 51.79 | 2023-09-23 | 2071.42 | 1 | SO50896 | 2023-09-30 | 165.71 | 1117.86 | |
SO50898_1 | 100 | 13948 | 371 | 4 | 2023-10-05 | 54.54 | 2023-09-23 | 2181.56 | 1 | SO50898 | 2023-09-30 | 174.53 | 1320.68 | |
SO50899_1 | 100 | 15983 | 333 | 4 | 2023-10-05 | 19.57 | 2023-09-23 | 782.99 | 1 | SO50899 | 2023-09-30 | 62.64 | 486.71 | |
SO50923_1 | 100 | 15984 | 333 | 4 | 2023-10-07 | 19.57 | 2023-09-25 | 782.99 | 1 | SO50923 | 2023-10-02 | 62.64 | 486.71 | |
SO50937_1 | 100 | 27508 | 356 | 4 | 2023-10-09 | 51.79 | 2023-09-27 | 2071.42 | 1 | SO50937 | 2023-10-04 | 165.71 | 1117.86 | |
SO50947_1 | 100 | 27527 | 352 | 4 | 2023-10-10 | 51.79 | 2023-09-28 | 2071.42 | 1 | SO50947 | 2023-10-05 | 165.71 | 1117.86 | |
SO50953_1 | 100 | 14464 | 387 | 4 | 2023-10-10 | 25.01 | 2023-09-28 | 1000.44 | 1 | SO50953 | 2023-10-05 | 80.04 | 605.65 | |
SO50955_1 | 100 | 27468 | 354 | 4 | 2023-10-11 | 51.79 | 2023-09-29 | 2071.42 | 1 | SO50955 | 2023-10-06 | 165.71 | 1117.86 | |
SO50956_1 | 100 | 27554 | 354 | 4 | 2023-10-11 | 51.79 | 2023-09-29 | 2071.42 | 1 | SO50956 | 2023-10-06 | 165.71 | 1117.86 | |
SO50966_1 | 100 | 15954 | 321 | 4 | 2023-10-11 | 19.57 | 2023-09-29 | 782.99 | 1 | SO50966 | 2023-10-06 | 62.64 | 486.71 | |
SO50967_1 | 100 | 15965 | 321 | 4 | 2023-10-11 | 19.57 | 2023-09-29 | 782.99 | 1 | SO50967 | 2023-10-06 | 62.64 | 486.71 | |
SO50968_1 | 100 | 15968 | 329 | 4 | 2023-10-11 | 19.57 | 2023-09-29 | 782.99 | 1 | SO50968 | 2023-10-06 | 62.64 | 486.71 | |
SO50969_1 | 100 | 27460 | 356 | 4 | 2023-10-12 | 51.79 | 2023-09-30 | 2071.42 | 1 | SO50969 | 2023-10-07 | 165.71 | 1117.86 | |
SO50970_1 | 100 | 27574 | 362 | 2 | 4 | 2023-10-12 | 51.23 | 2023-09-30 | 2049.10 | 1 | SO50970 | 2023-10-07 | 163.93 | 1105.81 |
SO50974_1 | 100 | 14470 | 381 | 4 | 2023-10-12 | 25.01 | 2023-09-30 | 1000.44 | 1 | SO50974 | 2023-10-07 | 80.04 | 605.65 | |
SO50979_1 | 100 | 27459 | 362 | 2 | 4 | 2023-10-13 | 51.23 | 2023-10-01 | 2049.10 | 1 | SO50979 | 2023-10-08 | 163.93 | 1105.81 |
SO50980_1 | 100 | 27540 | 354 | 4 | 2023-10-13 | 51.79 | 2023-10-01 | 2071.42 | 1 | SO50980 | 2023-10-08 | 165.71 | 1117.86 | |
SO50986_1 | 100 | 14485 | 383 | 4 | 2023-10-13 | 25.01 | 2023-10-01 | 1000.44 | 1 | SO50986 | 2023-10-08 | 80.04 | 605.65 | |
SO50987_1 | 100 | 14495 | 387 | 4 | 2023-10-13 | 25.01 | 2023-10-01 | 1000.44 | 1 | SO50987 | 2023-10-08 | 80.04 | 605.65 | |
SO50996_1 | 100 | 27544 | 356 | 4 | 2023-10-14 | 51.79 | 2023-10-02 | 2071.42 | 1 | SO50996 | 2023-10-09 | 165.71 | 1117.86 | |
SO51001_1 | 100 | 27467 | 358 | 4 | 2023-10-15 | 51.23 | 2023-10-03 | 2049.10 | 1 | SO51001 | 2023-10-10 | 163.93 | 1105.81 | |
SO51005_1 | 100 | 15990 | 341 | 4 | 2023-10-15 | 19.57 | 2023-10-03 | 782.99 | 1 | SO51005 | 2023-10-10 | 62.64 | 486.71 | |
SO59260_2 | 100 | 25284 | 217 | 4 | 2024-03-26 | 0.87 | 2024-03-14 | 34.99 | 2 | SO59260 | 2024-03-21 | 2.80 | 13.09 | |
SO59261_1 | 100 | 25404 | 561 | 4 | 2024-03-26 | 59.60 | 2024-03-14 | 2384.07 | 1 | SO59261 | 2024-03-21 | 190.73 | 1481.94 | |
SO59261_2 | 100 | 25404 | 479 | 4 | 2024-03-26 | 0.22 | 2024-03-14 | 8.99 | 2 | SO59261 | 2024-03-21 | 0.72 | 3.36 | |
SO59261_3 | 100 | 25404 | 477 | 4 | 2024-03-26 | 0.12 | 2024-03-14 | 4.99 | 3 | SO59261 | 2024-03-21 | 0.40 | 1.87 | |
SO59261_4 | 100 | 25404 | 214 | 4 | 2024-03-26 | 0.87 | 2024-03-14 | 34.99 | 4 | SO59261 | 2024-03-21 | 2.80 | 13.09 | |
SO59262_1 | 100 | 17676 | 472 | 4 | 2024-03-26 | 1.59 | 2024-03-14 | 63.50 | 1 | SO59262 | 2024-03-21 | 5.08 | 23.75 | |
SO59262_2 | 100 | 17676 | 605 | 4 | 2024-03-26 | 13.50 | 2024-03-14 | 539.99 | 2 | SO59262 | 2024-03-21 | 43.20 | 343.65 | |
SO59263_1 | 100 | 18459 | 604 | 4 | 2024-03-26 | 13.50 | 2024-03-14 | 539.99 | 1 | SO59263 | 2024-03-21 | 43.20 | 343.65 | |
SO59263_2 | 100 | 18459 | 477 | 4 | 2024-03-26 | 0.12 | 2024-03-14 | 4.99 | 2 | SO59263 | 2024-03-21 | 0.40 | 1.87 | |
SO59263_3 | 100 | 18459 | 479 | 4 | 2024-03-26 | 0.22 | 2024-03-14 | 8.99 | 3 | SO59263 | 2024-03-21 | 0.72 | 3.36 | |
SO59263_4 | 100 | 18459 | 214 | 4 | 2024-03-26 | 0.87 | 2024-03-14 | 34.99 | 4 | SO59263 | 2024-03-21 | 2.80 | 13.09 | |
SO59265_1 | 100 | 22256 | 584 | 4 | 2024-03-26 | 13.50 | 2024-03-14 | 539.99 | 1 | SO59265 | 2024-03-21 | 43.20 | 343.65 | |
SO59265_2 | 100 | 22256 | 225 | 4 | 2024-03-26 | 0.22 | 2024-03-14 | 8.99 | 2 | SO59265 | 2024-03-21 | 0.72 | 6.92 | |
SO59265_3 | 100 | 22256 | 538 | 4 | 2024-03-26 | 0.54 | 2024-03-14 | 21.49 | 3 | SO59265 | 2024-03-21 | 1.72 | 8.04 |
Generated 2024-11-10 19:43:06.086 UTC