Microsoft Dynamics 365 F&O

Cubes

Name	Quick Links
Finance
Customer Ledger	Overview	Measures	Dimensions
General Ledger	Overview	Measures	Dimensions
Vendor Ledger	Overview	Measures	Dimensions
Sales
Sales	Overview	Measures	Dimensions
SCM
Inventory	Overview	Measures	Dimensions
Purchase	Overview	Measures	Dimensions
Project
Project	Overview	Measures	Dimensions
CRM
CRM	Overview	Measures	Dimensions

CRM

Bus Matrix

Activity Phase

Activity Type

Business Relation

Campaign

Company

Customer

Employee

Item

Log Action

Opportunity

Posting Period

Project

Quotation

Vendor

Activity Count

Log Count

Quotation Amount

Quotation Quantity Ordered

Quotation Quantity Sold

Measures

Activity Count
Aggregate function	Sum
Source	fSmmActivities.wCount
Visible to Users	True

Quotation Amount
Aggregate function	Sum
Source	fSalesQuotationLine.LineAmount
Visible to Users	True

Quotation Quantity Ordered
Aggregate function	Sum
Source	fSalesQuotationLine.QtyOrdered
Visible to Users	True

Quotation Quantity Sold
Aggregate function	Sum
Source	fSalesQuotationLine.SalesQty
Visible to Users	True

Log Count
Aggregate function	Sum
Source	fSmmTransLog.wCount
Visible to Users	True

Dimensions

Activity Phase
Attributes
Name	Source	Description
Description	dSmmActivityPhaseGroup.Description

Activity Type
Attributes
Name	Source	Description
Description	dSmmActivityTypeGroup.Description

Business Relation
Attributes
Name	Source	Description
Name	dSmmBusRelTable.wName
Hierarchies
Type
Level Name	Source Attribute	Description
Description	wType
Business Relation	Name

Campaign
Attributes
Name	Source	Description
Name	dSmmCampaignTable.CampaignName
Hierarchies
Group
Level Name	Source Attribute	Description
Description	Campaign Group Description
Campaign	Name
Reason
Level Name	Source Attribute	Description
Description	Campaign Reason Description
Campaign	Name
Type
Level Name	Source Attribute	Description
Description	Campaign Type Description
Campaign	Name

Company
Attributes
Name	Source	Description
Name	dDataArea.Name

Customer
Attributes
Name	Source	Description
Number	fCustTable.AccountNum
Credit Limit Type	fCustTable.wCreditLimitID
Name	fCustTable.wName
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Customer	Name
Sales Group
Level Name	Source Attribute	Description
Name	Sales Group Name
Customer	Name
Country
Level Name	Source Attribute	Description
Name	Country Name
Customer	Name

Employee
Attributes
Name	Source	Description
Name	dHcmWorker.wName

Item
Attributes
Name	Source	Description
Name	dInventTable.wItemName
Number	dInventTable.ItemID
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Item	Name

Log Action
Attributes
Name	Source	Description
Description	wdLogAction.LogActionDescription

Opportunity
Attributes
Name	Source	Description
Probability	dSmmQuotationProbabilityGroup.Description
Prognosis	dSmmQuotationPrognosisGroup.Description

Posting Period
Attributes
Name	Source	Description
Date	wdPostingPeriod.DateName
Month	wdPostingPeriod.MonthName
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Project
Attributes
Name	Source	Description
Name	dProjTable.wProjIDName
Type	wdProjectType.TypeDescription

Quotation
Attributes
Name	Source	Description
Name	dSalesQuotationTable.QuotationName
Hierarchies
Reason
Level Name	Source Attribute	Description
Description	Quotation Reason Description
Quotation	Name

Vendor
Attributes
Name	Source	Description
Number	fVendTable.AccountNum
Name	fVendTable.wName
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Vendor	Name

Customer Ledger

Bus Matrix

	Aging Bucket	Company	Customer	Posting Period	Transaction Type
Aging Days Overdue	x	x	x	x	x
Amount	x	x	x	x	x
Closed Amount	x	x	x	x	x
Credit Limit Utilization	x	x	x	x	x
Credit Max		x	x
Current Balance Due	x	x	x	x	x
Current Balance Overdue	x	x	x	x	x
Customer Balance	x	x	x	x	x
Max Customer Balance	x	x	x	x	x
Overdue Days	x	x	x	x	x

Measures

Amount
Aggregate function	Sum
Source	fCustTrans.AmountMST
Visible to Users	True

Overdue Days
Aggregate function	Sum
Source	fCustTrans.wOverdueDays
Visible to Users	True

Aging Days Overdue
Aggregate function	Sum
Source	fCustTrans.wAgingDaysOverdue
Visible to Users	True

Current Balance Due
Aggregate function	Sum
Source	fCustTrans.wCurrentBalanceDue
Visible to Users	True

Current Balance Overdue
Aggregate function	Sum
Source	fCustTrans.wCurrentBalanceOverDue
Visible to Users	True

Closed Amount
Aggregate function	Sum
Source	fCustTrans.wClosedAmount
Visible to Users	True

Credit Max
Aggregate function	Sum
Source	fCustTable.CreditMax
Visible to Users	True

Calculations

Customer Balance
Function	End Balance
Expression	[Amount]
Visible to Users	True

Max Customer Balance
Expression	([Customer].[Credit Limit ID].&[1],[Customer Balance])
Visible to Users	True

Credit Limit Utilization
Expression	([Max Customer Balance]/[Credit Max]*100)
Visible to Users	True

Dimensions

Aging Bucket
Attributes
Name	Source	Description
Group	wdAgingBucket.Text

Company
Attributes
Name	Source	Description
Name	dDataArea.Name

Customer
Attributes
Name	Source	Description
Number	fCustTable.AccountNum
Credit Limit Type	fCustTable.wCreditLimitID
Name	fCustTable.wName
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Customer	Name
Sales Group
Level Name	Source Attribute	Description
Name	Sales Group Name
Customer	Name
Country
Level Name	Source Attribute	Description
Name	Country Name
Customer	Name

Posting Period
Attributes
Name	Source	Description
Date	wdPostingPeriod.DateName
Month	wdPostingPeriod.MonthName
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Transaction Type
Attributes
Name	Source	Description
Text	wdJournalCategory.Text

General Ledger

Bus Matrix

	Account	Account Hierarchy	Budget Submodel	Company	General Journal	Posting Period	Transaction Type
Amount Credited	x	x		x	x	x	x
Amount Debited	x	x		x	x	x	x
Amount Posted	x	x		x	x	x	x
Budget Amount	x	x	x	x		x
Budget Index	x	x	x	x		x
Budget Variance	x	x	x	x		x
End Balance	x	x		x	x	x	x
Quantity	x	x		x	x	x	x
Start Balance	x	x		x	x	x	x

Measures

Quantity
Aggregate function	Sum
Source	fGeneralJournalAccountEntry.Quantity
Visible to Users	True

Calculations

Amount Posted
Expression	[ID]=2, [wReportingCurrencyAmount], [ID]=1, [wAccountingCurrencyAmount], [wTransactionCurrencyAmount] ) )
Visible to Users	True

End Balance
Function	End Balance
Expression	[Amount Posted for Balance]
Visible to Users	True

Start Balance
Expression	[End Balance]-[Amount Posted]
Visible to Users	True

Budget Amount
Expression	[ID]=1, [wBudgetAccountingCurrencyAmount], [wBudgetTransactionCurrencyAmount] )
Visible to Users	True

Budget Variance
Expression	[Amount Posted]-[Budget Amount]
Visible to Users	True

Budget Index
Expression	([Amount Posted]/[Budget Amount])*100
Visible to Users	True

Amount Credited
Expression	([General Journal IsCredit].[KEY].&[1],[Amount Posted])
Visible to Users	True

Amount Debited
Expression	([General Journal IsCredit].[KEY].&[0],[Amount Posted])
Visible to Users	True

Dimensions

Account
Attributes
Name	Source	Description
Name	dMainAccount.Name
Number	dMainAccount.MainAccountID
Number and Name	dMainAccount.AccountNumName
Category	dMainAccountCategory.Description
Type	wdDimensionLedgerAccountType.Text

