Aa Account [PDF]

  • 0 0 0
  • Gefällt Ihnen dieses papier und der download? Sie können Ihre eigene PDF-Datei in wenigen Minuten kostenlos online veröffentlichen! Anmelden
Datei wird geladen, bitte warten...
Zitiervorschau

Application

AA_ARR_ACCOUNT AA_PRD_CAT_ACCOUNT AA_PRD_DES_ACCOUNT AA_PRD_PRF_ACCOUNT AA_SIM_ACCOUNT

Description The The The The The

ACCOUNT ACCOUNT ACCOUNT ACCOUNT ACCOUNT

Property Property Property Property Property

Class Class Class Class Class

is is is is is

used used used used used

by by by by by

all all all all all

products products products products products

which which which which which

are are are are are

account account account account account

based. based. based. based. based.

This This This This This

property property property property property

Back to domain

Application Property Name

ARRANGEMENT_KEY ACTIVITY ACTION CATEGORY CURRENCY CURRENCY_MARKET ACCOUNT_TITLE_1 ACCOUNT_TITLE_2 SHORT_TITLE MNEMONIC ALT_ID_TYPE ALT_ID CUSTOMER_REFERENCE POSTING_RESTRICT POSITION_TYPE BASE_DATE_TYPE ANNIVERSARY ACCOUNT_REFERENCE ORIGINATION_REF DATE_CONVENTION DATE_ADJUSTMENT BUS_DAY_CENTRES PORTFOLIO_ID MANDATE_APPL MANDATE_REG MANDATE_RECORD REFERAL_CODE INACTIVE_MONTHS PASSBOOK SHADOW_ACCOUNT GENERATE_IBAN RESERVED_8 RESERVED_7 RESERVED_6 RESERVED_5 RESERVED_4 RESERVED_3 RESERVED_2 RESERVED_1 PR_ATTRIBUTE PR_VALUE PR_BRK_RES PR_BRK_MSG PR_BRK_CHARGE PR_RESERVED_3 PR_RESERVED_2 PR_RESERVED_1 PR_APP_METHOD PR_APP_PERIOD

AA_Account:AA_ARR_ACCOUNT

Attribute Type Primary Key

Foreign Key: ST_Config:CATEGORY Foreign Key: FIN_CurrencyConfig:CURRENCY Foreign Key: FIN_CurrencyConfig:CURRENCY_MARKET

Foreign Key: AC_Config:POSTING_RESTRICT Foreign Key: RE_Config:FX_POS_TYPE Enumeration: BASE_DATE_TYPE

Enumeration: DATE_CONVENTION Enumeration: DATE_ADJUSTMENT

Foreign Key: EB_Mandate:EB_MANDATE_PARAMETER Foreign Key: EB_RulesEngine:EB_RULE_GATEWAY Foreign Key: EB_Mandate:EB_MANDATE Foreign Key: ACM_AccountOpening:REFERAL Enumeration: PASSBOOK Enumeration: SHADOW_ACCOUNT Enumeration: GENERATE_IBAN

Foreign Key: AA_Rules:AA_PERIODIC_ATTRIBUTE Enumeration: PR_ATTRIBUTE__PR_BRK_RES Foreign Key: AA_ProductFramework:AA_PROPERTY

Enumeration: PR_ATTRIBUTE__PR_APP_METHOD

Data Type

Business Type Group Name ANY

T24BusinessTypes:A T24BusinessTypes:A

Sub group Name

ACTION A A A

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:S

ALT_ID_TYPE ALT_ID_TYPE A SSS

POSTING_RESTRICT

T24BusinessTypes:MD T24BusinessTypes:A T24BusinessTypes:A

T24BusinessTypes:S T24BusinessTypes:A

BUS_DAY_CENTRES A A A A

MANDATE_APPL MANDATE_APPL MANDATE_APPL REFERAL_CODE

A

PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE

Integer

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:ANY A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:PERIOD

Meta Data

Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification:

L L L L L L L L L L L L L L L L L L L L L L L L L L L R L L L L L L L L L L L L L L L L L L L L L

Description

The key to the arrangement property condition. The key is comprised of the following compo The activity that caused this arrangement property to be updated. The activity that caused this arrangement property to be updated. Historically, the CATEGORY of an account has been used in T24 as both a product definition Identifies the Currency of the Account. Identifies the Currency Market for exchange rate information for this Account, in countrie The title lines are used to describe the specific account. The title lines are used to describe the specific account. The short title is typically an abbreviation of the account title and is used throughout T A mnemonic is an alternate key which can be defined by a user to reference the account In this application any alternate account systems defined in the ACCOUNT.PARAMETER applica Alternate System IDs are typically used for accounts that have been taken over from a diff A customer specified reference can be specified for an account arrangement. At the arrangement level, a posting restriction code (defined in POSTING.RESTRICT) can be Identifies the Type of Foreign Exchange Position which will be updated as a result of move This nochange field at the arrangement level indicates if the Anniversary field should be This field stores the Anniversary Date of the arrangement in the format 'MMDD'. This is us The field holds the reference of the underlying ACCOUNT application. This should just be t This field is for information purposes only. This field may find use to store the external During the automatic generation of payment schedules, the Date Convention and Date Adjustm Input allowed for all date conventions except for Calendar, Date Adjustment is used to spe By default, T24 will check the holiday schedule for the country of an arrangement’s curren An arrangement could be linked to customer's portfolio reference(SEC.ACC.MASTER id) using Indicates for which application these mandate settings apply. Must be a record on MANDATE. Indicates the rule that must be passed to ensure the mandate checking is triggered. Not a When the MANDATE.APPL and MANDATE.REG is used for triggering mandate requirement, this is Specifies the conditions under which Account details or details of entries over the Accoun Indicates the number of months without customer activity before an account is declared as Determines if the arrangement has a passbook. Holds the value YES or NULL.

These are set of Attributes which define the names of the rule, which will be applied on c This is the actual rule value, which will be applied on certain attributes of the property When a rule is broken what action needs to be taken is defined here. Currently, the variou Based on the PR.BRK.RES option selected, this will hold either an OVERRIDE or EB.ERROR id. Not used for arrangement level conditions System field - reserved for future use System field - reserved for future use System field - reserved for future use This will hold two values either DUE or CAPITALISE This will have to accept a valid T24 period.

SYS_RESERVE7 SYS_RESERVE6 SYS_RESERVE5 SYS_RESERVE4 SYS_RESERVE3 SYS_RESERVE2 SYS_RESERVE1 DEFAULT_ATTR_OPTION DEFAULT_NEGOTIABLE NR_ATTRIBUTE NR_OPTIONS NR_RESERVED2 NR_RESERVED1 NR_STD_COMP NR_TYPE NR_VALUE NR_MESSAGE CHANGED_FIELDS NEGOTIATED_FLDS ID_COMP_1 ID_COMP_2 ID_COMP_3 ID_COMP_4 ID_COMP_5 ID_COMP_6 RESERVED2_ID TARGET_PRODUCT STMT_NOS OVERRIDE RECORD_STATUS CURR_NO INPUTTER DATE_TIME AUTHORISER CO_CODE DEPT_CODE AUDITOR_CODE AUDIT_DATE_TIME

