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