Excel Integration Client-Side Validation
Contents
Introduction
Client-side validation will be implemented as Excel formulas and maps, assigned to validation cell properties.
Validation Configuration
Document
Field
Type
Reqd.
RO
Size
Validation/Notes
xContractLookup
n/a
n/a
n/a
n/a
hidden
bereichCode
menu
Y
N
n/a
locked if keyDocId set
gruppeCodeMenu
menu
Y
N
n/a
gruppeCodeLookup
n/a
n/a
n/a
n/a
hidden
archivCode
menu
Y
N
n/a
archivCodeLookup
n/a
n/a
n/a
n/a
hidden
drawingIndex
formula
Y
Y
n/a
zugriffCode
menu
Y
N
n/a
projektphaseCode
menu
Y
N
n/a
fachCode
menu
Y
N
n/a
objektCode
menu
Y
N
n/a
kontaktCode
menu
Y
N
n/a
documenttypCode
menu
Y
N
n/a
drawingNo
integer
Y
N
n/a
>= 0, <= 9999
partNo
text
Y
N
?
?
externalKeyDoc
text
Y
N
?
titel1
text
Y
N
255
titel2
text
N
N
255
titel3
text
N
N
255
titel4
text
N
N
255
massstab
text
N
N
64
formatCode
?
Y
?
n/a
?
glTech
n/a
n/a
n/a
n/a
not implemented
glVertrag
n/a
n/a
n/a
n/a
not implemented
Rev-A
Field
Type
Reqd.
RO
Size
Validation/Notes
vorabzugMenu
menu
Y
N
n/a
locked if keyRevAId set
revBVorabzugFlag
n/a
n/a
n/a
n/a
hidden, set to 1 is keyRevAId set
revARevisionCode
text
Y
Y
n/a
revATv
date
Y
Y
n/a
revAErstellIst
date
Y
N
n/a
revAErstellWer
menu
Y
N
n/a
revADelta7
integer
Y
N
n/a
>= 0
revAStellungStnNr
n/a
n/a
n/a
n/a
not implemented
revAStellungSoll
date
Y
Y
n/a
revAStellungIst
date
Y
N
n/a
revAStellungWer
menu
Y
N
n/a
revAStellungStatus
menu
Y
N
n/a
revAStellungStatusFormula
n/a
n/a
n/a
n/a
hidden
revADelta6
integer
Y
N
n/a
>= 0
revABereinSoll
date
Y
Y
n/a
revABereinIst
date
Y
N
n/a
revABereinWer
menu
Y
N
n/a
revABereinStatus
menu
Y
N
n/a
revABereinStatusFormula
n/a
n/a
n/a
n/a
hidden
Rev-A Validaion for Workflow Fields
1. Erstellen (design)
Field: revAErstellIst
>= today
<= revAStellungIst (next step)
required if revAStellungIst (next step) set
Field: revAErstellWer
required if revAErstellIst (this step) set
1. Stellungnahme (check)
Field: revAStellungIst
>= today
>= revAErstellIst (prev step)
<= revABereinIst (next step)
required if revABereinIst (next step) step
Field: revAStellungWer
required if revAStellungIst (this step) step
Field: revAStellungStatus
open if revAStellungIst (this) not set
keine Bemerkungennon or Bemerkungen einarbeiten if revAStellungIst (this step) set
1. Bereinigung (approve)
Field: revABereinIst
>= today
>= revAStellungIst (prev step)
<= revBErstellIst (next step)
required if revBErstellIst (next step) step
Field: revABereinWer
required if revABereinIst (this step) step
Field: revABereinStatus
open if revAStellungIst (this step) not set
bereinigt if revAStellungIst (this step) set
Rev-B
Field
Type
Reqd.
RO
Size
Validation/Notes
revBRevisionCode
text
Y
Y
n/a
revBDelta5
integer
Y
N
n/a
>= 0
revBTzf
date
Y
Y
n/a
revBErstellIst
date
Y
N
n/a
revBErstellWer
menu
Y
N
n/a
revBPruefArt
n/a
n/a
n/a
n/a
not implemented
revBDelta4
integer
Y
N
n/a
>= 0
revBPruefNr
n/a
n/a
n/a
n/a
not implemented
revBPruefSoll
date
Y
Y
n/a
revBPruefIst
date
Y
N
n/a
revBPruefWer
menu
Y
N
n/a
revBPruefStatus
menu
Y
N
n/a
revBPruefStatusFormula
n/a
n/a
n/a
n/a
hidden
revBQeNr
n/a
n/a
n/a
n/a
not implemented
revBDelta3
integer
Y
N
n/a
>= 0
revBTf
date
Y
Y
n/a
revBFreiIst
date
Y
N
n/a
revBFreiWer
menu
Y
N
n/a
revBFreiStatus
menu
Y
N
n/a
revBFreiStatusLookupFormula
n/a
n/a
n/a
n/a
hidden
Rev-C
Field
Type
Reqd.
RO
Size
Validation/Notes
revCRevisionCode
text
Y
Y
n/a
x_revCRevisionTypeMenu
menu
Y
N
n/a
revCRevisionTypeId
n/a
n/a
n/a
n/a
hidden
revCVersandIst
date
Y
N
n/a
revCVersandWer
menu
Y
N
n/a
revCErhaltenIst
date
Y
N
n/a
revCErhaltenWer
menu
Y
N
n/a
revCErhaltenStatus
menu
Y
N
n/a
revCErhaltenStatusFormula
n/a
n/a
n/a
n/a
hidden
revCDelta2
integer
Y
N
n/a
>= 0
revCTgza
date
Y
Y
n/a
revCUerbergebenIst
date
Y
N
n/a
revCUerbergebenWer
menu
Y
N
n/a
revCUerbergebenStatus
menu
Y
N
n/a
revCUerbergebenStatusFormula
n/a
n/a
n/a
n/a
hidden
revCDelta1
integer
Y
N
n/a
>= 0
revCT0
date
Y
N
n/a
revCT0wv
date
Y
N
n/a
User Defined Fields
Field
Type
Reqd.
RO
Size
Validation/Notes
resourcePlanCad
float
Y
N
n/a
>= 0
resourcePlanPi
float
Y
N
n/a
>= 0
resourcePlanPl
float
Y
N
n/a
>= 0
resourcePlanVon
date
Y
Y
n/a
resourcePlanBis
date
Y
Y
n/a
resourcePlAxpo
float
Y
N
n/a
>= 0
resourcePlPruef
float
Y
N
n/a
>= 0
resourcePlVon
date
Y
Y
n/a
resourcePlBis
date
Y
Y
n/a
verteilerRevAPl
integer
Y
N
n/a
>= 0
verteilerRevAPi
integer
Y
N
n/a
>= 0
verteilerRevAOebl
integer
Y
N
n/a
>= 0
verteilerRevAUn
integer
Y
N
n/a
>= 0
verteilerRevAExt
integer
Y
N
n/a
>= 0
verteilerRevAAblage
integer
Y
N
n/a
>= 0
verteilerRevBPl
integer
Y
N
n/a
>= 0
verteilerRevBPi
integer
Y
N
n/a
>= 0
verteilerRevBOebl
integer
Y
N
n/a
>= 0
verteilerRevBUn
integer
Y
N
n/a
>= 0
verteilerRevBExt
integer
Y
N
n/a
>= 0
verteilerRevBAblage
integer
Y
N
n/a
>= 0
verteilerRevCPl
integer
Y
N
n/a
>= 0
verteilerRevCPi
integer
Y
N
n/a
>= 0
verteilerRevCOebl
integer
Y
N
n/a
>= 0
verteilerRevCUn
integer
Y
N
n/a
>= 0
verteilerRevCExt
integer
Y
N
n/a
>= 0
verteilerRevCAblage
integer
Y
N
n/a
>= 0