| Deletions are marked like this. | Additions are marked like this. |
| Line 11: | Line 11: |
| Descriptions of columns in the tables below: |
== Column Descriptions == Descriptions of columns used in the tables below: |
| Line 20: | Line 22: |
|
= Document = ||<tablewidth="80%"> '''Field''' || '''Type''' || '''Reqd.''' || '''RO''' || '''Size''' || '''Validation/Notes''' || || xContractLookup || n/a || n/a || n/a || n/a || ''hidden'' || |
== Field Types == Explanation of the field types values: 1. '''date''' - Date. Format is '''dd.mm.yy''' 1. '''float''' - Floating point number. Format is '''9.9''' 1. '''formula''' - Format varies 1. '''integer''' - Integer value. Format is '''9''' 1. '''menu''' - Values determined by menu 1. '''text''' - Text field, with maximum length = Document - All Fields = ||<tablewidth="80%"> '''Field''' || '''Type''' || '''Reqd.''' || '''RO''' || '''Size''' || '''Validation/Notes''' || ||<:30%> xContractLookup || n/a || n/a || n/a || n/a ||<:30%> ''hidden'' || |
| Line 48: | Line 62: |
|
= Rev-A = ||<tablewidth="80%"> '''Field''' || '''Type''' || '''Reqd.''' || '''RO''' || '''Size''' || '''Validation/Notes''' || || vorabzugMenu || menu || Y || N || n/a || locked if keyRevAId set || |
= 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 || |
| Line 71: | Line 85: |
|
== Rev-A Validation for Workflow Fields == === Erstellen(design) === |
= Rev-A Validation for Workflow Fields = == Erstellen(design) == |
| Line 82: | Line 96: |
| === Stellungnahme (check) === | == Stellungnahme (check) == |
| Line 97: | Line 111: |
| === Bereinigung (approve) === | == Bereinigung (approve) == |
| Line 111: | Line 125: |
|
= Rev-B = ||<tablewidth="80%"> '''Field''' || '''Type''' || '''Reqd.''' || '''RO''' || '''Size''' || '''Validation/Notes''' || || revBRevisionCode || text || Y || Y || n/a || || |
= Rev-B - All Fields = ||<tablewidth="80%"> '''Field''' || '''Type''' || '''Reqd.''' || '''RO''' || '''Size''' || '''Validation/Notes''' || ||<:30%> revBRevisionCode || text || Y || Y || n/a ||<:30%> || |
| Line 135: | Line 149: |
|
== Rev-B Validation for Workflow Fields == === Erstellen (design) === |
= Rev-B Validation for Workflow Fields = == Erstellen (design) == |
| Line 147: | Line 161: |
| === Prüfbericht (check) === | == Prüfbericht (check) == |
| Line 160: | Line 174: |
| === Freigabe (approve) === | == Freigabe (approve) == |
| Line 176: | Line 190: |
|
= Rev-C = ||<tablewidth="80%"> '''Field''' || '''Type''' || '''Reqd.''' || '''RO''' || '''Size''' || '''Validation/Notes''' || || revCRevisionCode || text || Y || Y || n/a || || |
= Rev-C - All Fields = ||<tablewidth="80%"> '''Field''' || '''Type''' || '''Reqd.''' || '''RO''' || '''Size''' || '''Validation/Notes''' || ||<:30%> revCRevisionCode || text || Y || Y || n/a ||<:30%> || |
| Line 198: | Line 212: |
|
== Rev-C Validation for Workflow Fields == === Versand (design) === |
= Rev-C Validation for Workflow Fields = == Versand (design) == |
| Line 211: | Line 225: |
| === erhalten (check) === | == erhalten (check) == |
| Line 224: | Line 238: |
| === übergeben (approve) === | == übergeben (approve) == |
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
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
Field Types
Explanation of the field types values:
date - Date. Format is dd.mm.yy
float - Floating point number. Format is 9.9
formula - Format varies
integer - Integer value. Format is 9
menu - Values determined by menu
text - Text field, with maximum length
Document - All Fields
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 - All Fields
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 - All Fields
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 - All Fields
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