Account Hierarchy
Attributes
Name	Source	Description
Hierarchy	dMainAccount.wParentRecID
Type	wdDimensionLedgerAccountType.Text

Budget Submodel
Attributes
Name	Source	Description
Company Name	dDataArea.Name
Model Name	dBudgetModel.Txt
Hierarchies
Submodel Hierarchy
Level Name	Source Attribute	Description
Company Name	Company Name
Model Name	Model Name

Company
Attributes
Name	Source	Description
Name	dDataArea.Name

Currency
Attributes
Name	Source	Description
Text	wdCurrencySelection.Text

General Journal
Attributes
Name	Source	Description
Transaction Type	wdJournalCategory.Text
Period Type	wdFiscalPeriodType.Text

Posting Period
Attributes
Name	Source	Description
Date	wdPostingPeriod.DateName
Month	wdPostingPeriod.MonthName
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Transaction Type
Attributes
Name	Source	Description
Text	wdJournalCategory.Text

Inventory

Bus Matrix

	Company	Inventory Location	Inventory Status Type	Item	Posting Period	Vendor
Inventory Value Primo	x	x	x	x	x	x
Inventory Value Ultimo	x	x	x	x	x	x
Net Sales	x	x	x	x	x	x
Posted Inventory Value Primo	x	x	x	x	x	x
Posted Inventory Value Ultimo	x	x	x	x	x	x
Quantity	x	x		x	x	x
Quantity Primo	x	x	x	x	x	x
Quantity Ultimo	x	x	x	x	x	x
Speed	x	x	x	x	x	x
Speed per Year	x	x	x	x	x	x

Measures

Calculations

Quantity
Expression	[Sum Qty Posted]+ [Sum Qty Physical]+ [Trans Qty Posted]+ [Trans Qty Physical]
Visible to Users	True

Inventory Value Ultimo
Function	End Balance
Expression	[wBalanceInventoryValue]
Visible to Users	True

Inventory Value Primo
Expression	[Inventory Value Ultimo]-[Inventory Value]
Visible to Users	True

Posted Inventory Value Ultimo
Function	End Balance
Expression	[wBalancePostedInventoryValue]
Visible to Users	True

Posted Inventory Value Primo
Expression	[Posted Inventory Value Ultimo]-[Posted Inventory Value]
Visible to Users	True

Quantity Ultimo
Function	End Balance
Expression	[wBalanceQuantity]
Visible to Users	True

Quantity Primo
Expression	[Quantity Ultimo]-[Quantity]
Visible to Users	True

Net Sales
Expression	-([Inventory Value],[Inventory Trans Type].[Inventory Trans Type Key].&[0])
Visible to Users	True

Speed
Expression	[Inventory Value Average]>0, [Net Sales]/[Inventory Value Average], 0)
Visible to Users	True

Speed per Year
Expression	([Speed]*365)/[Number of Days]
Visible to Users	True

Dimensions

Company
Attributes
Name	Source	Description
Name	dDataArea.Name

Inventory Location
Attributes
Name	Source	Description
Name	dInventLocation.Name

Inventory Status Type
Attributes
Name	Source	Description
Direction	wdInventoryStatus.DirectionText
Type	wdInventoryStatus.StatusText
Hierarchies
Inventory Status Hierarchy
Level Name	Source Attribute	Description
Direction	Direction
Type	Type

Item
Attributes
Name	Source	Description
Name	dInventTable.wItemName
Number	dInventTable.ItemID
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Item	Name

Posting Period
Attributes
Name	Source	Description
Date	wdPostingPeriod.DateName
Month	wdPostingPeriod.MonthName
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Vendor
Attributes
Name	Source	Description
Number	fVendTable.AccountNum
Name	fVendTable.wName
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Vendor	Name

Project

Bus Matrix

	Company	Customer	Employee	Invoice Entity	Posting Period	Project
Amount on Account	x	x			x	x
Invoice Cost	x	x		x	x	x
Invoice Profit	x	x		x	x	x
Invoice Profit %	x	x		x	x	x
Invoice Quantity	x	x		x	x	x
Invoice Revenue	x	x		x	x	x
Project Hour Variance	x	x	x		x	x
Project Hours Actual	x	x	x		x	x
Project Hours Budget	x	x	x		x	x
Project Hours Index	x	x	x		x	x

Measures

Project Hours Budget
Aggregate function	Sum
Source	fProjForecastEmplSplit.Qty
Visible to Users	True

Project Hours Actual
Aggregate function	Sum
Source	fProjEmplTrans.Qty
Visible to Users	True

Invoice Quantity
Aggregate function	Sum
Source	fProjInvoiceTrans.Qty
Visible to Users	True

Invoice Cost
Aggregate function	Sum
Source	fProjInvoiceTrans.CostAmount
Visible to Users	True

Invoice Revenue
Aggregate function	Sum
Source	fProjInvoiceTrans.wLineAmountMST
Visible to Users	True

Amount on Account
Aggregate function	Sum
Source	fProjInvoiceOnAcc.AmountMST
Visible to Users	True

Calculations

Project Hour Variance
Expression	[Project Hours Budget]-[Project Hours Actual]
Visible to Users	True

Project Hours Index
Expression	([Project Hours Actual]/[Project Hours Budget])*100
Visible to Users	True

Invoice Profit
Expression	[Invoice Revenue]-[Invoice Cost]
Visible to Users	True

Invoice Profit %
Expression	([Invoice Profit]/[Invoice Revenue])*100
Visible to Users	True

Dimensions

Company
Attributes
Name	Source	Description
Name	dDataArea.Name

Customer
Attributes
Name	Source	Description
Number	fCustTable.AccountNum
Credit Limit Type	fCustTable.wCreditLimitID
Name	fCustTable.wName
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Customer	Name
Sales Group
Level Name	Source Attribute	Description
Name	Sales Group Name
Customer	Name
Country
Level Name	Source Attribute	Description
Name	Country Name
Customer	Name

Employee
Attributes
Name	Source	Description
Name	dHcmWorker.wName

Invoice Entity
Attributes
Name	Source	Description
Type Description	wdProjInvoiceType.wInvoiceTypeDescription
Type Name	wdProjInvoiceType.wInvoiceTypeName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Type Description	Type Description
Type Name	Type Name

Posting Period
Attributes
Name	Source	Description
Date	wdPostingPeriod.DateName
Month	wdPostingPeriod.MonthName
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Project
Attributes
Name	Source	Description
Name	dProjTable.wProjIDName
Type	wdProjectType.TypeDescription

Purchase

Bus Matrix

	Company	Item	Posting Period	Vendor
Average Purchase Price	x	x	x	x
Purchase Invoice Amount	x	x	x	x
Purchase Invoice Quantity	x	x	x	x

Measures

Purchase Invoice Quantity
Aggregate function	Sum
Source	fVendInvoiceTrans.Qty
Visible to Users	True

Purchase Invoice Amount
Aggregate function	Sum
Source	fVendInvoiceTrans.LineAmountMST
Visible to Users	True

Calculations

Average Purchase Price
Expression	[Purchase Invoice Amount]/[Purchase Invoice Quantity]
Visible to Users	True

Dimensions

Company
Attributes
Name	Source	Description
Name	dDataArea.Name

Item
Attributes
Name	Source	Description
Name	dInventTable.wItemName
Number	dInventTable.ItemID
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Item	Name

Posting Period
Attributes
Name	Source	Description
Date	wdPostingPeriod.DateName
Month	wdPostingPeriod.MonthName
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Vendor
Attributes
Name	Source	Description
Number	fVendTable.AccountNum
Name	fVendTable.wName
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Vendor	Name

Sales

Bus Matrix

	Company	Customer	Customer Invoice	Delivery Period	Employee	Item	Posting Period	Project	Sales Order	Shipping Period
