1.27.1 Segment Identification Number

This topic provides detailed information on Bulk GL Setup upload format of segment identification number.

Table 1-111 Segment Identification Number

Field Name (as expected in the file)	Data type	Length	Mandatory /Optional	Characteristics/ rules	Values
PROCESSID	VARCHAR2	200	Mandatory	-	Process ID
BULKCLIENTCODE	VARCHAR2	48	Mandatory	-	Bulk Client Code
IMPORTFILENAME	VARCHAR2	1020	Mandatory	-	Import File Name
FUNDID	VARCHAR2	24	Optional	-	Valid Fund ID in FCIS
GLTEMPLATEID	VARCHAR2	40	Mandatory	-	Valid GL Template ID
ACCOUNTTYPE	VARCHAR2	8	Mandatory	-	Valid Account Type
BUSINESSEVENT	VARCHAR2	8	Mandatory	-	Valid Business event
TRIGGEREVENT	VARCHAR2	60	Mandatory	-	Valid Trigger Event
THEROITICALFLAG	VARCHAR2	4	Mandatory	-	Theoretical Flag, Yes/ No
SETUPENABLED	VARCHAR2	4	Mandatory	-	GL setup enable disable flag, Yes/No
COMPONENTID	VARCHAR2	80	Mandatory	-	GL Component ID
COMPONENTDESCRIPTION	VARCHAR2	1020	Mandatory	-	GL Component Description
DEBITCREDITFLAG	VARCHAR2	8	Mandatory	-	Debit or Credit Flag
GLSETUPFORPRIMARY	VARCHAR2	4	Mandatory	-	GL Setup for Primary
PRIMARYENTITYTYPE	VARCHAR2	4	Mandatory	-	Primary Entity Type
ACCOUNTNUMBER	VARCHAR2	20	Mandatory	-	GL Account number for Primary
ACCOUNTCURRENCY	VARCHAR2	12	Mandatory	-	GL Account Currency for Primary
TRANSACTIONCURRENCY	VARCHAR2	12	Mandatory	-	Transaction Currency
BANKBRANCH	VARCHAR2	48	Optional	-	Bank Branch
DIRECTDEBITAPPLICABLE	VARCHAR2	4	Mandatory	-	Direct Debit applicable Yes/No
GLSETUPFORCONTRA	VARCHAR2	4	Mandatory	-	GL Setup for Contra
CONTRAPRIMARYENTITYTYPE	VARCHAR2	4	Mandatory	-	Contra Entity Type
CONTRAACCOUNTNUMBER	VARCHAR2	64	Mandatory	-	Contra GL Account Number
CONTRAACCOUNTCURRENCY	VARCHAR2	12	Mandatory	-	Contra GL Account Currency
CONTRATRANSACTIONCURRENCY	VARCHAR2	12	Mandatory	-	Contra Transaction Currency
CONTRABANKBRANCH	VARCHAR2	48	Optional	-	Contra Brank Branch
CONTRADIRECTDEBITAPPLICABLE	VARCHAR2	4	Mandatory	-	Contra Direct Debit Applicable Yes/No
RESTRICTEDREFTYPES	VARCHAR2	1020	Optional	-	Restricted Ref types for the GL setup(Delimited with ':')
GLCURRENCY	VARCHAR2	12	Mandatory	-	GL Currency
GLREFERENCENUMBER	VARCHAR2	40	Mandatory	-	GL Reference Number
PRODUCTID	VARCHAR2	40	Optional	-	Valid FCIS Product ID
PRODUCTORFUNDLEVEL	VARCHAR2	4	Mandatory	-	Indicates the GL setup is at fund level or product level
MODEODUPLOAD	VARCHAR2	4	Mandatory	-	Upload Mode
AUTH_STAT	VARCHAR2	4	Optional	-	Auth Status
RESTRICTEDSUBTYPES	VARCHAR2	1020	Optional	-	Restricted sub types for the GL setup(Delimited with ':')