Finance

Bus matrix

Account
Account
Account Name
Account No
Income Balance
Business Posting Group
Business Posting Group Code
Business Posting Group Description
Company
Company
Currency
Currency Code LCY
Selected Currency
Customer
Credit Limit Type
Customer
Customer Country
Customer Number
Customer Territory
Payment Terms
Customer Ledger
Customer Ledger Description
Customer Ledger DocumentNo
Customer Ledger DocumentType
Customer Ledger EntryNo
Detailed Customer Ledger Cust Ledger EntryNo
Detailed Customer Ledger Document No
Detailed Customer Ledger Document Type
Detailed Customer LedgerEntry No
Customer/Vendor Ledger
Aging Bucket
Cust Vend Document Type
Finance Reporting
Finance Statement Hierarchy
Finance Statement Line Name
Finance Statement Name
General Ledger
Closing Entries
General Ledger Budget
Budget Name
GL Transaction Details
GL Trans Description
GL Trans Document No
GL Trans Document Type
GL Trans Entry No
NAV Dimensions
Agentur Code
Agentur Name
Periods\Due Date
Due Date
Due Date YMD
Due Day Of Month
Due Month
Due Period
Due Quarter
Periods\Posting
Posting Date
Posting Day Of Month
Posting Month
Posting Period
Posting Quarter
Posting YMD
Posting Groups
Business Posting Group
Product Posting Group
Product Posting Group
Product Posting Group Code
Product Posting Group Description
Source
Source Code
Source Description
Vendor
Vendor
Vendor Country
Vendor Name
Vendor Number
Vendor Territory
Vendor Ledger
Vendor Ledger Description
Vendor Ledger Document No
Vendor Ledger Document Type
Vendor Ledger Entry No
Vendor Ledger EntryNo
Customer Ledger
Customer Balance x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Closed Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Closed Entry Count x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Credit Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Current Balance Due x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Current Balance Overdue x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Debit Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Overdue Entry Count x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Sales x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Total Number of Open Days x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Total Number of Overdue Days x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
General Ledger
GL Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
GL Amount RS x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
GL Credit Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
GL Debit Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
GL End Balance x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
GL Start Balance x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
General Ledger Budget
GL Budget Amount x x x x x x x x x x x x x x x x x x
GL Budget Amount LCY x x x x x x x x x x x x x x x x x x
GL Budget Amount RS x x x x x x x x x x x x x x x x x x
GL Budget Index x x x x x x x x x x x x x x x x x
GL Budget Index RS x x x x x x x x x x x x x x x x x
GL Budget Variance x x x x x x x x x x x x x x x x x
GL Budget Variance RS x x x x x x x x x x x x x x x x x
Vendor Ledger
Vendor Balance x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Vendor Ledger Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Vendor Ledger Closed Entry Count x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Vendor Ledger Credit Amount LCY x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Vendor Ledger Debit Amount LCY x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Vendor Ledger Overdue Entry Count x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Vendor Ledger Total Number of Open Days x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Vendor Ledger Total Number of Overdue Days x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x

Dimensions

    Account: The Number and Name of the General Ledger Account ((BC.G_L Account.No_) and (BC.G_L Account.Name))
    Account Name: The Name of the General Ledger Account (BC.G_L Account.Name)
    Account No: The Number of the General Ledger Account (BC.G_L Account.No_)
    Income Balance: Income Statement or Balance Sheet
    Business Posting Group: (BC.Gen_ Business Posting Group.Description)
    Business Posting Group Code: The Code for the Busines Posting Group (BC.Gen_ Business Posting Group.Code)
    Business Posting Group Description: The Description for the Busines Posting Group (BC.Gen_ Business Posting Group.Description)
    Company: Name of the Company [wdCompany.CompanyName]
    Currency Code LCY: Code for the Local Company Currency [wdCompany.CurrencyCodeLCY]
    Customer: The Number and Name of the Customer (BC.Customer.No_) (BC.Customer.Name)
    Credit Limit Type: Whether the Customer is With or Without Credit Limit ('With Credit Limit' or 'Without Credit Limit' - based on BC.Customer.Credit Limit (LCY))
    Customer Country: Hierarchy of the Customers Country (BC.Country_Region.Name) and the Customers Number and Name
    Customer Number: The Customer Number (BC.Customer.No_)
    Customer Territory: Hierarchy of the Customers Territory (BC.Territory.Name) and Customers Number and Name
    Payment Terms: Description of the Payment Terms (BC.Payment Terms.Description)
    Customer Ledger Description: (BC.Cust_ Ledger Entry.Description)
    Customer Ledger DocumentNo: (BC.Cust_ Ledger Entry.Document No_)
    Customer Ledger DocumentType: (BC.Cust_ Ledger Entry.Document Type)
    Customer Ledger EntryNo: (BC.Cust_ Ledger Entry.Entry No_)
    Aging Bucket: 'Not Due / On Time', '1-30 Days', '31-60 Days', '61-90 Days', 'Over 90 Days'
    Finance Statement Hierarchy: Hierarchy of Report Line Name and Account
    Closing Entries: 'Exclude Closing Entries' or 'Closing Entries only'
    Budget Name: (BC.G_L Budget Name.Name)
    Due Date: Date of Format YYYY-MM-DD
    Due Date YMD: Hierarchy of Year, Month and Date
    Due Day Of Month: The Day Number
    Due Month: Month Name
    Due Period: Hierarchy of Year, Quarter, Month, Date
    Due Quarter: The Quarter
    Posting Date: Date of Format YYYY-MM-DD
    Posting Day Of Month: The Day Number
    Posting Month: Month Name
    Posting Period: Hierarchy of Year, Quarter, Month, Date
    Posting Quarter: The Quarter
    Posting YMD: Hierarchy of Year, Month and Date
    Product Posting Group: (BC.Gen_ Product Posting Group.Description)
    Product Posting Group Code: (BC.Gen_ Product Posting Group.Code)
    Product Posting Group Description: (BC.Gen_ Product Posting Group.Description)
    Source Code: (BC.Source Code.Code)
    Source Description: (BC.Source Code.Description)
    Vendor: The Number and Name of a Vendor (BC.Vendor.No_) and (BC.Vendor.Name)
    Vendor Country: Hierarchy of the Vendor Country (BC.Country_Region.Name) and Vendor
    Vendor Name: Name of the Vendor (BC.Vendor.Name)
    Vendor Number: Number of the Vendor (BC.Vendor.No_)
    Vendor Territory: Hierarchy of the Vendor Territory (BC.Territory.Name) and the Vendor

