Oracle Designer

Report : ENTITIES AND THEIR ATTRIBUTES

Filename : D:\DOCUME~1\Bart\LOCALS~1\Temp\ckr1AD.tmp.html

Run by : DES

Report Date : 04 Januari 2012

Total Pages : 55

Parameter values

Workarea : GLOBAL SHARED WORKAREA

Container : BBS

Container Version :

Recurse Sub-Containers : Y

Entity Name : %

Diagram :

Entities Created

On/After :

On/Before : 04 Januari 2012

and

Entities Changed

On/After :

On/Before : 04 Januari 2012

04 Januari 2012 Entities and their Attributes Page 2 of 55

Container : BBS Version :

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 3 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

ACC HOLDER PAR VALUE ID 10 N NUMBER 12 0 Unique identification number for the Acc Holder Par Value.

VALUE 20 Y CHAR 240 The value of the Account Holder Parameter Value.

ACC HOLDER PARAMETER ID 10 N NUMBER 6 0 Unique identification number for the Acc Holder Parameter.

CODE 20 N CHAR 4 Unique identifying code for the Acc Holder Parameter.

IND AHR UPDATEABLE 30 N CHAR 1 Indicates whether the Account Holder can update the Account Holder Parameter Value.

IND AHR VISIBLE 40 N CHAR 1 Indicates whether the Account Holder can see the Account Holder Parameter Value.

IND INTERNAL 50 N CHAR 1 Indicates whether the Account Holder Parameter is needed for the BBS itself.

SEQNO 60 N NUMBER 7 0 Sequence number of the Account Holder Parameter used for display.

NAME 70 N CHAR 40 The name of the Acc Holder Parameter.

VALUE CHECK 80 Y VARCHAR2 4000 Value check is a piece of SQL that can be used to check the value of the Parameter.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 4 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

ACCOUNT ID 10 N NUMBER 12 0 Unique identification number for the Account.

ACCOUNT NUMBER 20 N INTEGER 10 An account number is a unique number identifying the Account that can be used in Transactions.

ACCOUNT NAME 30 N CHAR 20 The name of the Account which has to be referred in payments.

STATUS 40 N CHAR 1 The status of the Account in the Account life cycle.

IND FEE CONTRA ACCOUNT 50 N CHAR 1 Indication whether the holding tax or compensation must be taken from the contra account.

IND COLLECT OPTION 60 N CHAR 1 Indicates whether the Account can be used to initiate a collect on another Account.

BEGINDATE 70 N DATE The date the Account was opened.

ACCOUNT HOLDER 80 N CHAR 80 The account holder is the ascription of the Account consisting of the names of the Account Holders.

DESCRIPTION 90 Y CHAR 40 Description of the Account to be used in addition of Account Holder in the contra holder field of the Transaction

CONTRACTUAL ENDDATE 100 Y DATE The enddate of the Account stated in the Account opening contract.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 5 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

ACCOUNT ENDDATE 110 Y DATE The date the Account was closed.

NEW ACCOUNT NUMBER 120 Y INTEGER 10 New account number is the number of the Account of the replacement Account after the Account has been liquidated.

NEW ACCOUNT NAME 130 Y CHAR 20 New account name is the name of the Account of the replacement Account after the Account has been liquidated.

NEW ACCOUNT HOLDER 140 Y CHAR 80 New account holder is the name of the Account Holder of the replacement Account after the Account has been liquidated.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 6 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

ACCOUNT CUR BALANCE ID 10 N NUMBER 12 0 Unique identification number for the Account Cur Balance.

BALANCE DATE 20 N DATE Balance date is the date for which the Account Cur Balance is calculated.

REGISTRATION DATE 30 N DATE Registration date is the moment in time the Account Cur Balance was submitted.

BALANCE EFFECT 40 N NUMBER 12 2 The amount of money in the Account Currency Balance at the balance date based on the date effect of the Transactions.

BALANCE UNAVAILABLE 50 N NUMBER 18 5 The amount of money of the Account Currency unavailable for use at the balance date based on the date effect of the Transactions when taking into account holding tax due or compensation due.

BALANCE JOURNAL 60 N NUMBER 12 2 The amount of money in the Account Currency Balance at the balance date based on the date journal of the Transactions.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 7 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

