OnlineDumpInput
Table Name: online_dump_inputs
Columns
| Name | Type | Nullable | Primary Key | Default |
|---|---|---|---|---|
id |
INTEGER |
False | Yes | None |
agreement_no |
VARCHAR |
False | No | None |
amount |
FLOAT |
True | No | None |
date |
DATE |
True | No | None |
status |
VARCHAR |
True | No | None |
product_code |
VARCHAR |
True | No | None |
month |
INTEGER |
True | No | None |
year |
INTEGER |
True | No | None |
file_ingestion_id |
UUID |
True | No | None |
ingestion_cycle_id |
INTEGER |
True | No | None |
cycle_code |
VARCHAR(50) |
True | No | None |
payout_category |
VARCHAR(128) |
True | No | None |
payout_functions |
ARRAY |
True | No | None |
payout_calculation_status |
VARCHAR(10) |
False | No | ScalarElementColumnDefault('pending') |
payout_calculation_metadata |
JSONB |
True | No | None |
payout_recipient_id |
VARCHAR(255) |
True | No | None |
last_calculated_at |
DATETIME |
True | No | None |
created_by |
VARCHAR(128) |
True | No | None |
created_at |
DATETIME |
False | No | None |
created_by_role |
VARCHAR(50) |
True | No | None |
checked_by |
VARCHAR(128) |
True | No | None |
checked_at |
DATETIME |
True | No | None |
checker_status |
VARCHAR(50) |
True | No | None |
checker_remarks |
TEXT |
True | No | None |
approved_by |
VARCHAR(128) |
True | No | None |
approved_at |
DATETIME |
True | No | None |
approver_status |
VARCHAR(50) |
True | No | None |
approver_remarks |
TEXT |
True | No | None |
last_updated_by |
VARCHAR(128) |
True | No | None |
last_updated_at |
DATETIME |
False | No | None |
audit_version |
INTEGER |
True | No | ScalarElementColumnDefault(1) |
audit_action |
VARCHAR(50) |
True | No | None |
Data Filters
Active Filters:
Data Records
| id | agreement_no | amount | date | status | product_code | month | year | file_ingestion_id | ingestion_cycle_id | cycle_code | payout_category | payout_functions | payout_calculation_status | payout_calculation_metadata | payout_recipient_id | last_calculated_at | created_by | created_at | created_by_role | checked_by | checked_at | checker_status | checker_remarks | approved_by | approved_at | approver_status | approver_remarks | last_updated_by | last_updated_at | audit_version | audit_action |
|---|
Showing 1-0 of 0
Relationships
This model has no defined relationships.
SimPay