Definition of table: EPD - definition for periodic jobs

generated: 09.12.2016 10:27:27
by UC2010.accdb

AE Database 12.0 (Step 013)



Name Type Len Attributes Description
EPD_AH_Idnr Long Integer 4 UC: Null=False Reference to AH
EPD_Lnr Integer 2 UC: Null=False Number of Definiton
EPD_FreqMode Integer 2 UC: Null=True 0=every, 1=gap, 2=once
EPD_Every Integer 2 UC: Null=True Seconds for every
EPD_Gap Integer 2 UC: Null=True Seconds for gap
EPD_Once Text 4 UC: Null=True time for once (format HHMM)
EPD_Overlap Byte 1 UC: Typ=Boolean Null=True 0=no overlap, 1=one overlap
EPD_FromTime Text 4 UC: Null=True time frame from (format HHMM)
EPD_ToTime Text 4 UC: Null=True time frame to (format HHMM)
EPD_Adjust Byte 1 UC: Typ=Boolean Null=True 0=no adjustment, 1=adjust to time frame
EPD_RangeMode Text 1 UC: Null=True 0=no end, 1=end date, 2=max runs
EPD_RangeStart Date/Time 8 UC: Null=True Start date of the range
EPD_RangeEnd Date/Time 8 UC: Null=True End date (optional)
EPD_MaxRuns Integer 2 UC: Null=True Ends after n occurencies
EPD_DaysMode Text 1 UC: Null=True W=Weekdays, C=Cale
EPD_Weekdays Text 8 UC: Null=True 1234567 or ""
EPD_CaleType Text 1 UC: Null=True CALE Type: 1=CALE AND, 2=CALE EQ, 3=CALE NE
EPD_TZ Text 8 UC: Null=True Timezone for calculation


Indexes:

Name Fields
PK_EPD EPD_AH_Idnr, EPD_Lnr


Return to the Index File