ACCOUNT CURRENCY ID 10 N NUMBER 12 0 Unique identification number for the Account Currency.

BEGINDATE 20 N DATE The begindate of the Account Currency.

STATUS 30 N CHAR 1 The status of the Account Currency in the Account Currency life cycle.

INT CALC AMOUNT 40 Y NUMBER 12 2 Calculated intermediary balance for holding tax due or compensation due.

INT CALC DATE 50 Y DATE Date of calculation for the intermediary balance for holding tax due or compensation due.

CALCULATION STARTDATE 60 Y DATE The startdate for the holding tax calculation or compensation calculation. The calculation startdate can be used to support holding tax or compensation calculations for the Account Currency. Holding tax or compensation for the Account Currency before this date has been correctly calculated and paid. The calculation startdate can be changed when Transactions are added with a date effect before the calculation startdate or when a Holding Tax Rate or Compensation Rate is changed with a begindate before the

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 8 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

ACCOUNT CURRENCY calculation startdate.

BALANCE CALCULATION DATE 70 Y DATE Balance calculation date is the startdate for the calculation of the balance effect of Account Currency Balances. Account Currency Balances for the Account Currency before this date have been correctly calculated. The balance calculation date may be changed when Transactions are added with a date effect before the balance calculation date. The balances effect of all Account Currency Balances after the balance calculation date have to be recalculated.

BASE CORRECTION AMOUNT 80 Y NUMBER 18 2 The base correction amount is the amount of money that is substracted from the balances in the Account Currency that are shown to the Account Holder. The base correction amount may be used when an Account Holder has loaned a sum of money in the Account Currency to have additional spending room in the current account. Because it is not possible to have a negative balance in the current account, a separate loan agreement has to be made. The base correction amount can be set to the amount of money loaned, so the Account Holder can see the negative

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 9 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

ACCOUNT CURRENCY balance on the current account.

ENDDATE 90 Y DATE The enddate of the Account Currency.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 10 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

ACCOUNT HOLDER ID 10 N NUMBER 12 0 Unique identification number for the Account Holder.

LEGAL PERSON TYPE 20 N CHAR 1 Legal person type indicates whether the Account Holder is a natural person or a corporation.

GENDER 30 N CHAR 1 The gender of the Account Holder if the Account Holder is a natural person.

STATUS 40 N CHAR 1 The status of the Account Holder in the Account Holder life cycle.

IND UNDER GUARDIANSHIP 50 N CHAR 1 Ind under guardianship indicates whether a guardian is appointed as a Representative for the Account Holder.

INTERNAL NAME 60 N CHAR 30 Username identifies the name of the Account Holder in Account names and the username for the Account Holder in the BBS.

BIRTH OR CONSTITUTION DATE 70 N DATE The date the Account Holder was born if the Account Holder is a natural person or the date the Account Holder was constituted if the Account Holder is a corporation.

BEGINDATE 80 N DATE The begindate of the Account Holdership.

NAME OR LAST NAME 90 N CHAR 80 Last name of the Account Holder if the Account

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 11 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

ACCOUNT HOLDER Holder is a natural person or name of the Account Holder if the Account Holder is a corporation.

FIRST NAME 100 Y CHAR 40 The first name of the Account Holder if the Account Holder is a natural person.

INITIALS 110 Y CHAR 12 The initials of the Account Holder if the Account Holder is a natural person.

DEATH OR CLOSING DATE 120 Y DATE The date the Account Holder died if the Account Holder was a natural person or the date the Account Holder closed down if the Account Holder was a corporation.

ENDDATE 130 Y DATE The enddate of the Account Holdership.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 12 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

ACCOUNT HOLDING ID 10 N NUMBER 12 0 Unique identification number for the Account Holding.

BEGINDATE 20 N DATE The begindate of the Account Holding.

STATUS 30 N CHAR 1 The status of the Account Holding in the Account Holding life cycle.

IND ACCOUNT OPENING 40 N CHAR 1 Indicates whether the Account Holder opened the Account.

IND ACCOUNT CLOSING 50 N CHAR 1 Indicates whether the Account Holder closed the Account.

ENDDATE 60 Y DATE The enddate of the Account Holding.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 13 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

ACCOUNT TYPE ID 10 N NUMBER 6 0 Unique identification number for the Account Type.

