| 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 |
|
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 |
| 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 |
| 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 |
| 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 | |
|
Account
|
Budget Name
|
Business Posting Group
|
Closing Entries
|
Company
|
Customer
|
General Ledger Detail
|
IncomeBalance
|
Job
|
Posting Period
|
Product Posting Group
|
Source
|
Vendor
|
|
| Amount credited | x | x | x | x | x | x | x | x | x | x | x | x | |
| Amount debited | x | x | x | x | x | x | x | x | x | x | x | x | |
| Amount posted | x | x | x | x | x | x | x | x | x | x | x | x | |
| Budget Amount | x | x | x | x | x | ||||||||
| Budget Index | x | x | x | x | |||||||||
| Budget Variance | x | x | x | x | |||||||||
| End Balance | x | x | x | x | x | x | x | x | x | x | x | x | |
| Start Balance | x | x | x | x | x | x | x | x | x | x | x | x |
| 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 |
| 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 |
| 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 | |
|
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 |
| 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 |
| 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 |
| 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 | ||
| Item Category | ||
| Level Name | Source Attribute | Description |
| Description | wItemCategory | |
| 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 | |
|
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 | x | x | x | x | x | x | x | x | x | |||
| Cost Planning Variance | x | x | x | x | x | x | x | x | x | |||
| Excess Invoicing | x | x | x | x | x | x | x | x | x | x | ||
| Excess Invoicing % | x | x | x | x | x | x | x | x | x | x | ||
| Invoiced Cost | x | x | x | x | x | x | x | x | x | x | x | x |
| Invoiced Price | x | x | x | x | x | x | x | x | x | x | x | x |
| Invoiced Quantity | x | x | x | x | x | x | x | x | x | x | x | x |
| Planned Amount | x | x | x | x | x | x | x | x | x | |||
| Planned Cost | x | x | x | x | x | x | x | x | x | |||
| Planned Price | x | x | x | x | x | x | x | x | x | |||
| Planned Quantity | x | x | x | x | x | x | x | x | x | |||
| Planning Invoiced Amount | x | x | x | x | x | x | x | x | x | |||
| Planning Invoiced Cost | x | x | x | x | x | x | x | x | x | |||
| Price Planning Index | x | x | x | x | x | x | x | x | x | |||
| Price Planning Variance | x | x | x | x | x | x | x | x | x | |||
| Profit | x | x | x | x | x | x | x | x | x | x | ||
| Profit % | x | x | x | x | x | x | x | x | x | x | ||
| Quantity Planning Index | x | x | x | x | x | x | x | x | x | |||
| Quantity Planning Variance | x | x | x | x | x | x | x | x | x | |||
| Total Cost | x | x | x | x | x | x | x | x | x | x | ||
| Total Price | x | x | x | x | x | x | x | x | x | x | ||
| Total Quantity | x | x | x | x | x | x | x | x | x | x |
| 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.wInvoicedAmountLCY |
| Visible to Users | True |
| Planning Invoiced Cost | |
| Aggregate function | Sum |
| Source | fJobPlanningLine.wInvoicedCostAmountLCY |
| Visible to Users | True |
| 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 |
| 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 | |
|
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 | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| Chance of Success (Avg.) | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| Completion (Avg.) | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| Estimated Value | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| Opportunity Entry Count | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| Probability (Avg.) | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| 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 |
| 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 |
| 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 | |
|
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 | x | x | x | x | x | x | x | x | x | x | x | ||||
| Order Amount | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Order Quantity | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Outstanding Amount | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Outstanding Quantity | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Purchase | x | x | x | x | x | x | x | x | x | x | x | ||||
| Purchase Credit Memo Amount | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Purchase Credit Memo Quantity | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Purchase Invoice Amount | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Purchase Invoice Quantity | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Quantity | x | x | x | x | x | x | x | x | x | x | x | ||||
| Total Average Cost Price | x | x | x | x | x | x | x | x | x | x | |||||
| Total Purchase | x | x | x | x | x | x | x | x | x | x | |||||
| Total Quantity | x | x | x | x | x | x | x | x | x | x |
| 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 |
| 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 |
| 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 | ||
| Item Category | ||
| Level Name | Source Attribute | Description |
| Description | wItemCategory | |
| 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 | |
|
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 | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Credit Memo Amount | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | ||
| Credit Memo Cost | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | ||
| Credit Memo Quantity | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | ||
| Days Since Last Invoice | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | ||
| Number of Credit Memos | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | ||
| Number of Invoices | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | ||
| Number of Open Orders | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Order Amount | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Order Cost | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Order Profit | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Order Profit % | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Order Quantity | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Outstanding Amount | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Outstanding Cost | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Outstanding Profit | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Outstanding Profit % | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Outstanding Quantity | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Profit | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Profit % | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Quantity | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Sales | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Sales Invoice Amount | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | ||
| Sales Invoice Cost | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | ||
| Sales Invoice Quantity | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | ||
| Shipped Not Invoiced Amount | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Shipped not Invoiced Quantity | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | |||
| Total Cost | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | ||||
| Total Profit | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | ||||
| Total Profit % | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | ||||
| Total Quantity | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | ||||
| Total Sales | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |
| 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 Quantity | |
| Aggregate function | Sum |
| Source | fSalesLine.QtyShippedNotInvoiced |
| Visible to Users | True |
| Shipped Not Invoiced Amount | |
| Aggregate function | Sum |
| Source | fSalesLine.wShippedNotInvoicedAmountLCY |
| 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 |
| 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 |
| 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 | ||
| Item Category | ||
| Level Name | Source Attribute | Description |
| Description | wItemCategory | |
| 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 | |
|
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 |
| 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 |
| 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 |
| 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 | |
| Source Field Name | Destination Field Name |
| Totaling | Totaling |
| Dimension Value ID | DimensionValueID |
| Dimension Code | DimensionCode |
| Code | Code |
| Name | Name |
| Dimension Value Type | DimensionValueType |
| Indentation | Indentation |
| Global Dimension No_ | GlobalDimensionNo |
| Source Field Name | Destination Field Name |
| Code | Code |
| Description | Description |
| Source Field Name | Destination Field Name |
| Description | Description |
| Stage | Stage |
| Sales Cycle Code | SalesCycleCode |
| Source Field Name | Destination Field Name |
| Code | Code |
| Name | Name |
| Source Field Name | Destination Field Name |
| Code | Code |
| Name | Name |
| Source Field Name | Destination Field Name |
| Territory Code | TerritoryCode |
| Name | Name |
| No_ | No |
| Country_Region Code | CountryRegionCode |
| Company No_ | CompanyNo |
| Source Field Name | Destination Field Name |
| Code | Code |
| Description | Description |
| Source Field Name | Destination Field Name |
| Description | Description |
| Status | Status |
| Priority | Priority |
| Closed | Closed |
| No_ | No |
| Source Field Name | Destination Field Name |
| Description | Description |
| Status Code | StatusCode |
| No_ | No |
| Source Field Name | Destination Field Name |
| Code | Code |
| Name | Name |
| Source Field Name | Destination Field Name |
| Code | Code |
| Description | Description |
| Source Field Name | Destination Field Name |
| Code | Code |
| Description | Description |
| Source Field Name | Destination Field Name |
| Code | Code |
| Description | Description |
| Source Field Name | Destination Field Name |
| Code | Code |
| Description | Description |
| Source Field Name | Destination Field Name |
| Name | Name |
| Description | Description |
| Source Field Name | Destination Field Name |
| Name | Name |
| Account Type | AccountType |
| Indentation | Indentation |
| No_ | No |
| Income_Balance | IncomeBalance |
| Source Field Name | Destination Field Name |
| Name | Name |
| No_ | No |
| Source Field Name | Destination Field Name |
| Name | Name |
| Territory Code | TerritoryCode |
| Credit Limit (LCY) | CreditLimitLCY |
| No_ | No |
| Country_Region Code | CountryRegionCode |
| Payment Terms Code | PaymentTermsCode |
| Salesperson Code | SalespersonCode |
| Source Field Name | Destination Field Name |
| Code | Code |
| Description | Description |
| Source Field Name | Destination Field Name |
| Description | Description |
| Base Unit of Measure | BaseUnitOfMeasure |
| Inventory Posting Group | InventoryPostingGroup |
| Unit Cost | UnitCost |
| Standard Cost | StandardCost |
| Product Group Code | ProductGroupCode |
| No_ | No |
| Vendor No_ | VendorNo |
| Item Category Code | ItemCategoryCode |
| Source Field Name | Destination Field Name |
| Code | Code |
| Description | Description |
| Source Field Name | Destination Field Name |
| Name | Name |
| Code | Code |
| Source Field Name | Destination Field Name |
| Name | Name |
| Territory Code | TerritoryCode |
| Country_Region Code | CountryRegionCode |
| No_ | No |
| 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 |
| 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 |
| Dimension Set ID | DimensionSetID |
| Description | Description |
| Source Type | SourceType |
| Source No_ | SourceNo |
| Source Field Name | Destination Field Name |
| Budget Name | BudgetName |
| Date | Date |
| Amount | Amount |
| Description | Description |
| Entry No_ | EntryNo |
| G_L Account No_ | GLAccountNo |
| Dimension Set ID | DimensionSetID |
| 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 |
| Dimension Set ID | DimensionSetID |
| Source Field Name | Destination Field Name |
| Currency Code | CurrencyCode |
| Salesperson Code | SalespersonCode |
| Ship-to Code | ShipToCode |
| Posting Date | PostingDate |
| Shipment Date | ShipmentDate |
| Currency Factor | CurrencyFactor |
| Prices Including VAT | PricesIncludingVAT |
| No_ | No |
| Sell-to Customer No_ | SellToCustomerNo |
| Bill-to Customer No_ | BillToCustomerNo |
| Source Code | SourceCode |
| 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 |
| Dimension Set ID | DimensionSetID |
| Description | Description |
| Document Type | DocumentType |
| Document No_ | DocumentNo |
| 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 |
| Dimension Set ID | DimensionSetID |
| Source Field Name | Destination Field Name |
| Currency Code | CurrencyCode |
| Salesperson Code | SalespersonCode |
| Ship-to Code | ShipToCode |
| Order Date | OrderDate |
| Posting Date | PostingDate |
| Shipment Date | ShipmentDate |
| Currency Factor | CurrencyFactor |
| Prices Including VAT | PricesIncludingVAT |
| Source Code | SourceCode |
| No_ | No |
| Sell-to Customer No_ | SellToCustomerNo |
| Bill-to Customer No_ | BillToCustomerNo |
| 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 |
| Dimension Set ID | DimensionSetID |
| Source Type | SourceType |
| Positive | Positive |
| 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 |
| Source Field Name | Destination Field Name |
| Name | Name |
| No_ | No |
| Source Field Name | Destination Field Name |
| Description | Description |
| Job No_ | JobNo |
| Job Task No_ | JobTaskNo |
| Source Field Name | Destination Field Name |
| Type | Type |
| Posting Date | PostingDate |
| 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 |
| Gen_ Bus_ Posting Group | GenBusPostingGroup |
| Gen_ Prod_ Posting Group | GenProdPostingGroup |
| Job Task No_ | JobTaskNo |
| Dimension Set ID | DimensionSetID |
| 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 |
| Source Field Name | Destination Field Name |
| Description | Description |
| No_ | No |
| Source Field Name | Destination Field Name |
| Ship-to Code | ShipToCode |
| Posting Date | PostingDate |
| Currency Factor | CurrencyFactor |
| Prices Including VAT | PricesIncludingVAT |
| Purchaser Code | PurchaserCode |
| Source Code | SourceCode |
| No_ | No |
| Buy-from Vendor No_ | BuyfromVendorNo |
| Pay-to Vendor No_ | PaytoVendorNo |
| 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 |
| Dimension Set ID | DimensionSetID |
| Source Field Name | Destination Field Name |
| Ship-to Code | ShipToCode |
| Order Date | OrderDate |
| Posting Date | PostingDate |
| Currency Factor | CurrencyFactor |
| Prices Including VAT | PricesIncludingVAT |
| Purchaser Code | PurchaserCode |
| Source Code | SourceCode |
| No_ | No |
| Buy-from Vendor No_ | BuyfromVendorNo |
| Pay-to Vendor No_ | PaytoVendorNo |
| 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 |
| Dimension Set ID | DimensionSetID |
| 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 |
| Dimension Set ID | DimensionSetID |
| Description | Description |
| Document Type | DocumentType |
| Document No_ | DocumentNo |
| 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 |
| 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 |
| Dimension Set ID | DimensionSetID |
| Source No_ | SourceNo |
| Source Type | SourceType |
| Source Field Name | Destination Field Name |
| Description | Description |
| No_ | No |
| Source Field Name | Destination Field Name |
| Planning Date | PlanningDate |
| Type | Type |
| Description | Description |
| Quantity | Quantity |
| Total Cost (LCY) | TotalCostLCY |
| Total Price (LCY) | TotalPriceLCY |
| Work Type Code | WorkTypeCode |
| Document Date | DocumentDate |
| Line Amount (LCY) | LineAmountLCY |
| Total Cost | TotalCost |
| Total Price | TotalPrice |
| Line Amount | LineAmount |
| Line Type | LineType |
| Variant Code | VariantCode |
| Job No_ | JobNo |
| Job Task No_ | JobTaskNo |
| Line No_ | LineNo |
| No_ | No |
| Resource Group No_ | ResourceGroupNo |
| Gen_ Bus_ Posting Group | GenBusPostingGroup |
| Gen_ Prod_ Posting Group | GenProdPostingGroup |
| Job Ledger Entry No_ | JobLedgerEntryNo |
| Source Field Name | Destination Field Name |
| Code | Code |
| Name | Name |
| Country_Region Code | CountryRegionCode |
| Customer No_ | CustomerNo |
| Source Field Name | Destination Field Name |
| Code | Code |
| Description | Description |
| Source Field Name | Destination Field Name |
| Item Category Code | ItemCategoryCode |
| Code | Code |
| Description | Description |
| 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 |
| Dimension Set ID | DimensionSetID |
| 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 |
| 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 |
| Dimension Set ID | DimensionSetID |
| 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 |
| Source Field Name | Destination Field Name |
| Dimension Set ID | DimensionSetID |
| Dimension Code | DimensionCode |
| Dimension Value Code | DimensionValueCode |
| Dimension Value ID | DimensionValueID |
| Source Field Name | Destination Field Name |
| Job No_ | JobNo |
| Job Task No_ | JobTaskNo |
| Job Planning Line No_ | JobPlanningLineNo |
| Document Type | DocumentType |
| Document No_ | DocumentNo |
| Line No_ | LineNo |
| Invoiced Date | InvoicedDate |
| Invoiced Amount (LCY) | InvoicedAmountLCY |
| Invoiced Cost Amount (LCY) | InvoicedCostAmountLCY |
| Job Ledger Entry No_ | JobLedgerEntryNo |
| Source Field Name | Destination Field Name |
| Code | Code |
| Description | Description |