Enumeration: DEFAULT_ATTR_OPTION Enumeration: DEFAULT_NEGOTIABLE Enumeration: NR_ATTRIBUTE__NR_OPTIONS__NR_OPTIONS

Foreign Key: AA_Rules:EB_STANDARD_COMPARISON Foreign Key: AA_Rules:EB_COMPARISON_TYPE

Foreign Key: ST_CompanyCreation:COMPANY Foreign Key: ST_Config:DEPT_ACCT_OFFICER

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A A A T24BusinessTypes:ANY T24BusinessTypes:T T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A Integer T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A Integer Integer T24BusinessTypes:STAT Integer T24BusinessTypes:A T24BusinessTypes:RELTIME T24BusinessTypes:A

STMT_NOS OVERRIDE

INPUTTER DATE_TIME A

T24BusinessTypes:A T24BusinessTypes:RELTIME

NR_ATTRIBUTE NR_ATTRIBUTE NR_OPTIONS NR_ATTRIBUTE NR_ATTRIBUTE NR_ATTRIBUTE NR_ATTRIBUTE NR_TYPE NR_ATTRIBUTE NR_TYPE NR_ATTRIBUTE NR_TYPE CHANGED_FIELDS NEGOTIATED_FLDS

Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification:

L L L L L L L L L L L L L L L L L L L L L R L L L L L R R L R L L L L R L L

System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use p>Optional field - Allowed Values are RESETTING and NON-RESETTING. Not used for arrangement level conditions System field - not used for arrangement conditions System field - not used for arrangement conditions System Field - Reserved for future use System Field - Reserved for future use Not used for Arrangement Conditions System field - not used for arrangement conditions System field - not used for arrangement conditions System field - not used for arrangement conditions No input and multi value field lists all fields that have been negotiated for each dated v No input and multi value field that lists the attributes on the arrangement property recor Contains the arrangement number, extracted from the first component of the id Contains the name of the property that this arrangement level condition relates to Contains the Effective Date of this property condition Reserved for future use Reserved for future use Reserved for future use

This field denotes the target classic product of the given property class Contains the key to the accounting entries raised by the activity being applied to this ar Standard Override field containing override messages generated by amendments to this prope

Back to domain

Application Property Name

PRODUCT_KEY DESCRIPTION RESERVED CATEGORY CURRENCY CURRENCY_MARKET ACCOUNT_TITLE_1 ACCOUNT_TITLE_2 SHORT_TITLE MNEMONIC ALT_ID_TYPE ALT_ID CUSTOMER_REFERENCE POSTING_RESTRICT POSITION_TYPE BASE_DATE_TYPE ANNIVERSARY ACCOUNT_REFERENCE ORIGINATION_REF DATE_CONVENTION DATE_ADJUSTMENT BUS_DAY_CENTRES PORTFOLIO_ID MANDATE_APPL MANDATE_REG MANDATE_RECORD REFERAL_CODE INACTIVE_MONTHS PASSBOOK SHADOW_ACCOUNT GENERATE_IBAN RESERVED_8 RESERVED_7 RESERVED_6 RESERVED_5 RESERVED_4 RESERVED_3 RESERVED_2 RESERVED_1 PR_ATTRIBUTE PR_VALUE PR_BRK_RES PR_BRK_MSG PR_BRK_CHARGE PR_RESERVED_3 PR_RESERVED_2 PR_RESERVED_1 PR_APP_METHOD PR_APP_PERIOD

AA_Account:AA_PRD_CAT_ACCOUNT

Attribute Type Primary Key

Foreign Key: ST_Config:CATEGORY Foreign Key: FIN_CurrencyConfig:CURRENCY Foreign Key: FIN_CurrencyConfig:CURRENCY_MARKET

Foreign Key: AC_Config:POSTING_RESTRICT Foreign Key: RE_Config:FX_POS_TYPE Enumeration: BASE_DATE_TYPE

Enumeration: DATE_CONVENTION Enumeration: DATE_ADJUSTMENT

Foreign Key: EB_Mandate:EB_MANDATE_PARAMETER Foreign Key: EB_RulesEngine:EB_RULE_GATEWAY Foreign Key: EB_Mandate:EB_MANDATE Foreign Key: ACM_AccountOpening:REFERAL Enumeration: PASSBOOK Enumeration: SHADOW_ACCOUNT Enumeration: GENERATE_IBAN

Foreign Key: AA_Rules:AA_PERIODIC_ATTRIBUTE Enumeration: PR_ATTRIBUTE__PR_BRK_RES Foreign Key: AA_ProductFramework:AA_PROPERTY

Enumeration: PR_ATTRIBUTE__PR_APP_METHOD

Data Type

Business Type Group Name ANY

T24BusinessTypes:ANY T24BusinessTypes:A

Sub group Name

DESCRIPTION A A A

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:S

ALT_ID_TYPE ALT_ID_TYPE A SSS

POSTING_RESTRICT

T24BusinessTypes:MD T24BusinessTypes:A T24BusinessTypes:A

T24BusinessTypes:S T24BusinessTypes:A

BUS_DAY_CENTRES A A A A

MANDATE_APPL MANDATE_APPL MANDATE_APPL REFERAL_CODE

A

PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE

Integer

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:ANY A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:PERIOD

Meta Data

Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification:

L L L L L L L L L L L L L L L L L L L L L L L L L L L R L L L L L L L L L L L L L L L L L L L L L

Description

This field represents the key to the product level conditions of a property class Describes this condition record and is used for enrichment.

Historically, the CATEGORY of an account has been used in T24 as both a product definition Identifies the Currency of the Account. Identifies the Currency Market for exchange rate information for this Account, in countrie The title lines are used to describe the specific account. The title lines are used to describe the specific account. The short title is typically an abbreviation of the account title and is used throughout T A mnemonic is an alternate key which can be defined by a user to reference the account In this application any alternate account systems defined in the ACCOUNT.PARAMETER applica Alternate System IDs are typically used for accounts that have been taken over from a diff A customer specified reference can be specified for an account arrangement. At the arrangement level, a posting restriction code (defined in POSTING.RESTRICT) can be Identifies the Type of Foreign Exchange Position which will be updated as a result of move This nochange field at the arrangement level indicates if the Anniversary field should be This field stores the Anniversary Date of the arrangement in the format 'MMDD'. This is us The field holds the reference of the underlying ACCOUNT application. If this field is popu This field is for information purposes only. This field may find use to store the external During the automatic generation of payment schedules, the Date Convention and Date Adjustm Input allowed for all date conventions except for Calendar, Date Adjustment is used to spe By default, T24 will check the holiday schedule for the country of an arrangement’s curren An arrangement could be linked to customer's portfolio reference(SEC.ACC.MASTER id) using Indicates for which application these mandate settings apply. Must be a record on MANDATE. Indicates the rule that must be passed to ensure the mandate checking is triggered. Not a When the MANDATE.APPL and MANDATE.REG is used for triggering mandate requirement, this is Specifies the conditions under which Account details or details of entries over the Accoun Indicates the Number of months without customer activity before an Arrangement Account is Determines if the arrangement has a passbook. Holds the value YES or NULL.

These are set of Attributes which define the names of the rule, which will be applied on c This is the actual rule value, which will be applied on certain attributes of the property When a rule is broken what action needs to be taken is defined here. Currently, the variou Based on the PR.BRK.RES option selected, this will hold either an OVERRIDE or EB.ERROR id. Charge can be collected when the periodic rule is broken System field - reserved for future use System field - reserved for future use System field - reserved for future use This will hold two values either DUE or CAPITALISE.This Field denote which application met This will have to accept a valid T24 period.This Field will denote the application period

