Microsoft Dynamics NAV 3.01

Cubes

Customer Ledger

Bus Matrix

Aging Bucket
Company
Credit Limit Type
Customer
Customer Ledger Entry
Due Period
Posting Period
SalespersonPurchaser
Source
Amount x x x x x x x x x
Amount Credited x x x x x x x x x
Amount Debited x x x x x x x x x
Average number of Open Days x x x x x x x x x
Average number of Overdue Days x x x x x x x x x
Avg Customer Balance x x x x x x x x x
Closed Amount x x x x x x x x x
Closed Entry Count x x x x x x x x x
Credit Limit x x x x
Credit Limit Utilization x x x x
Current Balance Due x x x x x x x x x
Current Balance Overdue x x x x x x x x x
Customer Balance x x x x x x x x x
Limited Customer Balance x x x x x x x x x
Overdue Entry Count x x x x x x x x x
Sales x x x x x x x x x
Tota number of Overdue Days x x x x x x x x x
Total number of Open Days x x x x x x x x x
Turnover Ratio x x x x x x x x x

Measures

Amount
Aggregate function Sum
Source fDetailedCustLedgEntry.AmountLCY
Visible to Users True
Amount Debited
Aggregate function Sum
Source fDetailedCustLedgEntry.DebitAmountLCY
Visible to Users True
Amount Credited
Aggregate function Sum
Source fDetailedCustLedgEntry.CreditAmountLCY
Visible to Users True
Total number of Open Days
Aggregate function Sum
Source fDetailedCustLedgEntry.wOpenDays
Visible to Users True
Tota number of Overdue Days
Aggregate function Sum
Source fDetailedCustLedgEntry.wOverdueDays
Visible to Users True
Closed Entry Count
Aggregate function Sum
Source fDetailedCustLedgEntry.wCountClosed
Visible to Users True
Overdue Entry Count
Aggregate function Sum
Source fDetailedCustLedgEntry.wCountOverdue
Visible to Users True
Closed Amount
Aggregate function Sum
Source fDetailedCustLedgEntry.wClosedAmountLCY
Visible to Users True
Credit Limit
Aggregate function Sum
Source dCustomer.CreditLimitLCY
Visible to Users True
Current Balance Due
Aggregate function Sum
Source fCustLedgerEntry.wRemainingAmountLCY
Visible to Users True
Sales
Aggregate function Sum
Source fCustLedgerEntry.SalesLCY
Visible to Users True
Current Balance Overdue
Aggregate function Sum
Source fCustLedgerEntry.wRemainingAmountOverdueLCY
Visible to Users True

Calculations

Average number of Open Days
Expression [Total number of Open Days]/[Closed Entry Count]
Visible to Users True
Average number of Overdue Days
Expression [Total number of Overdue Days]/[Overdue Entry Count]
Visible to Users True
Customer Balance
Function End Balance
Expression [Amount]
Visible to Users True
Limited Customer Balance
Expression ([Credit Limit Type].[Credit Limit ID].&[1],[Customer Balance])
Visible to Users True
Credit Limit Utilization
Expression ([Limited Customer Balance]/[Credit Limit])*100
Visible to Users True
Avg Customer Balance
Expression ([Customer Balance]+[wCustomerOpeningBalance])/2
Visible to Users True
Turnover Ratio
Expression round([Sales]/[Avg Customer Balance],2)
Visible to Users True

Dimensions

Aging Bucket
Attributes
Name Source Description
Group wdAgingBucket.Text
Company
Attributes
Name Source Description
Name wdCompany.CompanyName
Credit Limit Type
Attributes
Name Source Description
Text dCustomer.wHasCreditLimit
Customer
Attributes
Name Source Description
Number dCustomer.No
Name dCustomer.Name
Number and Name dCustomer.NoName
Credit Limit dCustomer.wHasCreditLimit
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name Source Attribute Description
Territory Territory
Name Name
Customer Country
Level Name Source Attribute Description
Country Country
Name Name
Customer Ledger Entry
Attributes
Name Source Description
Number fCustLedgerEntry.EntryNo
Description fCustLedgerEntry.Description
Document Type wdJournalDocumentType.Text
Document Number fCustLedgerEntry.DocumentNo
Due Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week wdPostingPeriod.WeekName
Week Year wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name Source Attribute Description
Year Year
Quarter wYearQuarter
Month wYearMonth
Date Date
Calendar Hierarchy
Level Name Source Attribute Description
Year Calendar Year
Quarter wCalendarYearQuarter
Month wCalendarYearMonth
Date Calendar Date
Week Hierarchy
Level Name Source Attribute Description
Year Week Year
Week wYearWeek
Date Date
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week wdPostingPeriod.WeekName
Week Year wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name Source Attribute Description
Year Year
Quarter wYearQuarter
Month wYearMonth
Date Date
Calendar Hierarchy
Level Name Source Attribute Description
Year Calendar Year
Quarter wCalendarYearQuarter
Month wCalendarYearMonth
Date Calendar Date
Week Hierarchy
Level Name Source Attribute Description
Year Week Year
Week wYearWeek
Date Date
SalespersonPurchaser
Attributes
Name Source Description
Name dSalespersonPurchaser.Name
Source
Attributes
Name Source Description
Description dSourceCode.Description

General Ledger

Bus Matrix

Account
Budget Name
Business Posting Group
Closing Entries
Company
Customer
General Ledger Detail
IncomeBalance
Job
Posting Period
Product Posting Group
Source
Vendor
Amount Credited x x x x x x x x x x x x
Amount Debited x x x x x x x x x x x x
Amount Posted x x x x x x x x x x x x
Budget Amount x x x x x
Budget Index x x x x
Budget Variance x x x x
End Balance x x x x x x x x x x x x
Start Balance x x x x x x x x x x x x

Measures

Amount Posted
Aggregate function Sum
Source fGLEntry.Amount
Visible to Users True
Amount Debited
Aggregate function Sum
Source fGLEntry.DebitAmount
Visible to Users True
Amount Credited
Aggregate function Sum
Source fGLEntry.CreditAmount
Visible to Users True
Budget Amount
Aggregate function Sum
Source fGLBudgetEntry.Amount
Visible to Users True

Calculations

Budget Variance
Expression [Amount Posted]-[Budget Amount]
Visible to Users True
Budget Index
Expression ([Amount Posted]/[Budget Amount])
Visible to Users True
End Balance
Function End Balance
Expression [Amount Posted]
Visible to Users True
Start Balance
Expression [End Balance]-[Amount Posted]
Visible to Users True

Dimensions

Account
Attributes
Name Source Description
Account Table dGLAccount.Name
Number dGLAccount.No
Name dGLAccount.Name
Number and Name dGLAccount.NoName
IncomeBalance dGLAccount.wAccountGroup
Company and Account dGLAccount.CompanyNoName
Budget Name
Attributes
Name Source Description
Name dGLBudgetName.Description
Business Posting Group
Attributes
Name Source Description
Description dGenBusinessPostingGroup.Description
Closing Entries
Attributes
Name Source Description
Text wdPostingDateClosing.ClosingText
Company
Attributes
Name Source Description
Name wdCompany.CompanyName
Customer
Attributes
Name Source Description
Number dCustomer.No
Name dCustomer.Name
Number and Name dCustomer.NoName
Credit Limit dCustomer.wHasCreditLimit
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name Source Attribute Description
Territory Territory
Name Name
Customer Country
Level Name Source Attribute Description
Country Country
Name Name
General Ledger Detail
Attributes
Name Source Description
Number fGLEntry.EntryNo
Type wdGLSourceType.Text
Hierarchies
Number Group
Level Name Source Attribute Description
Range wGroup
Number Number
IncomeBalance
Attributes
Name Source Description
Text dGLAccount.wAccountGroup
Job
Attributes
Name Source Description
Job Description dJob.Description
Status wdJobStatus.Text
Job Number dJob.No
Job Number and Description dJob.NumberName
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week wdPostingPeriod.WeekName
Week Year wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name Source Attribute Description
Year Year
Quarter wYearQuarter
Month wYearMonth
Date Date
Calendar Hierarchy
Level Name Source Attribute Description
Year Calendar Year
Quarter wCalendarYearQuarter
Month wCalendarYearMonth
Date Calendar Date
Week Hierarchy
Level Name Source Attribute Description
Year Week Year
Week wYearWeek
Date Date
Product Posting Group
Attributes
Name Source Description
Description dGenProductPostingGroup.Description
Source
Attributes
Name Source Description
Description dSourceCode.Description
Vendor
Attributes
Name Source Description
Vendor Number dVendor.No
Vendor Name dVendor.Name
Vendor Number and Name dVendor.NoName
Hierarchies
Vendor Country
Level Name Source Attribute Description
Name Country
Vendor Vendor Name
Vendor Territory
Level Name Source Attribute Description
Name Territory
Vendor Vendor Name

