global data warehouse

8/7/2019 Global Data Warehouse

1/64

verse:Global Data Warehouse 9/10/2008

Page 1/64

Universe Parameters

DefinitionName: Global Data Warehouse

Description:

Connection: Global Data Warehouse

General informationCreated: 2/29/2008 by v-rao

Modified: 9/9/2008 by Administrator

Comments:

Statistics: 194 Classes

1294 Objects

72 Tables

22 Aliases

217 Joins

14 Contexts

6 Hierarchies

49 Conditions

StrategiesJoin strategy: Edit Manually (none)

Table strategy: (Built-in) Standard

Object strategy: (Built-in) Standard Renaming

ControlsLimit size of result set to: unchecked

Limit size of long text objects to: 1000 characters

Limit execution time to: 30 minutes

Warn if cost estimate exceeds: unchecked

SQL parametersQuery

Allow use of subqueries: yes Allow use of union, intersect and minus operators: yes

Allow complex conditions in Query Panel: yes

Cartesian products: warn

Multiple paths

Generate several SQL statements for each context: yes

Generate several SQL statements for each measure: yes

Allow selection of multiple contexts: yes


2/64

erse:Global Data Warehouse 9/10/2008

Page 2/64

LinksNo links for this universe

Object ListGeography

Sales ForceRVP Name .

RVP Region .

District Id .

District Name .

Sales Disctrict Name + Id .

Sales Disctrict Name Id US

Sales Disctrict Name Id UK

Sales Rep Id .

Sales Rep Name .Sales Rep Name + Id .

Period End Sales ForcePeriod End District Id .

Period End District Name .

Period End RVP Name .

Period End RVP Region .

Period End Sales Rep Id .

Period End Sales Rep Name .

Period End Sales Force UnusedPeriod End Audit Key

Period End Client

Period End Current Row

Period End Distribution Channel

Period End Division

Period End Effective From

Period End Effective To

Period End Meta Rowcreated

Period End Meta Rowupdated

Period End Pk Salesrep

Period End Sales Org Id

Original Sales ForceOriginal District Id

Original District Name

Original RVP Name

Original RVP Region

Original Sales Rep Id

Original Sales Rep Name


3/64


Page 3/64

Original Sales Force UnusedOriginal Audit Key

Original Client

Original Current Row

Original Distribution Channel

Original DivisionOriginal Effective From

Original Effective To

Original Meta Rowcreated

Original Meta Rowupdated

Original Pk Salesrep

Original Sales Org Id

Sales Force UnusedSales ForcePk Salesrep

Sales ForceClient

Sales ForceSales Org Id

Sales ForceDistribution Channel

Sales ForceDivision

Sales ForceEffective From

Sales ForceEffective To

Sales ForceCurrent Row

Sales ForceMeta Rowcreated

Sales ForceMeta Rowupdated

Sales ForceAudit Key

Specific Sales ForceSB Sales Org Id .

SB Distribution Channel .SB Division .

SB Rep Id .

SB Rep Name .

SB District Id .

SB District Name .

SB Rvp Name .

SB Rvp Region .

ZR Sales Org Id .

ZR Distribution Channel .

ZR Division .

ZR Rep Id .

ZR Rep Name .

ZR District Id .

ZR District Name .

ZR Rvp Name .

ZR Rvp Region .

Sb Salesrep Hidden Fields


4/64


Page 4/64

Pk Salesrep

Client

Effective From

Effective To

Current Row

Meta RowcreatedMeta Rowupdated

Audit Key

ZR Salesrep Hidden FieldsPk Salesrep

Client

Effective From

Effective To

Current Row

Meta Rowcreated

Meta Rowupdated

Audit Key

Customer

Sold-To CustomerSold-To Customer Id .

Sold-To Customer Name .

Sold-To Customer Name + Id .

Sold-To Customer Name Id US

Sold-To Customer Name Id IMU

Sold-To Gpo Id .

Sold-To Gpo Desc .

Sold-To AddressSold-To Cust Name2 .

Sold-To Cust Name3 .

Sold-To Cust Name4 .

Sold-To Street .

Sold-To Po Box .

Sold-To City .

Sold-To State Code .

Sold-To State .

Sold-To Postal Code .

Sold-To Country .

Sold-To Country Code .

Sold-To Historical GPOSold-To Hist Gpo Id

Sold-To Hist Gpo Desc

Sold-To Other IdSold-To Hin Id .

Sold-To Verispan Id .


5/64


Page 5/64

Sold To National Id .

Sold - To Other Id HistoricalSold-To Hist National Id

Sold-To Hist Hin Id

Sold-To Customer Details

Sold-To Sales Office .Sold-To Sales_Group .

Sold-To ContactSold-To Contact Name .

Sold-To Contact Phone .

Sold-To Email .

Sold-To Fax .

Sold-To Phone .

Sold-To Pricing/StatisticsSold-To Price List Type Id .

Sold-To Price List Type .Sold-To Price Group Id .

Sold-To Price Group .

Sold-To Shipping Plant /WareHouseSold-To Delivery Plant Id .

Sold-To Historical SCDSold-To Current Row

Sold-To Effective From

Sold-To Effective To

Sold-To Payment TermsSold-To Payment Terms Id .

Payment Terms .

Sold-To AccountingSold-To Acct Assignment Group .

Sold-To Acct Group Code .

Sold-To Profile DetailsSold-To Deletion Indicator .

Sold-To Incoterms .

Sold-To Ranking .

Sold-To Group DetailsSold-To Customer Group ID .

Sold-To Customer Group Desc .

Sold-To Cust Group1 Id .



Sold-To Attribute DetailsSold-To Attribute1 .

Sold-To Hist Attribute1 .


6/64


Page 6/64

Sold-To Attribute2 .





Sold-To Attribute7 .Sold-To Attribute8 .



Sold-To Division

Sold-To Cust Sales Org Id

Sold-To Sales District Id

Ship-To CustomerShip-To Customer Id .

Ship-To Customer Name .

Ship-To Customer Name and Id .

Ship-To Gpo Id .

Ship-To Gpo Desc .

Ship-To AddressShip-To Cust Name2 .

Ship-To Cust Name3 .

Ship-To Cust Name4 .

Ship-To Street .

Ship-To Po Box .

Ship-To City .

Ship-To State Code .

Ship-To State .Ship-To Postal Code .

Ship-To Country .

Ship-To Country Code .

Ship-To Other IdShip-To Hin Id .

Ship-To Verispan Id .

Ship-To National Id .

Ship-To Sales Text HistoricalShip-To Hist National Id .

Ship-To Hist Hin Id .

Ship-To Historical GPOShip-To Hist Gpo Id

Ship-To Hist Gpo Desc

Ship-To Customer DetailsShip-To Sales Office .

Ship-To Sales_Group .


7/64


Page 7/64

Ship-To ContactShip-To Contact Name .

Ship-To Contact Phone .

Ship-To Email .

Ship-To Fax .

Ship-To Phone .Ship-To Pricing/Statistics

Ship-To Price List Type Id .

Ship-To Price List Type .

Ship-To Price Group Id .

Ship-To Price Group Desc .

Ship-To Shipping Plant /WareHouseShip-To Delivery Plant Id .

Ship-To Historical SCDShip-To Current Row

Ship-To Effective FromShip-To Effective To

Ship-To Payment TermsShip-To Payment Terms Id .

Ship-To Payment Terms .

Ship-To AccountingShip-To Acct Assignment Group .

Ship-To Acct Group Code .

Ship-To Profile DetailsShip-To Deletion Indicator .

Ship-To Incoterms .

Ship-To Ranking .

Ship-To Group DetailsShip-To Customer Group Id .

Ship-To Customer Group Desc .

Ship-To Cust Group1 Id .



Ship-To Attribute DetailsShip-To Attribute1 .

Ship-To Hist Attribute1 .

Ship-To Attribute2 .








8/64


Page 8/64



Ship-To Division

Ship-To Sales Org Id

Ship-To Distribution Channel

Ship-To Sales District IdPayer Customer

Payer Customer Id .

Payer Customer Name .

Payer Customer Name and Id .

Payer Gpo Id .

Payer Gpo Desc .

Payer AddressPayer City .

Payer Country .

Payer Country Code .

Payer Cust Name2 .

Payer Cust Name3 .

Payer Cust Name4 .

Payer Po Box .

Payer Postal Code .

Payer State .

Payer State Code .

Payer Street .

Payer Other IdPayer Hin Id .

Payer National Id .Payer Verispan Id .

Payer Sales Texts HistPayer Hist Hin Id .

Payer Hist National Id .

Payer Historical GPOPayer Hist Gpo Id

Payer Hist Gpo Desc

Payer Customer DetailsPayer Sales Office .

Payer Sales_Group .

Payer ContactPayer Contact Name .

Payer Contact Phone .

Payer Email .

Payer Fax .

Payer Phone .


9/64


Page 9/64

Payer Pricing/StatisticsPayer Price Group Desc .

Payer Price Group Id .

Payer Price List Type .

Payer Price List Type Id .

Payer Shipping Plant /WareHousePayer Delivery Plant Id .

Payer Historical SCDPayer Current Row

Payer Effective From

Payer Effective To

Payer Payment TermsPayer Payment Terms .

Payer Payment Terms Id .

Payer Accounting

Payer Acct Assignment Group .Payer Acct Group Code .

Payer Profile DetailsPayer Deletion Indicator .

Payer Incoterms .

Payer Ranking .

Payer Group DetailsPayer Customer Group Desc .

Payer Customer Group Id .

Payer Cust Group1 Id .



Payer Attribute DetailsPayer Attribute1 .

Payer Attribute10 .

Payer Attribute2 .

Payer Attribute3 .

Payer Attribute4 .

Payer Attribute5 .

Payer Attribute6 .

Payer Attribute7 .

Payer Attribute8 .

Payer Attribute9 .

Payer Distribution Channel .

Payer Division .

Payer Hist Attribute1 .

Payer Sales District Id .

Payer Sales Org Id .


10/64


Page 10/64

Customer HierarchyAssignment Group .

Export Indicator .

Isis Channel .

Market Type .

Reporting Channel Desc .Sales Area

Sales Org .

Sales Org Desc .

Dist Channel .

Dist Channel Desc .

Division .

Division Desc .

Company Code .

Company Desc .

PlantPlant Name .Plant No .

Plant AddressPlant Address .

Plant City .

Plant Country Code .

Plant State Province Code .

Product

MaterialMaterial Id .

Material Description .

Material Description + Id .

Material Id + Description .

Material HierarchyLevel 1 Id .

Level 1 Desc .

Level 2 Id .

Level 2 Desc .

Level 3 Id .

Level 3 Desc .

Level 4 Id .Level 4 Desc .

Level 5 Id .

Level 5 Desc .

Level 6 Id .

Level 6 Desc .

Product Hierarchy .


11/64


Page 11/64

Historical Material HierHist Level 1 Desc

Hist Level 1 Id

Hist Level 2 Desc

Hist Level 2 Id

Hist Level 3 DescHist Level 3 Id

Hist Level 4 Desc

Hist Level 4 Id

Hist Level 5 Desc

Hist Level 5 Id

Hist Level 6 Desc

Hist Level 6 Id

Hist Product Hierarchy

Hist Standard Cost

Previous Std Cost

Material Hier CascadingLevel 1 Id Desc

Level 2 Id Desc

Level 3 Id Desc

Level 4 Id Desc

Level 5 Id Desc

Level 6 Id Desc

