| Deletions are marked like this. | Additions are marked like this. |
| Line 5: | Line 5: |
| Line 10: | Line 11: |
|
= 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 || 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 || ''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 == || '''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 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 || required if revAErstellIst set || || revADelta7 || integer || Y || N || n/a || >= 0 || || revAStellungStnNr || n/a || n/a || n/a || n/a || ''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-A Validation for Workflow Fields === 1. '''Erstellen''' (design) |
Descriptions of columns in the tables below: 1. '''Field''' - The field name from the ''Header Structure'' 1. '''Type''' - The field type/format validation that should be applied 1. '''Reqd.''' - Is the field required. A value must be present in the field 1. '''RO''' - Is the field ''read-only'', e.g. the user cannot edit the field 1. '''Size''' - For fields of type ''text'' the maximum number of characters 1. '''Validation/Notes''' - Validation rules of other notes = Document = ||<tablewidth="80%"> '''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 || 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 || ''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 = ||<tablewidth="80%"> '''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 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 || ''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-A Validation for Workflow Fields == === Erstellen(design) === |
| Line 73: | Line 82: |
| 1. '''Stellungnahme''' (check) |
=== Stellungnahme (check) === |
| Line 87: | Line 97: |
| 1. '''Bereinigung''' (approve) |
=== Bereinigung (approve) === |
| Line 100: | Line 111: |
|
== 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 || ''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 || ''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 || ''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 || ''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-B Validation for Workflow Fields === 1. '''Erstellen''' (design) |
= Rev-B = ||<tablewidth="80%"> '''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 || ''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 || ''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 || ''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 || ''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-B Validation for Workflow Fields == === Erstellen (design) === |
| Line 135: | Line 147: |
| 1. '''Prüfbericht''' (check) |
=== Prüfbericht (check) === |
| Line 147: | Line 160: |
| 1. '''Freigabe''' (approve) |
=== Freigabe (approve) === |
| Line 151: | Line 165: |
|
* <= ''revABereinIst'' (next step), which may not be set * required if ''revABereinIst'' (next step) step |
* <= ''revCVersandIst'' (next step), which may not be set * required if ''revCVersandIst'' (next step) step |
| Line 154: | Line 168: |
| * required if ''revABereinIst'' (this step) step | * required if ''revBFreiIst'' (this step) step |
| Line 162: | Line 176: |
|
== 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 || ''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 || || === Rev-C Validation for Workflow Fields === 1. '''Versand''' (design) |
= Rev-C = ||<tablewidth="80%"> '''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 || ''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 || || == Rev-C Validation for Workflow Fields == === Versand (design) === |
| Line 189: | Line 204: |
| * >= ''revBFreiWer'' (prev step), which may not be set | * >= ''revBFreiIst'' (prev step), which may not be set |
| Line 192: | Line 207: |
| * cannot be set if ''revCUerbergebenStatus'' is set to ''Keine Freigabe'' (rejected) | |
| Line 195: | Line 211: |
| 1. '''erhalten''' (check) |
=== erhalten (check) === |
| Line 207: | Line 224: |
| 1. '''übergeben''' (approve) |
=== übergeben (approve) === |
| Line 217: | Line 235: |
|
== 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 || |
= User Defined Fields = ||<tablewidth="80%"> '''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 || |
Excel Integration Client-Side Validation
Contents
Introduction
Client-side validation will be implemented as Excel formulas and maps, assigned to validation cell properties.
Descriptions of columns in the tables below:
Field - The field name from the Header Structure
Type - The field type/format validation that should be applied
Reqd. - 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
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
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
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
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 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
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-A Validation for Workflow Fields
Erstellen(design)
Field: revAErstellIst (design complete date)
>= today
<= revAStellungIst (next step), which may not be set
required if revAStellungIst (next step) set
Field: revAErstellWer (design responsible id)
required if revAErstellIst (this step) set
Stellungnahme (check)
Field: revAStellungIst (check complete date)
>= today
>= revAErstellIst (prev step)
<= revABereinIst (next step), which may not be set
required if revABereinIst (next step) step
Field: revAStellungWer (check responsible id)
required if revAStellungIst (this step) set
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)
Field: revABereinIst (approve complete date)
>= today
>= revAStellungIst (prev step)
<= revBErstellIst (next step), which may not be set
required if revBErstellIst (next step) step
Field: revABereinWer (approve responsible id)
required if revABereinIst (this step) step
Field: revABereinStatus (approve status)
if revABereinIst (this step) not set --> offen (open)
if revABereinIst (this step) set --> bereinigt (approved)
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
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
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
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
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-B Validation for Workflow Fields
Erstellen (design)
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
Field: revBErstellWer (design responsible id)
required if revBErstellIst (this step) set
Prüfbericht (check)
Field: revBPruefIst (check complete date)
>= today
>= revBErstellIst (prev step)
<= revBFreiIst (next step), which may not be set
required if revBFreiIst (next step) step
Field: revBPruefWer (check responsible id)
required if revBPruefIst (this step) step
Field: revBPruefStatus (check status)
if revBPruefIst (this step) not set --> offen (open)
if revBPruefIst (this step) set --> Prüfbericht erstellt (approved)
Freigabe (approve)
Field: revBFreiIst (approve complete date)
>= today
>= revBPruefIst (prev step)
<= revCVersandIst (next step), which may not be set
required if revCVersandIst (next step) step
Field: revBFreiWer (approve responsible id)
required if revBFreiIst (this step) step
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
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
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
Rev-C Validation for Workflow Fields
Versand (design)
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)
Field: revCVersandWer (design responsible id)
required if revCVersandIst (this step) set
erhalten (check)
Field: revCErhaltenIst (check complete date)
>= today
>= revCVersandIst (prev step)
<= revCUerbergebenIst (next step), which may not be set
required if revCUerbergebenIst (next step) step
Field: revCErhaltenWer (check responsible id)
required if revCErhaltenIst (this step) step
Field: revCErhaltenStatus (check status)
if revCErhaltenIst (this step) not set --> offen (open)
if revCErhaltenIst (this step) set --> erhalten (approved)
übergeben (approve)
Field: revCUerbergebenIst (approve complete date)
>= today
>= revCErhaltenIst (prev step)
Field: revCUerbergebenWer (approve responsible id)
required if revCUerbergebenIst (this step) step
Field: revCUerbergebenStatus (approve status)
if revCUerbergebenIst (this step) not set --> offen (open)
if revCUerbergebenIst (this step) set --> erfolgt (approved)
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