gateway elmultifacilityservice

Gateway Documentation - Multi facilityOracle FLEXCUBE Universal Banking

Release FCELCM_1.1.13[October][2013]

1. BACKGROUND ................................................... 12. ELMultiFacilityService ................................................... 2 2.1.AuthMultiFacility ................................................... 2 2.1.1. GE-MultiFacilityAuthorize-Req-Full-MSG.xsd ............................................................ 2 2.1.2. GE-MultiFacilityAuthorize-Res-Full-MSG.xsd ............................................................ 50 2.2.CloseMultiFacility ................................................... 99 2.2.1. GE-MultiFacilityClose-Req-Full-MSG.xsd ............................................................ 99 2.2.2. GE-MultiFacilityClose-Res-Full-MSG.xsd ............................................................ 147 2.3.CreateMultiFacility ................................................... 196 2.3.1. GE-MultiFacilityCreate-Req-Full-MSG.xsd ............................................................ 196 2.3.2. GE-MultiFacilityCreate-Res-Full-MSG.xsd ............................................................ 244 2.4.DeleteMultiFacility ................................................... 293 2.4.1. GE-MultiFacilityDelete-Req-Full-MSG.xsd ............................................................ 293 2.4.2. GE-MultiFacilityDelete-Res-Full-MSG.xsd ............................................................ 341 2.5.ModifyMultiFacility ................................................... 390 2.5.1. GE-MultiFacilityModify-Req-Full-MSG.xsd ............................................................ 390 2.5.2. GE-MultiFacilityModify-Res-Full-MSG.xsd ............................................................ 438 2.6.ReopenMultiFacility ................................................... 487 2.6.1. GE-MultiFacilityReopen-Req-Full-MSG.xsd ............................................................ 487 2.6.2. GE-MultiFacilityReopen-Res-Full-MSG.xsd ............................................................ 535

Table Of Contents_______________________

1.BACKGROUND

Integration of different applications and solutions is a key area in todays systems. A variety of specialized applicationsdeployed on disparate platforms and using different infrastructure need to be able to communicate and integrateseamlessly with FLEXCUBE UBS in order to exchange data.The FLEXCUBE UBS Integration Gateway (referred to asGateway) will cater to these integration needs.The integration needs supported by the Gateway can be broadly categorized from the perspective of the Gateway asfollows:

1. Inbound application integration used when any external system needs to add, modify or query informationwithin FLEXCUBE UBS 2. Outbound application integration used when any external system needs to be notified of the various events thatoccur within FLEXCUBE UBSThe following sections provide detailed XSD documentation of all operations available in ELMultiFacilityService ofEL-Module

1

2.ELMultiFacilityServiceMulti facilityMulti facility

2.1.AuthMultiFacilityAuthMultiFacility

2.1.1.GE-MultiFacilityAuthorize-Req-Full-MSG.xsd

FCUBS_HEADER SOURCE UBSCOMP MSGID CORRELID USERID BRANCH MODULEID SERVICE OPERATION SOURCE_OPERATION SOURCE_USERID DESTINATION MULTITRIPID FUNCTIONID ACTION MSGSTAT ADDL PARAM NAME VALUE FCUBS_BODY MultiFacility-Full Facility LINECODE LINESERIAL CCYREST LINECCY REVOLVINGLINE LINESTARTDATE LINEEXPIRYDATE LASTNEWUTILDATE AVAILABILITYFLAG INTERNALREMARKS LIMITAMOUNT COLLATERALCONTRIBUTION

2

UNCOLLECTEDFUNDSLIMIT REPORTINGAMOUNT AVAILABLEAMOUNT DATEOFFIRSTOD DATEOFLASTOD NETTINGREQUIRED UNADVISED TRANSFERAMOUNT DSPEFFLINEAMOUNT ID AMOUNTUTILISEDTODAY AMOUNTREINSTATEDTODAY UNCOLLECTEDAMOUNT EXCESSTENOR UTILISATION LIABBR COLLATERALPCT BRN LMTAMTBASIS FUNDED AVAILMENTDATE EXCEPTXNAMT USERDEFINESTATUS BLOCKAMOUNT TANKEDUTIL NETTINGAMOUNT EXCEPBREACH CATEGORY EXTERNALREFNO PROCESSNO USERREFNO CONVERSIONDATE TENORRESTTYPE CUSTOMERRESTTYPE PRODUCTRESTTYPE BRANCHRESTTYPE CCYRESTTYPE EXTSYSTEMRESTTYPE LIABID MAINLINEID DESCRIPTION SHADOWLIMIT APPROVEDAMT DAYLIGHTLIMIT

3

USERDEFSTATCHANGEDDT EXPRESTTYPE DAYLIGHTODLIMIT COMMITMENTPRODUCT COMMITMENTSETTLBRN COMMITMENTSETTLACC BULKPMTREQD MAKERID MAKERDTSTAMP CHECKERID CHECKERDTSTAMP MODNO AUTHSTAT RECSTAT ONCEAUTH FacilitySchedules FACILITYID LIMITDATE LIMITAMOUNT ID FacilityTenorRestriction FACILITYID TENOR TENORMNEMONIC LIMIT UTILISATION FROMPRV TONEXT LIABBRANH ID FacilityCustomerRestriction FACILITYID CUSTOMERNO ID FacilityBranchRestriction FACILITYID BRANCHCODE ID FacilityProductRestriction FACILITYID PRODUCTCODE ID FacilityCurrencyRestriction FACILITYID

