**NAS_DB_OBJECTS** rs1.prg_contacts.creating_date, 1, timestamp, 13, 1 rs1.prg_contacts.created_from, 2, text, 12, 1 rs1.prg_contacts.changing_date, 3, timestamp, 13, 1 rs1.prg_contacts.changed_from, 4, text, 12, 1 rs1.prg_contacts.intfield01, 5, int8, 10, 1 rs1.prg_contacts.sid, 6, text, 6, 1 rs1.prg_contacts.tid, 6, text, 7, 1 rs1.prg_contacts.fid, 6, int8, 8, 1 rs1.prg_contacts.timestampfield01, 9, timestamp, 16, 1 rs1.prg_contacts.timestampfield02, 10, timestamp, 16, 1 rs1.prg_contacts.field01, 11, text, 7, 1 rs1.prg_contacts.field02, 12, text, 7, 1 rs1.prg_contacts.field03, 13, text, 7, 0 rs1.prg_contacts.field04, 14, text, 7, 1 rs1.prg_contacts.field05, 15, text, 7, 1 rs1.prg_contacts.field06, 16, text, 7, 1 rs1.prg_contacts.field07, 17, text, 7, 1 rs1.prg_contacts.field08, 18, text, 7, 1 rs1.prg_contacts.field09, 19, text, 7, 1 rs1.prg_contacts.field10, 20, text, 7, 1 rs1.prg_contacts.field11, 21, text, 7, 1 rs1.prg_contacts.field12, 22, text, 7, 1 rs1.prg_contacts.field13, 23, text, 7, 1 rs1.prg_contacts.field14, 24, text, 7, 1 rs1.prg_contacts.field15, 25, text, 7, 1 rs1.prg_contacts.field16, 26, text, 7, 1 rs1.prg_contacts.field17, 27, text, 7, 1 rs1.prg_contacts.field18, 28, text, 7, 1 rs1.prg_contacts.field19, 29, text, 7, 1 rs1.prg_contacts.field20, 30, text, 7, 1 rs1.prg_contacts.field21, 31, text, 7, 1 rs1.prg_contacts.field22, 32, text, 7, 1 rs1.prg_contacts.field23, 33, text, 7, 1 rs1.prg_contacts.field24, 34, text, 7, 1 rs1.prg_contacts.field25, 35, text, 7, 1 rs1.prg_contacts.field26, 36, text, 7, 1 rs1.prg_contacts.field27, 37, text, 7, 1 rs1.prg_contacts.field28, 38, text, 7, 1 rs1.prg_contacts.field29, 39, text, 7, 1 rs1.prg_contacts.field30, 40, text, 7, 1 rs1.prg_contacts.field31, 41, text, 7, 1 rs1.prg_contacts.field32, 42, text, 7, 1 rs1.prg_contacts.field33, 43, text, 7, 1 rs1.prg_contacts.field34, 44, text, 7, 1 rs1.prg_contacts.field35, 45, text, 7, 1 rs1.prg_contacts.field36, 46, text, 7, 1 rs1.prg_contacts.field37, 47, text, 7, 1 rs1.prg_contacts.field38, 48, text, 7, 1 rs1.prg_contacts.field39, 49, text, 7, 1 rs1.prg_contacts.field40, 50, text, 7, 1 rs1.prg_contacts.field41, 51, text, 7, 1 rs1.prg_contacts.field42, 52, text, 7, 1 rs1.prg_contacts.field43, 53, text, 7, 1 rs1.prg_contacts.field44, 54, text, 7, 1 rs1.prg_contacts.field45, 55, text, 7, 1 rs1.prg_contacts.field46, 56, text, 7, 1 rs1.prg_contacts.field47, 57, text, 7, 1 rs1.prg_contacts.field48, 58, text, 7, 1 rs1.prg_contacts.field49, 59, text, 7, 1 rs1.prg_contacts.field50, 60, text, 7, 1 rs1.prg_contacts.field51, 61, text, 7, 1 rs1.prg_contacts.field52, 62, text, 7, 1 rs1.prg_contacts.field53, 63, text, 7, 1 rs1.prg_contacts.field54, 64, text, 7, 1 rs1.prg_contacts.field55, 65, text, 7, 1 rs1.prg_contacts.field56, 66, text, 7, 1 rs1.prg_contacts.field57, 67, text, 7, 1 rs1.prg_contacts.field58, 68, text, 7, 1 rs1.prg_contacts.field59, 69, text, 7, 1 rs1.prg_contacts.field60, 70, text, 7, 1 rs1.prg_contacts.field61, 71, text, 7, 1 rs1.prg_contacts.field62, 72, text, 7, 1 rs1.prg_contacts.field63, 73, text, 7, 1 rs1.prg_contacts.field64, 74, text, 7, 1 rs1.prg_contacts.field65, 75, text, 7, 1 rs1.prg_contacts.field66, 76, text, 7, 1 rs1.prg_contacts.field67, 77, text, 7, 1 rs1.prg_contacts.field68, 78, text, 7, 1 rs1.prg_contacts.field69, 79, text, 7, 1 rs1.prg_contacts.field70, 80, text, 7, 1 rs1.prg_contacts.field71, 81, text, 7, 1 rs1.prg_contacts.field72, 82, text, 7, 1 rs1.prg_contacts.field73, 83, text, 7, 1 rs1.prg_contacts.field74, 84, text, 7, 1 rs1.prg_contacts.field75, 85, text, 7, 1 rs1.prg_contacts.field76, 86, text, 7, 1 rs1.prg_contacts.field77, 87, text, 7, 1 rs1.prg_contacts.field78, 88, text, 7, 1 rs1.prg_contacts.field79, 89, text, 7, 1 rs1.prg_contacts.field80, 90, text, 7, 1 rs1.prg_contacts.field81, 91, text, 7, 1 rs1.prg_contacts.field82, 92, text, 7, 1 rs1.prg_contacts.field83, 93, text, 7, 1 rs1.prg_contacts.field84, 94, text, 7, 1 rs1.prg_contacts.field85, 95, text, 7, 1 rs1.prg_contacts.field86, 96, text, 7, 1 rs1.prg_contacts.field87, 97, text, 7, 1 rs1.prg_contacts.field88, 98, text, 7, 1 rs1.prg_contacts.field89, 99, text, 7, 1 rs1.prg_contacts.field90, 100, text, 7, 1 rs1.prg_contacts.order_crit, 101, text, 7, 1 rs1.prg_contacts.intfield03, 102, int8, 10, 1 rs1.prg_contacts.image01, 103, bytea, 7, 1 **NAS_DB_OBJECTS** **NAS_SQL_OBJECTS** **NAS_SELECT = SELECT creating_date,created_from,changing_date,changed_from,intfield01,sid,tid,fid,timestampfield01,timestampfield02,field01,field02,field03,field04,field05,field06,field07,field08,field09,field10,field11,field12,field13,field14,field15,field16,field17,field18,field19,field20,field21,field22,field23,field24,field25,field26,field27,field28,field29,field30,field31,field32,field33,field34,field35,field36,field37,field38,field39,field40,field41,field42,field43,field44,field45,field46,field47,field48,field49,field50,field51,field52,field53,field54,field55,field56,field57,field58,field59,field60,field61,field62,field63,field64,field65,field66,field67,field68,field69,field70,field71,field72,field73,field74,field75,field76,field77,field78,field79,field80,field81,field82,field83,field84,field85,field86,field87,field88,field89,field90,order_crit, intfield03, image01 FROM prg_contacts** **NAS_WHERE = WHERE (intfield01 = |**vkn**|)** **NAS_ORDER = ** **NAS_SQL_OBJECTS NAME=rs1** Groupware - **OX_APP_TITLE**
 

 **rs1.prg_contacts.field02**
 

