1.65.2 Pension Order Export Upload
This topic provides detailed information on the pension order export upload.
Table 1-200 Pension Order Export Upload
| Field name | Description | Datatype | Length | Table Name |
|---|---|---|---|---|
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ORDERTAUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATB_ORDERTAUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ORDERTAUPLOAD |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATB_ORDERTAUPLOAD |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATB_ORDERTAUPLOAD |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATB_ORDERTAUPLOAD |
| ORDERNUMBER | Ordernumber | VARCHAR2 | 16 | PATB_ORDERTAUPLOAD |
| REFERENCENUMBER | Referencenumber | VARCHAR2 | 16 | PATB_ORDERTAUPLOAD |
| PARTYID | Partyid | VARCHAR2 | 12 | PATB_ORDERTAUPLOAD |
| PORTFOLIOID | Portfolioid | VARCHAR2 | 16 | PATB_ORDERTAUPLOAD |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATB_ORDERTAUPLOAD |
| ORDERCURRENCY | Ordercurrency | VARCHAR2 | 3 | PATB_ORDERTAUPLOAD |
| ORDERMODE | Ordermode | VARCHAR2 | 1 | PATB_ORDERTAUPLOAD |
| ORDERVALUE | Ordervalue | NUMBER | 30 | PATB_ORDERTAUPLOAD |
| INSTRUCTIONDATE | Instructiondate | DATE | 7 | PATB_ORDERTAUPLOAD |
| ORDERTYPE | Ordertype | VARCHAR2 | 3 | PATB_ORDERTAUPLOAD |
| ORDERSUBTYPE | Ordersubtype | VARCHAR2 | 3 | PATB_ORDERTAUPLOAD |
| PAYMENTMODE | Paymentmode | VARCHAR2 | 2 | PATB_ORDERTAUPLOAD |
| GROSSORNET | Grossornet | VARCHAR2 | 1 | PATB_ORDERTAUPLOAD |
| MODULEID | Moduleid | VARCHAR2 | 30 | PATB_ORDERTAUPLOAD |
| ORDERSTATUS | Orderstatus | NUMBER | 2 | PATB_ORDERTAUPLOAD |
| ORIGINALORDNUMBER | Originalordnumber | VARCHAR2 | 16 | PATB_ORDERTAUPLOAD |
| ORIGINALREFNUMBER | Originalrefnumber | VARCHAR2 | 16 | PATB_ORDERTAUPLOAD |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PATB_ORDERTAUPLOAD |
| ONCE_AUTH | Once_Auth | VARCHAR2 | 1 | PATB_ORDERTAUPLOAD |
| RECORD_STAT | Record_Stat | VARCHAR2 | 1 | PATB_ORDERTAUPLOAD |
| MOD_NO | Mod_No | NUMBER | 22 | PATB_ORDERTAUPLOAD |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PATB_ORDERTAUPLOAD |
| MAKER_DT_STAMP | Maker_Dt_Stamp | DATE | 7 | PATB_ORDERTAUPLOAD |
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | PATB_ORDERTAUPLOAD |
| CHECKER_DT_STAMP | Checker_Dt_Stamp | DATE | 7 | PATB_ORDERTAUPLOAD |
| REMARKS | Remarks | VARCHAR2 | 255 | PATB_ORDERTAUPLOAD |
| SWIORDERSTATUS | Swiorderstatus | NUMBER | 2 | PATB_ORDERTAUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ORDERIN STRTAUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATB_ORDERIN STRTAUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ORDERIN STRTAUPLOAD |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATB_ORDERIN STRTAUPLOAD |
| ORDERNUMBER | Ordernumber | VARCHAR2 | 16 | PATB_ORDERIN STRTAUPLOAD |
| INSTRUMENTID | Instrumentid | VARCHAR2 | 16 | PATB_ORDERIN STRTAUPLOAD |
| SPLITPERCENTAGE | Splitpercentage | NUMBER | 5 | PATB_ORDERIN STRTAUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ORDERINSTASSETTAUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATB_ORDERINSTASSETTAUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ORDERINSTASSETTAUPLOAD |
| USERREFERENCENUMBER | Userreference number | VARCHAR2 | 16 | PATB_ORDERINSTASSETTAUPLOAD |
| ORDERNUMBER | Ordernumber | VARCHAR2 | 16 | PATB_ORDERINSTASSETTAUPLOAD |
| INSTRUMENTID | Instrumentid | VARCHAR2 | 16 | PATB_ORDERINSTASSETTAUPLOAD |
| ASSETID | Assetid | VARCHAR2 | 16 | PATB_ORDERINSTASSETTAUPLOAD |
| RATIO | Ratio | NUMBER | 5 | PATB_ORDERINSTASSETTAUPLOAD |
| OVERRIDE | Override | VARCHAR2 | 1 | PATB_ORDERINSTASSETTAUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ORDERINTERMEDIARYTAUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATB_ORDERINTERMEDIARYTAUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ORDERINTERMEDIARYTAUPLOAD |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATB_ORDERINTERMEDIARYTAUPLOAD |
| ORDERNUMBER | Ordernumber | VARCHAR2 | 16 | PATB_ORDERINTERMEDIARYTAUPLOAD |
| INTERMEDIARYID | Intermediaryid | VARCHAR2 | 12 | PATB_ORDERINTERMEDIARYTAUPLOAD |
| SPLITPERCENTAGE | Splitpercentage | NUMBER | 5 | PATB_ORDERINTERMEDIARYTAUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ORDERSETTLEMENTTAUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATB_ORDERSETTLEMENTTAUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ORDERSETTLEMENTTAUPLOAD |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATB_ORDERSETTLEMENTTAUPLOAD |
| ORDERNUMBER | Ordernumber | VARCHAR2 | 16 | PATB_ORDERSETTLEMENTTAUPLOAD |
| PAYMENTREFNUMBER | Paymentrefnumber | VARCHAR2 | 16 | PATB_ORDERSETTLEMENTTAUPLOAD |
| BANKREFERENCENO | Bankreferenceno | VARCHAR2 | 16 | PATB_ORDERSETTLEMENTTAUPLOAD |
| CHEQUEDATE | Chequedate | DATE | 7 | PATB_ORDERSETTLEMENTTAUPLOAD |
| CHEQUENUMBER | Chequenumber | VARCHAR2 | 20 | PATB_ORDERSETTLEMENTTAUPLOAD |
| PAYMENTAMOUNT | Paymentamount | NUMBER | 30 | PATB_ORDERSETTLEMENTTAUPLOAD |
| PAIDDATE | Paiddate | DATE | 7 | PATB_ORDERSETTLEMENTTAUPLOAD |
| SETTLED | Settled | VARCHAR2 | 1 | PATB_ORDERSETTLEMENTTAUPLOAD |
| ACCOUNTHOLDERNAME | Accountholdername | VARCHAR2 | 100 | PATB_ORDERSETTLEMENTTAUPLOAD |
| ACCOUNTTYPE | Accounttype | VARCHAR2 | 1 | PATB_ORDERSETTLEMENTTAUPLOAD |
| ACCOUNTCURRENCY | Accountcur rency | VARCHAR2 | 3 | PATB_ORDERSETTLEMENTTAUPLOAD |
| BANKCODE | Bankcode | VARCHAR2 | 12 | PATB_ORDERSETTLEMENTTAUPLOAD |
| BRANCHCODE | Branchcode | VARCHAR2 | 12 | PATB_ORDERSETTLEMENTTAUPLOAD |
| ACCOUNTNUMBER | Accountnumber | VARCHAR2 | 20 | PATB_ORDERSETTLEMENTTAUPLOAD |
| IBAN | Iban | VARCHAR2 | 40 | PATB_ORDERSETTLEMENTTAUPLOAD |
| AUTOSETTLEMENT | AUTOSETTLEMENT | NUMBER | 1 | PATB_ORDERSETTLEMENTTAUPLOAD |
| SETTLEMENTDUEDATE | SETTLEMENTDUEDATE | DATE | 7 | PATB_ORDERSETTLEMENTTAUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_PARTYMASTERTAUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATM_PARTYMASTERTAUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_PARTYMASTERTAUPLOAD |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATM_PARTYMASTERTAUPLOAD |
| PARTYID | Partyid | VARCHAR2 | 12 | PATM_PARTYMASTERTAUPLOAD |
| PARTYTYPE | Partytype | VARCHAR2 | 3 | PATM_PARTYMASTERTAUPLOAD |
| TITLE | Title | VARCHAR2 | 15 | PATM_PARTYMASTERTAUPLOAD |
| FIRSTNAME | Firstname | VARCHAR2 | 100 | PATM_PARTYMASTERTAUPLOAD |
| MIDDLENAME | Middlename | VARCHAR2 | 100 | PATM_PARTYMASTERTAUPLOAD |
| LASTNAME | Lastname | VARCHAR2 | 100 | PATM_PARTYMASTERTAUPLOAD |
| REGISTEREDNAME | Registeredname | VARCHAR2 | 100 | PATM_PARTYMASTERTAUPLOAD |
| DATEOFBIRTH | Dateofbirth | DATE | 7 | PATM_PARTYMASTERTAUPLOAD |
| DATEOFINCORPORATION | Dateofincorporation | DATE | 7 | PATM_PARTYMASTERTAUPLOAD |
| MARITALSTATUS | Maritalstatus | VARCHAR2 | 1 | PATM_PARTYMASTERTAUPLOAD |
| OCCUPATION | Occupation | VARCHAR2 | 3 | PATM_PARTYMASTERTAUPLOAD |
| GENDER | Gender | VARCHAR2 | 1 | PATM_PARTYMASTERTAUPLOAD |
| PREFERREDCURRENCY | Preferredcurrency | VARCHAR2 | 3 | PATM_PARTYMASTERTAUPLOAD |
| MINOR | Minor | NUMBER | 1 | PATM_PARTYMASTERTAUPLOAD |
| NATIONALITY | Nationality | VARCHAR2 | 3 | PATM_PARTYMASTERTAUPLOAD |
| COUNTRYOFDOMICILE | Countryofdomicile | VARCHAR2 | 3 | PATM_PARTYMASTERTAUPLOAD |
| COUNTRYOFBIRTH | Countryofbirth | VARCHAR2 | 3 | PATM_PARTYMASTERTAUPLOAD |
| DUALNATIONALITY | Dualnationality | VARCHAR2 | 3 | PATM_PARTYMASTERTAUPLOAD |
| SUBSTANTIALSTAYINUS | Substantial stayinus | NUMBER | 1 | PATM_PARTYMASTERTAUPLOAD |
| HEALTHSTATUS | Healthstatus | VARCHAR2 | 1 | PATM_PARTYMASTERTAUPLOAD |
| PROTECTIONLEVEL | Protectionlevel | VARCHAR2 | 1 | PATM_PARTYMASTERTAUPLOAD |
| FIRSTAUTHORIZEDSIGNATORY | Firstauthorizedsignatory | VARCHAR2 | 100 | PATM_PARTYMASTERTAUPLOAD |
| SECONDAUTHORIZEDSIGNATORY | Secondauthorizedsignatory | VARCHAR2 | 100 | PATM_PARTYMASTERTAUPLOAD |
| THIRDAUTHORIZEDSIGNATORY | Thirdauthorizedsignatory | VARCHAR2 | 100 | PATM_PARTYMASTERTAUPLOAD |
| CORPORATIONTYPE | Corporationtype | VARCHAR2 | 3 | PATM_PARTYMASTERTAUPLOAD |
| MINNOOFCORPORATESIGNATORY | Minnoofcorporatesignatory | NUMBER | 22 | PATM_PARTYMASTERTAUPLOAD |
| INCORPORA TIONCOUNTRY | Incorporationcountry | VARCHAR2 | 3 | PATM_PARTYMASTERTAUPLOAD |
| MODULEID | Moduleid | VARCHAR2 | 30 | PATM_PARTYMASTERTAUPLOAD |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PATM_PARTYMASTERTAUPLOAD |
| MAKER_DT_STAMP | Maker_Dt_Stamp | DATE | 7 | PATM_PARTYMASTERTAUPLOAD |
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | PATM_PARTYMASTERTAUPLOAD |
| CHECKER_DT_STAMP | Checker_Dt_Stamp | DATE | 7 | PATM_PARTYMASTERTAUPLOAD |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PATM_PARTYMASTERTAUPLOAD |
| ONCE_AUTH | Once_Auth | VARCHAR2 | 1 | PATM_PARTYMASTERTAUPLOAD |
| RECORD_STAT | Record_Stat | VARCHAR2 | 1 | PATM_PARTYMASTERTAUPLOAD |
| MOD_NO | Mod_No | NUMBER | 22 | PATM_PARTYMASTERTAUPLOAD |
| FATHERSPOUSENAME | Fatherspousename | VARCHAR2 | 105 | PATM_PARTYMASTERTAUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_PARTYCONTACTTAUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATM_PARTYCONTACTTAUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_PARTYCONTACTTAUPLOAD |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATM_PARTYCONTACTTAUPLOAD |
| PARTYID | Partyid | VARCHAR2 | 12 | PATM_PARTYCONTACTTAUPLOAD |
| CONTACTREFNO | Contactrefno | VARCHAR2 | 16 | PATM_PARTYCONTACTTAUPLOAD |
| ADDRESSTYPE | Addresstype | VARCHAR2 | 2 | PATM_PARTYCONTACTTAUPLOAD |
| ADDRESS LINE1 | Addressline1 | VARCHAR2 | 100 | PATM_PARTYCONTACTTAUPLOAD |
| ADDRESS LINE2 | Addressline2 | VARCHAR2 | 100 | PATM_PARTYCONTACTTAUPLOAD |
| ADDRESS LINE3 | Addressline3 | VARCHAR2 | 100 | PATM_PARTYCONTACTTAUPLOAD |
| POSTBOXNO | Postboxno | VARCHAR2 | 16 | PATM_PARTYCONTACTTAUPLOAD |
| CITY | City | VARCHAR2 | 80 | PATM_PARTYCONTACTTAUPLOAD |
| STATE | State | VARCHAR2 | 80 | PATM_PARTYCONTACTTAUPLOAD |
| COUNTRY | Country | VARCHAR2 | 3 | PATM_PARTYCONTACTTAUPLOAD |
| ZIPCODE | Zipcode | VARCHAR2 | 10 | PATM_PARTYCONTACTTAUPLOAD |
| BICCODE | Biccode | VARCHAR2 | 16 | PATM_PARTYCONTACTTAUPLOAD |
| WEBSITE | Website | VARCHAR2 | 100 | PATM_PARTYCONTACTTAUPLOAD |
| EMAILADDRESS | Emailaddress | VARCHAR2 | 100 | PATM_PARTYCONTACTTAUPLOAD |
| EFFECTIVEFROMDATE | Effectivefromdate | DATE | 7 | PATM_PARTYCONTACTTAUPLOAD |
| EFFECTIVETODATE | Effectivetodate | DATE | 7 | PATM_PARTYCONTACTTAUPLOAD |
| PRIMARYCONTACTPERSON | Primarycontactperson | VARCHAR2 | 100 | PATM_PARTYCONTACTTAUPLOAD |
| PRIMARYINTERNDIALCODE1 | Primaryinterndialcode1 | VARCHAR2 | 10 | PATM_PARTYCONTACTTAUPLOAD |
| PRIMARYINTERNDIALCODE2 | Primaryinterndialcode2 | VARCHAR2 | 10 | PATM_PARTYCONTACTTAUPLOAD |
| PRIMARYINTERNDIALCODE3 | Primaryinterndialcode3 | VARCHAR2 | 10 | PATM_PARTYCONTACTTAUPLOAD |
| PRIMARYINTERNDIALCODE4 | Primaryinterndialcode4 | VARCHAR2 | 10 | PATM_PARTYCONTACTTAUPLOAD |
| PRIMARYPOSITION | Primaryposition | VARCHAR2 | 60 | PATM_PARTYCONTACTTAUPLOAD |
| PRIMARYMOBILENUMBER1 | Primarymobilenumber1 | VARCHAR2 | 60 | PATM_PARTYCONTACTTAUPLOAD |
| PRIMARYMO BILENUMBER2 | Primarymobilenumber2 | VARCHAR2 | 60 | PATM_PARTYCONTACTTAUPLOAD |
| PRIMARYFIXEDLINE | Primaryfixedline | VARCHAR2 | 60 | PATM_PARTYCONTACTTAUPLOAD |
| FAX | Fax | VARCHAR2 | 120 | PATM_PARTYCONTACTTAUPLOAD |
| PRIMARYCONTACTINSTRN | Primarycontactinstrn | VARCHAR2 | 100 | PATM_PARTYCONTACTTAUPLOAD |
| PRIMARYEXTN | Primaryextn | VARCHAR2 | 60 | PATM_PARTYCONTACTTAUPLOAD |
| SECONDARYCONTACTPERSON | Secondarycontactperson | VARCHAR2 | 100 | PATM_PARTYCONTACTTAUPLOAD |
| SECONDARYINTERNDIALCODE1 | Secondaryinterndialcode1 | VARCHAR2 | 10 | PATM_PARTYCONTACTTAUPLOAD |
| SECONDARYINTERNDIALCODE2 | Secondaryinterndialcode2 | VARCHAR2 | 10 | PATM_PARTYCONTACTTAUPLOAD |
| SECONDARYPOSITION | Secondaryposition | VARCHAR2 | 60 | PATM_PARTYCONTACTTAUPLOAD |
| SECONDARYMOBILENUMBER | Secondarymobilenumber | VARCHAR2 | 60 | PATM_PARTYCONTACTTAUPLOAD |
| SECONDARYFIXEDLINE | Secondaryfixedline | VARCHAR2 | 60 | PATM_PARTYCONTACTTAUPLOAD |
| SECONDARYCONTACTINSTRN | Secondarycontactinstrn | VARCHAR2 | 105 | PATM_PARTYCONTACTTAUPLOAD |
| SECONDARYEXTN | Secondaryextn | VARCHAR2 | 60 | PATM_PARTYCONTACTTAUPLOAD |
| MODULEID | Moduleid | VARCHAR2 | 30 | PATM_PARTYCONTACTTAUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_PARTYIDTAUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATM_PARTYIDTAUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_PARTYIDTAUPLOAD |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATM_PARTYIDTAUPLOAD |
| PARTYID | Partyid | VARCHAR2 | 12 | PATM_PARTYIDTAUPLOAD |
| IDREFERENCENO | Idreferenceno | VARCHAR2 | 16 | PATM_PARTYIDTAUPLOAD |
| IDENTIFICATIONTYPE | Identificationtype | VARCHAR2 | 20 | PATM_PARTYIDTAUPLOAD |
| IDENTIFICATIONNUMBER | Identificationnumber | VARCHAR2 | 50 | PATM_PARTYIDTAUPLOAD |
| PLACEOFISSUE | Placeofissue | VARCHAR2 | 3 | PATM_PARTYIDTAUPLOAD |
| ISSUEAUTHORITY | Issueauthority | VARCHAR2 | 50 | PATM_PARTYIDTAUPLOAD |
| ISSUECOUNTRY | Issuecountry | VARCHAR2 | 3 | PATM_PARTYIDTAUPLOAD |
| DATEOFISSUE | Dateofissue | DATE | 7 | PATM_PARTYIDTAUPLOAD |
| DATEOFEXPIRY | Dateofexpiry | DATE | 7 | PATM_PARTYIDTAUPLOAD |
| LASTVERIFIEDDATE | Lastverifieddate | DATE | 7 | PATM_PARTYIDTAUPLOAD |
| VERIFICATIONSTATUS | Verificationstatus | VARCHAR2 | 1 | PATM_PARTYIDTAUPLOAD |
| MODULEID | Moduleid | VARCHAR2 | 30 | PATM_PARTYIDTAUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_INVACCMASTERTAUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATM_INVACCMASTERTAUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_INVACCMASTERTAUPLOAD |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATM_INVACCMASTERTAUPLOAD |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATM_INVACCMASTERTAUPLOAD |
| ACOPERATIONTYPE | Acoperationtype | VARCHAR2 | 1 | PATM_INVACCMASTERTAUPLOAD |
| DEALINGTYPE | Dealingtype | VARCHAR2 | 3 | PATM_INVACCMASTERTAUPLOAD |
| GUARDIANID | Guardianid | VARCHAR2 | 12 | PATM_INVACCMASTERTAUPLOAD |
| PARTYID | Partyid | VARCHAR2 | 12 | PATM_INVACCMASTERTAUPLOAD |
| INVESTORCATEGORY | Investorcategory | VARCHAR2 | 2 | PATM_INVACCMASTERTAUPLOAD |
| ACOPENINGDATE | Acopeningdate | DATE | 7 | PATM_INVACCMASTERTAUPLOAD |
| ACCOUNTREFNO | Accountrefno | VARCHAR2 | 16 | PATM_INVACCMASTERTAUPLOAD |
| MODULEID | Moduleid | VARCHAR2 | 30 | PATM_INVACCMASTERTAUPLOAD |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PATM_INVACCMASTERTAUPLOAD |
| ONCE_AUTH | Once_Auth | VARCHAR2 | 1 | PATM_INVACCMASTERTAUPLOAD |
| RECORD_STAT | Record_Stat | VARCHAR2 | 1 | PATM_INVACCMASTERTAUPLOAD |
| MOD_NO | Mod_No | NUMBER | 22 | PATM_INVACCMASTERTAUPLOAD |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PATM_INVACCMASTERTAUPLOAD |
| MAKER_DT_STAMP | Maker_Dt_Stamp | DATE | 7 | PATM_INVACCMASTERTAUPLOAD |
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | PATM_INVACCMASTERTAUPLOAD |
| CHECKER_DT_STAMP | Check er_Dt_Stamp | DATE | 7 | PATM_INVACCMASTERTAUPLOAD |
| ACCOUNTSTATUS | Accountstatus | VARCHAR2 | 1 | PATM_INVACCMASTERTAUPLOAD |
| PENSIONACCOUNT | Pensionaccount | VARCHAR2 | 1 | PATM_INVACCMASTERTAUPLOAD |
| ACCOUNTCLOSED | Accountclosed | VARCHAR2 | 1 | PATM_INVACCMASTERTAUPLOAD |
| CHANGEDATE | Changedate | DATE | 7 | PATM_INVACCMASTERTAUPLOAD |
| CHANGEREASON | Changereason | VARCHAR2 | 255 | PATM_INVACCMASTERTAUPLOAD |
| CHANGEREFERENCENO | Changereferenceno | VARCHAR2 | 16 | PATM_INVACCMASTERTAUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_INVACCINTERTAUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATM_INVACCINTERTAUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_INVACCINTERTAUPLOAD |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATM_INVACCINTERTAUPLOAD |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATM_INVACCINTERTAUPLOAD |
| INTERMEDIARYID | Intermediaryid | VARCHAR2 | 12 | PATM_INVACCINTERTAUPLOAD |
| SPLITPERCENTAGE | Splitpercentage | NUMBER | 5 | PATM_INVACCINTERTAUPLOAD |
| DEFAULTFLAG | Defaultflag | VARCHAR2 | 1 | PATM_INVACCINTERTAUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_INVACCBANKTAUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATM_INVACCBANKTAUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_INVACCBANKTAUPLOAD |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATM_INVACCBANKTAUPLOAD |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATM_INVACCBANKTAUPLOAD |
| BANKREFERENCENO | Bankreferenceno | VARCHAR2 | 16 | PATM_INVACCBANKTAUPLOAD |
| DIRECTDEBITAPPLICABLE | Directdebitapplicable | VARCHAR2 | 1 | PATM_INVACCBANKTAUPLOAD |
| DEFAULTFLAG | Defaultflag | VARCHAR2 | 1 | PATM_INVACCBANKTAUPLOAD |
| ACCOUNTHOLDERNAME | Accountholdername | VARCHAR2 | 100 | PATM_INVACCBANKTAUPLOAD |
| ACCOUNTTYPE | Accounttype | VARCHAR2 | 1 | PATM_INVACCBANKTAUPLOAD |
| ACCOUNTCURRENCY | Accountcurrency | VARCHAR2 | 3 | PATM_INVACCBANKTAUPLOAD |
| BANKCODE | Bankcode | VARCHAR2 | 12 | PATM_INVACCBANKTAUPLOAD |
| BRANCHCODE | Branchcode | VARCHAR2 | 12 | PATM_INVACCBANKTAUPLOAD |
| ACCOUNTNUMBER | Accountnumber | VARCHAR2 | 20 | PATM_INVACCBANKTAUPLOAD |
| IBAN | Iban | VARCHAR2 | 40 | PATM_INVACCBANKTAUPLOAD |
| VERIFICATIONSTATUS | Verificationstatus | VARCHAR2 | 1 | PATM_INVACCBANKTAUPLOAD |
| LASTVERIFIEDDATE | Lastverifieddate | DATE | 7 | PATM_INVACCBANKTAUPLOAD |
| MODULEID | Moduleid | VARCHAR2 | 30 | PATM_INVACCBANKTAUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_INVESTACCBENFTAUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATM_INVESTACCBENFTAUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_INVESTACCBENFTAUPLOAD |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATM_INVESTACCBENFTAUPLOAD |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATM_INVESTACCBENFTAUPLOAD |
| BENEFICIARYTYPE | Beneficiarytype | VARCHAR2 | 2 | PATM_INVESTACCBENFTAUPLOAD |
| BENFPARTYID | Benfpartyid | VARCHAR2 | 16 | PATM_INVESTACCBENFTAUPLOAD |
| AWARDPERCENTAGE | Awardpercentage | NUMBER | 5 | PATM_INVESTACCBENFTAUPLOAD |
| BENFPAR TYNAME | Benfpartyname | VARCHAR2 | 100 | PATM_INVESTACCBENFTAUPLOAD |
| DATEOFBIRTH | Dateofbirth | DATE | 7 | PATM_INVESTACCBENFTAUPLOAD |
| COUNTRYOFBIRTH | Countryofbirth | VARCHAR2 | 3 | PATM_INVESTACCBENFTAUPLOAD |
| COUNTRYOFDOMICILE | Countryofdomicile | VARCHAR2 | 3 | PATM_INVESTACCBENFTAUPLOAD |
| GENDER | Gender | VARCHAR2 | 1 | PATM_INVESTACCBENFTAUPLOAD |
| IDENTIFICATIONTYPE | Identificationtype | VARCHAR2 | 20 | PATM_INVESTACCBENFTAUPLOAD |
| IDENTIFICATIONNUMBER | Identificationnumber | VARCHAR2 | 50 | PATM_INVESTACCBENFTAUPLOAD |
| RELATIONSHIP | Relationship | VARCHAR2 | 70 | PATM_INVESTACCBENFTAUPLOAD |
| ADDRESSLINE1 | Addressline1 | VARCHAR2 | 100 | PATM_INVESTACCBENFTAUPLOAD |
| ADDRESSLINE2 | Addressline2 | VARCHAR2 | 100 | PATM_INVESTACCBENFTAUPLOAD |
| CITY | City | VARCHAR2 | 80 | PATM_INVESTACCBENFTAUPLOAD |
| STATE | State | VARCHAR2 | 80 | PATM_INVESTACCBENFTAUPLOAD |
| COUNTRY | Country | VARCHAR2 | 3 | PATM_INVESTACCBENFTAUPLOAD |
| ZIPCODE | Zipcode | VARCHAR2 | 10 | PATM_INVESTACCBENFTAUPLOAD |
| EMAILADDRESS | Emailaddress | VARCHAR2 | 100 | PATM_INVESTACCBENFTAUPLOAD |
| PRIMARYMOBILENUMBER1 | Primarymobilenumber1 | VARCHAR2 | 60 | PATM_INVESTACCBENFTAUPLOAD |
| PRIMARYMOBILENUMBER2 | Primarymobilenumber2 | VARCHAR2 | 60 | PATM_INVESTACCBENFTAUPLOAD |
| PRIMARYFIXEDLINE | Primaryfixedline | VARCHAR2 | 60 | PATM_INVESTACCBENFTAUPLOAD |
| FAX | Fax | VARCHAR2 | 120 | PATM_INVESTACCBENFTAUPLOAD |
| CONTACTPERSON | Contactperson | VARCHAR2 | 100 | PATM_INVESTACCBENFTAUPLOAD |
| BANKCODE | Bankcode | VARCHAR2 | 12 | PATM_INVESTACCBENFTAUPLOAD |
| BRANCHCODE | Branchcode | VARCHAR2 | 12 | PATM_INVESTACCBENFTAUPLOAD |
| ACCOUNTTYPE | Accounttype | VARCHAR2 | 1 | PATM_INVESTACCBENFTAUPLOAD |
| ACCOUNTCURRENCY | Accountcurrency | VARCHAR2 | 3 | PATM_INVESTACCBENFTAUPLOAD |
| ACCOUNTNUMBER | Accountnumber | VARCHAR2 | 20 | PATM_INVESTACCBENFTAUPLOAD |
| ACCOUNTNAME | Accountname | VARCHAR2 | 100 | PATM_INVESTACCBENFTAUPLOAD |
| IBAN | Iban | VARCHAR2 | 40 | PATM_INVESTACCBENFTAUPLOAD |
| DESIGNATION | Designation | VARCHAR2 | 100 | PATM_INVESTACCBENFTAUPLOAD |
| CONTROLLINGPERSON | Controllingperson | VARCHAR2 | 1 | PATM_INVESTACCBENFTAUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ALLOCDETAILSTAUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATB_ALLOCDETAILSTAUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ALLOCDETAILSTAUPLOAD |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATB_ALLOCDETAILSTAUPLOAD |
| ORDERNUMBER | Ordernumber | VARCHAR2 | 16 | PATB_ALLOCDETAILSTAUPLOAD |
| EXTERNALTXNNUMBER | Externaltxnnumber | VARCHAR2 | 16 | PATB_ALLOCDETAILSTAUPLOAD |
| PARTYID | Partyid | VARCHAR2 | 12 | PATB_ALLOCDETAILSTAUPLOAD |
| PORTFOLIOID | Portfolioid | VARCHAR2 | 16 | PATB_ALLOCDETAILSTAUPLOAD |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATB_ALLOCDETAILSTAUPLOAD |
| INSTRUMENTID | Instrumentid | VARCHAR2 | 16 | PATB_ALLOCDETAILSTAUPLOAD |
| ASSETID | Assetid | VARCHAR2 | 16 | PATB_ALLOCDETAILSTAUPLOAD |
| ORDERAMOUNT | Orderamount | NUMBER | 30 | PATB_ALLOCDETAILSTAUPLOAD |
| LOADAMOUNT | Loadamount | NUMBER | 30 | PATB_ALLOCDETAILSTAUPLOAD |
| NETAMOUNT | Netamount | NUMBER | 30 | PATB_ALLOCDETAILSTAUPLOAD |
| SETTLEMENTAMT | Settlementamt | NUMBER | 30 | PATB_ALLOCDETAILSTAUPLOAD |
| NAV | Nav | NUMBER | 17 | PATB_ALLOCDETAILSTAUPLOAD |
| NAVDATE | Navdate | DATE | 7 | PATB_ALLOCDETAILSTAUPLOAD |
| ALLOTEDUNITS | Allotedunits | NUMBER | 30 | PATB_ALLOCDETAILSTAUPLOAD |
| ALLOCATIONDATE | Allocationdate | DATE | 7 | PATB_ALLOCDETAILSTAUPLOAD |
| FROMORTOLEG | Fromortoleg | VARCHAR2 | 1 | PATB_ALLOCDETAILSTAUPLOAD |
| ORIGINALORDNUMBER | Originalordnumber | VARCHAR2 | 16 | PATB_ALLOCDETAILSTAUPLOAD |
| ORDERTYPE | Ordertype | VARCHAR2 | 3 | PATB_ALLOCDETAILSTAUPLOAD |
| STATUS | Status | VARCHAR2 | 2 | PATB_ALLOCDETAILSTAUPLOAD |
| ERR_CODE | Err_Code | VARCHAR2 | 20 | PATB_ALLOCDETAILSTAUPLOAD |
| ERRDESCRIPTION | Errdescription | VARCHAR2 | 255 | PATB_ALLOCDETAILSTAUPLOAD |
| TATRANSACTIONDATE | Tatransactiondate | DATE | 7 | PATB_ALLOCDETAILSTAUPLOAD |
| BLOCKEDFLAG | Blockedflag | VARCHAR2 | 1 | PATB_ALLOCDETAILSTAUPLOAD |
Parent topic: Pension Order Export