4

CCY ID FacilityValueDateDetails FACILITYID ID LIMITAMOUNT VALUEDATE BOOKDATE MODNO FacilityCharge ID FACILITYID ADMINCHARGETYPE ADMINCHARGEPERCT ADMINCHARGEAMT UTLCHARGETYPE UTLCHARGEPERCT UTLCHARGEAMT UNUTLCHARGETYPE UNUTLCHARGEPERCT UNUTLCHARGEAMT MODNO FacilityCovenant ID FACILITYID COVENANTID MANDATORY PERIODCITY PERIOD STARTDATE GRACEDAYS REVISIONDATE NOTICEDAYS COVENANTREFNO REMARKS MODNO FacilityExposure ID FACILITYID EXPOSUREID MODNO FacilitySystemRestriction ID FACILITYID

5

EXTSYSTEM MODNO FacilityPoolLink LIABID POOLID TYPE FACILITYBRANCHCODE FACILITYID FACILITYCURRENCY FACILITYAMOUNT FACILITYAMOUNTPOOLCCY PERCENTAGEOFPOOL PERCENTAGEOFCONTRACT ID MODNO FacilityExposureRestriction FACILITY EXPOSURE FacilityMandate MANDATETYPE MANDATE MINPERAVAL FacilityUDEValues FACILITY UDEID UDEVALUE RATECODE CODEUSAGE UDFDETAILS FUNCTIONID FIELD_NAME DATATYPE FIELD_VALUE VAL_TYPEFCUBS_HEADER

TOP

SOURCE

Attribute DescriptionName FCUBS_HEADERDatatypeDescription

Attribute DescriptionName SOURCE

6

TOP

UBSCOMP

TOP

MSGID

TOP

CORRELID

Datatype StringDescription This is the code for the system which has sourced this message. For request

messages, this field has to contain the source code for the partner system asmaintained within FLEXCUBE UBS. In case of response messages this fieldwill contain "FLEXCUBE".

Restrictions Restrictions Descriptionpattern [a-zA-Z_0-9]*

Attribute DescriptionName UBSCOMPDatatype StringDescription This is the component of FLEXCUBE for which this message is meant.

Gateway supports both FLEXCUBE UBS and FLEXCUBE Investor Services.If the message is for FLEXCUBE UBS then this field should contain "FCUBS"and "FCIS" if meant for FLEXCUBE Investor Services. This field is case-sensitive.

Restrictions Restrictions Descriptionenumeration FCUBS,FCIS

Attribute DescriptionName MSGIDDatatype StringDescription This is the "unique" message ID for this message. In inbound messages, if

this field is present then Gateway would perform technical duplicaterecognition using this field. For all messages going out from Gateway,Gateway will populate a unique message ID in this field.

Attributes Attribute DescriptionminOccurs 0nillable true


Attribute DescriptionName CORRELIDDatatype StringDescription This is the correlation ID for the message. Gateway supports 2 correlation

patterns, namely "Message ID to Correlation ID" (M2C) and "Correlation ID toCorrelation ID" (C2C). While using asynchronous means of communication(like a JMS queue), the partner system can correlate the response receivedfrom Gateway to the request message sent by it using this field. If thecorrelation pattern is M2C then this field will contain the MSGID of the requestmessage. If the correlation pattern is C2C then this field will contain theCORRELID of the request message.



7

TOP

USERID

TOP

BRANCH

TOP

MODULEID

TOP

SERVICE

TOP

OPERATION

Attribute DescriptionName USERIDDatatype StringDescription This is the user id which will be used within FLEXCUBE to record the

transaction. This needs to be a valid user id as maintained withinFLEXCUBE.

Restrictions Restrictions DescriptionmaxLength 12pattern [A-Z_0-9]*

Attribute DescriptionName BRANCHDatatype StringDescription This is the Branch of FLEXCUBE where the transaction would be recorded.

This needs to be a valid Branch code as maintained in FLEXCUBE.Restrictions Restrictions Description

length 3pattern [a-zA-Z_0-9]{3}

Attribute DescriptionName MODULEIDDatatype StringDescription This field is applicable only if messages are being sent to FCIS using

Gateway. This is the module id of FCIS where the transaction will berecorded.


Attribute DescriptionName SERVICEDatatype StringDescription This field should contain the code of the Service of FLEXCUBE which is

being requested. This field is case-sensitive.Attributes Attribute Description

nillable trueRestrictions Restrictions Description

pattern [a-zA-Z_0-9]*

8

TOP

SOURCE_OPERATION

TOP

SOURCE_USERID

TOP

DESTINATION

TOP

Attribute DescriptionName OPERATIONDatatype StringDescription This is the operation of the service which is being invoked. This field is case-

sensitive.Attributes Attribute Description