SYS_RESERVE7 SYS_RESERVE6 SYS_RESERVE5 SYS_RESERVE4 SYS_RESERVE3 SYS_RESERVE2 SYS_RESERVE1 DEFAULT_ATTR_OPTION DEFAULT_NEGOTIABLE NR_ATTRIBUTE NR_OPTIONS NR_RESERVED2 NR_RESERVED1 NR_STD_COMP NR_TYPE NR_VALUE NR_MESSAGE CHANGED_FIELDS NEGOTIATED_FLDS ID_COMP_1 ID_COMP_2 ID_COMP_3 ID_COMP_4 ID_COMP_5 ID_COMP_6 RESERVED2_ID TARGET_PRODUCT STMT_NOS OVERRIDE RECORD_STATUS CURR_NO INPUTTER DATE_TIME AUTHORISER CO_CODE DEPT_CODE AUDITOR_CODE AUDIT_DATE_TIME

Enumeration: DEFAULT_ATTR_OPTION Enumeration: DEFAULT_NEGOTIABLE Enumeration: NR_ATTRIBUTE__NR_OPTIONS__NR_OPTIONS

Foreign Key: AA_Rules:EB_STANDARD_COMPARISON Foreign Key: AA_Rules:EB_COMPARISON_TYPE Enumeration: NR_ATTRIBUTE__NR_TYPE__NR_MESSAGE

Foreign Key: ST_CompanyCreation:COMPANY Foreign Key: ST_Config:DEPT_ACCT_OFFICER

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A A A T24BusinessTypes:ANY T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A Integer T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A Integer Integer T24BusinessTypes:STAT Integer T24BusinessTypes:A T24BusinessTypes:RELTIME T24BusinessTypes:A

STMT_NOS OVERRIDE

INPUTTER DATE_TIME A

T24BusinessTypes:A T24BusinessTypes:RELTIME

NR_ATTRIBUTE NR_ATTRIBUTE NR_OPTIONS NR_ATTRIBUTE NR_ATTRIBUTE NR_ATTRIBUTE NR_ATTRIBUTE NR_TYPE NR_ATTRIBUTE NR_TYPE NR_ATTRIBUTE NR_TYPE CHANGED_FIELDS NEGOTIATED_FLDS

Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification:

L L L L L L L L L L L L L L L L L L L L L R L L L L L R R L R L L L L R L L

System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use Optional field - Allowed Values are RESETTING and NON-RESETTING. Defines whether all attributes (fields) can be negotiable or not. Defines which individual attribute (field) has the negotiation rules defined in fields Nr Defines named values to indicate if an option applies to the associated NR.ATTRIBUTE. More System Field - Reserved for future use System Field - Reserved for future use It is possible to define negotiation rules in EB.COMPARISON.TYPE. Defines the negotiation rule that is linked to the field defined in Nr.Attribute . If an Defines the value that links to the rule in field Nr.Type This field indicates whether to raise error or override message when rule is broken No input and multi value field - lists all fields that have been negotiated for each dated No input and multi value field that lists the attributes on the arrangement property recor Contains the arrangement number, extracted from the first component of the id The action that was triggered on the arrangement property Contains the effective date of the property condition Reserved for future use Reserved for future use Reserved for future use

This field denotes the target classic product of the given property class System field - not used for property conditions Standard Override field containing override messages generated by amendments to this prope

Back to domain

Application Property Name

PRODUCT_KEY DESCRIPTION RESERVED CATEGORY CURRENCY CURRENCY_MARKET ACCOUNT_TITLE_1 ACCOUNT_TITLE_2 SHORT_TITLE MNEMONIC ALT_ID_TYPE ALT_ID CUSTOMER_REFERENCE POSTING_RESTRICT POSITION_TYPE BASE_DATE_TYPE ANNIVERSARY ACCOUNT_REFERENCE ORIGINATION_REF DATE_CONVENTION DATE_ADJUSTMENT BUS_DAY_CENTRES PORTFOLIO_ID MANDATE_APPL MANDATE_REG MANDATE_RECORD REFERAL_CODE INACTIVE_MONTHS PASSBOOK SHADOW_ACCOUNT GENERATE_IBAN RESERVED_8 RESERVED_7 RESERVED_6 RESERVED_5 RESERVED_4 RESERVED_3 RESERVED_2 RESERVED_1 PR_ATTRIBUTE PR_VALUE PR_BRK_RES PR_BRK_MSG PR_BRK_CHARGE PR_RESERVED_3 PR_RESERVED_2 PR_RESERVED_1 PR_APP_METHOD PR_APP_PERIOD

AA_Account:AA_PRD_DES_ACCOUNT

Attribute Type Primary Key

Foreign Key: ST_Config:CATEGORY Foreign Key: FIN_CurrencyConfig:CURRENCY Foreign Key: FIN_CurrencyConfig:CURRENCY_MARKET

Foreign Key: AC_Config:POSTING_RESTRICT Foreign Key: RE_Config:FX_POS_TYPE Enumeration: BASE_DATE_TYPE

Enumeration: DATE_CONVENTION Enumeration: DATE_ADJUSTMENT

Foreign Key: EB_Mandate:EB_MANDATE_PARAMETER Foreign Key: EB_RulesEngine:EB_RULE_GATEWAY Foreign Key: EB_Mandate:EB_MANDATE Foreign Key: ACM_AccountOpening:REFERAL Enumeration: PASSBOOK Enumeration: SHADOW_ACCOUNT Enumeration: GENERATE_IBAN

Foreign Key: AA_Rules:AA_PERIODIC_ATTRIBUTE Enumeration: PR_ATTRIBUTE__PR_BRK_RES Foreign Key: AA_ProductFramework:AA_PROPERTY

Enumeration: PR_ATTRIBUTE__PR_APP_METHOD

Data Type

Business Type Group Name ANY

T24BusinessTypes:ANY T24BusinessTypes:A

Sub group Name

DESCRIPTION A A A

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:S

ALT_ID_TYPE ALT_ID_TYPE A SSS

POSTING_RESTRICT

T24BusinessTypes:MD T24BusinessTypes:A T24BusinessTypes:A

T24BusinessTypes:S T24BusinessTypes:A

BUS_DAY_CENTRES A A A A

MANDATE_APPL MANDATE_APPL MANDATE_APPL REFERAL_CODE

A

PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE

Integer

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:ANY A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:PERIOD

Meta Data

Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification:

L L L L L L L L L L L L L L L L L L L L L L L L L L L R L L L L L L L L L L L L L L L L L L L L L

Description

This field represents the key to the product level conditions of a property class Describes this condition record and is used for enrichment.

