Microsoft Dynamics NAV 3.01

Cubes

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

Customer Ledger

Bus Matrix

	Aging Bucket	Company	Credit Limit Type	Customer	Customer Ledger Entry	Due Period	Posting Period	SalespersonPurchaser	Source
Amount	x	x	x	x	x	x	x	x	x
Amount Credited	x	x	x	x	x	x	x	x	x
Amount Debited	x	x	x	x	x	x	x	x	x
Average number of Open Days	x	x	x	x	x	x	x	x	x
Average number of Overdue Days	x	x	x	x	x	x	x	x	x
Avg Customer Balance	x	x	x	x	x	x	x	x	x
Closed Amount	x	x	x	x	x	x	x	x	x
Closed Entry Count	x	x	x	x	x	x	x	x	x
Credit Limit		x	x	x				x
Credit Limit Utilization		x	x	x				x
Current Balance Due	x	x	x	x	x	x	x	x	x
Current Balance Overdue	x	x	x	x	x	x	x	x	x
Customer Balance	x	x	x	x	x	x	x	x	x
Limited Customer Balance	x	x	x	x	x	x	x	x	x
Overdue Entry Count	x	x	x	x	x	x	x	x	x
Sales	x	x	x	x	x	x	x	x	x
Tota number of Overdue Days	x	x	x	x	x	x	x	x	x
Total number of Open Days	x	x	x	x	x	x	x	x	x
Turnover Ratio	x	x	x	x	x	x	x	x	x

Measures

Amount
Aggregate function	Sum
Source	fDetailedCustLedgEntry.AmountLCY
Visible to Users	True

Amount Debited
Aggregate function	Sum
Source	fDetailedCustLedgEntry.DebitAmountLCY
Visible to Users	True

Amount Credited
Aggregate function	Sum
Source	fDetailedCustLedgEntry.CreditAmountLCY
Visible to Users	True

Total number of Open Days
Aggregate function	Sum
Source	fDetailedCustLedgEntry.wOpenDays
Visible to Users	True

Tota number of Overdue Days
Aggregate function	Sum
Source	fDetailedCustLedgEntry.wOverdueDays
Visible to Users	True

Closed Entry Count
Aggregate function	Sum
Source	fDetailedCustLedgEntry.wCountClosed
Visible to Users	True

Overdue Entry Count
Aggregate function	Sum
Source	fDetailedCustLedgEntry.wCountOverdue
Visible to Users	True

Closed Amount
Aggregate function	Sum
Source	fDetailedCustLedgEntry.wClosedAmountLCY
Visible to Users	True

Credit Limit
Aggregate function	Sum
Source	dCustomer.CreditLimitLCY
Visible to Users	True

Current Balance Due
Aggregate function	Sum
Source	fCustLedgerEntry.wRemainingAmountLCY
Visible to Users	True

Sales
Aggregate function	Sum
Source	fCustLedgerEntry.SalesLCY
Visible to Users	True

Current Balance Overdue
Aggregate function	Sum
Source	fCustLedgerEntry.wRemainingAmountOverdueLCY
Visible to Users	True

Calculations

Average number of Open Days
Expression	[Total number of Open Days]/[Closed Entry Count]
Visible to Users	True

Average number of Overdue Days
Expression	[Total number of Overdue Days]/[Overdue Entry Count]
Visible to Users	True

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

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

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

Avg Customer Balance
Expression	([Customer Balance]+[wCustomerOpeningBalance])/2
Visible to Users	True

Turnover Ratio
Expression	round([Sales]/[Avg Customer Balance],2)
Visible to Users	True

Dimensions

Aging Bucket
Attributes
Name	Source	Description
Group	wdAgingBucket.Text

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Credit Limit Type
Attributes
Name	Source	Description
Text	dCustomer.wHasCreditLimit

Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Number and Name	dCustomer.NoName
Credit Limit	dCustomer.wHasCreditLimit
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name

Customer Ledger Entry
Attributes
Name	Source	Description
Number	fCustLedgerEntry.EntryNo
Description	fCustLedgerEntry.Description
Document Type	wdJournalDocumentType.Text
Document Number	fCustLedgerEntry.DocumentNo

Due 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

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

SalespersonPurchaser
Attributes
Name	Source	Description
Name	dSalespersonPurchaser.Name

Source
Attributes
Name	Source	Description
Description	dSourceCode.Description

General Ledger

Bus Matrix

Account

Budget Name

Business Posting Group

Closing Entries

Company

Customer

General Ledger Detail

IncomeBalance

Job

Posting Period

Product Posting Group

Source

Vendor

Amount Credited

Amount Debited

Amount Posted

Budget Amount

Budget Index

Budget Variance

End Balance

Start Balance

Measures

Amount Posted
Aggregate function	Sum
Source	fGLEntry.Amount
Visible to Users	True

Amount Debited
Aggregate function	Sum
Source	fGLEntry.DebitAmount
Visible to Users	True

Amount Credited
Aggregate function	Sum
Source	fGLEntry.CreditAmount
Visible to Users	True

Budget Amount
Aggregate function	Sum
Source	fGLBudgetEntry.Amount
Visible to Users	True

Calculations

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

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

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

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

Dimensions

Account
Attributes
Name	Source	Description
Account Table	dGLAccount.Name
Number	dGLAccount.No
Name	dGLAccount.Name
Number and Name	dGLAccount.NoName
IncomeBalance	dGLAccount.wAccountGroup
Company and Account	dGLAccount.CompanyNoName

Budget Name
Attributes
Name	Source	Description
Name	dGLBudgetName.Description

Business Posting Group
Attributes
Name	Source	Description
Description	dGenBusinessPostingGroup.Description

Closing Entries
Attributes
Name	Source	Description
Text	wdPostingDateClosing.ClosingText

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Number and Name	dCustomer.NoName
Credit Limit	dCustomer.wHasCreditLimit
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name

General Ledger Detail
Attributes
Name	Source	Description
Number	fGLEntry.EntryNo
Type	wdGLSourceType.Text
Hierarchies
Number Group
Level Name	Source Attribute	Description
Range	wGroup
Number	Number

IncomeBalance
Attributes
Name	Source	Description
Text	dGLAccount.wAccountGroup

Job
Attributes
Name	Source	Description
Job Description	dJob.Description
Status	wdJobStatus.Text
Job Number	dJob.No
Job Number and Description	dJob.NumberName

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

Product Posting Group
Attributes
Name	Source	Description
Description	dGenProductPostingGroup.Description

Source
Attributes
Name	Source	Description
Description	dSourceCode.Description

Vendor
Attributes
Name	Source	Description
Vendor Number	dVendor.No
Vendor Name	dVendor.Name
Vendor Number and Name	dVendor.NoName
Hierarchies
Vendor Country
Level Name	Source Attribute	Description
Name	Country
Vendor	Vendor Name
Vendor Territory
Level Name	Source Attribute	Description
Name	Territory
Vendor	Vendor Name

Inventory

Bus Matrix

	Company	Customer	Inventory Entry Type	Inventory Posting Group	Item	Location	Posting Period	Source	Vendor