Measures

Customer Balance
Aggregate function sum
Description ---
Format standard
Customer Ledger Amount
Aggregate function sum
Description The Ledger Amount in Local Company Currency for Customer (BC.Detailed Cust_ Ledg_ Entry.Amount (LCY))
Format standard
Customer Ledger Closed Amount
Aggregate function sum
Description The Ledger Closed Amount in Local Company Currency for Customer (BC.Detailed Cust_ Ledg_ Entry.Amount (LCY)) or 0
Format standard
Customer Ledger Closed Entry Count
Aggregate function sum
Description Count of Ledger Closed Entries for Customer
Format standard
Customer Ledger Credit Amount
Aggregate function sum
Description The Ledger Credit Amount in Local Company Currency for Customer (BC.Detailed Cust_ Ledg_ Entry.Credit Amount (LCY))
Format standard
Customer Ledger Current Balance Due
Aggregate function sum
Description ---
Format standard
Customer Ledger Current Balance Overdue
Aggregate function sum
Description ---
Format standard
Customer Ledger Debit Amount
Aggregate function sum
Description The Ledger Debit Amount in Local Company Currency for Customer (BC.Detailed Cust_ Ledg_ Entry.Debit Amount (LCY))
Format standard
Customer Ledger Overdue Entry Count
Aggregate function sum
Description The Ledger Count of Overdue Entries for Customer (BC.Cust_ Ledger Entry.Closed at Date) > (BC.Cust_ Ledger Entry.Due Date)
Format standard
Customer Ledger Sales
Aggregate function sum
Description The Ledger Sales in Local Company Currency for Customer (BC.Cust_ Ledger Entry.Sales (LCY))
Format standard
Customer Ledger Total Number of Open Days
Aggregate function sum
Description The Number of Days between the Posting Date and Closed at Date for Customer Ledger ((BC.Detailed Cust_ Ledg_ Entry.Posting Date) and (BC.Cust_ Ledger Entry.Closed at Date))
Format standard
Customer Ledger Total Number of Overdue Days
Aggregate function sum
Description The Number of Days between Due Date and Closed at Date for Customer Ledger (BC.Cust_ Ledger Entry.Due Date) and (BC.Cust_ Ledger Entry.Closed at Date))
Format standard
GL Amount
Aggregate function sum
Description The Amount for General Ledger Entry (BC.G_L Entry.Amount)
Format standard
GL Amount RS
Aggregate function sum
Description The GL Amount with the reverse sign given in the finance report setup
Format standard
GL Credit Amount
Aggregate function sum
Description The Credit Amount for General Ledger Entry (BC.G_L Entry.Credit Amount)
Format standard
GL Debit Amount
Aggregate function sum
Description The Debit Amount for General Ledger Entry (BC.G_L Entry.Debit Amount)
Format standard
GL End Balance
Aggregate function sum
Description The End (Ultimo) Balance Amount for General Ledger Entries based on Posting Date. All Ledger entries are summarized from first entry to selected posting period. Any GL dimensions can be used. (BC.G_L Entry.Amount)
Format standard
GL Start Balance
Aggregate function sum
Description The Start (Primo) Balance Amount for General Ledger Entries based on Posting Date. All Ledger entries are summarized from first entry to selected posting period. Any GL dimensions can be used. (BC.G_L Entry.Amount)
Format standard
GL Budget Amount
Aggregate function sum
Description The Budget Amount for General Ledger Budget (BC.G_L Budget Entry.Amount)
Format standard
GL Budget Amount LCY
Aggregate function sum
Description ---
Format standard
GL Budget Amount RS
Aggregate function sum
Description The GL Budget Amount with the reverse sign given in the finance report setup
Format standard
GL Budget Index - Calculation
Aggregate function
Description The index based on actual GL Amount divided by GL Budget (GL Amount / GL Budget Amount)
Format
GL Budget Index RS - Calculation
Aggregate function
Description The index based on actual GL Amount RS divided by GL Budget RS (GL Amount RS / GL Budget Amount RS)
Format
GL Budget Variance - Calculation
Aggregate function
Description The budget variance based on actual GL Amount and GL Budget Amount (GL Amount - GL Budget Amount)
Format
GL Budget Variance RS - Calculation
Aggregate function
Description The budget variance based on actual GL Amount RS and GL Budget Amount RS (GL Amount RS - GL Budget Amount RS)
Format
Vendor Balance
Aggregate function sum
Description ---
Format standard
Vendor Ledger Amount
Aggregate function sum
Description The Ledger Amount in Local Company Currency for Vendor (BC.Detailed Vendor Ledg_ Entry.Amount (LCY))
Format standard
Vendor Ledger Closed Entry Count
Aggregate function sum
Description The Count of Closed Entries for Vendor Ledger
Format standard
Vendor Ledger Credit Amount LCY
Aggregate function sum
Description The Ledger Credit Amount in Local Company Currency for Vendor (BC.Detailed Vendor Ledg_ Entry.Credit Amount (LCY))
Format standard
Vendor Ledger Debit Amount LCY
Aggregate function sum
Description The Ledegr Debit Amount in Local Company Currency for Vendor (BC.Detailed Vendor Ledg_ Entry.Debit Amount (LCY))
Format standard
Vendor Ledger Overdue Entry Count
Aggregate function sum
Description The Count of Overdue Entries for Vendor (BC.Vendor Ledger Entry.Closed at Date) > (BC.Vendor Ledger Entry.Due Date)
Format standard
Vendor Ledger Total Number of Open Days
Aggregate function sum
Description The Number of Days between Posting Date and Closed at Date for Vendor ((BC.Detailed Vendor Ledg_ Entry.Posting Date) and (BC.Vendor Ledger Entry.Closed at Date))
Format standard
Vendor Ledger Total Number of Overdue Days
Aggregate function sum
Description The Number of Days between Due Date and Closed at Date for Vendor ((BC.Vendor Ledger Entry.Due Date) and (BC.Vendor Ledger Entry.Closed at Date))
Format standard