Material ClassificationCap/Non Cap Desc .

Cap/Non Cap Id .

Catalog Item .Forecast Flag .

Mfg Group Id .

Mfg Group Desc .

Mfg Team Id .

Mfg Team Desc .

Mfg Tech Desc .

Mfg Tech Id .

Royalty Payment Flag .

Material General PlantAvailability Check .

Base Uom .

Batch Management .

Cross Dist Chain Status .

Cross Dist Chain Status Desc .

Cross Plant Matl Status Code .

Cross Plant Matl Status .

Expiration Date Type .


12/64


Page 12/64

Lab Office .

Material Group .

Material Type .

Min Remaining Shelf Life .

New Product Group .

New Product Indicator .Num Gr Slips .

Order Uom .

Preowned Flag .

Serial Nr Profile .

Total Shelf Life .

Material MRP ViewsAbc Indicator .

Abc Indicator Desc .

Availability Check Desc .

Backward Consumption Period .

Batch Management Internal

Batch Management Plant .

Bulk Material .

Commodity Code .

Consumption Mode .

Costing Lot Size .

Country of Origin .

Cycle Count Indicator Fixed .

Cycle Counting Pi Indicator .

Do Not Cost .

Fixed Lot Size .Forward Consumption Period .

Gr Processing Time (Days) .

In House Production Days .

Issue Storage Location .

Issue Storage Location Desc .

Jit Schedule Indicator .

Material Status .

Material Status Code .

Max Lot Size .

Max Stock Level .

Min Lot Size .

Mrp Group .

Mrp Type .

Mrp Type Desc .

Planned Delivery Time (Days) .

Planner Desc .

MRP Controller .


13/64


Page 13/64

MRP Lot Size .

MRP Lot Size Desc .

Post To Inspection Stock .

Procurement Type .

Production Scheduler .

Production Scheduler Desc .Production Uom .

Production Version .

Purchasing Group .

Purchasing Group Name .

In Transfer Qty (Plant) .

Region of Origin .

Reorder Point .

Rounding Value .

Safety Stock .

Safety Time Indicator .

Safety Time Workdays .

Schedule Margin Key .

Shelf Life Period Indicator .

Special Procurement Type .

Special Procurement Type Desc .

Storage Location Ext Procurement .

Storage Location Ext Procurement Desc .

Stock In Transit .

Unit Of Issue .

Z3416 Next Cc Date .

Z3416 Update Date .

Material ValuationCost Currency Code .

Costing Overhead Group .

Last Cost Change .

Planned Cost 1 .

Planned Cost 2 .

Planned Cost 3 .

Planned Cost Date 1 .



Posting Period .

Previous Std Cost .

Price Unit .

Standard Cost .

Total Stock .

Total Value .

Valuation Type .


14/64


15/64


Page 15/64

Dist Channel

Division

List Price Sales Org

Material Id Sales Org

Meta Rowcreated Sales Org

Meta Rowupdated Sales OrgPk Materialsalesdata

Sales Org

Sales Status Code Sales Org

Sales Status Sales Org

Sales Text Sales Org

Sales Uom Sales Org

Material Sales Org HistoricalEffective From

Effective To

Current Row

Hist List Price Sales Org

Material Sales Org PricingMaterial Pricing Group Code

Material Pricing Group

Material Pricing Group1 Code

Material Pricing Group1 Desc





Material Pricing Group4 CodeMaterial Pricing Group4 Desc



Material Sales Org CommissionCommission Group Code

Commission Group

Material Sales Org Commission HistoricalHist Commission Group Code

Hist Commission Group

Material Hierarchy Sales OrgLevel 1 Desc

Level 1 Id

Level 2 Desc

Level 2 Id

Level 3 Desc

Level 3 Id

Level 4 Desc


16/64


Page 16/64

Level 4 Id

Level 5 Desc

Level 5 Id

Level 6 Desc

Level 6 Id

Product HierarchyHist Material Hier Sales org

Hist Product Hierarchy

Hist Level 1 Id

Hist Level 1 Desc

Hist Level 2 Id

Hist Level 2 Desc

Hist Level 3 Id

Hist Level 3 Desc

Hist Level 4 Id

Hist Level 4 Desc

Hist Level 5 Id

Hist Level 5 Desc

Hist Level 6 Id

Hist Level 6 Desc

TimeDate .

Year Specific TimeFiscal Year .

Fiscal Quarter .

Fiscal Period .

Fiscal Week .Fiscal Day .

Time Without YearQuarter .

Period .

Week .

Selling Day .

Selling Days in Period .

Non Accounting CalendarDay Of Week

Day Of MonthMonth

Month Name

Day Name

Is Weekday

Month Of Qtr

Date Indicators Flags


17/64


Page 17/64

YTD Specific YearsYtd Complete Periods Current Year flag .

Ytd Complete Periods 1yrs flag .



Ytd Current Year flag .Ytd 1yrs flag .

Ytd 2yrs flag .

Ytd 3yrs flag .

Rolling Completed Period

Indicators that End in Current PeriodRolling Current 12 flag .

Rolling Previous 12 flag .

Rolling Previous 12 2yrs flag .

Rolling Previous 12 3yrs flag .

Indicators that End in Prior PeriodRolling Current 12 Full Periods flag .Rolling 12 Full Periods Prior Year flag .

Rolling 12 Full Periods 2 Years Prior flag .

Year Specific Indicators

Year Specific YearCurrent Year flag .

Prior Year flag .

Second PY flag .

Current And Prior 2 Years flag .

Current And PY flag .

Year Specific QuarterCurrent Qtr CY flag .

Prior Qtr Rolling flag .

Year Specific PeriodCurrent Period flag .

Current Period PY flag .

Prior Period flag .

Prior Period PY flag .

Year Specific WeekCurrent Week flag .

Prior Week flag .

Year Specific DayCurrent Day flag .

Prior Day flag .

Indicators Every YearCurrent Period (Every Year) flag .

Prior Period (Every Year) flag .


18/64


Page 18/64

Rolling Qtr To Date (Every Year) flag .

Rolling Period To Date flag .

Ytd Complete Periods (Every Year) flag .

Current Week (Every Year) flag .

Prior Week (Every Year) flag .

Year To Date (Every Year) flag .Measurements

CurrencyCurrency Code .

Currency Desc .

Currency DetailsCountries

Sales Module

Billings

Billing Measures

Avg Discount %Invoice Base Qty .

Invoice Qty .

Billings Measures Local CurrencyNet Revenue LC No Sum

Net Revenue Lc .

Discount Amt Lc .

New Products Lc .

Billing Measure LC Gross ProfitGross Profit Lc .

Standard Cost Lc .Unit Cost Lc .

Unit Gross Profit Lc .

Pricing Measures LCGross Potential as list Lc .

Local Contract Price Lc .

National Contract Price Lc .

Unit Selling Price Lc .

Net Revenue Local Currency Time Selection

Measures LC YTD Specific YearsNet Revenue LC YTD Completed Periods CY .

Net Revenue LC YTD Completed Periods 1 yrs .

Net Revenue LC YTD Completed Periods 2 yrs .

Net Revenue LC YTD Completed Perods 3 yrs .

Net Revenue LC YTD .

Net Revenue LC YTD 1 Yr .




19/64


Page 19/64

Measures LC Rolling Completed PeriodsNet Revenue LC Rolling Current 12 .

Net Revenue LC Rolling Previous 12 .

Net Revenue LC Rolling Previous 12 2 yrs .

Net Revenue LC Rolling Previous 12 3 yrs .

Measures LC Year SpecificMeasures LC YS Year

Net Revenue LC Current Year .

Net Revenue LC Prior Year .

Net Revenue LC Second Prior Year .

Net Revenue LC Current & Prior 2 Years .

Net Revenue LC Current & Prior Year .

Measure LC YS QuaterNet Revenue LC Current Qtr CY .

Net Revenue LC Prior Qtr Rolling .

Measure LC Year Specific PeriodNet Revenue LC Current Period .

Net Revenue LC Current Period PY .

Net Revenue LC Prior Period .

Net Revenue LC Prior Period PY .

Measures LC Without YearNet Revenue LC Rolling Period To Date .

Net Revenue LC Rolling Current 12 Full Periods .

Billing Measure LC DetailDist Handling Amt Lc .

Export Ins Amt Lc .

Frieght Amt Lc .

Handling Amt Lc .

Net Rev New Prod Lc .

Restock Amt Lc .

Billing Measures USDNet Revenue USD NoSum

Net Revenue Usd .

Discount Amt Usd .

New Products Usd .

USD Gross ProfitStandard Cost Usd .

Gross Profit Usd .

Unit Cost Usd .

Unit Gross Profit Usd .

Pricing Measures USDGross Potential at list Usd .

Local Contract Price Usd .


20/64


Page 20/64

National Contract Price Usd .

Unit Selling Price Usd .

Net Revenue USD Time Selection

Measures USD YTD Specific YearsNet Revenue USD YTD CP CY TEST

Net Revenue USD YTD Completed Periods CY .Net Revenue USD YTD Completed Periods 1 yrs .

Net Revenue USD YTD Completed Periods 2 yrs .

Net Revenue USD YTD Completed Perods 3 yrs .

Net Revenue USD YTD .

Net Revenue USD YTD 1 Yr .



Measures USD Rolling Completed PeriodsNet Revenue USD Rolling Current 12 .

Net Revenue USD Rolling Previous 12 .

Net Revenue USD Rolling Previous 12 2 yrs .

Net Revenue USD Rolling Previous 12 3 yrs .

Measures USD Year Specific

Measures USD YS YearNet Revenue USD Current Year .

Net Revenue USD Prior Year .

Net Revenue USD Second Prior Year .

Net Revenue USD Current & Prior 2 Years .

Net Revenue USD Current & Prior Year .

Measure USD YS QuaterNet Revenue USD Current Qtr CY .

Net Revenue USD Prior Qtr Rolling .

Measure USD Year Specific PeriodNet Revenue USD Current Period .

Net Revenue USD Current Period PY .

Net Revenue USD Prior Period .

Net Revenue USD Prior Period PY .

Measures USD Without YearNet Revenue USD Rolling Period To Date .

Net Revenue USD Rolling Current 12 Full Periods .

Billing Measures USD DetailDist Handling Amt Usd .

Export Ins Amt Usd .

Frieght Amt Usd .

Handling Amt Usd .

Net Rev New Prod Usd .

Restock Amt Usd .


21/64


Page 21/64

Billings Measures FXDiscount Amt FX

Dist Handling Amt FX

Export Ins Amt FX

Ext List Price FX

Frieght Amt FXHandling Amt FX

Net Rev New Prod FX

Net Revenue FX

Profit FX

Restock Amt FX

Standard Cost FX

Billings DetailsBase Uom .

Bill Type .

Bill Type Desc .

Billing Doc .

Billing Doc Line .

Customer Group1 at Time of Billing .

GPO at Time of Billing .

Customer PO .

Delivery Doc .

Invoice Uom .

Reference Doc .

Sales Doc .

Sales Doc Line .

PromotionsPromotion Id

Promotion Desc

Ext Promotion Desc

Promotion Sales Org

Promotion Dist Channel

Promotion Division

Promotion Sales Office

Promotion Sales Group

Creation Datetime

Change Datetime

Created By

Changed By

Valid From Date

Valid To Date

Sales DealsSales Deal Id

Sales Deal Desc


22/64


Page 22/64

Ext Sales Deal Desc

Sales Deal Sales Org

