1.47.2 Broker Export
This topic provides detailed information on the broker export related information.
Table 1-170 Broker Export
| Field name | Description | Datatype | Length | Table Name |
|---|---|---|---|---|
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHBROKERTBL |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PHBROKERTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHBROKERTBL |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PHBROKERTBL |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PHBROKERTBL |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PHBROKERTBL |
| BROKERCODE | Brokercode | VARCHAR2 | 12 | PHBROKERTBL |
| BROKERNAME | Brokername | VARCHAR2 | 105 | PHBROKERTBL |
| PARENTBROKERCODE | Parentbrokercode | VARCHAR2 | 12 | PHBROKERTBL |
| BROKERBASECCY | Brokerbaseccy | VARCHAR2 | 3 | PHBROKERTBL |
| AMCID | Amcid | VARCHAR2 | 12 | PHBROKERTBL |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PHBROKERTBL |
| DELETEDSTATUS | Deletedstatus | NUMBER | 1 | PHBROKERTBL |
| OVERRIDDENTAXPERCENTAGE | Overriddentaxpercentage | NUMBER | 15 | PHBROKERTBL |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PHBROKERTBL |
| MAKER_DT_STA MP | Maker_Dt_Stamp | DATE | 7 | PHBROKERTBL |
| LEVELNUMBER | Levelnumber | NUMBER | 3 | PHBROKERTBL |
| RULEEFFECTIVEDATE | Ruleeffectivedate | DATE | 7 | PHBROKERTBL |
| CHANGETYPE | Changetype | VARCHAR2 | 1 | PHBROKERTBL |
| VATREGISTERED | Vatregistered | NUMBER | 1 | PHBROKERTBL |
| VATREGISTRATIONNUMBER | Vatregistrationnumber | VARCHAR2 | 15 | PHBROKERTBL |
| COMMISSIONPERCENTAGE | Commissionpercentage | NUMBER | 5 | PHBROKERTBL |
| COMMISSIONPAYMENTFREQ | Commissionpaymentfreq | VARCHAR2 | 1 | PHBROKERTBL |
| UNITHOLDERID | Unitholderid | VARCHAR2 | 12 | PHBROKERTBL |
| LASTPAYMENTDATE | Lastpaymentdate | DATE | 7 | PHBROKERTBL |
| LASTPAYMENTNUMBER | Lastpaymentnumber | NUMBER | 5 | PHBROKERTBL |
| LASTPROCESSEDDATE | Lastprocesseddate | DATE | 7 | PHBROKERTBL |
| NEXTPAYMENTDATE | Nextpaymentdate | DATE | 7 | PHBROKERTBL |
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | PHBROKERTBL |
| CHECKER_DT_STA MP | Checker_Dt_Stamp | DATE | 7 | PHBROKERTBL |
| BROKERTYPE | Brokertype | VARCHAR2 | 6 | PHBROKERTBL |
| USEBRO KERTYPE PAYMENTDA TES | Usebrokertypepay mentdates | NUMBER | 1 | PHBROKERTBL |
| BROKERCONSULTANT | Brokerconsultant | VARCHAR2 | 40 | PHBROKERTBL |
| BROKERCATEGORY | Brokercategory | VARCHAR2 | 1 | PHBROKERTBL |
| HOLDBACKPAYMENT | Holdbackpayment | NUMBER | 1 | PHBROKERTBL |
| MOD_NO | Mod_No | NUMBER | 10 | PHBROKERTBL |
| HOLDPYMTFROMDATE | Holdpymtfromdate | DATE | 7 | PHBROKERTBL |
| LATESTRULE | Latestrule | NUMBER | 22 | PHBROKERTBL |
| BROKERSTATUS | Brokerstatus | VARCHAR2 | 1 | PHBROKERTBL |
| RECORD_ST AT | Record_Stat | CHAR | 1 | PHBROKERTBL |
| ONCE_AUTH | Once_Auth | CHAR | 1 | PHBROKERTBL |
| REPLICATEPARENTDET | Replicateparentdet | CHAR | 1 | PHBROKERTBL |
| VATREGISTRATIONDATE | Vatregistrationdate | DATE | 7 | PHBROKERTBL |
| TEMPLATEID | Templateid | VARCHAR2 | 6 | PHBROKERTBL |
| USINDICIAAVAILABLE | Usindiciaavailable | NUMBER | 1 | PHBROKERTBL |
| FATCASTATUS | Fatcastatus | VARCHAR2 | 25 | PHBROKERTBL |
| NATIONALITY | Nationality | VARCHAR2 | 3 | PHBROKERTBL |
| COUNTRYOFBIRTH | Countryofbirth | VARCHAR2 | 3 | PHBROKERTBL |
| COUNTRYOFDOMICILE | Countryofdomicile | VARCHAR2 | 3 | PHBROKERTBL |
| INCORPORATIONCOUNTRY | Incorporationcountry | VARCHAR2 | 3 | PHBROKERTBL |
| TAXID | Taxid | VARCHAR2 | 50 | PHBROKERTBL |
| EIN | Ein | VARCHAR2 | 50 | PHBROKERTBL |
| TAXCERTIFICATEEFFEDATE | Taxcertificateeffed ate | DATE | 7 | PHBROKERTBL |
| TAXCERTIFI CATEEXP DATE | Taxcertificateexp date | DATE | 7 | PHBROKERTBL |
| TAXCIRCLE | Taxcircle | VARCHAR2 | 15 | PHBROKERTBL |
| FATCACLASSIFICATION | Fatcaclassification | VARCHAR2 | 25 | PHBROKERTBL |
| GIIN | Giin | VARCHAR2 | 30 | PHBROKERTBL |
| GIINISSUEDATE | Giinissuedate | DATE | 7 | PHBROKERTBL |
| GIINEXPIRYDATE | Giinexpirydate | DATE | 7 | PHBROKERTBL |
| GIINVERIFIEDFLAG | Giinverifiedflag | NUMBER | 1 | PHBROKERTBL |
| FATCASPONSORTYPE | Fatcasponsortype | VARCHAR2 | 2 | PHBROKERTBL |
| SPONSORINGENTITYTYPE | Sponsoringentitytype | VARCHAR2 | 1 | PHBROKERTBL |
| SPONSORINGENTITYID | Sponsoringentityid | VARCHAR2 | 12 | PHBROKERTBL |
| VATEXPIRYDATE | Vatexpirydate | DATE | 7 | PHBROKERTBL |
| UNAUTHEXIST | Unauthexist | VARCHAR2 | 1 | PHBROKERTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHBROKER LEGACYTBL |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PHBROKER LEGACYTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHBROKER LEGACYTBL |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PHBROKER LEGACYTBL |
| BROKERCODE | Brokercode | VARCHAR2 | 12 | PHBROKER LEGACYTBL |
| RULEEFFECTIVEDATE | Ruleeffectivedate | DATE | 7 | PHBROKER LEGACYTBL |
| BROKERLEGACYCODE | Brokerlegacycode | VARCHAR2 | 12 | PHBROKER LEGACYTBL |
| MOD_NO | Mod_No | NUMBER | 10 | PHBROKER LEGACYTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHBROKER PREFER ENCETBL |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PHBROKER PREFER ENCETBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHBROKER PREFER ENCETBL |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PHBROKER PREFER ENCETBL |
| BROKERCODE | Brokercode | VARCHAR2 | 12 | PHBROKER PREFER ENCETBL |
| RULEEFFECTIVEDATE | Ruleeffectivedate | DATE | 7 | PHBROKER PREFER ENCETBL |
| FEEDTYPE | Feedtype | VARCHAR2 | 20 | PHBROKER PREFER ENCETBL |
| FEEDSTRUCT | Feedstruct | VARCHAR2 | 4 | PHBROKER PREFER ENCETBL |
| FEEDSTARTDATE | Feedstartdate | DATE | 7 | PHBROKER PREFER ENCETBL |
| FEEDFREQUENCY | Feedfrequency | VARCHAR2 | 20 | PHBROKER PREFER ENCETBL |
| FEEDFORMAT | Feedformat | VARCHAR2 | 6 | PHBROKER PREFER ENCETBL |
| MOD_NO | Mod_No | NUMBER | 10 | PHBROKER PREFER ENCETBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHBROKERBANKDETAILSTBL |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PHBROKERBANKDETAILSTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHBROKERBANKDETAILSTBL |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PHBROKERBANKDETAILSTBL |
| BROKERCODE | Brokercode | VARCHAR2 | 12 | PHBROKERBANKDETAILSTBL |
| RULEEFFECTIVEDATE | Ruleeffectivedate | DATE | 7 | PHBROKERBANKDETAILSTBL |
| REFERENCENUMBER | Referencenumber | VARCHAR2 | 12 | PHBROKERBANKDETAILSTBL |
| BANKCODE | Bankcode | VARCHAR2 | 12 | PHBROKERBANKDETAILSTBL |
| BRANCHCODE | Branchcode | VARCHAR2 | 12 | PHBROKERBANKDETAILSTBL |
| ACCOUNTTYPE | Accounttype | VARCHAR2 | 1 | PHBROKERBANKDETAILSTBL |
| ACCOUNTNUMBER | Accountnumber | VARCHAR2 | 20 | PHBROKERBANKDETAILSTBL |
| ACCOUNTNAME | Accountname | VARCHAR2 | 100 | PHBROKERBANKDETAILSTBL |
| ACCOUNTCURRENCY | Accountcurrency | VARCHAR2 | 3 | PHBROKERBANKDETAILSTBL |
| DEFAULTDETAILS | Defaultdetails | NUMBER | 1 | PHBROKERBANKDETAILSTBL |
| DIRECTDEBITAPPLICABLE | Directdebitapplicable | NUMBER | 1 | PHBROKERBANKDETAILSTBL |
| SWIFTFORMAT | Swiftformat | VARCHAR2 | 6 | PHBROKERBANKDETAILSTBL |
| BANKCHARGED | Bankcharged | VARCHAR2 | 12 | PHBROKERBANKDETAILSTBL |
| BENEFICIARY | Beneficiary | VARCHAR2 | 35 | PHBROKERBANKDETAILSTBL |
| BENEFICIARYADD1 | Beneficiaryadd1 | VARCHAR2 | 105 | PHBROKERBANKDETAILSTBL |
| BENEFICIARYADD2 | Beneficiaryadd2 | VARCHAR2 | 105 | PHBROKERBANKDETAILSTBL |
| BENEFICIARYADD3 | Beneficiaryadd3 | VARCHAR2 | 105 | PHBROKERBANKDETAILSTBL |
| BENEFICIARYBICCODE | Beneficiarybiccode | VARCHAR2 | 24 | PHBROKERBANKDETAILSTBL |
| BENEFICIARYACCTNO | Beneficiaryacctno | VARCHAR2 | 34 | PHBROKERBANKDETAILSTBL |
| BENEFICIARYCODE | Beneficiarycode | VARCHAR2 | 24 | PHBROKERBANKDETAILSTBL |
| BENEFICIARYINFO | Beneficiaryinfo | VARCHAR2 | 100 | PHBROKERBANKDETAILSTBL |
| INTERMEDIARY | Intermediary | VARCHAR2 | 35 | PHBROKERBANKDETAILSTBL |
| INTERMEDIARYADD1 | Intermediaryadd1 | VARCHAR2 | 105 | PHBROKERBANKDETAILSTBL |
| INTERMEDIARYADD2 | Intermediaryadd2 | VARCHAR2 | 105 | PHBROKERBANKDETAILSTBL |
| INTERMEDIARYADD3 | Intermediaryadd3 | VARCHAR2 | 105 | PHBROKERBANKDETAILSTBL |
| INTERMEDIARYBICCODE | Intermediarybiccode | VARCHAR2 | 24 | PHBROKERBANKDETAILSTBL |
| INTERMEDIARYACCTNO | Intermediaryacctno | VARCHAR2 | 34 | PHBROKERBANKDETAILSTBL |
| INTERMEDIARYCODE | Intermediarycode | VARCHAR2 | 24 | PHBROKERBANKDETAILSTBL |
| INTERMEDIARYINFO | Intermediaryinfo | VARCHAR2 | 100 | PHBROKERBANKDETAILSTBL |
| FURTHERCREDITNAME | Furthercreditname | VARCHAR2 | 35 | PHBROKERBANKDETAILSTBL |
| FURTHERCREDITACCTNO | Furthercreditacctno | VARCHAR2 | 35 | PHBROKERBANKDETAILSTBL |
| REFERENCE1 | Reference1 | VARCHAR2 | 35 | PHBROKERBANKDETAILSTBL |
| REFERENCE2 | Reference2 | VARCHAR2 | 35 | PHBROKERBANKDETAILSTBL |
| IBAN | Iban | VARCHAR2 | 40 | PHBROKERBANKDETAILSTBL |
| BENEFICIARYIBAN | Beneficiaryiban | VARCHAR2 | 40 | PHBROKERBANKDETAILSTBL |
| INTERMEDIARYIBAN | Intermediaryiban | VARCHAR2 | 40 | PHBROKERBANKDETAILSTBL |
| MOD_NO | Mod_No | NUMBER | 10 | PHBROKERBANKDETAILSTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHBROKERCONTACTINFOTBL |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PHBROKERCONTACTINFOTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHBROKERCONTACTINFOTBL |
| USERREFERENCENUMBER | Userreferencenum ber | VARCHAR2 | 16 | PHBROKERCONTACTINFOTBL |
| ENTITYID | Entityid | VARCHAR2 | 12 | PHBROKERCONTACTINFOTBL |
| ENTITYTYPE | Entitytype | VARCHAR2 | 2 | PHBROKERCONTACTINFOTBL |
| ADDRESSTY PE | Addresstype | VARCHAR2 | 2 | PHBROKERCONTACTINFOTBL |
| ADDRESSLINE1 | Addressline1 | VARCHAR2 | 80 | PHBROKERCONTACTINFOTBL |
| ADDRESSLINE2 | Addressline2 | VARCHAR2 | 80 | PHBROKERCONTACTINFOTBL |
| ADDRESSLINE3 | Addressline3 | VARCHAR2 | 80 | PHBROKERCONTACTINFOTBL |
| ADDRESSLINE4 | Addressline4 | VARCHAR2 | 80 | PHBROKERCONTACTINFOTBL |
| ZIPCODE | Zipcode | VARCHAR2 | 10 | PHBROKERCONTACTINFOTBL |
| COUNTRY | Country | VARCHAR2 | 3 | PHBROKERCONTACTINFOTBL |
| USSTATE | Usstate | NUMBER | 1 | PHBROKERCONTACTINFOTBL |
| TELEPHONE1 | Telephone1 | VARCHAR2 | 60 | PHBROKERCONTACTINFOTBL |
| TELEPHONE2 | Telephone2 | VARCHAR2 | 60 | PHBROKERCONTACTINFOTBL |
| CELLPHONENUMBER | Cellphonenumber | VARCHAR2 | 60 | PHBROKERCONTACTINFOTBL |
| FAX | Fax | VARCHAR2 | 120 | PHBROKERCONTACTINFOTBL |
| VARCHAR2 | 255 | PHBROKERCONTACTINFOTBL | ||
| CONTACTPERSON | Contactperson | VARCHAR2 | 160 | PHBROKERCONTACTINFOTBL |
| EFFECTIVEFROMDATE | Effectivefromdate | DATE | 7 | PHBROKERCONTACTINFOTBL |
| EFFECTIVETODATE | Effectivetodate | DATE | 7 | PHBROKERCONTACTINFOTBL |
| BICCODE | Biccode | VARCHAR2 | 16 | PHBROKERCONTACTINFOTBL |
| RULEEFFECTIVEDATE | Ruleeffectivedate | DATE | 7 | PHBROKERCONTACTINFOTBL |
| INTDIALLINGCODEFAX | Intdiallingcodefax | VARCHAR2 | 10 | PHBROKERCONTACTINFOTBL |
| INTDIALLINGCODEPH2 | Intdiallingcodeph2 | VARCHAR2 | 10 | PHBROKERCONTACTINFOTBL |
| INTDIALLINGCODEPH1 | Intdiallingcodeph1 | VARCHAR2 | 10 | PHBROKERCONTACTINFOTBL |
| INTDIALLINGCODECELL | Intdiallingcodecell | VARCHAR2 | 10 | PHBROKERCONTACTINFOTBL |
| MOD_NO | Mod_No | NUMBER | 10 | PHBROKERCONTACTINFOTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHBROKERRELATEDPARTIESTBL |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PHBROKERRELATEDPARTIESTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHBROKERRELATEDPARTIESTBL |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PHBROKERRELATEDPARTIESTBL |
| BROKERCODE | Brokercode | VARCHAR2 | 12 | PHBROKERRELATEDPARTIESTBL |
| RULEEFFECTIVEDATE | Ruleeffectivedate | DATE | 7 | PHBROKERRELATEDPARTIESTBL |
| RPENTITYID | Rpentityid | VARCHAR2 | 12 | PHBROKERRELATEDPARTIESTBL |
| RPENTITYTYPE | Rpentitytype | VARCHAR2 | 2 | PHBROKERRELATEDPARTIESTBL |
| REPORTINGLEVEL | Reportinglevel | VARCHAR2 | 1 | PHBROKERRELATEDPARTIESTBL |
| PREFMAILMODE | Prefmailmode | VARCHAR2 | 1 | PHBROKERRELATEDPARTIESTBL |
| REMARKS | Remarks | VARCHAR2 | 255 | PHBROKERRELATEDPARTIESTBL |
| APPLYLEVEL | Applylevel | VARCHAR2 | 3 | PHBROKERRELATEDPARTIESTBL |
| APPLYTO | Applyto | VARCHAR2 | 12 | PHBROKERRELATEDPARTIESTBL |
| MOD_NO | Mod_No | NUMBER | 10 | PHBROKERRELATEDPARTIESTBL |
Parent topic: Broker Export