Microsoft Dynamics NAV 5.00

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
Total Number of Open Days	x	x	x	x	x	x	x	x	x
Total Number of Overdue Days	x	x	x	x	x	x	x	x	x
Turnover Ratio	x	x	x	x	x	x	x	x	x

Measures

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

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

Total 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

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

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

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

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

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

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
Limit	dCustomer.wHasCreditLimit

Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Number and Name	dCustomer.NumberName
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimitID
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Number and Name	Number and Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Number and Name	Number and 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
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Month	wdPostingPeriod.MonthName
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
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Month	wdPostingPeriod.MonthName
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

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

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

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.wParentNo
Account Number	dGLAccount.No
Account Name	dGLAccount.Name
Account Number and Name	dGLAccount.NumberName
IncomeBalance	dGLAccount.wAccountGroup
CompanyAccount	dGLAccount.CompanyNumberName

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
Number and Name	dCustomer.NumberName
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimitID
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Number and Name	Number and Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Number and Name	Number and 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
Job Number	dJob.No
Job Number and Description	dJob.NumberName
Status	wdJobStatus.Text

Posting Period
Attributes
Name	Source	Description
Date	wdPostingPeriod.DateName
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Month	wdPostingPeriod.MonthName
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 Number and Name
Vendor Territory
Level Name	Source Attribute	Description
Name	Territory
Vendor	Vendor Number and 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
Number of Days							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		x
Quantity Decreases	x	x	x	x	x	x	x		x
Quantity in Stock Primo	x	x	x	x	x	x	x		x
Quantity in Stock Ultimo	x	x	x	x	x	x	x		x
Quantity Increases	x	x	x	x	x	x	x		x
Quantity Sold	x	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

Cost Posted to G_L
Aggregate function	Sum
Source	fValueEntry.CostPostedtoGL
Visible to Users	True

Number of Days
Aggregate function	Count
Source	wdPostingPeriod.DateNumber
Visible to Users	True

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	[Sales Amount]
Visible to Users	True