Cost	x	x	x		x	x	x	x	x	x
Direct Order Cost	x	x		x	x	x	x	x	x	x
Margin	x	x	x		x	x	x	x	x	x
Margin %	x	x	x		x	x	x	x	x	x
Order Amount	x	x		x	x	x	x	x	x	x
Order Margin	x	x		x	x	x	x	x	x	x
Order Margin - Posted	x	x		x	x	x	x	x	x	x
Order Margin %	x	x		x	x	x	x	x	x	x
Order Margin % - Posted	x	x		x	x	x	x	x	x	x
Order Quantity	x	x		x	x	x	x	x	x	x
Outstanding Amount	x	x		x	x	x	x	x	x	x
Outstanding Quantity	x	x		x	x	x	x	x	x	x
Posted Order Cost	x	x		x	x	x	x	x	x	x
Quantity	x	x	x		x	x	x	x	x	x
Revenue	x	x	x		x	x	x	x	x	x
Shipped not Invoiced Amount	x	x		x	x	x	x	x	x	x
Shipped not Invoiced Quantity	x	x		x	x	x	x	x	x	x

Measures

Quantity
Aggregate function	Sum
Source	fCustInvoiceTrans.Qty
Visible to Users	True

Revenue
Aggregate function	Sum
Source	fCustInvoiceTrans.LineAmountMST
Visible to Users	True

Cost
Aggregate function	Sum
Source	fCustInvoiceTrans.wCostAmountPosted
Visible to Users	True

Order Amount
Aggregate function	Sum
Source	fSalesLine.wLineAmountMST
Visible to Users	True

Posted Order Cost
Aggregate function	Sum
Source	fSalesLine.wCostAmountPosted
Visible to Users	True

Order Quantity
Aggregate function	Sum
Source	fSalesLine.SALESQTY
Visible to Users	True

Outstanding Amount
Aggregate function	Sum
Source	fSalesLine.wRemainPhysicalMST
Visible to Users	True

Shipped not Invoiced Amount
Aggregate function	Sum
Source	fSalesLine.wRemainFinancialMST
Visible to Users	True

Outstanding Quantity
Aggregate function	Sum
Source	fSalesLine.RemainSalesPhysical
Visible to Users	True

Shipped not Invoiced Quantity
Aggregate function	Sum
Source	fSalesLine.RemainSalesFinancial
Visible to Users	True

Direct Order Cost
Aggregate function	Sum
Source	fSalesLine.wOrderCost
Visible to Users	True

Calculations

Margin
Expression	[Revenue]-[Cost]
Visible to Users	True

Margin %
Expression	([Margin]/[Revenue])*100
Visible to Users	True

Order Margin
Expression	[Order Amount]-[Direct Order Cost]
Visible to Users	True

Order Margin %
Expression	([Order Margin]/[Order Amount])*100
Visible to Users	True

Order Margin - Posted
Expression	[Order Amount]-[Posted Order Cost]
Visible to Users	True

Order Margin % - Posted
Expression	([Order Margin - Posted]/[Order Amount])*100
Visible to Users	True

Dimensions

Company
Attributes
Name	Source	Description
Name	dDataArea.Name

Customer
Attributes
Name	Source	Description
Number	fCustTable.AccountNum
Credit Limit Type	fCustTable.wCreditLimitID
Name	fCustTable.wName
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Customer	Name
Sales Group
Level Name	Source Attribute	Description
Name	Sales Group Name
Customer	Name
Country
Level Name	Source Attribute	Description
Name	Country Name
Customer	Name

Customer Invoice
Attributes
Name	Source	Description
Number	dCustInvoiceJour.InvoiceID

Delivery Period
Attributes
Name	Source	Description
Date	wdPostingPeriod.DateName
Month	wdPostingPeriod.MonthName
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Employee
Attributes
Name	Source	Description
Name	dHcmWorker.wName

Item
Attributes
Name	Source	Description
Name	dInventTable.wItemName
Number	dInventTable.ItemID
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Item	Name

Posting Period
Attributes
Name	Source	Description
Date	wdPostingPeriod.DateName
Month	wdPostingPeriod.MonthName
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Project
Attributes
Name	Source	Description
Name	dProjTable.wProjIDName
Type	wdProjectType.TypeDescription

Sales Order
Attributes
Name	Source	Description
Number	dSalesTable.SalesID

Shipping Period
Attributes
Name	Source	Description
Date	wdPostingPeriod.DateName
Month	wdPostingPeriod.MonthName
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Vendor Ledger

Bus Matrix

	Company	Posting Period	Transaction Type	Vendor
Amount	x	x	x	x
Vendor Balance	x	x	x	x

Measures

Amount
Aggregate function	Sum
Source	fVendTrans.AmountMST
Visible to Users	True

Calculations

Vendor Balance
Function	End Balance
Expression	[Amount]
Visible to Users	True

Dimensions

Company
Attributes
Name	Source	Description
Name	dDataArea.Name

Posting Period
Attributes
Name	Source	Description
Date	wdPostingPeriod.DateName
Month	wdPostingPeriod.MonthName
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Transaction Type
Attributes
Name	Source	Description
Text	wdJournalCategory.Text

Vendor
Attributes
Name	Source	Description
Number	fVendTable.AccountNum
Name	fVendTable.wName
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Vendor	Name

Data Transformations

CUSTTABLE	fCustTable
Source Field Name	Destination Field Name
ACCOUNTNUM	AccountNum
CUSTGROUP	CustGroup
CREDITMAX	CreditMax
DATAAREAID	DataAreaID
PARTY	Party
SALESGROUP	SalesGroup
RECID	RecID
PARTITION	Partition
DEFAULTDIMENSION	DefaultDimension

INVENTITEMGROUP	dInventItemGroup
Source Field Name	Destination Field Name
ITEMGROUPID	ItemGroupID
NAME	Name
DATAAREAID	DataAreaID
PARTITION	Partition

INVENTTRANS	tInventTrans
Source Field Name	Destination Field Name
INVENTDIMID	InventDimID
ITEMID	ItemID
STATUSISSUE	StatusIssue
DATEPHYSICAL	DatePhysical
QTY	Qty
COSTAMOUNTPOSTED	CostAmountPosted
CURRENCYCODE	CurrencyCode
INVOICEID	InvoiceID
VOUCHER	Voucher
DATEEXPECTED	DateExpected
DATEFINANCIAL	DateFinancial
COSTAMOUNTPHYSICAL	CostAmountPhysical
COSTAMOUNTADJUSTMENT	CostAmountAdjustment
QTYSETTLED	QtySettled
COSTAMOUNTSETTLED	CostAmountSettled
COSTAMOUNTSTD	CostAmountStd
DATAAREAID	DataAreaID
STATUSRECEIPT	StatusReceipt
PACKINGSLIPRETURNED	PackingSlipReturned
INVENTTRANSORIGIN	InventTransOrigin
PARTITION	Partition

SALESTABLE	dSalesTable
Source Field Name	Destination Field Name
SALESID	SalesID
SALESNAME	SalesName
CUSTACCOUNT	CustAccount
DATAAREAID	DataAreaID
WORKERSALESRESPONSIBLE	WorkerSalesResponsible
PROJID	ProjID
WORKERSALESTAKER	WorkerSalesTaker
PARTITION	Partition
SALESSTATUS	SalesStatus

HCMWORKER	dHcmWorker
Source Field Name	Destination Field Name
PERSON	Person
PERSONNELNUMBER	PersonnelNumber
RECID	RecID
PARTITION	Partition

SMMCAMPAIGNTABLE	dSmmCampaignTable
Source Field Name	Destination Field Name
CAMPAIGNID	CampaignID
CAMPAIGNNAME	CampaignName
CAMPAIGNDATE	CampaignDate
CAMPAIGNENDDATE	CampaignEndDate
CAMPAIGNPARENTID	CampaignParentID
CAMPAIGNGROUPID	CampaignGroupID
CAMPAIGNTYPEID	CampaignTypeID
CAMPAIGNCLOSED	CampaignClosed
CAMPAIGNSTATUS	CampaignStatus
CAMPAIGNREASONID	CampaignReasonID
DATAAREAID	DataAreaID
WORKER	Worker
PROJID	ProjID
PROJFATHERID	ProjFatherID
RECID	RecID
PARTITION	Partition

