1.28.1 Segment Identification Number

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

Table 1-112 Segment Identification Number

Field Name (as expected in the file) Data type Length Mandatory /Optional Characteristics/ rules Values
SEQUENCENUMBER NUMBER 22 Mandatory - Sequence Number
PROCESSID VARCHAR2 50 Mandatory - Process ID
BULKCLIENTCODE VARCHAR2 12 Mandatory - Bulk Client Code
IMPORTFILENAME VARCHAR2 255 Optional - Import File Name
UPLOADMODE VARCHAR2 1 Mandatory - Upload Mode
FSAREGISTRATIONNUMBER VARCHAR2 8 Mandatory - FSA Registration Number
FSAREGISTRATIONSTATUS VARCHAR2 1 Mandatory - FSA Registration Status
HOLDCLIENTMONEY NUMBER 1 Mandatory - Hold Client Money
ENTITYID VARCHAR2 12 Mandatory - Entity ID
ENTITYTYPE VARCHAR2 1 Mandatory - Entity Type
USERID VARCHAR2 15 Mandatory - Represents the user ID who has entered the latest record
MODULEID VARCHAR2 12 Mandatory - Module ID