hog_tcs_hst_txndaily
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | id | bigint | 64 |
| 2 | action_code | character varying | 3 |
| 3 | key_coid | numeric | 5 |
| 4 | key_prod | character varying | 9 |
| 5 | cntl_acct_num | character varying | 30 |
| 6 | effective_date | character varying | 30 |
| 7 | detail_acct_num | character varying | 48 |
| 8 | transaction_code | numeric | 3 |
| 9 | amount | numeric | 13 |
| 10 | posting_date | character varying | 30 |
| 11 | reference_description | character varying | 123 |
| 12 | tran_creation_date | character varying | 30 |
| 13 | original_currency_code | character varying | 9 |
| 14 | original_currency_amount | numeric | 13 |
| 15 | merch_name | character varying | 75 |
| 16 | mcc_code | numeric | 5 |
| 17 | data_date | timestamp without time zone | |
| 18 | load_id | numeric | 4 |