Historically, the CATEGORY of an account has been used in T24 as both a product definition Identifies the Currency of the Account. Identifies the Currency Market for exchange rate information for this Account, in countrie The title lines are used to describe the specific account. The title lines are used to describe the specific account. The short title is typically an abbreviation of the account title and is used throughout T A mnemonic is an alternate key which can be defined by a user to reference the account In this application any alternate account systems defined in the ACCOUNT.PARAMETER applica Alternate System IDs are typically used for accounts that have been taken over from a diff A customer specified reference can be specified for an account arrangement. At the arrangement level, a posting restriction code (defined in POSTING.RESTRICT) can be Identifies the Type of Foreign Exchange Position which will be updated as a result of move This nochange field at the arrangement level indicates if the Anniversary field should be This field stores the Anniversary Date of the arrangement in the format 'MMDD'. This is us The field holds the reference of the underlying ACCOUNT application. If this field is popu This field is for information purposes only. This field may find use to store the external During the automatic generation of payment schedules, the Date Convention and Date Adjustm Input allowed for all date conventions except for Calendar, Date Adjustment is used to spe By default, T24 will check the holiday schedule for the country of an arrangement’s curren An arrangement could be linked to customer's portfolio reference(SEC.ACC.MASTER id) using Indicates for which application these mandate settings apply. Must be a record on MANDATE. Indicates the rule that must be passed to ensure the mandate checking is triggered. Not a When the MANDATE.APPL and MANDATE.REG is used for triggering mandate requirement, this is Specifies the conditions under which Account details or details of entries over the Accoun Indicates the Number of months without customer activity before an Arrangement Account is Determines if the arrangement has a passbook. Holds the value YES or NULL.

These are set of Attributes which define the names of the rule, which will be applied on c This is the actual rule value, which will be applied on certain attributes of the property When a rule is broken what action needs to be taken is defined here. Currently, the variou Based on the PR.BRK.RES option selected, this will hold either an OVERRIDE or EB.ERROR id. Charge can be collected when the periodic rule is broken System field - reserved for future use System field - reserved for future use System field - reserved for future use This will hold two values either DUE or CAPITALISE.This Field denote which application met This will have to accept a valid T24 period.This Field will denote the application period

SYS_RESERVE7 SYS_RESERVE6 SYS_RESERVE5 SYS_RESERVE4 SYS_RESERVE3 SYS_RESERVE2 SYS_RESERVE1 DEFAULT_ATTR_OPTION DEFAULT_NEGOTIABLE NR_ATTRIBUTE NR_OPTIONS NR_RESERVED2 NR_RESERVED1 NR_STD_COMP NR_TYPE NR_VALUE NR_MESSAGE CHANGED_FIELDS NEGOTIATED_FLDS ID_COMP_1 ID_COMP_2 ID_COMP_3 ID_COMP_4 ID_COMP_5 ID_COMP_6 RESERVED2_ID TARGET_PRODUCT STMT_NOS OVERRIDE RECORD_STATUS CURR_NO INPUTTER DATE_TIME AUTHORISER CO_CODE DEPT_CODE AUDITOR_CODE AUDIT_DATE_TIME

Enumeration: DEFAULT_ATTR_OPTION Enumeration: DEFAULT_NEGOTIABLE Enumeration: NR_ATTRIBUTE__NR_OPTIONS__NR_OPTIONS

Foreign Key: AA_Rules:EB_STANDARD_COMPARISON Foreign Key: AA_Rules:EB_COMPARISON_TYPE Enumeration: NR_ATTRIBUTE__NR_TYPE__NR_MESSAGE

Foreign Key: ST_CompanyCreation:COMPANY Foreign Key: ST_Config:DEPT_ACCT_OFFICER

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A A A T24BusinessTypes:ANY T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A Integer T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A Integer Integer T24BusinessTypes:STAT Integer T24BusinessTypes:A T24BusinessTypes:RELTIME T24BusinessTypes:A

STMT_NOS OVERRIDE

INPUTTER DATE_TIME A

T24BusinessTypes:A T24BusinessTypes:RELTIME

NR_ATTRIBUTE NR_ATTRIBUTE NR_OPTIONS NR_ATTRIBUTE NR_ATTRIBUTE NR_ATTRIBUTE NR_ATTRIBUTE NR_TYPE NR_ATTRIBUTE NR_TYPE NR_ATTRIBUTE NR_TYPE CHANGED_FIELDS NEGOTIATED_FLDS

Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification:

L L L L L L L L L L L L L L L L L L L L L R L L L L L R R L R L L L L R L L

System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use Optional field - Allowed Values are RESETTING and NON-RESETTING. Defines whether all attributes (fields) can be negotiable or not. Defines which individual attribute (field) has the negotiation rules defined in fields Nr Defines named values to indicate if an option applies to the associated NR.ATTRIBUTE. More System Field - Reserved for future use System Field - Reserved for future use It is possible to define negotiation rules in EB.COMPARISON.TYPE. Defines the negotiation rule that is linked to the field defined in Nr.Attribute . If an Defines the value that links to the rule in field Nr.Type This field indicates whether to raise error or override message when rule is broken No input and multi value field - lists all fields that have been negotiated for each dated No input and multi value field that lists the attributes on the arrangement property recor Contains the arrangement number, extracted from the first component of the id The action that was triggered on the arrangement property Contains the effective date of the property condition Reserved for future use Reserved for future use Reserved for future use

This field denotes the target classic product of the given property class System field - not used for property conditions Standard Override field containing override messages generated by amendments to this prope

Back to domain

Application Property Name

PRODUCT_KEY DESCRIPTION RESERVED CATEGORY CURRENCY CURRENCY_MARKET ACCOUNT_TITLE_1 ACCOUNT_TITLE_2 SHORT_TITLE MNEMONIC ALT_ID_TYPE ALT_ID CUSTOMER_REFERENCE POSTING_RESTRICT POSITION_TYPE BASE_DATE_TYPE ANNIVERSARY ACCOUNT_REFERENCE ORIGINATION_REF DATE_CONVENTION DATE_ADJUSTMENT BUS_DAY_CENTRES PORTFOLIO_ID MANDATE_APPL MANDATE_REG MANDATE_RECORD REFERAL_CODE INACTIVE_MONTHS PASSBOOK SHADOW_ACCOUNT GENERATE_IBAN RESERVED_8 RESERVED_7 RESERVED_6 RESERVED_5 RESERVED_4 RESERVED_3 RESERVED_2 RESERVED_1 PR_ATTRIBUTE PR_VALUE PR_BRK_RES PR_BRK_MSG PR_BRK_CHARGE PR_RESERVED_3 PR_RESERVED_2 PR_RESERVED_1 PR_APP_METHOD PR_APP_PERIOD

AA_Account:AA_PRD_PRF_ACCOUNT

Attribute Type Primary Key

Foreign Key: ST_Config:CATEGORY Foreign Key: FIN_CurrencyConfig:CURRENCY Foreign Key: FIN_CurrencyConfig:CURRENCY_MARKET

Foreign Key: AC_Config:POSTING_RESTRICT Foreign Key: RE_Config:FX_POS_TYPE Enumeration: BASE_DATE_TYPE

Enumeration: DATE_CONVENTION Enumeration: DATE_ADJUSTMENT

Foreign Key: EB_Mandate:EB_MANDATE_PARAMETER Foreign Key: EB_RulesEngine:EB_RULE_GATEWAY Foreign Key: EB_Mandate:EB_MANDATE Foreign Key: ACM_AccountOpening:REFERAL Enumeration: PASSBOOK Enumeration: SHADOW_ACCOUNT Enumeration: GENERATE_IBAN

