Microsoft Dynamics AX 4.0

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

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.Name
Type	dSmmBusRelTypeGroup.TypeDescription
Hierarchies
Business Relation Hierarchy
Level Name	Source Attribute	Description
Type	Type
Name	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
Name	fCustTable.Name
Number	fCustTable.AccountNum
Credit Limit Type	fCustTable.wCreditLimitID
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Customer	Name
CountryRegion
Level Name	Source Attribute	Description
Name	Country_Region Name
Customer	Name

Employee
Attributes
Name	Source	Description
Name	dEmplTable.Name

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

Log Action
Attributes
Name	Source	Description
Description	wdLogAction.LogActionDescription

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 Year	wdPostingPeriod.WeekYearName
Week	wdPostingPeriod.WeekName
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.ProjectIDName
Type	wdProjectType.TypeDescription

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

Vendor
Attributes
Name	Source	Description
Name	fVendTable.Name
Number	fVendTable.AccountNum
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 %	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 Quantity
Aggregate function	Sum
Source	fSalesLine.SalesQty
Visible to Users	True

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

Outstanding Quantity
Aggregate function	Sum
Source	fSalesLine.RemainSalesPhysical
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

Order Amount
Aggregate function	Sum
Source	fSalesLine.wLineAmountMST
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

Dimensions

Company
Attributes
Name	Source	Description
Name	dDataArea.Name

Customer
Attributes
Name	Source	Description
Name	fCustTable.Name
Number	fCustTable.AccountNum
Credit Limit Type	fCustTable.wCreditLimitID
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Customer	Name
CountryRegion
Level Name	Source Attribute	Description
Name	Country_Region 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 Year	wdPostingPeriod.WeekYearName
Week	wdPostingPeriod.WeekName
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	dEmplTable.Name

Item
Attributes
Name	Source	Description
Name	dInventTable.ItemName
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 Year	wdPostingPeriod.WeekYearName
Week	wdPostingPeriod.WeekName
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.ProjectIDName
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 Year	wdPostingPeriod.WeekYearName
Week	wdPostingPeriod.WeekName
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

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
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

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

Overdue Days
Aggregate function	Sum
Source	fCustTrans.wOverdueDays
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
Name	fCustTable.Name
Number	fCustTable.AccountNum
Credit Limit Type	fCustTable.wCreditLimitID
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Customer	Name
CountryRegion
Level Name	Source Attribute	Description
Name	Country_Region 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 Year	wdPostingPeriod.WeekYearName
Week	wdPostingPeriod.WeekName
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	Budget Submodel	Company	Period Code	Posting Period	Transaction Type
Amount Credited	x		x	x	x	x
Amount Debited	x		x	x	x	x
Amount Posted	x		x	x	x	x
Budget Amount	x	x	x		x
Budget Index	x	x	x		x
Budget Variance	x	x	x		x
End Balance	x		x	x	x	x
Quantity	x		x	x	x	x
Start Balance	x		x	x	x	x

Measures

Amount Posted
Aggregate function	Sum
Source	fLedgerTrans.AmountMST
Visible to Users	True

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

Amount Credited
Aggregate function	Sum
Source	fLedgerTrans.wAmountCreditMST
Visible to Users	True

Amount Debited
Aggregate function	Sum
Source	fLedgerTrans.wAmountDebitMST
Visible to Users	True

Calculations

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

Start Balance
Expression	[End Balance]-[Amount Posted]
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

Budget Amount
Expression	sum(filter({descendants([Budget Submodel].[Model Name].currentmember,[Budget Submodel].[Model Name])},isempty([wRecID])=0), [wBudgetAmount]))
Visible to Users	True

Dimensions

Account
Attributes
Name	Source	Description
Hierarchy	dLedgerTable.wParentAccountNum
Name	dLedgerTable.AccountName
Number	dLedgerTable.AccountNum
Number and Name	dLedgerTable.AccountNumName
Type	wdLedgerAccountType.Text

Budget Model
Attributes
Name	Source	Description
Budget Model Key	dBudgetModelHierarchy.Txt
Parent	dBudgetModelHierarchy.ParentID

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

