1.53 Address Details Upload

This topic provides detailed information on the Address Details Upload.

Table 1-178 Address Details Upload

Field Name	Description	Datatype	Length
SEQUENCENUMBER	Sequencenumber	NUMBER	10
PROCESSID	Processid	VARCHAR2	50
BULKCLIENTCODE	Bulkclientcode	VARCHAR2	12
UPLOADMODE	Uploadmode	VARCHAR2	1
IMPORTFILENAME	Importfilename	VARCHAR2	255
CONTACTREFNO	Contactrefno	VARCHAR2	16
USERREFERENCENUMBER	Userreferencenumber	VARCHAR2	16
ADDRESSLINE1	Addressline1	VARCHAR2	100
ADDRESSLINE2	Addressline2	VARCHAR2	100
ADDRESSLINE3	Addressline3	VARCHAR2	100
POSTBOXNO	Postboxno	VARCHAR2	16
CITY	City	VARCHAR2	80
STATE	State	VARCHAR2	80
COUNTRY	Country	VARCHAR2	3
ZIPCODE	Zipcode	VARCHAR2	10
BICCODE	Biccode	VARCHAR2	16
WEBSITE	Website	VARCHAR2	100
EMAILADDRESS	Emailaddress	VARCHAR2	100
EFFECTIVEFROMDATE	Effectivefromdate	DATE	7
EFFECTIVETODATE	Effectivetodate	DATE	7
PRIMARYCONTACTPERSON	Primarycontactperson	VARCHAR2	100
PRIMARYINTERNDIALCODE1	Primaryinterndialcode1	VARCHAR2	10
PRIMARYINTERNDIALCODE2	Primaryinterndialcode2	VARCHAR2	10
PRIMARYINTERNDIALCODE3	Primaryinterndialcode3	VARCHAR2	10
PRIMARYINTERNDIALCODE4	Primaryinterndialcode4	VARCHAR2	10
PRIMARYPOSITION	Primaryposition	VARCHAR2	60
PRIMARYMOBILENUMBER1	Primarymobilenumber1	VARCHAR2	60
PRIMARYMOBILENUMBER2	Primarymobilenumber2	VARCHAR2	60
PRIMARYFIXEDLINE	Primaryfixedline	VARCHAR2	60
FAX	Fax	VARCHAR2	120
PRIMARYCONTACTINSTRN	Primarycontactinstrn	VARCHAR2	100
PRIMARYEXTN	Primaryextn	VARCHAR2	60
SECONDARYCONTACTPERSON	Secondarycontactperson	VARCHAR2	100
SECONDARYINTERNDIALCODE1	Secondaryinterndialcode1	VARCHAR2	10
SECONDARYINTERNDIALCODE2	Secondaryinterndialcode2	VARCHAR2	10
SECONDARYPOSITION	Secondaryposition	VARCHAR2	60
SECONDARYMOBILENUMBER	Secondarymobilenumber	VARCHAR2	60
SECONDARYFIXEDLINE	Secondaryfixedline	VARCHAR2	60
SECONDARYCONTACTINSTRN	Secondarycontactinstrn	VARCHAR2	105
SECONDARYEXTN	Secondaryextn	VARCHAR2	60
MODULEID	Moduleid	VARCHAR2	30
MAKER_ID	Maker_Id	VARCHAR2	320
MAKER_DT_STAMP	Maker_Dt_Stamp	DATE	7
CHECKER_ID	Checker_Id	VARCHAR2	320
CHECKER_DT_STAMP	Checker_Dt_Stamp	DATE	7
AUTH_STAT	Auth_Stat	VARCHAR2	1
ONCE_AUTH	Once_Auth	VARCHAR2	1
RECORD_STAT	Record_Stat	VARCHAR2	1
MOD_NO	Mod_No	NUMBER	22