#select * from loan_account where account_id=3855404 desc loan_account
| Field | Type | Null | Key | Default | Extra |
| ACCOUNT_ID | int(11) | NO | PRI | 0 | (null) |
| BUSINESS_ACTIVITIES_ID | int(11) | YES | MUL | | (null) |
| COLLATERAL_TYPE_ID | int(11) | YES | MUL | | (null) |
| GRACE_PERIOD_TYPE_ID | smallint(6) | NO | MUL | 0 | (null) |
| GROUP_FLAG | smallint(6) | YES | (null) | | (null) |
| LOAN_AMOUNT | decimal(21,4) | YES | (null) | | (null) |
| LOAN_AMOUNT_CURRENCY_ID | smallint(6) | YES | MUL | | (null) |
| LOAN_BALANCE | decimal(21,4) | YES | (null) | | (null) |
| LOAN_BALANCE_CURRENCY_ID | smallint(6) | YES | MUL | | (null) |
| INTEREST_TYPE_ID | smallint(6) | YES | MUL | | (null) |
| INTEREST_RATE | text | YES | (null) | | (null) |
| FUND_ID | smallint(6) | YES | MUL | | (null) |
| MEETING_ID | int(11) | YES | MUL | | (null) |
| CURRENCY_ID | smallint(6) | YES | MUL | | (null) |
| NO_OF_INSTALLMENTS | smallint(6) | NO | (null) | 0 | (null) |
| DISBURSEMENT_DATE | date | YES | (null) | | (null) |
| collateral_note | varchar(500) | YES | (null) | | (null) |
| GRACE_PERIOD_DURATION | smallint(6) | YES | (null) | | (null) |
| INTEREST_AT_DISB | smallint(6) | YES | (null) | | (null) |
| GRACE_PERIOD_PENALTY | smallint(6) | YES | (null) | | (null) |
| PRD_OFFERING_ID | smallint(6) | YES | MUL | | (null) |
| t_collateral_note | varchar(255) | YES | (null) | | (null) |
| REDONE | smallint(6) | NO | (null) | | (null) |
| PARENT_ACCOUNT_ID | int(11) | YES | MUL | | (null) |
| MONTH_RANK | smallint(6) | YES | (null) | | (null) |
| MONTH_WEEK | smallint(6) | YES | (null) | | (null) |
| RECUR_MONTH | smallint(6) | YES | (null) | | (null) |