| Deletions are marked like this. | Additions are marked like this. |
| Line 14: | Line 14: |
|
|| '''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 || |
|| '''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'' || |
| Line 42: | Line 42: |
|
|| '''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) 1. Field: ''revAErstellIst'' * >= today * <= ''revAStellungIst'' (next step) |
|| '''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) 1. Field: ''revAErstellIst'' (design complete date) * >= today * <= ''revAStellungIst'' (next step), which may not be set |
| Line 70: | Line 70: |
| 1. Field: ''revAErstellWer'' | 1. Field: ''revAErstellWer'' (design responsible id) |
| Line 74: | Line 74: |
| 1. Field: ''revAStellungIst'' | 1. Field: ''revAStellungIst'' (check complete date) |
| Line 77: | Line 77: |
| * <= ''revABereinIst'' (next step) | * <= ''revABereinIst'' (next step), which may not be set |
| Line 79: | Line 79: |
|
1. Field: ''revAStellungWer'' * required if ''revAStellungIst'' (this step) step 1. Field: ''revAStellungStatus'' * ''open'' if ''revAStellungIst'' (this) not set * ''keine Bemerkungennon'' or ''Bemerkungen einarbeiten'' if ''revAStellungIst'' (this step) set |
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) |
| Line 86: | Line 88: |
| 1. Field: ''revABereinIst'' | 1. Field: ''revABereinIst'' (approve complete date) |
| Line 89: | Line 91: |
| * <= ''revBErstellIst'' (next step) | * <= ''revBErstellIst'' (next step), which may not be set |
| Line 91: | Line 93: |
| 1. Field: ''revABereinWer'' | 1. Field: ''revABereinWer'' (approve responsible id) |
| Line 93: | Line 95: |
|
1. Field: ''revABereinStatus'' * ''open'' if revAStellungIst (this step) not set * ''bereinigt'' if revAStellungIst (this step) set |
1. Field: ''revABereinStatus'' (approve status) * if ''revABereinIst'' (this step) not set --> ''offen'' (open) * if ''revABereinIst'' (this step) set --> ''bereinigt'' (approved) |
| Line 103: | Line 102: |
|
|| '''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 || |
|| '''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) 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 1. '''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) 1. '''Freigabe''' (approve) 1. Field: ''revBFreiIst'' (approve complete date) * >= today * >= ''revBPruefIst'' (prev step) * <= ''revABereinIst'' (next step), which may not be set * required if ''revABereinIst'' (next step) step 1. Field: ''revBFreiWer'' (approve responsible id) * required if ''revABereinIst'' (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) |
| Line 127: | Line 164: |
|
|| '''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 || || |
|| '''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) 1. Field: ''revCVersandIst'' (design complete date) * >= today * >= ''revBFreiWer'' (prev step), which may not be set * <= ''revCErhaltenIst'' (next step), which may not be set * required if ''revCErhaltenIst'' (next step) set 1. Field: ''revCVersandWer'' (design responsible id) * required if ''revCVersandIst'' (this step) set 1. '''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) 1. '''ü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) |
| Line 149: | Line 219: |
|
|| '''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 || |
|| '''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.
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)
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
1. 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)
1. 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
1. 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
1. 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)
1. Freigabe (approve)
Field: revBFreiIst (approve complete date)
>= today
>= revBPruefIst (prev step)
<= revABereinIst (next step), which may not be set
required if revABereinIst (next step) step
Field: revBFreiWer (approve responsible id)
required if revABereinIst (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
1. Versand (design)
Field: revCVersandIst (design complete date)
>= today
>= revBFreiWer (prev step), which may not be set
<= revCErhaltenIst (next step), which may not be set
required if revCErhaltenIst (next step) set
Field: revCVersandWer (design responsible id)
required if revCVersandIst (this step) set
1. 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)
1. ü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 |