Cost of Sales
Expression	([Inventory Main Entry Type].[Description].&[1],[Cost Amount])*(-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

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
Number and Name	dCustomer.NumberName
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimitID
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Number and Name	Number and Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Number and Name	Number and 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.NumberDescription
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
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Month	wdPostingPeriod.MonthName
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 Number and Name
Vendor Territory
Level Name	Source Attribute	Description
Name	Territory
Vendor	Vendor Number and Name

Job

Bus Matrix

Bill-to Customer

Business Posting Group

Company

Customer

Job

Job Task

Posting Period

Product Posting Group

Sales Entity

SalespersonPurchaser

Ship-to Customer

Source

Cost Planning Index

Cost Planning Variance

Excess Invoicing

Excess Invoicing %

Invoiced Cost

Invoiced Price

Invoiced Quantity

Planned Amount

Planned Cost

Planned Price

Planned Quantity

Planning Invoiced Amount

Planning Invoiced Cost

Price Planning Index

Price Planning Variance

Profit

Profit %

Quantity Planning Index

Quantity Planning Variance

Total Cost

Total Price

Total Quantity

Measures

Planned Quantity
Aggregate function	Sum
Source	fJobPlanningLine.Quantity
Visible to Users	True

Planned Cost
Aggregate function	Sum
Source	fJobPlanningLine.TotalCostLCY
Visible to Users	True

Planned Price
Aggregate function	Sum
Source	fJobPlanningLine.TotalPriceLCY
Visible to Users	True

Planned Amount
Aggregate function	Sum
Source	fJobPlanningLine.LineAmountLCY
Visible to Users	True

Planning Invoiced Amount
Aggregate function	Sum
Source	fJobPlanningLine.InvoicedAmountLCY
Visible to Users	True

Planning Invoiced Cost
Aggregate function	Sum
Source	fJobPlanningLine.InvoicedCostAmountLCY
Visible to Users	True

Calculations

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

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

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

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

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

Total Cost
Expression	[Invoiced Cost]+[Job Ledger Cost]
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	iif ([Invoiced Price]=0, null, ([Profit]/[Invoiced Price])*100)
Visible to Users	True

Excess Invoicing %
Expression	iif ([Total Price]=0, null, ([Invoiced Price]/[Total Price])*100)
Visible to Users	True

Price Planning Variance
Expression	[Invoiced Price]-[Planned Price]
Visible to Users	True

Price Planning Index
Expression	iif ([Planned Price]=0, null, ([Invoiced Price]/[Planned Price])*100)
Visible to Users	True

Cost Planning Variance
Expression	[Planned Cost]-[Total Cost]
Visible to Users	True

Cost Planning Index
Expression	iif ([Total Cost]=0, null, ([Planned Cost]/[Total Cost])*100)
Visible to Users	True

Quantity Planning Variance
Expression	[Planned Quantity]-[Total Quantity]
Visible to Users	True

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

Dimensions

Bill-to Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Number and Name	dCustomer.NumberName
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimitID
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Number and Name	Number and Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Number and Name	Number and 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
Number and Name	dCustomer.NumberName
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimitID
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Number and Name	Number and Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Number and Name	Number and Name

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

Job Task
Attributes
Name	Source	Description
Description	dJobTask.Description

Posting Period
Attributes
Name	Source	Description
Date	wdPostingPeriod.DateName
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Month	wdPostingPeriod.MonthName
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
Number and Description	wdItemResource.NoDescription
Number	wdItemResource.No
Description	wdItemResource.Description
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
Code	dShiptoAddress.Code
Type	wdShiptoType.Text
Country	dCountryRegion.Name
Name	dShiptoAddress.Name
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 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	[wChanceOfSuccess]/[Opportunity Entry Count]
Visible to Users	True

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

Completion (Avg.)
Expression	[wCompletedPct]/[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
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 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.NumberName

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

Opportunity Entry Active
Attributes
Name	Source	Description
Description	wdOpportunityActive.Description

Posting Period
Attributes
Name	Source	Description
Date	wdPostingPeriod.DateName
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Month	wdPostingPeriod.MonthName
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

Order Amount

Order Quantity

Outstanding Amount

Outstanding Quantity

Purchase

Purchase Credit Memo Amount

Purchase Credit Memo Quantity

Purchase Invoice Amount

Purchase Invoice Quantity

Quantity

Total Average Cost Price

Total Purchase

Total Quantity

Measures

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

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

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

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

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

Order Quantity
Aggregate function	Sum
Source	fPurchaseLine.Quantity
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	[Purchase Invoice Amount]-[Purchase Credit Memo Amount]
Visible to Users	True

Quantity
Expression	[Purchase Invoice Quantity]-[Purchase 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 Number and Name
Vendor Territory
Level Name	Source Attribute	Description
Name	Territory
Vendor	Vendor Number and Name

Item
Attributes
Name	Source	Description
Number	dItem.No
Description	dItem.Description
Number and Description	dItem.NumberDescription
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
Job Number	dJob.No
Job Number and Description	dJob.NumberName
Status	wdJobStatus.Text

Order Period
Attributes
Name	Source	Description
Date	wdPostingPeriod.DateName
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Month	wdPostingPeriod.MonthName
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
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Month	wdPostingPeriod.MonthName
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
Number and Description	wdItemAsset.NumberDescription
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Purchase Entity	Purchase Entity
Number and Description	Number and 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 Number and Name
Vendor Territory
Level Name	Source Attribute	Description
Name	Territory
Vendor	Vendor Number and Name

Sales

Bus Matrix

Bill-to Customer

Business Posting Group

Company

Customer

Invoice Customer

Item

Job

Job Task

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

Days Since Last Invoice

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

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.LineCost
Visible to Users	True

Days Since Last Invoice
Aggregate function	Min
Source	fSalesInvoiceLine.wDaysSincePosting
Visible to Users	True

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.LineCost
Visible to Users	True

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

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

Order Quantity
Aggregate function	Sum
Source	fSalesLine.Quantity
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 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 Invoices
Aggregate function	DistinctCount
Source	fSalesInvoiceLine.wSalesInvoiceCount
Visible to Users	True

Number of Credit Memos
Aggregate function	DistinctCount
Source	fSalesCrMemoLine.wSalesCrMemoCount
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
Number and Name	dCustomer.NumberName
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimitID
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Number and Name	Number and Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Number and Name	Number and 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
Number and Name	dCustomer.NumberName
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimitID
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Number and Name	Number and Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Number and Name	Number and Name

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

Item
Attributes
Name	Source	Description
Number	dItem.No
Description	dItem.Description
Number and Description	dItem.NumberDescription
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
Job Number	dJob.No
Job Number and Description	dJob.NumberName
Status	wdJobStatus.Text

Job Task
Attributes
Name	Source	Description
Description	dJobTask.Description

Order Period
Attributes
Name	Source	Description
Date	wdPostingPeriod.DateName
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Month	wdPostingPeriod.MonthName
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
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Month	wdPostingPeriod.MonthName
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
Number and Description	wdItemResource.NoDescription
Number	wdItemResource.No
Description	wdItemResource.Description
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
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Month	wdPostingPeriod.MonthName
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
Code	dShiptoAddress.Code
Type	wdShiptoType.Text
Country	dCountryRegion.Name
Name	dShiptoAddress.Name
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

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

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

Dimensions

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Due Period
Attributes
Name	Source	Description
Date	wdPostingPeriod.DateName
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Month	wdPostingPeriod.MonthName
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
Quarter	wdPostingPeriod.QuarterName
Year	wdPostingPeriod.YearName
Month	wdPostingPeriod.MonthName
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 Number and Name
Vendor Territory
Level Name	Source Attribute	Description
Name	Territory
Vendor	Vendor Number and 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
Indentation	Indentation
Global Dimension No.	GlobalDimensionNo

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
Description	Description
Stage	Stage
Sales Cycle Code	SalesCycleCode

Country_Region (9)	dCountryRegion
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
Territory Code	TerritoryCode
Name	Name
No.	No
Country/Region Code	CountryRegionCode
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
Account Type	AccountType
No.	No
Income/Balance	IncomeBalance

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

Customer (18)	dCustomer
Source Field Name	Destination Field Name
Territory Code	TerritoryCode
Credit Limit (LCY)	CreditLimitLCY
Name	Name
No.	No
Country/Region Code	CountryRegionCode
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
Base Unit of Measure	BaseUnitOfMeasure
Unit Cost	UnitCost
Standard Cost	StandardCost
Inventory Posting Group	InventoryPostingGroup
No.	No
Vendor No.	VendorNo
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
Name	Name
Code	Code

Vendor (23)	dVendor
Source Field Name	Destination Field Name
Territory Code	TerritoryCode
Name	Name
No.	No
Country/Region Code	CountryRegionCode

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

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

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

Sales Cr_Memo Line (115)	fSalesCrMemoLine
Source Field Name	Destination Field Name
No.	No
Line No.	LineNo
Document No.	DocumentNo
Sell-to Customer No.	SellToCustomerNo
Type	Type
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
Job No.	JobNo
Unit Cost (LCY)	UnitCostLCY
Job Task No.	JobTaskNo
Bill-to Customer No.	BillToCustomerNo
Shipment Date	ShipmentDate
Line Amount	LineAmount
Line Discount %	LineDiscountPct
Line Discount Amount	LineDistinctAmount
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
Posting Date	PostingDate
Currency Code	CurrencyCode
Sales (LCY)	SalesLCY
Salesperson Code	SalespersonCode
Open	Open
Due Date	DueDate
Source Code	SourceCode
Closed at Date	ClosedAtDate
Entry No.	EntryNo
Customer No.	CustomerNo
Description	Description
Document Type	DocumentType
Document No.	DocumentNo

Sales Invoice Line (113)	fSalesInvoiceLine
Source Field Name	Destination Field Name
No.	No
Line No.	LineNo
Document No.	DocumentNo
Sell-to Customer No.	SellToCustomerNo
Type	Type
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
Job No.	JobNo
Unit Cost (LCY)	UnitCostLCY
Job Task No.	JobTaskNo
Bill-to Customer No.	BillToCustomerNo
Shipment Date	ShipmentDate
Line Amount	LineAmount
Line Discount %	LineDiscountPct
Line Discount Amount	LineDiscountAmount
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
Order Date	OrderDate
Shipment Date	ShipmentDate
Prices Including VAT	PricesIncludingVAT

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

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

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

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

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

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

JobTask (162)	dJobTask
Source Field Name	Destination Field Name
Description	Description
Job No.	JobNo
Job Task No.	JobTaskNo

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

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

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

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

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
Purchaser Code	PurchaserCode
Currency Factor	CurrencyFactor
Source Code	SourceCode
Ship-to Code	ShipToCode
Prices Including VAT	PricesIncludingVAT

Purch_ Cr_ Memo Line (125)	fPurchCrMemoLine
Source Field Name	Destination Field Name
No.	No
Document No.	DocumentNo
Line No.	LineNo
Buy-from Vendor No.	BuyfromVendorNo
Type	Type
Location Code	LocationCode
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
Job Task No.	JobTaskNo
Line Amount	LineAmount
Line Discount %	LineDiscountPct
VAT %	VATPct
Inv. Discount Amount	InvDiscountAmount

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
Purchaser Code	PurchaserCode
Currency Factor	CurrencyFactor
Source Code	SourceCode
Ship-to Code	ShipToCode
Prices Including VAT	PricesIncludingVAT
Order Date	OrderDate

Purch_ Inv_ Line (123)	fPurchInvLine
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
Job Task No.	JobTaskNo
Line Amount	LineAmount
Line Discount %	LineDiscountPct
VAT %	VATPct
Inv. Discount Amount	InvDiscountAmount

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

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

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

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

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

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

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

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

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

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

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

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

Job Planning Line (1003)	fJobPlanningLine
Source Field Name	Destination Field Name
Job No.	JobNo
Job Task No.	JobTaskNo
Line No.	LineNo
Type	Type
No.	No
Description	Description
Quantity	Quantity
Total Cost (LCY)	TotalCostLCY
Total Price (LCY)	TotalPriceLCY
Resource Group No.	ResourceGroupNo
Work Type Code	WorkTypeCode
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Line Amount (LCY)	LineAmountLCY
Total Cost	TotalCost
Total Price	TotalPrice
Line Amount	LineAmount
Invoiced Date	InvoicedDate
Invoiced Amount (LCY)	InvoicedAmountLCY
Variant Code	VariantCode
Document Date	DocumentDate
Job Ledger Entry No.	JobLedgerEntryNo
Invoiced Cost Amount (LCY)	InvoicedCostAmountLCY
Invoiced	Invoiced
Line Type	LineType
Planning Date	PlanningDate

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

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 No.	DocumentNo
Line No.	LineNo
Dimension Code	DimensionCode
Dimension Value Code	DimensionValueCode
Document Type	DocumentType

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
Job Task No.	JobTaskNo
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

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
Job Task No.	JobTaskNo
Line Amount	LineAmount
Line Discount %	LineDiscountPct
VAT %	VATPct
Inv. Discount Amount	InvDiscountAmount
Document Type	DocumentType
Quantity Invoiced	QuantityInvoiced

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