Stores resulting worktags derived from evaluated account posting rules, linking financial transactions to specific business dimensions for precise reporting.

Table Specific Information

Select

The Workday provider requires filtering on AccountPostingRuleSet_Prompt and AccountPostingRuleType_Prompt in order to perform the query.

For example:

SELECT * FROM EvaluateAccountPostingRulesResultingWorktags WHERE AccountPostingRuleSet_Prompt = 'Account_Posting_Rule_Set_ID=ACCOUNT_POSTING_RULE_SET-1' AND AccountPostingRuleType_Prompt = 'Account_Posting_Rule_Type_ID=PAYROLL';

Workday Resource Information

Retrieves the ledger account and resulting worktags of an account posting rule with specified parameters.

Secured by: Set Up: Accounting Rules

Scope: Common Financial Management

Columns

Name	Type	Description
Id [KEY]	String	Unique identifier for the current instance of the account posting rule evaluation.
EvaluateAccountPostingRules_Id [KEY]	String	The Workday identifier (WID) that uniquely identifies the EvaluateAccountPostingRules process containing this instance.
Descriptor	String	A brief preview or summary of the current instance, often used for display purposes.
AccountPostingRuleSet_Prompt	String	This field is required. The WID or reference Id that identifies the specific account posting rule set being applied. The reference Id should be formatted as accountPostingRuleSet=sampleRefIdType=value, such as accountPostingRuleSet=Account_Posting_Rule_Set_ID=ACCOUNT_POSTING_RULE_SET-1.
AccountPostingRuleType_Prompt	String	This field is required. The WID or reference Id that specifies the type of account posting rule being applied. The reference Id should be formatted as accountPostingRuleType=sampleRefIdType=value, such as accountPostingRuleType=Account_Posting_Rule_Type_ID=CASH.
DimensionValue_Prompt	String	The WIDs or reference Ids that represent the dimension values used in the account posting rule condition. The reference Id should be formatted as dimensionValue=sampleRefIdType=value, such as dimensionValue=Fund_ID=F03.1.3.