Microsoft Business Solutions-Axapta 3.0

Cubes

CRM

Bus Matrix

Activity Phase
Activity Type
Business Relation
Campaign
Company
Customer
Employee
Item
Log Action
Posting Period
Project
Quotation
Vendor
Activity Count x x x x x x x x x x x
Log Count x x x x x
Quotation Amount x x x x x x x x x x
Quotation Quantity Ordered x x x x x x x x x x
Quotation Quantity Sold x x x x x x x x x x

Measures

Activity Count
Aggregate function Sum
Source fSmmActivities.wCount
Visible to Users True
Log Count
Aggregate function Sum
Source fSmmTransLog.wCount
Visible to Users True
Quotation Quantity Ordered
Aggregate function Sum
Source fSmmQuotationLine.QtyOrdered
Visible to Users True
Quotation Amount
Aggregate function Sum
Source fSmmQuotationLine.LineAmount
Visible to Users True
Quotation Quantity Sold
Aggregate function Sum
Source fSmmQuotationLine.SalesQty
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
Type dSmmBusRelTypeGroup.TypeDescription
Name dSmmBusRelTable.Name
Customer INTERMEDIATE dSmmBusRelTable.CustAccount
Hierarchies
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 Group Description
Campaign Name
Reason
Level Name Source Attribute Description
Description Reason Description
Campaign Name
Type
Level Name Source Attribute Description
Description Type Description
Campaign Name
Company
Attributes
Name Source Description
Name dDataArea.Name
Customer
Attributes
Name Source Description
Name fCustTable.Name
Credit Limit Type fCustTable.wHasCreditLimit
Number fCustTable.AccountNum
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Customer Name
CountryRegion
Level Name Source Attribute Description
Name CountryRegion 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
Year wdPostingPeriod.YearName
Quarter wdPostingPeriod.QuarterName
Month wdPostingPeriod.MonthName
Date wdPostingPeriod.DateName
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.Name
Type wdProjectType.TypeDescription
Quotation
Attributes
Name Source Description
Name dSmmQuotationTable.QuotationName
Hierarchies
Phase
Level Name Source Attribute Description
Description Phase Description
Quotation Name
Probability
Level Name Source Attribute Description
Description Probability Description
Quotation Name
Reason
Level Name Source Attribute Description
Description Reason Description
Quotation Name
Type
Level Name Source Attribute Description
Description Type Description
Quotation Name
Vendor
Attributes
Name Source Description
Name fVendTable.Name
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 Max x x
Credit Max Utilization x x x 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
Current Balance Overdue
Aggregate function Sum
Source fCustTrans.wCurrentBalanceOverDue
Visible to Users True
Current Balance Due
Aggregate function Sum
Source fCustTrans.wCurrentBalanceDue
Visible to Users True
Aging Days Overdue
Aggregate function Sum
Source fCustTrans.wAgingDaysOverdue
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 Max 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
Credit Limit Type fCustTable.wHasCreditLimit
Number fCustTable.AccountNum
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Customer Name
CountryRegion
Level Name Source Attribute Description
Name CountryRegion Name
Customer Name
Posting Period
Attributes
Name Source Description
Year wdPostingPeriod.YearName
Quarter wdPostingPeriod.QuarterName
Month wdPostingPeriod.MonthName
Date wdPostingPeriod.DateName
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
Inventory Trans Type
Item
Posting Period
Vendor
Inventory Value Primo x x x x x x x
Inventory Value Ultimo x x x x x x x
Net Sales x x x x x x x
Posted Inventory Value Primo x x x x x x x
Posted Inventory Value Ultimo x x x x x x x
Quantity x x x x x
Quantity Primo x x x x x x x
Quantity Ultimo x x x x x x x
Speed x x x x x x x
Speed per Year x 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
Hierarchy
Level Name Source Attribute Description
Direction Direction
Type Type
Inventory Trans Type
Attributes
Name Source Description
Inventory Trans Type Key fInventTrans.TransType
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
Year wdPostingPeriod.YearName
Quarter wdPostingPeriod.QuarterName
Month wdPostingPeriod.MonthName
Date wdPostingPeriod.DateName
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
Name fVendTable.Name
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Vendor Name

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
Year wdPostingPeriod.YearName
Quarter wdPostingPeriod.QuarterName
Month wdPostingPeriod.MonthName
Date wdPostingPeriod.DateName
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
Name fVendTable.Name
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
Cost x x x x x x x x x
Direct Order Cost 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
Order Margin x x x x x x x x
Order Margin % x x x x x x x x
Order Quantity x x x x x x x x
Outstanding Amount x x x x x x x x
Outstanding Quantity x x x x x x x x
Posted Order Cost 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
Shipped not Invoiced Quantity 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.wLineAmountMST
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