Inventory

Bus Matrix

Company
Customer
Inventory Entry Type
Inventory Posting Group
Item
Location
Posting Period
Source
Vendor
Cost of Sales x x x x x x x x x
Cost posted to G/L x x x x x x x x x
Days to sell Inventory x x x x x x x x x
Days to sell Inventory (Yearly) x x x x x x x x x
Inventory Value Average x x x x x x x x x
Inventory Value Primo x x x x x x x x x
Inventory Value Ultimo x x x x x x x x x
Profit x x x x x x x x x
Profit % x x x x x x x x x
Quantity Changes x x x x x x x
Quantity Decreases x x x x x x x
Quantity in Stock Primo x x x x x x x
Quantity in Stock Ultimo x x x x x x x
Quantity Increases x x x x x x x
Quantity Sold x x x x x x x
Sales x x x x x x x x x
Speed x x x x x x x x x
Value Changes x x x x x x x x x
Value Decreases x x x x x x x x x
Value Increases x x x x x x x x x
Yearly Speed x x x x x x x x x

Measures

Calculations

Value Increases
Expression ([Inventory Main Entry Type].[Main Type].&[1],[Base Value])
Visible to Users True
Value Decreases
Expression ([Inventory Main Entry Type].[Main Type].&[0],[Base Value])*(-1)
Visible to Users True
Value Changes
Expression [Value Increases]-[Value Decreases]
Visible to Users True
Quantity Increases
Expression ([Inventory Main Entry Type].[Main Type].&[1],[Base Quantity])
Visible to Users True
Quantity Decreases
Expression ([Inventory Main Entry Type].[Main Type].&[0],[Base Quantity])*(-1)
Visible to Users True
Quantity Changes
Expression [Quantity Increases]-[Quantity Decreases]
Visible to Users True
Sales
Expression ([Inventory Main Entry Type].[Description].&[1],[Amount])*(-1)
Visible to Users True
Cost of Sales
Expression ([Expected Cost].[Expected Cost].&[0],[Inventory Main Entry Type].[Description].&[1],[Adjusted Cost])*(-1)
Visible to Users True
Quantity Sold
Expression ([Inventory Main Entry Type].[Description].&[1],[Quantity Changes])*(-1)
Visible to Users True
Profit
Expression [Sales]-[Cost of Sales]
Visible to Users True
Profit %
Expression ([Profit]/[Sales])*100
Visible to Users True
Inventory Value Ultimo
Function End Balance
Expression [Value Changes]
Visible to Users True
Inventory Value Primo
Expression [Inventory Value Ultimo]-[Value Changes]
Visible to Users True
Quantity in Stock Ultimo
Function End Balance
Expression [Quantity Changes]
Visible to Users True
Quantity in Stock Primo
Expression [Quantity in Stock Ultimo]-[Quantity Changes]
Visible to Users True
Inventory Value Average
Expression ([Inventory Value Primo]+[Inventory Value Ultimo])/2
Visible to Users True
Speed
Expression [Inventory Value Average]>0, [Cost of Sales]/[Inventory Value Average]
Visible to Users True
Yearly Speed
Expression ([Speed]*365)/[Number of Days]
Visible to Users True
Cost posted to G/L
Expression [Cost Posted to G_L]
Visible to Users True
Days to sell Inventory
Expression 365/[Speed]
Visible to Users True
Days to sell Inventory (Yearly)
Expression 365/[Yearly Speed]
Visible to Users True

Dimensions

Company
Attributes
Name Source Description
Name wdCompany.CompanyName
Customer
Attributes
Name Source Description
Number dCustomer.No
Name dCustomer.Name
Number and Name dCustomer.NoName
Credit Limit dCustomer.wHasCreditLimit
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name Source Attribute Description
Territory Territory
Name Name
Customer Country
Level Name Source Attribute Description
Country Country
Name Name
Inventory Entry Type
Attributes
Name Source Description
Description wdItemEntryType.EntryTypeDescription
Hierarchies
Main Type
Level Name Source Attribute Description
Description wMainType
Type Description
Inventory Posting Group
Attributes
Name Source Description
Description dInventoryPostingGroup.Description
Item
Attributes
Name Source Description
Number dItem.No
Description dItem.Description
Number and Description dItem.NoDescription
Hierarchies
Category
Level Name Source Attribute Description
Description wCategory
Item Description
Product Group
Level Name Source Attribute Description
Description wProductGroup
Item Description
Location
Attributes
Name Source Description
Name dLocation.Name
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week wdPostingPeriod.WeekName
Week Year wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name Source Attribute Description
Year Year
Quarter wYearQuarter
Month wYearMonth
Date Date
Calendar Hierarchy
Level Name Source Attribute Description
Year Calendar Year
Quarter wCalendarYearQuarter
Month wCalendarYearMonth
Date Calendar Date
Week Hierarchy
Level Name Source Attribute Description
Year Week Year
Week wYearWeek
Date Date
Source
Attributes
Name Source Description
Description dSourceCode.Description
Valuation Method
Attributes
Name Source Description
Text wdInventoryValuationMethod.Text
Vendor
Attributes
Name Source Description
Vendor Number dVendor.No
Vendor Name dVendor.Name
Vendor Number and Name dVendor.NoName
Hierarchies
Vendor Country
Level Name Source Attribute Description
Name Country
Vendor Vendor Name
Vendor Territory
Level Name Source Attribute Description
Name Territory
Vendor Vendor Name

Job

Bus Matrix

Bill-to Customer
Business Posting Group
Company
Customer
Invoice Customer
Job
Job Phase
Job Step
Job Task
Posting Period
Product Posting Group
Sales Entity
SalespersonPurchaser
Ship-to Customer
Source
Budgeted Job Cost x x x x x x x x x x
Budgeted Job Price x x x x x x x x x x
Budgeted Job Quantity x x x x x x x x x x
Cost Budget Index x x x x x x x x x x
Cost Budget Variance x x x x x x x x x x
Excess Invoicing x x x x x x x x x x x x x
Excess Invoicing % x x x x x x x x x x x x x
Invoiced Cost x x x x x x x x x x x x x x x
Invoiced Price x x x x x x x x x x x x x x x
Invoiced Quantity x x x x x x x x x x x x x x x
Job Ledger Cost x x x x x x x x x x x x x
Job Ledger Price x x x x x x x x x x x x x
Job Ledger Quantity x x x x x x x x x x x x x
Price Budget Index x x x x x x x x x x
Price Budget Variance x x x x x x x x x x
Profit x x x x x x x x x x x x x
Profit % x x x x x x x x x x x x x
Quantity Budget Index x x x x x x x x x x
Quantity Budget Variance x x x x x x x x x x
Total Cost x x x x x x x x x x x x x
Total Price x x x x x x x x x x x x x
Total Quantity x x x x x x x x x x x x x