Sales

Bus matrix

Business Posting Group
Business Posting Group Code
Business Posting Group Description
Company
Company
Currency
Currency Code LCY
Currency Code Posted
Selected Currency
Customer
Credit Limit Type
Customer
Customer Country
Customer Number
Customer Territory
Payment Terms
Item
Item
Item Category
Item Description
Item No
Item Vendor Number
Product Group
Sales Entity
Unit Of Measure
NAV Dimensions
Agentur Code
Agentur Name
Open Orders
Order Number
Periods\Order
Order Date
Order Day Of Month
Order Month
Order Period
Order Quarter
Order YMD
Periods\Posting
Posting Date
Posting Day Of Month
Posting Month
Posting Period
Posting Quarter
Posting YMD
Periods\Shipment
Shipment Date
Shipment Day Of Month
Shipment Month
Shipment Period
Shipment Quarter
Shipment YMD
Posting Groups
Business Posting Group
Product Posting Group
Product Posting Group
Product Posting Group Code
Product Posting Group Description
Sales Invoice
Invoice Number
Invoice Number or Memo Number
Sales Credit Memo Number
Salesperson/Purchaser
Salesperson Purchaser Code
Salesperson Purchaser Name
Source
Source Code
Source Description
Open Orders
Number of Open Orders x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x 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 x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Order Amount LCY x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Order Amount Selected Cur x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Order Line Cost x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Order Outstanding Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Order Outstanding Cost x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Order Outstanding Profit x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Order Outstanding Profit Pct x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Order Outstanding Quantity x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x 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 x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Order Profit Pct x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x 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 x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Order Quantity Shipped Not Invoiced x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Order Shipped Not Invoiced Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales
Cost x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x 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 x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Profit Pct x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x 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 x x x x x x x x x x x x x x x x 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 x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales Selected Cur x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales & Open Orders
Total Cost x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x 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 x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Total Profit Pct x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x 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 x x x x x x x x x x x x x x x 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 x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales Credit Memo
No of Credit Memo Invoices x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales Credit Memo Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales Credit Memo Amount LCY x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales Credit Memo Amount Selected Cur x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales Credit Memo Line Cost x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales Credit Memo Quantity x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales Invoice
Number of Sales Invoices x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x 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 x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales Invoice Amount LCY x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales Invoice Amount Posted Cur x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales Invoice Amount Selected Cur x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales Invoice Days Since Last Invoice x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales Invoice Line Cost x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales Invoice Profit x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sales Invoice Profit % x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x 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 x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x