CODE 20 N CHAR 8 Unique identifying code for the Account Type.

BEGINDATE 30 N DATE The begindate of the Account Type.

ACCOUNT SUPERTYPE 40 N CHAR 1 Account Supertype identifies the basic handling of the Account in the Natural Money Banking Law.

COMPENSATION TYPE 50 N CHAR 1 Compensation type identifies the way compensation is calculated. It can be collective based on Compensation Rate, individual based on Specific Rate or there can be no compensation calculation.

IND DISCONTINUABLE 60 N CHAR 1 Indicates whether it is possible to withdraw money from the Account if it is a savings Account or repay if it is a loan Account or modify the Guarantee agreement before the contractual enddate of the Account has been reached.

IND DEPOSITABLE 70 N CHAR 1 Indicates whether extra deposits on the Account are possible, if the Account is a savings account.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 14 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

ACCOUNT TYPE IND ONLY CONTRA ACCOUNT 80 N CHAR 1 Indicates whether payments from the Account may only be made to the contra account of the Account if the Account is not a current account.

IND CONTRACTUAL ENDDATE 90 N CHAR 1 Indicates whether Accounts of the Account Type should have a contractual enddate.

IND NEW ALLOWED 100 N CHAR 1 Indicates whether new Accounts for the Account Type can be issued.

NAME 110 N CHAR 40 The name of the Account Type.

DURATION 120 Y INTEGER 5 Duration is the time expressed in duration unit for the Account Type, applicable for time deposits.

DURATION UNIT 130 Y CHAR 1 Duration unit is the unit in which the time for the Account Type duration is expressed, which is applicable for time deposits.

ENDDATE 140 Y DATE The enddate of the Account Type.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 15 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

ACCOUNT TYPE CURRENCY ID 10 N NUMBER 9 0 Unique identification number for the Account Type Currency.

BEGINDATE 20 N DATE The begindate of the Account Type Currency.

IND NEW ALLOWED 30 N CHAR 1 Indicates whether new Account Currencies for the Account Type Currency can be issued.

MINIMUM AMOUNT 40 Y NUMBER 12 2 The minimum amount of the Account Type Currency allowed if an Account of the Account Type is opened in the Account Currency.

MAXIMUM AMOUNT 50 Y NUMBER 12 2 The maximum amount of the Account Type Currency allowed if an Account of the Account Type is opened in the Account Currency.

ENDDATE 60 Y DATE The enddate of the Account Type Currency.

ACCOUNT TYPE LEDGER ID 10 N NUMBER 9 0 Unique identification number for the Account Type Ledger.

BEGINDATE 20 N DATE The begindate of the Account Type Ledger.

ENDDATE 30 Y DATE The enddate of the Account Type Ledger.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 16 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

ADDRESS ID 10 N NUMBER 12 0 Unique identification number for the Address.

BEGINDATE 20 N DATE The begindate of the Address registration.

VERIFICATION STATUS 30 N CHAR 1 The result status of the Address verification.

DATE VERIFIED 40 Y DATE Date verified is the moment in time the Addres was verified by the Address Verification Service.

POSTAL CODE 50 Y CHAR 15 The postal code uniquely identifies a specific area within a Country.

HOUSE NUMBER 60 Y CHAR 15 The location identification of the home within the street.

ADDRESS LINE 1 70 Y CHAR 80 The first line of the fully qualified Address.

ADDRESS LINE 2 80 Y CHAR 80 The second line of the fully qualified Address.

VILLAGE OR CITY 90 Y CHAR 80 The town or village where the Address is located in.

ENDDATE 100 Y DATE The enddate of the Address registration.

AVAILABLE ACCOUNT NUMBER ACCOUNT NUMBER 10 N INTEGER 10

MARKED FOR USE 20 Y DATE Date and time the Available Account Number is marked for use.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 17 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

BANK ID 10 N NUMBER 9 0 Unique identification number for the Bank.

CODE 20 N CHAR 12 The bank code is the unique identifying code for the Bank.

NAME 30 N CHAR 40 The name of the Bank.

BEGINDATE 40 N DATE The begindate of the Bank.

EMAIL ADDRESS 50 N CHAR 120 First email address of the Bank to be used for mail that is transmitted over the internet.

