Microsoft Access TFACD (Calendar)
You should read the table from top to bottom to see the order in which the data fields are stored in the data records in the Access database.
Field name is the name of the field in the table. Type shows the field’s attribute and length gives the length of the data field. Text indicates the type of data.
Field name |
Type |
Length |
Text |
IDENT |
CHAR |
2 |
Factory calendar ID |
VJAHR |
NUMC |
4 |
From (year) |
BJAHR |
NUMC |
4 |
To (year) |
MOTAG |
CHAR |
1 |
Bit for workday |
DITAG |
CHAR |
1 |
Bit for workday |
MIWCH |
CHAR |
1 |
Bit for workday |
DOTAG |
CHAR |
1 |
Bit for workday |
FRTAG |
CHAR |
1 |
Bit for workday |
SATAG |
CHAR |
1 |
Bit for workday |
SOTAG |
CHAR |
1 |
Bit for workday |
FETAG |
CHAR |
1 |
Bit for workday |
HOCID |
CHAR |
2 |
Holiday calendar ID |
BASIS |
NUMC |
5 |
No. first work |
ABBR |
CHAR |
1 |
Termination flag |
CRUSR |
CHAR |
12 |
User |
CRDAT |
DATS |
10 |
Created on |
CRTIME |
TIMS |
8 |
Change time |
INTERV |
CHAR |
1 |
Termination flag |
AKTVJAHR |
NUMC |
4 |
Active from (year) |
AKTBJAHR |
NUMC |
4 |
Active to (year) |