Attribute DescriptionName SOURCE_OPERATIONDatatype StringDescription This is the code for the operation being invoked in the Source system. The

code of Source Operation being sent needs to be maintained as a validSource Operation for the Source within FLEXCUBE.



Attribute DescriptionName SOURCE_USERIDDatatype StringDescription This is the user id in the Source system who is performing the action.Attributes Attribute Description

minOccurs 0nillable true

Attribute DescriptionName DESTINATIONDatatype StringDescription This the system for which this message is destined. In case of request

messages to FLEXCUBE, it should be "FLEXCUBE". In case of response, theSOURCE from the request message is reproduced here.

Attributes Attribute DescriptionminOccurs 0


9

MULTITRIPID

TOP

FUNCTIONID

TOP

ACTION

TOP

MSGSTAT

Attribute DescriptionName MULTITRIPIDDatatype StringDescription In response messages, this is the ID sent by FLEXCUBE in case any

overrides are encountered. In request messages, the source system isexpected to reproduce the MULTITRIPID from the earlier received response ifthe source system accepts the overrides.



Attribute DescriptionName FUNCTIONIDDatatype StringDescription This is the function in FLEXCUBE which is being invoked. For integration

scenarios this need not be sent. This is used by FLEXCUBE native userinterface.



Attribute DescriptionName ACTIONDatatype StringDescription This is the action on the function being invoked. For integration scenarios this

need not be sent. This is used by FLEXCUBE native user interface.Attributes Attribute Description

minOccurs 0Restrictions Restrictions Description


Attribute DescriptionName MSGSTATDatatype StringDescription In response messages, FLEXCUBE will indicate the status of the request in

this field. The various values are "SUCCESS", "WARNING" and "FAILURE".Attributes Attribute Description

minOccurs 0

10

TOP

ADDL

TOP

PARAM

TOP

NAME

TOP

VALUE

TOP

FCUBS_BODY

TOP

MultiFacility-Full

Restrictions Restrictions Descriptionenumeration SUCCESS,WARNING,FAILURE

Attribute DescriptionName ADDLDatatypeDescription This node is to be used for Additional information about a message.Attributes Attribute Description

minOccurs 0

Attribute DescriptionName PARAMDatatypeDescription This is the parent node for each parameter in the additional node.Attributes Attribute Description

maxOccurs unboundedminOccurs 0

Attribute DescriptionName NAMEDatatype StringDescription The name of the additional parameter comes here.

Attribute DescriptionName VALUEDatatype StringDescription The value of the addtional parameter comes here.

Attribute DescriptionName FCUBS_BODYDatatypeDescription

Attribute DescriptionName MultiFacility-Full

11

TOP

Facility

TOP

LINECODE

TOP

LINESERIAL

TOP

CCYREST

TOP

LINECCY

DatatypeDescription

Attribute DescriptionName FacilityDatatypeDescriptionAttributes Attribute Description

maxOccurs unbounded

Attribute DescriptionName LINECODEDatatype StringDescriptionRestrictions Restrictions Description

maxLength 50

Attribute DescriptionName LINESERIALDatatype NumberDescription

Attribute DescriptionName CCYRESTDatatype StringDescriptionAttributes Attribute Description


maxLength 1

Attribute DescriptionName LINECCYDatatype StringDescriptionRestrictions Restrictions Description

maxLength 3

12

TOP

REVOLVINGLINE

TOP

LINESTARTDATE

TOP

LINEEXPIRYDATE

TOP

LASTNEWUTILDATE

TOP

AVAILABILITYFLAG

Attribute DescriptionName REVOLVINGLINEDatatype StringDescriptionAttributes Attribute Description


maxLength 1

Attribute DescriptionName LINESTARTDATEDatatype DateDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName LINEEXPIRYDATEDatatype DateDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName LASTNEWUTILDATEDatatype DateDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName AVAILABILITYFLAGDatatype StringDescriptionAttributes Attribute Description

minOccurs 0

13

TOP

INTERNALREMARKS

TOP

LIMITAMOUNT

TOP

COLLATERALCONTRIBUTION

TOP

UNCOLLECTEDFUNDSLIMIT

TOP

REPORTINGAMOUNT

Restrictions Restrictions DescriptionmaxLength 1

Attribute DescriptionName INTERNALREMARKSDatatype StringDescriptionAttributes Attribute Description


maxLength 255

Attribute DescriptionName LIMITAMOUNTDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName COLLATERALCONTRIBUTIONDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName UNCOLLECTEDFUNDSLIMITDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName REPORTINGAMOUNTDatatype NumberDescription

14

TOP

AVAILABLEAMOUNT

TOP

DATEOFFIRSTOD

TOP

DATEOFLASTOD

TOP

NETTINGREQUIRED

TOP

UNADVISED


Attribute DescriptionName AVAILABLEAMOUNTDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName DATEOFFIRSTODDatatype DateDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName DATEOFLASTODDatatype DateDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName NETTINGREQUIREDDatatype StringDescriptionAttributes Attribute Description


maxLength 1

Attribute DescriptionName UNADVISEDDatatype StringDescription

