Data fields
Data Fields define the structure and specifications for data used in the General Ledger Manager application, including field types, requirements, and validation rules.
Explore data fields
Data Fields power the General Ledger Manager application. They define how the system uses data and provide the information needed for accurate processing.
Use a single Data Field to create 1 or more Processing Instructions. These instructions set the criteria for generating Trial Balances and keep reporting consistent.
Data Fields also build Master Trial Balances. 1 field can trigger several Processing Instructions and produce multiple Master Trial Balances. This structure ensures efficiency and consistency in financial data management.
Pre-created, read-only data fields
The application includes 2 pre-created, read-only Data Fields:
Tax Provision – 6 Column
and Standard Trial Balance
. Users can't add or modify these fields.The following table lists the specific fields within these Data Fields, including each field’s type and whether it's required or optional.
Field Name | Is Required | Type | Classification |
|---|---|---|---|
Unit Code | No | Text | ONESOURCE Entity Code |
Div-1 | No | Text | NA |
Div-2 | No | Text | NA |
Ledger/Account Code | Yes | Text | ONESOURCE Account Code |
Beginning Balance | No | Currency | Beginning Balance |
Ending Balance | Yes | Currency | Ending Balance |
Financial/Hierarchy Code | Yes | Text | ONESOURCE Financial/Hierarchy Code |
Field Name | Is Required | Type | Classification |
|---|---|---|---|
Account Number | Yes | Text | ONESOURCE Account Code |
Entity Number | Yes | Text | ONESOURCE Entity Code |
Ending Balance | Yes | Currency | Ending Balance |
Beginning Balance | No | Currency | Beginning Balance |
Financial/Hierarchy Code | No | Text | ONESOURCE Financial/Hierarchy Code |
Classification column and data validation
Connect user input with administrative records
The Classification column links user-entered data to records in the Administration module under Accounts and Entities. This link makes sure imported or entered information matches the system's set up.
Enforce data integrity
The
Unit Code
field is classified as an ONESOURCE Entity Code. The Unit Code
in a customer file is valid only when the same value exists under Entities in Administration.A similar rule applies to the
Ledger Account Code
. The entered value needs to match an entry under Accounts in Administration. These validations ensure that only authorized codes are used, maintaining consistency and reliability in financial data.