Microsoft Business Solutions Axapta 2.5

Cubes

Name	Quick Links
Finance
Customer Ledger	Overview	Measures	Dimensions
Vendor Ledger	Overview	Measures	Dimensions
General 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

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

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

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

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

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
LINEAMOUNT	LineAmount
SALESID	SalesID
PROJID	ProjID
CATEGORYID	CategoryID
DATAAREAID	DataAreaID

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SMMQUOTATIONTYPEGROUP	dSmmQuotationTypeGroup
Source Field Name	Destination Field Name
TYPEID	TypeID
DESCRIPTION	Description
DATAAREAID	DataAreaID

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

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

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

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
COSTVALUE	CostValue
DLVDATE	DlvDate

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

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
DELCASHDISCDATE	DelCashDiscDate
LASTSETTLEDATE	LastSettleDate
CLOSED	Closed
TRANSTYPE	TransType
SETTLEMENT	Settlement
DATAAREAID	DataAreaID
DELDUEDATE	DelDueDate
OPENTRANS	OpenTrans

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

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

CUSTTABLE	fCustTable
Source Field Name	Destination Field Name
ACCOUNTNUM	AccountNum
NAME	Name
CUSTGROUP	CustGroup
CREDITMAX	CreditMax
DATAAREAID	DataAreaID
COUNTRY	Country

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

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

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
TOACCOUNT	ToAccount
FROMACCOUNT	FromAccount
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
SALESADMINISTRATOR	SalesAdministrator
NUMBERSEQUENCEGROUP	NumberSequenceGroup
COSTVALUE	CostValue

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

SMMRELATIONTABLE	dSmmRelationTable
Source Field Name	Destination Field Name
NAME	Name
ACCOUNTNUM	AccountNum
DATAAREAID	DataAreaID

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

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

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

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
DATAAREAID	DataAreaID
CAMPAIGNREASONID	CampaignReasonID

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
RECID	RecID
NAME	Name
REMAINSALESPHYSICAL	RemainSalesPhysical
REMAINSALESFINANCIAL	RemainSalesFinancial
PRICEUNIT	PriceUnit
MULTILNDISC	MultiLnDisc
MULTILNPERCENT	MultiLnPercent
INVENTREFID	InventRefID
CREATEDDATE	CreatedDate
COSTPRICE	CostPrice

CONTACTPERSON	dContactPerson
Source Field Name	Destination Field Name
COUNTRY	Country
NAME	Name
CONTACTPERSONID	ContactPersonID
TITLE	Title
VENDACCOUNT	VendAccount
CUSTACCOUNT	CustAccount
RELACCOUNT	RelAccount
DATAAREAID	DataAreaID
COMPANYCONTACTID	CompanyContactID

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

BUDGETMODEL	dBudgetModel
Source Field Name	Destination Field Name
RECID	RecID
TXT	Txt
TYPE	Type
SUBMODELID	SubmodelID
MODELID	ModelID
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
PARENTACTIVITYNUMBER	ParentActivityNumber
QUOTATIONID	QuotationID
CAMPAIGNID	CampaignID
PROJID	ProjID
DATAAREAID	DataAreaID

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

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

COUNTRY	dCountry
Source Field Name	Destination Field Name
COUNTRYID	CountryID
DATAAREAID	DataAreaID
NAME	Name

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

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

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

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
PROJINVOICEPROJID	ProjInvoiceProjID
FATHERID	FatherID

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