15

TOP

TRANSFERAMOUNT

TOP

DSPEFFLINEAMOUNT

TOP

ID

TOP

AMOUNTUTILISEDTODAY

TOP

AMOUNTREINSTATEDTODAY



Attribute DescriptionName TRANSFERAMOUNTDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName DSPEFFLINEAMOUNTDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName IDDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName AMOUNTUTILISEDTODAYDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName AMOUNTREINSTATEDTODAYDatatype NumberDescription

16

TOP

UNCOLLECTEDAMOUNT

TOP

EXCESSTENOR

TOP

UTILISATION

TOP

LIABBR

TOP

COLLATERALPCT


Attribute DescriptionName UNCOLLECTEDAMOUNTDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName EXCESSTENORDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName UTILISATIONDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName LIABBRDatatype StringDescriptionAttributes Attribute Description


maxLength 3

Attribute DescriptionName COLLATERALPCTDatatype NumberDescription

17

TOP

BRN

TOP

LMTAMTBASIS

TOP

FUNDED

TOP

AVAILMENTDATE

TOP

EXCEPTXNAMT


Attribute DescriptionName BRNDatatype StringDescriptionAttributes Attribute Description


maxLength 3

Attribute DescriptionName LMTAMTBASISDatatype StringDescriptionRestrictions Restrictions Description

enumeration A,L,M,

Attribute DescriptionName FUNDEDDatatype StringDescriptionAttributes Attribute Description


maxLength 1

Attribute DescriptionName AVAILMENTDATEDatatype DateDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName EXCEPTXNAMT

18

TOP

USERDEFINESTATUS

TOP

BLOCKAMOUNT

TOP

TANKEDUTIL

TOP

NETTINGAMOUNT

TOP

EXCEPBREACH

Datatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName USERDEFINESTATUSDatatype StringDescriptionAttributes Attribute Description


maxLength 50

Attribute DescriptionName BLOCKAMOUNTDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName TANKEDUTILDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName NETTINGAMOUNTDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName EXCEPBREACH

19

TOP

CATEGORY

TOP

EXTERNALREFNO

TOP

PROCESSNO

TOP

USERREFNO

Datatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName CATEGORYDatatype StringDescriptionAttributes Attribute Description


maxLength 50

Attribute DescriptionName EXTERNALREFNODatatype StringDescriptionAttributes Attribute Description


maxLength 50

Attribute DescriptionName PROCESSNODatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName USERREFNODatatype StringDescriptionAttributes Attribute Description


maxLength 50

20

TOP

CONVERSIONDATE

TOP

TENORRESTTYPE

TOP

CUSTOMERRESTTYPE

TOP

PRODUCTRESTTYPE

TOP

BRANCHRESTTYPE

Attribute DescriptionName CONVERSIONDATEDatatype DateDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName TENORRESTTYPEDatatype StringDescriptionAttributes Attribute Description


enumeration A,D

Attribute DescriptionName CUSTOMERRESTTYPEDatatype StringDescriptionAttributes Attribute Description


enumeration A,D

Attribute DescriptionName PRODUCTRESTTYPEDatatype StringDescriptionAttributes Attribute Description


enumeration A,D

Attribute DescriptionName BRANCHRESTTYPE

21

TOP

CCYRESTTYPE

TOP

EXTSYSTEMRESTTYPE

TOP

LIABID

TOP

MAINLINEID

TOP

DESCRIPTION

Datatype StringDescriptionAttributes Attribute Description


enumeration A,D

Attribute DescriptionName CCYRESTTYPEDatatype StringDescriptionAttributes Attribute Description


enumeration A,D

Attribute DescriptionName EXTSYSTEMRESTTYPEDatatype StringDescriptionAttributes Attribute Description


enumeration A,D

Attribute DescriptionName LIABIDDatatype StringDescription

Attribute DescriptionName MAINLINEIDDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

22

TOP

SHADOWLIMIT

TOP

APPROVEDAMT

TOP

DAYLIGHTLIMIT

TOP

USERDEFSTATCHANGEDDT

Attribute DescriptionName DESCRIPTIONDatatype StringDescriptionAttributes Attribute Description


maxLength 255

Attribute DescriptionName SHADOWLIMITDatatype StringDescriptionAttributes Attribute Description


maxLength 1

Attribute DescriptionName APPROVEDAMTDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName DAYLIGHTLIMITDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName USERDEFSTATCHANGEDDTDatatype DateDescriptionAttributes Attribute Description

minOccurs 0

23

TOP

EXPRESTTYPE

TOP

DAYLIGHTODLIMIT

TOP

COMMITMENTPRODUCT

TOP

COMMITMENTSETTLBRN

TOP

COMMITMENTSETTLACC

Attribute DescriptionName EXPRESTTYPEDatatype StringDescriptionAttributes Attribute Description


enumeration A,D

Attribute DescriptionName DAYLIGHTODLIMITDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName COMMITMENTPRODUCTDatatype StringDescriptionAttributes Attribute Description


maxLength 10

