Posted by 
In order to be able to group the fiduciary order according a preferential interest rate, we could do the following : 1) Create a local reference, by linking the vetting table to a field of the customer file for automatic selection, as follows :
BNK LOCAL.TABLE SEE
TABLE.NO.......... 200
-----------------------------------------------------------------------
1. 1 GB DESCRIPTION. FID.INT.GROUP
2. 1 GB SHORT.NAME.. FID.INT.GROUP
3 MAXIMUM.CHAR...... 10
5 CHAR.TYPE......... A
6. 1 VETTING.TABLE.. 1
7. 1. 1 GB REMARK... GROUP1
8. 1 APPLICATION.... FD.FID.ORDER FIDUCIARY ORDERS
9. 1. 1 DECIS.FIELD. 1 CUSTOMER
10. 1. 1 REPLACE.FILE CUSTOMER
11. 1. 1 REPLACE.FLD. 14 TARGET
12. 1. 1 DECISION.... EQ
13. 1. 1 DECISION.FR. 1
14. 1. 1 DECISION.TO. 30
6. 2 VETTING.TABLE.. 2
7. 2. 1 GB REMARK... GROUP2
8. 2 APPLICATION.... FD.FID.ORDER FIDUCIARY ORDERS
9. 2. 1 DECIS.FIELD. 1 CUSTOMER
10. 2. 1 REPLACE.FILE CUSTOMER
11. 2. 1 REPLACE.FLD. 14 TARGET
12. 2. 1 DECISION.... EQ
13. 2. 1 DECISION.FR. 31
14. 2. 1 DECISION.TO. 99
16 DEFAULT.POSSIBLE.. Y
21 CURR.NO........... 4
22. 1 INPUTTER.......
23 DATE.TIME.........
24 AUTHORISER........
25 CO.CODE...........
26 DEPT.CODE.........
In this example we have linked the field target of the customer file, but we can link any field of the customer file in the same way.
Then link the local reference 200 the file Fd.Fid.Order as follows : COPY OF BNK LOCAL.REF.TABLE SEE
APPLICATION....... FD.FID.ORDER FIDUCIARY ORDERS
------------------------------------------------------------------------------
1. 1 LOCAL.TABLE.NO. 200 FID.INT.GROUP
4 CURR.NO........... 1
5. 1 INPUTTER.......
6 DATE.TIME.........
7 AUTHORISER........
8 CO.CODE...........
9 DEPT.CODE.........
Add the 4th criteria in FD.Parameter as follows :
BNK FIDUCIARY PARAMETERS SEE
KEY............... SYSTEM
------------------------------------------------------------------------------
1. 1 FID.TYPE....... FIXED
2. 1. 1 GB DESCRIPT. FIXED FIDUCIARY
3. 1 DEP.CATEG.STRT. 27001 FIXED FID DEP
4. 1 DEP.CATEG.END.. 27011 FIXED FID DEP
5. 1 PLCMT.CAT.STRT. 27101 FIXED FID PLAC
6. 1 PLCMT.CAT.END.. 27111 FIXED FID PLAC
7. 1 DEF.CAT.DEPOSIT 27001 FIXED FID DEP
8. 1 DEF.CAT.PLCMT.. 27101 FIXED FID PLAC
9. 1 MARGIN.RATE.... 10
1. 2 FID.TYPE....... NOTICE
2. 2. 1 GB DESCRIPT. NOTICE FIDUCIARY
3. 2 DEP.CATEG.STRT. 27051 C/N FID DEP
4. 2 DEP.CATEG.END.. 27061 C/N FID DEP
5. 2 PLCMT.CAT.STRT. 27151 C/N FID PLACMNT
6. 2 PLCMT.CAT.END.. 27161 C/N FID PLACMNT
7. 2 DEF.CAT.DEPOSIT 27051 C/N FID DEP
8. 2 DEF.CAT.PLCMT.. 27151 C/N FID PLACMNT
9. 2 MARGIN.RATE.... 5
12 ACCR.CYCLE.INT.... 04 NOV 1998 DAILY
13 ACCR.CYCLE.COMM... 04 NOV 1998 DAILY
14 PL.ACCR.COMM...... 52400 FID COMMSN
15 PREV.MTH.ADJ.C.... 52400 FID COMMSN
16 PREV.YR.ADJ.C..... 52400 FID COMMSN
18 BROKER.CAT........ 53005 BROKERAGE
19 INT.DIFF.CAT...... 16400 FEES PAYABLE
20 RENEWAL.DAYS...... 2W
21 RENEWAL.OVE....... ACCOUNT
22 RENEWAL.START..... 0W
24 RENEW.RPT.DAYS.... 3W
25 MAT.UPD.DAYS...... 3
26 DAYS.POST.MAT..... 4C
27 DEF.RATE.NOTICE... 2
28 ONLINE.DRAWDOWN... Y
29 BACK.VALUE.MAX.... 04 SEP 1998
30 NOTICE.POOL.DEFT.. NONE
31 NOTICE.POOL.EXIST. NO
32. 1 POOLING.FIELDS. LOCAL.REF-1
Helptext of field Pooling.field as follows :
FIELD NO 32 = POOLING.FIELDS
————————————————————————————————————–
By default, the pooling of fiduciary orders to a group of orders is carried out according to three criteria ;
1) Currency 2) Value Date 3) Maturity Date
Hence orders which having matching values for these fields will be pooled together. this field is used to specify additional fields to pool by. Where orders have the same values in the additional fields, as well as the three mandatory fields, then – and only then – will the orders be pooled together.
Input to this field must be a valid, single valued field on the FD.FID.ORDER file, but specific instances of the LOCAL.REF field may be referenced. These should be input as LOCAL.REF-n, where n is the nu,ber of the local reference being referenced. (1) Must reference a valid, single valued field on the FD.FID.ORDER file, or a specific instance of a local reference field. (2) Must be in one of the following forms ; Field number Valid field numbers are converted to field names upon input. Field name Must be a valid field name LOCAL.REF-n. Where n is the instance of the multi value field to be referenced. (3) Optional
Then by inputting a new fiduciary order the system will select and attribute automatically the right code according the local reference and therefore pool the orders according the 4 criteria, as follows :
BNK FIDUCIARY ORDERS SEE
ORDER.NO.......... FDOR/98307/00013-1
------------------------------------------------------------------------------
1 CUSTOMER.......... 4881 Short.name 4881
2 FID.TYPE.......... FIXED FIXED FIDUCIARY
3 CATEGORY.......... 27-001 FIXED FID DEP
4 CURRENCY.......... GBP POUND STERLING
5 AMOUNT............ 100,000.00
6 CCY.MARKET........ 1 CURRENCY MARKET
7 ORDER.DATE........ 03 NOV 1998
8 VALUE.DATE........ 04 NOV 1998
9 MATURITY.DATE..... 04 FEB 1999
10 TERM.............. 3M 3 MONTHS
11 LIMIT.REF......... 9800.01
12 MARGIN.RATE....... 10.00
13 PORTFOLIO.NO...... 1 Account.name 4881-1
14 DRAWDOWN.ACCT..... 76006498 Sh-title 76006498
15 PRIN.LIQ.ACCT..... 76006498 Sh-title 76006498
16 INT.LIQ.ACCT...... 76006498 Sh-title 76006498
17 COMM.CHG.ACCT..... 76006498 Sh-title 76006498
18 ACCT.OFFICER...... 2000 PRIVATE BANKING DEPARTMENT
19 RENEWAL.TYPE...... NONE
28 POOLING........... AUTO
29 POOLED.GROUP...... 98307/00005 OPEN
30 POOLING.STATUS.... OPEN
33 COMM.TYPE......... STANDARD FIDUCIARY COMMISSION
36 COMM.TAKEN........ ARREARS
37 COMM.BASIS........ PRINCIPAL
69 ORDER.STATUS...... FWD
70 GROUP.COND.NO..... 002
86. 1 FID.INT.GROUP.. 1 GROUP1
87 PRINT.DEAL.SLIP... Y
88 SEND.CONFIRM...... Y
89. 1 ACTIVITY.CODE.. FO110-NONE
92. 1 OVERRIDE....... 04/11/98 76006498 CASH FLOW OVERDRAFT GBP -1098933.11
COPY OF BNK FIDUCIARY ORDERS SEE
ORDER.NO.......... FDOR/98307/00014-1
------------------------------------------------------------------------------
1 CUSTOMER.......... 2152 Short.name 2152
2 FID.TYPE.......... FIXED FIXED FIDUCIARY
3 CATEGORY.......... 27-001 FIXED FID DEP
4 CURRENCY.......... GBP POUND STERLING
5 AMOUNT............ 200,000.00
6 CCY.MARKET........ 1 CURRENCY MARKET
7 ORDER.DATE........ 03 NOV 1998
8 VALUE.DATE........ 04 NOV 1998
9 MATURITY.DATE..... 04 FEB 1999
10 TERM.............. 3M 3 MONTHS
11 LIMIT.REF......... 9800.01
12 MARGIN.RATE....... 10.00
13 PORTFOLIO.NO...... 1 SHORT NAME 2152
14 DRAWDOWN.ACCT..... 76004994 Sh-title 76004994
15 PRIN.LIQ.ACCT..... 76004994 Sh-title 76004994
16 INT.LIQ.ACCT...... 76004994 Sh-title 76004994
17 COMM.CHG.ACCT..... 76004994 Sh-title 76004994
18 ACCT.OFFICER...... 1000 CORPORATE BANKING AND CREDIT DEPT
19 RENEWAL.TYPE...... NONE
28 POOLING........... AUTO
29 POOLED.GROUP...... 98307/00006 OPEN
30 POOLING.STATUS.... OPEN
33 COMM.TYPE......... STANDARD FIDUCIARY COMMISSION
36 COMM.TAKEN........ ARREARS
37 COMM.BASIS........ PRINCIPAL
69 ORDER.STATUS...... FWD
70 GROUP.COND.NO..... 002
86. 1 FID.INT.GROUP.. 2 GROUP2
87 PRINT.DEAL.SLIP... Y
88 SEND.CONFIRM...... Y
89. 1 ACTIVITY.CODE.. FO110-NONE
92. 1 OVERRIDE....... 04/11/98 76004994 CASH FLOW OVERDRAFT GBP -2199755.59
The customer 4881 has the target code 10 and the customer 2152 has the target code 40.