DIMCOMPANY¶
This dimension table stores information about companies.
Columns¶
| Column | Data type | Description |
|---|---|---|
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. |
COMPADDRESS1 |
VARCHAR | The company's street address, line 1. For a visual reference of this data element in the source system, see Appendix B: COMPADDRESS1. |
COMPADDRESS2 |
VARCHAR | The company's street address, line 2. For a visual reference of this data element in the source system, see Appendix B: COMPADDRESS2. |
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. |
COMPANYNAME |
VARCHAR | The name of the company. For a visual reference of this data element in the source system, see Appendix B: COMPANYNAME. |
COMPARCHIVE |
NUMBER | An indication of whether the company record is archived or not. |
COMPCITY |
VARCHAR | The company's city. For a visual reference of this data element in the source system, see Appendix B: COMPCITY. |
COMPCONTACTPHONE1 |
VARCHAR | The primary contact phone number for the company. For a visual reference of this data element in the source system, see Appendix B: COMPCONTACTPHONE1. |
COMPCONTACTPHONE2 |
VARCHAR | The secondary contact phone number for the company. |
COMPCREATEDATE |
TIMESTAMP_NTZ | The date the company profile was created. For a visual reference of this data element in the source system, see Appendix B: COMPCREATEDATE. |
COMPINDUSTRY |
VARCHAR | The company industry. For a visual reference of this data element in the source system, see Appendix B: COMPINDUSTRY. |
COMPNAMELINK |
VARCHAR | The company profile link. |
COMPOWNERCOMBINED |
VARCHAR | The combined ownership details of the company. |
COMPOWNERPRIMARY |
VARCHAR | The primary owner of the company. |
COMPSTATE |
VARCHAR | The company's state. For a visual reference of this data element in the source system, see Appendix B: COMPSTATE. |
COMPSTATUS |
VARCHAR | The company status. For a visual reference of this data element in the source system, see Appendix B: COMPSTATUS. |
COMPUPDATEDATE |
TIMESTAMP_NTZ | The date of the most recent update to the company profile. For a visual reference of this data element in the source system, see Appendix B: COMPUPDATEDATE. |
COMPWEBSITE |
VARCHAR | The website of the company. For a visual reference of this data element in the source system, see Appendix B: COMPWEBSITE. |
COMPZIP |
VARCHAR | The company's ZIP/postal code. For a visual reference of this data element in the source system, see Appendix B: COMPZIP. |
CUSTOMERKEY |
NUMBER | A foreign key referencing a customer record in the DIMCUSTOMER table. |
MAXINVOICEDATE |
DATE | The latest invoice date. |
MININVOICEDATE |
DATE | The earliest invoice date. |