Period Code
Attributes
Name	Source	Description
Code	wdPeriodCode.PeriodText

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 Year	wdPostingPeriod.WeekYearName
Week	wdPostingPeriod.WeekName
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 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 Year	wdPostingPeriod.WeekYearName
Week	wdPostingPeriod.WeekName
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
Name	fVendTable.Name
Number	fVendTable.AccountNum
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
Project Hours Actual	x	x	x		x	x
Project Hours Budget	x		x		x	x
Project Hours Index	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
Name	fCustTable.Name
Number	fCustTable.AccountNum
Credit Limit Type	fCustTable.wCreditLimitID
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Customer	Name
CountryRegion
Level Name	Source Attribute	Description
Name	Country_Region Name
Customer	Name

Employee
Attributes
Name	Source	Description
Name	dEmplTable.Name

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 Year	wdPostingPeriod.WeekYearName
Week	wdPostingPeriod.WeekName
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.ProjectIDName
Type	wdProjectType.TypeDescription

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	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.ItemName
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 Year	wdPostingPeriod.WeekYearName
Week	wdPostingPeriod.WeekName
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
Name	fVendTable.Name
Number	fVendTable.AccountNum
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Vendor	Name

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.ItemName
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 Year	wdPostingPeriod.WeekYearName
Week	wdPostingPeriod.WeekName
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
Name	fVendTable.Name
Number	fVendTable.AccountNum
Hierarchies
Group
Level Name	Source Attribute	Description
Name	Group Name
Vendor	Name

Data Transformations

LEDGERTRANS	fLedgerTrans
Source Field Name	Destination Field Name
ACCOUNTNUM	AccountNum
TRANSDATE	TransDate
VOUCHER	Voucher
TXT	Txt
AMOUNTMST	AmountMST
AMOUNTCUR	AmountCUR
CURRENCYCODE	CurrencyCode
TRANSTYPE	TransType
QTY	Qty
CREDITING	Crediting
PERIODCODE	PeriodCode
DATAAREAID	DataAreaID

LEDGERTABLE	dLedgerTable
Source Field Name	Destination Field Name
ACCOUNTNUM	AccountNum
ACCOUNTNAME	AccountName
ACCOUNTPLTYPE	AccountPLType
LEDGERCLOSING	LedgerClosing
OPENINGACCOUNT	OpeningAccount
COMPANYGROUPACCOUNT	CompanyGroupAccount
DATAAREAID	DataAreaID
RECID	RecID

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

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

CUSTTABLE	fCustTable
Source Field Name	Destination Field Name
ACCOUNTNUM	AccountNum
NAME	Name
CUSTGROUP	CustGroup
DATAAREAID	DataAreaID
CREDITMAX	CreditMax
COUNTRYREGIONID	CountryRegionID

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

INVENTTABLE	dInventTable
Source Field Name	Destination Field Name
ITEMGROUPID	ItemGroupID
ITEMID	ItemID
ITEMNAME	ItemName
ITEMTYPE	ItemType
QTYPERLAYER	QtyPerLayer
DATAAREAID	DataAreaID
PRIMARYVENDORID	PrimaryVendorID

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

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
LASTSETTLEDATE	LastSettleDate
CLOSED	Closed
TRANSTYPE	TransType
SETTLEMENT	Settlement
DATAAREAID	DataAreaID
DUEDATE	DelDueDate

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

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

SALESTABLE	dSalesTable
Source Field Name	Destination Field Name
SALESID	SalesID
SALESNAME	SalesName
CUSTACCOUNT	CustAccount
DATAAREAID	DataAreaID
SALESRESPONSIBLE	SalesResponsible
PROJID	ProjID
DELIVERYDATE	DeliveryDate
SALESSTATUS	SalesStatus
SALESTYPE	SalesType

ADDRESSCOUNTRYREGION	dAddressCountryRegion
Source Field Name	Destination Field Name
COUNTRYREGIONID	CountryRegionID
NAME	Name
DATAAREAID	DataAreaID

LEDGERBUDGET	fLedgerBudget
Source Field Name	Destination Field Name
ACCOUNTNUM	AccountNum
STARTDATE	StartDate
AMOUNT	Amount
CURRENCY	Currency
QTY	Qty
MODELNUM	ModelNum
DATAAREAID	DataAreaID

