# reference_sap_profit_center

## Description

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

```sql
CREATE TABLE `reference_sap_profit_center` (
  `reference_sap_profit_center_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `profit_center` varchar(10) COLLATE utf8mb4_general_ci NOT NULL,
  `company_code` varchar(8) COLLATE utf8mb4_general_ci NOT NULL,
  `business_group` varchar(3) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'ORC',
  PRIMARY KEY (`reference_sap_profit_center_id`)
) 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 |
| ------------------------------ | ------------------ | ------- | -------- | ---------------- | ------------------------------------------------------- | ------- | ------- |
| business_group                 | varchar(3)         | ORC     | false    |                  |                                                         |         |         |
| company_code                   | varchar(8)         |         | false    |                  |                                                         |         |         |
| profit_center                  | varchar(10)        |         | false    |                  |                                                         |         |         |
| reference_sap_profit_center_id | mediumint unsigned |         | false    | auto_increment   | [reference_signing_entity](reference_signing_entity.md) |         |         |

## Constraints

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

## Indexes

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

## Relations

![er](reference_sap_profit_center.svg)

---

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