NameDescriptionTypeAdditional 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.

OrganizationId

integer

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

integer

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.

Status

string

None.

SAT_USER_DEFINED_2

string

None.

VALUE_CODE

string

None.

tbl_account_basic_update_800

Collection of tbl_account_basic_update_800

None.

tbl_bankruptcy_details_214

Collection of tbl_bankruptcy_details_214

None.

tbl_borrower_person_info_211

Collection of tbl_borrower_person_info_211

None.

tbl_CaseImage

Collection of tbl_CaseImage

None.

tbl_charge_off_transaction_900

Collection of tbl_charge_off_transaction_900

None.

tbl_deactivate_recall_910

Collection of tbl_deactivate_recall_910

None.

tbl_Events

Collection of tbl_Events

None.

tbl_financial_refresh_110

Collection of tbl_financial_refresh_110

None.

tbl_new_account_2101

tbl_new_account_210

None.

tbl_new_account_2102

tbl_new_account_210

None.

tbl_organizations

tbl_organizations

None.

tbl_payment_nfs_700

Collection of tbl_payment_nfs_700

None.

tbl_payment_transaction_300

Collection of tbl_payment_transaction_300

None.

tbl_status_change_400

Collection of tbl_status_change_400

None.