Sales Deal Dist Channel

Sales Deal Division

Sales Deal Sales Office

Sales Deal Sales GroupCreation Datetime

Change Datetime

Created By

Changed By

Valid From Date

Valid To Date

Order MethodOrder Method .

Order Method Desc .

Account Assignment GroupAcct Assignment Group .

Acct Assignment Group Desc .

Shipping ConditionsShipping Conditions .

Shipping Conditions Desc .

Payment TermsPayment Terms .

Payment Terms Desc .

IncotermsIncoterm .

Incoterm Desc .

Contracts

Contracts HeaderContracts - Create Time .

Contracts - Created By .

Contracts - Customer Group1 .

Contracts - Customer Group2 .

Contracts - Customer PO .

Contracts - Doc Reference Number .

Contracts - Header Create Date .

Contracts - Higher Level Item .Contracts - Name Of Order .

Contracts - Contract Doc .

Contracts - Quote_Doc .

Contracts - PO Date .

Contracts - Requested Delivery Date .

Contracts - Search Term .


23/64


Page 23/64

Contracts - Telephone Number .

Contracts Line ItemContracts - Base Uom .

Contracts - Batch Number .

Contracts - Condition Number .

Contracts - Condition Uom .Contracts - Contract End Date .

Contracts - Contract Start Date .

Contracts - Compliance Currency Code

Contracts - Create Time Line .

Contracts - Customer Group .

Contracts - First 241 Movement Date .

Contracts - First Delivery Date .

Contracts - Fixed Date And Qty .

Contracts - Line Created By .

Contracts - Net Price Lc .

Contracts - Net Price Usd .

Contracts - Contract Doc Line .

Contracts - Quote_Doc_Line .

Contracts - Order Uom .

Contracts - Pricing Ref Material .

Contracts - Qty Is Fixed .

Contracts - Returns Item .

Contracts - Target Uom .

Contracts MeasuresContracts - Contract Qty .

Contracts - Contract Qty Base .Contracts - Target Qty .

Contracts - Target Qty Base .

Contracts Measures Local CurencyContracts - Compliance Amount Lc .

Contracts - Placement Value Lc .

Contracts - Item Net Value Lc .

Contracts - Tax Amount Lc .

Contracts Measures USDContracts - Compliance Amount Usd .

Contracts - Placement Value Usd .

Contracts - Item Net Value Usd .

Contracts - Tax Amount Usd .

Demo Orders

Demo Orders HeaderDemo Orders - Condition Number .

Demo Orders - Header Create Date .

Demo Orders - Order Doc .


24/64


Page 24/64

Demo Orders Line ItemDemo Orders - Base Uom .

Demo Orders - Batch Number .

Demo Orders - Last Receipt Date .

Demo Orders - Order Doc Line .

Demo Orders - Serial Number .Demo Orders Measures

Demo Orders - Order Qty Base .

Item CategoryItem Category .

Item Category Desc .

Order ReasonOrder Reason Description .

Order Reason Id .

Orders

Orders HeaderOrders - Create Time .

Orders - Created By .

Orders - Customer Group1 .

Orders - Customer Group2 .

Orders - Customer PO .

Orders - Doc Reference Number .

Orders - Header Create Date .

Orders - Higher Level Item .

Orders - Name Of Order .

Orders - Order Doc .

Orders - PO Date .

Orders - Requested Delivery Date .

Orders - Search Term .

Orders - Telephone Number .

Orders Line ItemOrders - Base Uom .

Orders - Batch Number .

Orders - Condition Number .

Orders - Condition Uom .

Orders - Create Time Line .

Orders - Customer Group .Orders - Fixed Date And Qty .

Orders - Line Created By .

Orders - Net Price Lc .

Orders - Net Price Usd .

Orders - Order Doc Line .

Orders - Order Uom .


25/64


Page 25/64

Orders - Pricing Ref Material .

Orders - Qty Is Fixed .

Orders - Returns Item .

Orders - Target Uom .

Orders Measures

Orders - Order Qty .Orders - Order Qty Base .

Orders - Target Qty .

Orders - Target Qty Base .

Orders Measures Local CurencyOrders - Item Net Value Lc .

Orders - Tax Amount Lc .

Orders Measures USDOrders - Item Net Value Usd .

Orders - Tax Amount Usd .

Reference StatusConfirmation Item Status .Confirmation Item Status Desc .

Confirmation Status Picking .

Confirmation Status Picking Desc .

Delivery Status .

Delivery Status Desc .

Goods Movement Status .

Goods Movement Status Desc .

Incomplete Pricing .

Incomplete Pricing Desc .

Overall Processing Status .

Overall Processing Status Desc .

Overall Status .

Overall Status Desc .

Picking Status .

Picking Status Desc .

Reject Status .

Reject Status Desc .

Sales Document Header InfoBilling Block .

Billing Block Desc .Delivery Block .

Delivery Block Desc .

PO Method .

PO Method Desc .

Sales Document Line InfoBilling Block Line .

Billing Block Line Desc .


26/64


Page 26/64

Departure Country .

Departure Country Desc .

Delivery Priority .

Delivery Priority Desc .

Material Substitution Reason .

Material Substitution Reason Desc .Order Rejection Reason

Order Reject Reason Desc

Route .

Route Desc .

Shipping Point .

Shipping Point Desc .

Sales Document TypeSales Document Type .

Sales Document Type Desc .

Storage Location of OrderStorage Location of Order .

Storage Location of Order Desc .

VPC IndicatorVpc Indicator .

Vpc Indicator Desc .

Third Party SalesThird Party Invoice Qty .

Third Party Invoice Amt Lc .

Third Party Invoice Amt Usd .

Third Party Pk Thirdpartysales

Third Party Fk Client

Third Party Fk Customer

Third Party Fk Salesarea

Third Party Fk Salesrep

Third Party Fk Material

Third Party Fk Materialsalesdata

Third Party Fk Plant

Third Party Fk Date

Third Party Fk Currency

Third Party Meta Rowcreated

Third Party Meta Rowupdated

Third Party \Audit Key

Stock & Consignment

Demo InventoryMaterial Doc .

Material Doc Line .

Material Doc Year .

Header Text .


27/64


Page 27/64

Batch Number .

Serial Number .

Base Uom .

Quantity .

Demo Limit Amount .

European StockAsset Flag .

Order Uom .

Base Uom .

Source .

Stock Uom .

Qty @ Base Uom .

Qty @ Price Unit .

Qty @ Order Uom .

Value Lc .

Value Usd .

Qty

Stock Data Load Date .

Audit Key

Fk Client

Fk Currency

Fk Loaddate

Fk Material

Fk Plant

Fk Specialstock

Fk Storagelocation

Fk ScustomerMeta Rowcreated

Meta Rowupdated

Pk Imustockloaners

Loaners

Loaners & ConsignmentLoaners & Consignment - Asset Flag .

Loaners & Consignment - Base Uom .

Loaners & Consignment - Batch Number .

Loaners & Consignment - Inventory Datetime .

Loaners & Consignment - Material Loanset Id .

Loaners & Consignment - Material Loanset Desc .

Loaners & Consignment - Material Sales Loanset Id .

Loaners & Consignment - Source .

Loaners & Consignment - Stock Uom .

Loaners & Consignment MeasuresLoaners & Consignment - Qty .

Loaners & Consignment - Qty Base .


28/64


Page 28/64

Loaners & Consignment - Qty Price Unit .

Loaners & Consignment - Value Lc .

Loaners & Consignment - Value Usd .

ReservationsReservations - Asset Subnumber .

Reservations - Base Uom .Reservations - Batch Number .

Reservations - Completed Indicator .

Reservations - Consignment Indicator .

Reservations - Customer Po .

Reservations - Debit Order .

Reservations - Last Cdhdr Changenr .

Reservations - Loanset Order .

Reservations - Loanset Replenishment Order .

Reservations - Loanset Return Order .

Reservations - Main Asset Number .

Reservations - Material Equipment Id .

Reservations - Material Equipment Desc .

Reservations - Material Sales Data Equipment Id .

Reservations - Object Number .

Reservations - Pending Reservation Indicator .

Reservations - Rejection Reason .

Reservations - Rejection Reason Desc .

Reservations - Reservation Created By .

Reservations - Reservation Created Date .

Reservations - Reservation Item .

Reservations - Reservation Number .Reservations - Reservation Text .

Reservations - Reservation Type .

Reservations - Reservation Type Desc .

Reservations - Return Datetime .

Reservations - Serial Number .

Reservations - Single Item Indicator .

Reservations - Single Item Missing Damaged .

Reservations - Spare Part Indicator .

Reservations - User Status .

Reservations - User Status Desc .

Reservations DatesReservations - Delivery Date .

Reservations - Operation Date .

Reservations - Return Date .

Reservations - Return Date Actual .

Reservations MeasuresReservations - Qty Bill To .


29/64


Page 29/64

Reservations - Qty Damaged .

Reservations - Qty For Interim Document .

Revervations - Qty Forwarded .

Reservations - Qty Issued .

Reservations - Qty Missing .

Reservations - Qty Received .Equipment

Equipment - Asset Number .

Equipment - Batch Number .

Equipment - Created By .

Equipment - Created Date .

Equipment - Equipment Category .

Equipment - Equipment Desc .

Equipment - Equipment Id .

Equipment - Equipment Material Id .

Equipment - Last Modified By .

Equipment - Last Modified Date .

Equipment - Last Movement Date .

Equipment - Object Number .

Equipment - Object Type .

Equipment - Serial Number .

Equipment - System Status .

Equipment - Usage Period Number .

Equipment - User Status .

Equipment - User Status Desc .

Movement Type

Movement Indicator .Movement Type .

Movement Type Desc .

Pk Movementtype

Receipt Indicator

Special Stock Indicator

Audit Key

Client

Consumption Posting

Meta Rowcreated

Meta Rowupdated

Special StockSpecial Stock .

Special Stock Desc .

Pk Specialstock

Client

Meta Rowcreated

Meta Rowupdated


30/64


Page 30/64

Audit Key

European Sales BudgetBudget Amount Lc .

Budget Amount Usd .

Cogs Amount Lc .

Cogs Amount Usd .Fk Client

Audit Key

Fk Currency

Fk Salesarea

Fk Salesrep

Fk Sdatefiscalperiod

Fk Smateriallevel3

Meta Rowcreated

Meta Rowupdated

Pk Salesbudget

Source System

US Sales BudgetBudget Amount USD .

Do not DeleteDate String

TempRevenue Net Sales Current 12 Periods LC Check

Exchange RatesFrom Currency Code

From Date

Fx Conv Rate

Fx Countries

Fx Currency Desc

To Currency Code

To Date

System ClientClient

Client Name

Client City

Client Std Currency

AuditAudit Key

Package Name

Package Version

Rows Inserted

Rows Updated

Start Datetime


31/64


Page 31/64

Status

End Datetime

US Sold To CustomerUS Sold-To Customer Id

US Sold-To Customer Name

US Sold-To FaxUS Sold-To Street

US Sold-To Country

US Sold-To State

US Sold-To State Code

US Sold-To Postal Code

US Sold-To Phone

US Sold-To Po Box

US Sold-To City

US Sold-To Country Code

US Sold-To Cust Name2

US Sold-To Gpo Id

US Sold-To Gpo Desc

US Sold-To Hin Id

US Sold-To Ranking

Sold-To Customer Details2Sold-To Sales District Id

Sold-To Contact Name

Sold-To Contact Phone

