[jira] [Commented] (FINERACT-518) Share Transaction doesn't capture user ID
[ https://issues.apache.org/jira/browse/FINERACT-518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16728683#comment-16728683 ] Shruthi M R commented on FINERACT-518: --- [~santoshmath] as suggested by [~Ippez] can we close this issue and merge with https://issues.apache.org/jira/browse/FINERACT-440 .? > Share Transaction doesn't capture user ID > - > > Key: FINERACT-518 > URL: https://issues.apache.org/jira/browse/FINERACT-518 > Project: Apache Fineract > Issue Type: Improvement > 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)
[jira] [Commented] (FINERACT-518) Share Transaction doesn't capture user ID
[
https://issues.apache.org/jira/browse/FINERACT-518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)
[jira] [Commented] (FINERACT-518) Share Transaction doesn't capture user ID
[ https://issues.apache.org/jira/browse/FINERACT-518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16718923#comment-16718923 ] Shruthi M R commented on FINERACT-518: --- [~Ippez] are you saying you want created date and appuser id for share transaction? (similar to loan?). If not can you share the structure of the table you want? > 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)
[jira] [Commented] (FINERACT-518) Share Transaction doesn't capture user ID
[ https://issues.apache.org/jira/browse/FINERACT-518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16708494#comment-16708494 ] Ippez Roberts commented on FINERACT-518: [~santoshmath], Sure, this can be merged together with the above https://issues.apache.org/jira/browse/FINERACT-440 > 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: 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)