Attribute DescriptionName COMMITMENTSETTLBRNDatatype StringDescriptionAttributes Attribute Description


maxLength 10

Attribute DescriptionName COMMITMENTSETTLACC

24

TOP

BULKPMTREQD

TOP

MAKERID

TOP

MAKERDTSTAMP

TOP

CHECKERID

Datatype StringDescriptionAttributes Attribute Description


maxLength 50

Attribute DescriptionName BULKPMTREQDDatatype StringDescriptionAttributes Attribute Description


maxLength 1

Attribute DescriptionName MAKERIDDatatype StringDescriptionAttributes Attribute Description


maxLength 12

Attribute DescriptionName MAKERDTSTAMPDatatype StringDescriptionAttributes Attribute Description


maxLength 25

Attribute DescriptionName CHECKERIDDatatype StringDescription

25

TOP

CHECKERDTSTAMP

TOP

MODNO

TOP

AUTHSTAT

TOP

RECSTAT



Attribute DescriptionName CHECKERDTSTAMPDatatype StringDescriptionAttributes Attribute Description


maxLength 25

Attribute DescriptionName MODNODatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName AUTHSTATDatatype StringDescriptionAttributes Attribute Description


maxLength 1

Attribute DescriptionName RECSTATDatatype StringDescriptionAttributes Attribute Description


maxLength 1

26

TOP

ONCEAUTH

TOP

FacilitySchedules

TOP

FACILITYID

TOP

LIMITDATE

TOP

LIMITAMOUNT

Attribute DescriptionName ONCEAUTHDatatype StringDescriptionAttributes Attribute Description


maxLength 1

Attribute DescriptionName FacilitySchedulesDatatypeDescriptionAttributes Attribute Description


Attribute DescriptionName FACILITYIDDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName LIMITDATEDatatype DateDescription


minOccurs 0

27

TOP

ID

TOP

FacilityTenorRestriction

TOP

FACILITYID

TOP

TENOR

TOP

TENORMNEMONIC


minOccurs 0

Attribute DescriptionName FacilityTenorRestrictionDatatypeDescriptionAttributes Attribute Description



minOccurs 0

Attribute DescriptionName TENORDatatype NumberDescription

Attribute DescriptionName TENORMNEMONICDatatype StringDescriptionAttributes Attribute Description


maxLength 6

28

TOP

LIMIT

TOP

UTILISATION

TOP

FROMPRV

TOP

TONEXT

TOP

LIABBRANH

Attribute DescriptionName LIMITDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName UTILISATIONDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName FROMPRVDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName TONEXTDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName LIABBRANHDatatype StringDescriptionAttributes Attribute Description


maxLength 3

29

TOP

ID

TOP

FacilityCustomerRestriction

TOP

FACILITYID

TOP

CUSTOMERNO

TOP

ID


minOccurs 0

Attribute DescriptionName FacilityCustomerRestrictionDatatypeDescriptionAttributes Attribute Description



minOccurs 0

Attribute DescriptionName CUSTOMERNODatatype StringDescriptionRestrictions Restrictions Description

maxLength 9


minOccurs 0

30

TOP

FacilityBranchRestriction

TOP

FACILITYID

TOP

BRANCHCODE

TOP

ID

TOP

FacilityProductRestriction

Attribute DescriptionName FacilityBranchRestrictionDatatypeDescriptionAttributes Attribute Description



minOccurs 0

Attribute DescriptionName BRANCHCODEDatatype StringDescriptionRestrictions Restrictions Description

maxLength 3


minOccurs 0

Attribute DescriptionName FacilityProductRestrictionDatatypeDescriptionAttributes Attribute Description


31

TOP

FACILITYID

TOP

PRODUCTCODE

TOP

ID

TOP

FacilityCurrencyRestriction

TOP

FACILITYID


minOccurs 0

Attribute DescriptionName PRODUCTCODEDatatype StringDescriptionRestrictions Restrictions Description

maxLength 4


minOccurs 0

Attribute DescriptionName FacilityCurrencyRestrictionDatatypeDescriptionAttributes Attribute Description



minOccurs 0

32

TOP

CCY

TOP

ID

TOP

FacilityValueDateDetails

TOP

FACILITYID

TOP

ID

Attribute DescriptionName CCYDatatype StringDescriptionRestrictions Restrictions Description

maxLength 3


minOccurs 0

Attribute DescriptionName FacilityValueDateDetailsDatatypeDescriptionAttributes Attribute Description



minOccurs 0


minOccurs 0

33

TOP

LIMITAMOUNT

TOP

VALUEDATE

TOP

BOOKDATE

TOP

MODNO

TOP

FacilityCharge

TOP


minOccurs 0

Attribute DescriptionName VALUEDATEDatatype DateDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName BOOKDATEDatatype DateDescriptionAttributes Attribute Description

minOccurs 0


minOccurs 0

Attribute DescriptionName FacilityChargeDatatypeDescriptionAttributes Attribute Description

minOccurs 0

34

ID

TOP

FACILITYID

TOP

ADMINCHARGETYPE

TOP

ADMINCHARGEPERCT

TOP

ADMINCHARGEAMT