CONTACTPERSON	dContactPerson
Source Field Name	Destination Field Name
NAME	Name
CONTACTPERSONID	ContactPersonID
TITLE	Title
VENDACCOUNT	VendAccount
CUSTACCOUNT	CustAccount
DATAAREAID	DataAreaID
COUNTRYREGIONID	CountryRegionID
BUSRELACCOUNT	BusRelAccount
MAINRESPONSIBLE	CompanyContactID

EMPLTABLE	dEmplTable
Source Field Name	Destination Field Name
EMPLID	EmplID
NAME	Name
DATAAREAID	DataAreaID

SMMACTIVITIES	fSmmActivities
Source Field Name	Destination Field Name
CLOSED	Closed
APPOINTMENTSTARTDATE	AppointmentStartDate
PURPOSE	Purpose
ENDTIME	EndTime
STARTTIME	StartTime
BUSRELACCOUNT	BusRelAccount
RESPONSIBLEEMPLOYEE	ResponsibleEmployee
CONTACTPERSONID	ContactPersonID
ACTIVITYNUMBER	ActivityNumber
TYPEID	TypeID
PHASEID	PhaseID
CATEGORY	Category
SOURCE	Source
TASKPRIORITY	TaskPriority
SALESID	SalesID
QUOTATIONID	QuotationID
CAMPAIGNID	CampaignID
PROJID	ProjID
DATAAREAID	DataAreaID

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

SALESQUOTATIONLINE	fSalesQuotationLine
Source Field Name	Destination Field Name
LINENUM	LineNum
ITEMID	ItemID
NAME	Name
QTYORDERED	QtyOrdered
COSTPRICE	CostPrice
SALESPRICE	SalesPrice
LINEPERCENT	LinePercent
LINEDISC	LineDisc
LINEAMOUNT	LineAmount
SALESQTY	SalesQty
PROJCATEGORYID	ProjCategoryID
QUOTATIONID	QuotationID
QUOTATIONSTATUS	QuotationStatus
DATAAREAID	DataAreaID
INVENTTRANSID	InventTransID
LEDGERACCOUNT	LedgerAccount
LINEHEADER	LineHeader
SALESGROUP	SalesGroup
SALESUNIT	SalesUnit
QUOTATIONTYPE	QuotationType
CUSTOMERREF	CustomerRef
CUSTACCOUNT	CustAccount
PROGNOSISID	PrognosisID
PROBABILITYID	ProbabilityID
PROJTRANSTYPE	ProjTransType
PROJTRANSCODE	ProjTransCode
TRANSDATE	TransDate
ACCOUNTTYPE	AccountType
COMPANY	Ccompany

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

SALESQUOTATIONTABLE	dSalesQuotationTable
Source Field Name	Destination Field Name
QUOTATIONNAME	QuotationName
DATAAREAID	DataAreaID
CONTACTPERSONID	ContactPersonID
QUOTATIONID	QuotationID
BUSRELACCOUNT	BusRelAccount
QUOTATIONSTATUS	QuotationStatus
QUOTATIONEXPIRYDATE	QuotationExpiryDate
CAMPAIGNID	CampaignID
CUSTACCOUNT	CustAccount
SALESRESPONSIBLE	SalesResponsible
QUOTATIONTYPE	QuotationType
CONFIRMDATE	ConfirmDate
PHASEID	PhaseID
QUOTATIONCATEGORY	QuotationCategory
PROGNOSISDATE	PrognosisDate
PROGNOSISID	PrognosisID
PROBABILITYID	ProbabilityID
REASONID	ReasonID
SALESIDREF	SalesIDRef
PROJIDREF	ProjIDRef
SALESORIGINID	SalesOriginID
PROJINVOICEPROJID	ProjInvoiceProjID
ESTIMATE	Estimate
INVOICEACCOUNT	InvoiceAccount

VENDTABLE	fVendTable
Source Field Name	Destination Field Name
ACCOUNTNUM	AccountNum
NAME	Name
VENDGROUP	VendGroup
DATAAREAID	DataAreaID

