2. Annexure

2.1 Accounting Handoff from External System to FCUBS

An external system can request for debit or credit to an account or GL in FCUBS through the interface.

The following major values will be passed as part of debit request for accounting handoff:

Values	Description	Mandatory
MODULE	Module which is sending for accounting handoff	Yes
TRN_REF_NO	Transaction reference number for debit / credit	No
EVENT_SR_NO	Event serial no for Dr / Cr leg	Yes
EVENT	Event against which accounting to be posted	Yes
AC_BRANCH	Branch for accounting handoff	Yes
AC_NO	Account to which Debit / Credit to be done on accounting handoff	Yes
AC_CCY	Currency of the account	Yes
DRCR_IND	Account to be debited / credited on accounting handoff	Yes
AMOUNT_TAG	Amount tag against which accounting to be posted	Yes
LCY_AMOUNT	Local ccy amount for accounting handoff	Yes
ECAREFNO	ECA reference no generated for each request under a ECA create external reference no	Yes (Man­datory for ECA Debits only)
FCYAMT	Fcy amount for accounting hand­off, Mandatory, if Account cur­rency is Fcy.	No
EXCHRATE	If Ccy is Fcy, then exchange rate and Lcy amount tags are manda­tory.	No
BLOCKRELEASES­TATUS	Block release status to be set as F - Full debit; P – For partial debit (Only if partial release is allowed).	Yes
TRN_DT	Transaction date on which accounting to be posted. It’s a non mandatory field, if not provided, accounting would be posted to current system date.	No
VALUE_DT	Value date on which accounting to be posted. It’s a non mandatory field, if not provided, would be defaulted to current system date.	No
TXNNARRATIVE	Transaction narrative captured as part of request will be displayed in account statement.	No

The following values will be passed as part of accounting handoff for accounting posting:

Values	Description	Default value	Possible values	Mandatory
CHEQUE_MANDATORY	If debit to happen against an account based on the instru­ment no, then cheque mandatory to be Y.	N	Y / N	No
INSTRUMENTCODE	If cheque mandatory is Yes, then instru­ment code to be mandatory in the request. Based on that, the chq no would be updated to used in FLEXCUBE system.	Null	Valid instru­ment number	No
AVAILBALREQD	If balance checked to happen as part of ECA debit, this flag to be Y.	Y	Y / N	No
AVLINFO	Balance will be updated immediately / move to uncollected balance (for credit transaction alone) based on the value provided.	I - Imme­diate	I - Imme­diate- V - On value Date	No
INTRADAYRELEASE	If Available info is I and intraday release is Y, then funds will be in Uncollected, to be cleared on intra­day batch run.	N	Y / N	No
ESCROW	If Escrow is set as Y, then on EAC credit, amount would be blocked, if it’s against a project account.	N	Y / N	No
CONSFORACCACTIVITY	To make the account undormant on ECA processing, then consider for account activity to be sent as Y in request.	Y	Y / N	No
CONSFORTRNOVER	To restrict the maxi­mum amount to be credited to an account, this flag to be sent as Y in the request.	N	Y / N	No
SWEEPREQD	If ECA debit is made more than requested amount and if sweep is Yes, then excess debit will be covered from cover accounts, if available balance isn't sufficient to cover excess debit.	N	Y / N	No
DEBIT_OVER­RIDE_TRACKING	If account is set for Debit override, if this tag has value B / O, then debit override will be displayed.	B	B/O	No
CREDIT_OVER­RIDE_TRACKING	If account is set for Credit override, if this tag has value B / O, then credit override will be displayed.	B	B/O	No
DONTSHOWINSTMT	If during reversal request of external entries, reversal entries to be excluded from account statement, then DONTSHOW­INSTMT should be Y.	N	Y/N	No
EVENTSRNOTOBEREVD	If during reversal request of external entries, event slr no to be reversed should be sent in request.	Null	Valid event slr no	Yes (for reversal request)
TRNCODE	If transaction code is sent as part of request, it will be stored in the ACT­B_ENTRIES_TRN­CODE_DETAILS table	Null	Transac­tion Code	No
SWIFT_CODE	If SWIFT_CODE is sent as part of request, then it will be displayed in the SWIFT account statement.	Null	Valid SWIFT code	No
ACTIONINDICATOR	Indicates the MIS is for Modification or New	Null	‘N’ or ‘M’	Yes
TAG61SUPPINFO	If the transaction is used for SWIFT mes­sage supplementary information will be send in this tag.	Null
USERREFNO	User reference num­ber used for Advice and SWIFT mes­sage.	Null
ISREVERSAL	Indicate the transac­tion from external process is for rever­sal or not.	Null	R or Null
BANKREFNO	Bank reference num­ber used for SWIFT message	Null
ADDLINFO	Additional informa­tion used for Advice and SWIFT mes­sage.	Null