Cost of Sales	x	x	x	x	x	x	x	x	x
Cost posted to G/L	x	x	x	x	x	x	x	x	x
Days to sell Inventory	x	x	x	x	x	x	x	x	x
Days to sell Inventory (Yearly)	x	x	x	x	x	x	x	x	x
Inventory Value Average	x	x	x	x	x	x	x	x	x
Inventory Value Primo	x	x	x	x	x	x	x	x	x
Inventory Value Ultimo	x	x	x	x	x	x	x	x	x
Profit	x	x	x	x	x	x	x	x	x
Profit %	x	x	x	x	x	x	x	x	x
Quantity Changes	x	x	x		x	x	x		x
Quantity Decreases	x	x	x		x	x	x		x
Quantity in Stock Primo	x	x	x		x	x	x		x
Quantity in Stock Ultimo	x	x	x		x	x	x		x
Quantity Increases	x	x	x		x	x	x		x
Quantity Sold	x	x	x		x	x	x		x
Sales	x	x	x	x	x	x	x	x	x
Speed	x	x	x	x	x	x	x	x	x
Value Changes	x	x	x	x	x	x	x	x	x
Value Decreases	x	x	x	x	x	x	x	x	x
Value Increases	x	x	x	x	x	x	x	x	x
Yearly Speed	x	x	x	x	x	x	x	x	x

Measures

Calculations

Value Increases
Expression	([Inventory Main Entry Type].[Main Type].&[1],[Base Value])
Visible to Users	True

Value Decreases
Expression	([Inventory Main Entry Type].[Main Type].&[0],[Base Value])*(-1)
Visible to Users	True

Value Changes
Expression	[Value Increases]-[Value Decreases]
Visible to Users	True

Quantity Increases
Expression	([Inventory Main Entry Type].[Main Type].&[1],[Base Quantity])
Visible to Users	True

Quantity Decreases
Expression	([Inventory Main Entry Type].[Main Type].&[0],[Base Quantity])*(-1)
Visible to Users	True

Quantity Changes
Expression	[Quantity Increases]-[Quantity Decreases]
Visible to Users	True

Sales
Expression	([Inventory Main Entry Type].[Description].&[1],[Amount])*(-1)
Visible to Users	True

Cost of Sales
Expression	([Expected Cost].[Expected Cost].&[0],[Inventory Main Entry Type].[Description].&[1],[Adjusted Cost])*(-1)
Visible to Users	True

Quantity Sold
Expression	([Inventory Main Entry Type].[Description].&[1],[Quantity Changes])*(-1)
Visible to Users	True

Profit
Expression	[Sales]-[Cost of Sales]
Visible to Users	True

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

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

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

Quantity in Stock Ultimo
Function	End Balance
Expression	[Quantity Changes]
Visible to Users	True

Quantity in Stock Primo
Expression	[Quantity in Stock Ultimo]-[Quantity Changes]
Visible to Users	True

Inventory Value Average
Expression	([Inventory Value Primo]+[Inventory Value Ultimo])/2
Visible to Users	True

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

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

Cost posted to G/L
Expression	[Cost Posted to G_L]
Visible to Users	True

Days to sell Inventory
Expression	365/[Speed]
Visible to Users	True

Days to sell Inventory (Yearly)
Expression	365/[Yearly Speed]
Visible to Users	True

Dimensions

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Number and Name	dCustomer.NoName
Credit Limit	dCustomer.wHasCreditLimit
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name

Inventory Entry Type
Attributes
Name	Source	Description
Description	wdItemEntryType.EntryTypeDescription
Hierarchies
Main Type
Level Name	Source Attribute	Description
Description	wMainType
Type	Description

Inventory Posting Group
Attributes
Name	Source	Description
Description	dInventoryPostingGroup.Description

Item
Attributes
Name	Source	Description
Number	dItem.No
Description	dItem.Description
Number and Description	dItem.NoDescription
Hierarchies
Category
Level Name	Source Attribute	Description
Description	wCategory
Item	Description
Product Group
Level Name	Source Attribute	Description
Description	wProductGroup
Item	Description

Location
Attributes
Name	Source	Description
Name	dLocation.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

Source
Attributes
Name	Source	Description
Description	dSourceCode.Description

Valuation Method
Attributes
Name	Source	Description
Text	wdInventoryValuationMethod.Text

Vendor
Attributes
Name	Source	Description
Vendor Number	dVendor.No
Vendor Name	dVendor.Name
Vendor Number and Name	dVendor.NoName
Hierarchies
Vendor Country
Level Name	Source Attribute	Description
Name	Country
Vendor	Vendor Name
Vendor Territory
Level Name	Source Attribute	Description
Name	Territory
Vendor	Vendor Name

Job

Bus Matrix

Bill-to Customer

Business Posting Group

Company

Customer

Invoice Customer

Job

Job Phase

Job Step

Job Task

Posting Period

Product Posting Group

Sales Entity

SalespersonPurchaser

Ship-to Customer

Source

Budgeted Job Cost

Budgeted Job Price

Budgeted Job Quantity

Cost Budget Index

Cost Budget Variance

Excess Invoicing

Excess Invoicing %

Invoiced Cost

Invoiced Price

Invoiced Quantity

Job Ledger Cost

Job Ledger Price

Job Ledger Quantity

Price Budget Index

Price Budget Variance

Profit

Profit %

Quantity Budget Index

Quantity Budget Variance

Total Cost

Total Price

Total Quantity

Measures

Budgeted Job Quantity
Aggregate function	Sum
Source	fJobBudgetEntry.Quantity
Visible to Users	True

Budgeted Job Cost
Aggregate function	Sum
Source	fJobBudgetEntry.TotalCost
Visible to Users	True

Budgeted Job Price
Aggregate function	Sum
Source	fJobBudgetEntry.TotalPrice
Visible to Users	True

Job Ledger Quantity
Aggregate function	Sum
Source	fJobLedgerEntry.Quantity
Visible to Users	True

Job Ledger Cost
Aggregate function	Sum
Source	fJobLedgerEntry.TotalCost
Visible to Users	True

Job Ledger Price
Aggregate function	Sum
Source	fJobLedgerEntry.TotalPrice
Visible to Users	True

Calculations

Invoiced Price
Expression	[Invoice Amount]-[Credit Memo Amount]
Visible to Users	True

Invoiced Cost
Expression	[Invoice Cost]-[Credit Memo Cost]
Visible to Users	True

Invoiced Quantity
Expression	[Invoice Quantity]-[Credit Memo Quantity]
Visible to Users	True

Total Price
Expression	[Invoiced Price]+[Job Ledger Price]
Visible to Users	True

Total Cost
Expression	[Invoiced Cost]+[Job Ledger Cost]
Visible to Users	True

Total Quantity
Expression	[Invoiced Quantity]+[Job Ledger Quantity]
Visible to Users	True

Excess Invoicing
Expression	[Total Price]-[Invoiced Price]
Visible to Users	True

Profit
Expression	[Invoiced Price]-[Total Cost]
Visible to Users	True

Profit %
Expression	([Profit]/[Invoiced Price])*100
Visible to Users	True

Excess Invoicing %
Expression	([Invoiced Price]/[Total Price])*100
Visible to Users	True

Price Budget Variance
Expression	[Invoiced Price]-[Budgeted Job Price]
Visible to Users	True

Cost Budget Variance
Expression	[Budgeted Job Cost]-[Total Cost]
Visible to Users	True

