1.38.2 Pension Order Upload
This topic explains the systematic instructions on pension order upload.
For Pension order upload, use UH bulk client code as pension is needed to be maintained in FMG.
Export path of one system should be import path for another system:
Table 1-154 Pension Order Upload
| Field name | Description | Datatype | Length | Table Name |
|---|---|---|---|---|
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ORDERUP-LOAD |
| SEQUENCE-NUMBER | Sequencenum-ber | NUMBER | 22 | PATB_ORDERUP-LOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ORDERUP-LOAD |
| BULKCLIENT-CODE | Bulkclientcode | VARCHAR2 | 12 | PATB_ORDERUP-LOAD |
| UPLOAD-MODE | Uploadmode | VARCHAR2 | 1 | PATB_ORDERUP-LOAD |
| IMPORTFILE-NAME | Importfilename | VARCHAR2 | 255 | PATB_ORDERUP-LOAD |
| ORDERNUM-BER | Ordernumber | VARCHAR2 | 16 | PATB_ORDERUP-LOAD |
| REFERENCE-NUMBER | Referencenum-ber | VARCHAR2 | 16 | PATB_ORDERUP-LOAD |
| PARTYID | Partyid | VARCHAR2 | 12 | PATB_ORDERUP-LOAD |
| PORTFOLIOID | Portfolioid | VARCHAR2 | 16 | PATB_ORDERUP-LOAD |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATB_ORDERUP-LOAD |
| ORDERCUR-RENCY | Ordercurrency | VARCHAR2 | 3 | PATB_ORDERUP-LOAD |
| ORDERMODE | Ordermode | VARCHAR2 | 1 | PATB_ORDERUP-LOAD |
| ORDERVALUE | Ordervalue | NUMBER | 30 | PATB_ORDERUP-LOAD |
| INSTRUC-TIONDATE | Instructiondate | DATE | 7 | PATB_ORDERUP-LOAD |
| ORDERTYPE | Ordertype | VARCHAR2 | 3 | PATB_ORDERUP-LOAD |
| ORDERSUB-TYPE | Ordersubtype | VARCHAR2 | 3 | PATB_ORDERUP-LOAD |
| PAYMENT-MODE | Paymentmode | VARCHAR2 | 2 | PATB_ORDERUP-LOAD |
| GROSSOR-NET | Grossornet | VARCHAR2 | 1 | PATB_ORDERUP-LOAD |
| MODULEID | Moduleid | VARCHAR2 | 30 | PATB_ORDERUP-LOAD |
| ORDERSTA-TUS | Orderstatus | NUMBER | 2 | PATB_ORDERUP-LOAD |
| ORIGIN-ALORDNUM-BER | Originalord-number | VARCHAR2 | 16 | PATB_ORDERUP-LOAD |
| ORIGINAL-REFNUMBER | Originalrefnum-ber | VARCHAR2 | 16 | PATB_ORDERUP-LOAD |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PATB_ORDERUP-LOAD |
| ONCE_AUTH | Once_Auth | VARCHAR2 | 1 | PATB_ORDERUP-LOAD |
| RECORD_STA T | Record_Stat | VARCHAR2 | 1 | PATB_ORDERUP-LOAD |
| MOD_NO | Mod_No | NUMBER | 22 | PATB_ORDERUP-LOAD |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PATB_ORDERUP-LOAD |
| MAK-ER_DT_STAM P | Mak-er_Dt_Stamp | DATE | 7 | PATB_ORDERUP-LOAD |
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | PATB_ORDERUP-LOAD |
| CHECK-ER_DT_STAM P | Check-er_Dt_Stamp | DATE | 7 | PATB_ORDERUP-LOAD |
| REMARKS | Remarks | VARCHAR2 | 255 | PATB_ORDERUP-LOAD |
| SWIORDER-STATUS | Swiorderstatus | NUMBER | 2 | PATB_ORDERUP-LOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ORDERIN-STRUMENTUPLOAD |
| SEQUENCE-NUMBER | Sequencenum-ber | NUMBER | 22 | PATB_ORDERIN-STRUMENTUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ORDERIN-STRUMENTUPLOAD |
| BULKCLIENT-CODE | Bulkclientcode | VARCHAR2 | 12 | PATB_ORDERIN-STRUMENTUPLOAD |
| UPLOAD-MODE | Uploadmode | VARCHAR2 | 1 | PATB_ORDERIN-STRUMENTUPLOAD |
| IMPORTFILE-NAME | Importfilename | VARCHAR2 | 255 | PATB_ORDERIN-STRUMENTUPLOAD |
| ORDERNUM-BER | Ordernumber | VARCHAR2 | 16 | PATB_ORDERIN-STRUMENTUPLOAD |
| INSTRUMEN-TID | Instrumentid | VARCHAR2 | 16 | PATB_ORDERIN-STRUMENTUPLOAD |
| SPLITPER-CENTAGE | Splitpercentage | NUMBER | 22 | PATB_ORDERIN-STRUMENTUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ORDERINS- TASSETUPLOAD |
| SEQUENCE-NUMBER | Sequencenum-ber | NUMBER | 22 | PATB_ORDERINS- TASSETUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ORDERINS- TASSETUPLOAD |
| BULKCLIENT-CODE | Bulkclientcode | VARCHAR2 | 12 | PATB_ORDERINS- TASSETUPLOAD |
| UPLOAD-MODE | Uploadmode | VARCHAR2 | 1 | PATB_ORDERINS- TASSETUPLOAD |
| IMPORTFILE-NAME | Importfilename | VARCHAR2 | 255 | PATB_ORDERINS- TASSETUPLOAD |
| ORDERNUM-BER | Ordernumber | VARCHAR2 | 16 | PATB_ORDERINS- TASSETUPLOAD |
| INSTRUMEN-TID | Instrumentid | VARCHAR2 | 16 | PATB_ORDERINS- TASSETUPLOAD |
| ASSETID | Assetid | VARCHAR2 | 16 | PATB_ORDERINS- TASSETUPLOAD |
| RATIO | Ratio | NUMBER | 22 | PATB_ORDERINS- TASSETUPLOAD |
| OVERRIDE | Override | VARCHAR2 | 1 | PATB_ORDERINS- TASSETUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ORDERINTER-MEDIARYUPLOAD |
| SEQUENCE-NUMBER | Sequencenum-ber | NUMBER | 22 | PATB_ORDERINTER-MEDIARYUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ORDERINTER-MEDIARYUPLOAD |
| BULKCLIENT-CODE | Bulkclientcode | VARCHAR2 | 12 | PATB_ORDERINTER-MEDIARYUPLOAD |
| UPLOAD-MODE | Uploadmode | VARCHAR2 | 1 | PATB_ORDERINTER-MEDIARYUPLOAD |
| IMPORTFILE-NAME | Importfilename | VARCHAR2 | 255 | PATB_ORDERINTER-MEDIARYUPLOAD |
| ORDERNUM-BER | Ordernumber | VARCHAR2 | 16 | PATB_ORDERINTER-MEDIARYUPLOAD |
| INTERMEDI-ARYID | Intermediaryid | VARCHAR2 | 12 | PATB_ORDERINTER-MEDIARYUPLOAD |
| SPLITPER-CENTAGE | Splitpercentage | NUMBER | 22 | PATB_ORDERINTER-MEDIARYUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ORDERSET- TLEMENTUPLOAD |
| SEQUENCE-NUMBER | Sequencenum- ber | NUMBER | 22 | PATB_ORDERSET- TLEMENTUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ORDERSET- TLEMENTUPLOAD |
| BULKCLIENT-CODE | Bulkclientcode | VARCHAR2 | 12 | PATB_ORDERSET- TLEMENTUPLOAD |
| UPLOAD-MODE | Uploadmode | VARCHAR2 | 1 | PATB_ORDERSET- TLEMENTUPLOAD |
| IMPORTFILE-NAME | Importfilename | VARCHAR2 | 255 | PATB_ORDERSET- TLEMENTUPLOAD |
| ORDERNUM-BER | Ordernumber | VARCHAR2 | 16 | PATB_ORDERSET- TLEMENTUPLOAD |
| PAYMENTREF-NUMBER | Paymentref-number | VARCHAR2 | 16 | PATB_ORDERSET- TLEMENTUPLOAD |
| BANKREFER- ENCENO | Bankreferen-ceno | VARCHAR2 | 16 | PATB_ORDERSET- TLEMENTUPLOAD |
| CHEQUEDATE | Chequedate | DATE | 7 | PATB_ORDERSET- TLEMENTUPLOAD |
| CHEQUENUM-BER | Chequenumber | VARCHAR2 | 20 | PATB_ORDERSET- TLEMENTUPLOAD |
| PAYMENTA-MOUNT | Paymenta-mount | NUMBER | 22 | PATB_ORDERSET- TLEMENTUPLOAD |
| PAIDDATE | Paiddate | DATE | 7 | PATB_ORDERSET- TLEMENTUPLOAD |
| SETTLED | Settled | VARCHAR2 | 1 | PATB_ORDERSET- TLEMENTUPLOAD |
| AUTOSETTLE-MENT | AUTOSETTLE-MENT | NUMBER | 1 | PATB_ORDERSET- TLEMENTUPLOAD |
| SETTLEMENT-DUEDATE | SETTLEMENT-DUEDATE | DATE | 7 | PATB_ORDERSET- TLEMENTUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_SWORDERIN-STRUMENTUPLOAD |
| SEQUENCE-NUMBER | Sequencenum-ber | NUMBER | 22 | PATB_SWORDERIN-STRUMENTUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_SWORDERIN-STRUMENTUPLOAD |
| BULKCLIENT-CODE | Bulkclientcode | VARCHAR2 | 12 | PATB_SWORDERIN-STRUMENTUPLOAD |
| UPLOAD-MODE | Uploadmode | VARCHAR2 | 1 | PATB_SWORDERIN-STRUMENTUPLOAD |
| IMPORTFILE-NAME | Importfilename | VARCHAR2 | 255 | PATB_SWORDERIN-STRUMENTUPLOAD |
| ORDERNUM-BER | Ordernumber | VARCHAR2 | 16 | PATB_SWORDERIN-STRUMENTUPLOAD |
| INSTRUMEN-TID | Instrumentid | VARCHAR2 | 16 | PATB_SWORDERIN-STRUMENTUPLOAD |
| SPLITPER-CENTAGE | Splitpercentage | NUMBER | 22 | PATB_SWORDERIN-STRUMENTUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_SWORDERIN- STASSETUPLOAD |
| SEQUENCE-NUMBER | Sequencenum-ber | NUMBER | 22 | PATB_SWORDERIN- STASSETUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_SWORDERIN- STASSETUPLOAD |
| BULKCLIENT-CODE | Bulkclientcode | VARCHAR2 | 12 | PATB_SWORDERIN- STASSETUPLOAD |
| UPLOAD-MODE | Uploadmode | VARCHAR2 | 1 | PATB_SWORDERIN- STASSETUPLOAD |
| IMPORTFILE-NAME | Importfilename | VARCHAR2 | 255 | PATB_SWORDERIN- STASSETUPLOAD |
| ORDERNUM-BER | Ordernumber | VARCHAR2 | 16 | PATB_SWORDERIN- STASSETUPLOAD |
| INSTRUMEN-TID | Instrumentid | VARCHAR2 | 16 | PATB_SWORDERIN- STASSETUPLOAD |
| ASSETID | Assetid | VARCHAR2 | 16 | PATB_SWORDERIN- STASSETUPLOAD |
| RATIO | Ratio | NUMBER | 22 | PATB_SWORDERIN- STASSETUPLOAD |
| OVERRIDE | Override | VARCHAR2 | 1 | PATB_SWORDERIN- STASSETUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ADDINFOUP-LOAD |
| SEQUENCE-NUMBER | Sequencenum-ber | NUMBER | 22 | PATB_ADDINFOUP-LOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ADDINFOUP-LOAD |
| BULKCLIENT-CODE | Bulkclientcode | VARCHAR2 | 12 | PATB_ADDINFOUP-LOAD |
| UPLOAD-MODE | Uploadmode | VARCHAR2 | 1 | PATB_ADDINFOUP-LOAD |
| IMPORTFILE-NAME | Importfilename | VARCHAR2 | 255 | PATB_ADDINFOUP-LOAD |
| ORDERNUM-BER | Ordernumber | VARCHAR2 | 16 | PATB_ADDINFOUP-LOAD |
| ADDINFOLA-BEL | Addinfolabel | VARCHAR2 | 30 | PATB_ADDINFOUP-LOAD |
| FIELDVALUE | Fieldvalue | CHAR | 23 | PATB_ADDINFOUP-LOAD |
Parent topic: Pension Order Upload