3.2.7 Account Party Relationship
Entity Name: APRL
Description: This table holds account party relationships data from product processor.
Data Sequence:
APRL|Account Number|Party Id|Account Relationship|Internet Banking Flag|Phone Banking Flag|Mobile Banking Flag|ATM Card Flag|Debit Card Flag|Account Nickname|Consent to Receive Letter|Consent to Receive Email Communication|Consent to Receive SMS Communication|Messenger Communication Flag|udf1|udf2|udf3|udf4|udf5|udf6|udf7|udf8|udf9|udf10|udf11|udf12|udf13|udf14|udf15|udf16|udf17|udf18|udf19|udf20|udf21|udf22|udf23|udf24|udf25|udf26|udf27|udf28|udf29|udf30|udf31|udf32|udf33|udf34|udf35|udf36|udf37|udf38|udf39|udf40|udf41|udf42|udf43|udf44|udf45|udf46|udf47|udf48|udf49|udf50Table 3-13 Account Details
| Field Name | Description | Possible Values / Examples | Data Type | Data Length | Required/Optional |
|---|---|---|---|---|---|
| Account Number | Account Number as stored in Host | Customer Account Number | VARCHAR2 | 30 | Required |
| Party Id | Party Id as stored in Host | - | VARCHAR2 | 30 | Required |
| Account Relationship | Account Relationship Code |
SOW - Sole Owner, JAF - Joint and First, JAO - Joint and Others, GUA- Guarantor OTH - Other |
VARCHAR2 | 30 | Required |
| Internet Banking Flag | This flag signifies if internet banking flag is enabled for the customer account relationship (if maintained at this level) | Y/N | CHAR | 1 | Optional |
| Phone Banking Flag | This flag signifies if phone banking flag is enabled for the customer account relationship (if maintained at this level) | Y/N | CHAR | 1 | Optional |
| Mobile Banking Flag | This flag signifies if mobile banking flag is enabled for the customer account relationship (if maintained at this level) | Y/N | CHAR | 1 | Optional |
| ATM Card Flag | Check if ATM Card has been issued to the customer for this account | Y/N | CHAR | 1 | Optional |
| Debit Card Flag | Check if Debit Card has been issued to the customer for this account | Y/N | CHAR | 1 | Optional |
| Account Nickname | Short Description given to the Account | - | VARCHAR2 | 120 | Optional |
| Consent to Receive Letter | Signifies if the party has provided consent to receive Letters | Y/N | CHAR | 1 | Optional |
| Consent to Receive Email Communication | Signifies if the party has provided consent to receive Emails | Y/N | CHAR | 1 | Optional |
| Consent to Receive SMS Communication | Signifies if the party has provided consent to receive SMS | Y/N | CHAR | 1 | Optional |
| Messenger Communication Flag | Check if Customer agrees to receive message for example, on WhatsApp updates for the account. It can be other messenger also. | Y/N | CHAR | 1 | Optional |
Parent topic: Party Data