3. Annexure

3.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

Note

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