MAF CLOUD - NEW RELEASE + FIX UPDATES JUN 2023

kgi bond price format issue

bond price is very special in futures market.

for kgi CBOT/21, if the price is 112.2050, but after converting, it is 112.640625

Enhancement

-

https://mafint.atlassian.net/browse/MAF-3960

add Bal Qty in STOCK DETAILS table

1. this column will be empty in select API

2. add a new button to calculate bal qty

3. after click the button, BE return bal_qty based on each link_phy_trade_id

4. fill up the column in the table

API logic:

1. FE preload data to BE is all the link_phy_trade_ids

2. bal_qty = contract_stock_qty of phy_trade_id (=link_phy_trade_id) + sum all contract_stock_qty based on link_phy_trade_id

   1. BE only check 1 and 2 stock actions (stock in or stock out), the other types of stock action qty will be treated as 0 will apply for all stock type (stock in/out, relocate in/out and swap in/out)

   2. 1 is positive and 2 is negative of contract_stock_qty

Bal Qty will not be save, just click Calculate button will calculate all.

Enhancement

New Physical Trades

https://mafint.atlassian.net/browse/MAF-3935

add Bal Qty in STOCK DETAILS table

1. this column will be empty in select API

2. add a new button to calculate bal qty

3. after click the button, BE return bal_qty based on each link_phy_trade_id

4. fill up the column in the table

API logic:

1. FE preload data to BE is all the link_phy_trade_ids

2. bal_qty = contract_stock_qty of phy_trade_id (=link_phy_trade_id) + sum all contract_stock_qty based on link_phy_trade_id

   1. BE only check 1 and 2 stock actions (stock in or stock out), the other types of stock action qty will be treated as 0 will apply for all stock type (stock in/out, relocate in/out and swap in/out)

   2. 1 is positive and 2 is negative of contract_stock_qty

Bal Qty will not be save, just click Calculate button will calculate all.

Enhancement

New Physical Trades

https://mafint.atlassian.net/browse/MAF-3935

add Bal Qty in STOCK DETAILS table

1. this column will be empty in select API

2. add a new button to calculate bal qty

3. after click the button, BE return bal_qty based on each link_phy_trade_id

4. fill up the column in the table

API logic:

1. FE preload data to BE is all the link_phy_trade_ids

2. bal_qty = contract_stock_qty of phy_trade_id (=link_phy_trade_id) + sum all contract_stock_qty based on link_phy_trade_id

   1. BE only check 1 and 2 stock actions (stock in or stock out), the other types of stock action qty will be treated as 0 will apply for all stock type (stock in/out, relocate in/out and swap in/out)

   2. 1 is positive and 2 is negative of contract_stock_qty
      
      

Bal Qty will not be save, just click Calculate button will calculate all.

Enhancement

New Physical Trades

https://mafint.atlassian.net/browse/MAF-3935

1. 合同数量容易歧义，改成理论出入库数量；change contract qty column chinese name in stock mgmt

2. 数量改成实际出入库数量（理论出入库数量与实际出入库数量都优先带入合同未出入库数量，允许修改）change qty column chinese name in stock mgmt

3. in stock mgmt, add new row, once select contract no, both contract qty and qty columns should auto fill with unstock qty

4. both contract qty and qty columns allow edit

5. contract no drop down list in stock mgmt need to update accordingly

logic is if stock qty (contract qty in stock mgmt) is not input yet, stock qty = 0 so unstock qty in new phy = qty in new phy (contract qty in new phy)

stock in/out in stock mgmt and new phy trade table stock qty and unstock qty will be updated

unstock qty = contract actual qty/qty in new phy trade - stock qty in new phy trade [stock in/out contract qty in stock mgmt table]

No need real time update for unstock qty.

Enhancement

New Physical Trades

https://mafint.atlassian.net/browse/MAF-3953

add new key and column for paper trade

background: 

Hai Tian wanna do access control for paper trade.

1. their user will key view_group_id (maf_group_id) for each trade

2. in BE will hard code for Hai Tian company to select trade based on view_group_id (maf_group_id)

3. only for hai tian company at this moment.

Database is updated and pushed.

FE trade table

1. trade table

   1. key: view_group_id

   2. column: GROUP ID

   3. dropdown list: all the groups under user's company (value is maf_group_id, label is maf_group_name)

   4. validation: true

   5. editable

