Settlement (Payout)

payments.settlement

Fields

Every record also has id, created_at and updated_at.

Field	Label	Type	Rules
pay_id	pay id	text	required; unique; max 80 characters
utr_no	utr no	text	required; unique; max 80 characters
settlement_date	settlement date	date	required
settlement_account	settlement account	link → payments.settlement_account
amount	amount	money	required
settlement_currency	settlement currency	select	one of: INR; default "INR"
transaction_currency	transaction currency	select	one of: INR; default "INR"
settlement_bank	settlement bank	text	max 140 characters
ifsc_code	ifsc code	text	max 11 characters
account_number_last4	account number last4	text	max 4 characters
reconciled	reconciled	check	default false

Permissions

Role	Can
payments:admin	read, update
payments:finance	read, update
payments:viewer	read

API

GET    /api/payments/settlement?<field>=<value>&limit=100&offset=0
POST   /api/payments/settlement
GET    /api/payments/settlement/:id
PATCH  /api/payments/settlement/:id
DELETE /api/payments/settlement/:id