1.7.3 Broker Contact Information Related Information
This topic provides information on broker contact information related information.
Serial Number: 2
Segment Identification Number: 01CON
Description: This segment is used for providing Broker Contact Information related Information.
Attributes: Optional
Table 1-55 Broker Contact Information Related Information
Field Name (as expected in the file) | Data type | Length | Attributes | Characteristics/rules | Values |
---|---|---|---|---|---|
SEGMENTID | VARCHAR2 | 20 | Mandatory | - | Segment ID. Value for Segment ID is 01CON |
SEQUENCENUMBER | NUMBER | 10 | Mandatory | - | Sequence Number |
PROCESSID | VARCHAR2 | 50 | Mandatory | - | Process ID |
ADDRESSTYPE | VARCHAR2 | 2 | Mandatory | - | Represents the Addresstype |
ADDRESSLINE1 | VARCHAR2 | 105 | Mandatory | - | Represents the Addressline1 |
ADDRESSLINE2 | VARCHAR2 | 105 | Optional | - | Represents the Addressline2 |
ADDRESSLINE3 | VARCHAR2 | 105 | Optional | - | Represents the Addressline3 |
ADDRESSLINE4 | VARCHAR2 | 80 | Optional | - | Represents the Addressline4 |
ZIPCODE | VARCHAR2 | 10 | Mandatory | - | Represents the Zipcode |
COUNTRY | VARCHAR2 | 3 | Mandatory | - | Represents the Country |
USSTATE | NUMBER | 1 | Mandatory | - | Represents the US state |
TELEPHONE1 | VARCHAR2 | 60 | Mandatory | - | Represents the Telephone1 |
TELEPHONE2 | VARCHAR2 | 60 | Mandatory | - | Represents the Telephone2 |
CELLPHONENUMBER | VARCHAR2 | 105 | Mandatory | - | Represents the Cellphone number |
FAX | VARCHAR2 | 120 | Mandatory | - | Represents the Fax Number |
VARCHAR2 | 255 | Mandatory | - | Represents the Email ID | |
CONTACTPERSON | VARCHAR2 | 160 | Mandatory | - | Represents the Contact person |
EFFECTIVEFROMDATE | DATE | 10 | Mandatory | - | Represents the Effective from date |
EFFECTIVETODATE | DATE | 10 | Mandatory | - | Represents the Effective to date |
BICCODE | VARCHAR2 | 12 | Mandatory | - | Represents the Bic code |
INTDIALLINGCODEFAX | VARCHAR2 | 10 | Mandatory | - | Represents the default unit holder of the broker |
INTDIALLINGCODEPH2 | VARCHAR2 | 10 | Mandatory | - | International dialling code for telephone number 2 |
INTDIALLINGCODEPH1 | VARCHAR2 | 10 | Mandatory | - | International dialling code for telephone number 1 |
INTDIALLINGCODECELL | VARCHAR2 | 10 | Mandatory | - | International dialling code for cellphone number |
Parent topic: Broker File Format