CollectionTimeSeries

Run Query

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
Relationships

This model has no defined relationships.