CollectionTimeSeries
Table Name: collection_timeseries
Columns
| Name | Type | Nullable | Primary Key | Default |
|---|---|---|---|---|
id |
BIGINT |
False | Yes | None |
payout_cycle_master_code |
VARCHAR(100) |
False | No | None |
agreement_no |
VARCHAR(100) |
False | No | None |
agency_code |
VARCHAR(50) |
False | No | None |
receipt_no |
VARCHAR(100) |
True | No | None |
collection_date |
DATE |
False | No | None |
collection_amount |
NUMERIC(15, 2) |
False | No | None |
mode_of_payment |
VARCHAR(50) |
True | No | None |
receipts_status |
VARCHAR(100) |
True | No | None |
source_table |
VARCHAR(100) |
True | No | None |
source_record_id |
BIGINT |
True | No | None |
created_at |
DATETIME |
False | No | CallableColumnDefault(<function datetime.utcnow at 0x74c88c49d440>) |
updated_at |
DATETIME |
True | No | None |
Data Filters
Active Filters:
Data Records
| id | payout_cycle_master_code | agreement_no | agency_code | receipt_no | collection_date | collection_amount | mode_of_payment | receipts_status | source_table | source_record_id | created_at | updated_at |
|---|
Showing 1-0 of 0
Relationships
This model has no defined relationships.
SimPay