Foreign Key: AA_Rules:AA_PERIODIC_ATTRIBUTE Enumeration: PR_ATTRIBUTE__PR_BRK_RES Foreign Key: AA_ProductFramework:AA_PROPERTY

Enumeration: PR_ATTRIBUTE__PR_APP_METHOD

Data Type

Business Type Group Name ANY

T24BusinessTypes:ANY T24BusinessTypes:A

Sub group Name

DESCRIPTION A A A

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:S

ALT_ID_TYPE ALT_ID_TYPE A SSS

POSTING_RESTRICT

T24BusinessTypes:MD T24BusinessTypes:A T24BusinessTypes:A

T24BusinessTypes:S T24BusinessTypes:A

BUS_DAY_CENTRES A A A A

MANDATE_APPL MANDATE_APPL MANDATE_APPL REFERAL_CODE

A

PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE

Integer

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:ANY A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:PERIOD

Meta Data

Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification:

L L L L L L L L L L L L L L L L L L L L L L L L L L L R L L L L L L L L L L L L L L L L L L L L L

Description

This field represents the key to the product level conditions of a property class Describes this condition record and is used for enrichment.

Historically, the CATEGORY of an account has been used in T24 as both a product definition Identifies the Currency of the Account. Identifies the Currency Market for exchange rate information for this Account, in countrie The title lines are used to describe the specific account. The title lines are used to describe the specific account. The short title is typically an abbreviation of the account title and is used throughout T A mnemonic is an alternate key which can be defined by a user to reference the account In this application any alternate account systems defined in the ACCOUNT.PARAMETER applica Alternate System IDs are typically used for accounts that have been taken over from a diff A customer specified reference can be specified for an account arrangement. At the arrangement level, a posting restriction code (defined in POSTING.RESTRICT) can be Identifies the Type of Foreign Exchange Position which will be updated as a result of move This nochange field at the arrangement level indicates if the Anniversary field should be This field stores the Anniversary Date of the arrangement in the format 'MMDD'. This is us The field holds the reference of the underlying ACCOUNT application. If this field is popu This field is for information purposes only. This field may find use to store the external During the automatic generation of payment schedules, the Date Convention and Date Adjustm Input allowed for all date conventions except for Calendar, Date Adjustment is used to spe By default, T24 will check the holiday schedule for the country of an arrangement’s curren An arrangement could be linked to customer's portfolio reference(SEC.ACC.MASTER id) using Indicates for which application these mandate settings apply. Must be a record on MANDATE. Indicates the rule that must be passed to ensure the mandate checking is triggered. Not a When the MANDATE.APPL and MANDATE.REG is used for triggering mandate requirement, this is Specifies the conditions under which Account details or details of entries over the Accoun Indicates the Number of months without customer activity before an Arrangement Account is Determines if the arrangement has a passbook. Holds the value YES or NULL.

These are set of Attributes which define the names of the rule, which will be applied on c This is the actual rule value, which will be applied on certain attributes of the property When a rule is broken what action needs to be taken is defined here. Currently, the variou Based on the PR.BRK.RES option selected, this will hold either an OVERRIDE or EB.ERROR id. Charge can be collected when the periodic rule is broken System field - reserved for future use System field - reserved for future use System field - reserved for future use This will hold two values either DUE or CAPITALISE.This Field denote which application met This will have to accept a valid T24 period.This Field will denote the application period

SYS_RESERVE7 SYS_RESERVE6 SYS_RESERVE5 SYS_RESERVE4 SYS_RESERVE3 SYS_RESERVE2 SYS_RESERVE1 DEFAULT_ATTR_OPTION DEFAULT_NEGOTIABLE NR_ATTRIBUTE NR_OPTIONS NR_RESERVED2 NR_RESERVED1 NR_STD_COMP NR_TYPE NR_VALUE NR_MESSAGE CHANGED_FIELDS NEGOTIATED_FLDS ID_COMP_1 ID_COMP_2 ID_COMP_3 ID_COMP_4 ID_COMP_5 ID_COMP_6 RESERVED2_ID TARGET_PRODUCT STMT_NOS OVERRIDE RECORD_STATUS CURR_NO INPUTTER DATE_TIME AUTHORISER CO_CODE DEPT_CODE AUDITOR_CODE AUDIT_DATE_TIME

Enumeration: DEFAULT_ATTR_OPTION Enumeration: DEFAULT_NEGOTIABLE Enumeration: NR_ATTRIBUTE__NR_OPTIONS__NR_OPTIONS

Foreign Key: AA_Rules:EB_STANDARD_COMPARISON Foreign Key: AA_Rules:EB_COMPARISON_TYPE Enumeration: NR_ATTRIBUTE__NR_TYPE__NR_MESSAGE

Foreign Key: ST_CompanyCreation:COMPANY Foreign Key: ST_Config:DEPT_ACCT_OFFICER

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A A A T24BusinessTypes:ANY T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A Integer T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A Integer Integer T24BusinessTypes:STAT Integer T24BusinessTypes:A T24BusinessTypes:RELTIME T24BusinessTypes:A

STMT_NOS OVERRIDE

INPUTTER DATE_TIME A

T24BusinessTypes:A T24BusinessTypes:RELTIME

NR_ATTRIBUTE NR_ATTRIBUTE NR_OPTIONS NR_ATTRIBUTE NR_ATTRIBUTE NR_ATTRIBUTE NR_ATTRIBUTE NR_TYPE NR_ATTRIBUTE NR_TYPE NR_ATTRIBUTE NR_TYPE CHANGED_FIELDS NEGOTIATED_FLDS

Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification:

L L L L L L L L L L L L L L L L L L L L L R L L L L L R R L R L L L L R L L

System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use Optional field - Allowed Values are RESETTING and NON-RESETTING. Defines whether all attributes (fields) can be negotiable or not. Defines which individual attribute (field) has the negotiation rules defined in fields Nr Defines named values to indicate if an option applies to the associated NR.ATTRIBUTE. More System Field - Reserved for future use System Field - Reserved for future use It is possible to define negotiation rules in EB.COMPARISON.TYPE. Defines the negotiation rule that is linked to the field defined in Nr.Attribute . If an Defines the value that links to the rule in field Nr.Type This field indicates whether to raise error or override message when rule is broken No input and multi value field - lists all fields that have been negotiated for each dated No input and multi value field that lists the attributes on the arrangement property recor Contains the arrangement number, extracted from the first component of the id The action that was triggered on the arrangement property Contains the effective date of the property condition Reserved for future use Reserved for future use Reserved for future use

This field denotes the target classic product of the given property class System field - not used for property conditions Standard Override field containing override messages generated by amendments to this prope

Back to domain

Application Property Name

ARRANGEMENT_KEY ACTIVITY ACTION CATEGORY CURRENCY CURRENCY_MARKET ACCOUNT_TITLE_1 ACCOUNT_TITLE_2 SHORT_TITLE MNEMONIC ALT_ID_TYPE ALT_ID CUSTOMER_REFERENCE POSTING_RESTRICT POSITION_TYPE BASE_DATE_TYPE ANNIVERSARY ACCOUNT_REFERENCE ORIGINATION_REF DATE_CONVENTION DATE_ADJUSTMENT BUS_DAY_CENTRES PORTFOLIO_ID MANDATE_APPL MANDATE_REG MANDATE_RECORD REFERAL_CODE INACTIVE_MONTHS PASSBOOK SHADOW_ACCOUNT GENERATE_IBAN RESERVED_8 RESERVED_7 RESERVED_6 RESERVED_5 RESERVED_4 RESERVED_3 RESERVED_2 RESERVED_1 PR_ATTRIBUTE PR_VALUE PR_BRK_RES PR_BRK_MSG PR_BRK_CHARGE PR_RESERVED_3 PR_RESERVED_2 PR_RESERVED_1 PR_APP_METHOD PR_APP_PERIOD

