-
Notifications
You must be signed in to change notification settings - Fork 0
Report Writer Fields
Mike B edited this page Mar 24, 2024
·
1 revision
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 |
| 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: