[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > < SKIP 738 > < TAKE 24 >
24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47728_1 | E70E-4F41-93 | PO9947192869 | 100 | 285 | 377 | 603 | 5 | 2022-12-04 | 1308.94 | 32.72 | 2022-11-22 | 1 | 1320.68 | 1 | 1308.94 | 1 | SO47728 | 2022-11-29 | 104.72 | 1320.68 | 1308.94 | |||
SO51718_10 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 544 | 207 | 5 | 2023-10-04 | 194.38 | 4.86 | 2023-09-22 | 4 | 35.96 | 1 | 194.38 | 10 | SO51718 | 2023-09-29 | 15.55 | 143.84 | 48.59 | |||
SO44305_5 | E906-4DF2-BE | PO522153226 | 100 | 285 | 296 | 676 | 5 | 2021-12-04 | 1429.41 | 35.74 | 2021-11-22 | 2 | 617.03 | 1 | 1429.41 | 5 | SO44305 | 2021-11-29 | 114.35 | 1234.06 | 714.70 | |||
SO47729_1 | B0F0-4705-AD | PO9976143255 | 100 | 285 | 417 | 242 | 5 | 2022-12-04 | 324.45 | 8.11 | 2022-11-22 | 1 | 300.12 | 1 | 324.45 | 1 | SO47729 | 2022-11-29 | 25.96 | 300.12 | 324.45 | |||
SO51718_11 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 214 | 207 | 5 | 2023-10-04 | 83.98 | 2.10 | 2023-09-22 | 4 | 13.09 | 1 | 83.98 | 11 | SO51718 | 2023-09-29 | 6.72 | 52.35 | 20.99 | |||
SO44305_6 | E906-4DF2-BE | PO522153226 | 100 | 285 | 292 | 676 | 5 | 2021-12-04 | 818.70 | 20.47 | 2021-11-22 | 1 | 706.81 | 1 | 818.70 | 6 | SO44305 | 2021-11-29 | 65.50 | 706.81 | 818.70 | |||
SO47965_1 | 953F-437D-84 | PO19546111394 | 100 | 285 | 325 | 206 | 5 | 2023-01-04 | 939.59 | 23.49 | 2022-12-23 | 2 | 486.71 | 1 | 939.59 | 1 | SO47965 | 2022-12-30 | 75.17 | 973.41 | 469.79 | |||
SO51718_12 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 484 | 207 | 5 | 2023-10-04 | 19.08 | 0.48 | 2023-09-22 | 4 | 2.97 | 1 | 19.08 | 12 | SO51718 | 2023-09-29 | 1.53 | 11.89 | 4.77 | |||
SO44305_7 | E906-4DF2-BE | PO522153226 | 100 | 285 | 229 | 676 | 5 | 2021-12-04 | 57.68 | 1.44 | 2021-11-22 | 2 | 31.72 | 1 | 57.68 | 7 | SO44305 | 2021-11-29 | 4.61 | 63.45 | 28.84 | |||
SO47965_2 | 953F-437D-84 | PO19546111394 | 100 | 285 | 373 | 206 | 5 | 2023-01-04 | 2617.88 | 65.45 | 2022-12-23 | 2 | 1320.68 | 1 | 2617.88 | 2 | SO47965 | 2022-12-30 | 209.43 | 2641.37 | 1308.94 | |||
SO51718_13 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 400 | 207 | 5 | 2023-10-04 | 74.30 | 1.86 | 2023-09-22 | 2 | 27.49 | 1 | 74.30 | 13 | SO51718 | 2023-09-29 | 5.94 | 54.99 | 37.15 | |||
SO44305_8 | E906-4DF2-BE | PO522153226 | 100 | 285 | 232 | 676 | 5 | 2021-12-04 | 28.84 | 0.72 | 2021-11-22 | 1 | 31.72 | 1 | 28.84 | 8 | SO44305 | 2021-11-29 | 2.31 | 31.72 | 28.84 | |||
SO47965_3 | 953F-437D-84 | PO19546111394 | 100 | 285 | 379 | 206 | 5 | 2023-01-04 | 6544.69 | 163.62 | 2022-12-23 | 5 | 1320.68 | 1 | 6544.69 | 3 | SO47965 | 2022-12-30 | 523.58 | 6603.42 | 1308.94 | |||
SO51718_14 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 517 | 207 | 5 | 2023-10-04 | 94.75 | 2.37 | 2023-09-22 | 3 | 23.37 | 1 | 94.75 | 14 | SO51718 | 2023-09-29 | 7.58 | 70.12 | 31.58 | |||
SO44305_9 | E906-4DF2-BE | PO522153226 | 100 | 285 | 235 | 676 | 5 | 2021-12-04 | 57.68 | 1.44 | 2021-11-22 | 2 | 31.72 | 1 | 57.68 | 9 | SO44305 | 2021-11-29 | 4.61 | 63.45 | 28.84 | |||
SO47965_4 | 953F-437D-84 | PO19546111394 | 100 | 285 | 236 | 206 | 5 | 2023-01-04 | 173.04 | 4.33 | 2022-12-23 | 6 | 29.08 | 1 | 173.04 | 4 | SO47965 | 2022-12-30 | 13.84 | 174.48 | 28.84 | |||
SO51718_15 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 487 | 207 | 5 | 2023-10-04 | 131.98 | 3.30 | 2023-09-22 | 4 | 20.57 | 1 | 131.98 | 15 | SO51718 | 2023-09-29 | 10.56 | 82.27 | 32.99 | |||
SO44305_10 | E906-4DF2-BE | PO522153226 | 100 | 285 | 218 | 2 | 676 | 5 | 1.32 | 2021-12-04 | 66.12 | 1.62 | 2021-11-22 | 12 | 3.40 | 1 | 64.80 | 10 | SO44305 | 2021-11-29 | 5.18 | 40.76 | 5.51 | 0.02 |
SO47965_5 | 953F-437D-84 | PO19546111394 | 100 | 285 | 333 | 206 | 5 | 2023-01-04 | 1879.18 | 46.98 | 2022-12-23 | 4 | 486.71 | 1 | 1879.18 | 5 | SO47965 | 2022-12-30 | 150.33 | 1946.83 | 469.79 | |||
SO51718_16 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 475 | 207 | 5 | 2023-10-04 | 167.98 | 4.20 | 2023-09-22 | 4 | 26.18 | 1 | 167.98 | 16 | SO51718 | 2023-09-29 | 13.44 | 104.71 | 41.99 | |||
SO44305_11 | E906-4DF2-BE | PO522153226 | 100 | 285 | 219 | 676 | 5 | 2021-12-04 | 17.10 | 0.43 | 2021-11-22 | 3 | 3.40 | 1 | 17.10 | 11 | SO44305 | 2021-11-29 | 1.37 | 10.19 | 5.70 | |||
SO47965_6 | 953F-437D-84 | PO19546111394 | 100 | 285 | 385 | 206 | 5 | 2023-01-04 | 1200.53 | 30.01 | 2022-12-23 | 2 | 605.65 | 1 | 1200.53 | 6 | SO47965 | 2022-12-30 | 96.04 | 1211.30 | 600.26 | |||
SO51718_17 | 27D3-4968-89 | PO15051113417 | 100 | 285 | 225 | 207 | 5 | 2023-10-04 | 10.79 | 0.27 | 2023-09-22 | 2 | 6.92 | 1 | 10.79 | 17 | SO51718 | 2023-09-29 | 0.86 | 13.84 | 5.39 | |||
SO44305_12 | E906-4DF2-BE | PO522153226 | 100 | 285 | 223 | 676 | 5 | 2021-12-04 | 15.56 | 0.39 | 2021-11-22 | 3 | 5.71 | 1 | 15.56 | 12 | SO44305 | 2021-11-29 | 1.24 | 17.12 | 5.19 |
Generated 2024-09-21 11:46:46.729 UTC