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