|
id
|
char(36)
|
|
|
|
|
name
|
varchar(255)
|
|
|
|
|
date_entered
|
datetime
|
|
|
|
|
date_modified
|
datetime
|
|
|
|
|
modified_user_id
|
char(36)
|
|
|
|
|
created_by
|
char(36)
|
|
|
|
|
description
|
text
|
|
|
|
|
deleted
|
tinyint(1)
|
|
|
0
|
|
assigned_user_id
|
char(36)
|
|
|
|
|
collection_number
|
varchar(30)
|
|
|
|
|
contract_id
|
char(36)
|
|
|
|
|
payment_direction
|
varchar(30)
|
|
|
receivable
|
|
payment_method
|
varchar(30)
|
|
|
|
|
currency_id
|
char(36)
|
|
|
-99
|
|
receivable_amount
|
decimal(26,6)
|
|
|
|
|
actual_amount
|
decimal(26,6)
|
|
|
|
|
overdue_time
|
datetime
|
|
|
|
|
received_time
|
datetime
|
|
|
|
|
collection_status
|
varchar(30)
|
|
|
not_completed
|