EMAIL ADDRESS2 60 N CHAR 120 Second email address of the Bank to be used for mail that is transmitted over the internet.

MESSAGE SERVERNAME 70 N CHAR 120 The name of the message server of the bank.

CONTACT 80 N CHAR 2000 Information needed to contact the Bank, such as contact name, telephone number and address.

ENDDATE 90 Y DATE The enddate of the Bank.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 18 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

BANK STATEMENT ID 10 N NUMBER 15 0 Unique identification number for the Bank Statement.

YEAR 20 N INTEGER 4 The calendar year in which the Bank Statement was issued.

SEQNO 30 N NUMBER 7 0 Sequence number of the Bank Statement within the calendar year.

REFERENCE DATE 35 N DATE The date the Bank Statement refers to. Transactions with date journal before this date are included in the Account Currency Balance of the Bank Statement.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 19 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

COMPENSATION RATE ID 10 N NUMBER 9 0 Unique identification number for the Compensation Rate.

BEGINDATE 20 N DATE The begindate of the Compensation Rate.

RATE 40 N NUMBER 12 5 Rate is the Compensation Rate per computing interval.

COMPUTING INTERVAL 50 N CHAR 1 Computing interval is the interval at which the Compensation Rate is computed and the bank compensation is collected.

CALCULATION SCHEME 60 N CHAR 1 The calculation scheme determines the way in which the compensation is calculated.

DISC RATE TYPE 70 N CHAR 1 Disc rate type determines the way the discontination rate is calculated.

DISCONTINUATION RATE 80 N NUMBER 12 5 Discontinuation rate is the percentage cost of withdrawing money from a savings Account or paying of a loan in a loan Account.

ENDDATE 90 Y DATE The enddate of the compensation rate. Enddate is helpful in processing Compensation Rates because the next instance of Compensation Rate does not have to be evaluated when determining the enddate.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 20 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

COUNTRY ID 10 N NUMBER 6 0 Unique identification number for the Country.

CODE 20 N CHAR 2 Unique identifying code for the Country (probably ISO).

NAME 30 N CHAR 40 The name of the Country.

BEGINDATE 40 N DATE The begindate of the Country.

IND TRANSNATIONAL 50 N CHAR 1 Indicates whether the government is representing a group of nations.

GOVERNMENT 60 N CHAR 80 The name of the government of the Country.

EMAIL ADDRESS 70 N CHAR 120 First email address of the government of the Country to be used for mail that is transmitted over the internet.

EMAIL ADDRESS2 80 N CHAR 120 Second email address of the government of the Country to be used for mail that is transmitted over the internet.

CONTACT 90 N CHAR 2000 Information needed to contact the government of the Country, such as contact name, telephone number and address.

POSTAL CODE FORMAT 100 Y CHAR 40 Postal code format identifies the structure of the postal codes in the Country.

ENDDATE 110 Y DATE The enddate of the Country.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 21 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

CURRENCY ID 10 N NUMBER 9 0 Unique identification number for the Currency.

CODE 20 N CHAR 15 Unique identifying code for the Currency (probably ISO).

NAME 30 N CHAR 40 The name of the Currency.

BEGINDATE 40 N DATE The begindate of the Currency.

IND INTERNATIONAL 50 N CHAR 1 Indicates if the Currency is internationally accepted as means of payment.

IND NATURAL 60 N CHAR 1 Indicates if the Currency is a natural money Currency.

ISSUER 70 Y CHAR 80 The name of the government issuing the Currency.

TAX ACCOUNT NUMBER 80 Y INTEGER 10 Tax account number is the number of the destination Account for the holding tax.

TAX ACCOUNT NAME 90 Y CHAR 20 Tax account name is the name of the destination Account for the holding tax.

TAX ACCOUNT HOLDER 100 Y CHAR 80 Tax account holder is the name of the Account Holder of the destination Account for the holding tax.

EMAIL ADDRESS 110 Y CHAR 120 First email address of the government issuing the Currency to be used for mail that is transmitted over the

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 22 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

CURRENCY internet.

EMAIL ADDRESS2 120 Y CHAR 120 Second email address of the government of the Country to be used for mail that is transmitted over the internet.

