Wiki

Clone wiki

Moneydance-2019 / Extensions / Report Writer Fields

Home>Extensions>Report Writer>Report Writer Fields

Field Description
Accounts Some fields are particular to the type of Account,
Account ID The internal id of the account
Account Name The Short Name of the account
Account Number The account number from the bank/lender
Account Type The type of account can be BANK,ASSET,LOAN,CREDIT CARD,INVESTMENT or LIABILITY
Annual Fee The annual fee for Credit Card accounts
APR Percent The initial APR for Credit Card accounts or the APR for a Loan account
Bank Routing/Sort Code Bank routing/sort code
Broker Phone Num Broker Phone Num
Calculate or Specify Payment TRUE if a calculate payment, FALSE if specific payment
Card Expire Month The expiry month of a Credit Card account
Card Expire Year The expiry year of a Credit Card account
Card Long Number The long card number on a Credit Card account
Category for Interest The name of the Category to be used for Interest on an account
Cleared Balance The total of all transactions with a status of CLEARED
Comments The comments entered on the account screen
Confirmed Balance The total all transactions with a status of RECONCILING
Credit Limit The credit limit of a Credit Card account
Currency ID The standard 3 character ID of the currency record for the account
Currency Name The name of the currency of the account
Current Balance The total of all transactions
Date APR changes Date of APR change on a Credit Card account
Default Category The full name of the default category
Escrow Account Name The name of the Account to be used for Escrow payments
Escrow Payment Amt The amount of any Escrow on a Loan account
Initial Balance The balance of the account when it was opened
Initial Debt The initial debt on a Loan account
Inactive True if the account is marked as inactive
Loan Points The declared Loan Points on a Loan Account
Long Account Name The long name of the account showing parent accounts
Lots Based True if a security Sells are allocated in lots. False means average cost.
Name of Bank Name of holding organisation
Name of Broker Name of Broker
New APR Percent The permanent APR for a Credit Card account
Payment Expiry Date Date of the end of a Loan
Payment Plan The payment plan on a Loan account,can be FIXED, CLEARED_BALANCE, CURRENT_BALANCE, PERCENTAGE_OF_CLEARED_BALANCE or PERCENTAGE_OF_CURRENT_BALANCE
Payments Per Year The number of payments in a year on a Loan account
Percent Payment The percentage when Payment Plan is a PERCENTAGE
Principal Amount The total amount of a Loan
Security Sub Type The sub type of Security on investment accounts
Security Type The type of Security on investment accounts
Specific Payment The amount of the specific payment on a Loan account when the payment type is Fixed
Start Date The account start date
Total Num Payments The total number of payments to be made on a Loan account
Addresses
Field Description
ID The ID of the address
Name The Name from the Address screen
Street The Address from the Address screen
Phone The Phone from the Address screen
Email The Email from the Address screen
UID The internal id of the Address record
Budgets
Field Description
Budget Name The name of the Budget
Budget Period The period of the Budget, it can be MIXED, WEEK, BIWEEK, MONTH or YEAR
Is New Style TRUE if the Budget Period is not MIXED
Budget ID The internal ID of the Budget record
Budget Items
Field Description
Budget Name The name of the Budget
Budget Item ID The internal ID of this Budget Item record
Amount The amount of this budget item
Currency ID The standard 3 character id of the Currency of this Budget Item
Currency Name The name of the Currency of this Budget Item
Account Name The Name of the Account for this Budget Item
Is Income TRUE if this Budget Item is an income amount
Interval Type The interval type for this Budget Item. It can be one of: Annually,Bi-Monthly,
Weekly,Daily,Monthly,No Repeat,Once Annually,Once Bi-Monthly,Once Bi-Weekly,
Once Monthly,Once Semi-Annually,Once Semi-Monthly,Once Tri-Monthly,Once Tri-Weekly,
Once Weekly,Semi-Annually,Semi-Monthly,Tri-Monthly,Tri-Weekly,Weekly
Interval Start Date The start of the Budget Item period
Interval End Date The end of the Budget Item period
Categories
Field Description
Category ID The internal id of this Category record
Category Name The name of this Category
Category Type The type of this Category, it can be EXPENSE or INCOME
Currency ID The standard 3 character id of the Currency of this Category
Currency Name The name of the Currency of this Category
Long Name The full name of the Category including parent categories
Tax Related TRUE if the category has Sales Tax
Currencies
Field Description
Currency Name The name of this Currency
Prefix The prefix string for the Currency
Suffix The suffix string for the Currency
Decimal Places The number of decimal places to show for this Currency
Currency Rates
Field Description
Currency ID The standard 3 character id of the Currency
Currency Name The name of this Currency
Prefix The prefix string for the Currency
Suffix The suffix string for the Currency
Date The date of the rate
Daily High The daily high from the snap shot record
Daily Low The daily low from the snap shot record
Rate The actual rate
Daily Volume The daily low from the snap shot record
Reminders
Field Description
Auto Commit Days The number of days after which a Transaction Reminder will automatically commit
Description The description of this Reminder
Initial Date The first date for this Reminder
Last Date The last date for this Reminder
Memo The Memo field from the Reminder screen
Reminder Type The type of Remainder, it can be one of TRANSACTION or NOTE
Repeat Daily The number of days the reminder will reoccur if the period is daily
Repeat Monthly The day of the month the reminder will reoccur if the period is monthly
Repeat Weekly The day of the week the remainder will reoccur if the period is weekly
Repeat Yearly TRUE if the Reminder repeats annually
Repeat Monthly Mod The 'Repeat On' field from the Reminder screen when the period is Monthly. It can be one of:
Every, Every Other, Every Third, Every Forth,Every Sixth
Repeat Weekly Mod The 'Repeat On' field from the Reminder screen when the period is Weekly. It can be one of:
Every, Every First, Every Second, Every Third, Every Forth,Every Fifth, Every Last
Loan Reminder TRUE if the Reminder is for a Loan
ID The internal id of the Reminder record
Securities
Field Description
Security Id The ID field from the Security screen
Security Name The name of this Security
Ticker The exchange ticker of this Security
Prefix The prefix string for the Security
Suffix The suffix string for the Security
Decimal Places The number of decimal places to show for this Security
Security Prices
Field Description
Security ID The Id from the Security screen
Ticker The ticker from the Security screen
Security Name The name of this Security
Currency The currency of the price
Currency ID The Id of the currency of the price
Prefix The prefix string for the Security
Suffix The suffix string for the Security
Date The date of the price
Daily High The daily high from the snap shot record
Daily Low The daily low from the snap shot record
Rate The actual price
Daily Volume The daily low from the snap shot record
Transactions
Field Description
Transaction Type The type of the transaction, can be P for parent or S for split
ParentTxnID The internal ID of the parent transaction. If the transaction is of type P it will be the same as the ID field
Txn ID The internal ID of the transaction
Account Name The name of the Account this transaction belongs to
Check Number The cheque number field if entered
Date Entered The date the transaction was entered into the system
Date Posted Online If the transaction has been downloaded the date it was posted
Description The description from the transaction register"
Status The status of the transaction, it can be one of UNRECONCILED, RECONCILING or CLEARED
Tax Date The Accounting Date from the transaction register
Parent Value The value of the parent transaction if this is a split
Split Value The value of this transaction
Transfer Type Will be xfrtp_bank
Tags The Tags from the transaction separated by a space
Memo The Memo field from the Transaction register
Category The name of the category from the Transaction register
Transfer Account If the transaction is a transfer to another account this field is the name of that account
Has Attachment True if the transaction has 1 or more attachments
Investment Transactions
Field Description
Transaction Type The type of the transaction, can be P for parent or S for split
ParentTxnID The internal ID of the parent transaction. If the transaction is of type P it will be the same as the ID field
Txn ID The internal ID of the transaction
Account Name The name of the Account this transaction belongs to
Check Number The cheque number field if entered
Date Entered The date the transaction was entered into the system
Date Posted Online If the transaction has been downloaded the date it was posted
Description The description from the transaction register"
Status The status of the transaction, it can be one of UNRECONCILED, RECONCILING or CLEARED
Tax Date The Accounting Date from the transaction register
Parent Value The value of the parent transaction if this is a split
Split Value The value of this transaction
Fee The amount of the Fee from the transaction register
Price The Stock Price from the transaction register
Transfer Type Will be one of xfrtp_bank, xfrtp_shortcover,xfrtp_buysellxfr, xfrtp_dividend, xfrtp_dividendxfr or xfrtp_miscincexp
Tags The Tags from the transaction separated by a space
Memo The Memo field from the Transaction register
Category The name of the category from the Transaction register
Fee Account The name of the Account for the fee if specified
Split Type The type of split if the transaction is a split, it can one of fee, sec, xfr,exp or inc
Transfer Account If the transaction is a transfer to another account this field is the name of that account
Security The name of the security from the transaction register
Number Shares The number of shares from the transaction register
Has Attachment True if the transaction has 1 or more attachments
Lots
Field Description
Parent Txn ID Internal ID of the Sell transaction
Account Name The name of the investment account for this transaction
Security Name The name of the security for this transaction
Txn Type The type of the main transaction
Shares The number of shares on the main transaction (if more than one allocation, this is blank on all except first allocation)
Price The price the shares were traded at. (if more than one allocation, this is blank on all except first allocation)
Lot Txn Type The type of transaction that is being allocated
Lot Date The date of the transaction that is being allocated
Lot Price The price the shares being allocated were traded at
Lot Shares The number of shares on the original transaction
Lot Shares Allocated The number of shares allocated in this allocation

Please refer to the following pages for more information about Report Writer:

Updated