From de7f5c381632c6bcec82be5b80c6f7e9d93e4e17 Mon Sep 17 00:00:00 2001 From: eileen Date: Wed, 6 Jan 2016 00:06:33 +1300 Subject: [PATCH] Backport metadata titles Change-Id: Id10f05c8f890ba35a9b2f225a57b6de65f26269b --- xml/schema/Financial/EntityFinancialTrxn.xml | 5 +++++ xml/schema/Financial/FinancialTrxn.xml | 14 +++++++++++++- 2 files changed, 18 insertions(+), 1 deletion(-) diff --git a/xml/schema/Financial/EntityFinancialTrxn.xml b/xml/schema/Financial/EntityFinancialTrxn.xml index d0ef7f6fd7..653fc792d5 100755 --- a/xml/schema/Financial/EntityFinancialTrxn.xml +++ b/xml/schema/Financial/EntityFinancialTrxn.xml @@ -7,6 +7,7 @@ 3.2 id + Entity Financial Transaction ID int unsigned true ID @@ -18,6 +19,7 @@ entity_table + Entity Table varchar 64 true @@ -27,6 +29,7 @@ entity_id + Entity ID int unsigned true 3.2 @@ -38,6 +41,7 @@ financial_trxn_id + Financial Transaction Id int unsigned 3.2 @@ -50,6 +54,7 @@ amount + Amount decimal true true diff --git a/xml/schema/Financial/FinancialTrxn.xml b/xml/schema/Financial/FinancialTrxn.xml index 8aee581831..968961fe8d 100755 --- a/xml/schema/Financial/FinancialTrxn.xml +++ b/xml/schema/Financial/FinancialTrxn.xml @@ -8,6 +8,7 @@ true id + Financial Transaction ID int unsigned true 1.3 @@ -47,6 +48,7 @@ from_financial_account_id int unsigned + Financial Transaction From Account FK to financial_account table. 4.3 @@ -66,6 +68,7 @@ to_financial_account_id + Financial Transaction To Account int unsigned FK to financial_financial_account table. 4.3 @@ -86,6 +89,7 @@ trxn_date + Financial Transaction Date datetime NULL date transaction occurred @@ -93,6 +97,7 @@ trxn_type + Financial Transaction Type enum Debit,Credit true @@ -101,6 +106,7 @@ total_amount + Financial Total Amount decimal true amount of transaction @@ -108,18 +114,21 @@ fee_amount + Financial Fee Amount decimal actual processor fee if known - may be 0. 1.3 net_amount + Financial Net Amount decimal actual funds transfer amount. total less fees. if processor does not report actual fee during transaction, this is set to total_amount. 1.3 currency + Financial Currency varchar 3 NULL @@ -149,6 +158,7 @@ trxn_id + Transaction ID varchar 255 user-specified unique processor transaction id, bank id + trans id,... depending on payment_method @@ -156,6 +166,7 @@ trxn_result_code + Transaction result Code varchar 255 processor result code @@ -173,6 +184,7 @@ payment_processor_id + Payment Processor int unsigned Payment Processor for this financial transaction 4.3 @@ -187,7 +199,7 @@ payment_instrument_id financial_trxn_payment_instrument_id - Payment Instrument + Payment Method int unsigned FK to payment_instrument option group values -- 2.25.1