CONTACT 130 Y CHAR 2000 Information needed to contact the government issuing the Currency, such as contact name, telephone number and address.

ENDDATE 140 Y DATE The enddate of the Currency.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 23 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

DOCUMENT TYPE ID 10 N NUMBER 6 0 Unique identification number for the Document Type.

CODE 20 N CHAR 15 Unique identifying code for the Document Type.

NAME 30 N CHAR 40 The name of the Document Type.

BEGINDATE 40 N DATE The begindate of the Document Type.

LEGAL TYPE 50 N CHAR 1 Legal type indicates the legal use of the Legal Document.

REPRESENTATION TYPE 60 N CHAR 1 Representation type indicates whether the Legal Document is text or image.

IND MODEL TEXT 70 N CHAR 1 Indicates whether the document text is based on a model text.

CUSTOMER SIGNATURE 80 N CHAR 1 Indicates in which way the Legal Document should be signed by the Account Holder.

EMPLOYEE SIGNATURE 90 N CHAR 1 Indicates whether the Legal Document should be signed by an employee of the Bank.

IND VERIFICATION 90 N CHAR 1 Indicates whether the Legal Document should be verified by an employee of the Bank.

IND APPROVAL 100 N CHAR 1 Indicates whether the Legal Document should be approved by an employee of the Bank.

IND MANUAL DOCUMENT NUMBER 110 N CHAR 1 Indicates whether the document number of the

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 24 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

DOCUMENT TYPE Legal Document is entered manually.

IND MANUAL DATE OF ISSUE 120 N CHAR 1 Indicates whether the date of issue of the Legal Document is entered manually.

IND MANUAL DOCUMENT LABEL 130 N CHAR 1 Indicates whether the document label of the Legal Document is entered manually.

AHR REFERENCE 140 N CHAR 1 Identifies the way Account Holder is referenced in the Legal Document.

ACT REFERENCE 150 N CHAR 1 Identifies the way Account is referenced in the Legal Document.

RPE REFERENCE 160 N CHAR 1 Identifies the way Representative is referenced in the Legal Document.

NTY REFERENCE 170 N CHAR 1 Identifies the way Nationality is referenced in the Legal Document.

AHG REFERENCE 190 N CHAR 1 Identifies the way Account Holding is referenced in the Legal Document.

ENDDATE 190 Y DATE The enddate of the Document Type.

MODEL TEXT 200 Y TEXT Model text contains a text with substitution parameters to create a Legal Document.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 25 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

GENERAL JOURNAL ID 10 N NUMBER 9 0 Unique identification number for the General Journal.

YEAR 20 N INTEGER 4 The calendar year in which the General Journal was created.

SEQNO 30 N NUMBER 7 0 Sequence number of the General Journal within the calendar year.

NAME 40 N CHAR 80 The name of the General Journal.

REGISTRATION DATE 50 N DATE Registration date is the moment in time the General Journal was created.

BEGINDATE 60 N DATE The begindate of the General Journal.

ENDDATE 70 Y DATE The enddate of the General Journal.

GENERAL LEDGER ID 10 N NUMBER 6 0 Unique identification number for the General Ledger.

CODE 20 N CHAR 8 Unique identifying code for the General Ledger.

NAME 30 N CHAR 40 The name of the General Ledger.

BEGINDATE 40 N DATE The begindate of the General Ledger.

RANKING 50 N INTEGER 4 The ranking of the General Ledger within the superior General Ledger.

ENDDATE 60 Y DATE The enddate of the General Ledger.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 26 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

HOLDER ACCOUNT BOOK ID 10 N NUMBER 15 0 Unique identification number for the Holder Account Book.

ACCOUNT NUMBER 20 N INTEGER 10 Account number is the number of the destination Account for the Holder Account Book.

ACCOUNT NAME 30 N CHAR 20 Account name is the name of the destination Account for the Holder Account Book.

ACCOUNT HOLDER 40 N CHAR 80 Account holder is the name of the Account Holder of the destination Account for the Holder Account Book.

HOLDER ADDRESS ID 10 N NUMBER 12 0 Unique identification number for the Holder Address.

BEGINDATE 20 N DATE The begindate of the Holder Address.

ADDRESS TYPE 30 N CHAR 1 Type of Address which can be statutory or postal address.

