order_id
: Unique transaction identifier.
account_id
: Links the transaction to a user account.
timestamp
: Time of transaction.
payment_id
: Unique payment identifier.
order_id
: Links the payment to a specific order.
timestamp
: Time of payment.
outstanding_amt
: Remaining balance for the order.
account_id
: Unique account identifier.
payments
table must include an initial payment record for each order with outstanding_amt = order_value
.
fraud_label
is a boolean column (1 = fraudulent, 0 = legitimate, None = pending prediction).