Table CCS DIS Mapping Repository

table 5100955 "CCS DIS Mapping Repository"

Properties

Name	Value
Caption	Mapping Repository
DataPerCompany	0
DrillDownPageID	CCS DIS Mapping Repositories
LookupPageID	CCS DIS Mapping Repositories

Fields

Mapping Code

field(1; "Mapping Code"; Code[20])

Properties

Name	Value
Caption	Mapping Code
DataClassification	CustomerContent
TableRelation	"CCS DIS Mapping"

Version No.

field(2; "Version No."; Integer)

Properties

Name	Value
Caption	Version No.
DataClassification	CustomerContent
TableRelation	"CCS DIS Mapping Version"."No." where("Mapping Code" = field("Mapping Code"))

Code

field(3; "Code"; Code[20])

Properties

Name	Value
Caption	Code
DataClassification	CustomerContent
NotBlank	1

Field Structure

field(15; "Field Structure"; Blob)

Properties

Name	Value
Caption	Field Structure
DataClassification	CustomerContent

Type

field(20; "Type"; Enum "CCS DIS Repository Type")

Properties

Name	Value
Caption	Type
DataClassification	CustomerContent

NAV Table No.

field(30; "NAV Table No."; Integer)

Properties

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

NAV Table Caption

field(31; "NAV Table Caption"; Text[249])

Properties

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

NAV Temporary Table

field(32; "NAV Temporary Table"; Boolean)

Properties

Name	Value
Caption	Temporary Table
DataClassification	CustomerContent

NAV Company Name

field(33; "NAV Company Name"; Text[30])

Properties

Name	Value
Caption	Company Name
DataClassification	CustomerContent
TableRelation	Company

NAV Partner ChangeCompany

field(34; "NAV Partner ChangeCompany"; Boolean)

Properties

Name	Value
Caption	Company of Partner
DataClassification	CustomerContent

NAV Key Index

field(35; "NAV Key Index"; Integer)

Properties

Name	Value
BlankZero	1
Caption	Key Index
DataClassification	CustomerContent
TableRelation	Key."No." where(TableNo = field("NAV Table No."))

NAV Key Descending

field(36; "NAV Key Descending"; Boolean)

Properties

Name	Value
Caption	Sort Key Descending
DataClassification	CustomerContent

NAV Key Description

field(37; "NAV Key Description"; Text[250])

Properties

Name	Value
CalcFormula	lookup(Key.Key where(TableNo = field("NAV Table No."), "No." = field("NAV Key Index")))
Caption	Key Description
Editable	0
FieldClass	FlowField

Record Pool Code

field(40; "Record Pool Code"; Code[20])

Properties

Name	Value
Caption	Record Pool Code
DataClassification	CustomerContent
TableRelation	"CCS DIS Record Pool"

Record Pool Table No.

field(41; "Record Pool Table No."; Integer)

Properties

Name	Value
BlankZero	1
CalcFormula	lookup("CCS DIS Record Pool"."Table No." where(Code = field("Record Pool Code")))
Caption	Record Pool Table No.
Editable	0
FieldClass	FlowField

Record Pool Partner Records

field(42; "Record Pool Partner Records"; Boolean)

Properties

Name	Value
Caption	Use Partner Matrix
DataClassification	CustomerContent

Record Pool Record Frequency

field(43; "Record Pool Record Frequency"; Enum "CCS DIS Record Pool Record Frequency")

Properties

Name	Value
Caption	Permitted Record Frequency
DataClassification	CustomerContent

Record Pool Rec. Freq. Error

field(44; "Record Pool Rec. Freq. Error"; Enum "CCS DIS Rec. Pool Record Frequency Error")

Properties

Name	Value
Caption	Record Frequency Error Handling
DataClassification	CustomerContent

Record Pool Rec. Not Exist

field(45; "Record Pool Rec. Not Exist"; Enum "CCS DIS Rec. Pool Record Not Exist")

Properties

Name	Value
Caption	Rec. Not Exist Handling
DataClassification	CustomerContent

XML Node Name

field(50; "XML Node Name"; Text[80])

Properties

Name	Value
Caption	XML Node Name
DataClassification	CustomerContent

XML Parent Node

field(51; "XML Parent Node"; Code[20])

Properties

Name	Value
Caption	Parent XML Node
DataClassification	CustomerContent
TableRelation	"CCS DIS Mapping Repository".Code where("Mapping Code" = field("Mapping Code"), "Version No." = field("Version No."), Type = const(XmlNode))

SharePoint Web Url

field(70; "SharePoint Web Url"; Text[200])

Properties

Name	Value
Caption	Web URL
DataClassification	CustomerContent

SharePoint Server Relative Url

field(71; "SharePoint Server Relative Url"; Text[250])

Properties

Name	Value
Caption	Relative Site URL
DataClassification	CustomerContent

SharePoint List Guid

