# worksheet_payment_contract_advance

## Description

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

```sql
CREATE TABLE `worksheet_payment_contract_advance` (
  `worksheet_payment_contract_advance_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `contract_advance_id` mediumint unsigned NOT NULL,
  `statement_period_id` mediumint unsigned NOT NULL,
  `exchange_rate_statement_period_id` mediumint unsigned NOT NULL,
  `payment_name` varchar(180) COLLATE utf8mb4_general_ci NOT NULL,
  `amount` decimal(20,2) NOT NULL,
  `currency_code` char(3) COLLATE utf8mb4_general_ci NOT NULL,
  `amount_payee_currency` decimal(20,2) NOT NULL,
  `payee_currency_code` char(3) COLLATE utf8mb4_general_ci NOT NULL,
  `exchange_rate` decimal(30,19) NOT NULL,
  `withholding_tax_amount` decimal(20,2) NOT NULL,
  `vat_amount` decimal(20,2) NOT NULL,
  `amount_after_withholding_and_vat` decimal(20,2) NOT NULL,
  `withholding_tax_amount_payee_currency` decimal(20,2) NOT NULL,
  `vat_amount_payee_currency` decimal(20,2) NOT NULL,
  `amount_after_withholding_and_vat_payee_currency` decimal(20,2) NOT NULL,
  `us_source_income_rate` decimal(9,6) unsigned DEFAULT NULL,
  `salesforce_id` varchar(180) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_internal` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL,
  `created_by` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `last_modified` datetime NOT NULL,
  `last_modified_by` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`worksheet_payment_contract_advance_id`),
  KEY `fk_contract_advance` (`contract_advance_id`),
  KEY `fk_statement_period` (`statement_period_id`),
  KEY `fk_exchange_rate_statement_period_id` (`exchange_rate_statement_period_id`),
  CONSTRAINT `fk_contract_advance` FOREIGN KEY (`contract_advance_id`) REFERENCES `contract_advance` (`contract_advance_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_exchange_rate_statement_period_id` FOREIGN KEY (`exchange_rate_statement_period_id`) REFERENCES `statement_period` (`statement_period_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_statement_period` FOREIGN KEY (`statement_period_id`) REFERENCES `statement_period` (`statement_period_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
```

</details>

## Columns

| Name                                            | Type                  | Default | Nullable | Extra Definition | Children                                                              | Parents                                 | Comment |
| ----------------------------------------------- | --------------------- | ------- | -------- | ---------------- | --------------------------------------------------------------------- | --------------------------------------- | ------- |
| amount                                          | decimal(20,2)         |         | false    |                  |                                                                       |                                         |         |
| amount_after_withholding_and_vat                | decimal(20,2)         |         | false    |                  |                                                                       |                                         |         |
| amount_after_withholding_and_vat_payee_currency | decimal(20,2)         |         | false    |                  |                                                                       |                                         |         |
| amount_payee_currency                           | decimal(20,2)         |         | false    |                  |                                                                       |                                         |         |
| contract_advance_id                             | mediumint unsigned    |         | false    |                  |                                                                       | [contract_advance](contract_advance.md) |         |
| created_at                                      | datetime              |         | false    |                  |                                                                       |                                         |         |
| created_by                                      | varchar(255)          |         | false    |                  |                                                                       |                                         |         |
| currency_code                                   | char(3)               |         | false    |                  |                                                                       |                                         |         |
| deleted_at                                      | datetime              |         | true     |                  |                                                                       |                                         |         |
| deleted_by                                      | varchar(255)          |         | true     |                  |                                                                       |                                         |         |
| exchange_rate                                   | decimal(30,19)        |         | false    |                  |                                                                       |                                         |         |
| exchange_rate_statement_period_id               | mediumint unsigned    |         | false    |                  |                                                                       | [statement_period](statement_period.md) |         |
| is_internal                                     | tinyint(1)            | 0       | false    |                  |                                                                       |                                         |         |
| last_modified                                   | datetime              |         | false    |                  |                                                                       |                                         |         |
| last_modified_by                                | varchar(255)          |         | false    |                  |                                                                       |                                         |         |
| payee_currency_code                             | char(3)               |         | false    |                  |                                                                       |                                         |         |
| payment_name                                    | varchar(180)          |         | false    |                  |                                                                       |                                         |         |
| salesforce_id                                   | varchar(180)          |         | true     |                  |                                                                       |                                         |         |
| statement_period_id                             | mediumint unsigned    |         | false    |                  |                                                                       | [statement_period](statement_period.md) |         |
| us_source_income_rate                           | decimal(9,6) unsigned |         | true     |                  |                                                                       |                                         |         |
| vat_amount                                      | decimal(20,2)         |         | false    |                  |                                                                       |                                         |         |
| vat_amount_payee_currency                       | decimal(20,2)         |         | false    |                  |                                                                       |                                         |         |
| withholding_tax_amount                          | decimal(20,2)         |         | false    |                  |                                                                       |                                         |         |
| withholding_tax_amount_payee_currency           | decimal(20,2)         |         | false    |                  |                                                                       |                                         |         |
| worksheet_payment_contract_advance_id           | mediumint unsigned    |         | false    | auto_increment   | [ledger_contract_advance_applied](ledger_contract_advance_applied.md) |                                         |         |

## Constraints

| Name                                 | Type        | Definition                                                                                        |
| ------------------------------------ | ----------- | ------------------------------------------------------------------------------------------------- |
| PRIMARY                              | PRIMARY KEY | PRIMARY KEY (worksheet_payment_contract_advance_id)                                               |
| fk_contract_advance                  | FOREIGN KEY | FOREIGN KEY (contract_advance_id) REFERENCES contract_advance (contract_advance_id)               |
| fk_exchange_rate_statement_period_id | FOREIGN KEY | FOREIGN KEY (exchange_rate_statement_period_id) REFERENCES statement_period (statement_period_id) |
| fk_statement_period                  | FOREIGN KEY | FOREIGN KEY (statement_period_id) REFERENCES statement_period (statement_period_id)               |

## Indexes

| Name                                 | Definition                                                                               |
| ------------------------------------ | ---------------------------------------------------------------------------------------- |
| PRIMARY                              | PRIMARY KEY (worksheet_payment_contract_advance_id) USING BTREE                          |
| fk_contract_advance                  | KEY fk_contract_advance (contract_advance_id) USING BTREE                                |
| fk_exchange_rate_statement_period_id | KEY fk_exchange_rate_statement_period_id (exchange_rate_statement_period_id) USING BTREE |
| fk_statement_period                  | KEY fk_statement_period (statement_period_id) USING BTREE                                |

## Relations

![er](worksheet_payment_contract_advance.svg)

---

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