The PTC table holds information about personal contacts which might be associated to PTY and/or PTA entries.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID of Contact Person per Address/Party | Text | 8 | 1 | Edit | Yes | Public | ||
| PTYINR | Associated Party (Mandatory) | Text | 8 | 1 | Edit | Yes | Public | ||
| PTAINR | Associated Address (Optional) | Text | 8 | 1 | Edit | Yes | Public | ||
| NAM | Externally Displayed Name | Text | 35 | 1 | Edit | Yes | Public | ||
| ENO | Sequence ID | Text | 3 | 1 | Edit | Yes | Public | ||
| DEP | Department | Text | 35 | 1 | Edit | Yes | Public | ||
| GEN | Gender | Text | 10 | 1 | Edit | Yes | Public | ||
| BIDDAT | Birthday | Date | 12 | 0 | Date | Yes | Public | ||
| TELFAC | Phone Factory | Text | 20 | 1 | Edit | Yes | Public | ||
| TELFAX | Telefax | Text | 20 | 1 | Edit | Yes | Public | ||
| TELMOB | Mobile Phone | Text | 20 | 1 | Edit | Yes | Public | ||
| TELOFF | Office Phone | Text | 20 | 1 | Edit | Yes | Public | ||
| VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
| EML | Email/Internet | Text | 140 | 1 | 80 | Edit | Yes | Public | |
| ETGEXTKEY | Entity Group of Party Contract Person | Text | 8 | 1 | Edit | Yes | Public | ||
| GETFLDNRM | Field holding the normalized search fields | Text | 160 | 1 | Edit | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| PTC_ETGEXTKEY | ETGEXTKEY | |
| PTC_GETFLDNRM1 | GETFLDNRM | |
| PTC_INR | INR | Unique |
| PTC_NAM | NAM | |
| PTC_PTAINR | PTAINR | |
| PTC_PTYINR | PTYINR |
/
INR
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter PTC. The field INR is used to maintain links from other tables into this table.
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
This field holds the INR of the associated entry in the table “PTY”.
This mandatory field is used to define the identification number (INR) of the Party being associated with this Contact.
This field holds the INR of the associated entry in the table “PTA”.
This field is used to define the identification number (INR) of the address being associated with a Contact. Entry is optional.
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter PTC. The field INR is used to maintain links from other tables into this table.
Unique internal ID of a record within the table.
If multiple contacts have been set up for a party/address, the counter shows the serial number of the contact currently being entered.
This field is used to specify the department of the contact, whose details are being setup.This information may be used to create complete address information for correspondence to the clients.
This field is used to specify the department of the contact being set up.
This information may be used to create complete address information for correspondence to the clients.
This field is used to specify the gender (male/female) of the contact, whose details are being setup.This information may be used to create personalized correspondence to the clients.
This field is used to specify the gender (male/female) of the contact being set up.
This information may be used to create personalized correspondence to the clients.
This field contains the date of birth of the contact.
This field is used to specify the birthday of the contact being set up.
This information may be used to set up a diary event (a reminder prompt, for example).
This field is used to specify the factory telephone number of the contact.
This field is used to specify the factory telephone number of the contact.
This field is used to specify the telefax number of the contact.
This field is used to specify the telefax number of the contact.
This field is used to specify the cellphone (mobile) number of the contact.
This field is used to specify the cellphone (mobile) number of the contact.
This field is used to specify the office telephone number of the contact.
This field is used to specify the office telephone number of the contact.
This field holds the version counter to keep track of the version history of a PTC entry. The individual versions are controlled by entries in the SLG table.
This field holds the version counter used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.
This field is used to specify the Email address of the contact, whose details are being setup.This information may be used to create complete address information for correspondence to the clients.
This field is used to specify the email address of the contact, whose details are being setup.This information may be used to create complete address information for correspondence to the clients.
This table is defined on entity group level with separate entries for each entity group. This field holds the EXTKEY of the entity group which is the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the entity group of the currently active entity are visible to the user.
This field holds the external key of the owning entity group to identify the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity group are visible to the user.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.