field(72; "SharePoint List Guid"; Guid)

Properties

Name	Value
Caption	List GUID
DataClassification	CustomerContent

SharePoint List Display Name

field(73; "SharePoint List Display Name"; Text[50])

Properties

Name	Value
Caption	List Display Name
DataClassification	CustomerContent
Editable	0

SharePoint Credential Type

field(74; "SharePoint Credential Type"; Enum "CCS DIS SharePoint Credential Type")

Properties

Name	Value
Caption	Credential Type
DataClassification	AccountData
InitValue	OAuth 2.0

SharePoint OAuth App. Code

field(75; "SharePoint OAuth App. Code"; Code[20])

Properties

Name	Value
Caption	OAuth 2.0 Application Code
DataClassification	CustomerContent
TableRelation	"CCS DIS OAuth Application"

SharePoint Credential Realm

field(76; "SharePoint Credential Realm"; Text[50])

Properties

Name	Value
Caption	SharePoint Realm (Azure Tenant ID)
DataClassification	OrganizationIdentifiableInformation

SharePoint Target Host

field(77; "SharePoint Target Host"; Text[80])

Properties

Name	Value
Caption	SharePoint Target Host
DataClassification	OrganizationIdentifiableInformation

SharePoint App Client Id

field(78; "SharePoint App Client Id"; Text[50])

Properties

Name	Value
Caption	SharePoint App Client ID
DataClassification	OrganizationIdentifiableInformation

SharePoint App Secret Key

field(79; "SharePoint App Secret Key"; Guid)

Properties

Name	Value
Caption	SharePoint App Client Secret
DataClassification	CustomerContent

JSON Token Name

field(90; "JSON Token Name"; Text[80])

Properties

Name	Value
Caption	JSON Token Name
DataClassification	CustomerContent

JSON Token Type

field(91; "JSON Token Type"; Enum "CCS DIS Json Token Type")

Properties

Name	Value
Caption	JSON Token Type
DataClassification	CustomerContent
InitValue	Array

JSON Parent Token

field(92; "JSON Parent Token"; Code[20])

Properties

Name	Value
Caption	Parent JSON Token
DataClassification	CustomerContent
TableRelation	"CCS DIS Mapping Repository".Code where("Mapping Code" = field("Mapping Code"), "Version No." = field("Version No."), Type = const(JsonToken))

Description

field(120; "Description"; Text[80])

Properties

Name	Value
Caption	Description
DataClassification	CustomerContent

SharePoint Folder Variable Key

field(270; "SharePoint Folder Variable Key"; Text[30])

Properties

Name	Value
Caption	Folder Variable Key
DataClassification	CustomerContent

SharePoint Skip GetListItem

field(271; "SharePoint Skip GetListItem"; Boolean)

Properties

Name	Value
Caption	Skip GetListItem
DataClassification	CustomerContent

SharePoint Query Postfix

field(275; "SharePoint Query Postfix"; Text[150])

Properties

Name	Value
Caption	Query Node Postfix
DataClassification	CustomerContent

Notes

field(320; "Notes"; Blob)

Properties

Name	Value
Caption	Notes
DataClassification	CustomerContent
Subtype	Memo

Keys

Name	Fields	Properties
PK	"Mapping Code" "Version No." "Code"	Clustered = 1

Methods

CreateFieldStructure

public "CCS DIS Mapping Repository" CreateFieldStructure(): None

Creates the field structure for a mapping repository.

Return Value

None

CreateFieldStructureFromRepository

public "CCS DIS Mapping Repository" CreateFieldStructureFromRepository(): None

Opens the create field structure page to create the field structure.

Return Value

None

OpenCard

public "CCS DIS Mapping Repository" OpenCard(): None

Opens the mapping repository card for the selected repository.

Return Value

None

SetFieldGroupDetailText

public "CCS DIS Mapping Repository" SetFieldGroupDetailText(NewDetailText: Text): None

Sets the description field of the mapping repository, to be used in mapping line creation for description.

Parameters

Name	Type	Description
NewDetailText	`Text`	The new description text.

Return Value

None

ShowFields

public "CCS DIS Mapping Repository" ShowFields(): None

Opens the fields page, based on the repository type.

Return Value

None

Events

OnBeforeCheckCreateStructureValid

event "CCS DIS Mapping Repository" OnBeforeCheckCreateStructureValid(MappingRepository: Record "CCS DIS Mapping Repository"; var IsHandled: Boolean)

The event is executed before the field structure creation. It's validating, if the repository type can create a field structure.
If this event is not handled, only XmlNode and JsonToken will be able to create a field structure from.

Parameters

Name	Type	Description
MappingRepository	`Record "CCS DIS Mapping Repository"`	The mapping repository to create the field structure for.
IsHandled	`Boolean`	Set true to skip validation and open create field structure page.

Attributes

Name	Arguments
IntegrationEvent	False, False