title: "SFIELD (table)" category: reference tags: [table, sfield, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.SFIELD
Schema: dba
Aantal kolommen: 23
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
SFIENAME |
nvarchar(128) | Nee | — | — |
SFIEContext |
bigint | Nee | ((0)) | — |
SFIERecStatus |
int | Nee | ((0)) | — |
SFIEANONYMIZE |
smallint | Ja | ((0)) | — |
SFIECOPYFROM |
nvarchar(128) | Ja | — | — |
SFIEDATATYPE |
nvarchar(30) | Ja | — | — |
SFIEDEFSELCRIT |
smallint | Nee | — | — |
SFIEDEFVAL |
nvarchar(max) | Ja | — | — |
SFIEDOMAINDATATYPE |
nvarchar(100) | Ja | — | — |
SFIEFACTORYLEN |
smallint | Nee | ((0)) | — |
SFIEFORMAT |
nvarchar(6) | Ja | — | — |
SFIEFULLTEXTENABLED |
smallint | Nee | ((0)) | — |
SFIEFULLTEXTLANGUAGE |
nvarchar(128) | Ja | — | — |
SFIEFULLTEXTSTOPLIST |
nvarchar(128) | Ja | — | — |
SFIEINPUT |
smallint | Nee | — | — |
SFIELOG |
smallint | Nee | ((0)) | — |
SFIEMULTILINGUAL |
smallint | Nee | ((0)) | — |
SFIENEWLEN |
smallint | Nee | ((0)) | — |
SFIEPKORDER |
smallint | Nee | ((0)) | — |
SFIEPROPERTYNAME |
nvarchar(100) | Ja | — | — |
SFIEREADONLY |
smallint | Nee | ((0)) | — |
SFIEREC |
nvarchar(128) | Nee | — | — |
SFIEVALID |
nvarchar(61) | Ja | — | — |
Trigger-gevulde kolommenbewerken
SFIEPROPERTYNAME← TRGU_SFIELD
Brondatabewerken
- DB-schema —
lookup_table_schema("SFIELD")Alle kolommen met types, triggers, computed. Bron:database-schema.json.