...
i. Please click on Trade, followed by New Physical Trade from the navigation sidebar on the left to enter the physical trade page,
...
ii. Please click on + New Trade and a new row will be added for you to input your data. Please refer to the definitions below for more information.
...
Trade ID：Input is not required, once you save your trade data, the Trade ID will be generated automatically
...
Trade Date*：Trade date of the contract
...
Product*：Product name, for example Corn
...
The From Date is 1 week before today's date and To Date is today’s date by default. Please feel free to change the dates accordingly. The dates will remain according to your settings until you log out.
To delete the trades, tick the checkbox of the row and click on Delete Row at the top right corner of the page.
To reset the filter, click on the Reset Filter button or right-click in the table and click on Reset Filter.
...
ii. Please click on + New Trade and a new row will be added for you to input your data. Please refer to the definitions below for more information.
Trade ID：Input is not required, once you save your trade data, the Trade ID will be generated automatically
Trade Date*：Trade date of the contract
Product*：Product name, for example Corn
Specification：Product specification, you may fill in for your reference if necessary, eg Product is Rubber and specification is XX1
Entity of Contract*：Name of your company (can be input in Settings>Company>Company Profile page)
Counterparty*：Counterparty name
Contract No.：Every purchase and sale contract should have its own contract number
Main Contract No.: Main contract number of individual contract number, you may input as necessary
Purchase/Sale*：Purchase/Buy or Sale/Sell
Match No.: Assign the same match number to the corresponding purchase and sale contracts for your reference
Contract Delivery Date: Contract delivery date
Trader：Name of trader
Trade Mode *：
Offshore refers to offshore contracts - Cannot input for Tax Rate, Exchange Rate and Custom Tax Rate
Domestic China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate
Delivery China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate
Import/Export refers to import/export contracts - Can input Tax Rate, Exchange Rate (If Deal Currency and Product Currency are different) and Custom Tax Rate
Basis Trade China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate
...
Qty*：Contract quantity
Actual Qty: Actual quantity transacted
Unit*：Unit of contract/product eg metric ton
Contract Pricing Date: Contract pricing date
Margin (%) : Collateral value % deposited with the counterparty
Provisional Price: Temporary price, will be used to calculate P/L if Estimated Price or Actual Price is not available yet. The system will follow this order of priority to calculate P/L if the price is available: Actual Price > Estimated Price > Provisional Price
Actual Price: Actual price transacted, will be used as priority to calculate P/L
Pricing Date：Pricing Date
Execution Status: Status of contract eg settled, pending . The system will follow this order of priority to calculate P/L if the price is available: Actual Price > Estimated Price > Provisional Price
Pricing Date：Pricing Date
Execution Status: Status of contract eg settled, pending etc
Stock Date: The latest stock in/stock out date recorded in Stock Management Function
WH Name & Status: Name of warehouse and Stock Type recorded in Stock Management Function will be automatically reflected here
Stock Qty: Stock In/Out quantity that has been recorded in Stock Management Function
Unstock Qty: Stock In/Out quantity that has not been recorded in Stock Management Function, Un-stocked Quantity = Quantity - Stock Quantity
PSL Amt: PS Ledger amount with PSL Type: Payment recorded in PS Ledger will be automatically reflected here
PSL Date: PS Ledger date with PSL Type: Payment recorded in PS Ledger will be automatically reflected here
Bal Amount: Balance Amount = Trade value - PS Ledger Amount will be automatically reflected here
Inv Qty: Invoice quantity with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here
Inv Amt: Invoice amount with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here
Un Inv Qty: Un-Invoiced Quantity = Quantity - Invoice Quantity will be automatically reflected here
Un Inv Amt: Un-Invoiced Amount = Trade Value - Invoice Amount will be automatically reflected here
Remarks：Remarks
...
All the basic trades data input in Step a (Trades tab) above will be reflected automatically in the table. Please fill in the settlement data
The From Date is 1 week before today's date and To Date is today’s date by default. Please feel free to change the dates accordingly. The dates will remain according to your settings until you log out.
To reset the filter, click on the Reset Filter button or right-click in the table and click on Reset Filter.
...
Please fill in the settlement data as necessary, only fields in red are compulsory to be filled.
...
Contract Qty*：Contract quantity
Unit*：Unit of contract/product eg metric ton
Deal Ccy: Deal currency
Title Transfer Date: Title transfer date , cannot be earlier than physical trade date will be auto filled according to the Trade Date of the trade if AUTO TTD is auto ticked (by default). You may untick AUTO TTD and fill in the title transfer date as necessary. It cannot be earlier than physical trade date and cannot be after today's date
BM Pricing: Benchmark Pricing - Benchmark PRICING CODE of your product which has been pre-set in the physical pricing setting tab. The pricing index code selected will be used to benchmark the pricing of your trade. Please note that to set the pricing for each trade, you can only choose either benchmark pricing or fixed price. Fixed price will be empty if you select benchmark pricing. Tax rate for benchmark pricing has already been pre-set in physical pricing setting tab.
Premium: Premium of your benchmark pricing index
Fixed Price: Fixed price of trade. Please note that to set the pricing for each trade, you can only choose either benchmark pricing or fixed price. Benchmark pricing will be empty if you select fixed pricing.
Fixed Pricing CCY: Currency for fixed price trade.
Tax Rate (%): Tax rate for fixed price trade. Tax rate for benchmark pricing has already been pre-set in physical pricing setting tab so this field cannot be used if benchmark pricing has been used instead of fixed pricing. If you select OFFSHORE, TAX RATE field cannot be filled which means that TAX RATE will be applicable for other trade modes other than This will only be applicable if your trade mode is not OFFSHORE
MTM Pricing: MTM PRICING CODE of your product which has been pre-set in the physical pricing setting tab. The pricing index code selected will be used to benchmark the MTM of your trade. Tax rate for MTM pricing has already been pre-set in physical pricing setting tab. You do not need to select this if your deal number is an existing deal number with its own MTM pricing.
Actual Qty: Actual quantity of trade
Estd Price:
Actual Price:
Exchange Rate
Exchange Conversion Date
Custom Tax Amount
old bulk insert and update do not support exchange rate date.
only new settlement insert and update do.
only trade with trade mode == import/export is allowed to have ex rate date.
Once done, please tick the checkbox of the trades you want to save and click on Save Changes to save your data. If you do not tick the checkbox of the rows before clicking Save Changes, no data will be saved.
c. Update Pricing Data in New Physical Trade (Settlement Tab)
...
to select this if your deal number is an existing deal number with its own MTM pricing
Actual Qty: Actual quantity of trade
Estd Price: Estimated price of trade, will be used to calculate P/L if Actual Price is not available yet. The system will follow this order of priority to calculate P/L if the price is available: Actual Price > Estimated Price > Provisional Price
Actual Price: Actual price transacted, will be used as priority to calculate P/L. The system will follow this order of priority to calculate P/L if the price is available: Actual Price > Estimated Price > Provisional Price
Exchange Rate: Exchange rate used for the trade. This will only be applicable if your trade mode is IMPORT/EXPORT
Exchange Conversion Date: Date of exchange rate conversion. This is only supported in New Physical Trade page and not Old Physical Trade page. This will only be applicable if your trade mode is IMPORT/EXPORT
Custom Tax Amount: Custom tax amount applicable for the trade. This will only be applicable if your trade mode is IMPORT/EXPORT
Once done, please tick the checkbox of the trades you want to save and click on Save Changes to save your data. If you do not tick the checkbox of the rows before clicking Save Changes, no data will be saved.
All saved data will be transferred to the Updated Settlement table, please refer to Step c.
...
c. Update Pricing Data in New Physical Trade (Updated Settlement Tab)
If this step is not required yet, please proceed to the next step and return to complete this step when necessary.
All the settlement data updated and saved in Step b (Settlement tab) above will be reflected automatically in the table.
The From Date is 1 week before today's date and To Date is today’s date by default. Please feel free to change the dates accordingly. The dates will remain according to your settings until you log out.
To reset the filter, click on the Reset Filter button or right-click in the table and click on Reset Filter.
...
Please fill in the settlement data as necessary, only fields in red are compulsory to be filled.
Trade ID：Input is not required, once you save your trade data, the Trade ID will be generated automatically
Execution ID: Input is not required, Execution ID is generated automatically
Contract No.：Every purchase and sale contract should have its own contract number
Pricing Mode: Indicate as WMA, FLOAT or SPOT according to the BM Pricing set up in Step b above. If Fixed Price is used instead, it will indicate as FIX.
Quantity*：Contract quantity
Trader：Name of trader
Cat: Category of product
Title Transfer Date: Title transfer date, cannot be earlier than physical trade date and cannot be after today's date
Actual Qty: Actual quantity of trade
Estd Price: Estimated price of trade, will be used to calculate P/L if Actual Price is not available yet. The system will follow this order of priority to calculate P/L if the price is available: Actual Price > Estimated Price > Provisional Price
Actual Price: Actual price transacted, will be used as priority to calculate P/L. The system will follow this order of priority to calculate P/L if the price is available: Actual Price > Estimated Price > Provisional Price
Premium: Premium of your benchmark pricing index (WMA, FLOAT or SPOT only). This will not be applicable for pricing mode (FIX)
Exchange Rate: Exchange rate used for the trade. This will only be applicable if your trade mode is IMPORT/EXPORT
Exchange Conversion Date: Date of exchange rate conversion. This is only supported in New Physical Trade page and not Old Physical Trade page. This will only be applicable if your trade mode is IMPORT/EXPORT
Custom Tax Amount: Custom tax amount applicable for the trade. This will only be applicable if your trade mode is IMPORT/EXPORT
Once done, please click on Save Changes to save your data.
...
d. Input Stock/Inventory Data in Stock Management
...