Microsoft Dynamics NAV 3.70

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.wHasCreditLimit
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.wHasCreditLimit
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.wHasCreditLimit
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
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
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 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
Budgeted Job Price x x x x x x x x x
Budgeted Job Quantity x x x x x x x x x
Cost Budget Index x x x x x x x x x
Cost Budget Variance x x x x x x x x x
Excess Invoicing 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
Invoiced Cost 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
Invoiced Quantity x 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
Price Budget Variance x x x x x x x x x
Profit 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
Quantity Budget Index x x x x x x x x x
Quantity Budget Variance x x x x x x x x x
Total Cost 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
Total Quantity 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

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 Budget Variance
Expression [Invoiced Price]-[Budgeted Job Price]
Visible to Users True
Price Budget Index
Expression iif ([Budgeted Job Price]=0, null, ([Invoiced Price]/[Budgeted Job Price])*100)
Visible to Users True
Cost Budget Variance
Expression [Budgeted Job Cost]-[Total Cost]
Visible to Users True
Cost Budget Index
Expression iif ([Total Cost]=0, null, ([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
Number and Name dCustomer.NumberName
Name dCustomer.Name
Credit Limit Type dCustomer.wHasCreditLimit
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.wHasCreditLimit
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 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
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 dCountry.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 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
Purchase Credit Memo Amount x 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 x
Purchase Invoice Amount x 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 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

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
Country Country
Vendor Number and Name Vendor Number and Name
Vendor Territory
Level Name Source Attribute Description
Territory Territory
Vendor Number and Name Vendor Number and Name
Item
Attributes
Name Source Description
Number dItem.No
Description dItem.Description
Number and Description dItem.NumberDescription
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
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
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

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
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
Outstanding Cost
Aggregate function Sum
Source fSalesLine.wOutstandingCostLCY
Visible to Users True
Order Cost
Aggregate function Sum
Source fSalesLine.wLineCostLCY
Visible to Users True
Order Amount
Aggregate function Sum
Source fSalesLine.wLineAmountLCY
Visible to Users True
Order Quantity
Aggregate function Sum
Source fSalesLine.Quantity
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 Invoices
Aggregate function DistinctCount
Source fSalesInvoiceLine.wSalesInvoiceCount
Visible to Users True
Number of Credit Memos
Aggregate function DistinctCount
Source fSalesCrMemoLine.wCreditMemoCount
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.wHasCreditLimit
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.wHasCreditLimit
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
Customer Number dCustomer.No
Customer Number and Name dCustomer.NumberName
Customer Name dCustomer.Name
Credit Limit Type dCustomer.wHasCreditLimit
Hierarchies
Customer Country
Level Name Source Attribute Description
Country Country
Customer Number and Name Customer Number and Name
Customer Territory
Level Name Source Attribute Description
Territory Territory
Customer Number and Name Customer Number and Name
Item
Attributes
Name Source Description
Number dItem.No
Description dItem.Description
Number and Description dItem.NumberDescription
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
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
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 dCountry.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
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
Name Name
Territory Code TerritoryCode
Country Code CountryCode
No. No
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
No. No
Status Code StatusCode
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
Account Type AccountType
No. No
Income/Balance IncomeBalance
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
Name Name
No. No
Source Field Name Destination Field Name
Name Name
Territory Code TerritoryCode
Country Code CountryCode
Credit Limit (LCY) CreditLimitLCY
No. No
Payment Terms Code PaymentTermsCode
Salesperson Code SalespersonCode
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
No. No
Description Description
Inventory Posting Group InventoryPostingGroup
Base Unit of Measure BaseUnitOfMeasure
Unit Cost UnitCost
Standard Cost StandardCost
Vendor No. VendorNo
Item Category Code ItemCategoryCode
Product Group Code ProductGroupCode
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 Code CountryCode
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
Description Description
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
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
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
Phase Code PhaseCode
Step Code StepCode
Task Code TaskCode
Unit Cost (LCY) UnitCostLCY
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
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
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
Phase Code PhaseCode
Step Code StepCode
Task Code TaskCode
Unit Cost (LCY) UnitCostLCY
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
Order Date OrderDate
Shipment Date ShipmentDate
Prices Including VAT PricesIncludingVAT
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
Source Type SourceType
Positive Positive
Source Field Name Destination Field Name
Table ID TableID
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Entry No. EntryNo
Source Field Name Destination Field Name
Table ID TableID
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Document No. DocumentNo
Line No. LineNo
Source Field Name Destination Field Name
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Entry No. EntryNo
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
Job Status JobStatus
Type Type
Phase Code PhaseCode
Task Code TaskCode
Step Code StepCode
Date Date
Quantity Quantity
Total Cost TotalCost
Total Price TotalPrice
Entry No. EntryNo
Job No. JobNo
No. No
Resource Group No. ResourceGroupNo
Source Field Name Destination Field Name
Code Code
Description Description
Source Field Name Destination Field Name
Name Name
No. No
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
Posting Date PostingDate
Type Type
Description Description
Quantity Quantity
Direct Unit Cost DirectUnitCost
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
Task Code TaskCode
Phase Code PhaseCode
Step Code StepCode
Entry Type EntryType
Open Open
Remaining Amount RemainingAmount
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
Amt. Recognized AmtRecognized
Amt. to Recognize AmttoRecognize
Gen. Bus. Posting Group GenBusPostingGroup
Gen. Prod. Posting Group GenProdPostingGroup
Source Field Name Destination Field Name
Description Description
Creation Date CreationDate
Starting Date StartingDate
Ending Date EndingDate
Completion Date CompletionDate
Job Posting Date JobPostingDate
No. No
Completion % CompletionPct
Status Status
Person Responsible PersonResponsible
Bill-to Customer No. BilltoCustomerNo
Source Field Name Destination Field Name
Table ID TableID
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
No. No
Source Field Name Destination Field Name
Description Description
No. No
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
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
Phase Code PhaseCode
Task Code TaskCode
Step Code StepCode
Gen. Bus. Posting Group GenBusPostingGroup
Gen. Prod. Posting Group GenProdPostingGroup
Line Amount LineAmount
VAT % VATPct
Inv. Discount Amount InvDiscountAmount
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
No. No
Document No. DocumentNo
Line No. LineNo
Buy-from Vendor No. BuyfromVendorNo
Type Type
Location Code LocationCode
Quantity Quantity
Direct Unit Cost DirectUnitCost
Posting Group PostingGroup
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
Line Amount LineAmount
VAT % VATPct
Inv. Discount Amount InvDiscountAmount
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
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
Source No. SourceNo
Source Type SourceType
Source Field Name Destination Field Name
Table ID TableID
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Entry No. EntryNo
Source Field Name Destination Field Name
Table ID TableID
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Entry No. EntryNo
Source Field Name Destination Field Name
Table ID TableID
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Entry No. EntryNo
Source Field Name Destination Field Name
Table ID TableID
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Entry No. EntryNo
Source Field Name Destination Field Name
Table ID TableID
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Entry No. EntryNo
Source Field Name Destination Field Name
Table ID TableID
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Document No. DocumentNo
Line No. LineNo
Source Field Name Destination Field Name
Table ID TableID
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Document No. DocumentNo
Line No. LineNo
Source Field Name Destination Field Name
Table ID TableID
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Document No. DocumentNo
Line No. LineNo
Source Field Name Destination Field Name
Description Description
No. No
Source Field Name Destination Field Name
Code Code
Name Name
Country Code CountryCode
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
Table ID TableID
Document No. DocumentNo
Line No. LineNo
Dimension Code DimensionCode
Dimension Value Code DimensionValueCode
Document Type DocumentType
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
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
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
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
Code Code
Description Description