| Name | Description | Type | Additional information |
|---|---|---|---|
| id | integer |
None. |
|
| TSFILE_NUMBER | integer |
None. |
|
| A3P_THIRD_PARTY_ID | string |
None. |
|
| LOCATION_CODE | string |
None. |
|
| ACCT_NUMBER | string |
None. |
|
| TRANSACTION_NUMBER | string |
None. |
|
| CURRENT_DATE | date |
None. |
|
| CUSTOMER_NAME | string |
None. |
|
| SOCIAL_SECURITY_NUM | string |
None. |
|
| PRIMARY_BUSINESS_NAME | string |
None. |
|
| BUS_SOCIAL_SECURITY_NUM | string |
None. |
|
| ACTG_SYSTEM_ID | string |
None. |
|
| A3P_DATE_ASSIGNED | date |
None. |
|
| A3P_AMT_PLACED | decimal number |
None. |
|
| A3P_COMM_PERCENT | decimal number |
None. |
|
| A3P_ASGN_LAG_DATE | date |
None. |
|
| A3P_DATE_TO_BE_RECALLED | date |
None. |
|
| A3P_TSR_PERCENT | decimal number |
None. |
|
| A3P_TSR_AMT | decimal number |
None. |
|
| TOTAL_DELINQ_AMT | decimal number |
None. |
|
| OVERLIMIT_AMT | decimal number |
None. |
|
| INTEREST_RATE | decimal number |
None. |
|
| CURRENT_DUE_AMT | decimal number |
None. |
|
| TOTAL_DUE_AMT | decimal number |
None. |
|
| BALANCE_AMT | decimal number |
None. |
|
| ORIG_BALANCE_AMT | decimal number |
None. |
|
| PRINCIPAL_AMT | decimal number |
None. |
|
| DISPUTED_AMT | decimal number |
None. |
|
| INT_AND_LATE_CHG_AMT | decimal number |
None. |
|
| OTHER_AMT | decimal number |
None. |
|
| PAYMENT_AMT | decimal number |
None. |
|
| INTEREST_DELQ_AMT | decimal number |
None. |
|
| PRINCIPAL_DELQ_AMT | decimal number |
None. |
|
| TERMINATE_AMT | decimal number |
None. |
|
| SAT_USER_DEFINED_1 | string |
None. |
|
| OTH_DELQ_AMT | decimal number |
None. |
|
| DELINQ_AMT_BY_AGE_1 | decimal number |
None. |
|
| DELINQ_AMT_BY_AGE_3 | decimal number |
None. |
|
| REC_COST_1_AMT | decimal number |
None. |
|
| REC_COST_2_AMT | decimal number |
None. |
|
| REC_COST_3_AMT | decimal number |
None. |
|
| REC_COST_4_AMT | decimal number |
None. |
|
| REC_COST_5_AMT | decimal number |
None. |
|
| REC_COST_6_AMT | decimal number |
None. |
|
| REC_COST_7_AMT | decimal number |
None. |
|
| REC_COST_8_AMT | decimal number |
None. |
|
| REC_COST_9_AMT | decimal number |
None. |
|
| REC_COST_10_AMT | decimal number |
None. |
|
| REC_COST_11_AMT | decimal number |
None. |
|
| REC_COST_12_AMT | decimal number |
None. |
|
| REC_COST_13_AMT | decimal number |
None. |
|
| REC_COST_14_AMT | decimal number |
None. |
|
| REC_COST_15_AMT | decimal number |
None. |
|
| REC_COST_16_AMT | decimal number |
None. |
|
| REC_COST_17_AMT | decimal number |
None. |
|
| REC_COST_18_AMT | decimal number |
None. |
|
| REC_COST_19_AMT | decimal number |
None. |
|
| REC_COST_20_AMT | decimal number |
None. |
|
| REPOSSESSION_CHARGES | decimal number |
None. |
|
| BUDGET_PAYMENT_AMT | decimal number |
None. |
|
| LETTER_USER_DEFINED_8 | decimal number |
None. |
|
| ORIG_INTEREST_RATE | decimal number |
None. |
|
| NEXT_DUE_DATE | date |
None. |
|
| LAST_PAYMENT_DATE | date |
None. |
|
| LAST_PAYMENT_AMT | decimal number |
None. |
|
| DAYS_DELINQUENT_NUM | integer |
None. |
|
| CHARGE_OFF_AMOUNT | decimal number |
None. |
|
| CHARGE_OFF_DATE | date |
None. |
|
| ACCT_OPEN_DATE | date |
None. |
|
| LEGAL_STATE | string |
None. |
|
| REPOSSESSION_DATE | date |
None. |
|
| NUMBER_OF_CARDS | string |
None. |
|
| COL_COLLATERAL_CODE | string |
None. |
|
| COL_YEAR | integer |
None. |
|
| COL_MAKE | string |
None. |
|
| COL_MODEL | string |
None. |
|
| COL_VIN | string |
None. |
|
| COL_NEW_USED | string |
None. |
|
| REPO_SALES_PROCEEDS | decimal number |
None. |
|
| REPO_VOLUNTARY_IND | string |
None. |
|
| BANK_NUM | integer |
None. |
|
| ACCOUNT_TYPE | string |
None. |
|
| CACS_STATE_CODE | string |
None. |
|
| PLACEMENT_NUM | integer |
None. |
|
| PRB_DATE_OF_DEATH | date |
None. |
|
| D1P_COMMENT_LINE_1 | string |
None. |
|
| D1P_COMMENT_LINE_2 | string |
None. |
|
| D1P_COMMENT_LINE_3 | string |
None. |
|
| D1P_COMMENT_LINE_4 | string |
None. |
|
| D1P_COMMENT_LINE_5 | string |
None. |
|
| D1P_COMMENT_LINE_6 | string |
None. |
|
| D1P_COMMENT_LINE_7 | string |
None. |
|
| D1P_COMMENT_LINE_8 | string |
None. |
|
| D1P_COMMENT_LINE_9 | string |
None. |
|
| D1P_COMMENT_LINE_10 | string |
None. |
|
| CREATED_ON | date |
None. |
|
| UPDATED_ON | date |
None. |
|
| SAT_USER_DEFINED_2 | string |
None. |
|
| VALUE_CODE | string |
None. |
|
| tbl_new_account_210 | tbl_new_account_210 |
None. |