SMMQUOTATIONPROBABILITYGROUP	dSmmQuotationProbabilityGroup
Source Field Name	Destination Field Name
PROBABILITYID	ProbabilityID
DESCRIPTION	Description
DATAAREAID	DataAreaID
PARTITION	Partition

VENDTABLE	fVendTable
Source Field Name	Destination Field Name
ACCOUNTNUM	AccountNum
VENDGROUP	VendGroup
DATAAREAID	DataAreaID
PARTY	Party
RECID	RecID
PARTITION	Partition

SMMBUSRELTYPEGROUP	dSmmBusRelTypeGroup
Source Field Name	Destination Field Name
TYPEID	TypeID
TYPEDESCRIPTION	TypeDescription
TABLETYPE	TableType
DATAAREAID	DataAreaID
PARTITION	Partition

PROJCATEGORYGROUP	dProjCategoryGroup
Source Field Name	Destination Field Name
CATEGORYGROUPID	CategoryGroupID
NAME	Name
CATEGORYTYPE	CategoryType
DATAAREAID	DateAreaID
PARTITION	Partition

SMMCAMPAIGNGROUP	dSmmCampaignGroup
Source Field Name	Destination Field Name
CAMPAIGNGROUPDESCRIPTION	CampaignGroupDescription
CAMPAIGNGROUPID	CampaignGroupID
DATAAREAID	DataAreaID
PARTITION	Partition

SMMTRANSLOG	fSmmTransLog
Source Field Name	Destination Field Name
CONTACTPERSONID	ContactPersonID
LOGTYPE	LogType
LOGDATETIME	LogDateTime
LOGACTION	LogAction
PRIMARYDESCRIPTION	PrimaryDescription
SALESUNITID	SalesUnitID
DATAAREAID	DataAreaID
PARTY	Party
WORKER	Worker
REFTABLEID	RefTableID
REFNUM	RefNum
REFRECID	RefRecID
RECID	RecID
PARTITION	Partition

SMMACTIVITYTYPEGROUP	dSmmActivityTypeGroup
Source Field Name	Destination Field Name
DESCRIPTION	Description
TYPEID	TypeID
DATAAREAID	DataAreaID
PARTITION	Partition

SMMQUOTATIONREASONGROUP	dSmmQuotationReasonGroup
Source Field Name	Destination Field Name
REASONID	ReasonID
DESCRIPTION	Description
DATAAREAID	DataAreaID
PARTITION	Partition

SMMACTIVITYPHASEGROUP	dSmmActivityPhaseGroup
Source Field Name	Destination Field Name
DESCRIPTION	Description
PHASEID	PhaseID
DATAAREAID	DataAreaID
PARTITION	Partition

SMMCAMPAIGNREASONGROUP	dSmmCampaignReasonGroup
Source Field Name	Destination Field Name
REASONID	ReasonID
DESCRIPTION	Description
DATAAREAID	DataAreaID
PARTITION	Partition

SMMCAMPAIGNTYPEGROUP	dSmmCampaignTypeGroup
Source Field Name	Destination Field Name
CAMPAIGNTYPEID	CampaignTypeID
CAMPAIGNTYPEDESCRIPTION	CampaignTypeDescription
DATAAREAID	DataAreaID
PARTITION	Partition

SALESQUOTATIONTYPEGROUP	dSalesQuotationTypeGroup
Source Field Name	Destination Field Name
TYPEID	TypeID
DESCRIPTION	Description
DATAAREAID	DataAreaID
PARTITION	Partition

SYSTEMPARAMETERS	tSystemParameters
Source Field Name	Destination Field Name
SYSTEMLANGUAGEID	SystemLanguageID
CHARTOFACCOUNTSDELIMITER	ChartOfAccountsDelimiter
SYSTEMCURRENCYCODE	SystemCurrencyCode
SYSTEMEXCHANGERATETYPE	SystemExchangeRateType
RECID	RecID
PARTITION	Partition

DIRPARTYTABLE	dDirPartyTable
Source Field Name	Destination Field Name
NAME	Name
NAMEALIAS	NameAlias
PARTYNUMBER	PartyNumber
INSTANCERELATIONTYPE	InstanceRelationType
KNOWNAS	KnownAs
RELATIONTYPE	RelationType
RECID	RecID
PARTITION	Partition
DATAAREA	DataArea

COMMISSIONSALESGROUP	dCommissionSalesGroup
Source Field Name	Destination Field Name
DATAAREAID	DataAreaID
GROUPID	GroupID
NAME	Name
RECID	RecID
PARTITION	Partition

SMMQUOTATIONPROGNOSISGROUP	dSmmQuotationPrognosisGroup
Source Field Name	Destination Field Name
DESCRIPTION	Description
PROGNOSISID	PrognosisID
DATAAREAID	DataAreaID
PARTITION	Partition

INVENTDIM	tInventDim
Source Field Name	Destination Field Name
INVENTDIMID	InventDimID
INVENTBATCHID	InventBatchID
WMSLOCATIONID	WmsLocationID
WMSPALLETID	WmsPalletID
INVENTSERIALID	InventSerialID
INVENTLOCATIONID	InventLocationID
DATAAREAID	DataAreaID
RECID	RecID
PARTITION	Partition

INVENTTRANSORIGIN	dInventTransOrigin
Source Field Name	Destination Field Name
INVENTTRANSID	InventTransID
REFERENCECATEGORY	ReferenceCategory
REFERENCEID	ReferenceID
ITEMID	ItemID
ITEMINVENTDIMID	ItemInventDimID
PARTY	Party
DATAAREAID	DataAreaID
RECID	RecID
PARTITION	Partition

INVENTTABLE	dInventTable
Source Field Name	Destination Field Name
ITEMID	ItemID
ITEMTYPE	ItemType
QTYPERLAYER	QtyPerLayer
PRIMARYVENDORID	PrimaryVendorID
DATAAREAID	DataAreaID
RECID	RecID
PRODUCT	Product
PARTITION	Partition

ECORESPRODUCT	dEcoResProduct
Source Field Name	Destination Field Name
INSTANCERELATIONTYPE	InstanceRelationType
DISPLAYPRODUCTNUMBER	DisplayProductNumber
PRODUCTTYPE	ProductType
RELATIONTYPE	RelationType
RECID	RecID
SEARCHNAME	SearchName
PARTITION	Partition

ECORESPRODUCTTRANSLATION	dEcoResProductTranslation
Source Field Name	Destination Field Name
NAME	Name
PRODUCT	Product
LANGUAGEID	LanguageID
RECID	RecID
PARTITION	Partition

GENERALJOURNALACCOUNTENTRY	fGeneralJournalAccountEntry
Source Field Name	Destination Field Name
TRANSACTIONCURRENCYAMOUNT	TransactionCurrencyAmount
ACCOUNTINGCURRENCYAMOUNT	AccountingCurrencyAmount
REPORTINGCURRENCYAMOUNT	ReportingCurrencyAmount
QUANTITY	Quantity
ISCORRECTION	IsCorrection
ISCREDIT	IsCredit
TRANSACTIONCURRENCYCODE	TransactionCurrencyCode
POSTINGTYPE	PostingType
LEDGERDIMENSION	LedgerDimension
GENERALJOURNALENTRY	GeneralJournalEntry
TEXT	Text
CREATEDTRANSACTIONID	CreatedTransactionID
RECID	RecID
PARTITION	Partition

GENERALJOURNALENTRY	dGeneralJournalEntry
Source Field Name	Destination Field Name
ACCOUNTINGDATE	AccountingDate
LEDGERENTRYJOURNAL	LedgerEntryJournal
LEDGERPOSTINGJOURNAL	LedgerPostingJournal
FISCALCALENDARPERIOD	FiscalCalendarPeriod
LEDGER	Ledger
JOURNALNUMBER	JournalNumber
FISCALCALENDARYEAR	FiscalCalendarYear
JOURNALCATEGORY	JournalCategory
DOCUMENTDATE	DocumentDate
DOCUMENTNUMBER	DocumentNumber
CREATEDTRANSACTIONID	CreatedTransactionID
RECID	RecID
PARTITION	Partition