AA_Account:AA_SIM_ACCOUNT

Attribute Type Primary Key

Foreign Key: ST_Config:CATEGORY Foreign Key: FIN_CurrencyConfig:CURRENCY Foreign Key: FIN_CurrencyConfig:CURRENCY_MARKET

Foreign Key: AC_Config:POSTING_RESTRICT Foreign Key: RE_Config:FX_POS_TYPE Enumeration: BASE_DATE_TYPE

Enumeration: DATE_CONVENTION Enumeration: DATE_ADJUSTMENT

Foreign Key: EB_Mandate:EB_MANDATE_PARAMETER Foreign Key: EB_RulesEngine:EB_RULE_GATEWAY Foreign Key: EB_Mandate:EB_MANDATE Foreign Key: ACM_AccountOpening:REFERAL Enumeration: PASSBOOK Enumeration: SHADOW_ACCOUNT Enumeration: GENERATE_IBAN

Foreign Key: AA_Rules:AA_PERIODIC_ATTRIBUTE Enumeration: PR_ATTRIBUTE__PR_BRK_RES Foreign Key: AA_ProductFramework:AA_PROPERTY

Enumeration: PR_ATTRIBUTE__PR_APP_METHOD

Data Type

Business Type Group Name ANY

T24BusinessTypes:A T24BusinessTypes:A

Sub group Name

ACTION A A A

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:S

ALT_ID_TYPE ALT_ID_TYPE A SSS

POSTING_RESTRICT

T24BusinessTypes:MD T24BusinessTypes:A T24BusinessTypes:A

T24BusinessTypes:S T24BusinessTypes:A

BUS_DAY_CENTRES A A A A

MANDATE_APPL MANDATE_APPL MANDATE_APPL REFERAL_CODE

A

PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE PR_ATTRIBUTE

Integer

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:ANY A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:PERIOD

Meta Data

Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification:

L L L L L L L L L L L L L L L L L L L L L L L L L L L R L L L L L L L L L L L L L L L L L L L L L

Description

The key to the arrangement property condition. The key is comprised of the following compo The activity that caused this arrangement property to be updated. The activity that caused this arrangement property to be updated. Historically, the CATEGORY of an account has been used in T24 as both a product definition Identifies the Currency of the Account. Identifies the Currency Market for exchange rate information for this Account, in countrie The title lines are used to describe the specific account. The title lines are used to describe the specific account. The short title is typically an abbreviation of the account title and is used throughout T A mnemonic is an alternate key which can be defined by a user to reference the account In this application any alternate account systems defined in the ACCOUNT.PARAMETER applica Alternate System IDs are typically used for accounts that have been taken over from a diff A customer specified reference can be specified for an account arrangement. At the arrangement level, a posting restriction code (defined in POSTING.RESTRICT) can be Identifies the Type of Foreign Exchange Position which will be updated as a result of move This nochange field at the arrangement level indicates if the Anniversary field should be This field stores the Anniversary Date of the arrangement in the format 'MMDD'. This is us The field holds the reference of the underlying ACCOUNT application. This should just be t This field is for information purposes only. This field may find use to store the external During the automatic generation of payment schedules, the Date Convention and Date Adjustm Input allowed for all date conventions except for Calendar, Date Adjustment is used to spe By default, T24 will check the holiday schedule for the country of an arrangement’s curren An arrangement could be linked to customer's portfolio reference(SEC.ACC.MASTER id) using Indicates for which application these mandate settings apply. Must be a record on MANDATE. Indicates the rule that must be passed to ensure the mandate checking is triggered. Not a When the MANDATE.APPL and MANDATE.REG is used for triggering mandate requirement, this is Specifies the conditions under which Account details or details of entries over the Accoun Indicates the number of months without customer activity before an account is declared as Determines if the arrangement has a passbook. Holds the value YES or NULL.

These are set of Attributes which define the names of the rule, which will be applied on c This is the actual rule value, which will be applied on certain attributes of the property When a rule is broken what action needs to be taken is defined here. Currently, the variou Based on the PR.BRK.RES option selected, this will hold either an OVERRIDE or EB.ERROR id. Not used for arrangement level conditions System field - reserved for future use System field - reserved for future use System field - reserved for future use This will hold two values either DUE or CAPITALISE This will have to accept a valid T24 period.

SYS_RESERVE7 SYS_RESERVE6 SYS_RESERVE5 SYS_RESERVE4 SYS_RESERVE3 SYS_RESERVE2 SYS_RESERVE1 DEFAULT_ATTR_OPTION DEFAULT_NEGOTIABLE NR_ATTRIBUTE NR_OPTIONS NR_RESERVED2 NR_RESERVED1 NR_STD_COMP NR_TYPE NR_VALUE NR_MESSAGE CHANGED_FIELDS NEGOTIATED_FLDS ID_COMP_1 ID_COMP_2 ID_COMP_3 ID_COMP_4 ID_COMP_5 ID_COMP_6 RESERVED2_ID TARGET_PRODUCT STMT_NOS OVERRIDE RECORD_STATUS CURR_NO INPUTTER DATE_TIME AUTHORISER CO_CODE DEPT_CODE AUDITOR_CODE AUDIT_DATE_TIME

Enumeration: DEFAULT_ATTR_OPTION Enumeration: DEFAULT_NEGOTIABLE Enumeration: NR_ATTRIBUTE__NR_OPTIONS__NR_OPTIONS

Foreign Key: AA_Rules:EB_STANDARD_COMPARISON Foreign Key: AA_Rules:EB_COMPARISON_TYPE

Foreign Key: ST_CompanyCreation:COMPANY Foreign Key: ST_Config:DEPT_ACCT_OFFICER

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A

T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A A A T24BusinessTypes:ANY T24BusinessTypes:T T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A Integer T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A T24BusinessTypes:A Integer Integer T24BusinessTypes:STAT Integer T24BusinessTypes:A T24BusinessTypes:RELTIME T24BusinessTypes:A

STMT_NOS OVERRIDE

INPUTTER DATE_TIME A

T24BusinessTypes:A T24BusinessTypes:RELTIME

NR_ATTRIBUTE NR_ATTRIBUTE NR_OPTIONS NR_ATTRIBUTE NR_ATTRIBUTE NR_ATTRIBUTE NR_ATTRIBUTE NR_TYPE NR_ATTRIBUTE NR_TYPE NR_ATTRIBUTE NR_TYPE CHANGED_FIELDS NEGOTIATED_FLDS

Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification: Justification:

L L L L L L L L L L L L L L L L L L L L L R L L L L L R R L R L L L L R L L

