**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**
 

Personal information

Business information
Display name **rs1.prg_contacts.field01**  Company **rs1.prg_contacts.field18** 
Title **rs1.prg_contacts.field06**  Department **rs1.prg_contacts.field19** 
First name **rs1.prg_contacts.field03**  Position **rs1.prg_contacts.field20** 
Second name **rs1.prg_contacts.field04**  Job Title **rs1.prg_contacts.field21** 
Suffix **rs1.prg_contacts.field05**  Room Number **rs1.prg_contacts.field22** 
Street (Private) **rs1.prg_contacts.field07**  Street **rs1.prg_contacts.field23** 
Postal code (Private) **rs1.prg_contacts.field08**  Postal code **rs1.prg_contacts.field24** 
City (Private) **rs1.prg_contacts.field09**  City **rs1.prg_contacts.field25** 
State (Private) **rs1.prg_contacts.field10**  State **rs1.prg_contacts.field26** 
Country (Private) **rs1.prg_contacts.field11**  Country **rs1.prg_contacts.field27** 
Marital Status **rs1.prg_contacts.field12**  Number of Employee **rs1.prg_contacts.field28** 
Birthday **rs1.prg_contacts.timestampfield01**  Sales Volume **rs1.prg_contacts.field29** 
Number of Children **rs1.prg_contacts.field13**  TAX-ID Number **rs1.prg_contacts.field30** 
Profession **rs1.prg_contacts.field14**  Commercial Register **rs1.prg_contacts.field31** 
Nickname **rs1.prg_contacts.field15**  Branches **rs1.prg_contacts.field32** 
Spouse name **rs1.prg_contacts.field16**  Business Category **rs1.prg_contacts.field33** 
Anniversary **rs1.prg_contacts.timestampfield02**  Manager's name **rs1.prg_contacts.field35** 
Categories **rs1.prg_contacts.field69**  Assistants's name **rs1.prg_contacts.field36** 
Contact Image      
Default Address **rs1.prg_contacts.field90**     

Additional information
Street (Other) **rs1.prg_contacts.field37**  Comment **rs1.prg_contacts.field17** 
Postal code (Other) **rs1.prg_contacts.field38** 
City (Other) **rs1.prg_contacts.field39**  More **rs1.prg_contacts.field34** 
State (Other) **rs1.prg_contacts.field40** 
Country (Other) **rs1.prg_contacts.field41** 

Communication information
Tel. Assistant **telId=Xrs1.prg_contacts.field42**  Other Fax **faxId=Xrs1.prg_contacts.field56** 
Tel. Business **telId=Xrs1.prg_contacts.field43**  Pager **smsId=Xrs1.prg_contacts.field57** 
Tel. Business (2) **telId=Xrs1.prg_contacts.field44**  Primary **telId=Xrs1.prg_contacts.field58** 
Business Fax **faxId=Xrs1.prg_contacts.field45**  Radio **rs1.prg_contacts.field59** 
Tel. Callback **telId=Xrs1.prg_contacts.field46**  Telex **rs1.prg_contacts.field60** 
Tel. Car **telId=Xrs1.prg_contacts.field47**  TTY/TDD **rs1.prg_contacts.field61** 
Tel. Company **telId=Xrs1.prg_contacts.field48**  Instant Messenger **rs1.prg_contacts.field62** 
Tel. Home **telId=Xrs1.prg_contacts.field49**  Instant Messenger (2) **rs1.prg_contacts.field63** 
Tel. Home (2) **telId=Xrs1.prg_contacts.field50**  IP-Phone **rs1.prg_contacts.field64** 
Home Fax **faxId=Xrs1.prg_contacts.field51**  Email **rs1.prg_contacts.field65** 
ISDN **rs1.prg_contacts.field52**  Email (2) **rs1.prg_contacts.field66** 
Tel. Mobile **smsId=Xrs1.prg_contacts.field53**  Email (3) **rs1.prg_contacts.field67** 
Tel. Mobile alt. **smsId=Xrs1.prg_contacts.field54**  URL **rs1.prg_contacts.field68** 
Tel. Other **telId=Xrs1.prg_contacts.field55**     

Dynamic fields
**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**