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