Measures

Budgeted Job Quantity
Aggregate function Sum
Source fJobBudgetEntry.Quantity
Visible to Users True
Budgeted Job Cost
Aggregate function Sum
Source fJobBudgetEntry.TotalCost
Visible to Users True
Budgeted Job Price
Aggregate function Sum
Source fJobBudgetEntry.TotalPrice
Visible to Users True
Job Ledger Quantity
Aggregate function Sum
Source fJobLedgerEntry.Quantity
Visible to Users True
Job Ledger Cost
Aggregate function Sum
Source fJobLedgerEntry.TotalCost
Visible to Users True
Job Ledger Price
Aggregate function Sum
Source fJobLedgerEntry.TotalPrice
Visible to Users True

Calculations

Invoiced Price
Expression [Invoice Amount]-[Credit Memo Amount]
Visible to Users True
Invoiced Cost
Expression [Invoice Cost]-[Credit Memo Cost]
Visible to Users True
Invoiced Quantity
Expression [Invoice Quantity]-[Credit Memo Quantity]
Visible to Users True
Total Price
Expression [Invoiced Price]+[Job Ledger Price]
Visible to Users True
Total Cost
Expression [Invoiced Cost]+[Job Ledger Cost]
Visible to Users True
Total Quantity
Expression [Invoiced Quantity]+[Job Ledger Quantity]
Visible to Users True
Excess Invoicing
Expression [Total Price]-[Invoiced Price]
Visible to Users True
Profit
Expression [Invoiced Price]-[Total Cost]
Visible to Users True
Profit %
Expression ([Profit]/[Invoiced Price])*100
Visible to Users True
Excess Invoicing %
Expression ([Invoiced Price]/[Total Price])*100
Visible to Users True
Price Budget Variance
Expression [Invoiced Price]-[Budgeted Job Price]
Visible to Users True
Cost Budget Variance
Expression [Budgeted Job Cost]-[Total Cost]
Visible to Users True
Price Budget Index
Expression ([Invoiced Price]/[Budgeted Job Price])*100
Visible to Users True
Cost Budget Index
Expression ([Budgeted Job Cost]/[Total Cost])*100
Visible to Users True
Quantity Budget Variance
Expression [Budgeted Job Quantity]-[Total Quantity]
Visible to Users True
Quantity Budget Index
Expression iif ([Total Quantity]=0, null, ([Budgeted Job Quantity]/[Total Quantity])*100)
Visible to Users True

Dimensions

Bill-to Customer
Attributes
Name Source Description
Number dCustomer.No
Name dCustomer.Name
Number and Name dCustomer.NoName
Credit Limit dCustomer.wHasCreditLimit
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name Source Attribute Description
Territory Territory
Name Name
Customer Country
Level Name Source Attribute Description
Country Country
Name Name
Business Posting Group
Attributes
Name Source Description
Description dGenBusinessPostingGroup.Description
Company
Attributes
Name Source Description
Name wdCompany.CompanyName
Customer
Attributes
Name Source Description
Number dCustomer.No
Name dCustomer.Name
Number and Name dCustomer.NoName
Credit Limit dCustomer.wHasCreditLimit
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name Source Attribute Description
Territory Territory
Name Name
Customer Country
Level Name Source Attribute Description
Country Country
Name Name
Invoice Customer
Attributes
Name Source Description
Number dCustomer.No
Name dCustomer.Name
Number and Name dCustomer.NoName
Credit Limit dCustomer.wHasCreditLimit
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name Source Attribute Description
Territory Territory
Name Name
Customer Country
Level Name Source Attribute Description
Country Country
Name Name
Job
Attributes
Name Source Description
Job Description dJob.Description
Status wdJobStatus.Text
Job Number dJob.No
Job Number and Description dJob.NumberName
Job Phase
Attributes
Name Source Description
Description dPhase.Description
Job Step
Attributes
Name Source Description
Description dStep.Description
Job Task
Attributes
Name Source Description
Description dTask.Description
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week wdPostingPeriod.WeekName
Week Year wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name Source Attribute Description
Year Year
Quarter wYearQuarter
Month wYearMonth
Date Date
Calendar Hierarchy
Level Name Source Attribute Description
Year Calendar Year
Quarter wCalendarYearQuarter
Month wCalendarYearMonth
Date Calendar Date
Week Hierarchy
Level Name Source Attribute Description
Year Week Year
Week wYearWeek
Date Date
Product Posting Group
Attributes
Name Source Description
Description dGenProductPostingGroup.Description
Sales Credit Memo
Attributes
Name Source Description
Number dSalesCrMemoHeader.No
Sales Entity
Attributes
Name Source Description
Description wdItemResource.Description
Number wdItemResource.No
Number and Description wdItemResource.NoDescription
Hierarchies
Hierarchy
Level Name Source Attribute Description
Sales Entity Sales Entity
Number and Description Number and Description
Sales Invoice
Attributes
Name Source Description
Number dSalesInvoiceHeader.No
SalespersonPurchaser
Attributes
Name Source Description
Name dSalespersonPurchaser.Name
Ship-to Customer
Attributes
Name Source Description
Type wdShiptoType.Text
Name dShiptoAddress.Name
Country dCountry.Name
Code dShiptoAddress.Code
Hierarchies
Country Hierarchy
Level Name Source Attribute Description
Country Country
Name Name
Source
Attributes
Name Source Description
Description dSourceCode.Description

Opportunity Entry

Bus Matrix

Campaign
Campaign Status
Chance of Success
Closed Opportunity Description
Company
Completion
Contact
Opportunity
Opportunity Entry Active
Posting Period
Probability
Sales Cycle
Sales Cycle Stage
SalespersonPurchaser
Calculated Current Value x x x x x x x x x x x x x x
Chance of Success (Avg.) x x x x x x x x x x x x x x
Completion (Avg.) x x x x x x x x x x x x x x
Estimated Value x x x x x x x x x x x x x x
Opportunity Entry Count x x x x x x x x x x x x x x
Probability (Avg.) x x x x x x x x x x x x x x

Measures

Estimated Value
Aggregate function Sum
Source fOpportunityEntry.EstimatedValue_x0028_LCY_x0029_
Visible to Users True
Calculated Current Value
Aggregate function Sum
Source fOpportunityEntry.CalcdCurrentValueLCY
Visible to Users True
Opportunity Entry Count
Aggregate function Sum
Source fOpportunityEntry.wCount
Visible to Users True

Calculations

Chance of Success (Avg.)
Expression [Chances of Success Pct base]/[Opportunity Entry Count]
Visible to Users True
Probability (Avg.)
Expression [Probability Pct base]/[Opportunity Entry Count]
Visible to Users True
Completion (Avg.)
Expression [Probability Pct base]/[Opportunity Entry Count]
Visible to Users True

Dimensions