ENDDATE 40 Y DATE The enddate of the Holder Address.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 27 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

HOLDING TAX RATE ID 10 N NUMBER 9 0 Unique identification number for the Holding Tax Rate.

BEGINDATE 20 N DATE The begindate of the Holding Tax Rate.

RATE 30 N NUMBER 12 5 Rate is the Holding Tax Rate per computing interval.

COMPUTING INTERVAL 40 N CHAR 1 Computing interval is the interval at which the Holding Tax Rate is computed and the holding tax is collected.

CALCULATION SCHEME 50 N CHAR 1 The calculation scheme determines the way in which the holding tax is calculated.

EXCHANGE RATE 60 N NUMBER 12 5 Exchange rate is the rate to be paid when the currency is exchanged for another currency.

ENDDATE 70 Y DATE The enddate of the Holding Tax Rate. Enddate is helpful in processing Holding Tax Rates because the next instance of Holding Tax Rate does not have to be evaluated when determining the enddate.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 28 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

INCOMING TRANSACTION ID 10 N NUMBER 21 0 Unique identification number for the Transaction.

ACT ACCOUNT NUMBER 20 Y INTEGER 10 An account number is a unique number identifying the Account that can be used in Transactions.

ACT ACCOUNT NAME 30 Y CHAR 20 Act account name is the name of the Account for the Transaction.

ACT ACCOUNT HOLDER 40 Y CHAR 80 The account holder is the ascription of the Account consisting of the names of the Account Holders.

CRY CODE 50 Y CHAR 15 Unique identifying code for the Currency (probably ISO).

DATE EFFECT 60 N DATE The date when the Transaction comes into effect and has to be taken into account for holding tax and compensation calculations.

REGISTRATION DATE 70 N DATE Registration date is the moment in time the Transaction was submitted.

TRANSACTION TYPE 80 N CHAR 2 Transaction type categorises Transactions often based on the way the Transaction is processed.

STATUS 90 N CHAR 1 The status of the Transaction in the Transaction process cycle.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 29 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

INCOMING TRANSACTION ACCOUNT NUMBER 100 N INTEGER 10 Account number is the number of the contra Account for the Transaction.

ACCOUNT NAME 110 N CHAR 20 Account name is the name of the contra Account for the Transaction.

AMOUNT 120 N NUMBER 18 2 The amount is the amount of money in the Account Currency of the Transaction.

ACCOUNT HOLDER 130 N CHAR 80 Account holder is the name of the account holder of the contra Account for the Transaction.

PAYMENT REFERENCE 140 Y CHAR 32 Reference for the payment to be used for automatic processing.

CONTRA BANK TRN ID 150 Y NUMBER 21 0 Contra bank trn id is the Transaction identification of the Bank of the contra party for the Transaction.

BASE AMOUNT 160 Y NUMBER 18 2 Base amount is the amount of money in the base Currency of the Unverified Transaction which can be used for payments in Currencies that are not available in the Account.

DESCRIPTION 170 Y CHAR 240 Description specifies the intended purpose of the money of the Unverified Transaction which can be specified by the agent that is initating the

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 30 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

INCOMING TRANSACTION Unverified Transaction

PRIVATE_NOTES 180 Y CHAR 240 The private notes contain private information about the handling of the Transaction such as Currency exchange rates and costs.

PUBLIC_NOTES 190 Y CHAR 240 The public notes contain shared information about the handling of the Transaction such as redirection of the Transaction to a replacement Account.

MGE ID 200 Y NUMBER 21 0 Unique identification number for the Message.

REF ACT ID 210 Y NUMBER 12 0 Reference account for transactions directed to a replacement account.

REF TRN ID 220 Y NUMBER 21 0 Reference transaction number for correction entry.

SET ID 230 Y NUMBER 21 0 Identification for the set containing the transaction.

ACK ACCOUNT HOLDER 240 Y CHAR 80 Ack account holder is the name of the Account Holder of the Account for the Transaction.

PENDING DATE 250 Y DATE The date the Unverified Transaction went into a pending state. Unverified Transactions that stay too long in a pending state will be disapproved.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 31 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

LEGAL DOCUMENT ID 10 N NUMBER 12 0 Unique identification number for the Legal Document.