LEDGER	dLedger
Source Field Name	Destination Field Name
CHARTOFACCOUNTS	ChartOfAccounts
NAME	Name
PRIMARYFORLEGALENTITY	PrimaryForLegalEntity
FISCALCALENDAR	FiscalCalendar
ACCOUNTINGCURRENCY	AccountingCurrency
REPORTINGCURRENCY	ReportingCurrency
RECID	RecID
DESCRIPTION	Description
PARTITION	Partition

MAINACCOUNT	dMainAccount
Source Field Name	Destination Field Name
MAINACCOUNTID	MainAccountID
NAME	Name
CURRENCYCODE	CurrencyCode
TYPE	Type
ACCOUNTCATEGORYREF	AccountCategoryRef
CLOSING	Closing
POSTINGTYPE	PostingType
CONSOLIDATIONMAINACCOUNT	ConsolidationMainAccount
MAINACCOUNTTEMPLATE	MainAccountTemplate
LEDGERCHARTOFACCOUNTS	LedgerChartOfAccounts
OPENINGACCOUNT	OpeningAccount
REPORTINGACCOUNTTYPE	ReportingAccountType
RECID	RecID
PARTITION	Partition

LEDGERCHARTOFACCOUNTS	dLedgerChartOfAccounts
Source Field Name	Destination Field Name
NAME	Name
DESCRIPTION	Description
MAINACCOUNTFORMATMASK	MainAccountFormatMask
RECID	RecID
PARTITION	Partition

MAINACCOUNTCATEGORY	dMainAccountCategory
Source Field Name	Destination Field Name
ACCOUNTCATEGORY	AccountCategory
DESCRIPTION	Description
ACCOUNTTYPE	AccountType
CLOSED	Closed
ACCOUNTCATEGORYREF	AccountCategoryRef
RECID	RecID
PARTITION	Partition

DIMENSIONATTRIBUTEVALUECOMBINATION	dDimensionAttributeValueCombination
Source Field Name	Destination Field Name
DISPLAYVALUE	DisplayValue
MAINACCOUNT	MainAccount
ACCOUNTSTRUCTURE	AccountStructure
LEDGERDIMENSIONTYPE	LedgerDimensionType
HASH	Hash
RECID	RecID
PARTITION	Partition

BUDGETTRANSACTIONLINE	fBudgetTransactionLine
Source Field Name	Destination Field Name
LINENUMBER	LineNumber
INCLUDEINCASHFLOWFORECAST	IncludeInCashFlowForecast
BUDGETTRANSACTIONHEADER	BudgetTransactionHeader
DATE	Date
QUANTITY	Quantity
PRICE	Price
LEDGERDIMENSION	LedgerDimension
TRANSACTIONCURRENCYAMOUNT	TransactionCurrencyAmount
ACCOUNTINGCURRENCYAMOUNT	AccountingCurrencyAmount
TRANSACTIONCURRENCY	TransactionCurrency
BUDGETTYPE	BudgetType
GENERALJOURNALENTRY	GeneralJournalEntry
RECID	RecID
PARTITION	Partition

BUDGETTRANSACTIONHEADER	dBudgetTransactionHeader
Source Field Name	Destination Field Name
TRANSACTIONNUMBER	TransactionNumber
DATE	Date
TRANSACTIONSTATUS	TransactionStatus
BUDGETTRANSACTIONTYPE	BudgetTransactionType
BUDGETMODELID	BudgetModelID
BUDGETSUBMODELID	BudgetSubModelID
BUDGETMODELTYPE	BudgetModelType
BUDGETTRANSACTIONCODE	BudgetTransactionCode
PRIMARYLEDGER	PrimaryLedger
BUDGETMODELDATAAREAID	BudgetModelDataAreaID
RECID	RecID
PARTITION	Partition

BUDGETMODEL	dBudgetModel
Source Field Name	Destination Field Name
TXT	Txt
TYPE	Type
SUBMODELID	SubmodelID
MODELID	ModelID
RECID	RecID
DATAAREAID	DataAreaID
PARTITION	Partition

FISCALCALENDARYEAR	dFiscalCalendarYear
Source Field Name	Destination Field Name
STARTDATE	StartDate
ENDDATE	EndDate
FISCALCALENDAR	FiscalCalendar
NAME	Name
RECID	RecID
PARTITION	Partition

FISCALCALENDARPERIOD	dFiscalCalendarPeriod
Source Field Name	Destination Field Name
ENDDATE	EndDate
DESCRIPTION	Description
MONTH	Month
QUARTER	Quarter
STARTDATE	StartDate
FISCALCALENDARYEAR	FiscalCalendarYear
SHORTNAME	ShortName
NAME	Name
TYPE	Type
FISCALCALENDAR	FiscalCalendar
RECID	RecID
PARTITION	Partition

FISCALCALENDAR	dFiscalCalendar
Source Field Name	Destination Field Name
CALENDARID	CalendarID
DESCRIPTION	Description
RECID	RecID
PARTITION	Partition

CUSTGROUP	dCustGroup
Source Field Name	Destination Field Name
CUSTGROUP	CustGroup
NAME	Name
DATAAREAID	DataAreaID
PARTITION	Partition

CUSTTRANS	fCustTrans
Source Field Name	Destination Field Name
ACCOUNTNUM	AccountNum
TRANSDATE	TransDate
VOUCHER	Voucher
INVOICE	Invoice
TXT	Txt
AMOUNTCUR	AmountCUR
SETTLEAMOUNTCUR	SettleAmountCUR
AMOUNTMST	AmountMST
SETTLEAMOUNTMST	SettleAmountMST
CURRENCYCODE	CurrencyCode
DUEDATE	DelDueDate
LASTSETTLEDATE	LastSettleDate
CLOSED	Closed
TRANSTYPE	TransType
SETTLEMENT	Settlement
DATAAREAID	DataAreaID
RECID	RecID
PARTITION	Partition
DEFAULTDIMENSION	defaultDimension

VENDTRANS	fVendTrans
Source Field Name	Destination Field Name
ACCOUNTNUM	AccountNum
TRANSDATE	TransDate
VOUCHER	Voucher
INVOICE	Invoice
TXT	Txt
AMOUNTCUR	AmountCUR
SETTLEAMOUNTCUR	SettleAmountCUR
AMOUNTMST	AmountMST
SETTLEAMOUNTMST	SettleAmountMST
CURRENCYCODE	CurrencyCode
DUEDATE	DelDueDate
LASTSETTLEDATE	LastSettleDate
CLOSED	Closed
TRANSTYPE	TransType
DOCUMENTDATE	DocumentDate
DATAAREAID	DataAreaID
RECID	RecID
PARTITION	Partition
DEFAULTDIMENSION	DefaultDimension

VENDGROUP	dVendGroup
Source Field Name	Destination Field Name
VENDGROUP	VendGroup
NAME	Name
DATAAREAID	DataAreaID
PARTITION	Partition

PROJCOSTTRANS	fProjCostTrans
Source Field Name	Destination Field Name
PROJID	ProjID
CATEGORYID	CategoryID
TRANSDATE	TransDate
TXT	Txt
QTY	Qty
TOTALCOSTAMOUNTCUR	TotalCostAmountCur
TOTALSALESAMOUNTCUR	TotalSalesAmountCur
DATAAREAID	DataAreaID
TRANSID	TransID
RECID	RecID
CURRENCYID	CurrencyID
DEFAULTDIMENSION	DefaultDimension
CURRENCYIDCOST	CurrencyIDCost
PARTITION	Partition
RESOURCE_	Resource

PROJINVOICECOST	fProjInvoiceCost
Source Field Name	Destination Field Name
PROJINVOICEID	ProjInvoiceID
INVOICEDATE	InvoiceDate
TRANSID	TransID
TXT	Txt
QTY	Qty
LINEAMOUNT	LineAmount
PROJID	ProjID
CATEGORYID	CategoryID
TRANSDATE	TransDate
DEFAULTDIMENSION	DefaultDimension
DATAAREAID	DataAreaID
RECID	RecID
PARTITION	Partition
RESOURCE_	Resource

