mmex_scheduled_create
Create a new scheduled transaction in Money Manager EX database. Set account, payee, type, amount, and repeat frequency to automate recurring entries.
Instructions
Create a new scheduled transaction in the MMEX database.
Args:
account_id: Account ID.
payee_id: Payee ID.
trans_code: Transaction type. Valid values: "Withdrawal", "Deposit", "Transfer".
amount: Amount as decimal string.
repeats: Repeat frequency (0=None, 1=Weekly, 2=Bi-Weekly, 3=Monthly, etc.).
to_account_id: Destination account ID (for transfers).
status: Transaction status. Valid values: "" (None), "Reconciled", "Void", "Follow up", "Duplicate".
transaction_number: Transaction number/reference.
notes: Notes.
category_id: Category ID.
trans_date: First transaction date (YYYY-MM-DD).
next_occurrence_date: Next occurrence date (YYYY-MM-DD).
num_occurrences: Number of occurrences (0=infinite).
to_trans_amount: Destination amount (for transfers).
db_path: Path to the .mmb database file. Optional if MMEX_DB_PATH env var is set.
db_key: Encryption key for SQLCipher databases. Optional if MMEX_DB_KEY env var is set.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| account_id | Yes | ||
| payee_id | Yes | ||
| trans_code | Yes | ||
| amount | Yes | ||
| repeats | Yes | ||
| to_account_id | No | ||
| status | No | ||
| transaction_number | No | ||
| notes | No | ||
| category_id | No | ||
| trans_date | No | ||
| next_occurrence_date | No | ||
| num_occurrences | No | ||
| to_trans_amount | No | ||
| db_path | No | ||
| db_key | No |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |