...
Trade Execution ID：Input is not required, once you save your trade execution data, the Trade Execution ID will be generated automatically
Trade Execution No. *：Under each contract, there may be multiple trade executions due to different pricing methods and different transportation logistics. The trade execution number is used to distinguish each trade’s execution details. If there is only one trade execution, the trade execution number can be the contract number, this field can be input/edited directly in the table
DEAL QTY DSP: Refers to Quantity Discrepancy, there are times when the actual quantity of the purchase and sale contract cannot be matched 100%. For example, you purchase 1001 MT of goods and sold 1001.2 MT of the same goods. But the system is unable to determine if the difference in quantity is correct or due to an input error, so the DEAL QTY DSP will be highlighted in red to remind you to check for discrepancy. Please note that if the trade does not have Actual Quantity, the system will not check so it will not be highlighted in red.
Cases of DEAL QTY DSP in red:
The actual quantity for both purchase and sales contracts are not the same, or
Only the actual quantity for purchase contract is input, but not for the sale contract, and vice versa
Status：Trade status, defined by you
Trade ID：Input is not required, once you save your trade data, the Trade ID will be generated automatically
Trade Date：Date*：The trade date of the contract will be automatically displayed in this table for easy reference.
Deal No.* ：The deal number of the contract will be automatically displayed in this table for easy reference. A dealincludes one or more purchase and sale contracts. All purchase and sale contracts allocated to the same deal number will be matched with each other to calculate the net positions and P/L. Deal number is also considered a portfolio/trading book, and can be found in the Portfolio page.
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
Trader：Name of trader, can be input/edited directly in the table
Category：Category is used to group various contracts. For example, in the spot copper contract, the varieties (category) may include standard copper and non-standard copper. By categorising them separately, you will be able to determine the positions and P/L of each category - standard copper and non-standard copper, can be input/edited directly in the table
Contract No.：Every purchase and sale contract will have their own contract number, can be input/edited directly in the table
Pricing Date：Pricing date, can be input/edited directly in the table
Pricing Contract ：Pricing contract, can be input/edited directly in the table
Purchase/Sale：Sale*：Purchase/Buy or Sale/Sell
Counterparty Reference No.：Counterparty reference number，can be input/edited directly in the table
Counterparty：Counterparty*：Name of counterparty
Product：Product*：Product name, for example Corn, can be input/edited directly in the table
Specification：Product specification, you may fill in for your reference if necessary, eg Product is Rubber and specification is XX1, can be input/edited directly in the table
For the spot brand in the spot contract, the product specification information is non-important information, and more information is filled in for the convenience of retrieval, such as corn starch, can be input/edited directly in the table
Contract Quantity：Quantity*：Contract quantity, can be input/edited directly in the table
Title Transfer Date：Title Transfer Date, if you did not input, it will remain as empty or auto-filled with the trade’s Trade Date if AUTO TTD is ticked or selected, can be input/edited directly in the table
Payment Date：Payment date, can be input/edited directly in the table
LC Issuing Date: Letter of Credit issuing date
LC Number：Letter of Credit number
Presentation period: Presentation period
Pricing Start ：Start date of pricing period
Pricing End：End date of pricing period
Formula Name：If you use FORMULA pricing as the pricing mode for your trade, the formula name will be displayed here
Formula：If you use FORMULA pricing as the pricing mode for your trade, the formula will be displayed here
WMT：Wet Metric Ton
DMT：Dry Metric Ton
FE%：Iron %
MOIS%：Moisture %
Provisional Quantity：Provisional Quantity
Provisional Price：Provisional price, can be input/edited directly in the table
Actual Quantity ：Actual quantity, can be input/edited directly in the table
Pre-Final Quantity：System will auto-calculate, please refer to below Calculations Formula details
Price Unit：Unit*：Product unit eg metric ton
Estimated Price：Estimated price, if no Actual Price is input, the system will use Estimated Price to calculate P/L. Once you input Actual Price, the system will automatically use Actual Price to calculate P/L instead of Estimated Price. This field can be input/edited directly in the table
Actual Price：Actual price, can be input/edited directly in the table
Premium/Discount: Premium/Discount, can be input/edited directly in the table
Pre-Final Price ：System will auto-calculate, please refer to below Calculations Formula details
Pre-Final Price Before Tax ：System will auto-calculate, please refer to below Calculations Formula details
Final Price ：System will auto-calculate, please refer to below Calculations Formula details
Tax Rate（%）：Tax rate of contract, if “13%”, please input “13”
Priced In：System will auto-display, please refer to below Calculations Formula details
TRUE：If Estimated Price or Actual Price is input
FALSE：If Estimated Price or Actual Price is not input yet
Exchange Rate: Final exchange rate used for calculating P/L. If not filled, system will calculate according to the public exchange rate obtained from Exchange sources. Once you input the exchange rate, the system will use it to calculate P/L. This field can be input/edited directly in the table
Custom Tax Rate：Custom Tax Rate, can be input/edited directly in the table
Cargo Value：System will auto-calculate, please refer to below Calculations Formula details
Cargo Value Before Tax：System will auto-calculate, please refer to below Calculations Formula details
Remarks：Remarks, can be input/edited directly in the table
...