Excel Add-In for Sage Intacct

Build 25.0.9434

TransactionRuleDetail

Lists the specific configurations tied to a transaction rule, including account overrides, filters, and range limitations.

Columns

Name Type ReadOnly Description
Recordno [KEY] String False

Unique identifier for the transaction rule detail record.

Rulekey Int64 False

The identifier for the associated transaction rule.

Rulename String False

The name of the transaction rule.

Seqno Int64 False

The sequence number for the transaction rule detail.

Description String False

A description of the transaction rule detail.

Action String False

The action associated with the transaction rule detail.

Itemglgroupkey Int64 False

The general ledger group key associated with the item.

Itemglgroupname String False

The general ledger group name associated with the item.

Post Boolean False

Indicates whether the transaction rule detail should be posted.

Subtotalrange String False

The subtotal range associated with the transaction rule detail.

Source String False

The source of the transaction rule detail.

Rate Double False

The rate associated with the transaction rule detail.

Ratenote String False

Notes related to the rate of the transaction rule detail.

Dbglacctkey Int64 False

The debit general ledger account key for the transaction rule detail.

Dbglacctno String False

The debit general ledger account number for the transaction rule detail.

Dblockey Int64 False

The debit location key for the transaction rule detail.

Dblocid String False

The debit location ID for the transaction rule detail.

Dblocname String False

The debit location name for the transaction rule detail.

Dbdeptkey Int64 False

The debit department key for the transaction rule detail.

Dbdeptid String False

The debit department ID for the transaction rule detail.

Dbdeptname String False

The debit department name for the transaction rule detail.

Dbclasskey Int64 False

The debit class key for the transaction rule detail.

Dbclassid String False

The debit class ID for the transaction rule detail.

Dbclassname String False

The debit class name for the transaction rule detail.

Dbprojectkey Int64 False

The debit project key for the transaction rule detail.

Dbprojectid String False

The debit project ID for the transaction rule detail.

Dbprojectname String False

The debit project name for the transaction rule detail.

Crglacctkey Int64 False

The credit general ledger account key for the transaction rule detail.

Crglacctno String False

The credit general ledger account number for the transaction rule detail.

Crlockey Int64 False

The credit location key for the transaction rule detail.

Crlocid String False

The credit location ID for the transaction rule detail.

Crlocname String False

The credit location name for the transaction rule detail.

Crdeptkey Int64 False

The credit department key for the transaction rule detail.

Crdeptid String False

The credit department ID for the transaction rule detail.

Crdeptname String False

The credit department name for the transaction rule detail.

Crclasskey Int64 False

The credit class key for the transaction rule detail.

Crclassid String False

The credit class ID for the transaction rule detail.

Crclassname String False

The credit class name for the transaction rule detail.

Crprojectkey Int64 False

The credit project key for the transaction rule detail.

Crprojectid String False

The credit project ID for the transaction rule detail.

Crprojectname String False

The credit project name for the transaction rule detail.

Whencreated Datetime False

The date and time when the transaction rule detail was created.

Whenmodified Datetime False

The date and time when the transaction rule detail was last modified.

Createdby Int64 False

The identifier of the user who created the transaction rule detail.

Modifiedby Int64 False

The identifier of the user who last modified the transaction rule detail.

Record_url String False

The URL for accessing the transaction rule detail record.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434