Dimensions

Company
Attributes
Name Source Description
Name dDataArea.Name
Customer
Attributes
Name Source Description
Name fCustTable.Name
Credit Limit Type fCustTable.wHasCreditLimit
Number fCustTable.AccountNum
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Customer Name
CountryRegion
Level Name Source Attribute Description
Name CountryRegion Name
Customer Name
Customer Invoice
Attributes
Name Source Description
Number dCustInvoiceJour.InvoiceID
Order Number dCustInvoiceJour.SalesID
Delivery Period
Attributes
Name Source Description
Year wdPostingPeriod.YearName
Quarter wdPostingPeriod.QuarterName
Month wdPostingPeriod.MonthName
Date wdPostingPeriod.DateName
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 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
Year wdPostingPeriod.YearName
Quarter wdPostingPeriod.QuarterName
Month wdPostingPeriod.MonthName
Date wdPostingPeriod.DateName
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.Name
Type wdProjectType.TypeDescription
Sales Order
Attributes
Name Source Description
Number dSalesTable.SalesID

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.wLineAmountMST
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
Year wdPostingPeriod.YearName
Quarter wdPostingPeriod.QuarterName
Month wdPostingPeriod.MonthName
Date wdPostingPeriod.DateName
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
Name fVendTable.Name
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 fProjBudgetEmplSplit.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
Credit Limit Type fCustTable.wHasCreditLimit
Number fCustTable.AccountNum
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Customer Name
CountryRegion
Level Name Source Attribute Description
Name CountryRegion Name
Customer Name
Employee
Attributes
Name Source Description
Name dEmplTable.Name
Invoice Entity
Attributes
Name Source Description
Entity wdProjInvoiceType.wInvoiceTypeDescription
Entity Name wdProjInvoiceType.wInvoiceTypeName
Hierarchies
Hierarchy
Level Name Source Attribute Description
Type Description Entity
Name Entity Name
Posting Period
Attributes
Name Source Description
Year wdPostingPeriod.YearName
Quarter wdPostingPeriod.QuarterName
Month wdPostingPeriod.MonthName
Date wdPostingPeriod.DateName
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.Name
Type wdProjectType.TypeDescription

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
Budget Amount
Aggregate function Sum
Source fLedgerBudget.Amount
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

Dimensions

Account
Attributes
Name Source Description
Hierarchy dLedgerTable.wParentAccountNum
Number dLedgerTable.AccountNum
Name dLedgerTable.AccountName
Number and Name dLedgerTable.AccountNumName
Type wdLedgerAccountType.Text
Budget Model
Attributes
Name Source Description
Model dBudgetModelHierarchy.Txt
Budget Submodel
Attributes
Name Source Description
Company Name dDataArea.Name
Txt dBudgetModel.Txt
Hierarchies
Hierarchy
Level Name Source Attribute Description
Company Name Company Name
Txt Txt
Company
Attributes
Name Source Description
Name dDataArea.Name
Period Code
Attributes
Name Source Description
Code wdPeriodCode.PeriodText
Posting Period
Attributes
Name Source Description
Year wdPostingPeriod.YearName
Quarter wdPostingPeriod.QuarterName
Month wdPostingPeriod.MonthName
Date wdPostingPeriod.DateName
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

Data Transformations

