1.20.1 Segment Identification Number

This topic provides detailed information on segment identification number of customer address upload format.

Table 1-97 Segment Identification Number

Field Name (as expected in the file)	Data type	Length	Attributes	Characteristics/rules	Values
PROCESSID	VARCHAR2	50	Optional	-	Sequence Number
SEQUENCENUMBER	NUMBER	10	Mandatory	-	Process ID
BULKCLIENTCODE	VARCHAR2	12	Optional	-	Bulk Client Code
IMPORTFILENAME	VARCHAR2	255	Optional	-	Import File Name
UPLOADMODE	VARCHAR2	1	Mandatory	-	Mode of operation which has to be performed on the record
CIFNUMBER	VARCHAR2	20	Mandatory	-	CIF Number
MEDIA	VARCHAR2	15	Mandatory	-	Media
LOCATION	VARCHAR2	15	Mandatory	-	Location
ADDRESS1	VARCHAR2	105	Mandatory	-	Address 1
ADDRESS2	VARCHAR2	105	Optional	-	Address 2
ADDRESS3	VARCHAR2	105	Optional	-	Address 3
ADDRESS4	VARCHAR2	105	Optional	-	Address 4
ZIPCODE	VARCHAR2	10	Optional	-	ZIP Code
COUNTRY	VARCHAR2	3	Optional	-	Country
CONTACTPERSON	VARCHAR2	160	Optional	-	Contact Person
TELEPHONENUMBER1	VARCHAR2	60	Optional	-	Telephone Number 1
TELEPHONENUMBER2	VARCHAR2	60	Optional	-	Telephone Number 2
CELLPHONENUMBER	VARCHAR2	60	Optional	-	Cellphone Number
ENABLEDFLAG	VARCHAR2	1	Optional	-	Enabled Flag
USERID	VARCHAR2	320	Mandatory	-	Indicates the user ID who has entered the latest record
AUTH_STAT	VARCHAR2	1	Optional	-	Indicates the time when the record is created
MODULEID	VARCHAR2	30	Mandatory	-	Indicates the module ID
AGENTCODE	VARCHAR2	12	Mandatory	-	Indicates the agent code
BRANCHCODE	VARCHAR2	12	Mandatory	-	Indicates the branch code