Sold-To Email

Sold-To Acct Assignment Group

Sold-To Acct Group CodeSold-To Attribute1

Sold-To Price List Type Id

Sold-To Price List Type

Sold-To FOB

Sold-To Payment Terms Id

Payment Terms

Sold-To Verispan Id

Sold-To Facility Type

Sold-To Facility Type Id

Sold-To Price Group Id

Sold-To Price Group

Sold-To Cust Group1 Id

Sold-To Division

Sold-To Deletion Indicator

Sold-To Current Row

Sold-To Delivery Plant Id

Sold-To Cust Sales Org Id


32/64


Page 32/64

Sold-To Cust Distribution Channel

Cust Group4 Id

Cust Group5 Id

Hist Gpo

Hist Gpo Id

Customer GroupCust Name3

Cust Name4

Hist Attribute1

Hist Hin Id

Attribute2

Attribute3

Attribute4

Attribute5

Attribute6

Attribute7

Attribute8

Attribute10

Hist National Id

Attribute9

Effective From

Current Row

Effective To

Original MaterialOrig Material Id

Orig Material Desc

Orig Serial Nr ProfileOrig Hist Standard Cost

Orig Cost Currency Code

Orig Expiration Date

Orig Cycle Counting Pi Indicator

Orig Costing Overhead Group

Orig Delete Flag

Orig Fixed Vendor

Orig Isis Eligible

Orig Catalog Item

Orig Price Unit

Orig Max Storage Period

Orig Max Storage Period Units

Orig Gross Weight

Orig Net Weight

Orig Weight Uom

Orig Volume

Orig Volume Uom


33/64


Page 33/64

Orig Dimensions

Orig Ean Upc

Orig Ean Category

Orig Material HierarchyOrig Product Hierarchy

Orig Level 1 IdOrig Level 1 Desc

Orig Level 2 Id

Orig Level 2 Desc

Orig Level 3 Id

Orig Level 3 Desc

Orig Level 4 Id

Orig Level 4 Desc

Orig Level 5 Id

Orig Level 5 Desc

Orig Level 6 Id

Orig Level 6 Desc

Orig Material Hierarchy HistOrig Hist Product Hierarchy

Orig Hist Level 1 Id

Orig Hist Level 1 Desc






Orig Hist Level 4 DescOrig Hist Level 5 Id




Orig Material ClassificationOrig Mfg Tech Id

Orig Mfg Tech Desc

Orig Forecast Flag

Orig Royalty Payment Flag

Orig Cap/Non Cap Id

Orig Capncap Desc

Orig Material GeneralOrig Material Type

Orig Material Group

Orig Order Uom

Orig Lab Office

Orig Num Gr Slips


34/64


Page 34/64

Orig Min Remaining Shelf Life

Orig Total Shelf Life

Orig Preowned Flag

Orig Base Uom

Orig Batch Management

Orig Cross Dist Chain StatusOrig Cross Dist Chain Status Desc

Orig Availability Check

Orig Cross Plant Matl Status Code

Orig Cross Plant Matl Status

Orig Material ValuationOrig Standard Cost

Orig Valuation Type

Orig Total Stock

Orig Total Value

Orig Previous Std Cost

Orig Last Cost Change

Orig Planned Cost 1

Orig Planned Cost 2

Orig Planned Cost 3

Orig Planned Cost Date 1



Orig Posting Period

Orig Material ManufacturingOrig Mfg Team Id

Orig Mfg Team DescOrig Mfg Group Id

Orig Mfg Group Desc

Orig Material New ProductsOrig New Product Indicator

Orig New Product Group

Orig Material UnknownOrig Pk Material

Orig Source System

Orig Client

Orig Plant

Orig Current Row

Orig Effective From

Orig Effective To

Orig Meta Rowcreated

Orig Meta Rowupdated

Orig Audit Key

Orig Material Demo


35/64


Page 35/64

Orig Demo Price

Orig Plant Data For MaterialOrig Commodity Code

Orig Fixed Lot Size

Orig Consumption Mode

Orig Forward Consumption PeriodOrig Costing Lot Size

Orig Cycle Count Indicator Fixed

Orig Do Not Cost

Orig Batch Management Internal

Orig Abc Indicator

Orig Abc Indicator Desc

Orig Batch Management Plant

Orig Availability Check Desc

Orig Backward Consuption Period

Orig Bulk Material

Orig Min Lot Size

Orig Max Lot Size

Orig Max Stock Level

Orig Mrp Type

Orig Mrp Type Desc

Orig Gr Processing Days

Orig Planning Lot Size

Orig Planning Lot Size Desc

Orig In House Production Days

Orig Issue Storage Location

Orig Issue Storage Location DescOrig Mrp Group

Orig Jit Schedule Indicator

Orig Material Status Code

Orig Material Status

Orig Planner Id

Orig Planner Desc

Orig Reorder Point

Orig Safety Stock

Orig Purchasing Group

Orig Purchasing Group Name

Orig Unit Of Issue

Orig Planned Delivery Days

Orig Procurement Type

Orig Special Procurement Type

Orig Special Procurement Type Desc

Orig Rounding Value

Orig Schedule Margin Key


36/64


Page 36/64

Orig Production Scheduler

Orig Production Scheduler Desc

Orig Post To Inspection Stock

Orig Qty In Transfer

Orig Stock In Transit

Orig Production UomOrig Storage Location Ext Procurement

Orig Storage Location Ext Procurement Desc

Orig Safety Time Indicator

Orig Safety Time Workdays

Orig Production Version

Orig Z3416 Next Cc Date

Orig Z3416 Update Date

Condition List

Geography

Sales ForceSales Disctrict Name Id US

Sales Disctrict Name Id UK

Period End Sales Force

Period End Sales Force Unused

Original Sales Force

Original Sales Force Unused

Sales Force Unused

Specific Sales ForceSb Salesrep Hidden Fields

ZR Salesrep Hidden Fields

Customer

Sold-To CustomerSold To US

Sold-To Address

Sold-To Historical GPO

Sold-To Other Id

Sold - To Other Id HistoricalSold-To Customer Details

Sold-To Contact

Sold-To Pricing/Statistics

Sold-To Shipping Plant /WareHouse

Sold-To Historical SCD

Sold-To Payment Terms


37/64


Page 37/64

Sold-To Accounting

Sold-To Profile Details

Sold-To Group Details

Sold-To Attribute Details

Ship-To Customer

Ship-To Address

Ship-To Other Id

Ship-To Sales Text Historical

Ship-To Historical GPO

Ship-To Customer Details

Ship-To Contact

Ship-To Pricing/Statistics

Ship-To Shipping Plant /WareHouse

Ship-To Historical SCD

Ship-To Payment Terms

Ship-To Accounting

Ship-To Profile Details

Ship-To Group Details

Ship-To Attribute Details

Payer Customer

Payer Address

Payer Other Id

Payer Sales Texts Hist

Payer Historical GPOPayer Customer Details

Payer Contact

Payer Pricing/Statistics

Payer Shipping Plant /WareHouse

Payer Historical SCD

Payer Payment Terms

Payer Accounting

Payer Profile Details

Payer Group DetailsPayer Attribute Details

Customer Hierarchy

Sales Area

Plant

Plant Address

Product


38/64


Page 38/64

Material

Material Hierarchy

Historical Material Hier

Material Hier CascadingLevel 1 Id Desc

Level 2 Id Desc

Level 3 Id Desc

Level 4 Id Desc

Level 5 Id Desc

Level 6 Id Desc

Material Classification

Material General Plant

Material MRP Views

Material Valuation

Historical

Material Demo

Material Custom Groups

Material Unknown

Material SCD

Storage Location

Material Sales Org

Material Sales Org Historical

Material Sales Org Pricing

Material Sales Org Commission

Material Sales Org Commission Historical

Material Hierarchy Sales Org

Hist Material Hier Sales org

Time

Year Specific Time

Time Without Year

Non Accounting Calendar

Date Indicators Flags

YTD Specific Years

Ytd Complete Periods Current YearYtd Complete Periods 1yrs

Ytd Complete Periods 2yrs

Ytd Complete Periods 3yrs

Ytd Current Year

Ytd 1yrs

Ytd 2yrs

Ytd 3yrs


39/64


Page 39/64

Rolling Completed Period

Indicators that End in Current PeriodRolling Current 12

Rolling Previous 12

Rolling Previous 12 2yrs

Rolling Previous 12 3yrs

Indicators that End in Prior PeriodRolling Current 12 Full Periods

Rolling 12 Full Periods Prior Year

Rolling 12 Full Periods 2 Years Prior

Year Specific Indicators

Year Specific YearCurrent Year

Prior Year

Second PY

Current And Prior 2 YearsCurrent And PY

Year Specific QuarterCurrent Qtr CY

Prior Qtr Rolling

Year Specific PeriodCurrent Period

Current Period PY

Prior Period

Prior Period PY

Year Specific WeekCurrent WeekPrior Week

Year Specific DayCurrent Day

Prior Day

Indicators Every YearCurrent Period (Every Year)

Prior Period (Every Year)

Rolling Qtr To Date (Every Year)

Rolling Period To Date

Ytd Complete Periods (Every Year)

Current Week (Every Year)

Prior Week (Every Year)

Year To Date (Every Year)

Measurements

Currency

Currency Details


40/64


Page 40/64

Sales Module

Billings

Billing Measures

Billings Measures Local Currency

Billing Measure LC Gross Profit

Pricing Measures LC

Net Revenue Local Currency Time Selection

Measures LC YTD Specific Years

Measures LC Rolling Completed Periods

Measures LC Year Specific

Measures LC YS Year

Measure LC YS Quater

Measure LC Year Specific Period

Measures LC Without Year

Billing Measure LC Detail

Billing Measures USD

USD Gross Profit

Pricing Measures USD

Net Revenue USD Time Selection

Measures USD YTD Specific Years

Measures USD Rolling Completed Periods

Measures USD Year Specific

Measures USD YS Year

Measure USD YS QuaterMeasure USD Year Specific Period

Measures USD Without Year

Billing Measures USD Detail

Billings Measures FX

Billings Details

Promotions

Sales Deals

Order Method

Account Assignment GroupShipping Conditions

Payment Terms

Incoterms

Contracts

Contracts Header

Contracts Line Item


41/64


Page 41/64

Contracts Measures

Contracts Measures Local Curency

Contracts Measures USD

Demo Orders

Demo Orders Header

Demo Orders Line Item

Demo Orders Measures

Item Category

Order Reason

Orders

Orders Header

Orders Line Item

Orders Measures

Orders Measures Local Curency

Orders Measures USD

Reference Status

Sales Document Header Info

Sales Document Line Info

Sales Document Type

Storage Location of Order

VPC Indicator

Third Party Sales

Stock & Consignment

Demo InventoryEuropean Stock

Loaners

Loaners & Consignment

Loaners & Consignment Measures

Reservations

Reservations Dates

Reservations Measures

Equipment

Movement TypeSpecial Stock

European Sales Budget

US Sales Budget

Do not Delete

Temp3 years


42/64


Page 42/64

Exchange Rates

System ClientClient 100

Audit

US Sold To Customer

Sold-To Customer Details2

Original Material

Orig Material Hierarchy

Orig Material Hierarchy Hist

Orig Material Classification

Orig Material General

Orig Material Valuation

Orig Material Manufacturing

Orig Material New Products

Orig Material UnknownOrig Material Demo

Orig Plant Data For Material

Hierarchies List

Sales Force

