Table CCS DMS Table Setup

table 5306020 "CCS DMS Table Setup"

Properties

Name Value
Caption DMS Table Setup
DataClassification CustomerContent

Fields

Document Library Code

field(1; "Document Library Code"; Code[20])

Properties

Name Value
Caption Document Library Code
DataClassification CustomerContent
TableRelation "CCS DMS Document Library"

Content Type Code

field(2; "Content Type Code"; Code[20])

Properties

Name Value
Caption Content Type Code
DataClassification CustomerContent
TableRelation "CCS DMS Content Type".Code where("Document Library Code" = field("Document Library Code"))

Table Id

field(3; "Table Id"; Integer)

Properties

Name Value
Caption Table ID
DataClassification CustomerContent
NotBlank 1
TableRelation AllObjWithCaption."Object ID" where("Object Type" = const(Table))

Table Caption

field(6; "Table Caption"; Text[250])

Properties

Name Value
CalcFormula Lookup(AllObjWithCaption."Object Caption" where("Object Type" = const(Table),
"Object ID" = field("Table Id")))
Caption Table Caption
Editable 0
FieldClass FlowField

Status

field(7; "Status"; Enum "CCS DMS Table Setup Status")

Properties

Name Value
Caption Status
DataClassification CustomerContent
Editable 0

SharePoint Filter Exists

field(25; "SharePoint Filter Exists"; Boolean)

Properties

Name Value
CalcFormula Exist("CCS DMS SharePoint Filter" where("Document Library Code" = field("Document Library Code"), "Table Id" = field("Table Id")))
Caption SharePoint Filter
Editable 0
FieldClass FlowField

Record Filter Exists

field(26; "Record Filter Exists"; Boolean)

Properties

Name Value
CalcFormula Exist("CCS DMS Record Filter" where("Document Library Code" = field("Document Library Code"), "Table Id" = field("Table Id")))
Caption Record Filter
Editable 0
FieldClass FlowField

Metadata Exists

field(27; "Metadata Exists"; Boolean)

Properties

Name Value
CalcFormula Exist("CCS DMS Metadata" where("Document Library Code" = field("Document Library Code"), "Table Id" = field("Table Id")))
Caption Metadata
Editable 0
FieldClass FlowField

Modification Date

field(31; "Modification Date"; DateTime)

Properties

Name Value
Caption Last Modification Date
DataClassification CustomerContent
Editable 0

Modified by User

field(33; "Modified by User"; Code[50])

Properties

Name Value
Caption Modified by User
DataClassification EndUserIdentifiableInformation
Editable 0

Module Code

field(70; "Module Code"; Code[20])

Properties

Name Value
Caption LibrarySet Module
DataClassification CustomerContent
TableRelation "CCS DMS Library Module".Code

Folder Formula

field(75; "Folder Formula"; Text[100])

Properties

Name Value
Caption Folder Formula
DataClassification CustomerContent

Files in Folder Only

field(76; "Files in Folder Only"; Boolean)

Properties

Name Value
Caption Show Files in Folder Only
DataClassification CustomerContent

Keys

Name Fields Properties
Primary
  • "Document Library Code"
  • "Content Type Code"
  • "Table Id"
  • Clustered = 1
TableId
  • "Table Id"
LibrarySet
  • "Module Code"