Description:
Records payment transactions linked to rentals. Each entry captures the amount, type of payment, and when it was created.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the payment record. |
rental_id |
NUMBER | Identifier of the rental associated with the payment. |
amount |
NUMBER | Amount of the payment. |
type |
NUMBER | Type of payment (0 => BOOKING_PICKUP, 1 => END_RENTAL, 2 => BOOKING_PROLONG). |
type_name |
TEXT | String label for type. |
created_at |
TIMESTAMP_TZ | Timestamp when the payment record was created. |
_snowflake_inserted_at |
TIMESTAMP_NTZ | System timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | System timestamp when the record was last updated in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |