1.48.2 Load Maintenance Upload
This topic provides detailed information on the Load Maintenance Upload.
Table 1-172 Load Maintenance Upload
| Field name | Description | Datatype | Length | Table Name |
|---|---|---|---|---|
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_LOADUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATB_LOADUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_LOADUPLOAD |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATB_LOADUPLOAD |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATB_LOADUPLOAD |
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATB_LOADUPLOAD |
| LOADID | Loadid | NUMBER | 5 | PATB_LOADUPLOAD |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PATB_LOADUPLOAD |
| LOADDESCRIPTION | Loaddescription | VARCHAR2 | 60 | PATB_LOADUPLOAD |
| LOADTYPE | Loadtype | VARCHAR2 | 1 | PATB_LOADUPLOAD |
| AMOUNTORPERCENTAGE | Amountorpercentage | VARCHAR2 | 1 | PATB_LOADUPLOAD |
| LOADCALCMETHOD | Loadcalcmethod | VARCHAR2 | 1 | PATB_LOADUPLOAD |
| LOADOVERRIDEABLE | Loadoverrideable | NUMBER | 1 | PATB_LOADUPLOAD |
| CRITERIA | Criteria | VARCHAR2 | 255 | PATB_LOADUPLOAD |
| FROMTABLES | Fromtables | VARCHAR2 | 20 | PATB_LOADUPLOAD |
| LOWERBOUNDARYINCLUSIVE | Lowerboundaryinclusive | NUMBER | 1 | PATB_LOADUPLOAD |
| CUMULATIVELOADAPPLICABLE | Cumulativeloadapplicable | NUMBER | 1 | PATB_LOADUPLOAD |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PATB_LOADUPLOAD |
| MAKER_DT_STAMP | Maker_Dt_Stamp | DATE | 7 | PATB_LOADUPLOAD |
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | PATB_LOADUPLOAD |
| CHECKER_DT_STAMP | Checker_Dt_Stamp | DATE | 7 | PATB_LOADUPLOAD |
| LASTMODIFIEDUSERID | Lastmodifieduserid | VARCHAR2 | 320 | PATB_LOADUPLOAD |
| LASTMODIFIEDDATE | Lastmodifieddate | DATE | 7 | PATB_LOADUPLOAD |
| MOD_NO | Mod_No | NUMBER | 22 | PATB_LOADUPLOAD |
| PRICEBASISLOAD | Pricebasisload | NUMBER | 1 | PATB_LOADUPLOAD |
| AMOUNTBASIS | Amountbasis | VARCHAR2 | 1 | PATB_LOADUPLOAD |
| RECORD_STAT | Record_Stat | VARCHAR2 | 1 | PATB_LOADUPLOAD |
| ONCE_AUTH | Once_Auth | VARCHAR2 | 1 | PATB_LOADUPLOAD |
| ROATHRESHOLDFORINITIALFEE | Roathresholdforinitialfee | NUMBER | 30 | PATB_LOADUPLOAD |
| CREATEDMODULE | Createdmodule | VARCHAR2 | 30 | PATB_LOADUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_LOADDETUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATB_LOADDETUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_LOADDETUPLOAD |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATB_LOADDETUPLOAD |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATB_LOADDETUPLOAD |
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATB_LOADDETUPLOAD |
| LOADID | Loadid | NUMBER | 5 | PATB_LOADDETUPLOAD |
| SLABSEQNO | Slabseqno | NUMBER | 5 | PATB_LOADDETUPLOAD |
| SLABFROMDATE | Slabfromdate | DATE | 7 | PATB_LOADDETUPLOAD |
| SLABTODATE | Slabtodate | DATE | 7 | PATB_LOADDETUPLOAD |
| SLABFROMAMOUNT | Slabfromamount | NUMBER | 30 | PATB_LOADDETUPLOAD |
| SLABTOAMOUN T | Slabtoamount | NUMBER | 30 | PATB_LOADDETUPLOAD |
| SLABFROMUNITS | Slabfromunits | NUMBER | 27 | PATB_LOADDETUPLOAD |
| SLABTOUNITS | Slabtounits | NUMBER | 27 | PATB_LOADDETUPLOAD |
| SLABFROMPERIOD | Slabfromperiod | NUMBER | 22 | PATB_LOADDETUPLOAD |
| SLABTOPERIOD | Slabtoperiod | NUMBER | 22 | PATB_LOADDETUPLOAD |
| RETURNVALUE | Returnvalue | NUMBER | 30 | PATB_LOADDETUPLOAD |
| FLOORVALUE | Floorvalue | NUMBER | 15 | PATB_LOADDETUPLOAD |
| CEILINGVALUE | Ceilingvalue | NUMBER | 30 | PATB_LOADDETUPLOAD |
| PERIODBASIS | Periodbasis | VARCHAR2 | 1 | PATB_LOADDETUPLOAD |
| SLABFROMCOUNTER | Slabfrom counter | NUMBER | 22 | PATB_LOADDETUPLOAD |
| SLABTOCOUNTER | Slabtocounter | NUMBER | 22 | PATB_LOADDETUPLOAD |
| UHDEALCEILINGVALUE | Uhdealceilingvalue | NUMBER | 30 | PATB_LOADDETUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_BASISDEFUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATB_BASISDEFUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_BASISDEFUPLOAD |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATB_BASISDEFUPLOAD |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATB_BASISDEFUPLOAD |
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATB_BASISDEFUPLOAD |
| LOADID | Loadid | NUMBER | 5 | PATB_BASISDEFUPLOAD |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PATB_BASISDEFUPLOAD |
| TABLESREFERRED | Tablesreferred | VARCHAR2 | 16 | PATB_BASISDEFUPLOAD |
| BASISAMOUNT | Basisamount | VARCHAR2 | 255 | PATB_BASISDEFUPLOAD |
| BASISDAYS | Basisdays | VARCHAR2 | 255 | PATB_BASISDEFUPLOAD |
| BASISUNITS | Basisunits | VARCHAR2 | 255 | PATB_BASISDEFUPLOAD |
| JOINCLAUSE | Joinclause | VARCHAR2 | 255 | PATB_BASISDEFUPLOAD |
| FIELDFLAG | Fieldflag | VARCHAR2 | 1 | PATB_BASISDEFUPLOAD |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PATB_BASISDEFUPLOAD |
| MAKER_DT_STAMP | Maker_Dt_Stamp | DATE | 7 | PATB_BASISDEFUPLOAD |
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | PATB_BASISDEFUPLOAD |
| CHECKER_DT_STAMP | Checker_Dt_Stamp | DATE | 7 | PATB_BASISDEFUPLOAD |
| LASTMODIFIEDUSERID | Lastmodifieduserid | VARCHAR2 | 320 | PATB_BASISDEFUPLOAD |
| LASTMODIFIEDDATE | Lastmodifieddate | DATE | 7 | PATB_BASISDEFUPLOAD |
| MOD_NO | Mod_No | NUMBER | 22 | PATB_BASISDEFUPLOAD |
| RECORD_STAT | Record_Stat | CHAR | 1 | PATB_BASISDEFUPLOAD |
| ONCE_AUTH | Once_Auth | CHAR | 1 | PATB_BASISDEFUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_DERIVEDLOADUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATB_DERIVEDLOADUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_DERIVEDLOADUPLOAD |
| BULKCLIENT CODE | Bulkclient code | VARCHAR2 | 12 | PATB_DERIVEDLOADUPLOAD |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATB_DERIVEDLOADUPLOAD |
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATB_DERIVEDLOADUPLOAD |
| LOADID | Loadid | NUMBER | 5 | PATB_DERIVEDLOADUPLOAD |
| DESCRIPTION | Description | VARCHAR2 | 60 | PATB_DERIVEDLOADUPLOAD |
| PARENTLOADID | Parentloadid | VARCHAR2 | 6 | PATB_DERIVEDLOADUPLOAD |
| TOENTITYTYPE | Toentitytype | VARCHAR2 | 1 | PATB_DERIVEDLOADUPLOAD |
| TOENTITYID | Toentityid | VARCHAR2 | 12 | PATB_DERIVEDLOADUPLOAD |
| LOADPERCENTAGE | Loadpercentage | NUMBER | 5 | PATB_DERIVEDLOADUPLOAD |
| CRITERIA | Criteria | VARCHAR2 | 255 | PATB_DERIVEDLOADUPLOAD |
| FROMTABLES | Fromtables | VARCHAR2 | 20 | PATB_DERIVEDLOADUPLOAD |
| MANDATORY | Mandatory | NUMBER | 38 | PATB_DERIVEDLOADUPLOAD |
| PRIORITY | Priority | NUMBER | 38 | PATB_DERIVEDLOADUPLOAD |
| AMOUNTBASIS | Amountbasis | VARCHAR2 | 1 | PATB_DERIVEDLOADUPLOAD |
| CAPTOPARENTLOADAMOUNT | Captoparentloadamount | NUMBER | 30 | PATB_DERIVEDLOADUPLOAD |
| DIFFERENTIALLOAD | Differentialload | VARCHAR2 | 1 | PATB_DERIVEDLOADUPLOAD |
| DEPENDENTLOADID | Dependentloadid | VARCHAR2 | 6 | PATB_DERIVEDLOADUPLOAD |
| FDAPINCOME | Fdapincome | NUMBER | 1 | PATB_DERIVEDLOADUPLOAD |
Parent topic: Load Maintenance Upload