Definition of table: APD - perdiodical jobs definition (archived)

generated: 09.12.2016 10:26:56
by UC2010.accdb

AE Database 12.0 (Step 013)



Name Type Len Attributes Description
APD_AH_Idnr Long Integer 4 UC: Null=False reference to the archive header (AH)
APD_Lnr Integer 2 UC: Null=False Number of Definiton
APD_FreqMode Integer 2 UC: Null=True 0=every, 1=gap, 2=once
APD_Every Integer 2 UC: Null=True Seconds for every
APD_Gap Integer 2 UC: Null=True Seconds for gap
APD_Once Text 4 UC: Null=True time for once (format HHMM)
APD_Overlap Byte 1 UC: Typ=Boolean Null=True 0=no overlap, 1=one overlap
APD_FromTime Text 4 UC: Null=True time frame from (format HHMM)
APD_ToTime Text 4 UC: Null=True time frame to (format HHMM)
APD_Adjust Byte 1 UC: Typ=Boolean Null=True 0=no adjustment, 1=adjust to time frame
APD_RangeMode Text 1 UC: Null=True 0=no end, 1=end date, 2=max runs
APD_RangeStart Date/Time 8 UC: Null=True Start date of the range
APD_RangeEnd Date/Time 8 UC: Null=True End date (optional)
APD_MaxRuns Integer 2 UC: Null=True Ends after n occurencies
APD_DaysMode Text 1 UC: Null=True W=Weekdays, C=Cale
APD_Weekdays Text 8 UC: Null=True 1234567 or ""
APD_CaleType Text 1 UC: Null=True CALE Type: 1=CALE AND, 2=CALE EQ, 3=CALE NE
APD_TZ Text 8 UC: Null=True Timezone for calculation


Indexes:

Name Fields
PK_APD APD_AH_Idnr, APD_Lnr


Return to the Index File