minOccurs 0


minOccurs 0

Attribute DescriptionName ADMINCHARGETYPEDatatype StringDescriptionAttributes Attribute Description


maxLength 1

Attribute DescriptionName ADMINCHARGEPERCTDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName ADMINCHARGEAMTDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

35

TOP

UTLCHARGETYPE

TOP

UTLCHARGEPERCT

TOP

UTLCHARGEAMT

TOP

UNUTLCHARGETYPE

TOP

UNUTLCHARGEPERCT

Attribute DescriptionName UTLCHARGETYPEDatatype StringDescriptionAttributes Attribute Description


maxLength 1

Attribute DescriptionName UTLCHARGEPERCTDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName UTLCHARGEAMTDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName UNUTLCHARGETYPEDatatype StringDescriptionAttributes Attribute Description


maxLength 1

Attribute DescriptionName UNUTLCHARGEPERCTDatatype NumberDescription

36

TOP

UNUTLCHARGEAMT

TOP

MODNO

TOP

FacilityCovenant

TOP

ID

TOP

FACILITYID


Attribute DescriptionName UNUTLCHARGEAMTDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0


minOccurs 0

Attribute DescriptionName FacilityCovenantDatatypeDescriptionAttributes Attribute Description



minOccurs 0

Attribute DescriptionName FACILITYIDDatatype NumberDescription

37

TOP

COVENANTID

TOP

MANDATORY

TOP

PERIODCITY

TOP

PERIOD

TOP

STARTDATE


Attribute DescriptionName COVENANTIDDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName MANDATORYDatatype StringDescriptionAttributes Attribute Description


maxLength 1

Attribute DescriptionName PERIODCITYDatatype StringDescriptionAttributes Attribute Description


enumeration D,M,Q,S,W,Y

Attribute DescriptionName PERIODDatatype StringDescriptionAttributes Attribute Description


maxLength 15

38

TOP

GRACEDAYS

TOP

REVISIONDATE

TOP

NOTICEDAYS

TOP

COVENANTREFNO

TOP

Attribute DescriptionName STARTDATEDatatype DateDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName GRACEDAYSDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName REVISIONDATEDatatype DateDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName NOTICEDAYSDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName COVENANTREFNODatatype StringDescriptionAttributes Attribute Description


maxLength 50

39

REMARKS

TOP

MODNO

TOP

FacilityExposure

TOP

ID

TOP

FACILITYID

Attribute DescriptionName REMARKSDatatype StringDescriptionAttributes Attribute Description


maxLength 255


minOccurs 0

Attribute DescriptionName FacilityExposureDatatypeDescriptionAttributes Attribute Description



minOccurs 0


minOccurs 0

40

TOP

EXPOSUREID

TOP

MODNO

TOP

FacilitySystemRestriction

TOP

ID

TOP

FACILITYID

Attribute DescriptionName EXPOSUREIDDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0


minOccurs 0

Attribute DescriptionName FacilitySystemRestrictionDatatypeDescriptionAttributes Attribute Description



minOccurs 0


minOccurs 0

41

TOP

EXTSYSTEM

TOP

MODNO

TOP

FacilityPoolLink

TOP

LIABID

TOP

POOLID

TOP

TYPE

Attribute DescriptionName EXTSYSTEMDatatype StringDescriptionAttributes Attribute Description


maxLength 50


minOccurs 0

Attribute DescriptionName FacilityPoolLinkDatatypeDescriptionAttributes Attribute Description


Attribute DescriptionName LIABIDDatatype StringDescription

Attribute DescriptionName POOLIDDatatype NumberDescription

42

TOP

FACILITYBRANCHCODE

TOP

FACILITYID

TOP

FACILITYCURRENCY

TOP

FACILITYAMOUNT

Attribute DescriptionName TYPEDatatype StringDescriptionAttributes Attribute Description


maxLength 1

Attribute DescriptionName FACILITYBRANCHCODEDatatype StringDescriptionRestrictions Restrictions Description

maxLength 3


minOccurs 0

Attribute DescriptionName FACILITYCURRENCYDatatype StringDescriptionAttributes Attribute Description


maxLength 3

Attribute DescriptionName FACILITYAMOUNTDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

43

TOP

FACILITYAMOUNTPOOLCCY

TOP

PERCENTAGEOFPOOL

TOP

PERCENTAGEOFCONTRACT

TOP

ID

TOP

MODNO

TOP

Attribute DescriptionName FACILITYAMOUNTPOOLCCYDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName PERCENTAGEOFPOOLDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName PERCENTAGEOFCONTRACTDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0


minOccurs 0


minOccurs 0

44

FacilityExposureRestriction

TOP

FACILITY

TOP

EXPOSURE

TOP

FacilityMandate

TOP

MANDATETYPE

Attribute DescriptionName FacilityExposureRestrictionDatatypeDescriptionAttributes Attribute Description


Attribute DescriptionName FACILITYDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName EXPOSUREDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName FacilityMandateDatatypeDescriptionAttributes Attribute Description


Attribute DescriptionName MANDATETYPEDatatype StringDescriptionAttributes Attribute Description


