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