REGISTRATION DATE 20 N DATE Registration date is the moment in time the Legal Document was submitted.

DOCUMENT NUMBER 30 N CHAR 40 The number of the document given to it by the issuer.

DATE OF ISSUE 40 N DATE Date of issue is the date the Legal Document was issued by the government.

DOCUMENT LABEL 50 N CHAR 80 Document label is a text describing the Legal Document.

VERIFICATION STATUS 60 N CHAR 1 Status of the Legal Document in the verification process.

APPROVAL STATUS 70 N CHAR 1 Status of the Legal Document in the approval process.

CUSTOMER SIGNATURE DATE 80 Y DATE The date and time of the Account Holder signature.

EMPLOYEE SIGNATURE DATE 90 Y DATE The date and time of the employee signature.

VALID UNTIL DATE 100 Y DATE Enddate of validness of the Legal Document.

SEQNO 110 N NUMBER 7 0 Sequence number of the Legal Document with reference to the Account, Representative or Nationality.

IMAGE MIME TYPE 120 Y CHAR 4 The mime type of the image file.

IMAGE FILE NAME 130 Y CHAR 255 The file name of the image file.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 32 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

LEGAL DOCUMENT CHARACTER SET 140 Y CHAR 128 The character set used for the image or the text.

IMAGE LAST UPDATED 150 Y DATE The date and time when the image file was updated for the last time.

DOCUMENT TEXT 160 Y TEXT Document text contains the text of the signed Legal Document.

DOCUMENT IMAGE 170 Y IMAGE Document image contains a image copy of the Legal Document.

NATIONALITY ID 10 N NUMBER 12 0 Unique identification number for the Nationality.

BEGINDATE 20 N DATE The begindate of the Nationality registration.

IDENTIFICATION NUMBER 30 N CHAR 40 Identification number of the Nationality.

DATE LAST VERIFIED 40 Y DATE The date last verified is the moment in time the Nationality of the Account Holder was last verified.

ENDDATE 50 Y DATE The enddate of the Nationality registration.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 33 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

OUTGOING TRANSACTION ID 10 N NUMBER 21 0 Unique identification number for the Transaction.

DATE EFFECT 20 N DATE The date when the Transaction comes into effect and has to be taken into account for holding tax and compensation calculations.

REGISTRATION DATE 30 N DATE Registration date is the moment in time the Transaction was submitted.

TRANSACTION TYPE 40 N CHAR 2 Transaction type categorises Transactions often based on the way the Transaction is processed.

STATUS 50 N CHAR 1 The status of the Transaction in the Transaction process cycle.

ACCOUNT NUMBER 60 N INTEGER 10 Account number is the number of the contra Account for the Transaction.

ACCOUNT NAME 70 N CHAR 20 Account name is the name of the contra Account for the Transaction.

AMOUNT 80 Y NUMBER 18 2 The amount is the amount of money in the Account Currency of the Transaction.

ACCOUNT HOLDER 90 N CHAR 80 Account holder is the name of the account holder of the contra Account for the

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 34 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

OUTGOING TRANSACTION Transaction.

PAYMENT REFERENCE 100 Y CHAR 32 Reference for the payment to be used for automatic processing.

CONTRA BANK TRN ID 110 Y NUMBER 21 0 Contra bank trn id is the Transaction identification of the Bank of the contra party for the Transaction.

BASE AMOUNT 120 Y NUMBER 18 2 Base amount is the amount of money in the base Currency of the Transaction which can be used for payments in Currencies that are not available in the Account.

DESCRIPTION 130 Y CHAR 240 Description specifies the intended purpose of the money of the Transaction which can be specified by the agent that is initating the Transaction

PRIVATE NOTES 140 Y CHAR 240 The private notes contain private information about the handling of the Transaction such as Currency exchange rates and costs.

PUBLIC_NOTES 150 Y CHAR 240 The public notes contain shared information about the handling of the Transaction such as redirection of the Transaction to a replacement Account.

MGE ID 160 Y NUMBER 21 0 Unique identification number for the Message.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 35 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

OUTGOING TRANSACTION REF TRN ID 170 Y NUMBER 21 0 Reference transaction number for correction entry.

SET ID 180 Y NUMBER 21 0 Identification for the set containing the transaction.