maxLength 1

45

TOP

MANDATE

TOP

MINPERAVAL

TOP

FacilityUDEValues

TOP

FACILITY

TOP

UDEID

Attribute DescriptionName MANDATEDatatype StringDescriptionAttributes Attribute Description


maxLength 50

Attribute DescriptionName MINPERAVALDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName FacilityUDEValuesDatatypeDescriptionAttributes Attribute Description


Attribute DescriptionName FACILITYDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName UDEIDDatatype StringDescription

46

TOP

UDEVALUE

TOP

RATECODE

TOP

CODEUSAGE

TOP

UDFDETAILS

TOP



Attribute DescriptionName UDEVALUEDatatype NumberDescriptionAttributes Attribute Description

minOccurs 0

Attribute DescriptionName RATECODEDatatype StringDescriptionAttributes Attribute Description


maxLength 10

Attribute DescriptionName CODEUSAGEDatatype StringDescriptionAttributes Attribute Description


maxLength 1

Attribute DescriptionName UDFDETAILSDatatypeDescriptionAttributes Attribute Description


47

FUNCTIONID

TOP

FIELD_NAME

TOP

DATATYPE

TOP

FIELD_VALUE

TOP





Attribute DescriptionName FIELD_NAMEDatatype StringDescriptionRestrictions Restrictions Description

maxLength 105minLength 1

Attribute DescriptionName DATATYPEDatatype StringDescriptionAttributes Attribute Description


maxLength 15

Attribute DescriptionName FIELD_VALUEDatatype StringDescriptionAttributes Attribute Description



48

VAL_TYPE

TOP

Attribute DescriptionName VAL_TYPEDatatype StringDescriptionAttributes Attribute Description



49

2.1.2.GE-MultiFacilityAuthorize-Res-Full-MSG.xsd

FCUBS_HEADER SOURCE UBSCOMP MSGID CORRELID USERID BRANCH MODULEID SERVICE OPERATION SOURCE_OPERATION SOURCE_USERID DESTINATION MULTITRIPID FUNCTIONID ACTION MSGSTAT ADDL PARAM NAME VALUE FCUBS_BODY MultiFacility-Full Facility LINECODE LINESERIAL CCYREST LINECCY REVOLVINGLINE LINESTARTDATE LINEEXPIRYDATE LASTNEWUTILDATE AVAILABILITYFLAG INTERNALREMARKS LIMITAMOUNT COLLATERALCONTRIBUTION UNCOLLECTEDFUNDSLIMIT REPORTINGAMOUNT AVAILABLEAMOUNT DATEOFFIRSTOD DATEOFLASTOD NETTINGREQUIRED

50

UNADVISED TRANSFERAMOUNT DSPEFFLINEAMOUNT ID AMOUNTUTILISEDTODAY AMOUNTREINSTATEDTODAY UNCOLLECTEDAMOUNT EXCESSTENOR UTILISATION LIABBR COLLATERALPCT BRN LMTAMTBASIS FUNDED AVAILMENTDATE EXCEPTXNAMT USERDEFINESTATUS BLOCKAMOUNT TANKEDUTIL NETTINGAMOUNT EXCEPBREACH CATEGORY EXTERNALREFNO PROCESSNO USERREFNO CONVERSIONDATE TENORRESTTYPE CUSTOMERRESTTYPE PRODUCTRESTTYPE BRANCHRESTTYPE CCYRESTTYPE EXTSYSTEMRESTTYPE LIABID MAINLINEID DESCRIPTION SHADOWLIMIT APPROVEDAMT DAYLIGHTLIMIT USERDEFSTATCHANGEDDT EXPRESTTYPE DAYLIGHTODLIMIT COMMITMENTPRODUCT COMMITMENTSETTLBRN COMMITMENTSETTLACC

51

BULKPMTREQD MAKERID MAKERDTSTAMP CHECKERID CHECKERDTSTAMP MODNO AUTHSTAT RECSTAT ONCEAUTH FacilitySchedules FACILITYID LIMITDATE LIMITAMOUNT ID FacilityTenorRestriction FACILITYID TENOR TENORMNEMONIC LIMIT UTILISATION FROMPRV TONEXT LIABBRANH ID FacilityCustomerRestriction FACILITYID CUSTOMERNO ID FacilityBranchRestriction FACILITYID BRANCHCODE ID FacilityProductRestriction FACILITYID PRODUCTCODE ID FacilityCurrencyRestriction FACILITYID CCY ID FacilityValueDateDetails FACILITYID ID LIMITAMOUNT

52

VALUEDATE BOOKDATE MODNO FacilityCharge ID FACILITYID ADMINCHARGETYPE ADMINCHARGEPERCT ADMINCHARGEAMT UTLCHARGETYPE UTLCHARGEPERCT UTLCHARGEAMT UNUTLCHARGETYPE UNUTLCHARGEPERCT UNUTLCHARGEAMT MODNO FacilityCovenant ID FACILITYID COVENANTID MANDATORY PERIODCITY PERIOD STARTDATE GRACEDAYS REVISIONDATE NOTICEDAYS COVENANTREFNO REMARKS MODNO FacilityExposure ID FACILITYID EXPOSUREID MODNO FacilitySystemRestriction ID FACILITYID EXTSYSTEM MODNO FacilityPoolLink LIABID POOLID TYPE

