Microsoft Dynamics NAV 2018

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
Total Number of Open Days x x x x x x x x x
Total Number of Overdue Days x x x x x x x x x
Turnover Ratio x x x x x x x x x

Measures

Credit Limit
Aggregate function Sum
Source dCustomer.CreditLimitLCY
Visible to Users True
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
Total 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
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

Customer Balance
Function End Balance
Expression [Amount]
Visible to Users True
Limited Customer Balance
Expression ([Credit Limit Type].[LimitID].&[1],[Customer Balance])
Visible to Users True
Credit Limit Utilization
Expression ([Limited Customer Balance]/[Credit Limit])*100
Visible to Users True
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
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
Limit dCustomer.wHasCreditLimit
Customer
Attributes
Name Source Description
Number dCustomer.No
Number and Name dCustomer.NumberName
Name dCustomer.Name
Credit Limit Type dCustomer.wHasCreditLimitID
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Country
Level Name Source Attribute Description
Country Country
Number and Name Number and Name
Customer Territory
Level Name Source Attribute Description
Territory Territory
Number and Name Number and 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
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Month wdPostingPeriod.MonthName
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
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Month wdPostingPeriod.MonthName
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

Budget Amount
Aggregate function Sum
Source fGLBudgetEntry.Amount
Visible to Users True
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

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.wParentNo
Account Number dGLAccount.No
Account Name dGLAccount.Name
Account Number and Name dGLAccount.NumberName
IncomeBalance dGLAccount.wAccountGroup
CompanyAccount dGLAccount.CompanyNumberName
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
Number and Name dCustomer.NumberName
Name dCustomer.Name
Credit Limit Type dCustomer.wHasCreditLimitID
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Country
Level Name Source Attribute Description
Country Country
Number and Name Number and Name
Customer Territory
Level Name Source Attribute Description
Territory Territory
Number and Name Number and 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
Job Number dJob.No
Job Number and Description dJob.NumberName
Status wdJobStatus.Text
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Month wdPostingPeriod.MonthName
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 Number and Name
Vendor Territory
Level Name Source Attribute Description
Name Territory
Vendor Vendor Number and 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
Number of Days 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 x
Quantity Decreases x x x x x x x x
Quantity in Stock Primo x x x x x x x x
Quantity in Stock Ultimo x x x x x x x x
Quantity Increases x x x x x x x x
Quantity Sold x 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

