wallet_ledger

Modal

Field	Type	Nullable	Constraints
id	varchar
source_wallet_id	varchar		Foreign key (user wallet)
target_wallet_id	varchar		Foreign key (user wallet)
amount	int4
reason	varchar
ref_id	varchar
created_at	timestamp
updated_at	timestamp
amount_unit	varchar

Description of field

id

The primary key of the table.

source_wallet_id

Represents the user wallet in each wallet transaction.

target_wallet_id

Represents the bank wallet in each wallet transaction

amount

The amount involved in the wallet transaction. This is the same amount debited or credit to the user/bank wallet. A positive amount means the balance was credited to the user wallet and a negative amount means the balance was debited from the user wallet.

The sum of all wallet ledger entries for a specific wallet type for a user should always be equal to the current balance of that user wallet.

reason

The reason for which the wallet transaction occured. This often determines for which event/activity the wallet transaction was created for.

ref_id

This points to the short and specific data for the wallet transaction reason. Like the payout transaction id or payment transaction id or the UPI ID.

created_at

Timestamp when the wallet ledger entry was created.

updated_at

Timestamp when the wallet ledger entry was last updated.

amount_unit

This refers to the amount unit that was involved in the transaction. Default value is token. We are currently using INR for only payouts.