home *** CD-ROM | disk | FTP | other *** search
/ PC Professionell 2006 May / PCpro_2006_05.ISO / files / vollvers / crm / setup_de.exe / System / Selection4.dbs < prev    next >
Encoding:
INI File  |  2005-10-03  |  37.3 KB  |  1,848 lines

  1. [Main]
  2. Version=3.5
  3. OperatCount=38
  4. TableCount=5
  5. FieldCount=95
  6. CondCount=0
  7. FieldGroups=6
  8. DefaultMainTable=
  9. RootFieldsFirst=0
  10.  
  11. [Operator:1]
  12. Name=Equal
  13. DisplayName=ist gleich
  14. SQLName=@f = '@1'
  15. ValFormat=
  16. ExprType=SameAsField
  17. AppliedTypes=ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp,
  18. ValueKind=vkScalar
  19.  
  20. [Operator:2]
  21. Name=NotEqual
  22. DisplayName=ist ungleich
  23. SQLName=@f <> '@1'
  24. ValFormat=
  25. ExprType=SameAsField
  26. AppliedTypes=ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp,
  27. ValueKind=vkScalar
  28.  
  29. [Operator:3]
  30. Name=LessThan
  31. DisplayName=kleiner als
  32. SQLName=@f < '@1'
  33. ValFormat=
  34. ExprType=SameAsField
  35. AppliedTypes=ftSmallint,ftInteger,ftWord,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp,
  36. ValueKind=vkScalar
  37.  
  38. [Operator:4]
  39. Name=LessOrEqual
  40. DisplayName=kleiner gleich als
  41. SQLName=@f <= '@1'
  42. ValFormat=
  43. ExprType=SameAsField
  44. AppliedTypes=ftSmallint,ftInteger,ftWord,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp,
  45. ValueKind=vkScalar
  46.  
  47. [Operator:5]
  48. Name=GreaterThan
  49. DisplayName=gr÷▀er als
  50. SQLName=@f >'@1'
  51. ValFormat=
  52. ExprType=SameAsField
  53. AppliedTypes=ftSmallint,ftInteger,ftWord,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp,
  54. ValueKind=vkScalar
  55.  
  56. [Operator:6]
  57. Name=GreaterOrEqual
  58. DisplayName=gr÷▀er gleich als
  59. SQLName=@f >= '@1'
  60. ValFormat=
  61. ExprType=SameAsField
  62. AppliedTypes=ftSmallint,ftInteger,ftWord,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp,
  63. ValueKind=vkScalar
  64.  
  65. [Operator:7]
  66. Name=IsNull
  67. DisplayName=ist leer
  68. SQLName=@f is null
  69. ValFormat=
  70. ExprType=SameAsField
  71. AppliedTypes=ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftDate,ftTime,ftDateTime,ftAutoInc,ftMemo,ftFmtMemo,ftLargeint,ftTimeStamp,
  72. ValueKind=vkScalar
  73.  
  74. [Operator:8]
  75. Name=InList
  76. DisplayName=ist in der Liste
  77. SQLName=@f in (@1)
  78. ValFormat=
  79. ExprType=SameAsField
  80. AppliedTypes=ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp,
  81. ValueKind=vkList
  82.  
  83. [Operator:9]
  84. Name=NotInList
  85. DisplayName=ist nicht in der Liste
  86. SQLName=NOT (@f in (@1))
  87. ValFormat=
  88. ExprType=SameAsField
  89. AppliedTypes=ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp,
  90. ValueKind=vkList
  91.  
  92. [Operator:10]
  93. Name=StartsWith
  94. DisplayName=beginnt mit
  95. SQLName=@f like '@1%'
  96. ValFormat=
  97. ExprType=SameAsField
  98. AppliedTypes=ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp,
  99. ValueKind=vkScalar
  100.  
  101. [Operator:11]
  102. Name=NotStartsWith
  103. DisplayName=beginnt nicht mit
  104. SQLName=not(@f like '@1%')
  105. ValFormat=
  106. ExprType=SameAsField
  107. AppliedTypes=ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp,
  108. ValueKind=vkScalar
  109.  
  110. [Operator:12]
  111. Name=Contains
  112. DisplayName=beinhaltet
  113. SQLName=@f like '%@1%'
  114. ValFormat=
  115. ExprType=SameAsField
  116. AppliedTypes=ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp,
  117. ValueKind=vkScalar
  118.  
  119. [Operator:13]
  120. Name=NotContains
  121. DisplayName=beinhaltet nicht
  122. SQLName=not(@f like '%@1%')
  123. ValFormat=
  124. ExprType=SameAsField
  125. AppliedTypes=ftSmallint,ftInteger,ftWord,ftBoolean,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp,
  126. ValueKind=vkScalar
  127.  
  128. [Operator:14]
  129. Name=Between
  130. DisplayName=zwischen
  131. SQLName=@f between '@1' and '@2'
  132. ValFormat=and
  133. ExprType=SameAsField
  134. AppliedTypes=ftSmallint,ftInteger,ftWord,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp,
  135. ValueKind=vkScalar
  136.  
  137. [Operator:15]
  138. Name=NotBetween
  139. DisplayName=ist nicht zwischen
  140. SQLName=NOT (@f between '@1' and '@2')
  141. ValFormat=and
  142. ExprType=SameAsField
  143. AppliedTypes=ftSmallint,ftInteger,ftWord,ftFloat,ftCurrency,ftBCD,ftTime,ftAutoInc,ftLargeint,ftTimeStamp,
  144. ValueKind=vkScalar
  145.  
  146. [Operator:16]
  147. Name=Today
  148. DisplayName=ist heute
  149. SQLName=cast(@f as date) = CURRENT_DATE
  150. ValFormat=
  151. ExprType=SameAsField
  152. AppliedTypes=ftDate,ftDateTime,
  153. ValueKind=vkScalar
  154.  
  155. [Operator:17]
  156. Name=Equal_Date
  157. DisplayName=ist gleich
  158. SQLName=cast(@f as date) = cast('@1' as date)
  159. ValFormat=
  160. ExprType=SameAsField
  161. AppliedTypes=ftDate,ftDateTime,
  162. ValueKind=vkScalar
  163.  
  164. [Operator:18]
  165. Name=NotEqual_Date
  166. DisplayName=ist ungleich
  167. SQLName=cast(@f as date) <> cast('@1' as date)
  168. ValFormat=
  169. ExprType=SameAsField
  170. AppliedTypes=ftDate,ftDateTime,
  171. ValueKind=vkScalar
  172.  
  173. [Operator:19]
  174. Name=LessThan_Date
  175. DisplayName=kleiner als
  176. SQLName=cast(@f as date) < cast('@1' as date)
  177. ValFormat=
  178. ExprType=SameAsField
  179. AppliedTypes=ftDate,ftDateTime,
  180. ValueKind=vkScalar
  181.  
  182. [Operator:20]
  183. Name=LessOrEqual_Date
  184. DisplayName=kleiner gleich als
  185. SQLName=cast(@f as date) <= cast('@1' as date)
  186. ValFormat=
  187. ExprType=SameAsField
  188. AppliedTypes=ftDate,ftDateTime,
  189. ValueKind=vkScalar
  190.  
  191. [Operator:21]
  192. Name=GreaterThan_Date
  193. DisplayName=gr÷▀er als
  194. SQLName=cast(@f as date) > cast('@1' as date)
  195. ValFormat=
  196. ExprType=SameAsField
  197. AppliedTypes=ftDate,ftDateTime,
  198. ValueKind=vkScalar
  199.  
  200. [Operator:22]
  201. Name=GreaterOrEqual_Date
  202. DisplayName=gr÷▀er gleich als
  203. SQLName=cast(@f as date) >= cast('@1' as date)
  204. ValFormat=
  205. ExprType=SameAsField
  206. AppliedTypes=ftDate,ftDateTime,
  207. ValueKind=vkScalar
  208.  
  209. [Operator:23]
  210. Name=Between_Date
  211. DisplayName=zwischen
  212. SQLName=cast(@f as date) between cast('@1' as date) and cast('@2' as date)
  213. ValFormat=
  214. ExprType=SameAsField
  215. AppliedTypes=ftDate,ftDateTime,
  216. ValueKind=vkScalar
  217.  
  218. [Operator:24]
  219. Name=NotBetween_Date
  220. DisplayName=nicht zwischen
  221. SQLName=NOT (cast(@f as date) between cast('@1' as date) and cast('@2' as date))
  222. ValFormat=
  223. ExprType=SameAsField
  224. AppliedTypes=ftDate,ftDateTime,
  225. ValueKind=vkScalar
  226.  
  227. [Operator:25]
  228. Name=NextMonth
  229. DisplayName=liegt im nΣchsten Monat
  230. SQLName=(EXTRACT( MONTH from cast(@f as date)) = EXTRACT(MONTH from CURRENT_DATE)+1) AND (EXTRACT( YEAR from cast(@f as date)) = EXTRACT(YEAR from CURRENT_DATE)) 
  231. ValFormat=
  232. ExprType=SameAsField
  233. AppliedTypes=ftDate,ftDateTime,
  234. ValueKind=vkScalar
  235.  
  236. [Operator:26]
  237. Name=LastMonth
  238. DisplayName=liegt im letzten Monat
  239. SQLName=(EXTRACT( MONTH from cast(@f as date)) = EXTRACT(MONTH from CURRENT_DATE)-1) AND (EXTRACT( YEAR from cast(@f as date)) = EXTRACT(YEAR from CURRENT_DATE)) 
  240. ValFormat=
  241. ExprType=SameAsField
  242. AppliedTypes=ftDate,ftDateTime,
  243. ValueKind=vkScalar
  244.  
  245. [Operator:27]
  246. Name=ActualMonth
  247. DisplayName=liegt im aktuellen Monat
  248. SQLName=(EXTRACT( MONTH from cast(@f as date)) = EXTRACT(MONTH from CURRENT_DATE)) AND (EXTRACT( YEAR from cast(@f as date)) = EXTRACT(YEAR from CURRENT_DATE)) 
  249. ValFormat=
  250. ExprType=SameAsField
  251. AppliedTypes=ftDate,ftDateTime,
  252. ValueKind=vkScalar
  253.  
  254. [Operator:28]
  255. Name=Yesterday
  256. DisplayName=ist gestern
  257. SQLName=cast( @f as date ) = CURRENT_DATE-1
  258. ValFormat=
  259. ExprType=SameAsField
  260. AppliedTypes=ftDate,ftDateTime,
  261. ValueKind=vkScalar
  262.  
  263. [Operator:29]
  264. Name=Tomorrow
  265. DisplayName=ist morgen
  266. SQLName=cast( @f as date ) = CURRENT_DATE+1
  267. ValFormat=
  268. ExprType=SameAsField
  269. AppliedTypes=ftDate,ftDateTime,
  270. ValueKind=vkScalar
  271.  
  272. [Operator:30]
  273. Name=Next7Days
  274. DisplayName=liegt in den nΣchsten 7 Tagen
  275. SQLName=(cast( @f as date ) >= CURRENT_DATE) AND (cast( @f as date ) <= CURRENT_DATE+7)
  276. ValFormat=
  277. ExprType=SameAsField
  278. AppliedTypes=ftDate,ftDateTime,
  279. ValueKind=vkScalar
  280.  
  281. [Operator:31]
  282. Name=EqualStr
  283. DisplayName=ist gleich
  284. SQLName=UPPER(@f) = UPPER('@1')
  285. ValFormat=
  286. ExprType=SameAsField
  287. AppliedTypes=ftString,ftFixedChar,ftWideString,
  288. ValueKind=vkScalar
  289.  
  290. [Operator:32]
  291. Name=NotEqualStr
  292. DisplayName=ist ungleich
  293. SQLName=UPPER(@f) <> UPPER('@1')
  294. ValFormat=
  295. ExprType=SameAsField
  296. AppliedTypes=ftString,ftFixedChar,ftWideString,
  297. ValueKind=vkScalar
  298.  
  299. [Operator:33]
  300. Name=IsNullStr
  301. DisplayName=ist leer
  302. SQLName=((@f is null) OR (@f = ''))
  303. ValFormat=
  304. ExprType=SameAsField
  305. AppliedTypes=ftString,ftFixedChar,ftWideString,
  306. ValueKind=vkScalar
  307.  
  308. [Operator:34]
  309. Name=IsNotNullStr
  310. DisplayName=ist nicht leer
  311. SQLName=(not (@f is null) OR (@f <> ''))
  312. ValFormat=
  313. ExprType=SameAsField
  314. AppliedTypes=ftString,ftFixedChar,ftWideString,
  315. ValueKind=vkScalar
  316.  
  317. [Operator:35]
  318. Name=StartWithStr
  319. DisplayName=beginnt mit
  320. SQLName=UPPER(@f) like UPPER( '@1%')
  321. ValFormat=
  322. ExprType=SameAsField
  323. AppliedTypes=ftString,ftFixedChar,ftWideString,
  324. ValueKind=vkScalar
  325.  
  326. [Operator:36]
  327. Name=NotStartWithStr
  328. DisplayName=beginnt nicht mit
  329. SQLName=not(UPPER(@f) like UPPER( '@1%'))
  330. ValFormat=
  331. ExprType=SameAsField
  332. AppliedTypes=ftString,ftFixedChar,ftWideString,
  333. ValueKind=vkScalar
  334.  
  335. [Operator:37]
  336. Name=ContainsStr
  337. DisplayName=beinhaltet
  338. SQLName=UPPER(@f) like UPPER('%@1%')
  339. ValFormat=
  340. ExprType=SameAsField
  341. AppliedTypes=ftString,ftFixedChar,ftWideString,
  342. ValueKind=vkScalar
  343.  
  344. [Operator:38]
  345. Name=NotContainsStr
  346. DisplayName=beinhaltet nicht
  347. SQLName=not(UPPER(@f) like UPPER('%@1%'))
  348. ValFormat=
  349. ExprType=SameAsField
  350. AppliedTypes=ftString,ftFixedChar,ftWideString,
  351. ValueKind=vkScalar
  352.  
  353. [Table:1]
  354. DBName=T
  355. Name=ADRESSE
  356. DisplayName=ADRESSE
  357. Alias=ADRESSE
  358. Quoted=0
  359. Hints=
  360. DsgnPos=12,10,110,160
  361. Links=TERMIN,KONTAKT,AP,WORKER
  362.  
  363. [Link:ADRESSE-TERMIN]
  364. FldName1=ADRESS_ID
  365. FldName2=ADRESS_IDV
  366. Operators==
  367. QuoteFields=0
  368. LinkType=Right
  369.  
  370. [Link:ADRESSE-KONTAKT]
  371. FldName1=ADRESS_ID
  372. FldName2=ADRESS_ID
  373. Operators==
  374. QuoteFields=0
  375. LinkType=Right
  376.  
  377. [Link:ADRESSE-AP]
  378. FldName1=ADRESS_ID
  379. FldName2=ADRESS_ID
  380. Operators==
  381. QuoteFields=0
  382. LinkType=Left
  383.  
  384. [Link:ADRESSE-WORKER]
  385. FldName1=SERVICENUMMER
  386. FldName2=MITARBEITER_ID
  387. Operators==
  388. QuoteFields=0
  389. LinkType=Right
  390.  
  391. [Table:2]
  392. DBName=T
  393. Name=TERMIN
  394. DisplayName=TERMIN
  395. Alias=TERMIN
  396. Quoted=0
  397. Hints=
  398. DsgnPos=162,10,110,160
  399. Links=
  400.  
  401. [Table:3]
  402. DBName=T
  403. Name=KONTAKT
  404. DisplayName=KONTAKT
  405. Alias=KONTAKT
  406. Quoted=0
  407. Hints=
  408. DsgnPos=312,10,110,160
  409. Links=
  410.  
  411. [Table:4]
  412. DBName=T
  413. Name=AP
  414. DisplayName=AP
  415. Alias=AP
  416. Quoted=0
  417. Hints=
  418. DsgnPos=482,87,113,160
  419. Links=
  420.  
  421. [Table:5]
  422. DBName=T
  423. Name=WORKER
  424. DisplayName=WORKER
  425. Alias=WORKER
  426. Quoted=0
  427. Hints=
  428. DsgnPos=165,273,110,153
  429. Links=
  430.  
  431. [Field:1]
  432. ID=2
  433. Kind=kfkData
  434. FieldExpr=SERVICENUMMER
  435. DisplayName=Mitarbeiter
  436. TableAlias=ADRESSE
  437. EditType=4
  438. FieldType=2
  439. FieldSize=0
  440. Quoted=0
  441. UIC=1
  442. UIR=1
  443. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,Between,NotBetween
  444.  
  445. [Field:1.SQL]
  446. SELECT MITARBEITER_ID, NAME || ' ' || VORNAME FROM 
  447. WORKER
  448.  
  449. [Field:2]
  450. ID=3
  451. Kind=kfkData
  452. FieldExpr=FIRMA
  453. DisplayName=Firma
  454. TableAlias=ADRESSE
  455. EditType=0
  456. FieldType=1
  457. FieldSize=200
  458. Quoted=0
  459. UIC=1
  460. UIR=1
  461. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  462.  
  463. [Field:3]
  464. ID=4
  465. Kind=kfkData
  466. FieldExpr=FIRMA2
  467. DisplayName=Firma2
  468. TableAlias=ADRESSE
  469. EditType=0
  470. FieldType=1
  471. FieldSize=200
  472. Quoted=0
  473. UIC=1
  474. UIR=1
  475. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  476.  
  477. [Field:4]
  478. ID=5
  479. Kind=kfkData
  480. FieldExpr=STRASSE
  481. DisplayName=Strasse
  482. TableAlias=ADRESSE
  483. EditType=0
  484. FieldType=1
  485. FieldSize=200
  486. Quoted=0
  487. UIC=1
  488. UIR=1
  489. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  490.  
  491. [Field:5]
  492. ID=6
  493. Kind=kfkData
  494. FieldExpr=PLZ
  495. DisplayName=PLZ
  496. TableAlias=ADRESSE
  497. EditType=0
  498. FieldType=1
  499. FieldSize=200
  500. Quoted=0
  501. UIC=1
  502. UIR=1
  503. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,StartsWith,NotStartsWith,Contains,NotContains,Between,NotBetween
  504.  
  505. [Field:6]
  506. ID=7
  507. Kind=kfkData
  508. FieldExpr=ORT
  509. DisplayName=Ort
  510. TableAlias=ADRESSE
  511. EditType=0
  512. FieldType=1
  513. FieldSize=200
  514. Quoted=0
  515. UIC=1
  516. UIR=1
  517. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  518.  
  519. [Field:7]
  520. ID=8
  521. Kind=kfkData
  522. FieldExpr=LAND
  523. DisplayName=Land
  524. TableAlias=ADRESSE
  525. EditType=4
  526. FieldType=1
  527. FieldSize=200
  528. Quoted=0
  529. UIC=1
  530. UIR=1
  531. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  532.  
  533. [Field:7.SQL]
  534. SELECT STR1, STR1 FROM STRINGS WHERE ID=9 AND 
  535. OBJECT=58
  536.  
  537. [Field:8]
  538. ID=9
  539. Kind=kfkData
  540. FieldExpr=REGION
  541. DisplayName=Region
  542. TableAlias=ADRESSE
  543. EditType=4
  544. FieldType=1
  545. FieldSize=200
  546. Quoted=0
  547. UIC=1
  548. UIR=1
  549. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  550.  
  551. [Field:8.SQL]
  552. SELECT STR1, STR1 FROM STRINGS WHERE ID=10 AND 
  553. OBJECT=58
  554.  
  555. [Field:9]
  556. ID=10
  557. Kind=kfkData
  558. FieldExpr=TELEFON
  559. DisplayName=Telefon
  560. TableAlias=ADRESSE
  561. EditType=0
  562. FieldType=1
  563. FieldSize=200
  564. Quoted=0
  565. UIC=1
  566. UIR=1
  567. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  568.  
  569. [Field:10]
  570. ID=11
  571. Kind=kfkData
  572. FieldExpr=TELEFAX
  573. DisplayName=Telefax
  574. TableAlias=ADRESSE
  575. EditType=0
  576. FieldType=1
  577. FieldSize=200
  578. Quoted=0
  579. UIC=1
  580. UIR=1
  581. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  582.  
  583. [Field:11]
  584. ID=12
  585. Kind=kfkData
  586. FieldExpr=EMAIL
  587. DisplayName=EMail
  588. TableAlias=ADRESSE
  589. EditType=0
  590. FieldType=1
  591. FieldSize=200
  592. Quoted=0
  593. UIC=1
  594. UIR=1
  595. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  596.  
  597. [Field:12]
  598. ID=13
  599. Kind=kfkData
  600. FieldExpr=INTERNET
  601. DisplayName=Internet
  602. TableAlias=ADRESSE
  603. EditType=0
  604. FieldType=1
  605. FieldSize=200
  606. Quoted=0
  607. UIC=1
  608. UIR=1
  609. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  610.  
  611. [Field:13]
  612. ID=14
  613. Kind=kfkData
  614. FieldExpr=HANDY
  615. DisplayName=Handy
  616. TableAlias=ADRESSE
  617. EditType=0
  618. FieldType=1
  619. FieldSize=200
  620. Quoted=0
  621. UIC=1
  622. UIR=1
  623. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  624.  
  625. [Field:14]
  626. ID=15
  627. Kind=kfkData
  628. FieldExpr=BRANCHE
  629. DisplayName=Branche
  630. TableAlias=ADRESSE
  631. EditType=4
  632. FieldType=2
  633. FieldSize=0
  634. Quoted=0
  635. UIC=1
  636. UIR=1
  637. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,Between,NotBetween
  638.  
  639. [Field:14.SQL]
  640. SELECT BRANCHE_ID, BRANCHE from BRANCHE
  641.  
  642. [Field:15]
  643. ID=17
  644. Kind=kfkData
  645. FieldExpr=UPDATED
  646. DisplayName=GeΣndert am
  647. TableAlias=ADRESSE
  648. EditType=0
  649. FieldType=9
  650. FieldSize=0
  651. Quoted=0
  652. UIC=1
  653. UIR=1
  654. Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days
  655.  
  656. [Field:16]
  657. ID=18
  658. Kind=kfkData
  659. FieldExpr=DATUM
  660. DisplayName=Erstellt am
  661. TableAlias=ADRESSE
  662. EditType=0
  663. FieldType=9
  664. FieldSize=0
  665. Quoted=0
  666. UIC=1
  667. UIR=1
  668. Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days
  669.  
  670. [Field:17]
  671. ID=21
  672. Kind=kfkData
  673. FieldExpr=TELEFONAKTION
  674. DisplayName=Telefonaktion
  675. TableAlias=ADRESSE
  676. EditType=4
  677. FieldType=2
  678. FieldSize=0
  679. Quoted=0
  680. UIC=1
  681. UIR=1
  682. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,Between,NotBetween
  683.  
  684. [Field:17.SQL]
  685. select AKTION_ID, AKTION_NAME from AKTION
  686.  
  687. [Field:18]
  688. ID=22
  689. Kind=kfkData
  690. FieldExpr=NUMMER
  691. DisplayName=Nummer
  692. TableAlias=ADRESSE
  693. EditType=0
  694. FieldType=1
  695. FieldSize=200
  696. Quoted=0
  697. UIC=1
  698. UIR=1
  699. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  700.  
  701. [Field:19]
  702. ID=23
  703. Kind=kfkData
  704. FieldExpr=TYP
  705. DisplayName=Adresstyp
  706. TableAlias=ADRESSE
  707. EditType=2
  708. FieldType=3
  709. FieldSize=0
  710. Quoted=0
  711. UIC=1
  712. UIR=1
  713. Operators=Equal,NotEqual,IsNull
  714. Items=Firma,Mann,Frau
  715. Values=0,1,2
  716.  
  717. [Field:20]
  718. ID=24
  719. Kind=kfkData
  720. FieldExpr=FORECAST
  721. DisplayName=Umsatzplanung
  722. TableAlias=ADRESSE
  723. EditType=2
  724. FieldType=3
  725. FieldSize=0
  726. Quoted=0
  727. UIC=1
  728. UIR=1
  729. Operators=Equal,NotEqual,IsNull
  730. Items=Ja,Nein
  731. Values=0,1
  732.  
  733. [Field:21]
  734. ID=33
  735. Kind=kfkData
  736. FieldExpr=DATUM
  737. DisplayName=Begint am
  738. TableAlias=TERMIN
  739. EditType=0
  740. FieldType=9
  741. FieldSize=0
  742. Quoted=0
  743. UIC=1
  744. UIR=1
  745. Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days
  746.  
  747. [Field:22]
  748. ID=34
  749. Kind=kfkData
  750. FieldExpr=UHRZEIT
  751. DisplayName=Begint um
  752. TableAlias=TERMIN
  753. EditType=0
  754. FieldType=10
  755. FieldSize=0
  756. Quoted=0
  757. UIC=1
  758. UIR=1
  759. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,Between,NotBetween
  760.  
  761. [Field:23]
  762. ID=35
  763. Kind=kfkData
  764. FieldExpr=BETREFF
  765. DisplayName=Betreff
  766. TableAlias=TERMIN
  767. EditType=0
  768. FieldType=1
  769. FieldSize=200
  770. Quoted=0
  771. UIC=1
  772. UIR=1
  773. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  774.  
  775. [Field:24]
  776. ID=37
  777. Kind=kfkData
  778. FieldExpr=INHABER
  779. DisplayName=Mitarbeiter
  780. TableAlias=TERMIN
  781. EditType=4
  782. FieldType=2
  783. FieldSize=0
  784. Quoted=0
  785. UIC=1
  786. UIR=1
  787. Operators=Equal,NotEqual,IsNull
  788.  
  789. [Field:24.SQL]
  790. SELECT MITARBEITER_ID, NAME|| ' ' || VORNAME FROM WORKER
  791.  
  792. [Field:25]
  793. ID=38
  794. Kind=kfkData
  795. FieldExpr=AP
  796. DisplayName=Partner
  797. TableAlias=TERMIN
  798. EditType=4
  799. FieldType=3
  800. FieldSize=0
  801. Quoted=0
  802. UIC=1
  803. UIR=1
  804. Operators=Equal,NotEqual,IsNull
  805.  
  806. [Field:25.SQL]
  807. SELECT AP_ID, NACHNAME FROM AP
  808.  
  809. [Field:26]
  810. ID=39
  811. Kind=kfkData
  812. FieldExpr=ART
  813. DisplayName=Art
  814. TableAlias=TERMIN
  815. EditType=2
  816. FieldType=2
  817. FieldSize=0
  818. Quoted=0
  819. UIC=1
  820. UIR=1
  821. Operators=Equal,NotEqual,IsNull
  822. Items=Anrufen,Outdoor,Besuch,Aufgabe
  823. Values=0,1,2,3
  824.  
  825. [Field:27]
  826. ID=40
  827. Kind=kfkData
  828. FieldExpr=USETIME
  829. DisplayName=Termintyp
  830. TableAlias=TERMIN
  831. EditType=2
  832. FieldType=2
  833. FieldSize=0
  834. Quoted=0
  835. UIC=1
  836. UIR=1
  837. Operators=Equal,NotEqual,IsNull
  838. Items=Termin,Aufgabe
  839. Values=0,1
  840.  
  841. [Field:28]
  842. ID=41
  843. Kind=kfkData
  844. FieldExpr=CREATOR
  845. DisplayName=Erstellt durch
  846. TableAlias=TERMIN
  847. EditType=4
  848. FieldType=3
  849. FieldSize=0
  850. Quoted=0
  851. UIC=1
  852. UIR=1
  853. Operators=Equal,NotEqual,IsNull
  854.  
  855. [Field:28.SQL]
  856. SELECT MITARBEITER_ID, NAME|| ' ' || VORNAME FROM WORKER
  857.  
  858. [Field:29]
  859. ID=42
  860. Kind=kfkData
  861. FieldExpr=CREATED
  862. DisplayName=Erstellt am
  863. TableAlias=TERMIN
  864. EditType=0
  865. FieldType=9
  866. FieldSize=0
  867. Quoted=0
  868. UIC=1
  869. UIR=1
  870. Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days
  871.  
  872. [Field:30]
  873. ID=43
  874. Kind=kfkData
  875. FieldExpr=CREATEDTIME
  876. DisplayName=Erstellt um
  877. TableAlias=TERMIN
  878. EditType=0
  879. FieldType=10
  880. FieldSize=0
  881. Quoted=0
  882. UIC=1
  883. UIR=1
  884. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,Between,NotBetween
  885.  
  886. [Field:31]
  887. ID=44
  888. Kind=kfkData
  889. FieldExpr=ENDDATE
  890. DisplayName=Endet am
  891. TableAlias=TERMIN
  892. EditType=0
  893. FieldType=9
  894. FieldSize=0
  895. Quoted=0
  896. UIC=1
  897. UIR=1
  898. Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days
  899.  
  900. [Field:32]
  901. ID=45
  902. Kind=kfkData
  903. FieldExpr=ENDTIME
  904. DisplayName=Endet um
  905. TableAlias=TERMIN
  906. EditType=0
  907. FieldType=10
  908. FieldSize=0
  909. Quoted=0
  910. UIC=1
  911. UIR=1
  912. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,Between,NotBetween
  913.  
  914. [Field:33]
  915. ID=53
  916. Kind=kfkData
  917. FieldExpr=KONTAKTDATUM
  918. DisplayName=Kontaktdatum
  919. TableAlias=KONTAKT
  920. EditType=0
  921. FieldType=9
  922. FieldSize=0
  923. Quoted=0
  924. UIC=1
  925. UIR=1
  926. Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days
  927.  
  928. [Field:34]
  929. ID=54
  930. Kind=kfkData
  931. FieldExpr=KONTAKTART
  932. DisplayName=Kontaktart
  933. TableAlias=KONTAKT
  934. EditType=0
  935. FieldType=1
  936. FieldSize=100
  937. Quoted=0
  938. UIC=1
  939. UIR=1
  940. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  941.  
  942. [Field:35]
  943. ID=56
  944. Kind=kfkData
  945. FieldExpr=GESPROCHENMIT
  946. DisplayName=Partner
  947. TableAlias=KONTAKT
  948. EditType=4
  949. FieldType=1
  950. FieldSize=200
  951. Quoted=0
  952. UIC=1
  953. UIR=1
  954. Operators=Equal,NotEqual,IsNull
  955.  
  956. [Field:35.SQL]
  957. SELECT AP_ID, NACHNAME FROM AP
  958.  
  959. [Field:36]
  960. ID=57
  961. Kind=kfkData
  962. FieldExpr=ERGEBNIS
  963. DisplayName=Ergebnis
  964. TableAlias=KONTAKT
  965. EditType=0
  966. FieldType=1
  967. FieldSize=20
  968. Quoted=0
  969. UIC=1
  970. UIR=1
  971. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  972.  
  973. [Field:37]
  974. ID=58
  975. Kind=kfkData
  976. FieldExpr=GRUND
  977. DisplayName=Grund
  978. TableAlias=KONTAKT
  979. EditType=0
  980. FieldType=1
  981. FieldSize=200
  982. Quoted=0
  983. UIC=1
  984. UIR=1
  985. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  986.  
  987. [Field:38]
  988. ID=60
  989. Kind=kfkData
  990. FieldExpr=TELEFONKONTAKTER
  991. DisplayName=Mitarbeiter
  992. TableAlias=KONTAKT
  993. EditType=4
  994. FieldType=3
  995. FieldSize=0
  996. Quoted=0
  997. UIC=1
  998. UIR=1
  999. Operators=Equal,NotEqual,IsNull
  1000.  
  1001. [Field:38.SQL]
  1002. SELECT MITARBEITER_ID, NAME|| ' ' || VORNAME FROM WORKER
  1003.  
  1004. [Field:39]
  1005. ID=62
  1006. Kind=kfkData
  1007. FieldExpr=UPDATED
  1008. DisplayName=GeΣndert am
  1009. TableAlias=KONTAKT
  1010. EditType=0
  1011. FieldType=9
  1012. FieldSize=0
  1013. Quoted=0
  1014. UIC=1
  1015. UIR=1
  1016. Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days
  1017.  
  1018. [Field:40]
  1019. ID=64
  1020. Kind=kfkData
  1021. FieldExpr=ICHISTORY
  1022. DisplayName=Erstellt am
  1023. TableAlias=KONTAKT
  1024. EditType=0
  1025. FieldType=11
  1026. FieldSize=0
  1027. Quoted=0
  1028. UIC=1
  1029. UIR=1
  1030. Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days
  1031.  
  1032. [Field:41]
  1033. ID=68
  1034. Kind=kfkData
  1035. FieldExpr=VORNAME
  1036. DisplayName=Vorname
  1037. TableAlias=AP
  1038. EditType=0
  1039. FieldType=1
  1040. FieldSize=100
  1041. Quoted=0
  1042. UIC=1
  1043. UIR=1
  1044. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1045.  
  1046. [Field:42]
  1047. ID=69
  1048. Kind=kfkData
  1049. FieldExpr=NACHNAME
  1050. DisplayName=Nachname
  1051. TableAlias=AP
  1052. EditType=0
  1053. FieldType=1
  1054. FieldSize=100
  1055. Quoted=0
  1056. UIC=1
  1057. UIR=1
  1058. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1059.  
  1060. [Field:43]
  1061. ID=70
  1062. Kind=kfkData
  1063. FieldExpr=DURCHWAHL
  1064. DisplayName=Durchwahl
  1065. TableAlias=AP
  1066. EditType=0
  1067. FieldType=1
  1068. FieldSize=100
  1069. Quoted=0
  1070. UIC=1
  1071. UIR=1
  1072. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1073.  
  1074. [Field:44]
  1075. ID=71
  1076. Kind=kfkData
  1077. FieldExpr=APTELEFAX
  1078. DisplayName=Telefax
  1079. TableAlias=AP
  1080. EditType=0
  1081. FieldType=1
  1082. FieldSize=100
  1083. Quoted=0
  1084. UIC=1
  1085. UIR=1
  1086. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1087.  
  1088. [Field:45]
  1089. ID=72
  1090. Kind=kfkData
  1091. FieldExpr=APEMAIL
  1092. DisplayName=EMail
  1093. TableAlias=AP
  1094. EditType=0
  1095. FieldType=1
  1096. FieldSize=100
  1097. Quoted=0
  1098. UIC=1
  1099. UIR=1
  1100. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1101.  
  1102. [Field:46]
  1103. ID=73
  1104. Kind=kfkData
  1105. FieldExpr=APINTERNET
  1106. DisplayName=Internet
  1107. TableAlias=AP
  1108. EditType=0
  1109. FieldType=1
  1110. FieldSize=100
  1111. Quoted=0
  1112. UIC=1
  1113. UIR=1
  1114. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1115.  
  1116. [Field:47]
  1117. ID=74
  1118. Kind=kfkData
  1119. FieldExpr=APHANDY
  1120. DisplayName=Handy
  1121. TableAlias=AP
  1122. EditType=0
  1123. FieldType=1
  1124. FieldSize=100
  1125. Quoted=0
  1126. UIC=1
  1127. UIR=1
  1128. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1129.  
  1130. [Field:48]
  1131. ID=75
  1132. Kind=kfkData
  1133. FieldExpr=ZUERREICHEN
  1134. DisplayName=Erreichbarkeit
  1135. TableAlias=AP
  1136. EditType=0
  1137. FieldType=1
  1138. FieldSize=100
  1139. Quoted=0
  1140. UIC=1
  1141. UIR=1
  1142. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1143.  
  1144. [Field:49]
  1145. ID=76
  1146. Kind=kfkData
  1147. FieldExpr=POSI
  1148. DisplayName=Position
  1149. TableAlias=AP
  1150. EditType=4
  1151. FieldType=1
  1152. FieldSize=100
  1153. Quoted=0
  1154. UIC=1
  1155. UIR=1
  1156. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1157.  
  1158. [Field:49.SQL]
  1159. SELECT STR1, STR1 FROM STRINGS WHERE ID=11 AND 
  1160. OBJECT=58
  1161.  
  1162. [Field:50]
  1163. ID=77
  1164. Kind=kfkData
  1165. FieldExpr=VERTRETER
  1166. DisplayName=Vertretung
  1167. TableAlias=AP
  1168. EditType=0
  1169. FieldType=1
  1170. FieldSize=100
  1171. Quoted=0
  1172. UIC=1
  1173. UIR=1
  1174. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1175.  
  1176. [Field:51]
  1177. ID=78
  1178. Kind=kfkData
  1179. FieldExpr=GEBURTSTAG
  1180. DisplayName=Geburtstag
  1181. TableAlias=AP
  1182. EditType=0
  1183. FieldType=9
  1184. FieldSize=0
  1185. Quoted=0
  1186. UIC=1
  1187. UIR=1
  1188. Operators=Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,ActualMonth,NextMonth,LastMonth,Today,Tomorrow,Yesterday,Next7Days
  1189.  
  1190. [Field:52]
  1191. ID=79
  1192. Kind=kfkData
  1193. FieldExpr=USEGEBURTSTAG
  1194. DisplayName=Geburtstag erinnern
  1195. TableAlias=AP
  1196. EditType=2
  1197. FieldType=2
  1198. FieldSize=0
  1199. Quoted=0
  1200. UIC=1
  1201. UIR=1
  1202. Operators=Equal,NotEqual,IsNull
  1203. Items=Ja,Nein
  1204. Values=0,1
  1205.  
  1206. [Field:53]
  1207. ID=80
  1208. Kind=kfkData
  1209. FieldExpr=GESCHLECHT
  1210. DisplayName=Geschlecht
  1211. TableAlias=AP
  1212. EditType=2
  1213. FieldType=2
  1214. FieldSize=0
  1215. Quoted=0
  1216. UIC=1
  1217. UIR=1
  1218. Operators=Equal,NotEqual,IsNull
  1219. Items=Mann,Frau
  1220. Values=0,1
  1221.  
  1222. [Field:54]
  1223. ID=81
  1224. Kind=kfkData
  1225. FieldExpr=APADRART
  1226. DisplayName=Adressart
  1227. TableAlias=AP
  1228. EditType=4
  1229. FieldType=1
  1230. FieldSize=100
  1231. Quoted=0
  1232. UIC=1
  1233. UIR=1
  1234. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1235.  
  1236. [Field:54.SQL]
  1237. select ADRARTBEZ A, ADRARTBEZ B from ADRART
  1238.  
  1239. [Field:55]
  1240. ID=82
  1241. Kind=kfkData
  1242. FieldExpr=APFIRMA
  1243. DisplayName=Bemerkung
  1244. TableAlias=AP
  1245. EditType=0
  1246. FieldType=1
  1247. FieldSize=100
  1248. Quoted=0
  1249. UIC=1
  1250. UIR=1
  1251. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1252.  
  1253. [Field:56]
  1254. ID=83
  1255. Kind=kfkData
  1256. FieldExpr=APSTR
  1257. DisplayName=Strasse
  1258. TableAlias=AP
  1259. EditType=0
  1260. FieldType=1
  1261. FieldSize=100
  1262. Quoted=0
  1263. UIC=1
  1264. UIR=1
  1265. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1266.  
  1267. [Field:57]
  1268. ID=84
  1269. Kind=kfkData
  1270. FieldExpr=APPLZ
  1271. DisplayName=PLZ
  1272. TableAlias=AP
  1273. EditType=0
  1274. FieldType=1
  1275. FieldSize=100
  1276. Quoted=0
  1277. UIC=1
  1278. UIR=1
  1279. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,StartsWith,NotStartsWith,Contains,NotContains,Between,NotBetween,Today
  1280.  
  1281. [Field:58]
  1282. ID=85
  1283. Kind=kfkData
  1284. FieldExpr=APORT
  1285. DisplayName=Ort
  1286. TableAlias=AP
  1287. EditType=0
  1288. FieldType=1
  1289. FieldSize=100
  1290. Quoted=0
  1291. UIC=1
  1292. UIR=1
  1293. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1294.  
  1295. [Field:59]
  1296. ID=86
  1297. Kind=kfkData
  1298. FieldExpr=PRIOR
  1299. DisplayName=PrioritΣt
  1300. TableAlias=AP
  1301. EditType=2
  1302. FieldType=1
  1303. FieldSize=1
  1304. Quoted=0
  1305. UIC=1
  1306. UIR=1
  1307. Operators=Equal,NotEqual,IsNull
  1308. Items="1. Prio","2. Prio",keine
  1309. Values=1,2,N
  1310.  
  1311. [Field:60]
  1312. ID=87
  1313. Kind=kfkData
  1314. FieldExpr=TITEL
  1315. DisplayName=Titel
  1316. TableAlias=AP
  1317. EditType=0
  1318. FieldType=1
  1319. FieldSize=20
  1320. Quoted=0
  1321. UIC=1
  1322. UIR=1
  1323. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1324.  
  1325. [Field:61]
  1326. ID=88
  1327. Kind=kfkData
  1328. FieldExpr=APABTEILUNG
  1329. DisplayName=Abteilung
  1330. TableAlias=AP
  1331. EditType=4
  1332. FieldType=1
  1333. FieldSize=250
  1334. Quoted=0
  1335. UIC=1
  1336. UIR=1
  1337. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1338.  
  1339. [Field:61.SQL]
  1340. SELECT STR1, STR1 FROM STRINGS WHERE ID=7 AND 
  1341. OBJECT=58
  1342.  
  1343. [Field:62]
  1344. ID=89
  1345. Kind=kfkData
  1346. FieldExpr=APPRVTEL
  1347. DisplayName=Privat Telefon
  1348. TableAlias=AP
  1349. EditType=0
  1350. FieldType=1
  1351. FieldSize=250
  1352. Quoted=0
  1353. UIC=1
  1354. UIR=1
  1355. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1356.  
  1357. [Field:63]
  1358. ID=90
  1359. Kind=kfkData
  1360. FieldExpr=APPRVFAX
  1361. DisplayName=Privat Fax
  1362. TableAlias=AP
  1363. EditType=0
  1364. FieldType=1
  1365. FieldSize=250
  1366. Quoted=0
  1367. UIC=1
  1368. UIR=1
  1369. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1370.  
  1371. [Field:64]
  1372. ID=91
  1373. Kind=kfkData
  1374. FieldExpr=APPRVEMAIL
  1375. DisplayName=Privat EMail
  1376. TableAlias=AP
  1377. EditType=0
  1378. FieldType=1
  1379. FieldSize=250
  1380. Quoted=0
  1381. UIC=1
  1382. UIR=1
  1383. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1384.  
  1385. [Field:65]
  1386. ID=92
  1387. Kind=kfkData
  1388. FieldExpr=APPRVHOBBY
  1389. DisplayName=Hobby
  1390. TableAlias=AP
  1391. EditType=0
  1392. FieldType=1
  1393. FieldSize=250
  1394. Quoted=0
  1395. UIC=1
  1396. UIR=1
  1397. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1398.  
  1399. [Field:66]
  1400. ID=93
  1401. Kind=kfkData
  1402. FieldExpr=APVTEL
  1403. DisplayName=Vertretung Telefon
  1404. TableAlias=AP
  1405. EditType=0
  1406. FieldType=1
  1407. FieldSize=250
  1408. Quoted=0
  1409. UIC=1
  1410. UIR=1
  1411. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1412.  
  1413. [Field:67]
  1414. ID=94
  1415. Kind=kfkData
  1416. FieldExpr=APVFAX
  1417. DisplayName=Vertretung Telefax
  1418. TableAlias=AP
  1419. EditType=0
  1420. FieldType=1
  1421. FieldSize=250
  1422. Quoted=0
  1423. UIC=1
  1424. UIR=1
  1425. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1426.  
  1427. [Field:68]
  1428. ID=95
  1429. Kind=kfkData
  1430. FieldExpr=APVNOTE
  1431. DisplayName=Vertretung Bemerkung
  1432. TableAlias=AP
  1433. EditType=0
  1434. FieldType=1
  1435. FieldSize=250
  1436. Quoted=0
  1437. UIC=1
  1438. UIR=1
  1439. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1440.  
  1441. [Field:69]
  1442. ID=96
  1443. Kind=kfkData
  1444. FieldExpr=APVEMAIL
  1445. DisplayName=Vertretung EMail
  1446. TableAlias=AP
  1447. EditType=0
  1448. FieldType=1
  1449. FieldSize=250
  1450. Quoted=0
  1451. UIC=1
  1452. UIR=1
  1453. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1454.  
  1455. [Field:70]
  1456. ID=97
  1457. Kind=kfkData
  1458. FieldExpr=APVSTR
  1459. DisplayName=Vertretung Strasse
  1460. TableAlias=AP
  1461. EditType=0
  1462. FieldType=1
  1463. FieldSize=250
  1464. Quoted=0
  1465. UIC=1
  1466. UIR=1
  1467. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1468.  
  1469. [Field:71]
  1470. ID=98
  1471. Kind=kfkData
  1472. FieldExpr=APVPLZ
  1473. DisplayName=Vertretung PLZ
  1474. TableAlias=AP
  1475. EditType=0
  1476. FieldType=1
  1477. FieldSize=250
  1478. Quoted=0
  1479. UIC=1
  1480. UIR=1
  1481. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,StartsWith,NotStartsWith,Contains,NotContains,Between,NotBetween
  1482.  
  1483. [Field:72]
  1484. ID=99
  1485. Kind=kfkData
  1486. FieldExpr=APVORT
  1487. DisplayName=Vertretung Ort
  1488. TableAlias=AP
  1489. EditType=0
  1490. FieldType=1
  1491. FieldSize=250
  1492. Quoted=0
  1493. UIC=1
  1494. UIR=1
  1495. Operators=EqualStr,NotEqualStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr,IsNullStr,IsNotNullStr
  1496.  
  1497. [Field:73]
  1498. ID=155
  1499. Kind=kfkData
  1500. FieldExpr=ADRESS_ID
  1501. DisplayName=ADRESS_ID
  1502. TableAlias=ADRESSE
  1503. EditType=0
  1504. FieldType=3
  1505. FieldSize=0
  1506. Quoted=0
  1507. UIC=0
  1508. UIR=0
  1509. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,Between,NotBetween
  1510.  
  1511. [Field:74]
  1512. ID=156
  1513. Kind=kfkData
  1514. FieldExpr=SPERRE
  1515. DisplayName=SPERRE
  1516. TableAlias=ADRESSE
  1517. EditType=0
  1518. FieldType=2
  1519. FieldSize=0
  1520. Quoted=0
  1521. UIC=0
  1522. UIR=1
  1523. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,NotStartsWith,Contains,NotContains,Between,NotBetween
  1524.  
  1525. [Field:75]
  1526. ID=157
  1527. Kind=kfkData
  1528. FieldExpr=SPERRE_AUTHORITY
  1529. DisplayName=SPERRE_AUTHORITY
  1530. TableAlias=ADRESSE
  1531. EditType=0
  1532. FieldType=2
  1533. FieldSize=0
  1534. Quoted=0
  1535. UIC=0
  1536. UIR=1
  1537. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,NotStartsWith,Contains,NotContains,Between,NotBetween
  1538.  
  1539. [Field:76]
  1540. ID=158
  1541. Kind=kfkData
  1542. FieldExpr=ADRART
  1543. DisplayName=Adressart
  1544. TableAlias=ADRESSE
  1545. EditType=4
  1546. FieldType=1
  1547. FieldSize=100
  1548. Quoted=0
  1549. UIC=1
  1550. UIR=1
  1551. Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr
  1552.  
  1553. [Field:76.SQL]
  1554. select ADRARTBEZ A, ADRARTBEZ B from ADRART
  1555.  
  1556. [Field:77]
  1557. ID=159
  1558. Kind=kfkData
  1559. FieldExpr=UPDATED
  1560. DisplayName=UPDATED
  1561. TableAlias=ADRESSE
  1562. EditType=0
  1563. FieldType=9
  1564. FieldSize=0
  1565. Quoted=0
  1566. UIC=0
  1567. UIR=1
  1568. Operators=IsNull,Today,Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,NextMonth,LastMonth,ActualMonth,Yesterday,Tomorrow,Next7Days
  1569.  
  1570. [Field:78]
  1571. ID=160
  1572. Kind=kfkData
  1573. FieldExpr=DATUM
  1574. DisplayName=DATUM
  1575. TableAlias=ADRESSE
  1576. EditType=0
  1577. FieldType=9
  1578. FieldSize=0
  1579. Quoted=0
  1580. UIC=0
  1581. UIR=1
  1582. Operators=IsNull,Today,Equal_Date,NotEqual_Date,LessThan_Date,LessOrEqual_Date,GreaterThan_Date,GreaterOrEqual_Date,Between_Date,NotBetween_Date,NextMonth,LastMonth,ActualMonth,Yesterday,Tomorrow,Next7Days
  1583.  
  1584. [Field:79]
  1585. ID=161
  1586. Kind=kfkData
  1587. FieldExpr=SERVICENUMMER
  1588. DisplayName=SERVICENUMMER
  1589. TableAlias=ADRESSE
  1590. EditType=0
  1591. FieldType=2
  1592. FieldSize=0
  1593. Quoted=0
  1594. UIC=0
  1595. UIR=1
  1596. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,NotStartsWith,Contains,NotContains,Between,NotBetween
  1597.  
  1598. [Field:80]
  1599. ID=162
  1600. Kind=kfkData
  1601. FieldExpr=TYP
  1602. DisplayName=TYP
  1603. TableAlias=ADRESSE
  1604. EditType=0
  1605. FieldType=3
  1606. FieldSize=0
  1607. Quoted=0
  1608. UIC=0
  1609. UIR=1
  1610. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,StartsWith,NotStartsWith,Contains,NotContains,Between,NotBetween
  1611.  
  1612. [Field:81]
  1613. ID=163
  1614. Kind=kfkData
  1615. FieldExpr=AP_ID
  1616. DisplayName=AP_ID
  1617. TableAlias=AP
  1618. EditType=0
  1619. FieldType=3
  1620. FieldSize=0
  1621. Quoted=0
  1622. UIC=0
  1623. UIR=1
  1624. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,StartsWith,NotStartsWith,Contains,NotContains,Between,NotBetween
  1625.  
  1626. [Field:82]
  1627. ID=164
  1628. Kind=kfkData
  1629. FieldExpr=MITARBEITER_ID
  1630. DisplayName=MITARBEITER_ID
  1631. TableAlias=WORKER
  1632. EditType=0
  1633. FieldType=3
  1634. FieldSize=0
  1635. Quoted=0
  1636. UIC=0
  1637. UIR=1
  1638. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,StartsWith,NotStartsWith,Contains,NotContains,Between,NotBetween
  1639.  
  1640. [Field:83]
  1641. ID=165
  1642. Kind=kfkData
  1643. FieldExpr=NAME
  1644. DisplayName=NAME
  1645. TableAlias=WORKER
  1646. EditType=0
  1647. FieldType=1
  1648. FieldSize=200
  1649. Quoted=0
  1650. UIC=0
  1651. UIR=1
  1652. Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr
  1653.  
  1654. [Field:84]
  1655. ID=166
  1656. Kind=kfkData
  1657. FieldExpr=VORNAME
  1658. DisplayName=VORNAME
  1659. TableAlias=WORKER
  1660. EditType=0
  1661. FieldType=1
  1662. FieldSize=200
  1663. Quoted=0
  1664. UIC=0
  1665. UIR=1
  1666. Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr
  1667.  
  1668. [Field:85]
  1669. ID=167
  1670. Kind=kfkData
  1671. FieldExpr=ABTEILUNG
  1672. DisplayName=ABTEILUNG
  1673. TableAlias=WORKER
  1674. EditType=0
  1675. FieldType=1
  1676. FieldSize=200
  1677. Quoted=0
  1678. UIC=0
  1679. UIR=1
  1680. Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr
  1681.  
  1682. [Field:86]
  1683. ID=168
  1684. Kind=kfkData
  1685. FieldExpr=CODE
  1686. DisplayName=CODE
  1687. TableAlias=WORKER
  1688. EditType=0
  1689. FieldType=1
  1690. FieldSize=10
  1691. Quoted=0
  1692. UIC=0
  1693. UIR=1
  1694. Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr
  1695.  
  1696. [Field:87]
  1697. ID=169
  1698. Kind=kfkData
  1699. FieldExpr=USERGROUP
  1700. DisplayName=USERGROUP
  1701. TableAlias=WORKER
  1702. EditType=0
  1703. FieldType=3
  1704. FieldSize=0
  1705. Quoted=0
  1706. UIC=0
  1707. UIR=1
  1708. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,StartsWith,NotStartsWith,Contains,NotContains,Between,NotBetween
  1709.  
  1710. [Field:88]
  1711. ID=170
  1712. Kind=kfkData
  1713. FieldExpr=ANSCHRIFT
  1714. DisplayName=ANSCHRIFT
  1715. TableAlias=WORKER
  1716. EditType=0
  1717. FieldType=16
  1718. FieldSize=8
  1719. Quoted=0
  1720. UIC=0
  1721. UIR=1
  1722. Operators=IsNull
  1723.  
  1724. [Field:89]
  1725. ID=171
  1726. Kind=kfkData
  1727. FieldExpr=TELEFON
  1728. DisplayName=TELEFON
  1729. TableAlias=WORKER
  1730. EditType=0
  1731. FieldType=1
  1732. FieldSize=200
  1733. Quoted=0
  1734. UIC=0
  1735. UIR=1
  1736. Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr
  1737.  
  1738. [Field:90]
  1739. ID=172
  1740. Kind=kfkData
  1741. FieldExpr=TELEFAX
  1742. DisplayName=TELEFAX
  1743. TableAlias=WORKER
  1744. EditType=0
  1745. FieldType=1
  1746. FieldSize=200
  1747. Quoted=0
  1748. UIC=0
  1749. UIR=1
  1750. Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr
  1751.  
  1752. [Field:91]
  1753. ID=173
  1754. Kind=kfkData
  1755. FieldExpr=STATUS
  1756. DisplayName=STATUS
  1757. TableAlias=WORKER
  1758. EditType=0
  1759. FieldType=1
  1760. FieldSize=200
  1761. Quoted=0
  1762. UIC=0
  1763. UIR=1
  1764. Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr
  1765.  
  1766. [Field:92]
  1767. ID=174
  1768. Kind=kfkData
  1769. FieldExpr=LEV
  1770. DisplayName=LEV
  1771. TableAlias=WORKER
  1772. EditType=0
  1773. FieldType=1
  1774. FieldSize=100
  1775. Quoted=0
  1776. UIC=0
  1777. UIR=1
  1778. Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr
  1779.  
  1780. [Field:93]
  1781. ID=175
  1782. Kind=kfkData
  1783. FieldExpr=ADRESSE
  1784. DisplayName=ADRESSE
  1785. TableAlias=WORKER
  1786. EditType=0
  1787. FieldType=1
  1788. FieldSize=255
  1789. Quoted=0
  1790. UIC=0
  1791. UIR=1
  1792. Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr
  1793.  
  1794. [Field:94]
  1795. ID=176
  1796. Kind=kfkData
  1797. FieldExpr=ADRDESS_ID
  1798. DisplayName=ADRDESS_ID
  1799. TableAlias=WORKER
  1800. EditType=0
  1801. FieldType=3
  1802. FieldSize=0
  1803. Quoted=0
  1804. UIC=0
  1805. UIR=1
  1806. Operators=Equal,NotEqual,LessThan,LessOrEqual,GreaterThan,GreaterOrEqual,IsNull,InList,NotInList,StartsWith,NotStartsWith,Contains,NotContains,Between,NotBetween
  1807.  
  1808. [Field:95]
  1809. ID=177
  1810. Kind=kfkData
  1811. FieldExpr=JOBTITLE
  1812. DisplayName=JOBTITLE
  1813. TableAlias=WORKER
  1814. EditType=0
  1815. FieldType=1
  1816. FieldSize=255
  1817. Quoted=0
  1818. UIC=0
  1819. UIR=1
  1820. Operators=EqualStr,NotEqualStr,IsNullStr,IsNotNullStr,StartWithStr,NotStartWithStr,ContainsStr,NotContainsStr
  1821.  
  1822. [FieldGroup1]
  1823. GroupName=Adresse
  1824. Fields=2,3,4,5,6,7,8,9,10,11,12,13,14,15,17,18,21,22,23,24,155,156,157,158,159,160,161,162
  1825.  
  1826. [FieldGroup2]
  1827. GroupName=Person
  1828. Fields=68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,163
  1829.  
  1830. [FieldGroup3]
  1831. GroupName=Kontakt
  1832. Fields=53,54,56,57,58,60,62,64
  1833.  
  1834. [FieldGroup4]
  1835. GroupName=Datenfelder
  1836. Fields=
  1837.  
  1838. [FieldGroup5]
  1839. GroupName=Termin
  1840. Fields=33,34,45,44,35,37,38,39,40,41,42,43
  1841.  
  1842. [FieldGroup6]
  1843. GroupName=WORKER
  1844. Fields=164,165,166,167,168,169,170,171,172,173,174,175,176,177
  1845.  
  1846. [RootGroup]
  1847. Fields=
  1848.