| Deletions are marked like this. | Additions are marked like this. |
| Line 263: | Line 263: |
| * >= ''revABereinIst'' (prev step), which may not be set |
* if ''revBVorabzugFlag'' then * >= ''revABereinIst'' (prev step), which may not be set |
Excel Integration Client-Side Validation
Contents
Introduction
Client-side validation will be implemented as Excel formulas and maps, assigned to validation cell properties.
Column Descriptions
Descriptions of columns used in the tables below:
Field - The field name from the Header Structure
Type - The field type/format validation that should be applied
Req. - Is a value for the field required?
RO - Is the field read-only, e.g. the user cannot edit the field
Size - For fields of type text the maximum number of characters
Validation/Notes - Validation rules of other notes
Field Types
Explanation of the field types values:
date - Date. Format is dd.mm.yy
float - Floating point number. Format is 9.9
integer - Integer value. Format is 9
menu - Values determined by menu contents
text - Text field, with maximum length
Records
Document
Document Fields
Field
Type
Req.
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
text
Y
Y
n/a
calculated
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
3
[A-Za-z0-9]
externalKeyDoc
text
Y
N
255
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
n/a
n/a
n/a
n/a
field not implemented
glTech
n/a
n/a
n/a
n/a
field not implemented
glVertrag
n/a
n/a
n/a
n/a
field not implemented
Rev-A Vorabzug
Document Fields
Field
Type
Req.
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 if keyRevAId is set
revARevisionCode
text
Y
Y
n/a
revATv
date
Y
Y
n/a
calculated
revAErstellIst
date
Y
N
n/a
see below
revAErstellWer
menu
Y
N
n/a
see below
revADelta7
integer
Y
N
n/a
>= 0
revAStellungStnNr
n/a
n/a
n/a
n/a
field not implemented
revAStellungSoll
date
Y
Y
n/a
calculated
revAStellungIst
date
Y
N
n/a
see below
revAStellungWer
menu
Y
N
n/a
see below
revAStellungStatus
menu
Y
N
n/a
see below
revAStellungStatusFormula
n/a
n/a
n/a
n/a
hidden
revADelta6
integer
Y
N
n/a
>= 0
revABereinSoll
date
Y
Y
n/a
calculated
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-B zur Freigabe
Document Fields
Field
Type
Req.
RO
Size
Validation/Notes
revBRevisionCode
text
Y
Y
n/a
revBDelta5
integer
Y
N
n/a
>= 0
revBTzf
date
Y
Y
n/a
calculated
revBErstellIst
date
Y
N
n/a
see below
revBErstellWer
menu
Y
N
n/a
see below
revBPruefArt
n/a
n/a
n/a
n/a
field not implemented
revBDelta4
integer
Y
N
n/a
>= 0
revBPruefNr
n/a
n/a
n/a
n/a
field not implemented
revBPruefSoll
date
Y
Y
n/a
calculated
revBPruefIst
date
Y
N
n/a
see below
revBPruefWer
menu
Y
N
n/a
see below
revBPruefStatus
menu
Y
N
n/a
see below
revBPruefStatusFormula
n/a
n/a
n/a
n/a
hidden
revBQeNr
n/a
n/a
n/a
n/a
field not implemented
revBDelta3
integer
Y
N
n/a
>= 0
revBTf
date
Y
Y
n/a
calculated
revBFreiIst
date
Y
N
n/a
see below
revBFreiWer
menu
Y
N
n/a
see below
revBFreiStatus
menu
Y
N
n/a
see below
revBFreiStatusLookupFormula
n/a
n/a
n/a
n/a
hidden
Rev-C gut zur Ausführung / freigegeben
Document Fields
Field
Type
Req.
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
see below
revCVersandWer
menu
Y
N
n/a
see below
revCErhaltenIst
date
Y
N
n/a
see below
revCErhaltenWer
menu
Y
N
n/a
see below
revCErhaltenStatus
menu
Y
N
n/a
see below
revCErhaltenStatusFormula
n/a
n/a
n/a
n/a
hidden
revCDelta2
integer
Y
N
n/a
>= 0
revCTgza
date
Y
Y
n/a
calculated
revCUebergebenIst
date
Y
N
n/a
see below
revCUebergebenWer
menu
Y
N
n/a
see below
revCUebergebenStatus
menu
Y
N
n/a
see below
revCUebergebenStatusFormula
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
Document Fields
Field
Type
Req.
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
Workflow Validation
Rev-A Vorabzug
Erstellen (design)
Workflow Steps
Prev step: n/a
This step: revAErstell
Next step: revAStellung
Validation Rules
Field: revAErstellIst (design complete date)
required if revAStellungIst (next step) is set
<= today
<= revAStellungIst (next step), which may not be set
Field: revAErstellWer (design responsible id)
required if revAErstellIst (this step) is set
Stellungnahme (check)
Workflow Steps
Prev step: revAErstell
This step: revAStellung
Next step: revABerein
Validation Rules
Field: revAStellungIst (check complete date)
cannot be set if revAErstellIst (prev step) is not set
required if revABereinIst (next step) is set
<= today
>= revAErstellIst (prev step)
<= revABereinIst (next step), which may not be set
Field: revAStellungWer (check responsible id)
required if revAStellungIst (this step) is set
Field: revAStellungStatus (check status)
if revAStellungIst (this step) is not set --> offen (open)
if revAStellungIst (this step) is set --> one of:
keine Bemerkungen (approved)
Bemerkungen einarbeiten (approved with comments)
Bereinigung (approve)
Workflow Steps
Prev step: revAStellung
This step: revABerein
Next step: revBErstell
Validation Rules
Field: revABereinIst (approve complete date)
cannot be set if revAStellungIst (prev step) is not set
required if revBErstellIst (next step) is set
<= today
>= revAStellungIst (prev step)
<= revBErstellIst (next step), which may not be set
Field: revABereinWer (approve responsible id)
required if revABereinIst (this step) is set
Field: revABereinStatus (approve status)
if revABereinIst (this step) is not set --> offen (open)
if revABereinIst (this step) is set --> bereinigt (approved)
Rev-B zur Freigabe
Erstellen (design)
Workflow Steps
Prev step: revABerein
This step: revBErstell
Next step: revBPruef
Validation Rules
Field: revBErstellIst (design complete date)
cannot be set if revABereinIst (prev step) is not set
required if revBPruefIst (next step) is set
<= today
if revBVorabzugFlag then
>= revABereinIst (prev step), which may not be set
<= revBPruefIst (next step), which may not be set
Field: revBErstellWer (design responsible id)
required if revBErstellIst (this step) is set
Prüfbericht (check)
Workflow Steps
Prev step: revBErstell
This step: revBPruef
Next step: revBFrei
Validation Rules
Field: revBPruefIst (check complete date)
cannot be set if revBErstellIst (prev step) is not set
required if revBFreiIst (next step) is set
<= today
>= revBErstellIst (prev step)
<= revBFreiIst (next step), which may not be set
Field: revBPruefWer (check responsible id)
required if revBPruefIst (this step) is set
Field: revBPruefStatus (check status)
if revBPruefIst (this step) is not set --> offen (open)
if revBPruefIst (this step) is set --> Prüfbericht erstellt (approved)
Freigabe (approve)
Workflow Steps
Prev step: revBPruef
This step: revBFrei
Next step: revCVersand
Validation Rules
Field: revBFreiIst (approve complete date)
cannot be set if revBPruefIst (prev step) is not set
required if revCVersandIst (next step) is set
<= today
>= revBPruefIst (prev step)
<= revCVersandIst (next step), which may not be set
Field: revBFreiWer (approve responsible id)
required if revBFreiIst (this step) is set
Field: revBFreiStatus (approve status)
if revBFreiIst (this step) is not set --> offen (open)
if revBFreiIst (this step) is set --> one of:
Keine freigabe (rejected)
ohne Berkungen (approved)
mit Berkungen (approved with comments)
Rev-C gut zur Ausführung / freigegeben
Versand (design)
Workflow Steps
Prev step: revBFrei
This step: revCVersand
Next step: revCErhalten
Validation Rules
Field: revCVersandIst (design complete date)
cannot be set if revBFreiIst (prev step) is not set
cannot be set if revBFreiIst (prev step) is set to Keine Freigabe (rejected)
required if revCErhaltenIst (next step) is set
<= today
>= revBFreiIst (prev step), which may not be set
<= revCErhaltenIst (next step), which may not be set
Field: revCVersandWer (design responsible id)
required if revCVersandIst (this step) is set
erhalten (check)
Workflow Steps
Prev step: revCVersand
This step: revCErhalten
Next step: revCUebergeben
Validation Rules
Field: revCErhaltenIst (check complete date)
cannot be set if revCVersandIst (prev step) is not set
required if revCUebergebenIst (next step) is set
<= today
>= revCVersandIst (prev step)
<= revCUebergebenIst (next step), which may not be set
Field: revCErhaltenWer (check responsible id)
required if revCErhaltenIst (this step) is set
Field: revCErhaltenStatus (check status)
if revCErhaltenIst (this step) is not set --> offen (open)
if revCErhaltenIst (this step) is set --> erhalten (approved)
übergeben (approve)
Workflow Steps
Prev step: revCErhalten
This step: revCUebergeben
Next step: n/a
Validation Rules
Field: revCUebergebenIst (approve complete date)
cannot be set if revCErhaltenIst (prev step) is not set
<= today
>= revCErhaltenIst (prev step)
Field: revCUebergebenWer (approve responsible id)
required if revCUebergebenIst (this step) is set
Field: revCUebergebenStatus (approve status)
if revCUebergebenIst (this step) is not set --> offen (open)
if revCUebergebenIst (this step) is set --> erfolgt (approved)