Campaign
Attributes
Name Source Description
Campaign Description dCampaign.Description
Campaign Status dCampaignStatus.Description
Campaign Number dCampaign.No
Campaign Status
Attributes
Name Source Description
Campaign Description dCampaign.Description
Campaign Status dCampaignStatus.Description
Hierarchies
Hierarchy
Level Name Source Attribute Description
Campaign Status Campaign Status
Campaign Description Campaign Description
Chance of Success
Attributes
Name Source Description
Percentage fOpportunityEntry.ChancesofSuccessPercentage
Closed Opportunity Description
Attributes
Name Source Description
Description dCloseOpportunityCode.Description
Company
Attributes
Name Source Description
Name wdCompany.CompanyName
Completion
Attributes
Name Source Description
Percentage fOpportunityEntry.CompletedPercentage
Contact
Attributes
Name Source Description
Number dContact.No
Name dContact.Name
Number and Name dContact.NoName
Opportunity
Attributes
Name Source Description
Description dOpportunity.Description
Closed wdOpportunityClosed.Text
Priority wdOpportunityPriority.Text
Status wdOpportunityStatus.Text
Opportunity Entry Active
Attributes
Name Source Description
Description wdOpportunityActive.Description
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week wdPostingPeriod.WeekName
Week Year wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name Source Attribute Description
Year Year
Quarter wYearQuarter
Month wYearMonth
Date Date
Calendar Hierarchy
Level Name Source Attribute Description
Year Calendar Year
Quarter wCalendarYearQuarter
Month wCalendarYearMonth
Date Calendar Date
Week Hierarchy
Level Name Source Attribute Description
Year Week Year
Week wYearWeek
Date Date
Probability
Attributes
Name Source Description
Percentage fOpportunityEntry.ProbabilityPercentage
Sales Cycle
Attributes
Name Source Description
Description dSalesCycle.Description
Sales Cycle Stage
Attributes
Name Source Description
Description dSalesCycleStage.Description
SalespersonPurchaser
Attributes
Name Source Description
Name dSalespersonPurchaser.Name

Purchase

Bus Matrix

Business Posting Group
Company
Invoice Vendor
Item
Job
Order Period
Posting Period
Product Posting Group
Purchase Credit Memo
Purchase Entity
Purchase Invoice
Purchase Order
SalespersonPurchaser
Source
Vendor
Average Cost Price x x x x x x x x x x x x
Credit Memo Amount x x x x x x x x x x x x x
Credit Memo Quantity x x x x x x x x x x x x x
Invoice Amount x x x x x x x x x x x x x
Invoice Quantity x x x x x x x x x x x x x
Order Amount x x x x x x x x x x x x
Order Quantity x x x x x x x x x x x x
Outstanding Amount x x x x x x x x x x x x
Outstanding Quantity x x x x x x x x x x x x
Purchase x x x x x x x x x x x x
Quantity x x x x x x x x x x x x
Total Average Cost Price x x x x x x x x x x x
Total Purchase x x x x x x x x x x x
Total Quantity x x x x x x x x x x x

Measures

Credit Memo Quantity
Aggregate function Sum
Source fPurchCrMemoLine.Quantity
Visible to Users True
Credit Memo Amount
Aggregate function Sum
Source fPurchCrMemoLine.wAmountLCY
Visible to Users True
Invoice Quantity
Aggregate function Sum
Source fPurchInvLine.Quantity
Visible to Users True
Invoice Amount
Aggregate function Sum
Source fPurchInvLine.wAmountLCY
Visible to Users True
Order Quantity
Aggregate function Sum
Source fPurchaseLine.Quantity
Visible to Users True
Order Amount
Aggregate function Sum
Source fPurchaseLine.wLineAmountLCY
Visible to Users True
Outstanding Amount
Aggregate function Sum
Source fPurchaseLine.wOutstandingAmountLCY
Visible to Users True
Outstanding Quantity
Aggregate function Sum
Source fPurchaseLine.wOutstandingQuantity
Visible to Users True

Calculations

Purchase
Expression [Invoice Amount]-[Credit Memo Amount]
Visible to Users True
Quantity
Expression [Invoice Quantity]-[Credit Memo Quantity]
Visible to Users True
Average Cost Price
Expression ([Purchase]/[Quantity])
Visible to Users True
Total Purchase
Expression [Purchase] + [Outstanding Amount]
Visible to Users True
Total Quantity
Expression [Quantity] + [Outstanding Quantity]
Visible to Users True
Total Average Cost Price
Expression [Total Purchase]/[Total Quantity]
Visible to Users True

Dimensions

Business Posting Group
Attributes
Name Source Description
Description dGenBusinessPostingGroup.Description
Company
Attributes
Name Source Description
Name wdCompany.CompanyName
Invoice Vendor
Attributes
Name Source Description
Vendor Number dVendor.No
Vendor Name dVendor.Name
Vendor Number and Name dVendor.NoName
Hierarchies
Vendor Country
Level Name Source Attribute Description
Name Country
Vendor Vendor Name
Vendor Territory
Level Name Source Attribute Description
Name Territory
Vendor Vendor Name
Item
Attributes
Name Source Description
Number dItem.No
Description dItem.Description
Number and Description dItem.NoDescription
Hierarchies
Category
Level Name Source Attribute Description
Description wCategory
Item Description
Product Group
Level Name Source Attribute Description
Description wProductGroup
Item Description
Job
Attributes
Name Source Description
Job Description dJob.Description
Status wdJobStatus.Text
Job Number dJob.No
Job Number and Description dJob.NumberName
Order Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week wdPostingPeriod.WeekName
Week Year wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name Source Attribute Description
Year Year
Quarter wYearQuarter
Month wYearMonth
Date Date
Calendar Hierarchy
Level Name Source Attribute Description
Year Calendar Year
Quarter wCalendarYearQuarter
Month wCalendarYearMonth
Date Calendar Date
Week Hierarchy
Level Name Source Attribute Description
Year Week Year
Week wYearWeek
Date Date
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week wdPostingPeriod.WeekName
Week Year wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name Source Attribute Description
Year Year
Quarter wYearQuarter
Month wYearMonth
Date Date
Calendar Hierarchy
Level Name Source Attribute Description
Year Calendar Year
Quarter wCalendarYearQuarter
Month wCalendarYearMonth
Date Calendar Date
Week Hierarchy
Level Name Source Attribute Description
Year Week Year
Week wYearWeek
Date Date
Product Posting Group
Attributes
Name Source Description
Description dGenProductPostingGroup.Description
Purchase Credit Memo
Attributes
Name Source Description
Number dPurchCrMemoHdr.No
Purchase Entity
Attributes
Name Source Description
Number wdItemAsset.No
Description wdItemAsset.Description
Hierarchies
Hierarchy
Level Name Source Attribute Description
Type Type
Description Description
Purchase Invoice
Attributes
Name Source Description
Number dPurchInvHeader.No
Purchase Order
Attributes
Name Source Description
Number dPurchaseHeader.No
SalespersonPurchaser
Attributes
Name Source Description
Name dSalespersonPurchaser.Name
Source
Attributes
Name Source Description
Description dSourceCode.Description
Vendor
Attributes
Name Source Description
Vendor Number dVendor.No
Vendor Name dVendor.Name
Vendor Number and Name dVendor.NoName
Hierarchies
Vendor Country
Level Name Source Attribute Description
Name Country
Vendor Vendor Name
Vendor Territory
Level Name Source Attribute Description
Name Territory
Vendor Vendor Name

Sales

Bus Matrix

Bill-to Customer
Business Posting Group
Company
Customer
Invoice Customer
Item
Job
Order Period
Posting Period
Product Posting Group
Sales Credit Memo
Sales Entity
Sales Invoice
Sales Order
SalespersonPurchaser
Shipment Period
Ship-to Customer
Source
Cost x x x x x x x x x x x x x x x
Credit Memo Amount x x x x x x x x x x x x x x x x
Credit Memo Cost x x x x x x x x x x x x x x x x
Credit Memo Quantity x x x x x x x x x x x x x x x x
Number of Credit Memos x x x x x x x x x x x x x x x x
Number of Invoices x x x x x x x x x x x x x x x x
Number of Open Orders x x x x x x x x x x x x x x x
Order Amount x x x x x x x x x x x x x x x
Order Cost x x x x x x x x x x x x x x x
Order Profit x x x x x x x x x x x x x x x
Order Profit % x x x x x x x x x x x x x x x
Order Quantity x x x x x x x x x x x x x x x
Outstanding Amount x x x x x x x x x x x x x x x
Outstanding Cost x x x x x x x x x x x x x x x
Outstanding Profit x x x x x x x x x x x x x x x
Outstanding Profit % x x x x x x x x x x x x x x x
Outstanding Quantity x x x x x x x x x x x x x x x
Profit x x x x x x x x x x x x x x x
Profit % x x x x x x x x x x x x x x x
Quantity x x x x x x x x x x x x x x x
Sales x x x x x x x x x x x x x x x
Sales Invoice Amount x x x x x x x x x x x x x x x x
Sales Invoice Cost x x x x x x x x x x x x x x x x
Sales Invoice Quantity x x x x x x x x x x x x x x x x
Shipped not Invoiced Amount x x x x x x x x x x x x x x x
Shipped not Invoiced Quantity x x x x x x x x x x x x x x x
Total Cost x x x x x x x x x x x x x x
Total Profit x x x x x x x x x x x x x x
Total Profit % x x x x x x x x x x x x x x
Total Quantity x x x x x x x x x x x x x x
Total Sales x x x x x x x x x x x x x x

