Financial tag rule reference

Fields supported for all journals

Field name	Microsoft Power Fx	Description	SQL field
Account	doc.Account.MainAccount doc.Account.<DimensionFields>	When the account type is set to Ledger, all the available dimension fields that are associated with the Account field are entered in the Account field.	Join to DimensionAttributeValueCombination to the correct selected field
Account type	doc.AccountType	This field refers to the account type value on the journal line.	LedgerJournalTrans.AccountType
Approved	doc.Approved	A true/false value that indicates whether the journal line was approved.	LedgerJournalTrans.Approved
Approved by	doc.ApprovedBy	The user who approved the journal.	LedgerJournalTrans.Approver
Bank	doc.Bank.Account doc.Bank.Name	The Bank account ID or Bank account name field. This field is available when the account type is set to Bank.	Join to: BankAccountTable.AccountID BankAccountTable.Name
Company	doc.Company	The Account company value that is set on the journal line.	LedgerJournalTrans.Company
Currency	doc.Currency.Code	The Currency value for the journal line.	LedgerJournalTrans.Currencycode
Customer	doc.Customer.Account doc.Customer.Group doc.Customer.GroupName doc.Customer.Name	The Customer account ID, Customer account name, Customer group id or Customer group name field. This field is available when the account type is set to Customer.	Joins to: CustTable.AccountNum CustTable.CustGroup CustGroup.Name DirPartyTable.Name
Document	doc.Document	The Document field from the Invoice tab of the journal line.	LedgerJournalTrans.DocumentNum
Financial dimensions	doc.Dimensions.<DimensionFields>	When the account type is set to anything except Ledger, all the available dimension fields that are associated with the Account field are entered in the Dimension field.	Join to DimensionAttributeValueCombination to the correct selected field
Fixed Asset	doc.FixedAsset.Account doc.FixedAsset.Group doc.FixedAsset.GroupName doc.FixedAsset.Name	The Fixed asset account ID, Fixed asset name, Fixed asset group id, or Fixed asset group name field. This field is available when the account type is set to Fixed asset.	Join to: AssetTable.AssetID AssetTable.AssetGroup AssetGroup.Name AssetTable.Name
Invoice	doc.Invoice	The Invoice field on the journal line.	LedgerJournalTrans.Invoice
Journal batch number	doc.JournalNum	The Journal batch number field for the set of journal lines. This field is available for the header, account, and offset account tags.	LedgerJournalTable.JournalNum (header) LedgerJournalTrans.JournalNum (account/offset account)
Journal description	doc.JournalDescription	The Journal line description field.	LedgerJournalTrans.Txt
Offset account	doc.OffsetDimensions.<DimensionFields>	When the offset account type is set to Ledger, all the available dimension fields that are associated with the Offset account field are entered in the Offset account field.	Join to DimensionAttributeValueCombination to the correct selected field
Payment reference	doc.PaymentReference	The Journal line payment reference field.	LedgerJournalTrans. PaymReference
Posting profile	doc.PostingProfile	The Journal line posting profile field.	LedgerJournalTrans. PostingProfile
Project	doc.Project.Account doc.Project.Group doc.Project.GroupName doc.Project.Name	The Project account ID, Project account name, Project group id, or Project group name field. This field is available when the account type is set to Project.	Join to: ProjTable.ProjID ProjTable.ProjGroupID ProjGroup.Name ProjTable.Name
Reason / Reason comment	doc.Reason doc.ReasonComment	The reason ID and reason comment values that are related to a journal line.	Join to: ReasonTableRef.Reason ReasonTableRef.ReasonComment
Vendor	doc.Vendor.Account doc.Vendor.Group doc.Vendor.GroupName doc.Vendor.Name	The Vendor account ID, Vendor account name, Vendor group id, or Vendor group name field. This field is available when the account type is set to Vendor.	Join to: VendTable.AccountNum VendTable.VendGroup VendGroup.Name DirPartyTable.Name
Voucher number	doc.Voucher	The Voucher field from the journal line.	LedgerJournalTrans.Voucher