Table
creditactions
Each row represents a ledger line for a credit movement, including amounts, initiators, and source/target accounts.
Redshift
All tables
creditactions
Each row represents a ledger line for a credit movement, including amounts, initiators, and source/target accounts.
Full schema
View all columns and table relationships (SchemaSpy)Status group
No, this table does not include a statusgroup column.
Column details
| Column | Type |
|---|---|
id | varchar(36) |
companyid | varchar(36) |
clientid | varchar(36) |
action | varchar(65535) |
target | varchar(36) |
targettype | varchar(65535) |
initiator | varchar(36) |
initiatortype | varchar(65535) |
source | varchar(36) |
sourcetype | varchar(65535) |
timestamp | timestamp |
updatedat | timestamp |
amount | float8 |
targetbalancein | float8 |
targetbalanceout | float8 |
sourcebalancein | float8 |
sourcebalanceout | float8 |
creditaccountname | varchar(4096) |
Column names and types come from the Redshift analytics schema. SchemaSpy is authoritative for nullability, defaults, keys, and relationships.
Sample query
select
t.clientid,
t.action,
t.target,
t.targettype,
t.initiator
from creditactions as t
limit 100