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