RPTDW_PRODUCER_CONTACT Table

This section lists the database columns in the RPTDW_PRODUCER_CONTACT table.

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.
EMAIL	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