| Name | Description | Type | Additional information |
|---|---|---|---|
| id | integer |
None. |
|
| TSFILE_NUMBER | integer |
None. |
|
| THIRD_PARTY_ID | string |
None. |
|
| LOCATION_CODE | string |
None. |
|
| ACCT_NUM | string |
None. |
|
| TRANSACTION_NUMBER | integer |
None. |
|
| TRANSACTION_DATE | date |
None. |
|
| NAME_RELATIONSHIP | string |
None. |
|
| ADDRESS_RELATIONSHIP | string |
None. |
|
| DEMOG_NAME | string |
None. |
|
| FIRST_NAME | string |
None. |
|
| MIDDLE_NAME | string |
None. |
|
| LAST_NAME | string |
None. |
|
| MATERNAL | string |
None. |
|
| PREFIX | string |
None. |
|
| SUFFIX | string |
None. |
|
| ADDRESS_1 | string |
None. |
|
| ADDRESS_2 | string |
None. |
|
| ADDRESS_3 | string |
None. |
|
| CITY | string |
None. |
|
| STATE | string |
None. |
|
| ZIP | string |
None. |
|
| COUNTY | string |
None. |
|
| ISO_COUNTRY_CODE | string |
None. |
|
| EMAIL_ADDRESS | string |
None. |
|
| TELEPHONE_1 | string |
None. |
|
| TELEPHONE_2 | string |
None. |
|
| TELEPHONE_3 | string |
None. |
|
| PHONE_TYPE_1 | string |
None. |
|
| PHONE_AVAIL_CODE_1 | string |
None. |
|
| PHONE_TYPE_2 | string |
None. |
|
| PHONE_AVAIL_CODE_2 | string |
None. |
|
| PHONE_TYPE_3 | string |
None. |
|
| PHONE_AVAIL_CODE_3 | string |
None. |
|
| BLOCK_CODE | string |
None. |
|
| MEMO_LINE | string |
None. |
|
| LANG_PREFERENCE_CODE | string |
None. |
|
| DEM_UD_STATUS_2 | string |
None. |
|
| DATE_LAST_UPDATED | date |
None. |
|
| CREATED_ON | date |
None. |
|
| UPDATED_ON | date |
None. |
|
| TRANSACTION_CODE | string |
None. |
|
| CONTACT_ID | string |
None. |
|
| CONTACT_RECORD_TYPE_ | string |
None. |
|
| LEAD_CONTACT_IND | string |
None. |
|
| RESPONSIBLE_PARTY | string |
None. |
|
| PREFERRED_CURRENCY | string |
None. |
|
| tbl_new_account_210 | tbl_new_account_210 |
None. |