Note

Transaction code is not mandatory for external entry hand-off.

The following values will be passed as part of accounting handoff for accounting posting for MIS:

Values	Description	Default value
BRNCD	Transaction Branch Code	Null
CALCMETH1	Calculation Method	Null
CCY	Currency	Null
COMPMIS1	Composite MIS code 1	Null
COMPMIS2	Composite MIS code 2	Null
COMPMIS3	Composite MIS code 3	Null
COMPMIS4	Composite MIS code 4	Null
COMPMIS5	Composite MIS code 5	Null
COMPMIS6	Composite MIS code 6	Null
COMPMIS7	Composite MIS code 7	Null
COMPMIS8	Composite MIS code 8	Null
COMPMIS9	Composite MIS code 9	Null
COMPMIS10	Composite MIS code 10	Null
COSTCD1	MIS Cost Code 1	Null
COSTCD2	MIS Cost Code 2	Null
COSTCD3	MIS Cost Code 3	Null
COSTCD4	MIS Cost Code 4	Null
COSTCD5	MIS Cost Code 5	Null
CUSTOMER	Customer Number	Null
FUNDMIS1	Fund MIS Code 1	Null
FUNDMIS2	Fund MIS Code 2	Null
FUNDMIS3	Fund MIS Code 3	Null
FUNDMIS4	Fund MIS Code 4	Null
FUNDMIS5	Fund MIS Code 5	Null
FUNDMIS6	Fund MIS Code 6	Null
FUNDMIS7	Fund MIS Code 7	Null
FUNDMIS8	Fund MIS Code 8	Null
FUNDMIS9	Fund MIS Code 9	Null
FUNDMIS10	Fund MIS Code 10	Null
GRPREFNO	Group reference number to indicate the group of Trans­action doe which the MIS is applicable.	Null
MISGRP	MIS group	Null
MISGRPCOMP	Composite MIS group	Null
MISGRPFUN	Fund MIS group	Null
MISGRPTXN	Transaction MIS group	Null
MISHEAD	MIS head	Null
POOLCD	Pool Code	Null
PROCESSED­FLAG	MIS Processed Flag	Null
PRODUCT	Product code	Null
RATEFLG	Rate flag for MIS process­ing	Null
REFRATE	Ref rate for MIS	Null
REFRATECD	Ref rate code for MIS	Null
REFRATETYP	Ref rate type for MIS	Null
REFSPREAD	Ref spread	Null
REFXRATE	Ref exchange rate	Null
RELACC	Related account number	Null
RELET­ED_REFER­ENCE	Related reference number for MIS	Null
RGREL		Null
TXNMIS1	Transaction MIS code 1	Null
TXNMIS2	Transaction MIS code 2	Null
TXNMIS3	Transaction MIS code 3	Null
TXNMIS4	Transaction MIS code 4	Null
TXNMIS5	Transaction MIS code 5	Null
TXNMIS6	Transaction MIS code 6	Null
TXNMIS7	Transaction MIS code 7	Null
TXNMIS8	Transaction MIS code 8	Null
TXNMIS9	Transaction MIS code 9	Null
TXNMIS10	Transaction MIS code 10	Null
UNITREFNO	Reference number ,either account number or contract ref number base to the MIST type.	Null
UNITTYPE	Unit type ,to indicate Account MIS or contract MIS	Null