Measures

Credit Memo Quantity
Aggregate function Sum
Source fSalesCrMemoLine.Quantity
Visible to Users True
Credit Memo Amount
Aggregate function Sum
Source fSalesCrMemoLine.wAmountLCY
Visible to Users True
Credit Memo Cost
Aggregate function Sum
Source fSalesCrMemoLine.Cost
Visible to Users True
Sales Invoice Quantity
Aggregate function Sum
Source fSalesInvoiceLine.Quantity
Visible to Users True
Sales Invoice Amount
Aggregate function Sum
Source fSalesInvoiceLine.wAmountLCY
Visible to Users True
Sales Invoice Cost
Aggregate function Sum
Source fSalesInvoiceLine.Cost
Visible to Users True
Order Quantity
Aggregate function Sum
Source fSalesLine.Quantity
Visible to Users True
Outstanding Quantity
Aggregate function Sum
Source fSalesLine.wOutstandingQuantity
Visible to Users True
Order Amount
Aggregate function Sum
Source fSalesLine.wLineAmountLCY
Visible to Users True
Order Cost
Aggregate function Sum
Source fSalesLine.wLineCostLCY
Visible to Users True
Outstanding Amount
Aggregate function Sum
Source fSalesLine.wOutstandingAmountLCY
Visible to Users True
Outstanding Cost
Aggregate function Sum
Source fSalesLine.wOutstandingCostLCY
Visible to Users True
Shipped not Invoiced Amount
Aggregate function Sum
Source fSalesLine.wShippedNotInvoicedAmountLCY
Visible to Users True
Shipped not Invoiced Quantity
Aggregate function Sum
Source fSalesLine.QtyShippedNotInvoiced
Visible to Users True
Number of Credit Memos
Aggregate function DistinctCount
Source fSalesCrMemoLine.wCreditMemoCount
Visible to Users True
Number of Invoices
Aggregate function DistinctCount
Source fSalesInvoiceLine.wSalesInvoiceCount
Visible to Users True
Number of Open Orders
Aggregate function DistinctCount
Source fSalesLine.wSalesCount
Visible to Users True

Calculations

Sales
Expression [Sales Invoice Amount]-[Credit Memo Amount]
Visible to Users True
Cost
Expression [Sales Invoice Cost]-[Credit Memo Cost]
Visible to Users True
Quantity
Expression [Sales Invoice Quantity]-[Credit Memo Quantity]
Visible to Users True
Profit
Expression [Sales]-[Cost]
Visible to Users True
Profit %
Expression ([Profit]/[Sales])*100
Visible to Users True
Order Profit
Expression [Order Amount]-[Order Cost]
Visible to Users True
Order Profit %
Expression ([Order Profit]/[Order Amount])*100
Visible to Users True
Outstanding Profit
Expression [Outstanding Amount]-[Outstanding Cost]
Visible to Users True
Outstanding Profit %
Expression ([Outstanding Profit]/[Outstanding Amount])*100
Visible to Users True
Total Sales
Expression [Sales]+[Outstanding Amount]
Visible to Users True
Total Cost
Expression [Cost]+[Outstanding Cost]
Visible to Users True
Total Quantity
Expression [Quantity]+[Outstanding Quantity]
Visible to Users True
Total Profit
Expression [Total Sales]-[Total Cost]
Visible to Users True
Total Profit %
Expression ([Total Profit]/[Total Sales])*100
Visible to Users True

Dimensions

Bill-to Customer
Attributes
Name Source Description
Number dCustomer.No
Name dCustomer.Name
Number and Name dCustomer.NoName
Credit Limit dCustomer.wHasCreditLimit
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name Source Attribute Description
Territory Territory
Name Name
Customer Country
Level Name Source Attribute Description
Country Country
Name Name
Business Posting Group
Attributes
Name Source Description
Description dGenBusinessPostingGroup.Description
Company
Attributes
Name Source Description
Name wdCompany.CompanyName
Customer
Attributes
Name Source Description
Number dCustomer.No
Name dCustomer.Name
Number and Name dCustomer.NoName
Credit Limit dCustomer.wHasCreditLimit
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name Source Attribute Description
Territory Territory
Name Name
Customer Country
Level Name Source Attribute Description
Country Country
Name Name
Invoice Customer
Attributes
Name Source Description
Number dCustomer.No
Name dCustomer.Name
Number and Name dCustomer.NoName
Credit Limit dCustomer.wHasCreditLimit
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name Source Attribute Description
Territory Territory
Name Name
Customer Country
Level Name Source Attribute Description
Country Country
Name Name
Item
Attributes
Name Source Description
Number dItem.No
Description dItem.Description
Number and Description dItem.NoDescription
Hierarchies
Category
Level Name Source Attribute Description
Description wCategory
Item Description
Product Group
Level Name Source Attribute Description
Description wProductGroup
Item Description
Job
Attributes
Name Source Description
Job Description dJob.Description
Status wdJobStatus.Text
Job Number dJob.No
Job Number and Description dJob.NumberName
Order Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week wdPostingPeriod.WeekName
Week Year wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name Source Attribute Description
Year Year
Quarter wYearQuarter
Month wYearMonth
Date Date
Calendar Hierarchy
Level Name Source Attribute Description
Year Calendar Year
Quarter wCalendarYearQuarter
Month wCalendarYearMonth
Date Calendar Date
Week Hierarchy
Level Name Source Attribute Description
Year Week Year
Week wYearWeek
Date Date
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week wdPostingPeriod.WeekName
Week Year wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name Source Attribute Description
Year Year
Quarter wYearQuarter
Month wYearMonth
Date Date
Calendar Hierarchy
Level Name Source Attribute Description
Year Calendar Year
Quarter wCalendarYearQuarter
Month wCalendarYearMonth
Date Calendar Date
Week Hierarchy
Level Name Source Attribute Description
Year Week Year
Week wYearWeek
Date Date
Product Posting Group
Attributes
Name Source Description
Description dGenProductPostingGroup.Description
Sales Credit Memo
Attributes
Name Source Description
Number dSalesCrMemoHeader.No
Sales Entity
Attributes
Name Source Description
Description wdItemResource.Description
Number wdItemResource.No
Number and Description wdItemResource.NoDescription
Hierarchies
Hierarchy
Level Name Source Attribute Description
Sales Entity Sales Entity
Number and Description Number and Description
Sales Invoice
Attributes
Name Source Description
Number dSalesInvoiceHeader.No
Sales Order
Attributes
Name Source Description
Number dSalesHeader.No
SalespersonPurchaser
Attributes
Name Source Description
Name dSalespersonPurchaser.Name
Shipment Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week wdPostingPeriod.WeekName
Week Year wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name Source Attribute Description
Year Year
Quarter wYearQuarter
Month wYearMonth
Date Date
Calendar Hierarchy
Level Name Source Attribute Description
Year Calendar Year
Quarter wCalendarYearQuarter
Month wCalendarYearMonth
Date Calendar Date
Week Hierarchy
Level Name Source Attribute Description
Year Week Year
Week wYearWeek
Date Date
Ship-to Customer
Attributes
Name Source Description
Type wdShiptoType.Text
Name dShiptoAddress.Name
Country dCountry.Name
Code dShiptoAddress.Code
Hierarchies
Country Hierarchy
Level Name Source Attribute Description
Country Country
Name Name
Source
Attributes
Name Source Description
Description dSourceCode.Description