Price Budget Index
Expression	([Invoiced Price]/[Budgeted Job Price])*100
Visible to Users	True

Cost Budget Index
Expression	([Budgeted Job Cost]/[Total Cost])*100
Visible to Users	True

Quantity Budget Variance
Expression	[Budgeted Job Quantity]-[Total Quantity]
Visible to Users	True

Quantity Budget Index
Expression	iif ([Total Quantity]=0, null, ([Budgeted Job Quantity]/[Total Quantity])*100)
Visible to Users	True

Dimensions

Bill-to Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Number and Name	dCustomer.NoName
Credit Limit	dCustomer.wHasCreditLimit
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name

Business Posting Group
Attributes
Name	Source	Description
Description	dGenBusinessPostingGroup.Description

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Number and Name	dCustomer.NoName
Credit Limit	dCustomer.wHasCreditLimit
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name

Invoice Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Number and Name	dCustomer.NoName
Credit Limit	dCustomer.wHasCreditLimit
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name

Job
Attributes
Name	Source	Description
Job Description	dJob.Description
Status	wdJobStatus.Text
Job Number	dJob.No
Job Number and Description	dJob.NumberName

Job Phase
Attributes
Name	Source	Description
Description	dPhase.Description

Job Step
Attributes
Name	Source	Description
Description	dStep.Description

Job Task
Attributes
Name	Source	Description
Description	dTask.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

Product Posting Group
Attributes
Name	Source	Description
Description	dGenProductPostingGroup.Description

Sales Credit Memo
Attributes
Name	Source	Description
Number	dSalesCrMemoHeader.No

Sales Entity
Attributes
Name	Source	Description
Description	wdItemResource.Description
Number	wdItemResource.No
Number and Description	wdItemResource.NoDescription
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Sales Entity	Sales Entity
Number and Description	Number and Description

Sales Invoice
Attributes
Name	Source	Description
Number	dSalesInvoiceHeader.No

SalespersonPurchaser
Attributes
Name	Source	Description
Name	dSalespersonPurchaser.Name

Ship-to Customer
Attributes
Name	Source	Description
Type	wdShiptoType.Text
Name	dShiptoAddress.Name
Country	dCountry.Name
Code	dShiptoAddress.Code
Hierarchies
Country Hierarchy
Level Name	Source Attribute	Description
Country	Country
Name	Name

Source
Attributes
Name	Source	Description
Description	dSourceCode.Description

Opportunity Entry

Bus Matrix

Campaign

Campaign Status

Chance of Success

Closed Opportunity Description

Company

Completion

Contact

Opportunity

Opportunity Entry Active

Posting Period

Probability

Sales Cycle

Sales Cycle Stage

SalespersonPurchaser

Calculated Current Value

Chance of Success (Avg.)

Completion (Avg.)

Estimated Value

Opportunity Entry Count

Probability (Avg.)

Measures

Estimated Value
Aggregate function	Sum
Source	fOpportunityEntry.EstimatedValue_x0028_LCY_x0029_
Visible to Users	True

Calculated Current Value
Aggregate function	Sum
Source	fOpportunityEntry.CalcdCurrentValueLCY
Visible to Users	True

Opportunity Entry Count
Aggregate function	Sum
Source	fOpportunityEntry.wCount
Visible to Users	True

Calculations

Chance of Success (Avg.)
Expression	[Chances of Success Pct base]/[Opportunity Entry Count]
Visible to Users	True

Probability (Avg.)
Expression	[Probability Pct base]/[Opportunity Entry Count]
Visible to Users	True

Completion (Avg.)
Expression	[Probability Pct base]/[Opportunity Entry Count]
Visible to Users	True

Dimensions

Campaign
Attributes
Name	Source	Description
Campaign Description	dCampaign.Description
Campaign Status	dCampaignStatus.Description
Campaign Number	dCampaign.No

Campaign Status
Attributes
Name	Source	Description
Campaign Description	dCampaign.Description
Campaign Status	dCampaignStatus.Description
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Campaign Status	Campaign Status
Campaign Description	Campaign Description

Chance of Success
Attributes
Name	Source	Description
Percentage	fOpportunityEntry.ChancesofSuccessPercentage

Closed Opportunity Description
Attributes
Name	Source	Description
Description	dCloseOpportunityCode.Description

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Completion
Attributes
Name	Source	Description
Percentage	fOpportunityEntry.CompletedPercentage

Contact
Attributes
Name	Source	Description
Number	dContact.No
Name	dContact.Name
Number and Name	dContact.NoName

Opportunity
Attributes
Name	Source	Description
Description	dOpportunity.Description
Closed	wdOpportunityClosed.Text
Priority	wdOpportunityPriority.Text
Status	wdOpportunityStatus.Text

Opportunity Entry Active
Attributes
Name	Source	Description
Description	wdOpportunityActive.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

Probability
Attributes
Name	Source	Description
Percentage	fOpportunityEntry.ProbabilityPercentage

Sales Cycle
Attributes
Name	Source	Description
Description	dSalesCycle.Description

Sales Cycle Stage
Attributes
Name	Source	Description
Description	dSalesCycleStage.Description

SalespersonPurchaser
Attributes
Name	Source	Description
Name	dSalespersonPurchaser.Name

Purchase

Bus Matrix

Business Posting Group

Company

Invoice Vendor

Item

Job

Order Period

Posting Period

Product Posting Group

Purchase Credit Memo

Purchase Entity

Purchase Invoice

Purchase Order

SalespersonPurchaser

Source

Vendor

Average Cost Price

Credit Memo Amount

Credit Memo Quantity

Invoice Amount

Invoice Quantity

Order Amount

Order Quantity

Outstanding Amount

Outstanding Quantity

Purchase

Quantity

Total Average Cost Price

Total Purchase

Total Quantity

Measures

Credit Memo Quantity
Aggregate function	Sum
Source	fPurchCrMemoLine.Quantity
Visible to Users	True

Credit Memo Amount
Aggregate function	Sum
Source	fPurchCrMemoLine.wAmountLCY
Visible to Users	True

Invoice Quantity
Aggregate function	Sum
Source	fPurchInvLine.Quantity
Visible to Users	True

Invoice Amount
Aggregate function	Sum
Source	fPurchInvLine.wAmountLCY
Visible to Users	True

Order Quantity
Aggregate function	Sum
Source	fPurchaseLine.Quantity
Visible to Users	True

Order Amount
Aggregate function	Sum
Source	fPurchaseLine.wLineAmountLCY
Visible to Users	True

Outstanding Amount
Aggregate function	Sum
Source	fPurchaseLine.wOutstandingAmountLCY
Visible to Users	True

Outstanding Quantity
Aggregate function	Sum
Source	fPurchaseLine.wOutstandingQuantity
Visible to Users	True

Calculations

Purchase
Expression	[Invoice Amount]-[Credit Memo Amount]
Visible to Users	True

Quantity
Expression	[Invoice Quantity]-[Credit Memo Quantity]
Visible to Users	True

Average Cost Price
Expression	([Purchase]/[Quantity])
Visible to Users	True

Total Purchase
Expression	[Purchase] + [Outstanding Amount]
Visible to Users	True

Total Quantity
Expression	[Quantity] + [Outstanding Quantity]
Visible to Users	True

