ext_bnk_crai_credit_card_transaction_v
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | transaction_id | character varying | 33 |
| 2 | account_id_number | character varying | 512 |
| 3 | source_system_code | character varying | 12 |
| 4 | transaction_code | character varying | 18 |
| 5 | transaction_code_description | character varying | 768 |
| 6 | transaction_posting_date | timestamp without time zone | |
| 7 | transaction_type | text | |
| 8 | transaction_amount | numeric | 18 |
| 9 | original_currency_code | character varying | 72 |
| 10 | original_currency_amount | numeric | 20 |
| 11 | merchant_name | character varying | 300 |
| 12 | merchant_category_code | character varying | 15 |
| 13 | monthend_date | date |