Skip to main content

Solutions

Law firms

Tax, audit & accounting firms

Corporations

Governments

Products

Legal

Trade & supply

Tax, audit & accounting

Corporate tax

Risk & fraud

Books

Recommended products

Questions? We are here to help.
Contact us

Purchase

Buy solutions

Buy books

Contact sales

Questions? We are here to help.

Resources

Insights

Events

Product training

Product communities

Developers

Data fields

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.
ONESOURCE Tax Provision - 6 column fields
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
Standard Trial Balance fields
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.

This article applies to:

  • Product: ONESOURCE General Ledger Manager