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__Dues__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
OwnerId | Owner ID | LOOKUP |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Dues 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 |
|
LastActivityDate | Last Activity Date | DATE |
|
LastViewedDate | Last Viewed Date | DATETIME |
|
LastReferencedDate | Last Referenced Date | DATETIME |
|
AQB__AccountId__c | Account | LOOKUP | The account for this Dues. |
AQB__Acknowledgement__c | Acknowledgement | LOOKUP |
|
AQB__CampaignFund__c | Fundraising Campaign | LOOKUP |
|
AQB__Date__c | Dues Date | DATE |
|
AQB__Description__c | Description | TEXT AREA (LONG)(2000) |
|
AQB__ExternalID__c | ExternalID | TEXT(40) | A unique identifier, used during the import of Dues. |
AQB__FundraisingCampaignText__c | Fundraising Campaign Text | TEXT(100) |
|
AQB__NumberOfPayments__c | Number of Payments | NUMBER(6,0) | An internal field, for system use only. |
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__Payments__c | Payments | CURRENCY(9,2) | For internal use only. Do not use in Data Entry or in Reports. |
AQB__PledgeBalanceTotal__c | Pledge Balance - Total | CURRENCY(9,2) | For internal use only. Do not use in Data Entry or in Reports. |
AQB__PledgeEndDate__c | Pledge End Date | DATE | An internal field, used by the system during data entry only. It determines the end date of the pledge payments in the schedule that is being created. |
AQB__PledgeFrequency__c | Pledge Frequency | NUMBER(3,0) | An internal field, used by the system during data entry only. It determines the frequency of the pledge payments in the schedule that is being created. |
AQB__PledgeInterval__c | Pledge Interval | PICKLIST | An internal field, used by the system during data entry only. It determines the interval of the pledge payments in the schedule that is being created. |
AQB__PledgeScheduleType__c | Pledge Schedule Type | PICKLIST | An internal field, used by the system during data entry only. It determines the nature of the pledge payment schedule that is being created. |
AQB__PledgeStartDate__c | Pledge Start Date | DATE | An internal field, used by the system during data entry only. This date will become the due date for the first installment payment. |
AQB__TotalDues__c | Total | FORMULA (CURRENCY)(16,2) |
|
AQB__NextPledgesDueDate__c | Next Pledge Due Date | ROLL-UP SUMMARY | This system-calculated field examines the due dates of all outstanding pledges that are part of this Dues and displays the most imminent such date. |
AQB__PledgeAmount__c | Pledged Amount | ROLL-UP SUMMARY | For a Pledge, the current amount of the pledge. The original amount entered is reduced if the Pledge or part of the Pledge is voided, written off, or paid by a third party. |
AQB__RollUpOfPayments__c | Payments | ROLL-UP SUMMARY |
|
AQB__RollUpPledgeBalance__c | Pledge Balance | ROLL-UP SUMMARY | A system-calculated sum of all as yet unpaid pledges that are part of this Dues. |
USYD_Tax_Amount__c | Tax Amount | FORMULA (CURRENCY)(16,2) | Total Amount divided by 11 |
USYD_Net_Amount__c | Net Amount | FORMULA (CURRENCY)(16,2) | Total - Tax Amount |
Triggers
Name | Label |
|---|---|
DuesTrigger | AQB.DuesTrigger |
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 | Dues 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 | LastActivityDate |
Label | Last Activity Date |
Type | DATE |
Name | LastViewedDate |
Label | Last Viewed Date |
Type | DATETIME |
Name | LastReferencedDate |
Label | Last Referenced Date |
Type | DATETIME |
Name | AQB__AccountId__c |
Label | Account |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The account for this Dues. |
Description | The account for this Dues. |
Name | AQB__Acknowledgement__c |
Label | Acknowledgement |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Acknowledgement type used to acknowledge this dues. |
Name | AQB__CampaignFund__c |
Label | Fundraising Campaign |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The name of the Fund drive that generated this Dues. |
Name | AQB__Date__c |
Label | Dues Date |
Type | DATE |
Help Text | The date of the Dues. |
Name | AQB__Description__c |
Label | Description |
Type | TEXT AREA (LONG)(2000) |
Help Text | Any free text information you wish to associate with this Dues. |
Name | AQB__ExternalID__c |
Label | ExternalID |
Type | TEXT(40) |
Unique | Yes |
Help Text | A unique identifier, used during the import of Gifts. |
Description | A unique identifier, used during the import of Dues. |
Name | AQB__FundraisingCampaignText__c |
Label | Fundraising Campaign Text |
Type | TEXT(100) |
Name | AQB__NumberOfPayments__c |
Label | Number of Payments |
Type | NUMBER(6,0) |
Help Text | An internal field, for system use only. |
Description | An internal field, for system use only. |
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__Payments__c |
Label | Payments |
Type | CURRENCY(9,2) |
Help Text | For internal use only. Do not use in Data Entry or in Reports. |
Description | For internal use only. Do not use in Data Entry or in Reports. |
Name | AQB__PledgeBalanceTotal__c |
Label | Pledge Balance - Total |
Type | CURRENCY(9,2) |
Help Text | For internal use only. Do not use in Data Entry or in Reports. |
Description | For internal use only. Do not use in Data Entry or in Reports. |
Name | AQB__PledgeEndDate__c |
Label | Pledge End Date |
Type | DATE |
Help Text | An internal field, used by the system during data entry only. It determines the end date of the pledge payments in the schedule that is being created. |
Description | An internal field, used by the system during data entry only. It determines the end date of the pledge payments in the schedule that is being created. |
Name | AQB__PledgeFrequency__c |
Label | Pledge Frequency |
Type | NUMBER(3,0) |
Help Text | An internal field, used by the system during data entry only. It determines the frequency of the pledge payments in the schedule that is being created. |
Description | An internal field, used by the system during data entry only. It determines the frequency of the pledge payments in the schedule that is being created. |
Name | AQB__PledgeInterval__c |
Label | Pledge Interval |
Type | PICKLIST |
Help Text | An internal field, used by the system during data entry only. It determines the interval of the pledge payments in the schedule that is being created. |
Picklist values | Week(s) |
Description | An internal field, used by the system during data entry only. It determines the interval of the pledge payments in the schedule that is being created. |
Name | AQB__PledgeScheduleType__c |
Label | Pledge Schedule Type |
Type | PICKLIST |
Help Text | An internal field, used by the system during data entry only. It determines the nature of the pledge payment schedule that is being created. |
Picklist values | Fixed Total Amount, Fixed End Date |
Description | An internal field, used by the system during data entry only. It determines the nature of the pledge payment schedule that is being created. |
Name | AQB__PledgeStartDate__c |
Label | Pledge Start Date |
Type | DATE |
Help Text | An internal field, used by the system during data entry only. This date will become the due date for the first installment payment. |
Description | An internal field, used by the system during data entry only. This date will become the due date for the first installment payment. |
Name | AQB__TotalDues__c |
Label | Total |
Type | FORMULA (CURRENCY)(16,2) |
Name | AQB__NextPledgesDueDate__c |
Label | Next Pledge Due Date |
Type | ROLL-UP SUMMARY |
Help Text | This system-calculated field examines the due dates of all outstanding pledges that are part of this Dues and displays the most imminent such date. |
Description | This system-calculated field examines the due dates of all outstanding pledges that are part of this Dues and displays the most imminent such date. |
Name | AQB__PledgeAmount__c |
Label | Pledged Amount |
Type | ROLL-UP SUMMARY |
Help Text | For a Pledge, the current amount of the pledge. The original amount entered is reduced if the Pledge or part of the Pledge is voided, written off, or paid by a third party. |
Description | For a Pledge, the current amount of the pledge. The original amount entered is reduced if the Pledge or part of the Pledge is voided, written off, or paid by a third party. |
Name | AQB__RollUpOfPayments__c |
Label | Payments |
Type | ROLL-UP SUMMARY |
Name | AQB__RollUpPledgeBalance__c |
Label | Pledge Balance |
Type | ROLL-UP SUMMARY |
Help Text | A system-calculated sum of all as yet unpaid pledges that are part of this Dues. |
Description | A system-calculated sum of all as yet unpaid pledges that are part of this Dues. |
Name | USYD_Tax_Amount__c |
Label | Tax Amount |
Type | FORMULA (CURRENCY)(16,2) |
Help Text | Total Amount divided by 11 |
Description | Total Amount divided by 11 |
Name | USYD_Net_Amount__c |
Label | Net Amount |
Type | FORMULA (CURRENCY)(16,2) |
Help Text | Total - Tax Amount |
Description | Total - Tax Amount |