RPTDW_PRODUCER_CONTACT Table
This section lists the database columns in the RPTDW_PRODUCER_CONTACT table.
|
Database Column |
Details |
|
ID |
Type: Decimal |
|
NAME |
Type: text. Unique. |
|
FIRST_NAME |
Type: text. Unique. |
|
LAST_NAME |
Type: text. Unique. |
|
CONTACT_TYPE |
Type: text. Unique. |
|
|
Type: text. Unique. |
|
OFFICE_PHONE |
Type: text. Unique. |
|
CELL_PHONE |
Type: text. Unique. |
|
FAX_PHONE |
Type: text. Unique. |
|
ADDRESS1 |
Type: text. Unique. |
|
ADDRESS2 |
Type: text. Unique. |
|
ADDRESS3 |
Type: text. Unique. |
|
CITY |
Type: text. Unique. |
|
POSTAL_CODE |
Type: text. Unique. |
|
STATE_PROVINCE |
Type: text. Unique. |
|
COUNTRY |
Type: text. Unique. |
|
NOTES |
Type: text (max length 1000). Unique. |
|
STATUS |
Type: text. Unique. |
|
LAST_MODIFIED_TIME |
Type: TimeStamp. Unique. |
|
producer |
Type: Decimal. References Table: RPTDW_SOFTWARE_PRODUCER Table |