| Deletions are marked like this. | Additions are marked like this. |
| Line 6: | Line 6: |
| Line 18: | Line 19: |
| 1. '''Reqd.''' - Is the field required. A value must be present in the field | 1. '''Req..''' - Is the field required. A value must be present in the field |
| Line 23: | Line 24: |
| Line 29: | Line 31: |
| 1. '''formula''' - Format varies | |
| Line 31: | Line 32: |
| 1. '''menu''' - Values determined by menu | 1. '''menu''' - Values determined by menu contents |
| Line 35: | Line 36: |
|
= Document - All Fields = ||<tablewidth="80%"> '''Field''' || '''Type''' || '''Reqd.''' || '''RO''' || '''Size''' || '''Validation/Notes''' || ||<:30%> xContractLookup || n/a || n/a || n/a || n/a ||<:30%> ''hidden'' || |
= Records = == Document == ||<colspan="6" tablewidth="90%"> '''Document Fields''' || ||<:30%> '''Field''' || '''Type''' || '''Req.''' || '''RO''' || '''Size''' ||<:30%> '''Validation/Notes''' || || xContractLookup || n/a || n/a || n/a || n/a || ''hidden'' || |
| Line 44: | Line 49: |
| || drawingIndex || formula || Y || Y || n/a || || | || drawingIndex || text || Y || Y || n/a || ''calculated'' || |
| Line 59: | Line 64: |
|
|| formatCode || n/a || n/a || n/a || n/a || ''not implemented'' || || glTech || n/a || n/a || n/a || n/a || ''not implemented'' || || glVertrag || n/a || n/a || n/a || n/a || ''not implemented'' || = Rev-A - All Fields = ||<tablewidth="80%"> '''Field''' || '''Type''' || '''Reqd.''' || '''RO''' || '''Size''' || '''Validation/Notes''' || ||<:30%> vorabzugMenu || menu || Y || N || n/a ||<:30%> locked if keyRevAId set || |
|| 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 == ||<colspan="6" tablewidth="90%"> '''Document Fields''' || ||<:30%> '''Field''' || '''Type''' || '''Req.''' || '''RO''' || '''Size''' ||<:30%> '''Validation/Notes''' || || vorabzugMenu || menu || Y || N || n/a || locked if keyRevAId set || |
| Line 73: | Line 79: |
| || revAStellungStnNr || n/a || n/a || n/a || n/a || ''not implemented'' || | || revAStellungStnNr || n/a || n/a || n/a || n/a || ''field not implemented'' || |
| Line 86: | Line 92: |
|
= Rev-A Validation for Workflow Fields = == Erstellen(design) == 1. Field: ''revAErstellIst'' (design complete date) * >= today * <= ''revAStellungIst'' (next step), which may not be set * required if ''revAStellungIst'' (next step) set 1. Field: ''revAErstellWer'' (design responsible id) * required if ''revAErstellIst'' (this step) set == Stellungnahme (check) == 1. Field: ''revAStellungIst'' (check complete date) * >= today * >= ''revAErstellIst'' (prev step) * <= ''revABereinIst'' (next step), which may not be set * required if ''revABereinIst'' (next step) step 1. Field: ''revAStellungWer'' (check responsible id) * required if ''revAStellungIst'' (this step) set 1. Field: ''revAStellungStatus'' (check status) * if ''revAStellungIst'' (this step) not set --> ''open'' (open) * if ''revAStellungIst'' (this step) set --> one of: * ''keine Bemerkungen'' (approved) * ''Bemerkungen einarbeiten'' (approved) == Bereinigung (approve) == 1. Field: ''revABereinIst'' (approve complete date) * >= today * >= ''revAStellungIst'' (prev step) * <= ''revBErstellIst'' (next step), which may not be set * required if ''revBErstellIst'' (next step) step 1. Field: ''revABereinWer'' (approve responsible id) * required if ''revABereinIst'' (this step) step 1. Field: ''revABereinStatus'' (approve status) * if ''revABereinIst'' (this step) not set --> ''offen'' (open) * if ''revABereinIst'' (this step) set --> ''bereinigt'' (approved) = Rev-B - All Fields = ||<tablewidth="80%"> '''Field''' || '''Type''' || '''Reqd.''' || '''RO''' || '''Size''' || '''Validation/Notes''' || ||<:30%> revBRevisionCode || text || Y || Y || n/a ||<:30%> || |
== Rev-B zur Freigabe == ||<colspan="6" tablewidth="90%"> '''Document Fields''' || ||<:30%> '''Field''' || '''Type''' || '''Req.''' || '''RO''' || '''Size''' ||<:30%> '''Validation/Notes''' || || revBRevisionCode || text || Y || Y || n/a || || |
| Line 134: | Line 101: |
| || revBPruefArt || n/a || n/a || n/a || n/a || ''not implemented'' || | || revBPruefArt || n/a || n/a || n/a || n/a || ''field not implemented'' || |
| Line 136: | Line 103: |
| || revBPruefNr || n/a || n/a || n/a || n/a || ''not implemented'' || | || revBPruefNr || n/a || n/a || n/a || n/a || ''field not implemented'' || |
| Line 142: | Line 109: |
| || revBQeNr || n/a || n/a || n/a || n/a || ''not implemented'' || | || revBQeNr || n/a || n/a || n/a || n/a || ''field not implemented'' || |
| Line 150: | Line 117: |
|
= Rev-B Validation for Workflow Fields = == Erstellen (design) == 1. Field: ''revBErstellIst'' (design complete date) * >= today * >= ''revABereinIst'' (prev step), which may not be set * <= ''revBPruefIst'' (next step), which may not be set * required if ''revBPruefIst'' (next step) set 1. Field: ''revBErstellWer'' (design responsible id) * required if ''revBErstellIst'' (this step) set == Prüfbericht (check) == 1. Field: ''revBPruefIst'' (check complete date) * >= today * >= ''revBErstellIst'' (prev step) * <= ''revBFreiIst'' (next step), which may not be set * required if ''revBFreiIst'' (next step) step 1. Field: ''revBPruefWer'' (check responsible id) * required if ''revBPruefIst'' (this step) step 1. Field: ''revBPruefStatus'' (check status) * if ''revBPruefIst'' (this step) not set --> ''offen'' (open) * if ''revBPruefIst'' (this step) set --> ''Prüfbericht erstellt'' (approved) == Freigabe (approve) == 1. Field: ''revBFreiIst'' (approve complete date) * >= today * >= ''revBPruefIst'' (prev step) * <= ''revCVersandIst'' (next step), which may not be set * required if ''revCVersandIst'' (next step) step 1. Field: ''revBFreiWer'' (approve responsible id) * required if ''revBFreiIst'' (this step) step 1. Field: ''revBFreiStatus'' (approve status) * if ''revBFreiIst'' (this step) not set --> ''offen'' (open) * if ''revBFreiIst'' (this step) set --> one of: * ''Keine freigabe'' (rejected) * ''ohne Berkungen'' (approved) * ''mit Berkungen'' (approved) = Rev-C - All Fields = ||<tablewidth="80%"> '''Field''' || '''Type''' || '''Reqd.''' || '''RO''' || '''Size''' || '''Validation/Notes''' || ||<:30%> revCRevisionCode || text || Y || Y || n/a ||<:30%> || |
== Rev-C gut zur Ausführung / freigegeben == ||<colspan="6" tablewidth="90%"> '''Document Fields''' || ||<:30%> '''Field''' || '''Type''' || '''Req.''' || '''RO''' || '''Size''' ||<:30%> '''Validation/Notes''' || || revCRevisionCode || text || Y || Y || n/a || || |
| Line 213: | Line 140: |
|
= Rev-C Validation for Workflow Fields = == Versand (design) == 1. Field: ''revCVersandIst'' (design complete date) * >= today * >= ''revBFreiIst'' (prev step), which may not be set * <= ''revCErhaltenIst'' (next step), which may not be set * required if ''revCErhaltenIst'' (next step) set * cannot be set if ''revCUerbergebenStatus'' is set to ''Keine Freigabe'' (rejected) 1. Field: ''revCVersandWer'' (design responsible id) * required if ''revCVersandIst'' (this step) set == erhalten (check) == 1. Field: ''revCErhaltenIst'' (check complete date) * >= today * >= ''revCVersandIst'' (prev step) * <= ''revCUerbergebenIst'' (next step), which may not be set * required if ''revCUerbergebenIst'' (next step) step 1. Field: ''revCErhaltenWer'' (check responsible id) * required if ''revCErhaltenIst'' (this step) step 1. Field: ''revCErhaltenStatus'' (check status) * if ''revCErhaltenIst'' (this step) not set --> ''offen'' (open) * if ''revCErhaltenIst'' (this step) set --> ''erhalten'' (approved) == übergeben (approve) == 1. Field: ''revCUerbergebenIst'' (approve complete date) * >= today * >= ''revCErhaltenIst'' (prev step) 1. Field: ''revCUerbergebenWer'' (approve responsible id) * required if ''revCUerbergebenIst'' (this step) step 1. Field: ''revCUerbergebenStatus'' (approve status) * if ''revCUerbergebenIst'' (this step) not set --> ''offen'' (open) * if ''revCUerbergebenIst'' (this step) set --> ''erfolgt'' (approved) = User Defined Fields = ||<tablewidth="80%"> '''Field''' || '''Type''' || '''Reqd.''' || '''RO''' || '''Size''' || '''Validation/Notes''' || |
== User Defined Fields == ||<colspan="6" tablewidth="90%"> '''Document Fields''' || ||<:30%> '''Field''' || '''Type''' || '''Req.''' || '''RO''' || '''Size''' ||<:30%> '''Validation/Notes''' || |
| Line 280: | Line 171: |
|
= Workflow Validation = == Rev-A Vorabzug == === Erstellen(design) === 1. Field: '''''revAErstellIst''''' (design complete date) * required if ''revAStellungIst'' (next step) is set * <= today * <= ''revAStellungIst'' (next step), which may not be set 1. Field: '''''revAErstellWer''''' (design responsible id) * required if ''revAErstellIst'' (this step) is set === Stellungnahme (check) === 1. 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 1. Field: '''''revAStellungWer''''' (check responsible id) * required if ''revAStellungIst'' (this step) is set 1. 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) === 1. 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 1. Field: '''''revABereinWer''''' (approve responsible id) * required if ''revABereinIst'' (this step) is set 1. 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) === 1. Field: '''''revBErstellIst''''' (design complete date) * cannot be set if ''revABereinIst'' (prev step) is not set * required if ''revBPruefIst'' (next step) is set * <= today * >= ''revABereinIst'' (prev step), which may not be set * <= ''revBPruefIst'' (next step), which may not be set 1. Field: '''''revBErstellWer''''' (design responsible id) * required if ''revBErstellIst'' (this step) is set === Prüfbericht (check) === 1. 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 1. Field: '''''revBPruefWer''''' (check responsible id) * required if ''revBPruefIst'' (this step) is set 1. 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) === 1. 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 1. Field: '''''revBFreiWer''''' (approve responsible id) * required if ''revBFreiIst'' (this step) is set 1. 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) === 1. Field: '''''revCVersandIst''''' (design complete date) * cannot be set if ''revBPruefIst'' (prev step) is not set * cannot be set if ''revBPruefIst'' (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 1. Field: '''''revCVersandWer''''' (design responsible id) * required if ''revCVersandIst'' (this step) is set === erhalten (check) === 1. Field: '''''revCErhaltenIst''''' (check complete date) * cannot be set if ''revCVersandIst'' (prev step) is not set * required if ''revCUerbergebenIst'' (next step) is set * <= today * >= ''revCVersandIst'' (prev step) * <= ''revCUerbergebenIst'' (next step), which may not be set 1. Field: '''''revCErhaltenWer''''' (check responsible id) * required if ''revCErhaltenIst'' (this step) is set 1. Field: '''''revCErhaltenStatus''''' (check status) * if ''revCErhaltenIst'' (this step) is not set --> ''offen'' (open) * if ''revCErhaltenIst'' (this step) is set --> ''erhalten'' (approved) === übergeben (approve) === 1. Field: '''''revCUerbergebenIst''''' (approve complete date) * cannot be set if ''revCErhaltenIst'' (prev step) is not set * <= today * >= ''revCErhaltenIst'' (prev step) 1. Field: '''''revCUerbergebenWer''''' (approve responsible id) * required if ''revCUerbergebenIst'' (this step) is set 1. Field: '''''revCUerbergebenStatus''''' (approve status) * if ''revCUerbergebenIst'' (this step) is not set --> ''offen'' (open) * if ''revCUerbergebenIst'' (this step) is set --> ''erfolgt'' (approved) |
Excel Integration Client-Side Validation
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 the field required. A value must be present in the field
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
revCUerbergebenIst
date
Y
N
n/a
see below
revCUerbergebenWer
menu
Y
N
n/a
see below
revCUerbergebenStatus
menu
Y
N
n/a
see below
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
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)
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)
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)
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)
Field: revBErstellIst (design complete date)
cannot be set if revABereinIst (prev step) is not set
required if revBPruefIst (next step) is set
<= today
>= 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)
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)
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)
Field: revCVersandIst (design complete date)
cannot be set if revBPruefIst (prev step) is not set
cannot be set if revBPruefIst (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)
Field: revCErhaltenIst (check complete date)
cannot be set if revCVersandIst (prev step) is not set
required if revCUerbergebenIst (next step) is set
<= today
>= revCVersandIst (prev step)
<= revCUerbergebenIst (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)
Field: revCUerbergebenIst (approve complete date)
cannot be set if revCErhaltenIst (prev step) is not set
<= today
>= revCErhaltenIst (prev step)
Field: revCUerbergebenWer (approve responsible id)
required if revCUerbergebenIst (this step) is set
Field: revCUerbergebenStatus (approve status)
if revCUerbergebenIst (this step) is not set --> offen (open)
if revCUerbergebenIst (this step) is set --> erfolgt (approved)