Attention: Confluence is not suitable for the storage of highly confidential data. Please ensure that any data classified as Highly Protected is stored using a more secure platform.
If you have any questions, please refer to the University's data classification guide or contact ict.askcyber@sydney.edu.au
Object: AQB__RelationshipAccount__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
OwnerId | Owner ID | LOOKUP |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Number | AUTO NUMBER |
|
RecordTypeId | Record Type ID | LOOKUP |
|
CreatedDate | Created Date | DATETIME |
|
CreatedById | Created By ID | LOOKUP |
|
LastModifiedDate | Last Modified Date | DATETIME |
|
LastModifiedById | Last Modified By ID | LOOKUP |
|
SystemModstamp | System Modstamp | DATETIME |
|
AQB__AccountId__c | Account | LOOKUP | The account for this Relationship With Account. |
AQB__AccountRoleGroup__c | Account Role Group | FORMULA (TEXT)(1300) |
|
AQB__AccountRole__c | Account Role | LOOKUP | For this Relationship between an Account and another Account, this describes the role of the first Account, e.g. Client, Customer, etc. |
AQB__AwardSoftCredit__c | Related Account Receive Soft Credit | CHECKBOX | Check this box if the Related Account should be awarded a Soft Credit for gifts made by the primary Account. |
AQB__EndDate__c | End Date | DATE | The date on which this Relationship ended. |
AQB__Ended__c | Ended | PICKLIST | Indicates whether the End Date is precise or only known to have been on or prior to the End Date. |
AQB__GiveSoftCredit__c | Account Gives Soft Credit | FORMULA (TEXT)(1300) |
|
AQB__LinkedRelationship__c | Linked Relationship | LOOKUP |
|
AQB__OwnerUnit__c | Owner Unit | PICKLIST | Designates the Unit of the User that created this record. This field is intended for use in creating Sharing Rules for the purpose of controlling access to the record. |
AQB__RelatedAccountRole__c | Related Account Role | LOOKUP | For this Relationship between an Account and another Account, this describes the role of the second Account, e.g. Client, Customer, etc. |
AQB__RelatedAccount__c | Related Account | LOOKUP | The second Account involved in this Account-to-Account Relationship. |
AQB__RelatedTo__c | Related To | TEXT(80) | Name or other information about the person this account is related to. |
AQB__RelationshipPair__c | Relationship Pair | TEXT(30) |
|
AQB__Source__c | Source | TEXT(100) |
|
AQB__StartDate__c | Start Date | DATE | The date on which this Relationship began. |
AQB__Started__c | Started | PICKLIST | Indicates whether the Start Date is precise or only known to have been on or prior to the Start Date. |
aqcv_conversionid__c | aqcv conversionid | TEXT(255) | Unique id |
Validation rules
Name | Label |
|---|---|
Cannot_Change_Related_Account | Cannot_Change_Related_Account |
EndDateAfterStartDate | EndDateAfterStartDate |
Triggers
Name | Label |
|---|---|
RelationshipAccountDelete | AQB.RelationshipAccountDelete |
RelationshipAccountInsertBefore | AQB.RelationshipAccountInsertBefore |
RelationshipAccountUpdate | AQB.RelationshipAccountUpdate |
Fields Details
Name | Id |
Label | Record ID |
Type | ID |
Required | Yes |
Name | OwnerId |
Label | Owner ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | IsDeleted |
Label | Deleted |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | Name |
Label | Number |
Type | AUTO NUMBER |
Required | Yes |
Name | RecordTypeId |
Label | Record Type ID |
Type | LOOKUP |
Foreign key | Yes |
Name | CreatedDate |
Label | Created Date |
Type | DATETIME |
Required | Yes |
Name | CreatedById |
Label | Created By ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | LastModifiedDate |
Label | Last Modified Date |
Type | DATETIME |
Required | Yes |
Name | LastModifiedById |
Label | Last Modified By ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | SystemModstamp |
Label | System Modstamp |
Type | DATETIME |
Required | Yes |
Name | AQB__AccountId__c |
Label | Account |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The account for this Relationship With Account. |
Description | The account for this Relationship With Account. |
Name | AQB__AccountRoleGroup__c |
Label | Account Role Group |
Type | FORMULA (TEXT)(1300) |
Name | AQB__AccountRole__c |
Label | Account Role |
Type | LOOKUP |
Foreign key | Yes |
Help Text | For this Relationship between an Account and another Account, this describes the role of the first Account, e.g. Client, Customer, etc. |
Description | For this Relationship between an Account and another Account, this describes the role of the first Account, e.g. Client, Customer, etc. |
Name | AQB__AwardSoftCredit__c |
Label | Related Account Receive Soft Credit |
Type | CHECKBOX |
Required | Yes |
Help Text | Check this box if the Related Account should be awarded a Soft Credit for gifts made by the primary Account. |
Default value | false |
Description | Check this box if the Related Account should be awarded a Soft Credit for gifts made by the primary Account. |
Name | AQB__EndDate__c |
Label | End Date |
Type | DATE |
Help Text | The date on which this Relationship ended. |
Description | The date on which this Relationship ended. |
Name | AQB__Ended__c |
Label | Ended |
Type | PICKLIST |
Help Text | Indicates whether the End Date is precise or only known to have been on or prior to the End Date. |
Picklist values | On |
Description | Indicates whether the End Date is precise or only known to have been on or prior to the End Date. |
Name | AQB__GiveSoftCredit__c |
Label | Account Gives Soft Credit |
Type | FORMULA (TEXT)(1300) |
Help Text | Gifts from this Account will automatically be awarded as soft credits to the related Account. |
Name | AQB__LinkedRelationship__c |
Label | Linked Relationship |
Type | LOOKUP |
Foreign key | Yes |
Name | AQB__OwnerUnit__c |
Label | Owner Unit |
Type | PICKLIST |
Help Text | Designates the Unit of the User that created this record. This field is intended for use in creating Sharing Rules for the purpose of controlling access to the record. |
Picklist values | Advancement Services |
Description | Designates the Unit of the User that created this record. This field is intended for use in creating Sharing Rules for the purpose of controlling access to the record. |
Name | AQB__RelatedAccountRole__c |
Label | Related Account Role |
Type | LOOKUP |
Foreign key | Yes |
Help Text | For this Relationship between an Account and another Account, this describes the role of the second Account, e.g. Client, Customer, etc. |
Description | For this Relationship between an Account and another Account, this describes the role of the second Account, e.g. Client, Customer, etc. |
Name | AQB__RelatedAccount__c |
Label | Related Account |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The second Account involved in this Account-to-Account Relationship. |
Description | The second Account involved in this Account-to-Account Relationship. |
Name | AQB__RelatedTo__c |
Label | Related To |
Type | TEXT(80) |
Help Text | Name or other information about the person this account is related to. |
Description | Name or other information about the person this account is related to. |
Name | AQB__RelationshipPair__c |
Label | Relationship Pair |
Type | TEXT(30) |
Name | AQB__Source__c |
Label | Source |
Type | TEXT(100) |
Name | AQB__StartDate__c |
Label | Start Date |
Type | DATE |
Help Text | The date on which this Relationship began. |
Description | The date on which this Relationship began. |
Name | AQB__Started__c |
Label | Started |
Type | PICKLIST |
Help Text | Indicates whether the Start Date is precise or only known to have been on or prior to the Start Date. |
Picklist values | on |
Description | Indicates whether the Start Date is precise or only known to have been on or prior to the Start Date. |
Name | aqcv_conversionid__c |
Label | aqcv conversionid |
Type | TEXT(255) |
Unique | Yes |
Description | Unique id |