Total Average Cost Price
Expression	[Total Purchase]/[Total Quantity]
Visible to Users	True

Dimensions

Business Posting Group
Attributes
Name	Source	Description
Description	dGenBusinessPostingGroup.Description

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Invoice Vendor
Attributes
Name	Source	Description
Vendor Number	dVendor.No
Vendor Name	dVendor.Name
Vendor Number and Name	dVendor.NoName
Hierarchies
Vendor Country
Level Name	Source Attribute	Description
Name	Country
Vendor	Vendor Name
Vendor Territory
Level Name	Source Attribute	Description
Name	Territory
Vendor	Vendor Name

Item
Attributes
Name	Source	Description
Number	dItem.No
Description	dItem.Description
Number and Description	dItem.NoDescription
Hierarchies
Category
Level Name	Source Attribute	Description
Description	wCategory
Item	Description
Product Group
Level Name	Source Attribute	Description
Description	wProductGroup
Item	Description

Job
Attributes
Name	Source	Description
Job Description	dJob.Description
Status	wdJobStatus.Text
Job Number	dJob.No
Job Number and Description	dJob.NumberName

Order 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

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

Product Posting Group
Attributes
Name	Source	Description
Description	dGenProductPostingGroup.Description

Purchase Credit Memo
Attributes
Name	Source	Description
Number	dPurchCrMemoHdr.No

Purchase Entity
Attributes
Name	Source	Description
Number	wdItemAsset.No
Description	wdItemAsset.Description
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Type	Type
Description	Description

Purchase Invoice
Attributes
Name	Source	Description
Number	dPurchInvHeader.No

Purchase Order
Attributes
Name	Source	Description
Number	dPurchaseHeader.No

SalespersonPurchaser
Attributes
Name	Source	Description
Name	dSalespersonPurchaser.Name

Source
Attributes
Name	Source	Description
Description	dSourceCode.Description

Vendor
Attributes
Name	Source	Description
Vendor Number	dVendor.No
Vendor Name	dVendor.Name
Vendor Number and Name	dVendor.NoName
Hierarchies
Vendor Country
Level Name	Source Attribute	Description
Name	Country
Vendor	Vendor Name
Vendor Territory
Level Name	Source Attribute	Description
Name	Territory
Vendor	Vendor Name

Sales

Bus Matrix

Bill-to Customer

Business Posting Group

Company

Customer

Invoice Customer

Item

Job

Order Period

Posting Period

Product Posting Group

Sales Credit Memo

Sales Entity

Sales Invoice

Sales Order

SalespersonPurchaser

Shipment Period

Ship-to Customer

Source

Cost

Credit Memo Amount

Credit Memo Cost

Credit Memo Quantity

Number of Credit Memos

Number of Invoices

Number of Open Orders

Order Amount

Order Cost

Order Profit

Order Profit %

Order Quantity

Outstanding Amount

Outstanding Cost

Outstanding Profit

Outstanding Profit %

Outstanding Quantity

Profit

Profit %

Quantity

Sales

Sales Invoice Amount

Sales Invoice Cost

Sales Invoice Quantity

Shipped not Invoiced Amount

Shipped not Invoiced Quantity

Total Cost

Total Profit

Total Profit %

Total Quantity

Total Sales

Measures

Credit Memo Quantity
Aggregate function	Sum
Source	fSalesCrMemoLine.Quantity
Visible to Users	True

Credit Memo Amount
Aggregate function	Sum
Source	fSalesCrMemoLine.wAmountLCY
Visible to Users	True

Credit Memo Cost
Aggregate function	Sum
Source	fSalesCrMemoLine.Cost
Visible to Users	True

Sales Invoice Quantity
Aggregate function	Sum
Source	fSalesInvoiceLine.Quantity
Visible to Users	True

Sales Invoice Amount
Aggregate function	Sum
Source	fSalesInvoiceLine.wAmountLCY
Visible to Users	True

Sales Invoice Cost
Aggregate function	Sum
Source	fSalesInvoiceLine.Cost
Visible to Users	True

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

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

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

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

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

Outstanding Cost
Aggregate function	Sum
Source	fSalesLine.wOutstandingCostLCY
Visible to Users	True

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

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

Number of Credit Memos
Aggregate function	DistinctCount
Source	fSalesCrMemoLine.wCreditMemoCount
Visible to Users	True

Number of Invoices
Aggregate function	DistinctCount
Source	fSalesInvoiceLine.wSalesInvoiceCount
Visible to Users	True

Number of Open Orders
Aggregate function	DistinctCount
Source	fSalesLine.wSalesCount
Visible to Users	True

Calculations

Sales
Expression	[Sales Invoice Amount]-[Credit Memo Amount]
Visible to Users	True

Cost
Expression	[Sales Invoice Cost]-[Credit Memo Cost]
Visible to Users	True

Quantity
Expression	[Sales Invoice Quantity]-[Credit Memo Quantity]
Visible to Users	True

Profit
Expression	[Sales]-[Cost]
Visible to Users	True

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

Order Profit
Expression	[Order Amount]-[Order Cost]
Visible to Users	True

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

Outstanding Profit
Expression	[Outstanding Amount]-[Outstanding Cost]
Visible to Users	True

Outstanding Profit %
Expression	([Outstanding Profit]/[Outstanding Amount])*100
Visible to Users	True

Total Sales
Expression	[Sales]+[Outstanding Amount]
Visible to Users	True

Total Cost
Expression	[Cost]+[Outstanding Cost]
Visible to Users	True

Total Quantity
Expression	[Quantity]+[Outstanding Quantity]
Visible to Users	True

Total Profit
Expression	[Total Sales]-[Total Cost]
Visible to Users	True

Total Profit %
Expression	([Total Profit]/[Total Sales])*100
Visible to Users	True

Dimensions

Bill-to Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Number and Name	dCustomer.NoName
Credit Limit	dCustomer.wHasCreditLimit
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name

Business Posting Group
Attributes
Name	Source	Description
Description	dGenBusinessPostingGroup.Description

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Number and Name	dCustomer.NoName
Credit Limit	dCustomer.wHasCreditLimit
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name

Invoice Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Number and Name	dCustomer.NoName
Credit Limit	dCustomer.wHasCreditLimit
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name

Item
Attributes
Name	Source	Description
Number	dItem.No
Description	dItem.Description
Number and Description	dItem.NoDescription
Hierarchies
Category
Level Name	Source Attribute	Description
Description	wCategory
Item	Description
Product Group
Level Name	Source Attribute	Description
Description	wProductGroup
Item	Description

Job
Attributes
Name	Source	Description
Job Description	dJob.Description
Status	wdJobStatus.Text
Job Number	dJob.No
Job Number and Description	dJob.NumberName

Order 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

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

Product Posting Group
Attributes
Name	Source	Description
Description	dGenProductPostingGroup.Description

Sales Credit Memo
Attributes
Name	Source	Description
Number	dSalesCrMemoHeader.No

Sales Entity
Attributes
Name	Source	Description
Description	wdItemResource.Description
Number	wdItemResource.No
Number and Description	wdItemResource.NoDescription
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Sales Entity	Sales Entity
Number and Description	Number and Description

Sales Invoice
Attributes
Name	Source	Description
Number	dSalesInvoiceHeader.No

