1. New Physical Trade - Trades Table Hide some columns in Trades table by default Remove green highlights in table Allow input in Exchange rate for Offshore trade mode Add New Trade Mode: Add new columns CONTRACT AMT after CONTRACT ACTUAL PRICE Chinese: 合同金额 if ACTUAL PRICE FLAG = TRUE, CONTRACT AMT = CONTRACT ACTUAL QTY * CONTRACT ACTUAL PRICE If ACTUAL PRICE FLAG = FALSE, CONTRACT AMT = CONTRACT ACTUAL QTY * PROVISIONAL PRICE Add sum function
Settlement/Updated Settlement Table Fixed Pricing Ccy should be same in Settlement and Updated Settlement tabs If there is no Contract Actual Price, Estimated Price will be auto filled with Provisional Price. If there is Contract Actual Price, Estimated Price will be empty as per logic 1、PRICE BEFORE TAX after ESTED.PRICE Chinese: 不含税单价 PRICE BEFORE TAX = SETTLEMENT PRICE * (1- SETTLEMENT TAX RATE(%)) if no SETTLEMENT PRICE, PRICE BEFORE TAX = ESTED.PRICE * (1- SETTLEMENT TAX RATE(%)) 2、SETTLEMENT AMT after CUSTOM TAX AMOUNT Chinese: 结算金额 SETTLEMENT AMT = SETTLEMENT QTY* SETTLEMENT PRICE/ESTED.PRICE (Same logic as PRICE BEFORE TAX) 3、SETTLEMENT AMT BEFORE TAX after SETTLEMENT AMT Chinese: 不含税结算金额 SETTLEMENT AMT BEFORE TAX = SETTLEMENT AMT * (1- SETTLEMENT TAX RATE(%)) add sum function for 2 and 3 Add new columns TRADE MODE DEAL NO. UNIT DEAL CCY after CONTRACT NO. BM PRICING SETTLEMENT TAX RATE (% ) MTM PRICING after CONTRACT CCY all columns are in SETTLEMENT tab, they should not be editable in this tab.
Add all columns in Trades tab to Updated Settlement tab Add Sum function in updated settlement tab columns: SETTLEMENT AMT SETTLEMENT AMT BEFORE TAX
PS Ledger 1、For PS LEDGER tab, set PSL TYPE as PAYMENT default and can’t be modified. 2、Add upload csv file function, plz refer to the attached file. I have highlight all the required information DATE = 交易日期时间 COMPANY = 账户名称 COUNTERPARTY = 对方户名 LEDGER TYPE: if amount is on “借” column,LEDGER TYPE = RECEIVED; if amount is on “贷“ column,LEDGER TYPE = PAID AMOUNT = amount on ”借“ or ”贷“ column CCY = 币种
General Deals tab and Physical Pricing Setting tabs will be moved to New Physical Trade page Undo function - Will only undo copy & paste data, and will not work in add row/deleted data/bulk delete
| Enhancement | New Physical Trades | |