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