The Financial Balances dataset includes fields from the Reporting Balances, Transaction, and Transaction Line objects in FinancialForce Accounting, as well as other associated objects. The fields are:
|
Field |
Description |
|---|---|
| Account ID | The identification number of the account. |
| Account Name | The name of the account. |
| Balance Sheet 1 to 3 |
See What is a Reporting Hierarchy? and Setting up a Reporting Hierarchy in the Accounting Help for more information on how these fields are used. |
| Balance Type | The type of balance record. For example, Actual or Budget. See the Reporting Balances object. |
| Bank Account ID | The identification number of the bank account. |
| Cash Flow Adjustment (s) | The value of the Reclassify Profits object in the Reporting Balances object, if it exists, or the related value of the General Ledger Account object. |
| Cash Flow Category (s) | The category of the cashflow. See the Reporting Balances object. |
| Cash Flow Line Summary (s) | The value of the Cash Flow Line Summary object in the Reporting Balances object, if it exists, or the related value of the General Ledger Account object. |
| Company ID | The identification number of the company. |
| Company Name | The name of the company. See the Company object. |
| Number of Days in Period | The number of days in the period. Calculation is: (PeriodEndDate - PeriodStartDate) +1. If it is a special period, the value will be 0. |
| Dimension 1 Name | The name of the dimension 1. See the Dimension 1 object. |
| Dimension 2 Name | The name of the dimension 2. See the Dimension 2 object. |
| Dimension 3 Name | The name of the dimension 3. See the Dimension 3 object. |
| Dimension 4 Name | The name of the dimension 4. See the Dimension 4 object. |
| Document Currency | The currency ISO code recorded on the related document. |
| Dual Currency | The currency ISO code in which your corporate headquarters reports. |
| DueDate | The due date for the transaction. See the Transaction object. When the transaction document is of the type Journal, Currency Revaluation or Cash Matching Journal and the due date field is empty, this field is then populated with the transaction date. |
| General Ledger Account Code | The code of the general ledger account, if applicable. See the General Ledger Account object. |
| General Ledger Account ID | The identification number of the general ledger account. |
| General Ledger Account Name | The name of the general ledger account. See the General Ledger Account object. |
| General Ledger Account Name (s) | The name of the general ledger account without its code prefix. See the General Ledger Account object. |
| General Ledger Account Type | The type of general ledger account. For example, Balance Sheet or Income Statement. See the General Ledger Account object. |
| Home Currency | The main working currency ISO code of the current company. |
| Intersect Definition (s) | The definition of the intersect. Full is the default definition. See the Intersect Definition object. |
| Local GLA | The related local GLA, if this transaction is to be posted in both a corporate GLA and a related local GLA to enable reporting to more than one statutory body. |
| Local GLA Currency | The currency recorded on the related local GLA, if this transaction is to be posted in both a corporate GLA and a related local GLA to enable reporting to more than one statutory body. |
| Local GLA Value | The total value of the line in the local GLA currency, if this transaction is to be posted in both a corporate GLA and a related local GLA to enable reporting to more than one statutory body. |
| Financial Period End Date | The end date of the period in which the transaction or balance occurs. |
| Financial Period Name | The period of the transaction. |
| Financial Period | The number of the period, stored as a string. |
| Financial Period (s) | The number of the period, stored as a number. |
| Financial Period Start Date | The start date of the period. |
| Financial Special Period (s) | The name of the special periods. For example, 000 (Opening Period), 100 (Adjustment Period), 101 (Closing Period). |
| Financial Year | The name of the year and period associated with the transaction or balance. |
| Financial Year (s) | The number of the year and period associated with the transaction or balance. |
| Financial Year and Period (s) | The name of the year and number of the period represented by a string. |
| Financial Year and Period (s) | The name of the year and number of the period represented by a number. |
| Product ID | The identification number of the product. |
| Product Name | The name of the product. See the standard product object. |
| Quarter |
The periods are calculated as follows: Period 100 and 101 have their own quarter, [100] and [101] respectively. |
| Record ID | The identification number of the record. |
| TB1 Order | Hidden field. Used to sort the data in the same order as the picklist values in the Trial Balance 1 object. If you update or add a value from this picklist, in the App you must click Reconfigure to apply changes to the dashboard. |
| TB2 Order | Hidden field. Used to sort the data in the same order as the picklist values in the Trial Balance 2 object. If you update or add a value from this picklist, in the App you must click Reconfigure to apply changes to the dashboard. |
| TB3 Order | Hidden field. Used to sort the data in the same order as the picklist values in the Trial Balance 3 object. If you update or add a value from this picklist, in the App you must click Reconfigure to apply changes to the dashboard. |
| TB4 Order | Hidden field. Used to sort the data in the same order as the picklist values in the Trial Balance 4 object. If you update or add a value from this picklist, in the App you must click Reconfigure to apply changes to the dashboard. |
| Transaction Document Description | The header description of the transaction. See the Transaction object. |
| Transaction Document Number | The transaction document number. See the Transaction object. |
| Transaction ID | The identification number of the transaction. |
| Transaction Line Description | The line description of the transaction. See the Transaction Line object. |
| Transaction Line Name | The number of the transaction line. See the Transaction Line object. |
| Transaction Name | The name of the transaction. See the Transaction object. |
| Transaction Type | The type of transaction. See the Transaction object. |
| Trial Balance 1 | The name of the trial balance 1. See the General Ledger Account object. |
| Trial Balance 2 | The name of the trial balance 2. See the General Ledger Account object. |
| Trial Balance 3 | The name of the trial balance 3. See the General Ledger Account object. |
| Trial Balance 4 | The name of the trial balance 4. See the General Ledger Account object. |
| Dual Value | The total value in dual currency. See the Transaction object. |
| Dual Cr Value | The credit value in dual currency. |
| Dual Cr Value (s) | The credit value in dual currency, but with the signage reversed. |
| Dual Dr Value | The debit value in dual currency. |
| Dual Dr Value (s) | The debit value in dual currency, but with the signage reversed. |
| Dual Value (s) | The value in dual currency, but with the signage reversed. Sales are shown as positive values rather than negative values. |
| Home Value | The total value in your home currency. |
| Home Cr Value | The credit value in your home currency. |
| Home Cr Value (s) | The credit value in your home currency, but with the signage reversed. |
| Home Dr Value | The debit value in your home currency. |
| Home Dr Value (s) | The debit value in your home currency, but with the signage reversed. |
| Home Value (s) | The total value in your home currency, but with the signage reversed. Sales are shown as positive values rather than negative values. |
| Accounting Book ID | The identification number of the accounting book. |
| Accounting Book Name | The name of the accounting book. |
| Primary Accounting Book | The name of the accounting book selected as the primary book for the org. This is defined by the primary book field in the accounting book object in Accounting. |
| Reverse Transaction Name | The name of the reversed transaction record. |
| Reverse Transaction ID | The ID number of the reverse transaction record. |
| Reverse Transaction Reason | This is a text field that describes the reason for the transaction reversal. For more information, see Reversing an Allocation Transaction in the Accounting Online Help. |
| Date Canceled | Date the related payment was canceled, associated with the transaction line item. |
| Discount Account Value 1 — 4 | The discount value of the account information of the Line Transaction object in Accounting. |
| Discount Document Value 1 — 4 | The discount value of the document information of the Line Transaction object in Accounting. |
| Intercompany Transfer ID | The identification number of the intercompany transaction record associated with the transaction line item. |
| Intercompany Transfer Name | Lookup to the intercompany transfer record associated with the transaction line item. |
| Last Customer Statement Date | The last customer statement date associated with the transaction line item. |
| Last Reminder Date | The date that the last reminder was sent for the transaction line item. |
| Severity | The severity level of the last reminder sent for the invoice. |
| Version | The version associated with the transaction line item. |
| Account Name (Bank Account) | Name by which the account is known at the bank. |
| Bank Account Number | The number of the bank account. |
| Bank Account Currency ID | The system identification number corresponding to the accounting currency. |
| Bank Account Currency Name | The ISO code of the accounting currency associated with the bank account. |
| Bank Account Bank Name | The name of the bank that the bank account belongs to. |
| Bank Account City | The city address line for the bank account. |
| Bank Account Country | The country address line for the bank account. |
| Bank Account IBAN Number | The IBAN number associated with the bank account. |
| Bank Account Reporting Code | The reporting code associated with the bank account. |
| Bank Account Sort Code | The SORT code associated with the bank account. |
| Bank Account State/Province | The state or province address line for the bank account. |
| Bank Account Street | The street address line for the bank account. |
| Bank Account SWIFT Number | The SWIFT number associated with the bank account. |
| Bank Account Zip/Postal Code | The ZIP code or postal code associated with the bank account. |
| Bank Account Name | The name of the bank account. |
| Chart of Accounts Structure Name | The name of the chart of accounts structure associated with the general ledger account. |
| Chart of Accounts Structure ID | The identification number of the chart of accounts structure associated with the general ledger account. |
| Intersect Definition Core Accounting Code | Details of the intersect definition object associated with the record. For more information, see the Intersect Definition Object in Accounting. |
| Intersect Definition Dimension X | Details of the intersect definition object associated with the record. For more information, see the Intersect Definition Object in Accounting. |
| Intersect Definition Entity | Details of the intersect definition object associated with the record. For more information, see the Intersect Definition Object in Accounting. |
| Intersect Definition GLA | Details of the intersect definition object associated with the record. For more information, see the Intersect Definition Object in Accounting. |
| Intersect Definition Local GLA | Details of the intersect definition object associated with the record. For more information, see the Intersect Definition Object in Accounting. |
| Financial Year End Processing Date | Date the year end process was run. |
| Financial Year End Mode | The default processing mode for the year end process. For more information, see Year and Period Fields in Accounting. |
| Financial Year Status | Status of the year, such as Open, Closing, Closed or Error. Set by the year end process in Accounting. |
| Cash Entry Type | The type of transaction related to the cash entry record in Accounting. |
| Financial Period Is AP | Indicates the financial period is closed to the Accounts Payable General Ledger Account group. The data for this field is derived from the Period object in Accounting. |
| Financial Period Is AR | Indicates the financial period is closed to the Accounts Receivable General Ledger Account group. The data for this field is derived from the Period object in Accounting. |
| Financial Period Is Cash | Indicates the financial period is closed to the Cash General Ledger Account group. The data for this field is derived from the Period object in Accounting. |
| Financial Period Is Final Close | Indicates the financial period is closed to all general ledger accounts. The data for this field is derived from the Period object in Accounting. |
| Account Number | The number associated with the account object. |
| Collections On Hold Reason |
Indicates the reason why the account is on hold. The values are:
|
| Collections On Hold |
If selected, indicates that the account is placed on hold for collections. For more information, see the Account Fields in Accounting. |
| SIC Code | The standard industrial classification code (SIC) associated with the record. This is a unique code used to classify industry areas. |
| SIC Description | This field is related to the SIC Code, it provides a short description of the code. For example, "Computer Processing and Data Preparation and Processing Services" for SIC 7374. |