# worksheet_account_contract_payable_after_tax ## Description
Table Definition ```sql CREATE TABLE `worksheet_account_contract_payable_after_tax` ( `worksheet_account_contract_payable_after_tax_id` mediumint unsigned NOT NULL AUTO_INCREMENT, `worksheet_account_contract_closing_balance_id` mediumint unsigned NOT NULL, `contract_id` mediumint unsigned NOT NULL, `account_id` mediumint unsigned NOT NULL, `statement_period_id` mediumint unsigned NOT NULL, `abacus_event_id` mediumint unsigned NOT NULL, `payable_amount_pre_tax` decimal(20,2) NOT NULL, `tax_withholding_amount` decimal(20,2) DEFAULT NULL, `vat_amount` decimal(20,2) DEFAULT NULL, `payable_amount_post_tax` decimal(20,2) NOT NULL, `currency_code` char(3) NOT NULL, `country_of_tax_residence` char(3) NOT NULL, `country_of_tax_policy` char(3) DEFAULT NULL, `created_at` datetime NOT NULL, `created_by` varchar(255) NOT NULL, `last_modified` datetime NOT NULL, `last_modified_by` varchar(255) NOT NULL, `deleted_at` datetime DEFAULT NULL, `deleted_by` varchar(255) DEFAULT NULL, PRIMARY KEY (`worksheet_account_contract_payable_after_tax_id`), KEY `fk_wacpat_contract` (`contract_id`), KEY `fk_wacpat_account` (`account_id`), KEY `fk_wacpat_abacus_event` (`abacus_event_id`), KEY `fk_wacpat_statement_period` (`statement_period_id`), KEY `fk_wacpat_waccb` (`worksheet_account_contract_closing_balance_id`), CONSTRAINT `fk_wacpat_abacus_event` FOREIGN KEY (`abacus_event_id`) REFERENCES `abacus_event` (`abacus_event_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_wacpat_account` FOREIGN KEY (`account_id`) REFERENCES `account` (`account_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_wacpat_contract` FOREIGN KEY (`contract_id`) REFERENCES `contract` (`contract_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_wacpat_statement_period` FOREIGN KEY (`statement_period_id`) REFERENCES `statement_period` (`statement_period_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_wacpat_waccb` FOREIGN KEY (`worksheet_account_contract_closing_balance_id`) REFERENCES `worksheet_account_contract_closing_balance` (`worksheet_account_contract_closing_balance_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8mb3 ```
## Columns | Name | Type | Default | Nullable | Extra Definition | Children | Parents | Comment | | ----------------------------------------------- | ------------------ | ------- | -------- | ---------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------- | ------- | | abacus_event_id | mediumint unsigned | | false | | | [abacus_event](abacus_event.md) | | | account_id | mediumint unsigned | | false | | | [account](account.md) | | | contract_id | mediumint unsigned | | false | | | [contract](contract.md) | | | country_of_tax_policy | char(3) | | true | | | | | | country_of_tax_residence | char(3) | | false | | | | | | created_at | datetime | | false | | | | | | created_by | varchar(255) | | false | | | | | | currency_code | char(3) | | false | | | | | | deleted_at | datetime | | true | | | | | | deleted_by | varchar(255) | | true | | | | | | last_modified | datetime | | false | | | | | | last_modified_by | varchar(255) | | false | | | | | | payable_amount_post_tax | decimal(20,2) | | false | | | | | | payable_amount_pre_tax | decimal(20,2) | | false | | | | | | statement_period_id | mediumint unsigned | | false | | | [statement_period](statement_period.md) | | | tax_withholding_amount | decimal(20,2) | | true | | | | | | vat_amount | decimal(20,2) | | true | | | | | | worksheet_account_contract_closing_balance_id | mediumint unsigned | | false | | | [worksheet_account_contract_closing_balance](worksheet_account_contract_closing_balance.md) | | | worksheet_account_contract_payable_after_tax_id | mediumint unsigned | | false | auto_increment | [payment_group_payment_account_detail](payment_group_payment_account_detail.md) [worksheet_account_contract_payable_details](worksheet_account_contract_payable_details.md) | | | ## Constraints | Name | Type | Definition | | -------------------------- | ----------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------- | | PRIMARY | PRIMARY KEY | PRIMARY KEY (worksheet_account_contract_payable_after_tax_id) | | fk_wacpat_abacus_event | FOREIGN KEY | FOREIGN KEY (abacus_event_id) REFERENCES abacus_event (abacus_event_id) | | fk_wacpat_account | FOREIGN KEY | FOREIGN KEY (account_id) REFERENCES account (account_id) | | fk_wacpat_contract | FOREIGN KEY | FOREIGN KEY (contract_id) REFERENCES contract (contract_id) | | fk_wacpat_statement_period | FOREIGN KEY | FOREIGN KEY (statement_period_id) REFERENCES statement_period (statement_period_id) | | fk_wacpat_waccb | FOREIGN KEY | FOREIGN KEY (worksheet_account_contract_closing_balance_id) REFERENCES worksheet_account_contract_closing_balance (worksheet_account_contract_closing_balance_id) | ## Indexes | Name | Definition | | -------------------------- | ------------------------------------------------------------------------------- | | PRIMARY | PRIMARY KEY (worksheet_account_contract_payable_after_tax_id) USING BTREE | | fk_wacpat_abacus_event | KEY fk_wacpat_abacus_event (abacus_event_id) USING BTREE | | fk_wacpat_account | KEY fk_wacpat_account (account_id) USING BTREE | | fk_wacpat_contract | KEY fk_wacpat_contract (contract_id) USING BTREE | | fk_wacpat_statement_period | KEY fk_wacpat_statement_period (statement_period_id) USING BTREE | | fk_wacpat_waccb | KEY fk_wacpat_waccb (worksheet_account_contract_closing_balance_id) USING BTREE | ## Relations ![er](worksheet_account_contract_payable_after_tax.svg) --- > Generated by [tbls](https://github.com/k1LoW/tbls)