CustomerProfileView

View Detailing platform usage and consumption

ColumnTypeDescription
_pkSTRINGMetadata
_last_updateTIMESTAMPMetadata
company_idSTRINGComapany unique ID (Your company)
dateTIMESTAMPDate of the usage/consumption
user_nameSTRINGUsername that created the consumption
branch_nameSTRINGBrach to which the consumption belongs
client_nameSTRINGName of the person/company being analysed
client_documentSTRINGDocument of the person/company being analysed
client_ageINTAge of the client at the moment of record
suspect_casesINTNumber of suspect repports for that client
lawsuit_ammountINTNumber of lawsuits returned as defendant
criminallawsuit_ammountINTNumber of criminal lawsuits returned as defendant
administrative_proceedings_ammountINTNumber of administrative proceedings (COMPROT) returned
protests_valueFLOATTotal value of protest collections (in R$)
arrest_warrants_ammountINTNumber of arrest warrants issued
credit_score_1INTCredit score from the Simple Analysis
credit_score_2INTCredit score from the Advanced Analysis
total_debts_1FLOATTotal debts (R$) from the Simple Analysis
total_debts_2FLOATTotal debts (R$) from the Simple Analysis
statusSTRINGEvaluation status ( APPROVED | DISAPPROVED ...)