Skip to main content

logoCorrectSize.png

Adaptive Insights LLC.

Transaction Field Types

Describes transaction field types you can use when creating a transaction field definition in the transaction builder, including required fields, data fields, and dimension fields.

Required fields must be present in the definition and cannot be deleted. These required fields must always be defined and they must be populated. 

Field Categories Description

Level Field 

Required.

Represents the organizational level to which the transaction or line item belongs. Transactions cannot be associated with linked levels.​​​​

Account Field

Required.

Represents the account to which the transaction or the line item belongs. The list of valid accounts with which a transaction line item can be associated are General Ledger, Custom, and Assumption accounts that hold Actuals data in Adaptive Insights.

Transactions cannot be associated with cube or modeled accounts.  In Sales Planning, you can create number fields named for the cube sheet account codes you want a transaction to associate with. See Managing Transaction Tables for Sales Planning for more details.

Transaction Type Field

Required.

A text selector that allows you to specify the type of the transaction such as Bill, Invoice, Journal Entry, etc. This list comes pre-populated with a common list of transaction type values, however you can add, change, and remove entries as needed.

Posting Date

Required.

Represents the date on which the transaction is posted to the GL. This is a date field used to identify the month and year to which the transaction belongs.

Transaction Amount

Required.

Represents the amount for a line item in a transaction. This is a number field.

Text 

Contains any characters and limited to 1000 characters per field, in each transaction line. If you attempt to import more than the allowed 1000 characters into a field, the field will be truncated and you will get a warning message informing you of this

Number  Contains only numeric data. You can specify the display format (Number, Currency, or Percent) and the decimal precision.
Date  Contains only date data.
Text Selector Contains a predefined set of values as a drop-down list. Administrators can specify the set of values present in the Text Selector list.

Dimension 

Any of the custom dimensions present in your model can be used as a field for a transaction. These custom dimensions get listed on the field panel. Each dimension can appear only once in the transaction definition.

  • Was this article helpful?