|
|
SAP Business One SDK 10.0 - Database Tables Reference |
User Fields - Description
Table Name: CUFD
Table Description: User Fields - Description
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| TableID | Table | nVarChar | 21 | - | Â | Â | Â |
| FieldID | Field | Int | 6 | - | Â | Â | Â |
| AliasID | Title | nVarChar | 50 | - | Â | Â | Â |
| Descr | Description | nVarChar | 80 | - | Â | Â | Â |
| TypeID | Type | VarChar | 1 | - | Â | Â | Â |
| EditType | Edit Type | VarChar | 1 | - | Â | Â | Â |
| SizeID | Size | Int | 6 | - | Â | Â | Â |
| EditSize | Edit Size | Int | 6 | - | Â | Â | Â |
| Dflt | Default | nVarChar | 254 | - | Â | Â | Â |
| NotNull | Required Entry Field | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| IndexID | Create Index | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RTable | Linked Table | nVarChar | 21 | OUTB | Â | Â | Â |
| RField | Linked Field | Int | 6 | - | Â | Â | Â |
| Action | Action | VarChar | 1 | - | Â | Â | Â |
| Sys | System Defined? | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DfltDate | Default Date | Date | 8 | - | Â | Â | Â |
| RelUDO | Related UDO | nVarChar | 20 | - | Â | Â | Â |
| ValidRule | Validation Rule | nVarChar | 254 | - | Â | Â | Â |
| RelSO | Related System Object | nVarChar | 20 | - | Â | Â | Â |
| RThrdPTab | Related to Third Party Table | nVarChar | 100 | - | Â | Â | Â |
| RThrdPFld | Related to Third Party Field | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | TableID |
| Â | Â | FieldID |
| ALIAS | Yes | TableID |
| Â | Â | AliasID |