| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | AbsEntry | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | Code | Template Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | Dscription | Description | nvarchar | 50 | 0 | | | | Allow NULL? |
| 4 | IsRemoved | Is Removed | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 5 | DocObjType | Linked Document Type | nvarchar | 20 | 0 | | -1 | (-, -1, -13, -18, 1250000001, 13, 14, 15, 16, 17, 18, 19, 20, 203, 204, 21, 22, 23, 540000006, 59, 60, 67 | Allow NULL? |
| 6 | DraftEntry | Linked Draft Entry | int | 11 | 0 | ODRF | | | Allow NULL? |
| 7 | Frequency | Frequency | char | 1 | 0 | | M | A, D, M, O, Q, S, W | Allow NULL? |
| 8 | Remind | Sub-Frequency | int | 6 | 0 | | 1001 | -1, 1, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 101, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 102, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 103, 1030, 1031, 104, 105, 106, 107, 108, 109, 110, 115, 130, 145, 160, 2, 3, 4, 5, 6, 7 | Allow NULL? |
| 9 | StartDate | Execution Start Date | date | 8 | 0 | | | | |
| 10 | EndDate | Execution End Date | date | 8 | 0 | | | | |
| 11 | LogInstanc | Log Instance | int | 6 | 0 | | 0 | | Allow NULL? |
| 12 | CreateUser | Created by User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 13 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 14 | CreateTime | Creation Time | int | 6 | 0 | | | | Allow NULL? |
| 15 | UpdateUser | Updated by User | nvarchar | 6 | 0 | OUSR | | | Allow NULL? |
| 16 | UpdateDate | Update Date | date | 8 | 0 | | | | |
| 17 | UpdateTime | Update Time | int | 6 | 0 | | | | Allow NULL? |
| 18 | DataSource | Data Source | char | 1 | 0 | | N | A, D, I, M, N, O, P, T, U | Allow NULL? |
