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 |
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
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 |