Sales Order
Attributes
Name	Source	Description
Number	dSalesHeader.No

SalespersonPurchaser
Attributes
Name	Source	Description
Name	dSalespersonPurchaser.Name

Shipment 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

Ship-to Customer
Attributes
Name	Source	Description
Type	wdShiptoType.Text
Name	dShiptoAddress.Name
Country	dCountry.Name
Code	dShiptoAddress.Code
Hierarchies
Country Hierarchy
Level Name	Source Attribute	Description
Country	Country
Name	Name

Source
Attributes
Name	Source	Description
Description	dSourceCode.Description

Vendor Ledger

Bus Matrix

	Company	Due Period	Posting Period	SalespersonPurchaser	Source	Vendor	Vendor Ledger Entry
Amount	x	x	x	x	x	x	x
Amount Credited	x	x	x	x	x	x	x
Amount Debited	x	x	x	x	x	x	x
Average number of Open Days	x	x	x	x	x	x	x
Average number of Overdue Days	x	x	x	x	x	x	x
Closed Entry Count	x	x	x	x	x	x	x
Overdue Entry Count	x	x	x	x	x	x	x
Total number of Open Days	x	x	x	x	x	x	x
Total number of Overdue Days	x	x	x	x	x	x	x
Vendor Balance	x	x	x	x	x	x	x

Measures

Amount
Aggregate function	Sum
Source	fDetailedVendorLedgEntry.AmountLCY
Visible to Users	True

Amount Debited
Aggregate function	Sum
Source	fDetailedVendorLedgEntry.DebitAmountLCY
Visible to Users	True

Amount Credited
Aggregate function	Sum
Source	fDetailedVendorLedgEntry.CreditAmountLCY
Visible to Users	True

Total number of Open Days
Aggregate function	Sum
Source	fDetailedVendorLedgEntry.wOpenDays
Visible to Users	True

Total number of Overdue Days
Aggregate function	Sum
Source	fDetailedVendorLedgEntry.wOverdueDays
Visible to Users	True

Closed Entry Count
Aggregate function	Sum
Source	fDetailedVendorLedgEntry.wCountClosed
Visible to Users	True

Overdue Entry Count
Aggregate function	Sum
Source	fDetailedVendorLedgEntry.wCountOverdue
Visible to Users	True

Calculations

Average number of Open Days
Expression	[Total number of Open Days]/[Closed Entry Count]
Visible to Users	True

Average number of Overdue Days
Expression	[Total number of Overdue Days]/[Overdue Entry Count]
Visible to Users	True

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

Dimensions

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Due 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

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

SalespersonPurchaser
Attributes
Name	Source	Description
Name	dSalespersonPurchaser.Name

Source
Attributes
Name	Source	Description
Description	dSourceCode.Description

Vendor
Attributes
Name	Source	Description
Vendor Number	dVendor.No
Vendor Name	dVendor.Name
Vendor Number and Name	dVendor.NoName
Hierarchies
Vendor Country
Level Name	Source Attribute	Description
Name	Country
Vendor	Vendor Name
Vendor Territory
Level Name	Source Attribute	Description
Name	Territory
Vendor	Vendor Name

Vendor Ledger Entry
Attributes
Name	Source	Description
Number	fVendorLedgerEntry.EntryNo
Description	fVendorLedgerEntry.Description
Document Type	wdJournalDocumentType.Text
Document Number	fVendorLedgerEntry.DocumentNo

Data Transformations

Dimension Value (349)	tDimensionValue
Source Field Name	Destination Field Name
Dimension Code	DimensionCode
Code	Code
Name	Name
Dimension Value Type	DimensionValueType
Global Dimension No.	GlobalDimensionNo
Indentation	Indentation

Sales Cycle (5090)	dSalesCycle
Source Field Name	Destination Field Name
Code	Code
Description	Description

Sales Cycle Stage (5091)	dSalesCycleStage
Source Field Name	Destination Field Name
Stage	Stage
Description	Description
Sales Cycle Code	SalesCycleCode

Country(9)	dCountry
Source Field Name	Destination Field Name
Code	Code
Name	Name

Territory (286)	dTerritory
Source Field Name	Destination Field Name
Code	Code
Name	Name

Contact (5050)	dContact
Source Field Name	Destination Field Name
Name	Name
No.	No
Territory Code	TerritoryCode
Country Code	CountryCode
Company No.	CompanyNo

Close Opportunity Code (5094)	dCloseOpportunityCode
Source Field Name	Destination Field Name
Code	Code
Description	Description

Opportunity (5092)	dOpportunity
Source Field Name	Destination Field Name
Description	Description
Status	Status
Priority	Priority
Closed	Closed
No.	No

Campaign (5071)	dCampaign
Source Field Name	Destination Field Name
Description	Description
Status Code	StatusCode
No.	No

Salesperson_Purchaser (13)	dSalespersonPurchaser
Source Field Name	Destination Field Name
Code	Code
Name	Name

Campaign Status (5073)	dCampaignStatus
Source Field Name	Destination Field Name
Code	Code
Description	Description

Gen_ Business Posting Group (250)	dGenBusinessPostingGroup
Source Field Name	Destination Field Name
Code	Code
Description	Description

Gen_ Product Posting Group (251)	dGenProductPostingGroup
Source Field Name	Destination Field Name
Code	Code
Description	Description

Source Code (230)	dSourceCode
Source Field Name	Destination Field Name
Code	Code
Description	Description

G_L Budget Name (95)	dGLBudgetName
Source Field Name	Destination Field Name
Name	Name
Description	Description

G_L Account (15)	dGLAccount
Source Field Name	Destination Field Name
Name	Name
Indentation	Indentation
No.	No
Account Type	AccountType
Income/Balance	IncomeBalance

Work Type (200)	dWorkType
Source Field Name	Destination Field Name
Code	Code
Description	Description

Resource (156)	dResource
Source Field Name	Destination Field Name
No.	No
Name	Name

Customer (18)	dCustomer
Source Field Name	Destination Field Name
Name	Name
No.	No
Territory Code	TerritoryCode
Country Code	CountryCode
Credit Limit (LCY)	CreditLimitLCY
Payment Terms Code	PaymentTermsCode
Salesperson Code	SalespersonCode

Currency (4)	dCurrency
Source Field Name	Destination Field Name
Code	Code
Description	Description

Item (27)	dItem
Source Field Name	Destination Field Name
Description	Description
No.	No
Base Unit of Measure	BaseUnitOfMeasure
Unit Cost	UnitCost
Standard Cost	StandardCost
Vendor No.	VendorNo
Inventory Posting Group	InventoryPostingGroup
Item Category Code	ItemCategoryCode
Product Group Code	ProductGroupCode

Inventory Posting Group (94)	dInventoryPostingGroup
Source Field Name	Destination Field Name
Code	Code
Description	Description

Location (14)	dLocation
Source Field Name	Destination Field Name
Code	Code
Name	Name

Vendor (23)	dVendor
Source Field Name	Destination Field Name
Name	Name
Territory Code	TerritoryCode
Country Code	CountryCode
No.	No

