Allow input in Exchange rate for Offshore trade mode
Add New Trade Mode:
1、ENTREPOT 转口
2、OFFSHORE-CROSS CCY 离岸-跨币种
3、EFP 期转现
4、LONG ORDER 长单
5、Delete BASIS TRADE CHINA
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
Auto Update function should only update end date and not affect start date. This means that when Auto Update is ticked, End Date will auto reset to yesterday’s date, if unticked, End Date will remain as the user’s selected date; all without affecting the user’s selected Start Date
Physical Trade Status App Start Date and End Date should be the same in shared link and shared Group Dashboard