Appearance
Payment
payments.payment_transaction · every change is kept in the audit log · numbered PAY-{YYYY}-{########}
Fields
Every record also has id, created_at and updated_at.
| Field | Label | Type | Rules |
|---|---|---|---|
payment_order | payment order | link → payments.payment_order | required |
purpose | purpose | text | required; max 40 characters |
reference | reference | text | required; max 80 characters |
student | student | link → core.student | |
college | college | link → core.college | |
provider | provider | select | required; one of: CCAvenue, Razorpay, PayU, Offline |
payment_type | payment type | select | one of: Online, Offline; default "Online" |
mode | mode | text | max 60 characters |
tracking_id | tracking id | text | required; unique; max 80 characters |
bank_ref_no | bank ref no | text | max 80 characters |
gateway_status | gateway status | text | max 40 characters |
status | status | select | one of: Success, Failure, Reversed, Refunded; default "Success" |
currency | currency | select | one of: INR; default "INR" |
amount | amount | money | required; min 0 |
extra_amount | extra amount | money | default 0; min 0 |
college_share | college share | money | default 0 |
gateway_charges | gateway charges | money | default 0 |
platform_share | platform share | money | default 0 |
settlement_account | settlement account | link → payments.settlement_account | |
split_status | split status | select | one of: Pending, Done, Stopped, Not applicable; default "Pending" |
refund_status | refund status | select | one of: None, Pending, Done; default "None" |
paid_at | paid at | datetime | required |
payer_name | payer name | text | personal data; max 140 characters |
payer_email | payer email | personal data | |
payer_phone | payer phone | phone | personal data |
billing_address | billing address | longtext | personal data; max 1000 characters |
recorded_by | recorded by | link → core.user | |
remarks | remarks | longtext | max 2000 characters |
event_delivered | event delivered | check | default false |
delivery_attempts | delivery attempts | number | default 0; min 0 |
active | active | check | default true |
Permissions
| Role | Can |
|---|---|
payments:admin | read, create, update |
payments:finance | read, create, update |
payments:viewer | read |
payments:payer | read — only own rows (via student) |
API
http
GET /api/payments/payment_transaction?<field>=<value>&limit=100&offset=0
POST /api/payments/payment_transaction
GET /api/payments/payment_transaction/:id
PATCH /api/payments/payment_transaction/:id
DELETE /api/payments/payment_transaction/:id