PROJINVOICEITEM	fProjInvoiceItem
Source Field Name	Destination Field Name
PROJINVOICEID	ProjInvoiceID
INVOICEDATE	InvoiceDate
ITEMID	ItemID
LINEPERCENT	LinePercent
LINEDISC	LineDisc
LINEAMOUNT	LineAmount
SALESID	SalesID
PROJID	ProjID
CATEGORYID	CategoryID
TRANSDATE	TransDate
DATAAREAID	DataAreaID
RECID	RecID
PROJTRANSID	ProjTransID
INVENTTRANSID	InventTransID
QTY	Qty
PARTITION	Partition
DEFAULTDIMENSION	DefaultDimension

PROJINVOICEEMPL	dProjInvoiceEmpl
Source Field Name	Destination Field Name
PROJINVOICEID	ProjInvoiceID
INVOICEDATE	InvoiceDate
TRANSID	TransID
TXT	Txt
CURRENCYID	CurrencyID
QTY	Qty
LINEAMOUNT	LineAmount
PROJID	ProjID
CATEGORYID	CategoryID
TRANSDATE	TransDate
DEFAULTDIMENSION	DefaultDimension
WORKER	Worker
DATAAREAID	DataAreaID
RECID	RecID
PARTITION	Partition

PROJINVOICEEMPLDETAIL	fProjInvoiceEmplDetail
Source Field Name	Destination Field Name
INVOICEREFRECID	InvoiceRefRecID
SALEREFRECID	SaleRefRecID
SALESPRICE	SalesPrice
LINEAMOUNT	LineAmount
COSTVALUE	CostValue
DATAAREAID	DataAreaID
RECID	RecID
REFRECID	RefRecID
PARTITION	Partition

INVENTLOCATION	dInventLocation
Source Field Name	Destination Field Name
INVENTLOCATIONID	InventLocationID
NAME	Name
DATAAREAID	DataAreaID
RECID	RecID
PARTITION	Partition

PROJINVOICETABLE	dProjInvoiceTable
Source Field Name	Destination Field Name
PROJINVOICEPROJID	ProjInvoiceProjID
NAME	Name
PAYMENT	Payment
DATAAREAID	DataAreaID
RECID	RecID
PARTITION	Partition

PURCHTABLE	dPurchTable
Source Field Name	Destination Field Name
PURCHID	PurchID
PURCHNAME	PurchName
ORDERACCOUNT	OrderAccount
INVOICEACCOUNT	InvoiceAccount
DATAAREAID	DataAreaID
RECID	RecID
PARTITION	Partition

PROJTABLE	dProjTable
Source Field Name	Destination Field Name
PROJGROUPID	ProjGroupID
PROJID	ProjID
NAME	Name
STARTDATE	StartDate
ENDDATE	EndDate
CUSTACCOUNT	CustAccount
PARENTID	ParentID
HEADER	Header
STATUS	Status
TYPE	Type
JOBID	JobID
JOBPAYTYPE	JobPayType
DATAAREAID	DataAreaID
RECID	RecID
PROJINVOICEPROJID	ProjInvoiceProjID
PARTITION	Partition

PROJCATEGORY	dProjCategory
Source Field Name	Destination Field Name
CATEGORYID	CategoryID
NAME	Name
CATEGORYGROUPID	CategoryGroupID
CATEGORYTYPE	CategoryType
DATAAREAID	DataAreaID
RECID	RecID
PARTITION	Partition

PROJINVOICEJOUR	tProjInvoiceJour
Source Field Name	Destination Field Name
PROJGROUPID	ProjGroupID
CURRENCYID	CurrencyID
EXCHRATE	ExchRate
PROJINVOICEID	ProjInvoiceID
DATAAREAID	DataAreaID
RECID	RecID
PARTITION	Partition

VENDINVOICEJOUR	dVendInvoiceJour
Source Field Name	Destination Field Name
VENDGROUP	VendGroup
PURCHID	PurchID
ORDERACCOUNT	OrderAccount
INVOICEACCOUNT	InvoiceAccount
INVOICEID	InvoiceID
INVOICEDATE	InvoiceDate
DUEDATE	DueDate
QTY	Qty
SUMLINEDISC	SumLineDisc
CURRENCYCODE	CurrencyCode
EXCHRATE	ExchRate
DATAAREAID	DataAreaID
RECID	RecID
NUMBERSEQUENCEGROUP	NumberSequenceGroup
PARTITION	Partition

CUSTINVOICETRANS	fCustInvoiceTrans
Source Field Name	Destination Field Name
INVOICEID	InvoiceID
INVOICEDATE	InvoiceDate
LINENUM	LineNum
INVENTTRANSID	InventTransID
INVENTREFID	InventRefID
ITEMID	ItemID
NAME	Name
CURRENCYCODE	CurrencyCode
PRICEUNIT	PriceUnit
QTY	Qty
SALESPRICE	SalesPrice
DISCPERCENT	DiscPercent
DISCAMOUNT	DiscAmount
LINEAMOUNT	LineAmount
QTYPHYSICAL	QtyPhysical
SALESID	SalesID
LINEDISC	LineDisc
LINEPERCENT	LinePercent
DATAAREAID	DataAreaID
RECID	RecID
LINEAMOUNTTAX	LineAmountTax
LINEAMOUNTMST	LineAmountMST
NUMBERSEQUENCEGROUP	NumberSequenceGroup
PARTITION	Partition
DEFAULTDIMENSION	DefaultDimension
LEDGERDIMENSION	LedgerDimension
DLVDATE	DlvDate
INVENTQTY	InventQty
INVENTDIMID	InventDimID

CUSTINVOICEJOUR	dCustInvoiceJour
Source Field Name	Destination Field Name
SALESID	SalesID
ORDERACCOUNT	OrderAccount
INVOICEACCOUNT	InvoiceAccount
INVOICEDATE	InvoiceDate
DUEDATE	DueDate
QTY	Qty
INVOICEAMOUNT	InvoiceAmount
CURRENCYCODE	CurrencyCode
EXCHRATE	ExchRate
INVOICEID	InvoiceID
LEDGERVOUCHER	LedgerVoucher
DOCUMENTNUM	DocumentNum
NUMBERSEQUENCEGROUP	NumberSequenceGroup
DATAAREAID	DataAreaID
RECID	RecID
PARTITION	Partition

PROJACTIVITY	fProjActivity
Source Field Name	Destination Field Name
TXT	Txt
JOBID	JobID
DATAAREAID	DataAreaID
RECID	RecID
ACTIVITYNUMBER	ActivityNumber
PARTITION	Partition

VENDINVOICETRANS	fVendInvoiceTrans
Source Field Name	Destination Field Name
INVOICEID	InvoiceID
INVOICEDATE	InvoiceDate
LINENUM	LineNum
INVENTTRANSID	InventTransID
ITEMID	ItemID
CURRENCYCODE	CurrencyCode
PRICEUNIT	PriceUnit
QTY	Qty
PURCHPRICE	PurchPrice
DISCPERCENT	DiscPercent
DISCAMOUNT	DiscAmount
LINEAMOUNT	LineAmount
PURCHID	PurchID
LINEDISC	LineDisc
LINEPERCENT	LinePercent
NUMBERSEQUENCEGROUP	NumberSequenceGroup
DATAAREAID	DataAreaID
LINEAMOUNTMST	LineAmountMST
RECID	RecID
PARTITION	Partition
DEFAULTDIMENSION	DefaultDimension
LEDGERDIMENSION	LedgerDimension
INVENTDIMID	InventDimID
INVENTQTY	InventQty

SMMACTIVITIES	fSmmActivities
Source Field Name	Destination Field Name
CLOSED	Closed
PURPOSE	Purpose
ACTIVITYNUMBER	ActivityNumber
TYPEID	TypeID
PHASEID	PhaseID
CATEGORY	Category
SOURCE	Source
TASKPRIORITY	TaskPriority
DATAAREAID	DataAreaID
RECID	RecID
ACTUALENDDATETIME	ActualEndDateTime
ENDDATETIME	EndDateTime
PERCENTAGECOMPLETED	PercentageCompleted
PLANID	PlanID
STARTDATETIME	StartDateTime
PARTITION	Partition
RESPONSIBLEWORKER	ResponsibleWorker
DONEBYWORKER	DoneByWorker