Cost Posted to G_L
Aggregate function Sum
Source fValueEntry.CostPostedtoGL
Visible to Users True
Number of Days
Aggregate function Count
Source wdPostingPeriod.DateNumber
Visible to Users True

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 [Sales Amount]
Visible to Users True
Cost of Sales
Expression ([Inventory Main Entry Type].[Description].&[1],[Cost Amount])*(-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
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
Number and Name dCustomer.NumberName
Name dCustomer.Name
Credit Limit Type dCustomer.wHasCreditLimitID
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Country
Level Name Source Attribute Description
Country Country
Number and Name Number and Name
Customer Territory
Level Name Source Attribute Description
Territory Territory
Number and Name Number and 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.NumberDescription
Hierarchies
Item Category
Level Name Source Attribute Description
Description wItemCategory
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
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Month wdPostingPeriod.MonthName
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 Number and Name
Vendor Territory
Level Name Source Attribute Description
Name Territory
Vendor Vendor Number and Name

Job

Bus Matrix

Bill-to Customer
Business Posting Group
Company
Customer
Job
Job Task
Posting Period
Product Posting Group
Sales Entity
SalespersonPurchaser
Ship-to Customer
Source
Cost Planning Index x x x x x x x x x
Cost Planning Variance x x x x x x x x x
Excess Invoicing x x x x x x x x x x
Excess Invoicing % x x x x x x x x x x
Invoiced Cost 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
Invoiced Quantity x x x x x x x x x x x x
Planned Amount x x x x x x x x x
Planned Cost x x x x x x x x x
Planned Price x x x x x x x x x
Planned Quantity x x x x x x x x x
Planning Invoiced Amount x x x x x x x x x
Planning Invoiced Cost x x x x x x x x x
Price Planning Index x x x x x x x x x
Price Planning Variance x x x x x x x x x
Profit x x x x x x x x x x
Profit % x x x x x x x x x x
Quantity Planning Index x x x x x x x x x
Quantity Planning Variance x x x x x x x x x
Total Cost x x x x x x x x x x
Total Price x x x x x x x x x x
Total Quantity x x x x x x x x x x

Measures

Planned Quantity
Aggregate function Sum
Source fJobPlanningLine.Quantity
Visible to Users True
Planned Cost
Aggregate function Sum
Source fJobPlanningLine.TotalCostLCY
Visible to Users True
Planned Price
Aggregate function Sum
Source fJobPlanningLine.TotalPriceLCY
Visible to Users True
Planned Amount
Aggregate function Sum
Source fJobPlanningLine.LineAmountLCY
Visible to Users True
Planning Invoiced Amount
Aggregate function Sum
Source fJobPlanningLine.wInvoicedAmountLCY
Visible to Users True
Planning Invoiced Cost
Aggregate function Sum
Source fJobPlanningLine.wInvoicedCostAmountLCY
Visible to Users True

Calculations

Invoiced Price
Expression [Sales Invoice Amount]-[Credit Memo Amount]
Visible to Users True
Invoiced Cost
Expression [Sales Invoice Cost]-[Credit Memo Cost]
Visible to Users True
Invoiced Quantity
Expression [Sales Invoice Quantity]-[Credit Memo Quantity]
Visible to Users True
Total Price
Expression [Invoiced Price]+[Job Ledger Price]
Visible to Users True
Total Quantity
Expression [Invoiced Quantity]+[Job Ledger Quantity]
Visible to Users True
Total Cost
Expression [Invoiced Cost]+[Job Ledger Cost]
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 iif ([Invoiced Price]=0, null, ([Profit]/[Invoiced Price])*100)
Visible to Users True
Excess Invoicing %
Expression iif ([Total Price]=0, null, ([Invoiced Price]/[Total Price])*100)
Visible to Users True
Price Planning Variance
Expression [Invoiced Price]-[Planned Price]
Visible to Users True
Price Planning Index
Expression iif ([Planned Price]=0, null, ([Invoiced Price]/[Planned Price])*100)
Visible to Users True
Cost Planning Variance
Expression [Planned Cost]-[Total Cost]
Visible to Users True
Cost Planning Index
Expression iif ([Total Cost]=0, null, ([Planned Cost]/[Total Cost])*100)
Visible to Users True
Quantity Planning Variance
Expression [Planned Quantity]-[Total Quantity]
Visible to Users True
Quantity Planning Index
Expression iif ([Total Quantity]=0, null, ([Planned Quantity]/[Total Quantity])*100)
Visible to Users True

Dimensions

Bill-to Customer
Attributes
Name Source Description
Number dCustomer.No
Number and Name dCustomer.NumberName
Name dCustomer.Name
Credit Limit Type dCustomer.wHasCreditLimitID
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Country
Level Name Source Attribute Description
Country Country
Number and Name Number and Name
Customer Territory
Level Name Source Attribute Description
Territory Territory
Number and Name Number and 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
Number and Name dCustomer.NumberName
Name dCustomer.Name
Credit Limit Type dCustomer.wHasCreditLimitID
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Country
Level Name Source Attribute Description
Country Country
Number and Name Number and Name
Customer Territory
Level Name Source Attribute Description
Territory Territory
Number and Name Number and Name
Job
Attributes
Name Source Description
Job Description dJob.Description
Job Number dJob.No
Job Number and Description dJob.NumberName
Status wdJobStatus.Text
Job Task
Attributes
Name Source Description
Description dJobTask.Description
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Month wdPostingPeriod.MonthName
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
Number and Description wdItemResource.NoDescription
Number wdItemResource.No
Description wdItemResource.Description
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
Code dShiptoAddress.Code
Type wdShiptoType.Text
Country dCountryRegion.Name
Name dShiptoAddress.Name
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 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 [wChanceOfSuccess]/[Opportunity Entry Count]
Visible to Users True
Probability (Avg.)
Expression [wProbabilityPct]/[Opportunity Entry Count]
Visible to Users True
Completion (Avg.)
Expression [wCompletedPct]/[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
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 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.NumberName
Opportunity
Attributes
Name Source Description
Description dOpportunity.Description
Status wdOpportunityStatus.Text
Priority wdOpportunityPriority.Text
Closed wdOpportunityClosed.Text
Opportunity Entry Active
Attributes
Name Source Description
Description wdOpportunityActive.Description
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Month wdPostingPeriod.MonthName
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
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
Purchase Credit Memo Amount x x x x x x x x x x x x
Purchase Credit Memo Quantity x x x x x x x x x x x x
Purchase Invoice Amount x x x x x x x x x x x x
Purchase Invoice Quantity x x x x x x x x x x x x
Quantity 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
Total Purchase x x x x x x x x x x
Total Quantity x x x x x x x x x x

Measures

Purchase Credit Memo Quantity
Aggregate function Sum
Source fPurchCrMemoLine.Quantity
Visible to Users True
Purchase Credit Memo Amount
Aggregate function Sum
Source fPurchCrMemoLine.wAmountLCY
Visible to Users True
Purchase Invoice Quantity
Aggregate function Sum
Source fPurchInvLine.Quantity
Visible to Users True
Purchase Invoice Amount
Aggregate function Sum
Source fPurchInvLine.wAmountLCY
Visible to Users True
Order Amount
Aggregate function Sum
Source fPurchaseLine.wLineAmountLCY
Visible to Users True
Order Quantity
Aggregate function Sum
Source fPurchaseLine.Quantity
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 [Purchase Invoice Amount]-[Purchase Credit Memo Amount]
Visible to Users True
Quantity
Expression [Purchase Invoice Quantity]-[Purchase 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 Number and Name
Vendor Territory
Level Name Source Attribute Description
Name Territory
Vendor Vendor Number and Name
Item
Attributes
Name Source Description
Number dItem.No
Description dItem.Description
Number and Description dItem.NumberDescription
Hierarchies
Item Category
Level Name Source Attribute Description
Description wItemCategory
Item Description
Product Group
Level Name Source Attribute Description
Description wProductGroup
Item Description
Job
Attributes
Name Source Description
Job Description dJob.Description
Job Number dJob.No
Job Number and Description dJob.NumberName
Status wdJobStatus.Text
Order Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Month wdPostingPeriod.MonthName
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
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Month wdPostingPeriod.MonthName
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
Number and Description wdItemAsset.NumberDescription
Hierarchies
Hierarchy
Level Name Source Attribute Description
Purchase Entity Purchase Entity
Number and Description Number and 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 Number and Name
Vendor Territory
Level Name Source Attribute Description
Name Territory
Vendor Vendor Number and Name

Sales

Bus Matrix

Bill-to Customer
Business Posting Group
Company
Customer
Invoice Customer
Item
Job
Job Task
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 x
Credit Memo Amount x 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 x
Credit Memo Quantity x x x x x x x x x x x x x x x x x
Days Since Last Invoice x 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 x
Number of Invoices x 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 x
Order Amount x 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 x
Order Profit x 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 x
Order Quantity x 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 x
Outstanding Cost x 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 x
Outstanding Profit % x 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 x
Profit x 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 x
Quantity x 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 x
Sales Invoice Amount x 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 x
Sales Invoice Quantity x 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 x
Shipped not Invoiced Quantity x 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 x
Total Profit x 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 x
Total Quantity x 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 x

Measures

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.LineCost
Visible to Users True
Days Since Last Invoice
Aggregate function Min
Source fSalesInvoiceLine.wDaysSincePosting
Visible to Users True
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.LineCost
Visible to Users True
Outstanding Quantity
Aggregate function Sum
Source fSalesLine.wOutstandingQuantity
Visible to Users True
Outstanding Amount
Aggregate function Sum
Source fSalesLine.wOutstandingAmountLCY
Visible to Users True
Order Quantity
Aggregate function Sum
Source fSalesLine.Quantity
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 Cost
Aggregate function Sum
Source fSalesLine.wOutstandingCostLCY
Visible to Users True
Shipped not Invoiced Quantity
Aggregate function Sum
Source fSalesLine.QtyShippedNotInvoiced
Visible to Users True
Shipped Not Invoiced Amount
Aggregate function Sum
Source fSalesLine.wShippedNotInvoicedAmountLCY
Visible to Users True
Number of Invoices
Aggregate function DistinctCount
Source fSalesInvoiceLine.wSalesInvoiceCount
Visible to Users True
Number of Credit Memos
Aggregate function DistinctCount
Source fSalesCrMemoLine.wSalesCrMemoCount
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
Number and Name dCustomer.NumberName
Name dCustomer.Name
Credit Limit Type dCustomer.wHasCreditLimitID
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Country
Level Name Source Attribute Description
Country Country
Number and Name Number and Name
Customer Territory
Level Name Source Attribute Description
Territory Territory
Number and Name Number and 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
Number and Name dCustomer.NumberName
Name dCustomer.Name
Credit Limit Type dCustomer.wHasCreditLimitID
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Country
Level Name Source Attribute Description
Country Country
Number and Name Number and Name
Customer Territory
Level Name Source Attribute Description
Territory Territory
Number and Name Number and Name
Invoice Customer
Attributes
Name Source Description
Number dCustomer.No
Number and Name dCustomer.NumberName
Name dCustomer.Name
Credit Limit Type dCustomer.wHasCreditLimitID
Payment Terms dPaymentTerms.Description
Hierarchies
Customer Country
Level Name Source Attribute Description
Country Country
Number and Name Number and Name
Customer Territory
Level Name Source Attribute Description
Territory Territory
Number and Name Number and Name
Item
Attributes
Name Source Description
Number dItem.No
Description dItem.Description
Number and Description dItem.NumberDescription
Hierarchies
Item Category
Level Name Source Attribute Description
Description wItemCategory
Item Description
Product Group
Level Name Source Attribute Description
Description wProductGroup
Item Description
Job
Attributes
Name Source Description
Job Description dJob.Description
Job Number dJob.No
Job Number and Description dJob.NumberName
Status wdJobStatus.Text
Job Task
Attributes
Name Source Description
Description dJobTask.Description
Order Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Month wdPostingPeriod.MonthName
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
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Month wdPostingPeriod.MonthName
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
Number and Description wdItemResource.NoDescription
Number wdItemResource.No
Description wdItemResource.Description
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
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Month wdPostingPeriod.MonthName
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
Code dShiptoAddress.Code
Type wdShiptoType.Text
Country dCountryRegion.Name
Name dShiptoAddress.Name
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

Vendor Balance
Function End Balance
Expression [Amount]
Visible to Users True
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

Dimensions

Company
Attributes
Name Source Description
Name wdCompany.CompanyName
Due Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Month wdPostingPeriod.MonthName
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
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Month wdPostingPeriod.MonthName
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 Number and Name
Vendor Territory
Level Name Source Attribute Description
Name Territory
Vendor Vendor Number and 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
Totaling Totaling
Dimension Value ID DimensionValueID
Dimension Code DimensionCode
Code Code
Name Name
Dimension Value Type DimensionValueType
Indentation Indentation
Global Dimension No_ GlobalDimensionNo
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
Description Description
Stage Stage
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
Territory Code TerritoryCode
Name Name
No_ No
Country_Region Code CountryRegionCode
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
Account Type AccountType
Indentation Indentation
No_ No
Income_Balance IncomeBalance
Source Field Name Destination Field Name
Name Name
No_ No
Source Field Name Destination Field Name
Name Name
Territory Code TerritoryCode
Credit Limit (LCY) CreditLimitLCY
No_ No
Country_Region Code CountryRegionCode
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
Base Unit of Measure BaseUnitOfMeasure
Inventory Posting Group InventoryPostingGroup
Unit Cost UnitCost
Standard Cost StandardCost
Product Group Code ProductGroupCode
No_ No
Vendor No_ VendorNo
Item Category Code ItemCategoryCode
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
Name Name
Code Code
Source Field Name Destination Field Name
Name Name
Territory Code TerritoryCode
Country_Region Code CountryRegionCode
No_ No
Source Field Name Destination Field Name
Sales Cycle Code SalesCycleCode
Sales Cycle Stage SalesCycleStage
Salesperson Code SalespersonCode
Date of Change DateofChange
Active Active
Action Taken ActionTaken
Estimated Value (LCY) EstimatedValue(LCY)
Completed _ CompletedPct
Chances of Success _ ChancesofSuccessPct
Probability _ ProbabilityPct
Close Opportunity Code CloseOpportunityCode
Previous Sales Cycle Stage PreviousSalesCycleStage
Estimated Close Date EstimatedCloseDate
Opportunity No_ OpportunityNo
Contact No_ ContactNo
Campaign No_ CampaignNo
Calcd_ Current Value (LCY) CalcdCurrentValueLCY
Source Field Name Destination Field Name
Posting Date PostingDate
Document Type DocumentType
Amount Amount
Source Code SourceCode
Debit Amount DebitAmount
Credit Amount CreditAmount
Entry No_ EntryNo
G_L Account No_ GLAccountNo
Document No_ DocumentNo
Job No_ JobNo
Gen_ Bus_ Posting Group GenBusPostingGroup
Gen_ Prod_ Posting Group GenProdPostingGroup
Dimension Set ID DimensionSetID
Description Description
Source Type SourceType
Source No_ SourceNo
Source Field Name Destination Field Name
Budget Name BudgetName
Date Date
Amount Amount
Description Description
Entry No_ EntryNo
G_L Account No_ GLAccountNo
Dimension Set ID DimensionSetID
Source Field Name Destination Field Name
No_ No
Line No_ LineNo
Document No_ DocumentNo
Sell-to Customer No_ SellToCustomerNo
Type Type
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
Job No_ JobNo
Unit Cost (LCY) UnitCostLCY
Job Task No_ JobTaskNo
Bill-to Customer No_ BillToCustomerNo
Shipment Date ShipmentDate
Line Amount LineAmount
Line Discount _ LineDiscountPct
Line Discount Amount LineDistinctAmount
VAT _ VATPct
Dimension Set ID DimensionSetID
Source Field Name Destination Field Name
Currency Code CurrencyCode
Salesperson Code SalespersonCode
Ship-to Code ShipToCode
Posting Date PostingDate
Shipment Date ShipmentDate
Currency Factor CurrencyFactor
Prices Including VAT PricesIncludingVAT
No_ No
Sell-to Customer No_ SellToCustomerNo
Bill-to Customer No_ BillToCustomerNo
Source Code SourceCode
Source Field Name Destination Field Name
Posting Date PostingDate
Currency Code CurrencyCode
Sales (LCY) SalesLCY
Salesperson Code SalespersonCode
Open Open
Due Date DueDate
Source Code SourceCode
Closed at Date ClosedAtDate
Entry No_ EntryNo
Customer No_ CustomerNo
Dimension Set ID DimensionSetID
Description Description
Document Type DocumentType
Document No_ DocumentNo
Source Field Name Destination Field Name
No_ No
Line No_ LineNo
Document No_ DocumentNo
Sell-to Customer No_ SellToCustomerNo
Type Type
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
Job No_ JobNo
Unit Cost (LCY) UnitCostLCY
Job Task No_ JobTaskNo
Bill-to Customer No_ BillToCustomerNo
Shipment Date ShipmentDate
Line Amount LineAmount
Line Discount _ LineDiscountPct
Line Discount Amount LineDiscountAmount
VAT _ VATPct
Dimension Set ID DimensionSetID
Source Field Name Destination Field Name
Currency Code CurrencyCode
Salesperson Code SalespersonCode
Ship-to Code ShipToCode
Order Date OrderDate
Posting Date PostingDate
Shipment Date ShipmentDate
Currency Factor CurrencyFactor
Prices Including VAT PricesIncludingVAT
Source Code SourceCode
No_ No
Sell-to Customer No_ SellToCustomerNo
Bill-to Customer No_ BillToCustomerNo
Source Field Name Destination Field Name
Posting Date PostingDate
Entry Type EntryType
Location Code LocationCode
Quantity Quantity
Transaction Type TransactionType
Document Date DocumentDate
Last Invoice Date LastInvoiceDate
Open Open
Invoiced Quantity InvoicedQuantity
Entry No_ EntryNo
Item No_ ItemNo
Source No_ SourceNo
Dimension Set ID DimensionSetID
Source Type SourceType
Positive Positive
Source Field Name Destination Field Name
Entry Type EntryType
Posting Date PostingDate
Document Type DocumentType
Amount Amount
Amount (LCY) AmountLCY
Currency Code CurrencyCode
Source Code SourceCode
Debit Amount (LCY) DebitAmountLCY
Credit Amount (LCY) CreditAmountLCY
Debit Amount DebitAmount
Credit Amount CreditAmount
Initial Entry Due Date InitialEntryDueDate
Entry No_ EntryNo
Cust_ Ledger Entry No_ CustLedgerEntryNo
Document No_ DocumentNo
Customer No_ CustomerNo
Source Field Name Destination Field Name
Name Name
No_ No
Source Field Name Destination Field Name
Description Description
Job No_ JobNo
Job Task No_ JobTaskNo
Source Field Name Destination Field Name
Type Type
Posting Date PostingDate
Description Description
Quantity Quantity
Unit Cost UnitCost
Total Cost TotalCost
Unit Price UnitPrice
Total Price TotalPrice
Unit of Measure Code UnitofMeasureCode
Location Code LocationCode
Work Type Code WorkTypeCode
Source Code SourceCode
Entry Type EntryType
Area Area
Entry No_ EntryNo
Job No_ JobNo
Document No_ DocumentNo
No_ No
Resource Group No_ ResourceGroupNo
Amt_ to Post to G_L AmttoPosttoGL
Amt_ Posted to G_L AmtPostedtoGL
Gen_ Bus_ Posting Group GenBusPostingGroup
Gen_ Prod_ Posting Group GenProdPostingGroup
Job Task No_ JobTaskNo
Dimension Set ID DimensionSetID
Source Field Name Destination Field Name
Description Description
Creation Date CreationDate
Starting Date StartingDate
Ending Date EndingDate
Status Status
Person Responsible PersonResponsible
No_ No
Bill-to Customer No_ BilltoCustomerNo
Source Field Name Destination Field Name
Description Description
No_ No
Source Field Name Destination Field Name
Ship-to Code ShipToCode
Posting Date PostingDate
Currency Factor CurrencyFactor
Prices Including VAT PricesIncludingVAT
Purchaser Code PurchaserCode
Source Code SourceCode
No_ No
Buy-from Vendor No_ BuyfromVendorNo
Pay-to Vendor No_ PaytoVendorNo
Source Field Name Destination Field Name
No_ No
Document No_ DocumentNo
Line No_ LineNo
Buy-from Vendor No_ BuyfromVendorNo
Type Type
Location Code LocationCode
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
Job Task No_ JobTaskNo
Line Amount LineAmount
Line Discount _ LineDiscountPct
VAT _ VATPct
Inv_ Discount Amount InvDiscountAmount
Dimension Set ID DimensionSetID
Source Field Name Destination Field Name
Ship-to Code ShipToCode
Order Date OrderDate
Posting Date PostingDate
Currency Factor CurrencyFactor
Prices Including VAT PricesIncludingVAT
Purchaser Code PurchaserCode
Source Code SourceCode
No_ No
Buy-from Vendor No_ BuyfromVendorNo
Pay-to Vendor No_ PaytoVendorNo
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
Job Task No_ JobTaskNo
Line Amount LineAmount
Line Discount _ LineDiscountPct
VAT _ VATPct
Inv_ Discount Amount InvDiscountAmount
Dimension Set ID DimensionSetID
Source Field Name Destination Field Name
Posting Date PostingDate
Purchase (LCY) PurchaseLCY
Purchaser Code PurchaserCode
Due Date DueDate
Open Open
Source Code SourceCode
Closed at Date ClosedAtDate
Entry No_ EntryNo
Vendor No_ VendorNo
Inv_ Discount (LCY) InvDiscountLCY
Dimension Set ID DimensionSetID
Description Description
Document Type DocumentType
Document No_ DocumentNo
Source Field Name Destination Field Name
Entry Type EntryType
Document Type DocumentType
Amount Amount
Amount (LCY) AmountLCY
Source Code SourceCode
Debit Amount (LCY) DebitAmountLCY
Credit Amount (LCY) CreditAmountLCY
Posting Date PostingDate
Entry No_ EntryNo
Vendor Ledger Entry No_ VendorLedgerEntryNo
Document No_ DocumentNo
Vendor No_ VendorNo
Source Field Name Destination Field Name
Posting Date PostingDate
Item Ledger Entry Type ItemLedgerEntryType
Description Description
Location Code LocationCode
Inventory Posting Group InventoryPostingGroup
Valued Quantity ValuedQuantity
Invoiced Quantity InvoicedQuantity
Cost per Unit CostperUnit
Discount Amount DiscountAmount
Source Code SourceCode
Entry Type EntryType
Sales Amount (Actual) SalesAmountActual
Cost Amount (Actual) CostAmountActual
Cost Amount (Expected) CostAmountExpected
Sales Amount (Expected) SalesAmountExpected
Expected Cost ExpectedCost
Entry No_ EntryNo
Item No_ ItemNo
Document No_ DocumentNo
Item Ledger Entry No_ ItemLedgerEntryNo
Salespers__Purch_ Code SalespersPurchCode
Cost Posted to G_L CostPostedtoGL
Gen_ Bus_ Posting Group GenBusPostingGroup
Gen_ Prod_ Posting Group GenProdPostingGroup
Expected Cost Posted to G_L ExpectedCostPostedtoGL
Document Type DocumentType
Document Line No_ DocumentLineNo
Dimension Set ID DimensionSetID
Source No_ SourceNo
Source Type SourceType
Source Field Name Destination Field Name
Description Description
No_ No
Source Field Name Destination Field Name
Planning Date PlanningDate
Type Type
Description Description
Quantity Quantity
Total Cost (LCY) TotalCostLCY
Total Price (LCY) TotalPriceLCY
Work Type Code WorkTypeCode
Document Date DocumentDate
Line Amount (LCY) LineAmountLCY
Total Cost TotalCost
Total Price TotalPrice
Line Amount LineAmount
Line Type LineType
Variant Code VariantCode
Job No_ JobNo
Job Task No_ JobTaskNo
Line No_ LineNo
No_ No
Resource Group No_ ResourceGroupNo
Gen_ Bus_ Posting Group GenBusPostingGroup
Gen_ Prod_ Posting Group GenProdPostingGroup
Job Ledger Entry No_ JobLedgerEntryNo
Source Field Name Destination Field Name
Code Code
Name Name
Country_Region Code CountryRegionCode
Customer No_ CustomerNo
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
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
Job Task No_ JobTaskNo
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
Dimension Set ID DimensionSetID
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
Job Task No_ JobTaskNo
Line Amount LineAmount
Line Discount _ LineDiscountPct
VAT _ VATPct
Inv_ Discount Amount InvDiscountAmount
Document Type DocumentType
Quantity Invoiced QuantityInvoiced
Dimension Set ID DimensionSetID
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
Dimension Set ID DimensionSetID
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Dimension Value ID DimensionValueID
Source Field Name Destination Field Name
Job No_ JobNo
Job Task No_ JobTaskNo
Job Planning Line No_ JobPlanningLineNo
Document Type DocumentType
Document No_ DocumentNo
Line No_ LineNo
Invoiced Date InvoicedDate
Invoiced Amount (LCY) InvoicedAmountLCY
Invoiced Cost Amount (LCY) InvoicedCostAmountLCY
Job Ledger Entry No_ JobLedgerEntryNo
Source Field Name Destination Field Name
Code Code
Description Description