Dimensions

    Business Posting Group: (BC.Gen_ Business Posting Group.Description)
    Business Posting Group Code: The Code for the Busines Posting Group (BC.Gen_ Business Posting Group.Code)
    Business Posting Group Description: The Description for the Busines Posting Group (BC.Gen_ Business Posting Group.Description)
    Company: Name of the Company [wdCompany.CompanyName]
    Currency Code LCY: Code for the Local Company Currency [wdCompany.CurrencyCodeLCY]
    Customer: The Number and Name of the Customer (BC.Customer.No_) (BC.Customer.Name)
    Credit Limit Type: Whether the Customer is With or Without Credit Limit ('With Credit Limit' or 'Without Credit Limit' - based on BC.Customer.Credit Limit (LCY))
    Customer Country: Hierarchy of the Customers Country (BC.Country_Region.Name) and the Customers Number and Name
    Customer Number: The Customer Number (BC.Customer.No_)
    Customer Territory: Hierarchy of the Customers Territory (BC.Territory.Name) and Customers Number and Name
    Payment Terms: Description of the Payment Terms (BC.Payment Terms.Description)
    Item: (BC.Item.No_) and (BC.Item.Description)
    Item Category: Hierarchy of (BC.Item Category.Description) and Item
    Item Description: The Item Description (BC.Item.Description)
    Item No: The Item Number (BC.Item.No_)
    Item Vendor Number: The Vendor Number (BC.Item.Vendor No_)
    Product Group: Hierarchy of (BC.Product Group.Description) and Item
    Sales Entity: Hierarchy of Type and Item
    Order Number: (BC.Sales Header.No_)
    Order Date: Date of Format YYYY-MM-DD
    Order Day Of Month: The Day Number
    Order Month: Month Name
    Order Period: Hierarchy of Year, Quarter, Month, Date
    Order Quarter: The Quarter
    Order YMD: Hierarchy of Year, Month and Date
    Posting Date: Date of Format YYYY-MM-DD
    Posting Day Of Month: The Day Number
    Posting Month: Month Name
    Posting Period: Hierarchy of Year, Quarter, Month, Date
    Posting Quarter: The Quarter
    Posting YMD: Hierarchy of Year, Month and Date
    Shipment Date: Date of Format YYYY-MM-DD
    Shipment Day Of Month: The Day Number
    Shipment Month: Month Name
    Shipment Period: Hierarchy of Year, Quarter, Month, Date
    Shipment Quarter: The Quarter
    Shipment YMD: Hierarchy of Year, Month and Date
    Product Posting Group: (BC.Gen_ Product Posting Group.Description)
    Product Posting Group Code: (BC.Gen_ Product Posting Group.Code)
    Product Posting Group Description: (BC.Gen_ Product Posting Group.Description)
    Invoice Number: (BC.Sales Invoice Header.No_)
    Invoice Number or Memo Number: Contains either the Invoice Number or the Credit Memo Number
    Sales Credit Memo Number: (BC.Sales Cr_Memo Header.No_)
    Salesperson Purchaser Code: (BC.Salesperson_Purchaser.Code)
    Salesperson Purchaser Name: (BC.Salesperson_Purchaser.Name)
    Source Code: (BC.Source Code.Code)
    Source Description: (BC.Source Code.Description)

Measures