SMMBUSRELTABLE	dSmmBusRelTable
Source Field Name	Destination Field Name
VENDACCOUNT	VendAccount
CUSTACCOUNT	CustAccount
SALESDISTRICT	SalesDistrict
NREMPLOYEES	NrEmployees
SEGMENT	Segment
STATUS	Status
ABC	ABC
BUSRELACCOUNT	BusRelAccount
RELATIONTYPE	RelationType
MAINCONTACT	MainContact
SUBSEGMENT	SubSegment
NAME	Name
BUSRELTYPEID	BusRelTypeID
DATAAREAID	DataAreaID

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

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
DATAAREAID	DataAreaID
NUMBERSEQUENCEGROUP	NumberSequenceGroup
SALESADMINISTRATOR	SalesAdministrator

PROJACTIVITY	fProjActivity
Source Field Name	Destination Field Name
ACTIVITYID	ActivityID
PROJID	ProjID
TXT	Txt
FINISHPERCENT	FinishPercent
JOBID	JobID
DATAAREAID	DataAreaID

PROJCOSTTRANS	fProjCostTrans
Source Field Name	Destination Field Name
PROJID	ProjID
CATEGORYID	CategoryID
TRANSDATE	TransDate
TXT	Txt
QTY	Qty
COSTPRICE	CostPrice
SALESPRICE	SalesPrice
TRANSID	TransID
DATAAREAID	DataAreaID

PROJINVOICECOST	fProjInvoiceCost
Source Field Name	Destination Field Name
PROJINVOICEID	ProjInvoiceID
INVOICEDATE	InvoiceDate
TXT	Txt
QTY	Qty
COSTAMOUNT	CostAmount
SALESPRICE	SalesPrice
LINEAMOUNT	LineAmount
PROJID	ProjID
CATEGORYID	CategoryID
TRANSDATE	TransDate
DATAAREAID	DataAreaID
TRANSID	TransID

PROJINVOICEEMPL	fProjInvoiceEmpl
Source Field Name	Destination Field Name
PROJINVOICEID	ProjInvoiceID
INVOICEDATE	InvoiceDate
TXT	Txt
QTY	Qty
COSTVALUE	CostValue
SALESPRICE	SalesPrice
LINEAMOUNT	LineAmount
PROJID	ProjID
EMPLID	EmplID
CATEGORYID	CategoryID
TRANSDATE	TransDate
ACTIVITYID	ActivityID
DATAAREAID	DataAreaID

PROJINVOICEITEM	fProjInvoiceItem
Source Field Name	Destination Field Name
PROJINVOICEID	ProjInvoiceID
INVOICEDATE	InvoiceDate
ITEMID	ItemID
COSTVALUE	CostValue
SALESPRICE	SalesPrice
LINEPERCENT	LinePercent
LINEDISC	LineDisc
SALESID	SalesID
PROJID	ProjID
CATEGORYID	CategoryID
DATAAREAID	DataAreaID
LINEAMOUNT	LineAmount

PROJINVOICEJOUR	tProjInvoiceJour
Source Field Name	Destination Field Name
PROJGROUPID	ProjGroupID
CURRENCYID	CurrencyID
EXCHRATE	ExchRate
PROJINVOICEID	InvoiceID
DATAAREAID	DataAreaID

PROJTABLE	dProjTable
Source Field Name	Destination Field Name
PROJGROUPID	ProjGroupID
PROJID	ProjID
NAME	Name
STARTDATE	StartDate
ENDDATE	EndDate
CUSTACCOUNT	CustAccount
STATUS	Status
TYPE	Type
JOBID	JobID
JOBPAYTYPE	JobPayType
DATAAREAID	DataAreaID
PARENTID	FatherID
PROJINVOICEPROJID	ProjInvoiceProjID

PROJCATEGORY	dProjCategory
Source Field Name	Destination Field Name
CATEGORYID	CategoryID
NAME	Name
CATEGORYGROUPID	CategoryGroupID
CATEGORYTYPE	CategoryType
DATAAREAID	DataAreaID

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

PROJINVOICETABLE	dProjInvoiceTable
Source Field Name	Destination Field Name
NAME	Name
PROJINVOICEPROJID	ProjInvoiceProjID
INVOICEACCOUNT	InvoiceAccount
PAYMENT	Payment
DATAAREAID	DataAreaID

