CLMS_ARLBALS
Description
Synonyms
SDSNZP02_BANK..EFS_CLMS_ARLBALS
SDSNZP02_BANK..NROD_CLMS_ARLBALS
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ACTION_CODE | CHARACTER VARYING(1) | 1 |
| 2 | ACCOUNT | INTEGER | 4 |
| 3 | BASERATE | NUMERIC(14,3) | 19 |
| 4 | EFFRATE | NUMERIC(14,3) | 19 |
| 5 | YLDRATE | NUMERIC(9,3) | 19 |
| 6 | MARGIN | NUMERIC(9,3) | 19 |
| 7 | PENAMT | NUMERIC(15,2) | 19 |
| 8 | MANINBA | TIMESTAMP | 8 |
| 9 | INBASTS | INTEGER | 4 |
| 10 | INBAPEDATE | TIMESTAMP | 8 |
| 11 | OOIDATE | TIMESTAMP | 8 |
| 12 | ARINSTCNT | INTEGER | 4 |
| 13 | ARDAYS | INTEGER | 4 |
| 14 | EXPDTE | TIMESTAMP | 8 |
| 15 | EXPBLN | NUMERIC(19,2) | 19 |
| 16 | CAPBAL | NUMERIC(19,2) | 19 |
| 17 | CURBAL | NUMERIC(19,2) | 19 |
| 18 | DPBAL | NUMERIC(19,2) | 19 |
| 19 | PLIM | NUMERIC(19,2) | 19 |
| 20 | GLIM | NUMERIC(19,2) | 19 |
| 21 | DRAWN | NUMERIC(19,2) | 19 |
| 22 | CAPLIM | NUMERIC(19,2) | 19 |
| 23 | CAPPED | NUMERIC(19,2) | 19 |
| 24 | GUARVAL | NUMERIC(19,2) | 19 |
| 25 | AUTHCODE | INTEGER | 4 |
| 26 | AUTHNO | INTEGER | 4 |
| 27 | BABFDD | INTEGER | 4 |
| 28 | BABFFEE | CHARACTER VARYING(4) | 4 |
| 29 | LFEEDATE | TIMESTAMP | 8 |
| 30 | NFEEDATE | TIMESTAMP | 8 |
| 31 | LFRATE | NUMERIC(9,3) | 19 |
| 32 | NEGRATE | NUMERIC(9,3) | 19 |
| 33 | NEINSTAAMNT | NUMERIC(19,2) | 19 |
| 34 | NEINSTADATE | TIMESTAMP | 8 |
| 35 | NESPECINSTAAMNT | NUMERIC(19,2) | 19 |
| 36 | NXTSPECINSTADT | TIMESTAMP | 8 |
| 37 | TOTLIMIT | NUMERIC(19,2) | 19 |
| 38 | INBABAL | NUMERIC(19,2) | 19 |
| 39 | WOBAL | NUMERIC(19,2) | 19 |
| 40 | INTABAL | NUMERIC(19,2) | 19 |
| 41 | ACINTABAL | NUMERIC(19,2) | 19 |
| 42 | UCOSBAL | NUMERIC(19,2) | 19 |
| 43 | UCOSBAL1 | NUMERIC(19,2) | 19 |
| 44 | UCOSBAL2 | NUMERIC(19,2) | 19 |
| 45 | UCOSBAL3 | NUMERIC(19,2) | 19 |
| 46 | UCOSBAL4 | NUMERIC(19,2) | 19 |
| 47 | UCOSBAL5 | NUMERIC(19,2) | 19 |
| 48 | UCOSBAL6 | NUMERIC(19,2) | 19 |
| 49 | UCOSBAL7 | NUMERIC(19,2) | 19 |
| 50 | UCOSBAL8 | NUMERIC(19,2) | 19 |
| 51 | UCOSBAL9 | NUMERIC(19,2) | 19 |
| 52 | GSTACBAL | NUMERIC(19,2) | 19 |
| 53 | CMINT | NUMERIC(19,2) | 19 |
| 54 | CMCAPTINT | NUMERIC(19,2) | 19 |
| 55 | LCAPBAL | NUMERIC(19,2) | 19 |
| 56 | LCAPDATE | TIMESTAMP | 8 |
| 57 | CURRINSAFRQMNTH | INTEGER | 4 |
| 58 | ARREAR_AMNT_0_1_MNTH | NUMERIC(19,2) | 19 |
| 59 | ARREAR_AMNT_1_2_MNTH | NUMERIC(19,2) | 19 |
| 60 | ARREAR_AMNT_2_3_MNTH | NUMERIC(19,2) | 19 |
| 61 | ARREAR_AMNT_3_4_MNTH | NUMERIC(19,2) | 19 |
| 62 | ARREAR_AMNT_4_5_MNTH | NUMERIC(19,2) | 19 |
| 63 | ARREAR_AMNT_5_6_MNTH | NUMERIC(19,2) | 19 |
| 64 | ARREAR_AMNT_6_PLUS_MNTH | NUMERIC(19,2) | 19 |
| 65 | TOT_ARREAR_AMNT | NUMERIC(19,2) | 19 |
| 66 | TOT_OUT_FEE_AMNT | NUMERIC(19,2) | 19 |
| 67 | OLD_ARREAR_GRAD_CDE | INTEGER | 4 |
| 68 | AMU_FLAG | CHARACTER VARYING(1) | 1 |
| 69 | UNDRAWN_AMNT | NUMERIC(19,2) | 19 |
| 70 | CURRBABFV | NUMERIC(19,2) | 19 |
| 71 | DUEDAY | CHARACTER VARYING(2) | 2 |
| 72 | LDDDATE | TIMESTAMP | 8 |
| 73 | COMCYCLE | INTEGER | 4 |
| 74 | LENDDATE | TIMESTAMP | 8 |
| 75 | CENDDATE | TIMESTAMP | 8 |
| 76 | ODIMARG | NUMERIC(19,2) | 19 |
| 77 | HIGHMARG | NUMERIC(19,2) | 19 |
| 78 | CONARDAYS | INTEGER | 4 |
| 79 | DATA_DATE | TIMESTAMP | 8 |
| 80 | LOAD_ID | INTEGER | 4 |
| 81 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 82 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 83 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 84 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |