FINANCE - Finance/Risk Summary
What is
This report will list all TRADE records that have been maintained with a Trust/Bank Loan account and that TRADE has NOT been marked as completed; i.e. Loans still outstanding.
The selections are Department and the output media, which would logically be a .xls as the content of the report is a large number of columns that if printed directly from ITAS would be unreadable.
The TRADEs are sectioned into a separate page per bank account, sequenced by/grouped by selection i.e.
a) Department
b) Warehouse Location
c) Country Of origin
d) Shipping Status
Within each of these groupings the TRADE details are further sectioned by unallocated Purchases and allocated Purchases with associate Sales details.
The content of the row is ex TRADE i.e.
1. Purchase ITAS contract reference
2. Purchase Trust Reference (LTD)
3. Lot reference, TRADE/Traffic/shipping/Fwd Ref
4. Weight (MT equivalent), TRADE
5. Seller Code: TRADE
6. Purchase Currency; TRADE
7. Purchase Price; TRADE
8. Expiry of Financing, TRADE (phys01_trustdate)
9. Remaining days, basis ITAS run date to/from Expiry Of Financing
10. Purchase Contract value; TRADE
11. Margin%; TRADE (100- phys01_trustpc)
12. Margin value; Purchase Contract less Finance value
13. Financed value; TRADE (phys01_trustamt)
14. M2M on Margin%; use TRADE (phys01_trustcommod) for SPOT + 1 price
15. Vessel name; TRADE
16. FX Rate of Exchange; TRADE (phys01_roe)
17. Traded Currency; TRADE (phys01_roeccy)
18. Traded value; calculated using roe and FX covered amount
19. Sale ITAS contract reference
20. Sale Takeon reference
21. Buyer Code; TRADE
22. Sale currency code; TRADE
23. Sale contract value; TRADE
24. Sale Invoice Ref; TRADE (phys01_invref)
25. Sale Due Date; TRADE (phys01_duedate)
26. Sale release date; TRADE (phys01_deliverydate)
27. Journey ref, TRADE/Traffic/Shipping
28. Commodity code; TRADE
29. Crop year; TRADE
30. Start of Financing, date when the PI was paid(CASH)
31. Group Number; TRADE
32. B/L Reference, TRADE
33. Port of destination, TRADE
34. PI Invoice reference, TRADE
35. Purchase Invoice value, TRADE
36. P&L value; per TRADE/FinCalc
Totals are produced for each sub-section and the main Grouping