PROJFORECASTEMPL	fProjForecastEmpl
Source Field Name	Destination Field Name
PROJID	ProjID
EMPLID	EmplID
CATEGORYID	CategoryID
QTY	Qty
COSTPRICE	CostPrice
SALESPRICE	SalesPrice
MODELID	ModelID
TXT	Txt
CURRENCYID	CurrencyID
ACTIVE	Active
SCHEDTODATE	SchedToDate
SCHEDFROMDATE	SchedFromDate
ACTIVITYID	ActivityID
SCHEDTIMEHOURS	SchedTimeHours
DATAAREAID	DataAreaID

PROJEMPLTRANS	fProjEmplTrans
Source Field Name	Destination Field Name
PROJID	ProjID
EMPLID	EmplID
CATEGORYID	CategoryID
TRANSDATE	TransDate
TXT	Txt
QTY	Qty
COSTPRICE	CostPrice
SALESPRICE	SalesPrice
CURRENCYID	CurrencyID
ACTIVITYID	ActivityID
DATAAREAID	DataAreaID

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

PROJONACCTRANS	fProjOnAccTrans
Source Field Name	Destination Field Name
PROJID	ProjID
TRANSDATE	TransDate
DESCRIPTION	Description
AMOUNT	Amount
OFFSETTRANSACTION	OffsetTransaction
TRANSID	TransID
CURRENCYID	CurrencyID
DATAAREAID	DataAreaID

SMMTRANSLOG	fSmmTransLog
Source Field Name	Destination Field Name
CONTACTPERSONID	ContactPersonID
BUSRELACCOUNT	BusRelAccount
EMPLOYEE	Employee
LOGTYPE	LogType
LOGDATE	LogDateTime
LOGACTION	LogAction
PRIMARYDESCRIPTION	PrimaryDescription
SALESUNITID	SalesUnitID
DATAAREAID	DataAreaID

SMMCAMPAIGNSELECTION	fSmmCampaignSelection
Source Field Name	Destination Field Name
CAMPAIGNID	CampaignID
BUSRELACCOUNT	BusRelAccount
CONTACTPERSONID	ContactPersonID
RESPONDED	Responded
ANSWERFREQUENCY	AnswerFrequency
NUMOFTARGETS	NumOfTargets
NAMEID	NameID
BROADCASTTYPE	BroadCastType
CAMPAIGNRESPONSE	CampaignResponse
DATAAREAID	DataAreaID

SMMQUOTATIONPHASEGROUP	dSmmQuotationPhaseGroup
Source Field Name	Destination Field Name
PHASEID	PhaseID
DESCRIPTION	Description
PHASESORTFIELD	PhaseSortField
DATAAREAID	DataAreaID

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

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

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

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

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

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

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

DIMENSIONS	tDimensions
Source Field Name	Destination Field Name
DESCRIPTION	Description
NUM	Num
DIMENSIONCODE	DimensionCode
DATAAREAID	DataAreaID

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

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
INVENTDIMID	InventDimID
INVENTQTY	InventQty

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
NUMBERSEQUENCEGROUP	NumberSequenceGroup

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
LASTSETTLEDATE	LastSettleDate
CLOSED	Closed
TRANSTYPE	TransType
DOCUMENTDATE	DocumentDate
DATAAREAID	DataAreaID
DUEDATE	DelDueDate

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

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

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

INVENTLOCATION	dInventLocation
Source Field Name	Destination Field Name
INVENTLOCATIONID	InventLocationID
NAME	Name
DATAAREAID	DataAreaID

LEDGERTABLEINTERVAL	tLedgerTableInterval
Source Field Name	Destination Field Name
ACCOUNTTABLEID	AccountTableID
ACCOUNTRECID	AccountRecID
FROMACCOUNT	FromAccount
TOACCOUNT	ToAccount
DATAAREAID	DataAreaID

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

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

EXCHRATE	tExchRates
Source Field Name	Destination Field Name
FROMDATE	FromDate
EXCHRATE	ExchRate
TODATE	ToDate
CURRENCYCODE	CurrencyCode
DATAAREAID	DataAreaID
RECID	RecID