# reference_payment_entity

## Description

AKA "paid_by"; meant to replace signing_entity table

<details>
<summary><strong>Table Definition</strong></summary>

```sql
CREATE TABLE `reference_payment_entity` (
  `reference_payment_entity_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `payment_entity_name` varchar(180) COLLATE utf8mb4_general_ci NOT NULL,
  `country_of_tax_reporting` char(3) COLLATE utf8mb4_general_ci NOT NULL,
  `created_by` varchar(180) COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `last_modified_by` varchar(180) COLLATE utf8mb4_general_ci NOT NULL,
  `last_modified` datetime NOT NULL,
  PRIMARY KEY (`reference_payment_entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='AKA "paid_by"; meant to replace signing_entity table'
```

</details>

## Columns

| Name                        | Type               | Default | Nullable | Extra Definition | Children                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Parents | Comment |
| --------------------------- | ------------------ | ------- | -------- | ---------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- | ------- |
| country_of_tax_reporting    | char(3)            |         | false    |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |         |         |
| created_at                  | datetime           |         | false    |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |         |         |
| created_by                  | varchar(180)       |         | false    |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |         |         |
| last_modified               | datetime           |         | false    |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |         |         |
| last_modified_by            | varchar(180)       |         | false    |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |         |         |
| payment_entity_name         | varchar(180)       |         | false    |                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |         |         |
| reference_payment_entity_id | mediumint unsigned |         | false    | auto_increment   | [account_payment_term](account_payment_term.md) [account_payment_term_history](account_payment_term_history.md) [payment_entity_payoneer_program](payment_entity_payoneer_program.md) [reference_signing_entity](reference_signing_entity.md) [statement_period_payment_entity](statement_period_payment_entity.md) [worksheet_account_contract_closing_balance](worksheet_account_contract_closing_balance.md) [worksheet_account_contract_taxable_revenue](worksheet_account_contract_taxable_revenue.md) |         |         |

## Constraints

| Name    | Type        | Definition                                |
| ------- | ----------- | ----------------------------------------- |
| PRIMARY | PRIMARY KEY | PRIMARY KEY (reference_payment_entity_id) |

## Indexes

| Name    | Definition                                            |
| ------- | ----------------------------------------------------- |
| PRIMARY | PRIMARY KEY (reference_payment_entity_id) USING BTREE |

## Relations

![er](reference_payment_entity.svg)

---

> Generated by [tbls](https://github.com/k1LoW/tbls)