| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | TableName | Table Name | nvarchar | 5 | 0 | | | | Allow NULL? |
| 2 | FieldIndex | Field Index | int | 6 | 0 | | | | Allow NULL? |
| 3 | Name | Field Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 4 | Alias | Alias | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | Descr | Description | nvarchar | 250 | 0 | | | | Allow NULL? |
| 6 | Type | Type | char | 1 | 0 | | A | A=DB Alpha, B=DB Binary, D=DB Date, I=DB Auto Key, M=DB Memo, N=DB Numeric | Allow NULL? |
| 7 | Size | Size | int | 6 | 0 | | | | Allow NULL? |
| 8 | FieldType | Field Type Num | int | 6 | 0 | | | | Allow NULL? |
| 9 | Visible | Visible | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 10 | EditType | Edit Type | char | 1 | 0 | | | | Allow NULL? |
| 11 | EditSize | Edit Size | int | 6 | 0 | | | | Allow NULL? |
| 12 | RFile | Related Table | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | ColHeading | Column Heading | nvarchar | 30 | 0 | | | | Allow NULL? |
| 14 | FrmHeading | Form Heading | nvarchar | 30 | 0 | | | | Allow NULL? |
| 15 | GroupNum | Group Number | int | 6 | 0 | | 0 | -1=System, 0=User | Allow NULL? |
| 16 | DefaultVal | Default Value | nvarchar | 254 | 0 | | | | Allow NULL? |
| 17 | DIStatus | DI Status | char | 1 | 0 | | E | E=NOT DEFINED, N=Not added to DI, R=Added as Read Only, Y=Added as Read/Write | Allow NULL? |
| 18 | Dirty | Dirty | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 19 | Flag1 | Flag1 | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 20 | UpdateDate | Update Date | date | 8 | 0 | | | | |
| 21 | UpdateTime | Update Time | int | 11 | 0 | | 0 | | Allow NULL? |
| 22 | UsrSgnAttr | User Sign For Attribs Change | int | 11 | 0 | | -1 | | Allow NULL? |
| 23 | ResCode | Resource Code from RSBD | int | 11 | 0 | | -1 | | Allow NULL? |
| 24 | RevCode | Revision Code | int | 11 | 0 | | -1 | | Allow NULL? |
| 25 | AssGrp | Association Group | nvarchar | 16 | 0 | | | | Allow NULL? |
| 26 | AssType | Association Type | nvarchar | 2 | 0 | | -1 | -1, A1=Array Key 1, A2=Array Key 2, A3=Array Key 3, AO=Array Offset, O1=Object Key Seg. 1, O2=Object Key Seg. 2, O3=Object Key Seg. 3, O4=Object Key Seg. 4, O5=Object Key Seg. 5, O6=Object Key Seg. 6, OT=Object Type | Allow NULL? |
| 27 | IsPersist | Is Field Persistant | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