53

FACILITYBRANCHCODE FACILITYID FACILITYCURRENCY FACILITYAMOUNT FACILITYAMOUNTPOOLCCY PERCENTAGEOFPOOL PERCENTAGEOFCONTRACT ID MODNO FacilityExposureRestriction FACILITY EXPOSURE FacilityMandate MANDATETYPE MANDATE MINPERAVAL FacilityUDEValues FACILITY UDEID UDEVALUE RATECODE CODEUSAGE UDFDETAILS FUNCTIONID FIELD_NAME DATATYPE FIELD_VALUE VAL_TYPE FCUBS_ERROR_RESP ERROR ECODE EDESC FCUBS_WARNING_RESP WARNING WCODE WDESCFCUBS_HEADER

TOP

SOURCE

Attribute DescriptionName FCUBS_HEADERDatatypeDescription

54

TOP

UBSCOMP

TOP

MSGID

TOP

CORRELID

Attribute DescriptionName SOURCEDatatype StringDescription This is the code for the system which has sourced this message. For request

messages, this field has to contain the source code for the partner system asmaintained within FLEXCUBE UBS. In case of response messages this fieldwill contain "FLEXCUBE".


Attribute DescriptionName UBSCOMPDatatype StringDescription This is the component of FLEXCUBE for which this message is meant.

Gateway supports both FLEXCUBE UBS and FLEXCUBE Investor Services.If the message is for FLEXCUBE UBS then this field should contain "FCUBS"and "FCIS" if meant for FLEXCUBE Investor Services. This field is case-sensitive.

Restrictions Restrictions Descriptionenumeration FCUBS,FCIS

Attribute DescriptionName MSGIDDatatype StringDescription This is the "unique" message ID for this message. In inbound messages, if

this field is present then Gateway would perform technical duplicaterecognition using this field. For all messages going out from Gateway,Gateway will populate a unique message ID in this field.



Attribute DescriptionName CORRELIDDatatype StringDescription This is the correlation ID for the message. Gateway supports 2 correlation

patterns, namely "Message ID to Correlation ID" (M2C) and "Correlation ID toCorrelation ID" (C2C). While using asynchronous means of communication(like a JMS queue), the partner system can correlate the response receivedfrom Gateway to the request message sent by it using this field. If thecorrelation pattern is M2C then this field will contain the MSGID of the requestmessage. If the correlation pattern is C2C then this field will contain theCORRELID of the request message.


55

TOP

USERID

TOP

BRANCH

TOP

MODULEID

TOP

SERVICE


Attribute DescriptionName USERIDDatatype StringDescription This is the user id which will be used within FLEXCUBE to record the

transaction. This needs to be a valid user id as maintained withinFLEXCUBE.


Attribute DescriptionName BRANCHDatatype StringDescription This is the Branch of FLEXCUBE where the transaction would be recorded.

This needs to be a valid Branch code as maintained in FLEXCUBE.Restrictions Restrictions Description

length 3pattern [a-zA-Z_0-9]{3}

Attribute DescriptionName MODULEIDDatatype StringDescription This field is applicable only if messages are being sent to FCIS using

Gateway. This is the module id of FCIS where the transaction will berecorded.


Attribute DescriptionName SERVICEDatatype StringDescription This field should contain the code of the Service of FLEXCUBE which is

being requested. This field is case-sensitive.Attributes Attribute Description



56

TOP

OPERATION

TOP

SOURCE_OPERATION

TOP

SOURCE_USERID

TOP

DESTINATION

Attribute DescriptionName OPERATIONDatatype StringDescription This is the operation of the service which is being invoked. This field is case-

sensitive.Attributes Attribute Description



Attribute DescriptionName SOURCE_OPERATIONDatatype StringDescription This is the code for the operation being invoked in the Source system. The

code of Source Operation being sent needs to be maintained as a validSource Operation for the Source within FLEXCUBE.



Attribute DescriptionName SOURCE_USERIDDatatype StringDescription This is the user id in the Source system who is performing the action.Attributes Attribute Description

minOccurs 0nillable true

Attribute DescriptionName DESTINATIONDatatype StringDescription This the system for which this message is destined. In case of request

messages to FLEXCUBE, it should be "FLEXCUBE". In case of response, theSOURCE from the request message is reproduced here.



57

TOP

MULTITRIPID

TOP

FUNCTIONID

TOP

ACTION

TOP

MSGSTAT

Attribute DescriptionName MULTITRIPIDDatatype StringDescription In response messages, this is the ID sent by FLEXCUBE in case any

overrides are encountered. In request messages, the source system isexpected to reproduce the MULTITRIPID from the earlier received response ifthe source system accepts the overrides.






Restrictions Restric

gateway elmultifacilityservice

Documents

integration needs

flexcube ubsthe

gateway asfollows

external system

different infrastructure

detailed xsd documentation

operations available

disparate platforms