Material Hierarchy

Time

Material Custom Groups

Material Description HierarchyRVP Region

Tables List

Original_dbo_dim_Material

dbo.agg_BillingsPeriod

dbo.dim_AcctAssignmentGroup

dbo.dim_Audit

dbo.dim_BillType

dbo.dim_BillingBlockdbo.dim_Client

dbo.dim_Currency

dbo.dim_CustHierarchy

dbo.dim_Customer

dbo.dim_Date

dbo.dim_DeliveryBlock

dbo.dim_DeliveryPriority


43/64


Page 43/64

dbo.dim_DeliveryStatus

dbo.dim_Incoterms

dbo.dim_ItemCategory

dbo.dim_Material

dbo.dim_MaterialSalesData

dbo.dim_MaterialSubstitutionReasondbo.dim_MovementType

dbo.dim_OrderMethod

dbo.dim_OrderReason

dbo.dim_OrderType

dbo.dim_POMethod

dbo.dim_PaymentTerms

dbo.dim_Plant

dbo.dim_Promotions

dbo.dim_ReferenceStatus

dbo.dim_RejectReason

dbo.dim_ReservationType

dbo.dim_Route

dbo.dim_SalesArea

dbo.dim_SalesDeal

dbo.dim_SalesRep

dbo.dim_ShipConditions

dbo.dim_ShippingPoint

dbo.dim_SpecialStock

dbo.dim_StorageLocation

dbo.dim_VpcIndicator

dbo.dim_sCustomer

dbo.dim_sDateFiscalPeriod

dbo.dim_sMaterialLevel3

dbo.dim_sSalesRep

dbo.fact_Contracts

dbo.fact_DemoInventory

dbo.fact_DemoLimits

dbo.fact_DemoOrders

dbo.fact_Equipment

dbo.fact_FxRates

dbo.fact_ImuStockLoaners

dbo.fact_LoanersConsignmentdbo.fact_Orders

dbo.fact_Reservations

dbo.fact_SalesBudget

dbo.fact_ThirdPartySales

dbo.fact_USSalesBudget

dbo.sec_PSR


44/64


Page 44/64

dbo.sec_SalesDistrict

dbo.sec_SalesRep

dbo.sfdim_MaterialCustomGroups

dbo.vagg_BillingsPeriod_DE

dbo.vagg_BillingsPeriod_REP

dbo.vfact_Billingsdbo.vfact_Billings_DE

dbo.vfact_Billings_REP

dbo.vfact_DemoInventory_DE

dbo.vfact_DemoInventory_REP

dbo.vfact_DemoLimits_DE

dbo.vfact_DemoLimits_REP

dbo.vfact_DemoOrders_DE

dbo.vfact_DemoOrders_REP

dbo.vfact_ThirdPartySales_DE

dbo.vfact_ThirdPartySales_REP

vdim_BillingBlockLine

vdim_ContractEndDate

vdim_ContractStartDate

vdim_CustomerBillTo

vdim_CustomerShipTo

vdim_DeliveryDate

vdim_ImuStockLoadDate

vdim_MaterialEquipment

vdim_MaterialLoanset

vdim_MaterialSalesDataEquipment

vdim_MaterialSalesLoanset

vdim_OperationDate

vdim_OrderCreateDate

vdim_OrderRejectReason

vdim_ReturnDate

vdim_ReturnDateActual

vdim_SBSalesRep

vdim_SalesRepOriginal

vdim_SalesRepPeriodEnd

vdim_StorageLocationForOrders

vdim_ZRRep

Join List

Join0: dbo.dim_Client.PK_Client=dbo.vfact_Billings.FK_Client

Join1: dbo.dim_Material.PK_Material=dbo.vfact_Billings.FK_MaterialSubstituted


45/64


Page 45/64

Join2: dbo.dim_Customer.PK_Customer=dbo.vfact_Billings.FK_CustSoldTo

Join3: vdim_CustomerBillTo.PK_Customer=dbo.vfact_Billings.FK_CustBillTo

Join4: vdim_CustomerShipTo.PK_Customer=dbo.vfact_Billings.FK_CustShipTo

Join5: vdim_SalesRepPeriodEnd.PK_SalesRep=dbo.vfact_Billings.FK_SalesRepPeriodEnd

Join6: vdim_SalesRepOriginal.PK_SalesRep=dbo.vfact_Billings.FK_SalesRepOriginal

Join7: dbo.dim_SalesArea.PK_SalesArea=dbo.vfact_Billings.FK_SalesArea

Join8: dbo.dim_Currency.PK_Currency=dbo.vfact_Billings.FK_Currency

Join9: dbo.dim_Plant.PK_Plant=dbo.vfact_Billings.FK_Plant

Join10: dbo.vfact_Billings.FK_BillType=dbo.dim_BillType.PK_BillType

Join11: dbo.vfact_Billings.FK_OrderType=dbo.dim_OrderType.PK_OrderType

Join12: dbo.vfact_Billings.FK_BillingDate=dbo.dim_Date.PK_Date

Join13: dbo.vfact_Billings.FK_MaterialSalesDataSubstituted=dbo.dim_MaterialSalesData.PK_MaterialSalesData

Join14: dbo.vfact_Billings.FK_Incoterms=dbo.dim_Incoterms.PK_Incoterms

Join15: dbo.vfact_Billings.FK_PaymentTerms=dbo.dim_PaymentTerms.PK_PaymentTerms

Join16: dbo.vfact_Billings.FK_ShipConditions=dbo.dim_ShipConditions.PK_ShipConditions

Join17: dbo.dim_AcctAssignmentGroup.PK_AcctAssignmentGroup=dbo.vfact_Billings.FK_AcctAssignmentGroup

Join18: dbo.vfact_Billings.FK_Promotion=dbo.dim_Promotions.PK_Promotion

Join19: dbo.vfact_Billings.FK_SalesDeal=dbo.dim_SalesDeal.PK_SalesDeal

Join20: dbo.vfact_Billings.FK_OrderMethod=dbo.dim_OrderMethod.PK_OrderMethod

Join21: dbo.dim_Audit.Audit_Key=dbo.vfact_Billings.Audit_Key

Join22: dbo.vfact_Billings.FK_CustHierarchy=dbo.dim_CustHierarchy.PK_CustHierarchy

Join23: dbo.vfact_Billings.FK_VpcIndicator=dbo.dim_VpcIndicator.PK_VpcIndicator


46/64


Page 46/64

Join24: dbo.dim_SalesRep.PK_SalesRep=dbo.vfact_Billings.FK_SalesRepCurrent

Join25: dbo.vfact_Billings.FK_Client=dbo.fa

ct_FxRates.FK_Client and dbo.vfact_

Billings.FK_Currency=dbo.fact_FxRat

es.FK_FromCurrency anddbo.vfact_Billings.FK_BillingDate BETWEEN dbo.fact_FxRates.FK_FromDate AND dbo.fact_FxRates.FK_

dbo.fact_FxRates.To_Currency_Code=

@Prompt('Enter "To Currency Code":'

,'A','FX Rates\To Currency Code',Mo

no,Free)

Join26: dbo.dim_Client.PK_Client=dbo.fact_ImuStockLoaners.FK_Client

Join27: dbo.dim_Plant.PK_Plant=dbo.fact_ImuStockLoaners.FK_Plant

Join28: dbo.dim_Material.PK_Material=dbo.fact_ImuStockLoaners.FK_Material

Join29: dbo.fact_ImuStockLoaners.FK_StorageLocation=dbo.dim_StorageLocation.PK_StorageLocation

Join30: dbo.fact_ImuStockLoaners.FK_SpecialStock=dbo.dim_SpecialStock.PK_SpecialStock

Join31: dbo.dim_Currency.PK_Currency=dbo.fact_ImuStockLoaners.FK_Currency

Join32: dbo.fact_ImuStockLoaners.FK_LoadDate=vdim_ImuStockLoadDate.PK_Date

Join33: dbo.dim_Client.PK_Client=dbo.agg_BillingsPeriod.FK_Client

Join34: dbo.dim_Material.PK_Material=dbo.agg_BillingsPeriod.FK_MaterialSubstituted

Join35: dbo.dim_Customer.PK_Customer=dbo.agg_BillingsPeriod.FK_CustSoldTo

Join36: vdim_CustomerBillTo.PK_Customer=dbo.agg_BillingsPeriod.FK_CustBillTo

Join37: vdim_CustomerShipTo.PK_Customer=dbo.agg_BillingsPeriod.FK_CustShipTo

Join38: dbo.dim_SalesRep.PK_SalesRep=dbo.agg_BillingsPeriod.FK_SalesRepCurrent

Join39: vdim_SalesRepPeriodEnd.PK_SalesRep=dbo.agg_BillingsPeriod.FK_SalesRepPeriodEnd

Join40: vdim_SalesRepOriginal.PK_SalesRep=dbo.agg_BillingsPeriod.FK_SalesRepOriginal

Join41: dbo.agg_BillingsPeriod.FK_MaterialSalesDataSubstituted=dbo.dim_MaterialSalesData.PK_MaterialSales


47/64


Page 47/64

Join42: dbo.dim_SalesArea.PK_SalesArea=dbo.agg_BillingsPeriod.FK_SalesArea

Join43: dbo.dim_Currency.PK_Currency=dbo.agg_BillingsPeriod.FK_Currency

Join44: dbo.dim_Plant.PK_Plant=dbo.agg_BillingsPeriod.FK_Plant

Join45: dbo.agg_BillingsPeriod.FK_BillType=dbo.dim_BillType.PK_BillType

Join46: dbo.agg_BillingsPeriod.FK_OrderType=dbo.dim_OrderType.PK_OrderType

Join47: dbo.vfact_Billings.FK_StorageLocation=vdim_StorageLocationForOrders.PK_StorageLocation

Join48: dbo.dim_OrderReason.PK_OrderReason=dbo.vfact_Billings.FK_OrderReason

Join49: dbo.dim_OrderReason.PK_OrderReason=dbo.agg_BillingsPeriod.FK_OrderReason

Join50: dbo.agg_BillingsPeriod.FK_Incoterms=dbo.dim_Incoterms.PK_Incoterms

Join51: dbo.agg_BillingsPeriod.FK_PaymentTerms=dbo.dim_PaymentTerms.PK_PaymentTerms

Join52: dbo.agg_BillingsPeriod.FK_ShipConditions=dbo.dim_ShipConditions.PK_ShipConditions

Join53: dbo.agg_BillingsPeriod.FK_AcctAssignmentGroup=dbo.dim_AcctAssignmentGroup.PK_AcctAssignmentG

Join54: dbo.agg_BillingsPeriod.FK_Promotion=dbo.dim_Promotions.PK_Promotion

Join55: dbo.agg_BillingsPeriod.FK_SalesDeal=dbo.dim_SalesDeal.PK_SalesDeal

Join56: dbo.agg_BillingsPeriod.FK_OrderMethod=dbo.dim_OrderMethod.PK_OrderMethod

Join57: dbo.agg_BillingsPeriod.FK_CustHierarchy=dbo.dim_CustHierarchy.PK_CustHierarchy

Join58: dbo.agg_BillingsPeriod.FK_VpcIndicator=dbo.dim_VpcIndicator.PK_VpcIndicator

Join59: dbo.agg_BillingsPeriod.FK_StorageLocation=vdim_StorageLocationForOrders.PK_StorageLocation

Join60: dbo.dim_sDateFiscalPeriod.PK_DateFP=dbo.agg_BillingsPeriod.FK_BillingPeriod

