Microsoft Dynamics AX 7

Cubes

CRM

Bus Matrix

Activity Phase
Activity Type
Business Relation
Campaign
Company
Customer
Employee
Item
Log Action
Opportunity
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 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
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

Source Field Name Destination Field Name
ACCOUNTNUM AccountNum
CUSTGROUP CustGroup
CREDITMAX CreditMax
DATAAREAID DataAreaID
PARTY Party
SALESGROUP SalesGroup
RECID RecID
PARTITION Partition
DEFAULTDIMENSION DefaultDimension
Source Field Name Destination Field Name
ITEMGROUPID ItemGroupID
NAME Name
DATAAREAID DataAreaID
PARTITION Partition
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
Source Field Name Destination Field Name
SALESID SalesID
SALESNAME SalesName
CUSTACCOUNT CustAccount
DATAAREAID DataAreaID
WORKERSALESRESPONSIBLE WorkerSalesResponsible
PROJID ProjID
WORKERSALESTAKER WorkerSalesTaker
PARTITION Partition
SALESSTATUS SalesStatus
Source Field Name Destination Field Name
PERSON Person
PERSONNELNUMBER PersonnelNumber
RECID RecID
PARTITION Partition
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
Source Field Name Destination Field Name
PROBABILITYID ProbabilityID
DESCRIPTION Description
DATAAREAID DataAreaID
PARTITION Partition
Source Field Name Destination Field Name
ACCOUNTNUM AccountNum
VENDGROUP VendGroup
DATAAREAID DataAreaID
PARTY Party
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
TYPEID TypeID
TYPEDESCRIPTION TypeDescription
TABLETYPE TableType
DATAAREAID DataAreaID
PARTITION Partition
Source Field Name Destination Field Name
CATEGORYGROUPID CategoryGroupID
NAME Name
CATEGORYTYPE CategoryType
DATAAREAID DateAreaID
PARTITION Partition
Source Field Name Destination Field Name
CAMPAIGNGROUPDESCRIPTION CampaignGroupDescription
CAMPAIGNGROUPID CampaignGroupID
DATAAREAID DataAreaID
PARTITION Partition
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
Source Field Name Destination Field Name
DESCRIPTION Description
TYPEID TypeID
DATAAREAID DataAreaID
PARTITION Partition
Source Field Name Destination Field Name
REASONID ReasonID
DESCRIPTION Description
DATAAREAID DataAreaID
PARTITION Partition
Source Field Name Destination Field Name
DESCRIPTION Description
PHASEID PhaseID
DATAAREAID DataAreaID
PARTITION Partition
Source Field Name Destination Field Name
REASONID ReasonID
DESCRIPTION Description
DATAAREAID DataAreaID
PARTITION Partition
Source Field Name Destination Field Name
CAMPAIGNTYPEID CampaignTypeID
CAMPAIGNTYPEDESCRIPTION CampaignTypeDescription
DATAAREAID DataAreaID
PARTITION Partition
Source Field Name Destination Field Name
TYPEID TypeID
DESCRIPTION Description
DATAAREAID DataAreaID
PARTITION Partition
Source Field Name Destination Field Name
SYSTEMLANGUAGEID SystemLanguageID
CHARTOFACCOUNTSDELIMITER ChartOfAccountsDelimiter
SYSTEMCURRENCYCODE SystemCurrencyCode
SYSTEMEXCHANGERATETYPE SystemExchangeRateType
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
NAME Name
NAMEALIAS NameAlias
PARTYNUMBER PartyNumber
INSTANCERELATIONTYPE InstanceRelationType
KNOWNAS KnownAs
RELATIONTYPE RelationType
RECID RecID
PARTITION Partition
DATAAREA DataArea
Source Field Name Destination Field Name
DATAAREAID DataAreaID
GROUPID GroupID
NAME Name
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
DESCRIPTION Description
PROGNOSISID PrognosisID
DATAAREAID DataAreaID
PARTITION Partition
Source Field Name Destination Field Name
INVENTDIMID InventDimID
INVENTBATCHID InventBatchID
WMSLOCATIONID WmsLocationID
WMSPALLETID WmsPalletID
INVENTSERIALID InventSerialID
INVENTLOCATIONID InventLocationID
DATAAREAID DataAreaID
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
INVENTTRANSID InventTransID
REFERENCECATEGORY ReferenceCategory
REFERENCEID ReferenceID
ITEMID ItemID
ITEMINVENTDIMID ItemInventDimID
PARTY Party
DATAAREAID DataAreaID
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
ITEMID ItemID
ITEMTYPE ItemType
QTYPERLAYER QtyPerLayer
PRIMARYVENDORID PrimaryVendorID
DATAAREAID DataAreaID
RECID RecID
PRODUCT Product
PARTITION Partition
Source Field Name Destination Field Name
INSTANCERELATIONTYPE InstanceRelationType
DISPLAYPRODUCTNUMBER DisplayProductNumber
PRODUCTTYPE ProductType
RELATIONTYPE RelationType
RECID RecID
SEARCHNAME SearchName
PARTITION Partition
Source Field Name Destination Field Name
NAME Name
PRODUCT Product
LANGUAGEID LanguageID
RECID RecID
PARTITION Partition
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
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
Source Field Name Destination Field Name
CHARTOFACCOUNTS ChartOfAccounts
NAME Name
PRIMARYFORLEGALENTITY PrimaryForLegalEntity
FISCALCALENDAR FiscalCalendar
ACCOUNTINGCURRENCY AccountingCurrency
REPORTINGCURRENCY ReportingCurrency
RECID RecID
DESCRIPTION Description
PARTITION Partition
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
Source Field Name Destination Field Name
NAME Name
DESCRIPTION Description
MAINACCOUNTFORMATMASK MainAccountFormatMask
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
ACCOUNTCATEGORY AccountCategory
DESCRIPTION Description
ACCOUNTTYPE AccountType
CLOSED Closed
ACCOUNTCATEGORYREF AccountCategoryRef
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
DISPLAYVALUE DisplayValue
MAINACCOUNT MainAccount
ACCOUNTSTRUCTURE AccountStructure
LEDGERDIMENSIONTYPE LedgerDimensionType
HASH Hash
RECID RecID
PARTITION Partition
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
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
Source Field Name Destination Field Name
TXT Txt
TYPE Type
SUBMODELID SubmodelID
MODELID ModelID
RECID RecID
DATAAREAID DataAreaID
PARTITION Partition
Source Field Name Destination Field Name
STARTDATE StartDate
ENDDATE EndDate
FISCALCALENDAR FiscalCalendar
NAME Name
RECID RecID
PARTITION Partition
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
Source Field Name Destination Field Name
CALENDARID CalendarID
DESCRIPTION Description
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
CUSTGROUP CustGroup
NAME Name
DATAAREAID DataAreaID
PARTITION Partition
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
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
Source Field Name Destination Field Name
VENDGROUP VendGroup
NAME Name
DATAAREAID DataAreaID
PARTITION Partition
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
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
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
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
Source Field Name Destination Field Name
INVOICEREFRECID InvoiceRefRecID
SALEREFRECID SaleRefRecID
SALESPRICE SalesPrice
LINEAMOUNT LineAmount
COSTVALUE CostValue
DATAAREAID DataAreaID
RECID RecID
REFRECID RefRecID
PARTITION Partition
Source Field Name Destination Field Name
INVENTLOCATIONID InventLocationID
NAME Name
DATAAREAID DataAreaID
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
PROJINVOICEPROJID ProjInvoiceProjID
NAME Name
PAYMENT Payment
DATAAREAID DataAreaID
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
PURCHID PurchID
PURCHNAME PurchName
ORDERACCOUNT OrderAccount
INVOICEACCOUNT InvoiceAccount
DATAAREAID DataAreaID
RECID RecID
PARTITION Partition
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
Source Field Name Destination Field Name
CATEGORYID CategoryID
NAME Name
CATEGORYGROUPID CategoryGroupID
CATEGORYTYPE CategoryType
DATAAREAID DataAreaID
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
PROJGROUPID ProjGroupID
CURRENCYID CurrencyID
EXCHRATE ExchRate
PROJINVOICEID ProjInvoiceID
DATAAREAID DataAreaID
RECID RecID
PARTITION Partition
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
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
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
Source Field Name Destination Field Name
TXT Txt
JOBID JobID
DATAAREAID DataAreaID
RECID RecID
ACTIVITYNUMBER ActivityNumber
PARTITION Partition
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
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
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
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
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
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
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
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
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
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
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
Source Field Name Destination Field Name
DIMENSIONATTRIBUTEVALUE DimensionAttributeValue
INVERTTOTALSIGN InvertTotalSign
FROMVALUE FromValue
TOVALUE ToValue
RECID RecID
PARTITION Partition
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
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
Source Field Name Destination Field Name
COUNTRYREGIONID CountryRegionID
ISOCODE ISOCode
CURRENCYCODE CurrencyCode
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
PARTY Party
LOCATION Location
ISPOSTALADDRESS IsPostalAddress
ISPRIMARY IsPrimary
RECID RecID
PARTITION Partition
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
Source Field Name Destination Field Name
LOCATIONID LocationID
DESCRIPTION Description
ISPOSTALADDRESS IsPostalAddress
RECID RecID
PARENTLOCATION ParentLocation
PARTITION Partition
Source Field Name Destination Field Name
LONGNAME LongName
SHORTNAME ShortName
COUNTRYREGIONID CountryRegionID
RECID RecID
LANGUAGEID LanguageID
PARTITION Partition
Source Field Name Destination Field Name
REFTABLEID RefTableID
REFRECID RefRecID
ACTIVITYNUMBER ActivityNumber
PRIMARYLINK PrimaryLink
PARENTTYPE ParentType
DATAAREAID DataAreaID
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
ITEMID ItemID
ITEMDATAAREAID ItemDataAreaID
ITEMGROUPID ItemGroupID
ITEMGROUPDATAAREAID ItemGroupDataAreaID
RECID RecID
PARTITION Partition
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
Source Field Name Destination Field Name
EXCHANGERATECURRENCYPAIR ExchangeRateCurrencyPair
EXCHANGERATE ExchangeRate
VALIDTO ValidTo
VALIDFROM ValidFrom
PARTITION Partition
RECID RecID
Source Field Name Destination Field Name
FROMCURRENCYCODE FromCurrencyCode
TOCURRENCYCODE ToCurrencyCode
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
ORDINAL Ordinal
DISPLAYVALUE DisplayValue
DIMENSIONATTRIBUTEVALUE DimensionAttributeValue
DIMENSIONATTRIBUTEVALUEGROUP DimensionAttributeValueGroup
RECVERSION RecVersion
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
RECVERSION RecVersion
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
DESCRIPTION Description
VALUE Value
FINANCIALTAGCATEGORY FinancialTagCategory
RECVERSION RecVersion
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
ORDINAL Ordinal
DIMENSIONATTRIBUTEVALUECOMBINATION DimensionAttributeValueCombination
DIMENSIONATTRIBUTEVALUEGROUP DimensionAttributeValueGroup
RECVERSION RecVersion
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
DIMENSIONATTRIBUTEVALUESET DimensionAttributeValueSet
DIMENSIONATTRIBUTEVALUE DimensionAttributeValue
DISPLAYVALUE DisplayValue
RECVERSION RecVersion
RECID RecID
PARTITION Partition
Source Field Name Destination Field Name
PARTITION Partition
RECID RecID
WORKER Worker
RESOURCEID ResourceID
RESOURCECOMPANYID ResourceCompanyID
NAME Name