2. outside the table

   1. same as portfolio, user is able to select trades, and select GROUP to update all select trades GROUP ID

3. view, update and insert should work for GROUP ID

Enhancement

New Physical Trades

https://mafint.atlassian.net/browse/MAF-3955

only stock in can insert/edit link_phy_id in stock mgmt table

only stock in can insert/edit link_phy_id (link contract no column) in stock mgmt table

if stock action is empty, link_phy_id cannot be editable

does not apply for pair details table

->stock action is stock in, stock out, move in, move out, swap in and swap out with link contract no

only allow stock in has link contract no.

Enhancement

New Physical Trades

https://mafint.atlassian.net/browse/MAF-3957

created by and date in paper trade are invalid

Enhancement

New Physical Trades

https://mafint.atlassian.net/browse/MAF-3958

sale contract in link contract no should be negative

sale contract should be negative in link contract no in stock mgmt, i click on link contract number and all the sale contract shows positive qty but they should be negative

Enhancement

New Physical Trades

https://mafint.atlassian.net/browse/MAF-3959

filter away contract no if unstock qty is 0 in BOTH CONTRACT NO and LINK CONTRACT NO in stock mgmt (unstock qty 0 should not appear in contract no drop down list) same as ps ledger

Enhancement

New Physical Trades

https://mafint.atlassian.net/browse/MAF-3961

cannot use stock mgmt if choose later start date

Enhancement

New Physical Trades

https://mafint.atlassian.net/browse/MAF-3952

for both new apps Unpriced Contract Schedule and Purchase Sale Summary, when click on the open in new window button, will be empty

Enhancement

New Physical Trades

https://mafint.atlassian.net/browse/MAF-3954

demurrage cannot download attachment due to characters input by simplied chinese keyboard

Enhancement

New Physical Trades

https://mafint.atlassian.net/browse/MAF-3956

translate in new phy trade - physical and warrant

Enhancement

New Physical Trades

https://mafint.atlassian.net/browse/MAF-3951

采/销售量汇总

Users need to choose summary mode first: CONTRACT or STOCK 业务口径或者财务口径

Aggregate all contracts based on P/S DATE, PRODUCT, PURCHASE/SALE, TRADE MODE, and calculate the sum of QTY, AMT, AMT BEFORE TAX

columns:

P/S DATE 采/销日期：based on the time dimensions (note a) and summary mode (note b)

PRODUCT 品种

PURCHASE/SALE 采/销

TRADE MODE 交易模式

QTY 数量： based on summary mode (note b)

AMT 采/销成本： QTY * PRICE （priority：CONTRACT ACTUAL PRICE > PROVISIONAL PRICE)

AMT BEFORE TAX 采/销不含税成本： AMT/ （1+ CONTRACT TAX RATE）

note a:

Three time dimensions: daily, weekly, monthly

Daily：specific date

weekly: 某月第几周

monthly：几月

note b:

Two summary modes based on CONTRACT or STOCK

CONTRACT 业务口径：P/S DATE is based on trade date in new physical trade table, QTY is (priority: CONTRACT ACTUAL QTY > QTY in physical trade)

STOCK 财务口径：P/S DATE is based on stock date in stock management, QTY is stock_contract_qty

P/S DATE 采/销日期：based on the time dimensions (note a) and summary mode (note b)

PRODUCT 品种

PURCHASE/SALE 采/销

TRADE MODE 交易模式

QTY 数量： based on summary mode (note b)

AMT 采/销成本： QTY * PRICE （priority：CONTRACT ACTUAL PRICE > PROVISIONAL PRICE)

AMT BEFORE TAX 采/销不含税成本： AMT/ （1+ CONTRACT TAX RATE）

1. Date dimension handle by BE

2. group by PRODUCT 品种, PURCHASE/SALE 采/销, TRADE MODE 交易模式 handle by FE table

3. AMT 采/销成本： QTY * PRICE （priority：CONTRACT ACTUAL PRICE > PROVISIONAL PRICE)

   AMT BEFORE TAX 采/销不含税成本： AMT/ （1+ CONTRACT TAX RATE） → should be same as phy trade table formula.

make it more flexible, we put group keys in settings and let users to choose. the dropdown list could from BE dashboard meta data

PRODUCT 品种

PURCHASE/SALE 采/销

TRADE MODE 交易模式

Enhancement

New Physical Trades

https://mafint.atlassian.net/browse/MAF-3946