Join61: dbo.agg_BillingsPeriod.Audit_Key=dbo.dim_Audit.Audit_Key

Join62: dbo.fact_ImuStockLoaners.Audit_Key=dbo.dim_Audit.Audit_Key

Join63: dbo.dim_Client.PK_Client=dbo.fact_ThirdPartySales.FK_Client


48/64


Page 48/64

Join64: dbo.dim_Material.PK_Material=dbo.fact_ThirdPartySales.FK_Material

Join65: dbo.dim_SalesArea.PK_SalesArea=dbo.fact_ThirdPartySales.FK_SalesArea

Join66: dbo.dim_Customer.PK_Customer=dbo.fact_ThirdPartySales.FK_Customer

Join67: dbo.dim_SalesRep.PK_SalesRep=dbo.fact_ThirdPartySales.FK_SalesRep

Join68: dbo.fact_ThirdPartySales.FK_MaterialSalesData=dbo.dim_MaterialSalesData.PK_MaterialSalesData

Join69: dbo.dim_Plant.PK_Plant=dbo.fact_ThirdPartySales.FK_Plant

Join70: dbo.fact_ThirdPartySales.FK_Date=dbo.dim_Date.PK_Date

Join71: dbo.dim_Currency.PK_Currency=dbo.fact_ThirdPartySales.FK_Currency

Join72: dbo.fact_ImuStockLoaners.FK_sCustomer=dbo.dim_sCustomer.PK_sCustomer

Join73: dbo.dim_Material.Material_Id=dbo.sfdim_MaterialCustomGroups.Material_Id AND

(dbo.sfdim_MaterialCustomGroups.Cu

stom_Group_Type + ' - ' + dbo.sfdim

_MaterialCustomGroups.Custom_Group

) = @Prompt('Select Custom Group T

ype and Group','A','Material Custom

Groups\Custom Group Type Group',m

ono,free)

Join74: dbo.dim_Client.PK_Client=dbo.fact_DemoInventory.FK_Client

Join75: dbo.dim_Material.PK_Material=dbo.fact_DemoInventory.FK_Material

Join76: dbo.dim_MovementType.PK_MovementType=dbo.fact_DemoInventory.FK_MovementType

Join77: dbo.dim_Plant.PK_Plant=dbo.fact_DemoInventory.FK_Plant

Join78: dbo.fact_DemoInventory.FK_PostedDate=dbo.dim_Date.PK_Date

Join79: dbo.dim_SalesRep.PK_SalesRep=dbo.fact_DemoInventory.FK_SalesRep

Join80: dbo.fact_DemoInventory.FK_SpecialStock=dbo.dim_SpecialStock.PK_SpecialStock

Join81: dbo.fact_DemoLimits.FK_sSalesDistrict=dbo.dim_sSalesRep.PK_sSalesRep


49/64


Page 49/64

Join82: dbo.dim_sMaterialLevel3.PK_MaterialLevel3=dbo.fact_SalesBudget.FK_sMaterialLevel3

Join83: dbo.dim_SalesArea.PK_SalesArea=dbo.fact_SalesBudget.FK_SalesArea

Join84: dbo.dim_SalesRep.PK_SalesRep=dbo.fact_SalesBudget.FK_SalesRep

Join85: dbo.dim_Client.PK_Client=dbo.fact_SalesBudget.FK_Client

Join86: dbo.dim_Currency.PK_Currency=dbo.fact_SalesBudget.FK_Currency

Join87: dbo.dim_sDateFiscalPeriod.PK_DateFP=dbo.fact_SalesBudget.FK_sDateFiscalPeriod

Join88: dbo.vfact_Billings.FK_MaterialSalesData=Original_dbo_dim_Material.PK_Material

Join89: dbo.dim_Client.PK_Client=dbo.fact_USSalesBudget.FK_Client

Join90: dbo.dim_Currency.PK_Currency=dbo.fact_USSalesBudget.FK_Currency

Join91: dbo.dim_sMaterialLevel3.PK_MaterialLevel3=dbo.fact_USSalesBudget.FK_MaterialLevel3

Join92: dbo.dim_sDateFiscalPeriod.PK_DateFP=dbo.fact_USSalesBudget.FK_sDatePeriod

Join93: dbo.fact_USSalesBudget.FK_sSalesRep=dbo.dim_sSalesRep.PK_sSalesRep

Join94: dbo.dim_Date.Fiscal_Year_Period=dbo.dim_sDateFiscalPeriod.Fiscal_Year_Period

Join95: dbo.dim_SalesRep.Client=dbo.dim_sSalesRep.Client and dbo.dim_SalesRep.Rep_Id=dbo.dim_sSalesRe

Join96: dbo.dim_Material.Source_System=dbo.dim_sMaterialLevel3.Source_System

and dbo.dim_Material.Client=dbo.dim_sMaterialLevel3.Client

and dbo.dim_Material.Level_3_Id=dbo.dim_sMaterialLevel3.Level_3_Id

Join97: dbo.dim_Customer.Source_System=db

o.dim_sCustomer.Source_System and

dbo.dim_Customer.Client=dbo.dim_sC

ustomer.Client and dbo.dim_Custome

r.Customer_Id=dbo.dim_sCustomer.Customer_Id

Join98: dbo.dim_Client.PK_Client=dbo.fact_LoanersConsignment.FK_Client

Join99: dbo.dim_Currency.PK_Currency=dbo.fact_LoanersConsignment.FK_Currency


50/64


Page 50/64

Join100: dbo.dim_Customer.PK_Customer=dbo.fact_LoanersConsignment.FK_Customer

Join101: dbo.dim_Client.PK_Client=dbo.fact_Equipment.FK_Client

Join102: dbo.dim_Material.PK_Material=dbo.fact_Equipment.FK_Material

Join103: dbo.fact_Equipment.FK_MaterialSalesData=dbo.dim_MaterialSalesData.PK_MaterialSalesData

Join104: dbo.dim_Plant.PK_Plant=dbo.fact_Equipment.FK_Plant

Join105: dbo.dim_SalesArea.PK_SalesArea=dbo.fact_Equipment.FK_SalesArea

Join106: dbo.fact_Equipment.FK_StorageLocation=dbo.dim_StorageLocation.PK_StorageLocation

Join107: dbo.fact_LoanersConsignment.FK_Equipment=dbo.fact_Equipment.PK_Equipment

Join108: dbo.dim_Material.PK_Material=dbo.fact_LoanersConsignment.FK_Material

Join109: dbo.fact_LoanersConsignment.FK_MaterialSalesData=dbo.dim_MaterialSalesData.PK_MaterialSalesDat

Join110: dbo.dim_Plant.PK_Plant=dbo.fact_LoanersConsignment.FK_Plant

Join111: dbo.fact_LoanersConsignment.FK_Reservations=dbo.fact_Reservations.PK_Reservations

Join112: dbo.dim_SalesArea.PK_SalesArea=dbo.fact_LoanersConsignment.FK_SalesArea

Join113: dbo.fact_LoanersConsignment.FK_SpecialStock=dbo.dim_SpecialStock.PK_SpecialStock

Join114: dbo.fact_LoanersConsignment.FK_StorageLocation=dbo.dim_StorageLocation.PK_StorageLocation

Join115: dbo.dim_Client.PK_Client=dbo.fact_Reservations.FK_Client

Join116: vdim_CustomerShipTo.PK_Customer=dbo.fact_Reservations.FK_CustomerShipTo

Join117: dbo.dim_Customer.PK_Customer=dbo.fact_Reservations.FK_CustomerSoldTo

Join118: dbo.fact_Equipment.PK_Equipment=dbo.fact_Reservations.FK_Equipment

Join119: dbo.dim_Incoterms.PK_Incoterms=dbo.fact_Reservations.FK_Incoterms

Join120: dbo.dim_Plant.PK_Plant=dbo.fact_Reservations.FK_Plant

Join121: dbo.dim_RejectReason.PK_RejectReason=dbo.fact_Reservations.FK_RejectionReason


51/64


Page 51/64

Join122: dbo.dim_ReservationType.PK_ReservationType=dbo.fact_Reservations.FK_ReservationType

Join123: dbo.dim_SalesArea.PK_SalesArea=dbo.fact_Reservations.FK_SalesArea

Join124: dbo.dim_ShipConditions.PK_ShipConditions=dbo.fact_Reservations.FK_ShippingConditions

Join125: vdim_DeliveryDate.PK_Date=dbo.fact_Reservations.FK_DeliveryDate

Join126: vdim_OperationDate.PK_Date=dbo.fact_Reservations.FK_OperationDate

Join127: vdim_ReturnDate.PK_Date=dbo.fact_Reservations.FK_ReturnDate

Join128: vdim_ReturnDateActual.PK_Date=dbo.fact_Reservations.FK_ReturnDateActual

Join129: dbo.dim_Material.PK_Material=dbo.fact_Reservations.FK_MaterialComponent

Join130: dbo.fact_Reservations.FK_MaterialSalesDataComponent=dbo.dim_MaterialSalesData.PK_MaterialSales

Join131: vdim_MaterialEquipment.PK_Material=dbo.fact_Reservations.FK_MaterialEquipment

Join132: vdim_MaterialSalesDataEquipment.PK_MaterialSalesData=dbo.fact_Reservations.FK_MaterialSalesData

Join133: dbo.fact_LoanersConsignment.FK_MaterialLoanset=vdim_MaterialLoanset.PK_Material

Join134: dbo.fact_LoanersConsignment.FK_MaterialSalesDataLoanset=vdim_MaterialSalesLoanset.PK_MaterialS

Join135: dbo.dim_Client.PK_Client=dbo.fact_DemoOrders.FK_Client

Join136: dbo.dim_ItemCategory.PK_Itemcategory=dbo.fact_DemoOrders.FK_ItemCategory

Join137: dbo.fact_DemoOrders.FK_LineCreateDate=dbo.dim_Date.PK_Date

Join138: dbo.dim_Material.PK_Material=dbo.fact_DemoOrders.FK_Material

Join139: dbo.dim_MaterialSalesData.PK_MaterialSalesData=dbo.fact_DemoOrders.FK_MaterialSalesData

Join140: dbo.fact_DemoOrders.FK_OrderCreateDate=vdim_OrderCreateDate.PK_Date

Join141: dbo.fact_DemoOrders.FK_OrderType=dbo.dim_OrderType.PK_OrderType

Join142: dbo.dim_Plant.PK_Plant=dbo.fact_DemoOrders.FK_Plant

Join143: dbo.dim_ReferenceStatus.PK_ReferenceStatus=dbo.fact_DemoOrders.FK_ReferenceStatus


52/64


Page 52/64

Join144: dbo.fact_DemoOrders.FK_RejectReason=vdim_OrderRejectReason.PK_RejectReason

Join145: dbo.fact_DemoOrders.FK_SBSalesRep=vdim_SBSalesRep.PK_SalesRep

Join146: dbo.dim_SalesArea.PK_SalesArea=dbo.fact_DemoOrders.FK_SalesArea

Join147: dbo.fact_DemoOrders.FK_SpecialStock=dbo.dim_SpecialStock.PK_SpecialStock

Join148: dbo.dim_BillingBlock.PK_BillingBlock=dbo.fact_Orders.FK_BillingBlock

Join149: vdim_BillingBlockLine.PK_BillingBlock=dbo.fact_Orders.FK_BillingBlockLine

Join150: dbo.dim_Client.PK_Client=dbo.fact_Orders.FK_Client