Source Field Name Destination Field Name
ACTIVITYID ActivityID
PROJID ProjID
TXT Txt
FINISHPERCENT FinishPercent
JOBID JobID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
NAME Name
PROJINVOICEPROJID ProjInvoiceProjID
INVOICEACCOUNT InvoiceAccount
PAYMENT Payment
DATAAREAID DataAreaID
Source Field Name Destination Field Name
PROJID ProjID
CATEGORYID CategoryID
TRANSDATE TransDate
TXT Txt
QTY Qty
COSTPRICE CostPrice
SALESPRICE SalesPrice
DATAAREAID DataAreaID
TRANSID TransID
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
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
Source Field Name Destination Field Name
PROJINVOICEID ProjInvoiceID
INVOICEDATE InvoiceDate
ITEMID ItemID
COSTVALUE CostValue
SALESPRICE SalesPrice
LINEPERCENT LinePercent
LINEDISC LineDisc
LINEAMOUNT LineAmount
SALESID SalesID
PROJID ProjID
CATEGORYID CategoryID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
PROJGROUPID ProjGroupID
CURRENCYID CurrencyID
EXCHRATE ExchRate
DATAAREAID DataAreaID
PROJINVOICEID InvoiceID
Source Field Name Destination Field Name
CATEGORYID CategoryID
NAME Name
CATEGORYGROUPID CategoryGroupID
CATEGORYTYPE CategoryType
DATAAREAID DataAreaID
Source Field Name Destination Field Name
CATEGORYGROUPID CategoryGroupID
NAME Name
CATEGORYTYPE CategoryType
DATAAREAID DataAreaID
Source Field Name Destination Field Name
PROJID ProjID
TRANSDATE TransDate
DESCRIPTION Description
AMOUNT Amount
OFFSETTRANSACTION OffsetTransaction
TRANSID TransID
CURRENCYID CurrencyID
DATAAREAID DataAreaID
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
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
Source Field Name Destination Field Name
LEDGERTRANSDATE LedgerTransDate
PROJID ProjID
VOUCHER Voucher
TRANSID TransID
PROJTRANSDATE ProjTransDate
PROJTRANSTYPE ProjTransType
AMOUNTMST AmountMST
COSTSALES CostSales
DATAAREAID DataAreaID
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
Source Field Name Destination Field Name
VENDGROUP VendGroup
NAME Name
DATAAREAID DataAreaID
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
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
DATAAREAID DataAreaID
NUMBERSEQUENCEGROUP NumberSequenceGroup
INVENTDIMID InventDimID
Source Field Name Destination Field Name
INVENTLOCATIONID InventLocationID
NAME Name
DATAAREAID DataAreaID
Source Field Name Destination Field Name
INVENTDIMID InventDimID
INVENTBATCHID InventBatchID
WMSLOCATIONID WmsLocationID
WMSPALLETID WmsPalletID
INVENTSERIALID InventSerialID
INVENTLOCATIONID InventLocationID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
ACCOUNTTABLEID AccountTableID
ACCOUNTRECID AccountRecID
FROMACCOUNT FromAccount
TOACCOUNT ToAccount
DATAAREAID DataAreaID
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
DEL_CONFIGID ConfigID
Source Field Name Destination Field Name
PURCHID PurchID
PURCHNAME PurchName
ORDERACCOUNT OrderAccount
INVOICEACCOUNT InvoiceAccount
DATAAREAID DataAreaID
Source Field Name Destination Field Name
DESCRIPTION Description
TYPEID TypeID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
DESCRIPTION Description
PHASEID PhaseID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
CAMPAIGNGROUPDESCRIPTION CampaignGroupDescription
CAMPAIGNGROUPID CampaignGroupID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
REASONID ReasonID
DESCRIPTION Description
DATAAREAID DataAreaID
Source Field Name Destination Field Name
CAMPAIGNTYPEID CampaignTypeID
CAMPAIGNTYPEDESCRIPTION CampaignTypeDescription
DATAAREAID DataAreaID
Source Field Name Destination Field Name
CONTACTPERSONID ContactPersonID
BUSRELACCOUNT BusRelAccount
EMPLOYEE Employee
LOGTYPE LogType
LOGTIME LogTime
LOGDATE LogDate
LOGACTION LogAction
PRIMARYDESCRIPTION PrimaryDescription
SALESUNITID SalesUnitID
DATAAREAID DataAreaID
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
Source Field Name Destination Field Name
SALESUNITMANAGERID SalesUnitManagerID
SALESUNITID SalesUnitID
SALESYEAR SalesYear
AMOUNTYEAR AmountYear
AMOUNTMONTH12 AmountMonth12
AMOUNTMONTH11 AmountMonth11
AMOUNTMONTH10 AmountMonth10
AMOUNTMONTH9 AmountMonth9
AMOUNTMONTH8 AmountMonth8
AMOUNTMONTH7 AmountMonth7
AMOUNTMONTH6 AmountMonth6
AMOUNTMONTH5 AmountMonth5
AMOUNTMONTH4 AmountMonth4
AMOUNTMONTH3 AmountMonth3
AMOUNTMONTH2 AmountMonth2
AMOUNTMONTH1 AmountMonth1
DATAAREAID DataAreaID
SALESMANID SalesMamID
Source Field Name Destination Field Name
TYPEID TypeID
DESCRIPTION Description
DATAAREAID DataAreaID
Source Field Name Destination Field Name
REASONID ReasonID
DESCRIPTION Description
DATAAREAID DataAreaID
Source Field Name Destination Field Name
PHASEID PhaseID
DESCRIPTION Description
PHASESORTFIELD PhaseSortField
DATAAREAID DataAreaID
Source Field Name Destination Field Name
DESCRIPTION Description
DIMENSIONCODE DimensionCode
DATAAREAID DataAreaID
NUM Num
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
DEL_COSTVALUE CostValue
NUMBERSEQUENCEGROUP NumberSequenceGroup
DLVDATE DlvDate
Source Field Name Destination Field Name
ITEMGROUPID ItemGroupID
ITEMID ItemID
ITEMNAME ItemName
ITEMTYPE ItemType
QTYPERLAYER QtyPerLayer
DATAAREAID DataAreaID
PRIMARYVENDORID PrimaryVendorID
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
DELCASHDISCDATE DelCashDiscDate
LASTSETTLEDATE LastSettleDate
CLOSED Closed
TRANSTYPE TransType
SETTLEMENT Settlement
DATAAREAID DataAreaID
DUEDATE DelDueDate
DEL_OPENTRANS OpenTrans
Source Field Name Destination Field Name
ITEMGROUPID ItemGroupID
NAME Name
DATAAREAID DataAreaID
Source Field Name Destination Field Name
ITEMID ItemID
STATUSISSUE StatusIssue
DATEPHYSICAL DatePhysical
COSTAMOUNTPOSTED CostAmountPosted
TRANSTYPE TransType
DATEFINANCIAL DateFinancial
COSTAMOUNTPHYSICAL CostAmountPhysical
DATAAREAID DataAreaID
STATUSRECEIPT StatusReceipt
QTY Qty
CURRENCYCODE CurrencyCode
INVOICEID InvoiceID
VOUCHER Voucher
DATEEXPECTED DateExpected
INVENTTRANSID InventTransID
COSTAMOUNTADJUSTMENT CostAmountAdjustment
QTYSETTLED QtySettled
COSTAMOUNTSETTLED CostAmountSettled
COSTAMOUNTSTD CostAmountStd
PACKINGSLIPRETURNED PackingSlipReturned
INVENTDIMID InventDimID
DIRECTION Direction
Source Field Name Destination Field Name
ACCOUNTNUM AccountNum
NAME Name
CUSTGROUP CustGroup
CREDITMAX CreditMax
DATAAREAID DataAreaID
COUNTRY Country
Source Field Name Destination Field Name
SALESID SalesID
SALESNAME SalesName
CUSTACCOUNT CustAccount
DATAAREAID DataAreaID
SALESRESPONSIBLE SalesResponsible
PROJID ProjID
DELIVERYDATE deliveryDate
SALESSTATUS SalesStatus
SALESTYPE SalesType
Source Field Name Destination Field Name
CUSTGROUP CustGroup
NAME Name
DATAAREAID DataAreaID
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
TOACCOUNT ToAccount
FROMACCOUNT FromAccount
DATAAREAID DataAreaID
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
DEL_COSTVALUE CostValue
SALESADMINISTRATOR SalesAdministrator
NUMBERSEQUENCEGROUP NumberSequenceGroup
Source Field Name Destination Field Name
TYPEDESCRIPTION TypeDescription
TABLETYPE TableType
DATAAREAID DataAreaID
TYPEID TypeID
Source Field Name Destination Field Name
NAME Name
ACCOUNTNUM AccountNum
DATAAREAID DataAreaID
Source Field Name Destination Field Name
SALESID SalesID
QUOTATIONNAME QuotationName
CONTACTPERSONID ContactPersonID
QUOTATIONTYPEID QuotationTypeID
QUOTATIONREASONID QuotationReasonID
QUOTATIONPROGNOSISID QuotationPrognosisID
QUOTATIONPROBABILITYID QuotationProbabilityID
QUOTATIONID QuotationID
BUSRELACCOUNT BusRelAccount
QUOTATIONSTATUS QuotationStatus
QUOTATIONFOLLOWUPDATE QuotationFollowUpdate
QUOTATIONDATE QuotationDate
QUOTATIONEXPIRYDATE QuotationExpiryDate
QUOTATIONFOLLOWUPACTIVITY QuotationFollowupActivity
AMOUNTTOTAL AmountTotal
PROJID ProjID
CAMPAIGNID CampaignID
VENDACCOUNT VendAccount
CUSTACCOUNT CustAccount
RELACCOUNT RelAccount
DATAAREAID DataAreaID
QUOTATIONPHASEID QuotationPhaseID
SALESRESPONSIBLE SalesResponsible
Source Field Name Destination Field Name
PROBABILITYID ProbabilityID
DESCRIPTION Description
DATAAREAID DataAreaID
Source Field Name Destination Field Name
LINENUM LineNum
ITEMID ItemID
NAME Name
QTYORDERED QtyOrdered
SALESDELIVERNOW SalesDeliverNow
REMAINSALESPHYSICAL RemainSalesPhysical
REMAINSALESFINANCIAL RemainSalesFinancial
COSTPRICE CostPrice
SALESPRICE SalesPrice
CURRENCYCODE CurrencyCode
LINEPERCENT LinePercent
LINEDISC LineDisc
LINEAMOUNT LineAmount
CONFIRMEDDLV ConfirmedDlv
CUSTGROUP CustGroup
SALESQTY SalesQty
SALESMARKUP SalesMarkup
COMPLETE Complete
PROJCATEGORYID ProjCategoryID
PROJID ProjID
QUOTATIONID QuotationID
QUOTATIONREASONID QuotationReasonID
QUOTATIONPROGNOSISID QuotationPrognosisID
QUOTATIONPROBABILITYID QuotationProbabilityID
QUOTATIONTYPEID QuotationTypeID
QUOTATIONMARKUP QuotationMarkup
BUSRELACCOUNT BusRelAccount
QUOTATIONSTATUS QuotationStatus
SALESSTATUS SalesStatus
PROGNOSISDATE PrognosisDate
SALESID SalesID
DATAAREAID DataAreaID
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
DATAAREAID DataAreaID
CAMPAIGNREASONID CampaignReasonID
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
CREATEDDATE CreatedDate
RECID RecID
NAME Name
REMAINSALESPHYSICAL RemainSalesPhysical
REMAINSALESFINANCIAL RemainSalesFinancial
PRICEUNIT PriceUnit
MULTILNDISC MultiLnDisc
MULTILNPERCENT MultiLnPercent
INVENTREFID InventRefID
COSTPRICE CostPrice
Source Field Name Destination Field Name
COUNTRY Country
NAME Name
CONTACTPERSONID ContactPersonID
TITLE Title
VENDACCOUNT VendAccount
CUSTACCOUNT CustAccount
RELACCOUNT RelAccount
DATAAREAID DataAreaID
DEL_COMPANYCONTACTID CompanyContactID
Source Field Name Destination Field Name
ACCOUNTNUM AccountNum
NAME Name
VENDGROUP VendGroup
DATAAREAID DataAreaID
Source Field Name Destination Field Name
RECID RecID
TXT Txt
TYPE Type
SUBMODELID SubmodelID
MODELID ModelID
DATAAREAID DataAreaID
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
PARENTACTIVITYNUMBER ParentActivityNumber
QUOTATIONID QuotationID
CAMPAIGNID CampaignID
PROJID ProjID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
EMPLID EmplID
NAME Name
DATAAREAID DataAreaID
Source Field Name Destination Field Name
RECID RecID
ACCOUNTNUM AccountNum
ACCOUNTNAME AccountName
ACCOUNTPLTYPE AccountPLType
LEDGERCLOSING LedgerClosing
OPENINGACCOUNT OpeningAccount
COMPANYGROUPACCOUNT CompanyGroupAccount
DATAAREAID DataAreaID
Source Field Name Destination Field Name
COUNTRYID CountryID
DATAAREAID DataAreaID
NAME Name
Source Field Name Destination Field Name
ACCOUNTNUM AccountNum
STARTDATE StartDate
AMOUNT Amount
CURRENCY Currency
QTY Qty
MODELNUM ModelNum
DATAAREAID DataAreaID
Source Field Name Destination Field Name
RELACCOUNT RelAccount
VENDACCOUNT VendAccount
CUSTACCOUNT CustAccount
SALESDISTRICT SalesDistrict
NREMPLOYEES NrEmployees
SEGMENT Segment
STATUS Status
ABC ABC
BUSRELACCOUNT BusRelAccount
RELATIONTYPE RelationType
MAINCONTACT MainContact
SUBSEGMENT SubSegment
NAME Name
DATAAREAID DataAreaID
BUSRELTYPEID BusRelTypeID
Source Field Name Destination Field Name
PROJINVOICEID ProjInvoiceID
PROJID ProjID
AMOUNT Amount
INVOICEDATE InvoiceDate
TXT Txt
CURRENCYID CurrencyID
TRANSDATE TransDate
AMOUNTMST AmountMST
DATAAREAID DataAreaID
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
PROJINVOICEPROJID ProjInvoiceProjID
PARENTID FatherID
Source Field Name Destination Field Name
FROMDATE FromDate
EXCHRATE ExchRate
TODATE ToDate
CURRENCYCODE CurrencyCode
DATAAREAID DataAreaID
RECID RecID