Vendor Ledger

Bus Matrix

Company
Due Period
Posting Period
SalespersonPurchaser
Source
Vendor
Vendor Ledger Entry
Amount x x x x x x x
Amount Credited x x x x x x x
Amount Debited x x x x x x x
Average number of Open Days x x x x x x x
Average number of Overdue Days x x x x x x x
Closed Entry Count x x x x x x x
Overdue Entry Count x x x x x x x
Total number of Open Days x x x x x x x
Total number of Overdue Days x x x x x x x
Vendor Balance x x x x x x x

Measures

Amount
Aggregate function Sum
Source fDetailedVendorLedgEntry.AmountLCY
Visible to Users True
Amount Debited
Aggregate function Sum
Source fDetailedVendorLedgEntry.DebitAmountLCY
Visible to Users True
Amount Credited
Aggregate function Sum
Source fDetailedVendorLedgEntry.CreditAmountLCY
Visible to Users True
Total number of Open Days
Aggregate function Sum
Source fDetailedVendorLedgEntry.wOpenDays
Visible to Users True
Total number of Overdue Days
Aggregate function Sum
Source fDetailedVendorLedgEntry.wOverdueDays
Visible to Users True
Closed Entry Count
Aggregate function Sum
Source fDetailedVendorLedgEntry.wCountClosed
Visible to Users True
Overdue Entry Count
Aggregate function Sum
Source fDetailedVendorLedgEntry.wCountOverdue
Visible to Users True

Calculations

Average number of Open Days
Expression [Total number of Open Days]/[Closed Entry Count]
Visible to Users True
Average number of Overdue Days
Expression [Total number of Overdue Days]/[Overdue Entry Count]
Visible to Users True
Vendor Balance
Function End Balance
Expression [Amount]
Visible to Users True

Dimensions

Company
Attributes
Name Source Description
Name wdCompany.CompanyName
Due Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week wdPostingPeriod.WeekName
Week Year wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name Source Attribute Description
Year Year
Quarter wYearQuarter
Month wYearMonth
Date Date
Calendar Hierarchy
Level Name Source Attribute Description
Year Calendar Year
Quarter wCalendarYearQuarter
Month wCalendarYearMonth
Date Calendar Date
Week Hierarchy
Level Name Source Attribute Description
Year Week Year
Week wYearWeek
Date Date
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week wdPostingPeriod.WeekName
Week Year wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name Source Attribute Description
Year Year
Quarter wYearQuarter
Month wYearMonth
Date Date
Calendar Hierarchy
Level Name Source Attribute Description
Year Calendar Year
Quarter wCalendarYearQuarter
Month wCalendarYearMonth
Date Calendar Date
Week Hierarchy
Level Name Source Attribute Description
Year Week Year
Week wYearWeek
Date Date
SalespersonPurchaser
Attributes
Name Source Description
Name dSalespersonPurchaser.Name
Source
Attributes
Name Source Description
Description dSourceCode.Description
Vendor
Attributes
Name Source Description
Vendor Number dVendor.No
Vendor Name dVendor.Name
Vendor Number and Name dVendor.NoName
Hierarchies
Vendor Country
Level Name Source Attribute Description
Name Country
Vendor Vendor Name
Vendor Territory
Level Name Source Attribute Description
Name Territory
Vendor Vendor Name
Vendor Ledger Entry
Attributes
Name Source Description
Number fVendorLedgerEntry.EntryNo
Description fVendorLedgerEntry.Description
Document Type wdJournalDocumentType.Text
Document Number fVendorLedgerEntry.DocumentNo

Data Transformations