Opportunity Entry (5093)	fOpportunityEntry
Source Field Name	Destination Field Name
Opportunity No.	OpportunityNo
Sales Cycle Code	SalesCycleCode
Sales Cycle Stage	SalesCycleStage
Contact No.	ContactNo
Salesperson Code	SalespersonCode
Campaign No.	CampaignNo
Date of Change	DateofChange
Active	Active
Action Taken	ActionTaken
Estimated Value (LCY)	EstimatedValue(LCY)
Calcd. Current Value (LCY)	CalcdCurrentValueLCY
Completed %	CompletedPct
Chances of Success %	ChancesofSuccessPct
Probability %	ProbabilityPct
Close Opportunity Code	CloseOpportunityCode
Previous Sales Cycle Stage	PreviousSalesCycleStage
Estimated Close Date	EstimatedCloseDate

G_L Entry (17)	fGLEntry
Source Field Name	Destination Field Name
G/L Account No.	GLAccountNo
Posting Date	PostingDate
Document Type	DocumentType
Document No.	DocumentNo
Description	Description
Amount	Amount
Source Code	SourceCode
Job No.	JobNo
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Debit Amount	DebitAmount
Credit Amount	CreditAmount
Entry No.	EntryNo
Source Type	SourceType
Source No.	SourceNo

G_L Budget Entry (96)	fGLBudgetEntry
Source Field Name	Destination Field Name
Budget Name	BudgetName
G/L Account No.	GLAccountNo
Date	Date
Amount	Amount
Description	Description
Entry No.	EntryNo

Sales Cr_ Memo Line (115)	fSalesCrMemoLine
Source Field Name	Destination Field Name
Document No.	DocumentNo
Type	Type
No.	No
Quantity	Quantity
Amount	Amount
Amount Including VAT	AmountIncludingVAT
Inv. Discount Amount	InvDiscountAmount
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Unit Cost	UnitCost
Line No.	LineNo
Job No.	JobNo
Phase Code	PhaseCode
Task Code	TaskCode
Step Code	StepCode
Unit Cost (LCY)	UnitCostLCY
Sell-to Customer No.	SellToCustomerNo
Bill-to Customer No.	BillToCustomerNo
Shipment Date	ShipmentDate
Line Amount	LineAmount
VAT %	VatPct

Sales Cr_ Memo Header (114)	dSalesCrMemoHeader
Source Field Name	Destination Field Name
No.	No
Posting Date	PostingDate
Currency Code	CurrencyCode
Salesperson Code	SalespersonCode
Currency Factor	CurrencyFactor
Sell-to Customer No.	SellToCustomerNo
Source Code	SourceCode
Bill-to Customer No.	BillToCustomerNo
Ship-to Code	ShipToCode
Shipment Date	ShipmentDate
Prices Including VAT	PricesIncludingVAT

Cust_ Ledger Entry (21)	fCustLedgerEntry
Source Field Name	Destination Field Name
Entry No.	EntryNo
Customer No.	CustomerNo
Posting Date	PostingDate
Currency Code	CurrencyCode
Sales (LCY)	SalesLCY
Salesperson Code	SalespersonCode
Source Code	SourceCode
Open	Open
Due Date	DueDate
Closed at Date	ClosedAtDate
Description	Description
Document Type	DocumentType
Document No.	DocumentNo

Sales Invoice Line (113)	fSalesInvoiceLine
Source Field Name	Destination Field Name
Document No.	DocumentNo
Type	Type
No.	No
Quantity	Quantity
Amount	Amount
Amount Including VAT	AmountIncludingVAT
Inv. Discount Amount	InvDiscountAmount
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Unit Cost	UnitCost
Line No.	LineNo
Job No.	JobNo
Phase Code	PhaseCode
Task Code	TaskCode
Step Code	StepCode
Unit Cost (LCY)	UnitCostLCY
Sell-to Customer No.	SellToCustomerNo
Bill-to Customer No.	BillToCustomerNo
Shipment Date	ShipmentDate
Line Amount	LineAmount
VAT %	VatPct

Sales Invoice Header (112)	dSalesInvoiceHeader
Source Field Name	Destination Field Name
No.	No
Posting Date	PostingDate
Currency Code	CurrencyCode
Salesperson Code	SalespersonCode
Currency Factor	CurrencyFactor
Sell-to Customer No.	SellToCustomerNo
Source Code	SourceCode
Bill-to Customer No.	BillToCustomerNo
Ship-to Code	ShipToCode
Shipment Date	ShipmentDate
Order Date	OrderDate
Prices Including VAT	PricesIncludingVAT

Item Ledger Entry (32)	fItemLedgerEntry
Source Field Name	Destination Field Name
Item No.	ItemNo
Posting Date	PostingDate
Entry Type	EntryType
Source No.	SourceNo
Location Code	LocationCode
Quantity	Quantity
Transaction Type	TransactionType
Document Date	DocumentDate
Last Invoice Date	LastInvoiceDate
Entry No.	EntryNo
Open	Open
Invoiced Quantity	InvoicedQuantity
Source Type	SourceType
Positive	Positive

Ledger Entry Dimension Table 17 (355)	fLedgerEntryDimensionGLEntry
Source Field Name	Destination Field Name
Dimension Code	DimensionCode
Table ID	TableID
Entry No.	EntryNo
Dimension Value Code	DimensionValueCode

Posted Document Dimension Table 113 (359)	fPostedDocumentDimensionSalesInvoiceLine
Source Field Name	Destination Field Name
Dimension Code	DimensionCode
Document No.	DocumentNo
Line No.	LineNo
Dimension Value Code	DimensionValueCode
Table ID	TableID

G_L Budget Dimension (361)	fGLBudgetDimension
Source Field Name	Destination Field Name
Entry No.	EntryNo
Dimension Code	DimensionCode
Dimension Value Code	DimensionValueCode

Detailed Cust_ Ledg_ Entry (379)	fDetailedCustLedgEntry
Source Field Name	Destination Field Name
Entry No.	EntryNo
Cust. Ledger Entry No.	CustLedgerEntryNo
Entry Type	EntryType
Posting Date	PostingDate
Document Type	DocumentType
Document No.	DocumentNo
Amount	Amount
Amount (LCY)	AmountLCY
Customer No.	CustomerNo
Currency Code	CurrencyCode
Source Code	SourceCode
Debit Amount	DebitAmount
Credit Amount	CreditAmount
Debit Amount (LCY)	DebitAmountLCY
Credit Amount (LCY)	CreditAmountLCY
Initial Entry Due Date	InitialEntryDueDate

Job Budget Entry (211)	fJobBudgetEntry
Source Field Name	Destination Field Name
Entry No.	EntryNo
Job Status	JobStatus
Job No.	JobNo
Type	Type
No.	No
Phase Code	PhaseCode
Task Code	TaskCode
Step Code	StepCode
Date	Date
Resource Group No.	ResourceGroupNo
Quantity	Quantity
Total Cost	TotalCost
Total Price	TotalPrice

Phase (161)	dPhase
Source Field Name	Destination Field Name
Code	Code
Description	Description

Resource Group (152)	dResourceGroup
Source Field Name	Destination Field Name
No.	No
Name	Name

Step (163)	dStep
Source Field Name	Destination Field Name
Code	Code
Description	Description

Task (162)	dTask
Source Field Name	Destination Field Name
Code	Code
Description	Description

