INT_HOG_NROD_ODS_TRANSACTIONS
Description
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | SRC_CO_CODE | BIGINT | 8 |
| 2 | SRC_PD_TP_CODE | CHARACTER VARYING(3) | 3 |
| 3 | AR_ID | BIGINT | 8 |
| 4 | POSTING_DATE | TIMESTAMP | 8 |
| 5 | POSTING_TIME | CHARACTER VARYING(8) | 8 |
| 6 | SRC_TXN_CODE | INTEGER | 4 |
| 7 | ODS_TXN_SEQ_NBR | INTEGER | 4 |
| 8 | CHK_NBR | BIGINT | 8 |
| 9 | AMOUNT | NUMERIC(13,2) | 19 |
| 10 | ATHR_CODE | CHARACTER VARYING(9) | 9 |
| 11 | TFR_AC_NBR_CODE | CHARACTER VARYING(20) | 20 |
| 12 | TFR_AC_NBR_CODE_STR | CHARACTER VARYING(20) | 20 |
| 13 | TFR_APL_ID | INTEGER | 4 |
| 14 | NETW_DEVICE_ID | CHARACTER VARYING(8) | 8 |
| 15 | DATA_DATE | TIMESTAMP | 8 |
| 16 | CASH_AMT | NUMERIC(13,2) | 19 |
| 17 | CHK_AMT | NUMERIC(13,2) | 19 |
| 18 | TFR_AMT | NUMERIC(13,2) | 19 |
| 19 | OTHR_AMT | NUMERIC(13,2) | 19 |
| 20 | BRANCH_NO | INTEGER | 4 |
| 21 | TXN_CHANNEL_CODE | CHARACTER VARYING(4) | 4 |