INVENTSUM	tInventSum
Source Field Name	Destination Field Name
ITEMID	ItemID
POSTEDQTY	PostedQty
POSTEDVALUE	PostedValue
DEDUCTED	Deducted
RECEIVED	Received
RESERVPHYSICAL	ReservPhysical
RESERVORDERED	ReservOrdered
ONORDER	OnOrder
ORDERED	Ordered
QUOTATIONISSUE	QuotationIssue
QUOTATIONRECEIPT	QuotationReceipt
INVENTDIMID	InventDimID
CLOSED	Closed
REGISTERED	Registered
PICKED	Picked
AVAILORDERED	AvailOrdered
AVAILPHYSICAL	AvailPhysical
PHYSICALVALUE	PhysicalValue
ARRIVED	Arrived
PHYSICALINVENT	PhysicalInvent
CLOSEDQTY	ClosedQty
LASTUPDDATEPHYSICAL	LastUpdDatePhysical
LASTUPDDATEEXPECTED	LastUpdDateExpected
DATAAREAID	DataAreaID
RECID	RecID
PARTITION	Partition

PROJEMPLTRANS	fProjEmplTrans
Source Field Name	Destination Field Name
PROJID	ProjID
CATEGORYID	CategoryID
TRANSDATE	TransDate
TXT	Txt
QTY	Qty
CURRENCYID	CurrencyID
DATAAREAID	DataAreaID
RECID	RecID
DEFAULTDIMENSION	DefaultDimension
TOTALCOSTAMOUNTCUR	TotalCostAmountCur
TOTALSALESAMOUNTCUR	TotalSalesAmountCur
PARTITION	Partition
RESOURCE_	Resource
ACTIVITYNUMBER	ActivityNumber

PROJINVOICEONACC	fProjInvoiceOnAcc
Source Field Name	Destination Field Name
PROJINVOICEID	ProjInvoiceID
PROJID	ProjID
AMOUNT	Amount
INVOICEDATE	InvoiceDate
TXT	Txt
CURRENCYID	CurrencyID
TRANSDATE	TransDate
AMOUNTMST	AmountMST
DATAAREAID	DataAreaID
RECID	RecID
DEFAULTDIMENSION	DefaultDimension
QTY	Qty
PARTITION	Partition

PROJFORECASTEMPL	fProjForecastEmpl
Source Field Name	Destination Field Name
PROJID	ProjID
CATEGORYID	CategoryID
QTY	Qty
COSTPRICE	CostPrice
SALESPRICE	SalesPrice
MODELID	ModelID
TXT	Txt
CURRENCYID	CurrencyID
ACTIVE	Active
SCHEDTODATE	SchedToDate
SCHEDFROMDATE	SchedFromDate
SCHEDTIMEHOURS	SchedTimeHours
DATAAREAID	DataAreaID
RECID	RecID
DEFAULTDIMENSION	DefaultDimension
PARTITION	Partition
RESOURCE_	Resource
ACTIVITYNUMBER	ActivityNumber

PROJTRANSPOSTING	fProjTransPosting
Source Field Name	Destination Field Name
LEDGERTRANSDATE	LedgerTransDate
PROJID	ProjID
VOUCHER	Voucher
TRANSID	TransID
PROJTRANSDATE	ProjTransDate
PROJTRANSTYPE	ProjTransType
AMOUNTMST	AmountMST
COSTSALES	CostSales
DATAAREAID	DataAreaID
RECID	RecID
LEDGERDIMENSION	LedgerDimension
DEFAULTDIMENSION	DefaultDimension
PARTITION	Partition
RESOURCE_	Resource

SALESQUOTATIONLINE	fSalesQuotationLine
Source Field Name	Destination Field Name
LINENUM	LineNum
QUOTATIONID	QuotationID
INVENTTRANSID	InventTransID
ITEMID	ItemID
LINEAMOUNT	LineAmount
LINEDISC	LineDisc
LINEHEADER	LineHeader
LINEPERCENT	LinePercent
NAME	Name
QTYORDERED	QtyOrdered
SALESGROUP	SalesGroup
SALESQTY	SalesQty
SALESPRICE	SalesPrice
SALESUNIT	SalesUnit
QUOTATIONTYPE	QuotationType
COSTPRICE	CostPrice
CUSTOMERREF	CustomerRef
CUSTACCOUNT	CustAccount
PROJTRANSTYPE	ProjTransType
PROJCATEGORYID	ProjCategoryID
TRANSDATE	TransDate
COMPANY	Company
ACCOUNTTYPE	AccountType
QUOTATIONSTATUS	QuotationStatus
DATAAREAID	DataAreaID
RECID	RecID
LEDGERDIMENSION	LedgerDimension
DEFAULTDIMENSION	DefaultDimension
PARTITION	Partition

SALESQUOTATIONTABLE	dSalesQuotationTable
Source Field Name	Destination Field Name
DATAAREAID	DataAreaID
RECID	RecID
DEFAULTDIMENSION	DefaultDimension
WORKERSALESTAKER	WorkerSalesTaker
QUOTATIONID	QuotationID
QUOTATIONNAME	QuotationName
QUOTATIONEXPIRYDATE	QuotationExpiryDate
QUOTATIONTYPE	QuotationType
CONFIRMDATE	ConfirmDate
QUOTATIONSTATUS	QuotationStatus
QUOTATIONCATEGORY	QuotationCategory
CUSTACCOUNT	CustAccount
BUSRELACCOUNT	BusRelAccount
CONTACTPERSONID	ContactPersonID
REASONID	ReasonID
SALESIDREF	SalesIDRef
PROJIDREF	ProjIDRef
CAMPAIGNID	CampaignID
SALESORIGINID	SalesOriginID
INVOICEACCOUNT	InvoiceAccount
ESTIMATE	Estimate
PROJINVOICEPROJID	ProjInvoiceProjID
OPPORTUNITYID	OpportunityID
PARTITION	Partition
WORKERSALESRESPONSIBLE	WorkerSalesResponsible

SMMBUSRELTABLE	dSmmBusRelTable
Source Field Name	Destination Field Name
SALESDISTRICT	SalesDistrict
SEGMENT	Segment
STATUS	Status
BUSRELACCOUNT	BusRelAccount
SUBSEGMENT	SubSegment
BUSRELTYPEID	BusRelTypeID
CUSTGROUP	CustGroup
VENDGROUP	VendGroup
DATAAREAID	DataAreaID
RECID	RecID
PARTY	Party
DEFAULTDIMENSION	DefaultDimension
COMPANYNAFCODE	CompanyNAFCode
MAINCONTACTWORKER	MainContactWorker
PARTITION	Partition

SMMOPPORTUNITYTABLE	fSmmOpportunityTable
Source Field Name	Destination Field Name
OPPORTUNITYID	OpportunityID
SUBJECT	Subject
STATUS	Status
PARTY	Party
PROGNOSISID	PrognosisID
PROBABILITYID	ProbabilityID
SOURCEDESCRIPTION	SourceDescription
ESTIMATEDREVENUE	EstimatedRevenue
OPENEDDATE	OpenedDate
CLOSEDDATE	ClosedDate
SOURCEREFRECID	SourceRefRecID
PROCESSNAME	ProcessName
DAYSTOCLOSE	DaysToClose
SOURCETYPEID	SourceTypeID
CLOSEDBYWORKER	ClosedByWorker
OPENEDBYWORKER	OpenedByWorker
SOURCEREFTABLEID	SourceRefTableID
OWNERWORKER	OwnerWorker
DATAAREAID	DataAreaID
RECID	RecID
PARTITION	Partition

DIMENSIONATTRIBUTEVALUETOTALLINGCRITERIA	tDimensionAttributeValueTotallingCriteria
Source Field Name	Destination Field Name
DIMENSIONATTRIBUTEVALUE	DimensionAttributeValue
INVERTTOTALSIGN	InvertTotalSign
FROMVALUE	FromValue
TOVALUE	ToValue
RECID	RecID
PARTITION	Partition