Persönliche Informationen

Geschäftliche Informationen
Voller Name **rs1.prg_contacts.field01**  Firma **rs1.prg_contacts.field18** 
Titel **rs1.prg_contacts.field06**  Abteilung **rs1.prg_contacts.field19** 
Vorname **rs1.prg_contacts.field03**  Position **rs1.prg_contacts.field20** 
2. Vorname **rs1.prg_contacts.field04**  Art der Anstellung **rs1.prg_contacts.field21** 
Suffix **rs1.prg_contacts.field05**  Raumnummer **rs1.prg_contacts.field22** 
Straße (Privat) **rs1.prg_contacts.field07**  Straße **rs1.prg_contacts.field23** 
Postleitzahl (Privat) **rs1.prg_contacts.field08**  Postleitzahl **rs1.prg_contacts.field24** 
Stadt (Privat) **rs1.prg_contacts.field09**  Stadt **rs1.prg_contacts.field25** 
Bundesland (Privat) **rs1.prg_contacts.field10**  Bundesland **rs1.prg_contacts.field26** 
Land (Privat) **rs1.prg_contacts.field11**  Land **rs1.prg_contacts.field27** 
Familienstand **rs1.prg_contacts.field12**  Anzahl Mitarbeiter **rs1.prg_contacts.field28** 
Geburtstag **rs1.prg_contacts.timestampfield01**  Umsatz **rs1.prg_contacts.field29** 
Anzahl Kinder **rs1.prg_contacts.field13**  UST-Ident-Nr. **rs1.prg_contacts.field30** 
Beruf **rs1.prg_contacts.field14**  HRB-Eintrag **rs1.prg_contacts.field31** 
Spitzname **rs1.prg_contacts.field15**  Betriebszweige **rs1.prg_contacts.field32** 
Ehepartner **rs1.prg_contacts.field16**  Business Kategorie **rs1.prg_contacts.field33** 
Jahrestag **rs1.prg_contacts.timestampfield02**  Manager **rs1.prg_contacts.field35** 
Kategorien **rs1.prg_contacts.field69**  Assistent **rs1.prg_contacts.field36** 
Kontakt Bild      
Standard Adresse **rs1.prg_contacts.field90**     

