Enrichment Details

ms_reference_data (Language)

Attribute

Description

T24 Mapping

type

Hard coded to LANGUAGE

-

value

Primary key of the Language

LANGUAGE -> @ID

description

Description for the Language 

LANGUAGE -> MNEMONIC

MsAltKey

Attribute

Description

alternateKey

Alternate Key for Arrangement / Party Details

alternateName

Alternate Name for Arrangement / Party Details

entityId

Arrangement / Party Details @ID

Officer Details

Attribute

Description

T24 Mapping

officerKey

Primary Key of the Officer Details

DEPT_ACCT_OFFICER -> @ID

description

Description for the Officer Details 

DEPT_ACCT_OFFICER -> NAME

Product Details

Attribute

Description

T24 Mapping

productIdentifier

Primary Key of the Product Details

AA_PRODUCT-> @ID/ INVESTMENT_PROGRAM@ID

description

Language Specific Description for the Product Details 

(ProductDetails_description Table) 

AA_PRODUCT-> DESCRIPTION/ INVESTMENT_PROGRAM -> DESCRIPTION

Company Details

Attribute

Description

T24 Mapping

companyRef

Primary Key of the Product Details

COMPANY -> @ID

customerCompanyRef

Indicates under which company the Customer files are maintained for this company

COMPANY -> CUSTOMER.COMPANY

leadCompanyRef

Indicates whether this is a Lead Company or a branch company

COMPANY -> FINANCIAL.COM

defaultFinancialCompany

Indicates under which company the Financial Static table files are maintained for this Company

COMPANY -> DEFAULT.FINAN.COM

defaultLanguageCode

Identifies the language used for this Company

COMPANY -> LANGUAGE.CODE

description

Language Specific Description for the Product Details 

(CompanyDetails_description Table) 

COMPANY-> DESCRIPTION

Company Details Extension

Attribute

Description

companyRef

Primary Key (reflects the company Ref)

name

Holds the name of the extension Field

value

Holds the value of the extension Field

Posting Restrict

Attribute

Description

T24 Mapping

postingRef

Primary Key of the Posting Restrict Details

POSTING_RESTRICT-> @ID

restrictionType

Identifies the type of entries that are to be restricted, either only debits, only credits or both

POSTING_RESTRICT -> RESTRICTION.TYPE

description

Language Specific Description for the Posting Restrict Details 

(PostingRestrict_description Table) 

POSTING_RESTRICT-> DESCRIPTION

legalEntityId Branch company code POSTING_RESTRICT-> CO.CODE
allowTransaction Indicates whether transactions are allowed or not POSTING.RESTRICT → ALLOW.TRANSACTION
transactionCodes It holds the allowed transaction codes. POSTING_RESTRICT → TRANSACTION

Party Roles

Attribute

Description

T24 Mapping

roleId

Primary Key of the AA Customer Role Details

AA_CUSTOMER_ROLE -> @ID

description

Language Specific Description for the Party Roles (PartyRoles_description Table)

AA_CUSTOMER_ROLE-> DESCRIPTION

isBeneficialOwner

This field indicates whether the customer(s) pertaining to the role is a beneficial owner of the arrangement.

AA_CUSTOMER_ROLE-> BENEFICIAL.OWNER

maxTaxLiabPercentage

Max Limit Liability Percentage of the Roles.

AA_CUSTOMER_ROLE-> MAX.LIMIT.LIAB.PERC

Party Arrangement

Attribute

Description

T24 Mapping

recId

Primary Key of the Party Arrangement Details

AA_ARR_CUSTOMER-> CO.CODE - AA_ARR_CUSTOMER-> @ID -> @ID $ Auto-Generated Arrangement Id

partyRole

Role of the Party linked to the Arrangement

AA_ARR_CUSTOMER -> CUSTOMER.ROLE

arrangementId

Arrangement Id from the Arrangement Table

Auto-Generated Arrangement Id

partyId

Party Id from the Party Details Table

AA_ARR_CUSTOMER-> CO.CODE - AA_ARR_CUSTOMER-> @ID

Arrangement Event Processed

Attribute

Description

T24 Mapping

arrangementId

Arrangement Id from the Arrangement Table

Auto-Generated Arrangement Id

eventName

Holds the information of event that comes for an arrangement

-

 


Field Name
|
Application/Table name

Temenos Headquarters SA
2 Rue de l'Ecole-de-Chimie
CH - 1205 Geneva
Switzerland

Copyright © 2020- Temenos Headquarters SA

Published on :
Tuesday, May 23, 2023 9:34:02 PM IST