CLMS_ARTRANS
Description
Synonyms
SDSNZP02_BANK..EFS_CLMS_ARTRANS
SDSNZP02_BANK..NROD_CLMS_ARTRANS
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ID | BIGINT | 8 |
| 2 | ACTION_CODE | CHARACTER VARYING(1) | 1 |
| 3 | ACCOUNT | INTEGER | 4 |
| 4 | SEQMTH | INTEGER | 4 |
| 5 | TRNO | INTEGER | 4 |
| 6 | TTYPE | INTEGER | 4 |
| 7 | XTTYPE | INTEGER | 4 |
| 8 | CLFLAG | INTEGER | 4 |
| 9 | EDATE | TIMESTAMP | 8 |
| 10 | PDATE | TIMESTAMP | 8 |
| 11 | PTIME | CHARACTER VARYING(8) | 8 |
| 12 | PIND | CHARACTER VARYING(1) | 1 |
| 13 | TVAL | NUMERIC(19,2) | 19 |
| 14 | REASON | INTEGER | 4 |
| 15 | TGROUP | INTEGER | 4 |
| 16 | CAPBAL | NUMERIC(19,2) | 19 |
| 17 | CURBAL | NUMERIC(19,2) | 19 |
| 18 | WOBAL | NUMERIC(19,2) | 19 |
| 19 | INBABAL | NUMERIC(19,2) | 19 |
| 20 | INTABAL | NUMERIC(19,2) | 19 |
| 21 | UCOSBAL | NUMERIC(19,2) | 19 |
| 22 | DPBAL | NUMERIC(19,2) | 19 |
| 23 | PLIM | NUMERIC(19,2) | 19 |
| 24 | GLIM | NUMERIC(19,2) | 19 |
| 25 | DRAWN | NUMERIC(19,2) | 19 |
| 26 | CAPLIM | NUMERIC(19,2) | 19 |
| 27 | CAPPED | NUMERIC(19,2) | 19 |
| 28 | GUARVAL | NUMERIC(19,2) | 19 |
| 29 | UCOSBAL1 | NUMERIC(19,2) | 19 |
| 30 | UCOSBAL2 | CHARACTER VARYING(16) | 16 |
| 31 | UCOSBAL3 | CHARACTER VARYING(16) | 16 |
| 32 | UCOSBAL4 | CHARACTER VARYING(16) | 16 |
| 33 | UCOSBAL5 | CHARACTER VARYING(16) | 16 |
| 34 | UCOSBAL6 | CHARACTER VARYING(16) | 16 |
| 35 | UCOSBAL7 | CHARACTER VARYING(16) | 16 |
| 36 | UCOSBAL8 | CHARACTER VARYING(16) | 16 |
| 37 | UCOSBAL9 | CHARACTER VARYING(16) | 16 |
| 38 | ASSETVAL | NUMERIC(19,2) | 19 |
| 39 | OCOSTADJ | NUMERIC(19,2) | 19 |
| 40 | ODLIMADJ | NUMERIC(19,2) | 19 |
| 41 | GSTACBAL | NUMERIC(19,2) | 19 |
| 42 | FEE | CHARACTER VARYING(4) | 4 |
| 43 | CALCAMT | NUMERIC(19,2) | 19 |
| 44 | WAIVER | INTEGER | 4 |
| 45 | SUPWDESC | CHARACTER VARYING(20) | 20 |
| 46 | DDCODE | INTEGER | 4 |
| 47 | TNARR1 | CHARACTER VARYING(20) | 20 |
| 48 | TNARR2 | CHARACTER VARYING(20) | 20 |
| 49 | TELLER | CHARACTER VARYING(8) | 8 |
| 50 | BRANCH | INTEGER | 4 |
| 51 | PAYMETH | CHARACTER VARYING(1) | 1 |
| 52 | SOURCE | CHARACTER VARYING(2) | 2 |
| 53 | DATA_DATE | TIMESTAMP | 8 |
| 54 | LOAD_ID | INTEGER | 4 |
| 55 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 56 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 57 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 58 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |