1.67.2 Asset Maintenance Import
This topic provides detailed information on the Asset Maintenance Import for segment identification numbers.
Table 1-204 Asset Maintenance Import
| Field name | Description | Datatype | Length | Table Name |
|---|---|---|---|---|
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ASSETMAINTUPLOAD |
| SEQUENCENUMBER | Sequence number | NUMBER | 10 | PATB_ASSETMAINTUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ASSETMAINTUPLOAD |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATB_ASSETMAINTUPLOAD |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATB_ASSETMAINTUPLOAD |
| ASSETCLASS | Assetclass | VARCHAR2 | 10 | PATB_ASSETMAINTUPLOAD |
| ASSETID | Assetid | VARCHAR2 | 6 | PATB_ASSETMAINTUPLOAD |
| ASSETNAMESHORT | Assetnameshort | VARCHAR2 | 90 | PATB_ASSETMAINTUPLOAD |
| ASSETBASECCY | Assetbaseccy | VARCHAR2 | 3 | PATB_ASSETMAINTUPLOAD |
| QUOTATION | Quotation | VARCHAR2 | 100 | PATB_ASSETMAINTUPLOAD |
| EXTERNALSYSTEM | Externalsystem | VARCHAR2 | 255 | PATB_ASSETMAINTUPLOAD |
| MAKER_ID | Maker Id | VARCHAR2 | 320 | PATB_ASSETMAINTUPLOAD |
| MAKER_DT_STAMP | Maker Date Stamp | DATE | 7 | PATB_ASSETMAINTUPLOAD |
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | PATB_ASSETMAINTUPLOAD |
| CHECKER_DT_STAMP | Checker_Dt_Stam p | DATE | 7 | PATB_ASSETMAINTUPLOAD |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PATB_ASSETMAINTUPLOAD |
| ONCE_AUTH | Once_Auth | VARCHAR2 | 1 | PATB_ASSETMAINTUPLOAD |
| RECORD_STAT | Record_Stat | VARCHAR2 | 1 | PATB_ASSETMAINTUPLOAD |
| MOD_NO | Mod_No | NUMBER | 22 | PATB_ASSETMAINTUPLOAD |
| REMARKS | Remarks | VARCHAR2 | 255 | PATB_ASSETMAINTUPLOAD |
| MODULEID | Moduleid | VARCHAR2 | 30 | PATB_ASSETMAINTUPLOAD |
| NOOFDECIMALS | Noofdecimals | NUMBER | 22 | PATB_ASSETMAINTUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_ASSETADDINFOUPLOAD |
| SEQUENCENUMBER | Sequence number | NUMBER | 22 | PATM_ASSETADDINFOUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_ASSETADDINFOUPLOAD |
| ASSETID | Assetid | VARCHAR2 | 6 | PATM_ASSETADDINFOUPLOAD |
| ADDINFOLABEL | Addinfolabel | VARCHAR2 | 30 | PATM_ASSETADDINFOUPLOAD |
| FIELDVALUE | Field value | CHAR | 23 | PATM_ASSETADDINFOUPLOAD |
| ASSETCLASS | Assetclass | VARCHAR2 | 10 | PATM_ASSETADDINFOUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_ASSETLOADDETUPLOAD |
| SEQUENCENUMBER | Sequence number | NUMBER | 10 | PATM_ASSETLOADDETUPLOAD |
| PROCESSID | Process Id | VARCHAR2 | 50 | PATM_ASSETLOADDETUPLOAD |
| ASSETID | Asset Id | VARCHAR2 | 6 | PATM_ASSETLOADDETUPLOAD |
| TRANSACTIONTYPE | Transaction type | VARCHAR2 | 2 | PATM_ASSETLOADDETUPLOAD |
| LOADID | Loadid | NUMBER | 5 | PATM_ASSETLOADDETUPLOAD |
| LOADDESCRIPTION | Loaddescription | VARCHAR2 | 255 | PATM_ASSETLOADDETUPLOAD |
| ASSETCLASS | Assetclass | VARCHAR2 | 10 | PATM_ASSETLOADDETUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_ASSETTXNRULEUPLOAD |
| SEQUENCENUMBER | Sequence number | NUMBER | 10 | PATM_ASSETTXNRULEUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_ASSETTXNRULEUPLOAD |
| ASSETID | Assetid | VARCHAR2 | 6 | PATM_ASSETTXNRULEUPLOAD |
| TRANSACTIONTYPE | Transaction Type | VARCHAR2 | 2 | PATM_ASSETTXNRULEUPLOAD |
| TRANSACTIONSTARTDATE | Transactionstartdate | DATE | 7 | PATM_ASSETTXNRULEUPLOAD |
| TRANSACTIONENDDATE | Transactionenddate | DATE | 7 | PATM_ASSETTXNRULEUPLOAD |
| MINTRANSACTIONAMOUNT | Mintransactionamount | NUMBER | 30 | PATM_ASSETTXNRULEUPLOAD |
| STEPAMOUNT | Step Amount | NUMBER | 30 | PATM_ASSETTXNRULEUPLOAD |
| MAXTRANSACTIONAMOUNT | Maxtransactionamount | NUMBER | 30 | PATM_ASSETTXNRULEUPLOAD |
| MINTRANSACTIONUNITS | Mintransactionunits | NUMBER | 27 | PATM_ASSETTXNRULEUPLOAD |
| STEPUNITS | Step units | NUMBER | 27 | PATM_ASSETTXNRULEUPLOAD |
| MAXTRANSACTIONUNITS | Maxtransactionunits | NUMBER | 27 | PATM_ASSETTXNRULEUPLOAD |
| TRANSACTIONENABLED | Transaction enabled | NUMBER | 1 | PATM_ASSETTXNRULEUPLOAD |
| MININITIALTXNAMOUNT | Mininitialtxnamount | NUMBER | 30 | PATM_ASSETTXNRULEUPLOAD |
| MININITIALTXNUNITS | Mininitialtxnunits | NUMBER | 27 | PATM_ASSETTXNRULEUPLOAD |
| MAXINITIALTXNAMOUNT | Maxinitialtxnamount | NUMBER | 30 | PATM_ASSETTXNRULEUPLOAD |
| MAXINITIALTXNUNITS | Maxinitialtxnunits | NUMBER | 27 | PATM_ASSETTXNRULEUPLOAD |
| ASSETCLASS | Assetclass | VARCHAR2 | 10 | PATM_ASSETTXNRULEUPLOAD |
Parent topic: Asset Maintenance Import