[ROOT] / doc / toc / ARAdventureWorksOLAP / Enum / FactInternetSaleP

CarrierTrackingNumber , CustomerPONumber , DimCurrencyId , DimCustomerId , DimProductId , DimPromotionId , DimSalesTerritoryId , DueDate , Freight , OrderDate , SalesAmount , SalesOrderLineNumber , SalesOrderNumber , ShipDate , TaxAmt , TotalProductCost


Describes class FactInternetSale.


CarrierTrackingNumber 
CustomerPONumber 
DimCurrencyIdCalled 'CurrencyKey' in original sample database
DimCustomerIdCalled 'CustomerKey' in original sample database
DimProductIdCalled 'ProductKey' in original sample database
DimPromotionIdCalled 'PromotionKey' in original sample database. Note: All instances of 'DimPromotionId = 1' (No discount) has been filtered out at import
DimSalesTerritoryIdCalled 'SalesTerritoryKey' in original sample database.
DueDateCalled 'DueDateKey' in original sample database (link to DimDate)
Freight 
OrderDateCalled 'OrderDateKey' in original sample database (link to DimDate)
SalesAmount 
SalesOrderLineNumberSalesOrderNumber plus SalesOrderLineNumber constitutes primary key of FactInternetSale
SalesOrderNumberSalesOrderNumber plus SalesOrderLineNumber constitutes primary key of FactInternetSale
ShipDateCalled 'ShipDateKey' in original sample database (link to DimDate)
TaxAmt 
TotalProductCost 

Details

Generated 2024-04-14 01:43:11.749 UTC