DIMCOMPANYBRANCH¶
This dimension table stores information about company branches.
Columns¶
| Column | Data type | Description |
|---|---|---|
BRANCHCITY |
VARCHAR | The city where the branch is located. |
BRANCHID |
NUMBER | The identifier for the branch. |
BRANCHNAME |
VARCHAR | The name of the branch. For a visual reference of this data element in the source system, see Appendix B: BRANCHNAME. |
BRANCHSTATE |
VARCHAR | The state where the branch is located. |
BUILDID |
NUMBER | Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows. |
COMPANYID |
NUMBER | The identifier for the company. For a visual reference of this data element in the source system, see Appendix B: COMPANYID. |
COMPANYKEY |
NUMBER | The identifier for the company. |
COMPBRANCHKEY |
NUMBER | The primary key referencing a company branch. |
CUSTOMERKEY |
NUMBER | A foreign key referencing the customer record in the DIMCUSTOMER table. |