Source Field Name Destination Field Name
Dimension Code DimensionCode
Code Code
Name Name
Dimension Value Type DimensionValueType
Global Dimension No. GlobalDimensionNo
Indentation Indentation
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
Stage Stage
Description Description
Sales Cycle Code SalesCycleCode
Source Field Name Destination Field Name
Code Code
Name Name
Source Field Name Destination Field Name
Code Code
Name Name
Source Field Name Destination Field Name
Name Name
No. No
Territory Code TerritoryCode
Country Code CountryCode
Company No. CompanyNo
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
Description Description
Status Status
Priority Priority
Closed Closed
No. No
Source Field Name Destination Field Name
Description Description
Status Code StatusCode
No. No
Source Field Name Destination Field Name
Code Code
Name Name
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
Name Name
Description Description
Source Field Name Destination Field Name
Name Name
Indentation Indentation
No. No
Account Type AccountType
Income/Balance IncomeBalance
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
No. No
Name Name
Source Field Name Destination Field Name
Name Name
No. No
Territory Code TerritoryCode
Country Code CountryCode
Credit Limit (LCY) CreditLimitLCY
Payment Terms Code PaymentTermsCode
Salesperson Code SalespersonCode
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
Description Description
No. No
Base Unit of Measure BaseUnitOfMeasure
Unit Cost UnitCost
Standard Cost StandardCost
Vendor No. VendorNo
Inventory Posting Group InventoryPostingGroup
Item Category Code ItemCategoryCode
Product Group Code ProductGroupCode
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
Code Code
Name Name
Source Field Name Destination Field Name
Name Name
Territory Code TerritoryCode
Country Code CountryCode
No. No
Source Field Name Destination Field Name
Opportunity No. OpportunityNo
Sales Cycle Code SalesCycleCode
Sales Cycle Stage SalesCycleStage
Contact No. ContactNo
Salesperson Code SalespersonCode
Campaign No. CampaignNo
Date of Change DateofChange
Active Active
Action Taken ActionTaken
Estimated Value (LCY) EstimatedValue(LCY)
Calcd. Current Value (LCY) CalcdCurrentValueLCY
Completed % CompletedPct
Chances of Success % ChancesofSuccessPct
Probability % ProbabilityPct
Close Opportunity Code CloseOpportunityCode
Previous Sales Cycle Stage PreviousSalesCycleStage
Estimated Close Date EstimatedCloseDate
Source Field Name Destination Field Name
G/L Account No. GLAccountNo
Posting Date PostingDate
Document Type DocumentType
Document No. DocumentNo
Description Description
Amount Amount
Source Code SourceCode
Job No. JobNo
Gen. Bus. Posting Group GenBusPostingGroup
Gen. Prod. Posting Group GenProdPostingGroup
Debit Amount DebitAmount
Credit Amount CreditAmount
Entry No. EntryNo
Source Type SourceType
Source No. SourceNo
Source Field Name Destination Field Name
Budget Name BudgetName
G/L Account No. GLAccountNo
Date Date
Amount Amount
Description Description
Entry No. EntryNo
Source Field Name Destination Field Name
Document No. DocumentNo
Type Type
No. No
Quantity Quantity
Amount Amount
Amount Including VAT AmountIncludingVAT
Inv. Discount Amount InvDiscountAmount
Gen. Bus. Posting Group GenBusPostingGroup
Gen. Prod. Posting Group GenProdPostingGroup
Unit Cost UnitCost
Line No. LineNo
Job No. JobNo
Phase Code PhaseCode
Task Code TaskCode
Step Code StepCode
Unit Cost (LCY) UnitCostLCY
Sell-to Customer No. SellToCustomerNo
Bill-to Customer No. BillToCustomerNo
Shipment Date ShipmentDate
Line Amount LineAmount
VAT % VatPct
Source Field Name Destination Field Name
No. No
Posting Date PostingDate
Currency Code CurrencyCode
Salesperson Code SalespersonCode
Currency Factor CurrencyFactor
Sell-to Customer No. SellToCustomerNo
Source Code SourceCode
Bill-to Customer No. BillToCustomerNo
Ship-to Code ShipToCode
Shipment Date ShipmentDate
Prices Including VAT PricesIncludingVAT
Source Field Name Destination Field Name
Entry No. EntryNo
Customer No. CustomerNo
Posting Date PostingDate
Currency Code CurrencyCode
Sales (LCY) SalesLCY
Salesperson Code SalespersonCode
Source Code SourceCode
Open Open
Due Date DueDate
Closed at Date ClosedAtDate
Description Description
Document Type DocumentType
Document No. DocumentNo
Source Field Name Destination Field Name
Document No. DocumentNo
Type Type
No. No
Quantity Quantity
Amount Amount
Amount Including VAT AmountIncludingVAT
Inv. Discount Amount InvDiscountAmount
Gen. Bus. Posting Group GenBusPostingGroup
Gen. Prod. Posting Group GenProdPostingGroup
Unit Cost UnitCost
Line No. LineNo
Job No. JobNo
Phase Code PhaseCode
Task Code TaskCode
Step Code StepCode
Unit Cost (LCY) UnitCostLCY
Sell-to Customer No. SellToCustomerNo
Bill-to Customer No. BillToCustomerNo
Shipment Date ShipmentDate
Line Amount LineAmount
VAT % VatPct
Source Field Name Destination Field Name
No. No
Posting Date PostingDate
Currency Code CurrencyCode
Salesperson Code SalespersonCode
Currency Factor CurrencyFactor
Sell-to Customer No. SellToCustomerNo
Source Code SourceCode
Bill-to Customer No. BillToCustomerNo
Ship-to Code ShipToCode
Shipment Date ShipmentDate
Order Date OrderDate
Prices Including VAT PricesIncludingVAT
Source Field Name Destination Field Name
Item No. ItemNo
Posting Date PostingDate
Entry Type EntryType
Source No. SourceNo
Location Code LocationCode
Quantity Quantity
Transaction Type TransactionType
Document Date DocumentDate
Last Invoice Date LastInvoiceDate
Entry No. EntryNo
Open Open
Invoiced Quantity InvoicedQuantity
Source Type SourceType
Positive Positive
Source Field Name Destination Field Name
Dimension Code DimensionCode
Table ID TableID
Entry No. EntryNo
Dimension Value Code DimensionValueCode
Source Field Name Destination Field Name
Dimension Code DimensionCode
Document No. DocumentNo
Line No. LineNo
Dimension Value Code DimensionValueCode
Table ID TableID
Source Field Name Destination Field Name
Entry No. EntryNo
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Source Field Name Destination Field Name
Entry No. EntryNo
Cust. Ledger Entry No. CustLedgerEntryNo
Entry Type EntryType
Posting Date PostingDate
Document Type DocumentType
Document No. DocumentNo
Amount Amount
Amount (LCY) AmountLCY
Customer No. CustomerNo
Currency Code CurrencyCode
Source Code SourceCode
Debit Amount DebitAmount
Credit Amount CreditAmount
Debit Amount (LCY) DebitAmountLCY
Credit Amount (LCY) CreditAmountLCY
Initial Entry Due Date InitialEntryDueDate
Source Field Name Destination Field Name
Entry No. EntryNo
Job Status JobStatus
Job No. JobNo
Type Type
No. No
Phase Code PhaseCode
Task Code TaskCode
Step Code StepCode
Date Date
Resource Group No. ResourceGroupNo
Quantity Quantity
Total Cost TotalCost
Total Price TotalPrice
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
No. No
Name Name
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
Entry No. EntryNo
Job No. JobNo
Posting Date PostingDate
Document No. DocumentNo
Type Type
No. No
Description Description
Quantity Quantity
Direct Unit Cost DirectUnitCost
Unit Cost UnitCost
Total Cost TotalCost
Unit Price UnitPrice
Total Price TotalPrice
Resource Group No. ResourceGroupNo
Unit of Measure Code UnitofMeasureCode
Location Code LocationCode
Work Type Code WorkTypeCode
Source Code SourceCode
Phase Code PhaseCode
Task Code TaskCode
Step Code StepCode
Amt. to Post to G/L AmttoPosttoGL
Amt. Posted to G/L AmtPostedtoGL
Amt. to Recognize AmttoRecognize
Amt. Recognized AmtRecognized
Entry Type EntryType
Open Open
Remaining Amount RemainingAmount
Area Area
Gen. Bus. Posting Group GenBusPostingGroup
Gen. Prod. Posting Group GenProdPostingGroup
Source Field Name Destination Field Name
No. No
Description Description
Creation Date CreationDate
Starting Date StartingDate
Ending Date EndingDate
Completion Date CompletionDate
Job Posting Date JobPostingDate
Completion % CompletionPct
Status Status
Person Responsible PersonResponsible
Bill-to Customer No. BilltoCustomerNo
Source Field Name Destination Field Name
Document No. DocumentNo
Line No. LineNo
Buy-from Vendor No. BuyfromVendorNo
Type Type
No. No
Location Code LocationCode
Quantity Quantity
Direct Unit Cost DirectUnitCost
Unit Cost (LCY) UnitCostLCY
Line Discount Amount LineDiscountAmount
Unit Price (LCY) UnitPriceLCY
Job No. JobNo
Phase Code PhaseCode
Task Code TaskCode
Step Code StepCode
Gen. Bus. Posting Group GenBusPostingGroup
Gen. Prod. Posting Group GenProdPostingGroup
Amount Amount
Inv. Discount Amount InvDiscountAmount
Line Amount LineAmount
VAT % VatPct
Source Field Name Destination Field Name
No. No
Description Description
Source Field Name Destination Field Name
No. No
Buy-from Vendor No. BuyfromVendorNo
Pay-to Vendor No. PaytoVendorNo
Posting Date PostingDate
Currency Factor CurrencyFactor
Job No. JobNo
Purchaser Code PurchaserCode
Source Code SourceCode
Ship-to Code ShipToCode
Prices Including VAT PricesIncludingVAT
Source Field Name Destination Field Name
Type Type
Document No. DocumentNo
Line No. LineNo
Buy-from Vendor No. BuyfromVendorNo
No. No
Location Code LocationCode
Posting Group PostingGroup
Quantity Quantity
Direct Unit Cost DirectUnitCost
Unit Cost (LCY) UnitCostLCY
Line Discount Amount LineDiscountAmount
Amount Amount
Unit Price (LCY) UnitPriceLCY
Job No. JobNo
Phase Code PhaseCode
Task Code TaskCode
Step Code StepCode
Gen. Bus. Posting Group GenBusPostingGroup
Gen. Prod. Posting Group GenProdPostingGroup
Inv. Discount Amount InvDiscountAmount
Line Amount LineAmount
VAT % VatPct
Source Field Name Destination Field Name
No. No
Buy-from Vendor No. BuyfromVendorNo
Pay-to Vendor No. PaytoVendorNo
Posting Date PostingDate
Job No. JobNo
Purchaser Code PurchaserCode
Currency Factor CurrencyFactor
Source Code SourceCode
Ship-to Code ShipToCode
Prices Including VAT PricesIncludingVAT
Order Date OrderDate
Source Field Name Destination Field Name
Entry No. EntryNo
Vendor No. VendorNo
Posting Date PostingDate
Purchase (LCY) PurchaseLCY
Inv. Discount (LCY) InvDiscountLCY
Purchaser Code PurchaserCode
Due Date DueDate
Open Open
Closed at Date ClosedAtDate
Source Code SourceCode
Description Description
Document Type DocumentType
Document No. DocumentNo
Source Field Name Destination Field Name
Amount Amount
Entry No. EntryNo
Vendor Ledger Entry No. VendorLedgerEntryNo
Entry Type EntryType
Document Type DocumentType
Document No. DocumentNo
Amount (LCY) AmountLCY
Vendor No. VendorNo
Source Code SourceCode
Debit Amount (LCY) DebitAmountLCY
Credit Amount (LCY) CreditAmountLCY
Posting Date PostingDate
Source Field Name Destination Field Name
Entry No. EntryNo
Item No. ItemNo
Posting Date PostingDate
Item Ledger Entry Type ItemLedgerEntryType
Document No. DocumentNo
Description Description
Location Code LocationCode
Inventory Posting Group InventoryPostingGroup
Item Ledger Entry No. ItemLedgerEntryNo
Valued Quantity ValuedQuantity
Invoiced Quantity InvoicedQuantity
Cost per Unit CostperUnit
Amount Amount
Salespers./Purch. Code SalespersPurchCode
Discount Amount DiscountAmount
Source Code SourceCode
Adjusted Cost AdjustedCost
Cost Posted to G/L CostPostedtoGL
Entry Type EntryType
Gen. Bus. Posting Group GenBusPostingGroup
Gen. Prod. Posting Group GenProdPostingGroup
Expected Cost ExpectedCost
Source No. SourceNo
Source Type SourceType
Source Field Name Destination Field Name
Dimension Code DimensionCode
Table ID TableID
Entry No. EntryNo
Dimension Value Code DimensionValueCode
Source Field Name Destination Field Name
Dimension Code DimensionCode
Table ID TableID
Entry No. EntryNo
Dimension Value Code DimensionValueCode
Source Field Name Destination Field Name
Dimension Code DimensionCode
Table ID TableID
Entry No. EntryNo
Dimension Value Code DimensionValueCode
Source Field Name Destination Field Name
Dimension Code DimensionCode
Table ID TableID
Entry No. EntryNo
Dimension Value Code DimensionValueCode
Source Field Name Destination Field Name
Dimension Code DimensionCode
Table ID TableID
Entry No. EntryNo
Dimension Value Code DimensionValueCode
Source Field Name Destination Field Name
Dimension Code DimensionCode
Document No. DocumentNo
Line No. LineNo
Dimension Value Code DimensionValueCode
Table ID TableID
Source Field Name Destination Field Name
Dimension Code DimensionCode
Document No. DocumentNo
Line No. LineNo
Dimension Value Code DimensionValueCode
Table ID TableID
Source Field Name Destination Field Name
Dimension Code DimensionCode
Document No. DocumentNo
Line No. LineNo
Dimension Value Code DimensionValueCode
Table ID TableID
Source Field Name Destination Field Name
No. No
Description Description
Source Field Name Destination Field Name
Table ID TableID
No. No
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Source Field Name Destination Field Name
Code Code
Country Code CountryCode
Customer No. CustomerNo
Name Name
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
Item Category Code ItemCategoryCode
Code Code
Description Description
Source Field Name Destination Field Name
Table ID TableID
Document Type DocumentType
Document No. DocumentNo
Line No. LineNo
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Source Field Name Destination Field Name
Document Type DocumentType
Document No. DocumentNo
Line No. LineNo
Sell-to Customer No. SelltoCustomerNo
Type Type
No. No
Location Code LocationCode
Shipment Date ShipmentDate
Description Description
Unit of Measure UnitofMeasure
Quantity Quantity
Outstanding Quantity OutstandingQuantity
Qty. to Invoice QtytoInvoice
Qty. to Ship QtytoShip
Unit Price UnitPrice
Unit Cost (LCY) UnitCostLCY
Line Discount % LineDiscountPct
Line Discount Amount LineDiscountAmount
Amount Amount
Amount Including VAT AmountIncludingVAT
Shortcut Dimension 1 Code ShortcutDimension1Code
Shortcut Dimension 2 Code ShortcutDimension2Code
Job No. JobNo
Outstanding Amount OutstandingAmount
Qty. Shipped Not Invoiced QtyShippedNotInvoiced
Shipped Not Invoiced ShippedNotInvoiced
Quantity Shipped QuantityShipped
Quantity Invoiced QuantityInvoiced
Bill-to Customer No. BilltoCustomerNo
Inv. Discount Amount InvDiscountAmount
Gen. Bus. Posting Group GenBusPostingGroup
Gen. Prod. Posting Group GenProdPostingGroup
Transaction Type TransactionType
Currency Code CurrencyCode
Outstanding Amount (LCY) OutstandingAmountLCY
Shipped Not Invoiced (LCY) ShippedNotInvoicedLCY
Reserve Reserve
Unit Cost UnitCost
Line Amount LineAmount
Inv. Disc. Amount to Invoice InvDiscAmounttoInvoice
Qty. per Unit of Measure QtyperUnitofMeasure
Planned Planned
Unit of Measure Code UnitofMeasureCode
Quantity (Base) QuantityBase
Outstanding Qty. (Base) OutstandingQtyBase
Qty. to Invoice (Base) QtytoInvoiceBase
Qty. to Ship (Base) QtytoShipBase
Qty. Shipped Not Invd. (Base) QtyShippedNotInvdBase
Qty. Shipped (Base) QtyShippedBase
Qty. Invoiced (Base) QtyInvoicedBase
Item Category Code ItemCategoryCode
Product Group Code ProductGroupCode
Planned Delivery Date PlannedDeliveryDate
Planned Shipment Date PlannedShipmentDate
VAT % VATPct
Phase Code PhaseCode
Step Code StepCode
Task Code TaskCode
Source Field Name Destination Field Name
Document Type DocumentType
No. No
Sell-to Customer No. SelltoCustomerNo
Bill-to Customer No. BilltoCustomerNo
Ship-to Code ShiptoCode
Order Date OrderDate
Posting Date PostingDate
Shipment Date ShipmentDate
Location Code LocationCode
Shortcut Dimension 1 Code ShortcutDimension1Code
Shortcut Dimension 2 Code ShortcutDimension2Code
Currency Code CurrencyCode
Currency Factor CurrencyFactor
Salesperson Code SalespersonCode
Ship Ship
Invoice Invoice
Gen. Bus. Posting Group GenBusPostingGroup
Document Date DocumentDate
Reserve Reserve
Status Status
Campaign No. CampaignNo
Prices Including VAT PricesIncludingVAT
Source Field Name Destination Field Name
No. No
Document No. DocumentNo
Line No. LineNo
Buy-from Vendor No. BuyfromVendorNo
Type Type
Location Code LocationCode
Posting Group PostingGroup
Quantity Quantity
Direct Unit Cost DirectUnitCost
Unit Cost (LCY) UnitCostLCY
Line Discount Amount LineDiscountAmount
Amount Amount
Unit Price (LCY) UnitPriceLCY
Job No. JobNo
Gen. Bus. Posting Group GenBusPostingGroup
Gen. Prod. Posting Group GenProdPostingGroup
Line Amount LineAmount
Line Discount % LineDiscountPct
VAT % VATPct
Inv. Discount Amount InvDiscountAmount
Document Type DocumentType
Quantity Invoiced QuantityInvoiced
Step Code StepCode
Task Code TaskCode
Phase Code PhaseCode
Source Field Name Destination Field Name
No. No
Buy-from Vendor No. BuyfromVendorNo
Pay-to Vendor No. PaytoVendorNo
Posting Date PostingDate
Purchaser Code PurchaserCode
Currency Factor CurrencyFactor
Ship-to Code ShiptoCode
Prices Including VAT PricesIncludingVAT
Order Date OrderDate
Document Type DocumentType
Source Field Name Destination Field Name
Table ID TableID
Document Type DocumentType
Document No. DocumentNo
Line No. LineNo
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Source Field Name Destination Field Name
Code Code
Description Description