Number of Open Orders
Aggregate function distinctcount
Description The Distinct Count of Document Numbers for Sales (BC.Sales Line.Document No_)
Format #,#
Order Amount
Aggregate function sum
Description The Order Amount in Local Company Currency for Sales (((BC.Sales Line.Line Amount) / (BC.Sales Header.Currency Factor)) - ((BC.Sales Line.Inv_ Discount Amount) / (BC.Sales Header.Currency Factor)))
Format standard
Order Amount LCY
Aggregate function sum
Description ---
Format standard
Order Amount Selected Cur
Aggregate function sum
Description ---
Format standard
Order Line Cost
Aggregate function sum
Description The Order Line Cost in Local Company Currency for Sales (BC.Sales Line.Quantity) * (BC.Sales Line.Unit Cost (LCY))
Format standard
Order Outstanding Amount
Aggregate function sum
Description The Outstanding Amount in Local Company Currency from Orders for Sales ([Order Amount] / (BC.Sales Line.Quantity)) * ((BC.Sales Line.Quantity) - (BC.Sales Line.Quantity Invoiced))
Format standard
Order Outstanding Cost
Aggregate function sum
Description The Outstanding Cost in Local Company Currency from Orders for Sales ((BC.Sales Line.Quantity) - (BC.Sales Line.Quantity Invoiced)) * (BC.Sales Line.Unit Cost (LCY))
Format standard
Order Outstanding Profit - Calculation
Aggregate function
Description [Order Outstanding Amount]-[Order Outstanding Cost]
Format standard
Order Outstanding Profit Pct - Calculation
Aggregate function
Description [Order Outstanding Profit]/[Order Outstanding Amount]*100
Format standard
Order Outstanding Quantity
Aggregate function sum
Description The Outstanding Quantity from Orders for Sales (BC.Sales Line.Quantity) - (BC.Sales Line.Quantity Invoiced)
Format #,#
Order Profit - Calculation
Aggregate function
Description [Order Amount]-[Order Line Cost]
Format standard
Order Profit Pct - Calculation
Aggregate function
Description [Order Profit]/[Order Amount]*100
Format standard
Order Quantity
Aggregate function sum
Description The Quantity of Orders for Sales (BC.Sales Line.Quantity)
Format #,#
Order Quantity Shipped Not Invoiced
Aggregate function sum
Description The Quantity of Shipped Orders that is Not Invoiced for Sales (BC.Sales Line.Qty_ Shipped Not Invoiced)
Format #,#
Order Shipped Not Invoiced Amount
Aggregate function sum
Description The Amount in Local Company Currency for Shipped Orders that is Not Invoiced for Sales ([Order Amount] / (BC.Sales Line.Quantity)) * (BC.Sales Line.Qty_ Shipped Not Invoiced)
Format standard
Cost - Calculation
Aggregate function
Description coalesce([Sales Invoice Line Cost]-[Sales Credit Memo Line Cost],[Sales Invoice Line Cost])
Format
Profit - Calculation
Aggregate function
Description [Sales]-[Cost]
Format
Profit Pct - Calculation
Aggregate function
Description [Profit]/[Sales]*100
Format
Quantity - Calculation
Aggregate function
Description coalesce([Sales Invoice Quantity]-[Sales Credit Memo Quantity],[Sales Invoice Quantity])
Format
Sales - Calculation
Aggregate function
Description coalesce([Sales Invoice Amount]-[Sales Credit Memo Amount],[Sales Invoice Amount])
Format
Sales Selected Cur - Calculation
Aggregate function
Description coalesce([Sales Invoice Amount Selected Cur]-[Sales Credit Memo Amount Selected Cur],[Sales Invoice Amount Selected Cur])
Format
Total Cost - Calculation
Aggregate function
Description coalesce([Cost]+[Order Outstanding Cost],[Cost])
Format
Total Profit - Calculation
Aggregate function
Description [Total Sales]-[Total Cost - Sales]
Format
Total Profit Pct - Calculation
Aggregate function
Description [Total Profit]/[Total Sales]*100
Format
Total Quantity - Calculation
Aggregate function
Description coalesce([Quantity]+[Order Outstanding Quantity],[Quantity])
Format
Total Sales - Calculation
Aggregate function
Description coalesce([Sales]+[Order Outstanding Amount],[Sales])
Format
No of Credit Memo Invoices
Aggregate function distinctcount
Description The Distinct Count of Document Numbers for Sales Credit Memo (BC.Sales Cr_Memo Line.Document No_)
Format standard
Sales Credit Memo Amount
Aggregate function sum
Description The Amount in Local Company Currency for Sales Credit Memo (((BC.Sales Credit Memo.Line Amount) / (BC.Sales Header.Currency Factor)) - ((BC.Sales Credit Memo.Inv_ Discount Amount) / (BC.Sales Header.Currency Factor)))
Format standard
Sales Credit Memo Amount LCY
Aggregate function sum
Description ---
Format standard
Sales Credit Memo Amount Selected Cur
Aggregate function sum
Description ---
Format standard
Sales Credit Memo Line Cost
Aggregate function sum
Description The Line Cost in Local Company Currency for Sales Credit Memo (BC.Sales Cr_Memo Line.Quantity) * (BC.Sales Cr_Memo Line.Unit Cost (LCY))
Format standard
Sales Credit Memo Quantity
Aggregate function sum
Description The Quantity for Sales Credit Memo (BC.Sales Cr_Memo Line.Quantity)
Format #,#
Number of Sales Invoices
Aggregate function distinctcount
Description The Distinct Count of Document Numbers for Sales Invoices (BC.Sales Invoice Line.Document No_)
Format standard
Sales Invoice Amount
Aggregate function sum
Description The Sales Invoice Amount in Local Company Currency (((BC.Sales Invoice Line.Line Amount) / (BC.Sales Header.Currency Factor)) - ((BC.Sales Invoice Line.Inv_ Discount Amount) / (BC.Sales Header.Currency Factor)))
Format standard
Sales Invoice Amount LCY
Aggregate function sum
Description ---
Format standard
Sales Invoice Amount Posted Cur
Aggregate function sum
Description ---
Format standard
Sales Invoice Amount Selected Cur
Aggregate function sum
Description ---
Format standard
Sales Invoice Days Since Last Invoice
Aggregate function sum
Description The Number of Days Since Last Invoice for Sales Invoice (Number of Days from (BC.Sales Invoice Line.Posting Date) to Today)
Format standard
Sales Invoice Line Cost
Aggregate function sum
Description The Line Cost in Local Company Currency for Sales Invoice ((BC.Sales Invoice Line.Quantity) * (BC.Sales Invoice Line.Unit Cost (LCY))
Format standard
Sales Invoice Profit - Calculation
Aggregate function
Description [Sales Invoice Amount]-[Sales Invoice Line Cost]
Format standard
Sales Invoice Profit % - Calculation
Aggregate function
Description [Sales Invoice Profit]/[Sales Invoice Amount]*100
Format standard
Sales Invoice Quantity
Aggregate function sum
Description The Quantity for Sales Invoice (BC.Sales Invoice Line.Quantity)
Format #,#

Inventory

Bus matrix

Company
Company
Currency
Currency Code LCY
Customer
Credit Limit Type
Customer
Customer Country
Customer Number
Customer Territory
Payment Terms
Inventory
Inventory EntryType
Inventory Main Type
Value Entry Type
Inventory Posting Group
Inventory Posting Group Code
Inventory Posting Group Description
Item
Item
Item Category
Item Description
Item No
Item Vendor Number
Product Group
Location
Location Code
Location Name
NAV Dimensions
Agentur Code
Agentur Name
Periods\Posting
Posting Date
Posting Day Of Month
Posting Month
Posting Period
Posting Quarter
Posting YMD
Source
Source Code
Source Description
Vendor
Vendor
Vendor Country
Vendor Name
Vendor Number
Vendor Territory
Inventory\On Hand
On Hand x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
On Hand Invoiced x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
On Hand Invoiced Start Period x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
On Hand Start Period x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Inventory\Value
Cost Including Expected Value x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Cost Including Expected Value Start Period x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Cost Posted to GL Value x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Cost Posted to GL Value Start Period x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Invoiced Value x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Invoiced Value Start Period x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x

Dimensions

    Company: Name of the Company [wdCompany.CompanyName]
    Currency Code LCY: Code for the Local Company Currency [wdCompany.CurrencyCodeLCY]
    Customer: The Number and Name of the Customer (BC.Customer.No_) (BC.Customer.Name)
    Credit Limit Type: Whether the Customer is With or Without Credit Limit ('With Credit Limit' or 'Without Credit Limit' - based on BC.Customer.Credit Limit (LCY))
    Customer Country: Hierarchy of the Customers Country (BC.Country_Region.Name) and the Customers Number and Name
    Customer Number: The Customer Number (BC.Customer.No_)
    Customer Territory: Hierarchy of the Customers Territory (BC.Territory.Name) and Customers Number and Name
    Payment Terms: Description of the Payment Terms (BC.Payment Terms.Description)
    Inventory EntryType: (BC.Item Ledger Entry.Entry Type) or 'n/a'
    Inventory Main Type: Hierarchy of Entry Main Type and Entry Type
    Value Entry Type: (BC.Value Entry.Entry Type) or 'n/a'
    Inventory Posting Group Code: (BC.Inventory Posting Group.Code)
    Inventory Posting Group Description: (BC.Inventory Posting Group.Description)
    Item: (BC.Item.No_) and (BC.Item.Description)
    Item Category: Hierarchy of (BC.Item Category.Description) and Item
    Item Description: The Item Description (BC.Item.Description)
    Item No: The Item Number (BC.Item.No_)
    Item Vendor Number: The Vendor Number (BC.Item.Vendor No_)
    Product Group: Hierarchy of (BC.Product Group.Description) and Item
    Location Code: (BC.Location.Code)
    Location Name: (BC.Location.Name)
    Posting Date: Date of Format YYYY-MM-DD
    Posting Day Of Month: The Day Number
    Posting Month: Month Name
    Posting Period: Hierarchy of Year, Quarter, Month, Date
    Posting Quarter: The Quarter
    Posting YMD: Hierarchy of Year, Month and Date
    Source Code: (BC.Source Code.Code)
    Source Description: (BC.Source Code.Description)
    Vendor: The Number and Name of a Vendor (BC.Vendor.No_) and (BC.Vendor.Name)
    Vendor Country: Hierarchy of the Vendor Country (BC.Country_Region.Name) and Vendor
    Vendor Name: Name of the Vendor (BC.Vendor.Name)
    Vendor Number: Number of the Vendor (BC.Vendor.No_)
    Vendor Territory: Hierarchy of the Vendor Territory (BC.Territory.Name) and the Vendor

Measures

On Hand
Aggregate function sum
Description ---
Format standard
On Hand Invoiced
Aggregate function sum
Description ---
Format standard
On Hand Invoiced Start Period
Aggregate function sum
Description ---
Format standard
On Hand Start Period
Aggregate function sum
Description ---
Format standard
Cost Including Expected Value
Aggregate function sum
Description ---
Format standard
Cost Including Expected Value Start Period
Aggregate function sum
Description ---
Format standard
Cost Posted to GL Value
Aggregate function sum
Description ---
Format standard
Cost Posted to GL Value Start Period
Aggregate function sum
Description ---
Format standard
Invoiced Value
Aggregate function sum
Description ---
Format standard
Invoiced Value Start Period
Aggregate function sum
Description ---
Format standard

Purchase

Bus matrix

Company
Company
Currency
Currency Code LCY
NAV Dimensions
Agentur Code
Agentur Name
Periods\Order
Order Date
Order Day Of Month
Order Month
Order Period
Order Quarter
Order YMD
Periods\Posting
Posting Date
Posting Day Of Month
Posting Month
Posting Period
Posting Quarter
Posting YMD
Purchase
Purchase
Purchase Credit Memo Number
Purchase Entity
Purchase Invoice Number
Purchase Order Number
Salesperson/Purchaser
Salesperson Purchaser Code
Salesperson Purchaser Name
Source
Source Code
Source Description
Vendor
Vendor
Vendor Country
Vendor Name
Vendor Number
Vendor Territory
Open Purchase Orders
Purchase Order Amount x x x x x x x x x x x x x x x x x x x x x x x x x
Purchase Order Quantity x x x x x x x x x x x x x x x x x x x x x x x x x
Purchase Outstanding Amount x x x x x x x x x x x x x x x x x x x x x x x x x
Purchase Outstanding Quantity x x x x x x x x x x x x x x x x x x x x x x x x x
Purchase
Average Cost Price x x x x x x x x x x x x x x x x x x x x x x x x x x
Purchase x x x x x x x x x x x x x x x 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 x x x 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 x x x 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 x x x 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 x x x x x x x x x x x x x x x
Purchase Quantity x x x x x x x x x x x x x x x x x x x x x x x x x x
Total Average Purchase Cost x x x x x x x x x x x x x x x x x x x x x x x x
Total Purchase x x x x x x x x x x x x x x x x x x x x x x x x
Total Purchase Quantity x x x x x x x x x x x x x x x x x x x x x x x x

Dimensions

    Company: Name of the Company [wdCompany.CompanyName]
    Currency Code LCY: Code for the Local Company Currency [wdCompany.CurrencyCodeLCY]
    Order Date: Date of Format YYYY-MM-DD
    Order Day Of Month: The Day Number
    Order Month: Month Name
    Order Period: Hierarchy of Year, Quarter, Month, Date
    Order Quarter: The Quarter
    Order YMD: Hierarchy of Year, Month and Date
    Posting Date: Date of Format YYYY-MM-DD
    Posting Day Of Month: The Day Number
    Posting Month: Month Name
    Posting Period: Hierarchy of Year, Quarter, Month, Date
    Posting Quarter: The Quarter
    Posting YMD: Hierarchy of Year, Month and Date
    Purchase Credit Memo Number: (BC.Purch_ Cr_ Memo Hdr_.No_)
    Purchase Entity: Hierarchy of Purchase Entity and Item
    Purchase Invoice Number: (BC.Purch_ Inv_ Header.No_)
    Purchase Order Number: (BC.Purchase Header.No_)
    Salesperson Purchaser Code: (BC.Salesperson_Purchaser.Code)
    Salesperson Purchaser Name: (BC.Salesperson_Purchaser.Name)
    Source Code: (BC.Source Code.Code)
    Source Description: (BC.Source Code.Description)
    Vendor: The Number and Name of a Vendor (BC.Vendor.No_) and (BC.Vendor.Name)
    Vendor Country: Hierarchy of the Vendor Country (BC.Country_Region.Name) and Vendor
    Vendor Name: Name of the Vendor (BC.Vendor.Name)
    Vendor Number: Number of the Vendor (BC.Vendor.No_)
    Vendor Territory: Hierarchy of the Vendor Territory (BC.Territory.Name) and the Vendor

Measures

Purchase Order Amount
Aggregate function sum
Description The Order Amount in Local Company Currency for Purchase (((BC.Purchase Line.Line Amount) / (BC.Purch_ Inv_ Header.Currency Factor)) - ((BC.Purchase Line.Inv_ Discount Amount) / (BC.Purch_ Inv_ Header.Currency Factor)))
Format standard
Purchase Order Quantity
Aggregate function sum
Description The Quantity of Orders for Purchase (BC.Purchase Line.Quantity)
Format #,#
Purchase Outstanding Amount
Aggregate function sum
Description The Outstanding Amount in Local Company Currency for Purchase Orders ([Purchase Order Amount] / (BC.Purchase Line.Quantity)) * ((BC.Purchase Line.Quantity) - (BC.Purchase Line.Quantity Invoiced))
Format standard
Purchase Outstanding Quantity
Aggregate function sum
Description The Outstanding Quantity from Purchase Orders ((BC.Purchase Line.Quantity) - (BC.Purchase Line.Quantity Invoiced))
Format #,#
Average Cost Price - Calculation
Aggregate function
Description [Purchase]/[Purchase Quantity]
Format
Purchase - Calculation
Aggregate function
Description COALESCE([Purchase Invoice Amount]-[Purchase Credit Memo Amount],[Purchase Invoice Amount])
Format
Purchase Credit Memo Amount
Aggregate function sum
Description The Amount in Local Company Currency for Purchase Credit Memo (((BC.Purch_ Cr_ Memo Line.Line Amount) / (BC.Purch_ Inv_ Header.Currency Factor)) - ((BC.Purch_ Cr_ Memo Line.Inv_ Discount Amount) / (BC.Purch_ Inv_ Header.Currency Factor)))
Format standard
Purchase Credit Memo Quantity
Aggregate function sum
Description The Quantity for Purchase Credit Memo (BC.Purch_ Cr_ Memo Line.Quantity)
Format standard
Purchase Invoice Amount
Aggregate function sum
Description The Invoice Amount in Local Company Currency for Purchase (((BC.Purch_ Inv_ Line.Line Amount) / (BC.Purch_ Inv_ Header.Currency Factor)) - ((BC.Purch_ Inv_ Line.Inv_ Discount Amount) / (BC.Purch_ Inv_ Header.Currency Factor)))
Format standard
Purchase Invoice Quantity
Aggregate function sum
Description The Invoice Quantity for Purchase (BC.Purch_ Inv_ Line.Quantity)
Format #,#
Purchase Quantity - Calculation
Aggregate function
Description COALESCE([Purchase Invoice Quantity]-[Purchase Credit Memo Quantity],[Purchase Invoice Quantity])
Format
Total Average Purchase Cost - Calculation
Aggregate function
Description [Total Purchase]/[Total Purchase Quantity]
Format
Total Purchase - Calculation
Aggregate function
Description COALESCE([Purchase]+[Purchase Outstanding Amount],[Purchase])
Format
Total Purchase Quantity - Calculation
Aggregate function
Description COALESCE([Purchase Quantity]+[Purchase Order Quantity],[Purchase Quantity])
Format

Master

Bus matrix

Account
Account
Account Name
Account No
Income Balance
Business Posting Group
Business Posting Group Code
Business Posting Group Description
Campaign
Campaign
Campaign Description
Campaign Number
Campaign Status
Company
Company
Contact
Contact
Contact Name
Contact Number
CRM
Chances of Success Pct
Closed Description
Completed Pct
Probability Pct
Currency
Currency Code LCY
Currency Code Posted
Selected Currency
Customer
Credit Limit Type
Customer
Customer Country
Customer Number
Customer Territory
Payment Terms
Customer Ledger
Customer Ledger Description
Customer Ledger DocumentNo
Customer Ledger DocumentType
Customer Ledger EntryNo
Detailed Customer Ledger Cust Ledger EntryNo
Detailed Customer Ledger Document No
Detailed Customer Ledger Document Type
Detailed Customer LedgerEntry No
Customer/Vendor Ledger
Aging Bucket
Cust Vend Document Type
Finance Reporting
Finance Statement Hierarchy
Finance Statement Line Name
Finance Statement Name
General Ledger
Closing Entries
General Ledger Budget
Budget Name
GL Transaction Details
GL Trans Description
GL Trans Document No
GL Trans Document Type
GL Trans Entry No
Inventory
Inventory EntryType
Inventory Main Type
Value Entry Type
Inventory Posting Group
Inventory Posting Group Code
Inventory Posting Group Description
Item
Item
Item Category
Item Description
Item No
Item Vendor Number
Product Group
Sales Entity
Unit Of Measure
Job
Job
Job Description
Job Number
Job Status
Job Task
Location
Location Code
Location Name
NAV Dimensions
Agentur Code
Agentur Name
Open Orders
Order Number
Opportunity
Opportunity Closed
Opportunity Description
Opportunity Entry Active
Opportunity Priority
Opportunity Status
Periods\Due Date
Due Date
Due Date YMD
Due Day Of Month
Due Month
Due Period
Due Quarter
Periods\Order
Order Date
Order Day Of Month
Order Month
Order Period
Order Quarter
Order YMD
Periods\Posting
Posting Date
Posting Day Of Month
Posting Month
Posting Period
Posting Quarter
Posting YMD
Periods\Shipment
Shipment Date
Shipment Day Of Month
Shipment Month
Shipment Period
Shipment Quarter
Shipment YMD
Posting Groups
Business Posting Group
Product Posting Group
Product Posting Group
Product Posting Group Code
Product Posting Group Description
Purchase
Purchase
Purchase Credit Memo Number
Purchase Entity
Purchase Invoice Number
Purchase Order Number
Sales Cycle
Sales Cycle
Sales Cycle Stage
Sales Invoice
Invoice Number
Invoice Number or Memo Number
Sales Credit Memo Number
Salesperson/Purchaser
Salesperson Purchaser Code
Salesperson Purchaser Name
Source
Source Code
Source Description
Update Times
Cube
LastUpdated
Vendor
Vendor
Vendor Country
Vendor Name
Vendor Number
Vendor Territory
Vendor Ledger
Vendor Ledger Description
Vendor Ledger Document No
Vendor Ledger Document Type
Vendor Ledger Entry No
Vendor Ledger EntryNo
CRM
Calculated Current Value x x x x x x x x x x x x x x 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 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 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 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 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 x x x x x x x x x x x x x x
Customer Ledger
Customer Balance x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Closed Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Closed Entry Count x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Credit Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Current Balance Due x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Current Balance Overdue x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Debit Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Overdue Entry Count x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Sales x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Total Number of Open Days x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Customer Ledger Total Number of Overdue Days x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
General Ledger
GL Amount x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
GL Amount RS x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
GL Credit Amount x x x x x x x