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__OpportunityComponent__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Opportunity Component Name | AUTO NUMBER |
|
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__Opportunity__c | Opportunity | MASTER-DETAIL | An internal field used to maintain the link between the Opportunity and the Opportunity Component. |
AQB__Account__c | Account | LOOKUP | The name of the Account to which this Opportunity belongs. |
AQB__Amount__c | Amount | CURRENCY(9,2) | The Amount of this component of the Opportunity. |
AQB__Description__c | Description | TEXT AREA(255) | Any free text information you wish to associate with this Opportunity Component. |
AQB__GoalCategoryFormula__c | Goal Category | FORMULA (TEXT)(1300) |
|
AQB__GoalCategory__c | Deprecated Goal Category | PICKLIST | Automatically filled in if is left blank and if there is a Goal Category in the Designation in the Chart of Accounts. |
AQB__GoalFormula__c | Goal | FORMULA (TEXT)(1300) |
|
AQB__Goal__c | Deprecated Goal | PICKLIST | Automatically filled in if is left blank and if there is a Goal in the Designation in the Chart of Accounts. |
AQB__InstitutionalUnit__c | Institutional Unit | LOOKUP | The Institutional Unit associates with this Opportunity Component. |
AQB__ProposedDesignation__c | Proposed Designation | LOOKUP | The Designation that is being proposed to the donor for the funding of this Opportunity. |
aqcv_conversionid__c | aqcv conversionid | TEXT(255) | Unique id |
AQC_AccountIsPending__c | Account is Pending | FORMULA (CHECKBOX) |
|
AQC_InstallmentDueDate__c | Installment Due Date(Pledge Only) | DATE |
|
AQC_New_Account__c | New Account | CHECKBOX |
|
AQC_TrustConditions__c | Trust Conditions | PICKLIST |
|
Currency__c | Currency | PICKLIST |
|
Method_of_payment__c | Method of payment | PICKLIST |
|
Usyd_Payment_Received__c | Payment Received | CHECKBOX |
|
USYD_ProposedDesignationName__c | Proposed Designation Name | FORMULA (TEXT)(1300) | To display the Proposed Designation Name as text |
Validation rules
Name | Label |
|---|---|
Due_Date_and_Amount_are_Required | Due_Date_and_Amount_are_Required |
USYD_Required_Trust_for_Non_Pending_Desi | USYD_Required_Trust_for_Non_Pending_Desi |
USYD_AmountRequired | USYD_AmountRequired |
USYD_InstallmentDateRequired | USYD_InstallmentDateRequired |
Triggers
Name | Label |
|---|---|
OpportunityComponentDeleteAfter | AQB.OpportunityComponentDeleteAfter |
OpportunityComponentUpsertAfter | AQB.OpportunityComponentUpsertAfter |
OpportunityComponentUpsertBefore | AQB.OpportunityComponentUpsertBefore |
Fields Details
Name | Id |
Label | Record ID |
Type | ID |
Required | Yes |
Name | IsDeleted |
Label | Deleted |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | Name |
Label | Opportunity Component Name |
Type | AUTO NUMBER |
Required | 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__Opportunity__c |
Label | Opportunity |
Type | MASTER-DETAIL |
Foreign key | Yes |
Required | Yes |
Help Text | An internal field used to maintain the link between the Opportunity and the Opportunity Component. |
Description | An internal field used to maintain the link between the Opportunity and the Opportunity Component. |
Name | AQB__Account__c |
Label | Account |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The name of the Account to which this Opportunity belongs. |
Description | The name of the Account to which this Opportunity belongs. |
Name | AQB__Amount__c |
Label | Amount |
Type | CURRENCY(9,2) |
Help Text | The Amount of this component of the Opportunity. |
Description | The Amount of this component of the Opportunity. |
Name | AQB__Description__c |
Label | Description |
Type | TEXT AREA(255) |
Help Text | Any free text information you wish to associate with this Opportunity Component. |
Description | Any free text information you wish to associate with this Opportunity Component. |
Name | AQB__GoalCategoryFormula__c |
Label | Goal Category |
Type | FORMULA (TEXT)(1300) |
Name | AQB__GoalCategory__c |
Label | Deprecated Goal Category |
Type | PICKLIST |
Help Text | Automatically filled in if is left blank and if there is a Goal Category in the Designation in the Chart of Accounts. |
Picklist values | Economic Policy |
Description | Automatically filled in if is left blank and if there is a Goal Category in the Designation in the Chart of Accounts. |
Name | AQB__GoalFormula__c |
Label | Goal |
Type | FORMULA (TEXT)(1300) |
Name | AQB__Goal__c |
Label | Deprecated Goal |
Type | PICKLIST |
Help Text | Automatically filled in if is left blank and if there is a Goal in the Designation in the Chart of Accounts. |
Picklist values | Economic Mobility |
Description | Automatically filled in if is left blank and if there is a Goal in the Designation in the Chart of Accounts. |
Name | AQB__InstitutionalUnit__c |
Label | Institutional Unit |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The Institutional Unit associates with this Opportunity Component. |
Description | The Institutional Unit associates with this Opportunity Component. |
Name | AQB__ProposedDesignation__c |
Label | Proposed Designation |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The Designation that is being proposed to the donor for the funding of this Opportunity. |
Description | The Designation that is being proposed to the donor for the funding of this Opportunity. |
Name | aqcv_conversionid__c |
Label | aqcv conversionid |
Type | TEXT(255) |
Unique | Yes |
Description | Unique id |
Name | AQC_AccountIsPending__c |
Label | Account is Pending |
Type | FORMULA (CHECKBOX) |
Required | Yes |
Help Text | Indicates that the Chart of Account is pending approval from finance. |
Name | AQC_InstallmentDueDate__c |
Label | Installment Due Date(Pledge Only) |
Type | DATE |
Name | AQC_New_Account__c |
Label | New Account |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | AQC_TrustConditions__c |
Label | Trust Conditions |
Type | PICKLIST |
Help Text | When the trust conditions do not match, attach to the supporting documentation from the trust office to the Opportunity Files. |
Picklist values | Match |
Name | Currency__c |
Label | Currency |
Type | PICKLIST |
Picklist values | AUD |
Name | Method_of_payment__c |
Label | Method of payment |
Type | PICKLIST |
Picklist values | EFT |
Name | Usyd_Payment_Received__c |
Label | Payment Received |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | USYD_ProposedDesignationName__c |
Label | Proposed Designation Name |
Type | FORMULA (TEXT)(1300) |
Help Text | To display the Proposed Designation Name as text |
Description | To display the Proposed Designation Name as text |