ACK MGE ID 190 Y NUMBER 21 0 Unique identification number for the acknowledgement Message.

PENDING DATE 200 Y DATE The date the Transaction went into a pending state. Transactions that stay too long in a pending state will be disapproved.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 36 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

PAYMENT ORDER ID 10 N NUMBER 12 0 Unique identification number for the Payment Order.

SEQNO 20 N NUMBER 12 0 Sequence number of the Payment Order within the Account.

PAYMENT TYPE 30 N CHAR 2 Payment type specifies the basic category of a Payment Order.

ACCOUNT NUMBER 40 N INTEGER 10 Account number is the number of the destination Account for the Payment Order.

ACCOUNT NAME 50 N CHAR 20 Account name is the name of the destination Account for the Payment Order.

INTERVAL 60 Y CHAR 1 The interval at which maximum amount for collection has to be evaluated.

AMOUNT 70 N NUMBER 18 2 Amount is the amount of money that is tranferred in each Transaction that is part of the Payment Order.

STATUS 80 N CHAR 1 The status of the Payment Order in the Payment Order life cycle.

ACCOUNT HOLDER 90 N CHAR 80 Account holder is the name of the account holder of the destination Account for the Payment Order.

BEGINDATE 100 N DATE The begindate of the Payment Order.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 37 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

PAYMENT ORDER REGISTRATION DATE 110 N DATE Registration date is the moment in time the Payment Order was submitted.

PAYMENT REFERENCE 120 Y CHAR 32 Reference for the payment to be used for automatic processing.

NEXT DATE 130 Y DATE The date for the next payment.

DESCRIPTION 140 Y CHAR 240 Description of the Payment Order that can be seen in Transaction description.

ENDDATE 150 Y DATE The enddate of the Payment Order.

ACTION CODE 160 Y CHAR 1 An identification of the actions to be performed on the Payment Order.

REF TRN ID 170 Y NUMBER 21 0 Reference transaction number for correction entry.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 38 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

PERMISSION FEEDBACK ID 10 N NUMBER 15 0 Unique identification number for the Permission Feedback.

PTC ID 20 N NUMBER 21 0 Unique identification number for the Permission to Collect.

LOCATION 30 N CHAR 1 Location of the error.

MSE CODE 40 N CHAR 9 Unique code of the Message.

MESSAGE SEVERITY 50 N CHAR 1 The severity of the error (informational, warning, error, fatal).

REGISTRATION DATE 60 N TIMESTAMP The timestamp of the feedback occurrence.

P_1 70 Y CHAR 240 Substitution parameter 1 to be used in the error message text.

P_2 80 Y CHAR 240 Substitution parameter 2 to be used in the error message text.

P_3 90 Y CHAR 240 Substitution parameter 3 to be used in the error message text. Substitution parameter 3 to be used in the error message text.

P_4 100 Y CHAR 240 Substitution parameter 4 to be used in the error message text.

P_5 110 Y CHAR 240 Substitution parameter 5 to be used in the error message text.

MESSAGE TEXT 120 Y VARCHAR2 4000 The text of the feedback.

RESOLVED DATE 120 Y TIMESTAMP The timestap of the feedback resolution.

Oracle Designer Report : ckattb14

04 Januari 2012 Entities and their Attributes Page 39 of 55

Container : BBS Version :

Entity Name Attribute Name Seq. Opt. Format Length Dec Pl Attribute Description Attribute Notes

PERMISSION TO COLLECT ID 10 N NUMBER 15 0 Unique identification number for the Permission to Collect.

SEQNO 20 N NUMBER 12 0 Sequence number of the Permission to Collect for the Account Currency and contra Account.

ACCOUNT NUMBER 30 N INTEGER 10 Account number is the number of the contra Account for the Permission to Collect.

ACCOUNT NAME 40 N CHAR 20 Account name is the name of the contra Account for the Permission to Collect.

PERMISSION TYPE 50 N CHAR 1 The type of permission, either acceptor or collector. The acceptor initiates the Permission to Collect.

BEGINDATE 60 N DATE The date the Permission to Collect starts or has started.

ACCOUNT HOLDER 70 N CHAR 80 Account holder is the ascription of the contra Account for the Permission to Collect.

STATUS 80 N CHAR 1 The status of the Permission to Collect for messaging.