Definition of table: OPD - Period Object attributes

generated: 12.12.2016 18:34:28
by UC2010.accdb

AE Database 11.2 (Step 018)



Name Type Len Attributes Description
OPD_OH_Idnr Long Integer 4 UC: Null=False Reference to OH
OPD_FreqMode Integer 2 UC: Null=True 0=every, 1=gap, 2=once
OPD_Every Integer 2 UC: Null=True Seconds for every
OPD_Gap Integer 2 UC: Null=True Seconds for gap
OPD_Once Text 4 UC: Null=True time for once (format HHMM)
OPD_Overlap Byte 1 UC: Typ=Boolean Null=True 0=no overlap, 1=one overlap
OPD_FromTime Text 4 UC: Null=True time frame from (format HHMM)
OPD_ToTime Text 4 UC: Null=True time frame to (format HHMM)
OPD_Adjust Byte 1 UC: Typ=Boolean Null=True 0=no adjustment, 1=adjust to time frame
OPD_RangeMode Text 1 UC: Null=True 0=no end, 1=end date, 2=max runs
OPD_RangeStart Date/Time 8 UC: Null=True Start date of the range
OPD_RangeEnd Date/Time 8 UC: Null=True End date (optional)
OPD_MaxRuns Integer 2 UC: Null=True Ends after n occurencies
OPD_DaysMode Text 1 UC: Null=True W=Weekdays, C=Cale
OPD_Weekdays Text 8 UC: Null=True 1234567 or ""
OPD_CaleType Text 1 UC: Null=True CALE Type: 1=CALE AND, 2=CALE EQ, 3=CALE NE


Indexes:

Name Fields
PK_OPD OPD_OH_Idnr


Return to the Index File