System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use System field - reserved for future use p>Optional field - Allowed Values are RESETTING and NON-RESETTING. Not used for arrangement level conditions System field - not used for arrangement conditions System field - not used for arrangement conditions System Field - Reserved for future use System Field - Reserved for future use Not used for Arrangement Conditions System field - not used for arrangement conditions System field - not used for arrangement conditions System field - not used for arrangement conditions No input and multi value field lists all fields that have been negotiated for each dated v No input and multi value field that lists the attributes on the arrangement property recor Contains the arrangement number, extracted from the first component of the id Contains the name of the property that this arrangement level condition relates to Contains the Effective Date of this property condition Reserved for future use Reserved for future use Reserved for future use

This field denotes the target classic product of the given property class Contains the key to the accounting entries raised by the activity being applied to this ar Standard Override field containing override messages generated by amendments to this prope

Back to domain

Enumeration

AA_ARR_ACCOUNT__BASE_DATE_TYPE

Name

Value

AGREEMENT START

AGREEMENT START

BASE_DATE_TYPE

Description

Back to domain

Enumeration

AA_ARR_ACCOUNT__DATE_CONVENTION

Name

Value

CALENDAR BACKWARD FORWARD FORWARD_SAME_MONTH

CALENDAR BACKWARD FORWARD FORWARD SAME MONTH

ATE_CONVENTION

Description

Back to domain

Enumeration

AA_ARR_ACCOUNT__DATE_ADJUSTMENT

Name

Value

VALUE PERIOD

VALUE PERIOD

ATE_ADJUSTMENT

Description

Back to domain

Enumeration

AA_ARR_ACCOUNT__PASSBOOK

Name

Value

NO Y

NO Y

Description

Back to domain

Enumeration

AA_ARR_ACCOUNT__SHADOW_ACCOUNT

Name

Value

YES NULL

YES NULL

SHADOW_ACCOUNT

Description

Back to domain

Enumeration

AA_ARR_ACCOUNT__GENERATE_IBAN

Name

Value

NO YES

NO YES

_GENERATE_IBAN

Description

Back to domain

Enumeration

AA_ARR_ACCOUNT__PR_ATTRIBUTE__PR_BRK_RES

Name

Value

ERROR OVERRIDE INFORMATION CAP FLOOR

ERROR OVERRIDE INFORMATION CAP FLOOR

UTE__PR_BRK_RES

Description

Back to domain

Enumeration

AA_ARR_ACCOUNT__PR_ATTRIBUTE__PR_APP_METHOD

Name

Value

DUE CAPITALISE DEFER

DUE CAPITALISE DEFER

__PR_APP_METHOD

Description

Back to domain

Enumeration

AA_ARR_ACCOUNT__DEFAULT_ATTR_OPTION

Name

Value

RESETTING NON__RESETTING

RESETTING NON-RESETTING

ULT_ATTR_OPTION

Description

Back to domain

Enumeration

AA_ARR_ACCOUNT__DEFAULT_NEGOTIABLE

Name

Value

YES NO

YES NO

AULT_NEGOTIABLE

Description

Back to domain

Enumeration Name

FIX__VALUE MANDATORY NEGOTIABLE NON__NEGOTIABLE OVERRIDE RESETTING NON__RESETTING

AA_ARR_ACCOUNT__NR_ATTRIBUTE__NR_OPTIONS__NR_OPTIONS

Value

FIX-VALUE MANDATORY NEGOTIABLE NON-NEGOTIABLE OVERRIDE RESETTING NON-RESETTING

Description

Back to domain

Enumeration

AA_PRD_CAT_ACCOUNT__BASE_DATE_TYPE

Name

Value

AGREEMENT START

AGREEMENT START

BASE_DATE_TYPE

Description

Back to domain

Enumeration

AA_PRD_CAT_ACCOUNT__DATE_CONVENTION

Name

Value

CALENDAR BACKWARD FORWARD FORWARD_SAME_MONTH

CALENDAR BACKWARD FORWARD FORWARD SAME MONTH

DATE_CONVENTION

Description

Back to domain

Enumeration

AA_PRD_CAT_ACCOUNT__DATE_ADJUSTMENT

Name

Value

VALUE PERIOD

VALUE PERIOD

DATE_ADJUSTMENT

Description

Back to domain

Enumeration

AA_PRD_CAT_ACCOUNT__PASSBOOK

Name

Value

NO Y

NO Y

Description

Back to domain

Enumeration

AA_PRD_CAT_ACCOUNT__SHADOW_ACCOUNT

Name

Value

YES NULL

YES NULL

SHADOW_ACCOUNT

Description

Back to domain

Enumeration

AA_PRD_CAT_ACCOUNT__GENERATE_IBAN

Name

Value

NO YES

NO YES

_GENERATE_IBAN

Description

Back to domain

Enumeration Name

ERROR OVERRIDE INFORMATION CAP FLOOR

AA_PRD_CAT_ACCOUNT__PR_ATTRIBUTE__PR_BRK_RES

Value

ERROR OVERRIDE INFORMATION CAP FLOOR

Description

Back to domain

Enumeration Name

DUE CAPITALISE DEFER

AA_PRD_CAT_ACCOUNT__PR_ATTRIBUTE__PR_APP_METHOD

Value

DUE CAPITALISE DEFER

Description

Back to domain

Enumeration

AA_PRD_CAT_ACCOUNT__DEFAULT_ATTR_OPTION

Name

Value

RESETTING NON__RESETTING

RESETTING NON-RESETTING

ULT_ATTR_OPTION

Description

Back to domain

Enumeration

AA_PRD_CAT_ACCOUNT__DEFAULT_NEGOTIABLE

Name

Value

YES NO

YES NO

AULT_NEGOTIABLE

Description

Back to domain

Enumeration Name

FIX__VALUE MANDATORY NEGOTIABLE NON__NEGOTIABLE OVERRIDE RESETTING NON__RESETTING

AA_PRD_CAT_ACCOUNT__NR_ATTRIBUTE__NR_OPTIONS__NR_OPTIONS

Value

FIX-VALUE MANDATORY NEGOTIABLE NON-NEGOTIABLE OVERRIDE RESETTING NON-RESETTING

Description

Back to domain

Enumeration Name

ERROR OVERRIDE

AA_PRD_CAT_ACCOUNT__NR_ATTRIBUTE__NR_TYPE__NR_MESSAGE

Value

ERROR OVERRIDE

Description

Back to domain

Enumeration

AA_PRD_DES_ACCOUNT__BASE_DATE_TYPE

Name

Value

AGREEMENT START

AGREEMENT START

BASE_DATE_TYPE

Description

Back to domain

Enumeration

AA_PRD_DES_ACCOUNT__DATE_CONVENTION

Name

Value

CALENDAR BACKWARD FORWARD FORWARD_SAME_MONTH

CALENDAR BACKWARD FORWARD FORWARD SAME MONTH

DATE_CONVENTION

Description

Back to domain

Enumeration

AA_PRD_DES_ACCOUNT__DATE_ADJUSTMENT

Name

Value

VALUE PERIOD

VALUE PERIOD

DATE_ADJUSTMENT

Description

Back to domain

Enumeration

AA_PRD_DES_ACCOUNT__PASSBOOK

Name

Value

NO Y

NO Y

Description

Back to domain

Enumeration

AA_PRD_DES_ACCOUNT__SHADOW_ACCOUNT

Name

Value

YES NULL

YES NULL

SHADOW_ACCOUNT

Description

Back to domain

Enumeration

AA_PRD_DES_ACCOUNT__GENERATE_IBAN

