app.org_legal_entities_masked
View
Live org legal entities with the Restricted tax identifier decrypted for holders of data.restricted.read.tax and masked (NULL with is_masked true) for everyone else (Section 8.3). Rows are limited to orgs where the caller reads settings.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Legal entity. |
| org_id | uuid | Yes | Owning org. |
| legal_name | text | Yes | Registered legal name. |
| country_code | character(2) | Yes | Country of registration. |
| tax_identifier | text | Yes | Tax identifier in plain text for holders of data.restricted.read.tax; NULL when masked or not recorded. |
| tax_identifier_last4 | text | Yes | Last four characters of the tax identifier. |
| is_masked | boolean | Yes | True when a tax identifier is recorded but the caller may not read it. |
| fiscal_year_start_month | smallint | Yes | Month the fiscal year starts. |
| base_currency | character(3) | Yes | Currency the entity keeps its books in. |
| is_primary | boolean | Yes | True for the org's primary entity. |
| created_at | timestamp with time zone | Yes | When the entity was added. |
| created_by | uuid | Yes | Person who added it. |
| updated_at | timestamp with time zone | Yes | When it last changed. |
| updated_by | uuid | Yes | Person who last changed it. |