Zusätzliche Informationen
Straße (Andere) **rs1.prg_contacts.field37**  Kommentar **rs1.prg_contacts.field17** 
Postleitzahl (Andere) **rs1.prg_contacts.field38** 
Stadt (Andere) **rs1.prg_contacts.field39**  Mehr **rs1.prg_contacts.field34** 
Bundesland (Andere) **rs1.prg_contacts.field40** 
Land (Andere) **rs1.prg_contacts.field41** 

Kommunikation
Tel. Assistent **telId=Xrs1.prg_contacts.field42**  Andere Fax **faxId=Xrs1.prg_contacts.field56** 
Tel. Geschäftlich **telId=Xrs1.prg_contacts.field43**  Piepser **smsId=Xrs1.prg_contacts.field57** 
Tel. Geschäftlich (2) **telId=Xrs1.prg_contacts.field44**  Primär **telId=Xrs1.prg_contacts.field58** 
Geschäftlich Fax **faxId=Xrs1.prg_contacts.field45**  Radio **rs1.prg_contacts.field59** 
Tel. Rückruf **telId=Xrs1.prg_contacts.field46**  Telex **rs1.prg_contacts.field60** 
Tel. Auto **telId=Xrs1.prg_contacts.field47**  TTY/TDD **rs1.prg_contacts.field61** 
Tel. Firma **telId=Xrs1.prg_contacts.field48**  Instant Messenger **rs1.prg_contacts.field62** 
Tel. Privat **telId=Xrs1.prg_contacts.field49**  Instant Messenger (2) **rs1.prg_contacts.field63** 
Tel. Privat (2) **telId=Xrs1.prg_contacts.field50**  IP-Telefon **rs1.prg_contacts.field64** 
Privat Fax **faxId=Xrs1.prg_contacts.field51**  E-Mail **rs1.prg_contacts.field65** 
ISDN **rs1.prg_contacts.field52**  E-Mail (2) **rs1.prg_contacts.field66** 
Tel. Handy **smsId=Xrs1.prg_contacts.field53**  E-Mail (3) **rs1.prg_contacts.field67** 
Tel. Handy alt. **smsId=Xrs1.prg_contacts.field54**  URL **rs1.prg_contacts.field68** 
Tel. Andere **telId=Xrs1.prg_contacts.field55**     

Dynamische Felder
**dynconfield01** **rs1.prg_contacts.field70**  **dynconfield11** **rs1.prg_contacts.field80** 
**dynconfield02** **rs1.prg_contacts.field71**  **dynconfield12** **rs1.prg_contacts.field81** 
**dynconfield03** **rs1.prg_contacts.field72**  **dynconfield13** **rs1.prg_contacts.field82** 
**dynconfield04** **rs1.prg_contacts.field73**  **dynconfield14** **rs1.prg_contacts.field83** 
**dynconfield05** **rs1.prg_contacts.field74**  **dynconfield15** **rs1.prg_contacts.field84** 
**dynconfield06** **rs1.prg_contacts.field75**  **dynconfield16** **rs1.prg_contacts.field85** 
**dynconfield07** **rs1.prg_contacts.field76**  **dynconfield17** **rs1.prg_contacts.field86** 
**dynconfield08** **rs1.prg_contacts.field77**  **dynconfield18** **rs1.prg_contacts.field87** 
**dynconfield09** **rs1.prg_contacts.field78**  **dynconfield19** **rs1.prg_contacts.field88** 
**dynconfield10** **rs1.prg_contacts.field79**  **dynconfield20** **rs1.prg_contacts.field89**