[
https://issues.apache.org/jira/browse/FINERACT-518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16720155#comment-16720155
]
Ippez Roberts commented on FINERACT-518:
----------------------------------------
[~Shruthi M R], in my view, besides the parameters already in
m_share_account_transactions table, these columns are necessary to include for
report generation purposes and also to be used in audit trail
Please include the following in the m_share_account_transactions table to make
it complete as in m_savings_account_transaction in this Jira Ticket
_{color:#59afe1}ALTER TABLE m_share_account_transactions{color}_
_{color:#59afe1}ADD COLUMN `office_id` BIGINT(20) NOT NULL,{color}_
_{color:#59afe1}ADD COLUMN `payment_detail_id` BIGINT(20) NULL DEFAULT
NULL,{color}_
_{color:#59afe1}ADD COLUMN `is_reversed` TINYINT(1) NOT NULL,{color}_
_{color:#59afe1}ADD COLUMN `balance_end_date_derived` DATE NULL DEFAULT
NULL,{color}_
_{color:#59afe1}ADD COLUMN `balance_number_of_days_derived` INT(11) NULL
DEFAULT NULL,{color}_
_{color:#59afe1}ADD COLUMN `running_balance_derived` DECIMAL(19,6) NULL
DEFAULT NULL,{color}_
_{color:#59afe1}ADD COLUMN `cumulative_balance_derived` DECIMAL(19,6) NULL
DEFAULT NULL,{color}_
_{color:#59afe1}ADD COLUMN `created_date` DATETIME NOT NULL,{color}_
_{color:#59afe1}ADD COLUMN `appuser_id` BIGINT(20) NULL DEFAULT NULL,{color}_
_{color:#59afe1}ADD COLUMN `is_manual` TINYINT(1) NULL DEFAULT '0'{color}_
> Share Transaction doesn't capture user ID
> -----------------------------------------
>
> Key: FINERACT-518
> URL: https://issues.apache.org/jira/browse/FINERACT-518
> Project: Apache Fineract
> Issue Type: Bug
> Components: Shares
> Reporter: Ippez Roberts
> Assignee: Markus Geiss
> Priority: Critical
> Labels: Volunteer, gci, gsoc, p1
> Fix For: 1.3.0
>
>
> In m_share_account_transactions table there is no column for appuser_id for
> capturing the user id of whose so ever has done a transaction, be it Share
> purchase, Share Redeem hence auditing share transactions is hard
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
