Static Database Fields – Customer Table
The Customer Data table contains an entry for each point in the system. Each entry contains a variety of data which is of interest to the customer, but is not used by any PICS programs The data mainly connects the point to customer data such as a equipment serial numbers, maintenance history, drawing locations, etc.
Structure name: custData_t. Table base file name: custdata. Table define: TBL_CUSTDATA.
| Member Name |
Key |
Range |
Type |
Description |
| cd_PID |
Unique |
1 to 32767 |
SHORT |
cd_PID links from the pnt_Pid. The rest of the fields are all intended for customer record keeping and are not currently used by PICS in any way. |
| cd_comment |
|
|
CHAR(255) |
| cd_sysid |
|
|
CHAR(16) |
| cd_moddate |
|
|
CHAR(8) |
| cd_moddoc |
|
|
CHAR(16) |
| cd_caldate |
|
|
CHAR(8) |
| cd_calperd |
|
|
WORD |
| cd_source |
|
|
CHAR(16) |
| cd_drawing |
|
|
CHAR(16) |
| cd_description |
|
|
CHAR(255) |
| cd_term1 |
|
|
CHAR(16) |
| cd_term2 |
|
|
CHAR(16) |
| cd_term3 |
|
|
CHAR(16) |
| cd_term4 |
|
|
CHAR(16) |
| cd_verdate |
|
|
CHAR(8) |
| cd_verby |
|
|
CHAR(16) |
| cd_cable |
|
|
CHAR(16) |