Join151: dbo.dim_Currency.PK_Currency=dbo.fact_Orders.FK_Currency

Join152: vdim_CustomerShipTo.PK_Customer=dbo.fact_Orders.FK_CustShipTo

Join153: dbo.dim_Customer.PK_Customer=dbo.fact_Orders.FK_CustSoldTo

Join154: dbo.dim_DeliveryBlock.PK_DeliveryBlock=dbo.fact_Orders.FK_DeliveryBlock

Join155: dbo.dim_DeliveryPriority.PK_DeliveryPriority=dbo.fact_Orders.FK_DeliveryPriority

Join156: dbo.dim_ItemCategory.PK_Itemcategory=dbo.fact_Orders.FK_ItemCategory

Join157: dbo.fact_Orders.FK_LineCreateDate=dbo.dim_Date.PK_Date

Join158: dbo.dim_Material.PK_Material=dbo.fact_Orders.FK_Material

Join159: dbo.dim_MaterialSalesData.PK_MaterialSalesData=dbo.fact_Orders.FK_MaterialSalesData

Join160: dbo.fact_Orders.FK_OrderCreateDate=vdim_OrderCreateDate.PK_Date

Join161: dbo.dim_OrderReason.PK_OrderReason=dbo.fact_Orders.FK_OrderReason

Join162: dbo.fact_Orders.FK_OrderType=dbo.dim_OrderType.PK_OrderType

Join163: dbo.dim_Plant.PK_Plant=dbo.fact_Orders.FK_Plant

Join164: dbo.dim_POMethod.PK_POMethod=dbo.fact_Orders.FK_POMethod

Join165: dbo.fact_Orders.FK_Promotion=dbo.dim_Promotions.PK_Promotion


53/64


Page 53/64

Join166: dbo.dim_MaterialSubstitutionReason.PK_MaterialSubstitutionReason=dbo.fact_Orders.FK_ReasonForM

Join167: dbo.dim_ReferenceStatus.PK_ReferenceStatus=dbo.fact_Orders.FK_ReferenceStatus

Join168: dbo.fact_Orders.FK_RejectReason=vdim_OrderRejectReason.PK_RejectReason

Join169: dbo.dim_Route.PK_Route=dbo.fact_Orders.FK_Route

Join170: dbo.fact_Orders.FK_SBSalesRep=vdim_SBSalesRep.PK_SalesRep

Join171: dbo.dim_SalesArea.PK_SalesArea=dbo.fact_Orders.FK_SalesArea

Join172: dbo.fact_Orders.FK_SalesDeal=dbo.dim_SalesDeal.PK_SalesDeal

Join173: dbo.dim_SalesRep.PK_SalesRep=dbo.fact_Orders.FK_SalesRep

Join174: dbo.fact_Orders.FK_ShippingConditions=dbo.dim_ShipConditions.PK_ShipConditions

Join175: dbo.dim_ShippingPoint.PK_ShippingPoint=dbo.fact_Orders.FK_ShippingRecievingPoint

Join176: dbo.fact_Orders.FK_SpecialStock=dbo.dim_SpecialStock.PK_SpecialStock

Join177: dbo.fact_Orders.FK_StorageLocation=vdim_StorageLocationForOrders.PK_StorageLocation

Join178: dbo.fact_Orders.FK_VPCIndicator=dbo.dim_VpcIndicator.PK_VpcIndicator

Join179: dbo.fact_Orders.FK_ZRRep=vdim_ZRRep.PK_SalesRep

Join180: vdim_CustomerBillTo.PK_Customer=dbo.fact_Orders.FK_CustPayer

Join181: dbo.dim_SalesRep.PK_SalesRep=dbo.fact_DemoOrders.FK_SalesRep

Join182: dbo.dim_BillingBlock.PK_BillingBlock=dbo.fact_Contracts.FK_BillingBlock

Join183: vdim_BillingBlockLine.PK_BillingBlock=dbo.fact_Contracts.FK_BillingBlockLine

Join184: dbo.dim_Client.PK_Client=dbo.fact_Contracts.FK_Client

Join185: vdim_OrderCreateDate.PK_Date=dbo.fact_Contracts.FK_ContractCreateDate

Join186: dbo.fact_Contracts.FK_ContractEndDate=vdim_ContractEndDate.PK_Date

Join187: dbo.dim_Date.PK_Date=dbo.fact_Contracts.FK_ContractLineCreateDate


54/64


Page 54/64

Join188: dbo.fact_Contracts.FK_ContractStartDate=vdim_ContractStartDate.PK_Date

Join189: dbo.dim_Currency.PK_Currency=dbo.fact_Contracts.FK_Currency

Join190: vdim_CustomerBillTo.PK_Customer=dbo.fact_Contracts.FK_CustPayer

Join191: vdim_CustomerShipTo.PK_Customer=dbo.fact_Contracts.FK_CustShipTo

Join192: dbo.dim_Customer.PK_Customer=dbo.fact_Contracts.FK_CustSoldTo

Join193: dbo.dim_DeliveryBlock.PK_DeliveryBlock=dbo.fact_Contracts.FK_DeliveryBlock

Join194: dbo.dim_DeliveryPriority.PK_DeliveryPriority=dbo.fact_Contracts.FK_DeliveryPriority

Join195: dbo.dim_ItemCategory.PK_Itemcategory=dbo.fact_Contracts.FK_ItemCategory

Join196: dbo.dim_Material.PK_Material=dbo.fact_Contracts.FK_Material

Join197: dbo.dim_MaterialSalesData.PK_MaterialSalesData=dbo.fact_Contracts.FK_MaterialSalesData

Join198: dbo.dim_MaterialSubstitutionReason.PK_MaterialSubstitutionReason=dbo.fact_Contracts.FK_MaterialS

Join199: dbo.dim_OrderReason.PK_OrderReason=dbo.fact_Contracts.FK_OrderReason

Join200: dbo.dim_OrderType.PK_OrderType=dbo.fact_Contracts.FK_OrderType

Join201: dbo.dim_POMethod.PK_POMethod=dbo.fact_Contracts.FK_POMethod

Join202: dbo.dim_Plant.PK_Plant=dbo.fact_Contracts.FK_Plant

Join203: dbo.dim_Promotions.PK_Promotion=dbo.fact_Contracts.FK_Promotion

Join204: dbo.dim_ReferenceStatus.PK_ReferenceStatus=dbo.fact_Contracts.FK_ReferenceStatus

Join205: vdim_OrderRejectReason.PK_RejectReason=dbo.fact_Contracts.FK_RejectionReason

Join206: dbo.dim_Route.PK_Route=dbo.fact_Contracts.FK_Route

Join207: vdim_SBSalesRep.PK_SalesRep=dbo.fact_Contracts.FK_SBSalesRep

Join208: dbo.dim_SalesArea.PK_SalesArea=dbo.fact_Contracts.FK_SalesArea

Join209: dbo.dim_SalesDeal.PK_SalesDeal=dbo.fact_Contracts.FK_SalesDeal


55/64


Page 55/64

Join210: dbo.dim_SalesRep.PK_SalesRep=dbo.fact_Contracts.FK_SalesRep

Join211: dbo.dim_ShipConditions.PK_ShipConditions=dbo.fact_Contracts.FK_ShippingConditions

Join212: dbo.dim_ShippingPoint.PK_ShippingPoint=dbo.fact_Contracts.FK_ShippingRecievingPoint

Join213: dbo.dim_SpecialStock.PK_SpecialStock=dbo.fact_Contracts.FK_SpecialStock

Join214: dbo.dim_StorageLocation.PK_StorageLocation=dbo.fact_Contracts.FK_StorageLocation

Join215: dbo.dim_VpcIndicator.PK_VpcIndicator=dbo.fact_Contracts.FK_VpcIndicator

Join216: vdim_ZRRep.PK_SalesRep=dbo.fact_Contracts.FK_ZRRep

Context ListIMU Stock

Loaners Equipment

Billings Summary by Fiscal Period

Third Party

US Sales Budget

Billings

Orders

Demo Limits

Demo Inventory

European Sales BudgetLoaners Consignment

Contracts

Demo Orders

Loaners Reservations


56/64


Page 56/64

PK_Client N

PK_Material N

PK_Customer N

PK_Customer N

PK_Customer N

PK_SalesRep N

PK_SalesRep N

PK_SalesArea N

PK_Currency N

PK_Plant N

PK_OrderType

PK_Date

PK_MaterialSalesData N

PK_Incoterms

PK_PaymentTerms

PK_ShipConditions

PK_AcctAssignmen

PK_Promotion

PK_SalesDeal

PK_OrderMethod

Audit_Key

PK_CustHierarchy

PK_VpcIndicator

PK_SalesRep N FK_Client

FK_FromCurrency

FK_FromDate

FK_ToDate

To_Currency_Code

PK_Client N

PK_Plant N

PK_Material N

PK_StorageLocatio

PK_SpecialStock

PK_Currency N

PK_Date

PK_Client N

PK_Material N

PK_Customer N

PK_Customer N

PK_Customer N

PK_SalesRep N

PK_SalesRep N

PK_SalesRep N


PK_SalesArea N

PK_Currency N

PK_Plant N

PK_OrderType

PK_StorageLocatio

PK_Incoterms

PK_PaymentTerms

PK_ShipConditions

PK_AcctAssignmen

PK_Promotion

PK_SalesDeal

PK_OrderMethod

PK_CustHierarchy

PK_VpcIndicator

PK_StorageLocatio

PK_DateFP

Audit_KeyAudit_Key

PK_Client N

PK_Material N

PK_SalesArea N

PK_Customer N

PK_SalesRep N


PK_Plant N

PK_Date

PK_Currency N

PK_sCustomer N

Material_Id C

PK_Client N

PK_Material N

PK_Plant N

PK_Date

PK_SalesRep N

PK_SpecialStock

PK_sSalesRep N

PK_MaterialLevel3 N

PK_SalesArea N

PK_SalesRep N

PK_Client N

PK_Currency N

PK_DateFP

PK_Client N

PK_Currency N

PK_MaterialLevel3 N

PK_DateFP

PK_sSalesRep N

Fiscal_Year_Period

Fiscal_Year_Period

Client C

Rep_Id C

Client C

Rep_Id C

Source_System C

Client C

Level_3_Id C

Source_System C

Client C

Level_3_Id C

Source_System C

Client C

Customer_Id C

Source_System C

Client C

Customer_Id C

PK_Client N

PK_Currency N

PK_Customer N

PK_Client N

PK_Material N


PK_Plant N

PK_SalesArea N

PK_StorageLocatio

PK_Material N


PK_Plant N

PK_SalesArea N

PK_SpecialStock

PK_StorageLocatio

PK_Client N

PK_Customer N

PK_Customer N

PK_Incoterms

PK_Plant N

PK_SalesArea N

PK_ShipConditions

PK_Material N


PK_Client N

PK_Date

PK_Material N


PK_OrderType

PK_Plant N

PK_SalesArea N

PK_SpecialStock

PK_Client N

PK_Currency N

PK_Customer N

PK_Customer N

PK_Date

PK_Material N


PK_OrderType

PK_Plant N

PK_Promotion

PK_SalesArea N

PK_SalesDeal

PK_SalesRep N

PK_ShipConditions

PK_SpecialStock

PK_StorageLocatio

PK_VpcIndicator

PK_Customer N

PK_SalesRep N

PK_Client N

PK_Date

PK_Currency N

PK_Customer N