Job Ledger Entry (169)	fJobLedgerEntry
Source Field Name	Destination Field Name
Entry No.	EntryNo
Job No.	JobNo
Posting Date	PostingDate
Document No.	DocumentNo
Type	Type
No.	No
Description	Description
Quantity	Quantity
Direct Unit Cost	DirectUnitCost
Unit Cost	UnitCost
Total Cost	TotalCost
Unit Price	UnitPrice
Total Price	TotalPrice
Resource Group No.	ResourceGroupNo
Unit of Measure Code	UnitofMeasureCode
Location Code	LocationCode
Work Type Code	WorkTypeCode
Source Code	SourceCode
Phase Code	PhaseCode
Task Code	TaskCode
Step Code	StepCode
Amt. to Post to G/L	AmttoPosttoGL
Amt. Posted to G/L	AmtPostedtoGL
Amt. to Recognize	AmttoRecognize
Amt. Recognized	AmtRecognized
Entry Type	EntryType
Open	Open
Remaining Amount	RemainingAmount
Area	Area
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup

Job (167)	dJob
Source Field Name	Destination Field Name
No.	No
Description	Description
Creation Date	CreationDate
Starting Date	StartingDate
Ending Date	EndingDate
Completion Date	CompletionDate
Job Posting Date	JobPostingDate
Completion %	CompletionPct
Status	Status
Person Responsible	PersonResponsible
Bill-to Customer No.	BilltoCustomerNo

Purch_ Cr_ Memo Line (125)	fPurchCrMemoLine
Source Field Name	Destination Field Name
Document No.	DocumentNo
Line No.	LineNo
Buy-from Vendor No.	BuyfromVendorNo
Type	Type
No.	No
Location Code	LocationCode
Quantity	Quantity
Direct Unit Cost	DirectUnitCost
Unit Cost (LCY)	UnitCostLCY
Line Discount Amount	LineDiscountAmount
Unit Price (LCY)	UnitPriceLCY
Job No.	JobNo
Phase Code	PhaseCode
Task Code	TaskCode
Step Code	StepCode
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Amount	Amount
Inv. Discount Amount	InvDiscountAmount
Line Amount	LineAmount
VAT %	VatPct

Fixed Asset (5600)	dFixedAsset
Source Field Name	Destination Field Name
No.	No
Description	Description

Purch_ Cr_ Memo Hdr_ (124)	dPurchCrMemoHdr
Source Field Name	Destination Field Name
No.	No
Buy-from Vendor No.	BuyfromVendorNo
Pay-to Vendor No.	PaytoVendorNo
Posting Date	PostingDate
Currency Factor	CurrencyFactor
Job No.	JobNo
Purchaser Code	PurchaserCode
Source Code	SourceCode
Ship-to Code	ShipToCode
Prices Including VAT	PricesIncludingVAT

Purch_ Inv_ Line (123)	fPurchInvLine
Source Field Name	Destination Field Name
Type	Type
Document No.	DocumentNo
Line No.	LineNo
Buy-from Vendor No.	BuyfromVendorNo
No.	No
Location Code	LocationCode
Posting Group	PostingGroup
Quantity	Quantity
Direct Unit Cost	DirectUnitCost
Unit Cost (LCY)	UnitCostLCY
Line Discount Amount	LineDiscountAmount
Amount	Amount
Unit Price (LCY)	UnitPriceLCY
Job No.	JobNo
Phase Code	PhaseCode
Task Code	TaskCode
Step Code	StepCode
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Inv. Discount Amount	InvDiscountAmount
Line Amount	LineAmount
VAT %	VatPct

Purch_ Inv_ Header (122)	dPurchInvHeader
Source Field Name	Destination Field Name
No.	No
Buy-from Vendor No.	BuyfromVendorNo
Pay-to Vendor No.	PaytoVendorNo
Posting Date	PostingDate
Job No.	JobNo
Purchaser Code	PurchaserCode
Currency Factor	CurrencyFactor
Source Code	SourceCode
Ship-to Code	ShipToCode
Prices Including VAT	PricesIncludingVAT
Order Date	OrderDate

Vendor Ledger Entry (25)	fVendorLedgerEntry
Source Field Name	Destination Field Name
Entry No.	EntryNo
Vendor No.	VendorNo
Posting Date	PostingDate
Purchase (LCY)	PurchaseLCY
Inv. Discount (LCY)	InvDiscountLCY
Purchaser Code	PurchaserCode
Due Date	DueDate
Open	Open
Closed at Date	ClosedAtDate
Source Code	SourceCode
Description	Description
Document Type	DocumentType
Document No.	DocumentNo

Detailed Vendor Ledg_ Entry (380)	fDetailedVendorLedgEntry
Source Field Name	Destination Field Name
Amount	Amount
Entry No.	EntryNo
Vendor Ledger Entry No.	VendorLedgerEntryNo
Entry Type	EntryType
Document Type	DocumentType
Document No.	DocumentNo
Amount (LCY)	AmountLCY
Vendor No.	VendorNo
Source Code	SourceCode
Debit Amount (LCY)	DebitAmountLCY
Credit Amount (LCY)	CreditAmountLCY
Posting Date	PostingDate

Value Entry (5802)	fValueEntry
Source Field Name	Destination Field Name
Entry No.	EntryNo
Item No.	ItemNo
Posting Date	PostingDate
Item Ledger Entry Type	ItemLedgerEntryType
Document No.	DocumentNo
Description	Description
Location Code	LocationCode
Inventory Posting Group	InventoryPostingGroup
Item Ledger Entry No.	ItemLedgerEntryNo
Valued Quantity	ValuedQuantity
Invoiced Quantity	InvoicedQuantity
Cost per Unit	CostperUnit
Amount	Amount
Salespers./Purch. Code	SalespersPurchCode
Discount Amount	DiscountAmount
Source Code	SourceCode
Adjusted Cost	AdjustedCost
Cost Posted to G/L	CostPostedtoGL
Entry Type	EntryType
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Expected Cost	ExpectedCost
Source No.	SourceNo
Source Type	SourceType

Ledger Entry Dimension Table 32 (355)	fLedgerEntryDimensionItemLedgerEntry
Source Field Name	Destination Field Name
Dimension Code	DimensionCode
Table ID	TableID
Entry No.	EntryNo
Dimension Value Code	DimensionValueCode

Ledger Entry Dimension Table 169 (355)	fLedgerEntryDimensionJobLedgerEntry
Source Field Name	Destination Field Name
Dimension Code	DimensionCode
Table ID	TableID
Entry No.	EntryNo
Dimension Value Code	DimensionValueCode

Ledger Entry Dimension Table 5802 (355)	fLedgerEntryDimensionValueEntry
Source Field Name	Destination Field Name
Dimension Code	DimensionCode
Table ID	TableID
Entry No.	EntryNo
Dimension Value Code	DimensionValueCode

Ledger Entry Dimension Table 21 (355)	fLedgerEntryDimensionCustLedgerEntry
Source Field Name	Destination Field Name
Dimension Code	DimensionCode
Table ID	TableID
Entry No.	EntryNo
Dimension Value Code	DimensionValueCode

Ledger Entry Dimension Table 25 (355)	fLedgerEntryDimensionVendorLedgerEntry
Source Field Name	Destination Field Name
Dimension Code	DimensionCode
Table ID	TableID
Entry No.	EntryNo
Dimension Value Code	DimensionValueCode