Name

Value

NO YES

NO YES

_GENERATE_IBAN

Description

Back to domain

Enumeration Name

ERROR OVERRIDE INFORMATION CAP FLOOR

AA_PRD_DES_ACCOUNT__PR_ATTRIBUTE__PR_BRK_RES

Value

ERROR OVERRIDE INFORMATION CAP FLOOR

Description

Back to domain

Enumeration Name

DUE CAPITALISE DEFER

AA_PRD_DES_ACCOUNT__PR_ATTRIBUTE__PR_APP_METHOD

Value

DUE CAPITALISE DEFER

Description

Back to domain

Enumeration

AA_PRD_DES_ACCOUNT__DEFAULT_ATTR_OPTION

Name

Value

RESETTING NON__RESETTING

RESETTING NON-RESETTING

ULT_ATTR_OPTION

Description

Back to domain

Enumeration

AA_PRD_DES_ACCOUNT__DEFAULT_NEGOTIABLE

Name

Value

YES NO

YES NO

AULT_NEGOTIABLE

Description

Back to domain

Enumeration Name

FIX__VALUE MANDATORY NEGOTIABLE NON__NEGOTIABLE OVERRIDE RESETTING NON__RESETTING

AA_PRD_DES_ACCOUNT__NR_ATTRIBUTE__NR_OPTIONS__NR_OPTIONS

Value

FIX-VALUE MANDATORY NEGOTIABLE NON-NEGOTIABLE OVERRIDE RESETTING NON-RESETTING

Description

Back to domain

Enumeration Name

ERROR OVERRIDE

AA_PRD_DES_ACCOUNT__NR_ATTRIBUTE__NR_TYPE__NR_MESSAGE

Value

ERROR OVERRIDE

Description

Back to domain

Enumeration

AA_PRD_PRF_ACCOUNT__BASE_DATE_TYPE

Name

Value

AGREEMENT START

AGREEMENT START

BASE_DATE_TYPE

Description

Back to domain

Enumeration

AA_PRD_PRF_ACCOUNT__DATE_CONVENTION

Name

Value

CALENDAR BACKWARD FORWARD FORWARD_SAME_MONTH

CALENDAR BACKWARD FORWARD FORWARD SAME MONTH

DATE_CONVENTION

Description

Back to domain

Enumeration

AA_PRD_PRF_ACCOUNT__DATE_ADJUSTMENT

Name

Value

VALUE PERIOD

VALUE PERIOD

DATE_ADJUSTMENT

Description

Back to domain

Enumeration

AA_PRD_PRF_ACCOUNT__PASSBOOK

Name

Value

NO Y

NO Y

Description

Back to domain

Enumeration

AA_PRD_PRF_ACCOUNT__SHADOW_ACCOUNT

Name

Value

YES NULL

YES NULL

SHADOW_ACCOUNT

Description

Back to domain

Enumeration

AA_PRD_PRF_ACCOUNT__GENERATE_IBAN

Name

Value

NO YES

NO YES

_GENERATE_IBAN

Description

Back to domain

Enumeration Name

ERROR OVERRIDE INFORMATION CAP FLOOR

AA_PRD_PRF_ACCOUNT__PR_ATTRIBUTE__PR_BRK_RES

Value

ERROR OVERRIDE INFORMATION CAP FLOOR

Description

Back to domain

Enumeration Name

DUE CAPITALISE DEFER

AA_PRD_PRF_ACCOUNT__PR_ATTRIBUTE__PR_APP_METHOD

Value

DUE CAPITALISE DEFER

Description

Back to domain

Enumeration

AA_PRD_PRF_ACCOUNT__DEFAULT_ATTR_OPTION

Name

Value

RESETTING NON__RESETTING

RESETTING NON-RESETTING

ULT_ATTR_OPTION

Description

Back to domain

Enumeration

AA_PRD_PRF_ACCOUNT__DEFAULT_NEGOTIABLE

Name

Value

YES NO

YES NO

AULT_NEGOTIABLE

Description

Back to domain

Enumeration Name

FIX__VALUE MANDATORY NEGOTIABLE NON__NEGOTIABLE OVERRIDE RESETTING NON__RESETTING

AA_PRD_PRF_ACCOUNT__NR_ATTRIBUTE__NR_OPTIONS__NR_OPTIONS

Value

FIX-VALUE MANDATORY NEGOTIABLE NON-NEGOTIABLE OVERRIDE RESETTING NON-RESETTING

Description

Back to domain

Enumeration Name

ERROR OVERRIDE

AA_PRD_PRF_ACCOUNT__NR_ATTRIBUTE__NR_TYPE__NR_MESSAGE

Value

ERROR OVERRIDE

Description

Back to domain

Enumeration

AA_SIM_ACCOUNT__BASE_DATE_TYPE

Name

Value

AGREEMENT START

AGREEMENT START

ASE_DATE_TYPE

Description

Back to domain

Enumeration

AA_SIM_ACCOUNT__DATE_CONVENTION

Name

Value

CALENDAR BACKWARD FORWARD FORWARD_SAME_MONTH

CALENDAR BACKWARD FORWARD FORWARD SAME MONTH

ATE_CONVENTION

Description

Back to domain

Enumeration

AA_SIM_ACCOUNT__DATE_ADJUSTMENT

Name

Value

VALUE PERIOD

VALUE PERIOD

ATE_ADJUSTMENT

Description

Back to domain

Enumeration

AA_SIM_ACCOUNT__PASSBOOK

Name

Value

NO Y

NO Y

Description

Back to domain

Enumeration

AA_SIM_ACCOUNT__SHADOW_ACCOUNT

Name

Value

YES NULL

YES NULL

HADOW_ACCOUNT

Description

Back to domain

Enumeration

AA_SIM_ACCOUNT__GENERATE_IBAN

Name

Value

NO YES

NO YES

GENERATE_IBAN

Description

Back to domain

Enumeration

AA_SIM_ACCOUNT__PR_ATTRIBUTE__PR_BRK_RES

Name

Value

ERROR OVERRIDE INFORMATION CAP FLOOR

ERROR OVERRIDE INFORMATION CAP FLOOR

TE__PR_BRK_RES

Description

Back to domain

Enumeration

AA_SIM_ACCOUNT__PR_ATTRIBUTE__PR_APP_METHOD

Name

Value

DUE CAPITALISE DEFER

DUE CAPITALISE DEFER

__PR_APP_METHOD

Description

Back to domain

Enumeration

AA_SIM_ACCOUNT__DEFAULT_ATTR_OPTION

Name

Value

RESETTING NON__RESETTING

RESETTING NON-RESETTING

LT_ATTR_OPTION

Description

Back to domain

Enumeration

AA_SIM_ACCOUNT__DEFAULT_NEGOTIABLE

Name

Value

YES NO

YES NO

ULT_NEGOTIABLE

Description

Back to domain

Enumeration Name

FIX__VALUE MANDATORY NEGOTIABLE NON__NEGOTIABLE OVERRIDE RESETTING NON__RESETTING

AA_SIM_ACCOUNT__NR_ATTRIBUTE__NR_OPTIONS__NR_OPTIONS

Value

FIX-VALUE MANDATORY NEGOTIABLE NON-NEGOTIABLE OVERRIDE RESETTING NON-RESETTING

Description