PK_Customer N

PK_Customer N

PK_Material N


PK_OrderType

PK_Plant N

PK_Promotion

PK_SalesArea N

PK_SalesDeal

PK_SalesRep N

PK_ShipConditions

PK_SpecialStock

PK_StorageLocatio

PK_VpcIndicator

ALIASED TABLES - DO NOT DELETE !!!

dbo.fact_Orders

PK_Orders N...

dbo.agg_BillingsPeriod

dbo

PK_Date

Fiscal_Year_Period

dbo.dim_RejectR

dbo.fact_Equipment

vdim_CustomerBillTo

PK_Customer N

dbo.dim_SalesArea

PK_SalesArea N

dbo.dim_Currency

PK_Currency N

dbo.dim_Client

PK_Client N

dbo.dim_Plant

PK_Plant N

dbo.vfact_Billings

dbo.fact_ThirdPartySales

dbo.fact_DemoInventory


PK_SalesRep N vdim_StorageLoc

PK_StorageLocatio

dbo.dim_MaterialSalesData


dbo.dim_sSalesRep

PK_sSalesRep N

Client C

Rep_Id C

dbo.dim_s

PK_DateFP

Fiscal_Year_Period

dbo.dim_Pro

PK_Promotion

vdim_CustomerShipTo

PK_Customer N

dbo.fact_USSalesBudget

dbo.dim_Incote

PK_Incoterms

dbo.fact_DemoLimits

dbo.dim_Customer

PK_Customer N

Source_System C

Client C

Customer_Id C

dbo.dim_BillTy

dbo.fact_DemoOrders

dbo.fact_Reservations

dbo.dim_VpcInd

PK_VpcIndicator

dbo.dim_Specia

PK_SpecialStock

dbo.fact_ImuStockLoaners

dbo.dim_sMaterialLevel3

PK_MaterialLevel3 N

Source_System C

Client C

Level_3_Id C

dbo.fact_SalesBudget

vdim_Im

PK_Date

dbo.dim_OrderM

PK_OrderMethod

dbo.dim_ShipC

PK_ShipConditions

dbo.fact_Contracts

dbo.fact_FxR

FK_Client

FK_FromCurrency

FK_FromDate

FK_ToDate

To_Currency_Codevdim_SalesRepPeriodEnd

PK_SalesRep N

dbo.fact_LoanersConsignment

dbo.dim_sCustomer

PK_sCustomer N

Source_System C

Client C

Customer_Id C

dbo.dim_Order

PK_OrderType

dbo.dim_Material

PK_Material N

Source_System C

Client C

Material_Id C

Level_3_Id C

dbo.dim_SalesRep

PK_SalesRep N

Client C

Rep_Id C

dbo.dim_Cust

PK_CustHierarchy

dbo.dim_Audit

Audit_Key

dbo.dim_Paymen

PK_PaymentTerms

dbo.dim_AcctA

PK_AcctAssignmen

dbo.dim_Sa

PK_SalesDeal

dbo.dim_Storage

PK_StorageLocatio


57/64


Page 57/64

K_OrderType N

K_Date N

K_Incoterms N

K_PaymentTerms N

K_ShipConditions N

K_AcctAssignmentGroup N

K_Promotion N

K_SalesDeal N

K_OrderMethod N

udit_Key N

K_CustHierarchy N

K_VpcIndicator N

K_Client N

K_FromCurrency N

K_FromDate N

K_ToDate N

o_Currency_Code C

K_StorageLocation N

K_SpecialStock N

K_Date N

K_OrderType N

K_StorageLocation N

K_Incoterms N

K_PaymentTerms N

K_ShipConditions N


K_Promotion N

K_SalesDeal N

K_OrderMethod N

K_CustHierarchy N

K_VpcIndicator N

K_StorageLocation N

K_DateFP N

udit_Key Nudit_Key N

K_Date NK_Date N

K_SpecialStock N

K_DateFP NK_DateFP N

scal_Year_Period C

scal_Year_Period C

K_StorageLocation N

K_SpecialStock N

K_StorageLocation N

K_Incoterms N

K_ShipConditions N

K_Date N

K_OrderType N

K_SpecialStock N

K_Date N

K_OrderType N

K_Promotion N

K_SalesDeal N

K_ShipConditions N

K_SpecialStock N

K_StorageLocation N

K_VpcIndicator N

K_Date N

K_OrderType N

K_Promotion N

K_SalesDeal N

K_ShipConditions N

K_SpecialStock N

K_StorageLocation N

K_VpcIndicator N

dbo.dim_Date

K_Date N

scal_Year_Period C



K_StorageLocation N

dbo.dim_sDateFiscalPeriod

K_DateFP N

scal_Year_Period C

dbo.dim_Promotions

K_Promotion N

dbo.dim_Incoterms

K_Incoterms N

dbo.dim_BillType

dbo.dim_VpcIndicator

K_VpcIndicator N


K_SpecialStock N

vdim_ImuStockLoadDate

K_Date N

dbo.dim_OrderMethod

K_OrderMethod N

dbo.dim_ShipConditions

K_ShipConditions N

dbo.fact_FxRates

K_Client N

K_FromCurrency N

K_FromDate N

K_ToDate N

o_Currency_Code C

dbo.dim_OrderType

K_OrderType N

dbo.dim_CustHierarchy

K_CustHierarchy N

dbo.dim_Audit

Audit_Key N

dbo.dim_PaymentTerms

K_PaymentTerms N

dbo.dim_AcctAssignmentGroup


dbo.dim_SalesDeal

K_SalesDeal N

dbo.dim_StorageLocation

K_StorageLocation N


58/64


Page 58/64

Security Do not delete

dbo.vfact_ThirdPartySales_REP

dbo.vfact_DemoOrders_REP

dbo.vfact_DemoInventory_REP

dbo.vfact_DemoOrders_DE

dbo.vfact_Billings_DE

dbo.vfact_DemoLimits_DE

dbo.vfact_ThirdPartySales_DE

dbo.vagg_BillingsPeriod_REP

dbo.vfact_DemoInventory_DE

dbo.vfact_Billings_REP

dbo.vfact_DemoLimits_REP

dbo.vagg_BillingsPeriod_DE


59/64


Page 59/64

PK_SalesRep N

PK_SalesArea N

PK_Currency N

PK_Plant N

Audit_Key

PK_Plant N

PK_SpecialStock

PK_Currency N

PK_SalesRep N

PK_SalesArea N

PK_Currency N

PK_Plant N

PK_StorageLocatio

PK_OrderReason NPK_OrderReason N

PK_StorageLocatio

Audit_KeyAudit_Key

PK_SalesArea N

PK_Plant N

PK_Currency N

Material_Id C

Custom_Group_Type C

Custom_Group C

PK_MovementType N

PK_Plant N

PK_SpecialStock

PK_SalesArea N

PK_Currency N

PK_Material N

PK_Currency NPK_Currency N

PK_Plant N

PK_SalesArea N

PK_Plant N

PK_SalesArea N

PK_SpecialStock

PK_Plant N

PK_RejectReason

PK_ReservationTyp

PK_SalesArea N

PK_Date

PK_Date

PK_Date

PK_Date

PK_Material

PK_MaterialSalesDa

PK_Material

PK_MaterialSalesDa

PK_Itemcategory N

PK_Date

PK_Plant N

PK_ReferenceStatus N

PK_RejectReason

PK_SalesRep

PK_SalesArea N

PK_SpecialStock

PK_BillingBlock N

PK_BillingBlock N

PK_Currency N

PK_DeliveryBlock N

PK_DeliveryPriority N

PK_Itemcategory N

PK_Date

PK_OrderReason N

PK_Plant N

PK_POMethod N

PK_MaterialSubstitutionReason N


PK_RejectReason

PK_Route N PK_SalesRep

PK_SalesArea N

PK_ShippingPoint N

PK_SpecialStock

PK_StorageLocatio

PK_SalesRep

PK_BillingBlock N

PK_BillingBlock N

PK_Date

PK_Date

PK_Currency N

PK_DeliveryBlock N


PK_Itemcategory N


PK_OrderReason N

PK_POMethod N

PK_Plant N


PK_RejectReason

PK_Route N PK_SalesRep

PK_SalesArea N

PK_ShippingPoint N

PK_SpecialStock

PK_SalesRep

vdim_Materia

PK_MaterialSalesDa

dbo.fact_Orders

PK_Orders N...

dbo.dim_RejectR

PK_RejectReason

dbo.sfdim_MaterialCustomGroups

Material_Id C

Custom_Group_Type C

Custom_Group C

vdim_ZRRep

PK_SalesRep

dbo.dim_SalesArea

PK_SalesArea N

dbo.dim_ReferenceStatus


dbo.dim_Currency

PK_Currency N

dbo.dim_Plant

PK_Plant N

vdim_

PK_Material

vdim_

PK_Date

vdim_OrPK_Date

dbo.dim_ItemCategory

PK_Itemcategory N

vdim_

PK_Date

dbo.dim_BillingBlock

PK_BillingBlock N

dbo.dim_DeliveryBlock

PK_DeliveryBlock N

vdim_SBSalesR

PK_SalesRep

vdim_Re

PK_Date

vdim_OrderRejec

PK_RejectReason


PK_SalesRep N

vdim_Ma

PK_MaterialSalesDa

vdim_StorageLoc

PK_StorageLocatio

vdim_O

PK_Date

dbo.dim_DeliveryPriority


Original_dbo_dim_Material

PK_Material N

dbo.fact_DemoOrders

dbo.dim_MaterialSubstitutionReason


dbo.dim_Specia

PK_SpecialStock

dbo.dim_Reserv

PK_ReservationTyp

dbo.dim_Route

PK_Route N

dbo.fact_Contracts

dbo.dim_ShippingPoint

PK_ShippingPoint N

dbo.dim_OrderReason

PK_OrderReason N

vdim_M

PK_Material

dbo.dim_Audit

Audit_Key

dbo.dim_MovementType

PK_MovementType N

vdim_Co

PK_Date

TheDate

dbo.dim_POMethod

PK_POMethod N

vdim_BillingBlockLine

PK_BillingBlock N


60/64


Page 60/64

udit_Key N

K_SpecialStock N

K_StorageLocation NK_StorageLocation N

udit_Key Nudit_Key N

K_SpecialStock NK_SpecialStock N

K_RejectReason N

K_ReservationType N

K_Date N

K_Date N

K_Date N

K_Date N

K_Material N

K_MaterialSalesData N

K_Material N


K_Date N

K_RejectReason N

K_SalesRep N

K_SpecialStock N

K_Date N

K_RejectReason N

K_SalesRep N

K_SpecialStock N

K_StorageLocation N

K_SalesRep N

K_Date N

K_Date N

K_RejectReason N

K_SalesRep N

K_SpecialStock N

K_SalesRep N

vdim_MaterialSalesDataEquipment



K_RejectReason N

vdim_ZRRep

K_SalesRep N

vdim_MaterialLoanset

K_Material N

vdim_ReturnDate

K_Date N

vdim_OrderCreateDateK_Date N

vdim_DeliveryDate

K_Date N

vdim_SBSalesRep

K_SalesRep N

vdim_ReturnDateActual

K_Date N

vdim_OrderRejectReason

K_RejectReason N

vdim_MaterialSalesLoanset



K_StorageLocation N

vdim_OperationDate

K_Date N


K_SpecialStock N

dbo.dim_ReservationType

K_ReservationType N

vdim_MaterialEq

global data warehouse

Documents