DIMENSIONATTRIBUTEVALUE	tDimensionAttributeValue
Source Field Name	Destination Field Name
DIMENSIONATTRIBUTE	DimensionAttribute
ACTIVEFROM	ActiveFrom
ACTIVETO	ActiveTo
ISTOTAL	IsTotal
ENTITYINSTANCE	EntityInstance
GROUPDIMENSION	GroupDimension
HASHKEY	HashKey
RECID	RecID
ISDELETED	IsDeleted
ISSUSPENDED	IsSuspended
PARTITION	Partition

DIMENSIONATTRIBUTE	tDimensionAttribute
Source Field Name	Destination Field Name
NAME	Name
KEYATTRIBUTE	KeyAttribute
VALUEATTRIBUTE	ValueAttribute
NAMEATTRIBUTE	NameAttribute
BACKINGENTITYTYPE	BackingEntityType
REPORTCOLUMNNAME	ReportColumnName
HASHKEY	HashKey
TYPE	Type
BACKINGENTITYTABLENAME	BackingEntityTableName
BACKINGENTITYKEYFIELDNAME	BackingEntityKeyFieldName
BACKINGENTITYVALUEFIELDNAME	BackingEntityValueFieldName
BACKINGENTITYTABLEID	BackingEntityTableID
BACKINGENTITYKEYFIELDID	BackingEntityKeyFieldID
BACKINGENTITYVALUEFIELDID	BackingEntityValueFieldID
RECID	RecID
PARTITION	Partition

LOGISTICSADDRESSCOUNTRYREGION	dLogisticsAddressCountryRegion
Source Field Name	Destination Field Name
COUNTRYREGIONID	CountryRegionID
ISOCODE	ISOCode
CURRENCYCODE	CurrencyCode
RECID	RecID
PARTITION	Partition

DIRPARTYLOCATION	dDirPartyLocation
Source Field Name	Destination Field Name
PARTY	Party
LOCATION	Location
ISPOSTALADDRESS	IsPostalAddress
ISPRIMARY	IsPrimary
RECID	RecID
PARTITION	Partition

LOGISTICSPOSTALADDRESS	dLogisticsPostalAddress
Source Field Name	Destination Field Name
ADDRESS	Address
COUNTRYREGIONID	CountryRegionID
ZIPCODE	ZipCode
STATE	State
COUNTY	County
CITY	City
STREET	Street
STREETNUMBER	StreetNumber
CITYRECID	CityRecID
DISTRICT	District
LOCATION	Location
ZIPCODERECID	ZipCodeRecID
VALIDTO	ValidTo
VALIDFROM	ValidFrom
DISTRICTNAME	DistrictName
RECID	RecID
PARTITION	Partition

LOGISTICSLOCATION	dLogisticsLocation
Source Field Name	Destination Field Name
LOCATIONID	LocationID
DESCRIPTION	Description
ISPOSTALADDRESS	IsPostalAddress
RECID	RecID
PARENTLOCATION	ParentLocation
PARTITION	Partition

LOGISTICSADDRESSCOUNTRYREGIONTRANSLATION	dLogisticsAddressCountryRegionTranslation
Source Field Name	Destination Field Name
LONGNAME	LongName
SHORTNAME	ShortName
COUNTRYREGIONID	CountryRegionID
RECID	RecID
LANGUAGEID	LanguageID
PARTITION	Partition

SMMACTIVITYPARENTLINKTABLE	tSmmActivityParentLinkTable
Source Field Name	Destination Field Name
REFTABLEID	RefTableID
REFRECID	RefRecID
ACTIVITYNUMBER	ActivityNumber
PRIMARYLINK	PrimaryLink
PARENTTYPE	ParentType
DATAAREAID	DataAreaID
RECID	RecID
PARTITION	Partition

INVENTITEMGROUPITEM	dInventItemGroupItem
Source Field Name	Destination Field Name
ITEMID	ItemID
ITEMDATAAREAID	ItemDataAreaID
ITEMGROUPID	ItemGroupID
ITEMGROUPDATAAREAID	ItemGroupDataAreaID
RECID	RecID
PARTITION	Partition

SALESLINE	fSalesLine
Source Field Name	Destination Field Name
CREATEDDATETIME	CreateDatetime
LINENUM	LineNum
ITEMID	ItemID
SALESSTATUS	SalesStatus
NAME	Name
SALESPRICE	SalesPrice
CURRENCYCODE	CurrencyCode
LINEPERCENT	LinePercent
LINEDISC	LineDisc
LINEAMOUNT	LineAmount
PRICEUNIT	PriceUnit
INVENTTRANSID	InventTransID
MULTILNDISC	MultiLnDisc
MULTILNPERCENT	MultiLnPercent
INVENTREFID	InventRefID
DATAAREAID	DataAreaID
PARTITION	Partition
RECID	RecID
REMAINSALESPHYSICAL	RemainSalesPhysical
REMAINSALESFINANCIAL	RemainSalesFinancial
QTYORDERED	QtyOrdered
DEFAULTDIMENSION	DefaultDimension
SALESQTY	SalesQty
SHIPPINGDATEREQUESTED	ShippingDateRequested
SHIPPINGDATECONFIRMED	ShippingDateConfirmed
CONFIRMEDDLV	ConfirmedDlv
SALESID	SalesID
RECEIPTDATEREQUESTED	ReceiptDateRequested
RECEIPTDATECONFIRMED	ReceiptDateConfirmed
COSTPRICE	CostPrice
INVENTDIMID	InventDimID

EXCHANGERATE	tExchangeRate
Source Field Name	Destination Field Name
EXCHANGERATECURRENCYPAIR	ExchangeRateCurrencyPair
EXCHANGERATE	ExchangeRate
VALIDTO	ValidTo
VALIDFROM	ValidFrom
PARTITION	Partition
RECID	RecID

EXCHANGERATECURRENCYPAIR	tExchangeRateCurrencyPair
Source Field Name	Destination Field Name
FROMCURRENCYCODE	FromCurrencyCode
TOCURRENCYCODE	ToCurrencyCode
RECID	RecID
PARTITION	Partition

DIMENSIONATTRIBUTELEVELVALUE	tDimensionAttributeLevelValue
Source Field Name	Destination Field Name
ORDINAL	Ordinal
DISPLAYVALUE	DisplayValue
DIMENSIONATTRIBUTEVALUE	DimensionAttributeValue
DIMENSIONATTRIBUTEVALUEGROUP	DimensionAttributeValueGroup
RECVERSION	RecVersion
RECID	RecID
PARTITION	Partition

DIMENSIONATTRIBUTEVALUESET	tDimensionAttributeValueSet
Source Field Name	Destination Field Name
RECVERSION	RecVersion
RECID	RecID
PARTITION	Partition

DIMENSIONFINANCIALTAG	tDimensionFinancialTag
Source Field Name	Destination Field Name
DESCRIPTION	Description
VALUE	Value
FINANCIALTAGCATEGORY	FinancialTagCategory
RECVERSION	RecVersion
RECID	RecID
PARTITION	Partition

DIMENSIONATTRIBUTEVALUEGROUPCOMBINATION	tDimensionAttributeValueGroupCombination
Source Field Name	Destination Field Name
ORDINAL	Ordinal
DIMENSIONATTRIBUTEVALUECOMBINATION	DimensionAttributeValueCombination
DIMENSIONATTRIBUTEVALUEGROUP	DimensionAttributeValueGroup
RECVERSION	RecVersion
RECID	RecID
PARTITION	Partition

DIMENSIONATTRIBUTEVALUESETITEM	tDimensionAttributeValueSetItem
Source Field Name	Destination Field Name
DIMENSIONATTRIBUTEVALUESET	DimensionAttributeValueSet
DIMENSIONATTRIBUTEVALUE	DimensionAttributeValue
DISPLAYVALUE	DisplayValue
RECVERSION	RecVersion
RECID	RecID
PARTITION	Partition

RESOURCEWORKERVIEW	dResourceWorkerView
Source Field Name	Destination Field Name
PARTITION	Partition
RECID	RecID
WORKER	Worker
RESOURCEID	ResourceID
RESOURCECOMPANYID	ResourceCompanyID
NAME	Name