Posted Document Dimension Table 115 (359)	fPostedDocumentDimensionSalesCrMemoLine
Source Field Name	Destination Field Name
Dimension Code	DimensionCode
Document No.	DocumentNo
Line No.	LineNo
Dimension Value Code	DimensionValueCode
Table ID	TableID

Posted Document Dimension Table 123 (359)	fPostedDocumentDimensionPurchInvLine
Source Field Name	Destination Field Name
Dimension Code	DimensionCode
Document No.	DocumentNo
Line No.	LineNo
Dimension Value Code	DimensionValueCode
Table ID	TableID

Posted Document Dimension Table 125 (359)	fPostedDocumentDimensionPurchCrMemoLine
Source Field Name	Destination Field Name
Dimension Code	DimensionCode
Document No.	DocumentNo
Line No.	LineNo
Dimension Value Code	DimensionValueCode
Table ID	TableID

Item Charge (5800)	dItemCharge
Source Field Name	Destination Field Name
No.	No
Description	Description

Default Dimension (352)	fDefaultDimensionCustomer
Source Field Name	Destination Field Name
Table ID	TableID
No.	No
Dimension Code	DimensionCode
Dimension Value Code	DimensionValueCode

Ship-to Address (222)	dShiptoAddress
Source Field Name	Destination Field Name
Code	Code
Country Code	CountryCode
Customer No.	CustomerNo
Name	Name

Item Category (5722)	dItemCategory
Source Field Name	Destination Field Name
Code	Code
Description	Description

Product Group (5723)	dProductGroup
Source Field Name	Destination Field Name
Item Category Code	ItemCategoryCode
Code	Code
Description	Description

Document Dimension Table 37 (357)	fDocumentDimensionSalesLine
Source Field Name	Destination Field Name
Table ID	TableID
Document Type	DocumentType
Document No.	DocumentNo
Line No.	LineNo
Dimension Code	DimensionCode
Dimension Value Code	DimensionValueCode

Sales Line (37)	fSalesLine
Source Field Name	Destination Field Name
Document Type	DocumentType
Document No.	DocumentNo
Line No.	LineNo
Sell-to Customer No.	SelltoCustomerNo
Type	Type
No.	No
Location Code	LocationCode
Shipment Date	ShipmentDate
Description	Description
Unit of Measure	UnitofMeasure
Quantity	Quantity
Outstanding Quantity	OutstandingQuantity
Qty. to Invoice	QtytoInvoice
Qty. to Ship	QtytoShip
Unit Price	UnitPrice
Unit Cost (LCY)	UnitCostLCY
Line Discount %	LineDiscountPct
Line Discount Amount	LineDiscountAmount
Amount	Amount
Amount Including VAT	AmountIncludingVAT
Shortcut Dimension 1 Code	ShortcutDimension1Code
Shortcut Dimension 2 Code	ShortcutDimension2Code
Job No.	JobNo
Outstanding Amount	OutstandingAmount
Qty. Shipped Not Invoiced	QtyShippedNotInvoiced
Shipped Not Invoiced	ShippedNotInvoiced
Quantity Shipped	QuantityShipped
Quantity Invoiced	QuantityInvoiced
Bill-to Customer No.	BilltoCustomerNo
Inv. Discount Amount	InvDiscountAmount
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Transaction Type	TransactionType
Currency Code	CurrencyCode
Outstanding Amount (LCY)	OutstandingAmountLCY
Shipped Not Invoiced (LCY)	ShippedNotInvoicedLCY
Reserve	Reserve
Unit Cost	UnitCost
Line Amount	LineAmount
Inv. Disc. Amount to Invoice	InvDiscAmounttoInvoice
Qty. per Unit of Measure	QtyperUnitofMeasure
Planned	Planned
Unit of Measure Code	UnitofMeasureCode
Quantity (Base)	QuantityBase
Outstanding Qty. (Base)	OutstandingQtyBase
Qty. to Invoice (Base)	QtytoInvoiceBase
Qty. to Ship (Base)	QtytoShipBase
Qty. Shipped Not Invd. (Base)	QtyShippedNotInvdBase
Qty. Shipped (Base)	QtyShippedBase
Qty. Invoiced (Base)	QtyInvoicedBase
Item Category Code	ItemCategoryCode
Product Group Code	ProductGroupCode
Planned Delivery Date	PlannedDeliveryDate
Planned Shipment Date	PlannedShipmentDate
VAT %	VATPct
Phase Code	PhaseCode
Step Code	StepCode
Task Code	TaskCode

Sales Header (36)	dSalesHeader
Source Field Name	Destination Field Name
Document Type	DocumentType
No.	No
Sell-to Customer No.	SelltoCustomerNo
Bill-to Customer No.	BilltoCustomerNo
Ship-to Code	ShiptoCode
Order Date	OrderDate
Posting Date	PostingDate
Shipment Date	ShipmentDate
Location Code	LocationCode
Shortcut Dimension 1 Code	ShortcutDimension1Code
Shortcut Dimension 2 Code	ShortcutDimension2Code
Currency Code	CurrencyCode
Currency Factor	CurrencyFactor
Salesperson Code	SalespersonCode
Ship	Ship
Invoice	Invoice
Gen. Bus. Posting Group	GenBusPostingGroup
Document Date	DocumentDate
Reserve	Reserve
Status	Status
Campaign No.	CampaignNo
Prices Including VAT	PricesIncludingVAT

Purchase Line (39)	fPurchaseLine
Source Field Name	Destination Field Name
No.	No
Document No.	DocumentNo
Line No.	LineNo
Buy-from Vendor No.	BuyfromVendorNo
Type	Type
Location Code	LocationCode
Posting Group	PostingGroup
Quantity	Quantity
Direct Unit Cost	DirectUnitCost
Unit Cost (LCY)	UnitCostLCY
Line Discount Amount	LineDiscountAmount
Amount	Amount
Unit Price (LCY)	UnitPriceLCY
Job No.	JobNo
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Line Amount	LineAmount
Line Discount %	LineDiscountPct
VAT %	VATPct
Inv. Discount Amount	InvDiscountAmount
Document Type	DocumentType
Quantity Invoiced	QuantityInvoiced
Step Code	StepCode
Task Code	TaskCode
Phase Code	PhaseCode

Purchase Header (38)	dPurchaseHeader
Source Field Name	Destination Field Name
No.	No
Buy-from Vendor No.	BuyfromVendorNo
Pay-to Vendor No.	PaytoVendorNo
Posting Date	PostingDate
Purchaser Code	PurchaserCode
Currency Factor	CurrencyFactor
Ship-to Code	ShiptoCode
Prices Including VAT	PricesIncludingVAT
Order Date	OrderDate
Document Type	DocumentType

Document Dimension Table 39 (357)	fDocumentDimensionPurchaseLine
Source Field Name	Destination Field Name
Table ID	TableID
Document Type	DocumentType
Document No.	DocumentNo
Line No.	LineNo
Dimension Code	DimensionCode
Dimension Value Code	DimensionValueCode

Payment Terms (3)	dPaymentTerms
Source Field Name	Destination Field Name
Code	Code
Description	Description