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__PledgeTerms__c
Fields
Name | Label | Type | Description |
---|---|---|---|
Id | Record ID | ID |
|
OwnerId | Owner ID | LOOKUP |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Pledge Terms 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__Account__c | Account | LOOKUP |
|
AQB__Acknowledgement__c | Acknowledgement | LOOKUP |
|
AQB__Anonymous__c | Anonymous | CHECKBOX |
|
AQB__CampaignAppeal__c | Campaign Appeal | LOOKUP |
|
AQB__ChartOfAccounts__c | Designation | LOOKUP |
|
AQB__ConditionalPledge__c | Conditional Pledge | CHECKBOX |
|
AQB__Currency__c | Donor Currency | LOOKUP |
|
AQB__Description__c | Description | TEXT AREA (LONG)(1000) |
|
AQB__EndDate__c | and ending by | DATE |
|
AQB__Frequency__c | will be paid every | NUMBER(3,0) |
|
AQB__IndividualPaymentOriginalCurrency__c | An individual payment original currency | NUMBER(10,2) | Enter the amount that will be paid with each payment in original currency. |
AQB__IndividualPayment__c | An individual payment of $ | CURRENCY(10,2) |
|
AQB__Interval__c | Interval | PICKLIST |
|
AQB__Method__c | Method | TEXT(10) |
|
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__PledgeScheduleType__c | Pledge Schedule Type | PICKLIST |
|
AQB__PledgeStipulation__c | Pledge Stipulation | PICKLIST | Determines if the pledge is conditional, unconditional or a statement of intent. |
AQB__SendPledgeReminder__c | Send Pledge Reminder | CHECKBOX |
|
AQB__StartDate__c | starting on | DATE |
|
AQB__TotalPledgeOriginalCurrency__c | The Total Pledge Original Currency | NUMBER(10,2) | This amount should indicate the total amount (Original Currency)of the pledge after all payments have been made. |
AQB__TotalPledge__c | The Total Pledge of $ | CURRENCY(10,2) |
|
AQB__numberOfPayments__c | will be paid in this number of payments | NUMBER(2,0) |
|
Validation rules
Name | Label |
---|---|
Pledge_Dates | Pledge_Dates |
Pledge_Start_Date | Pledge_Start_Date |
Triggers
Name | Label |
---|---|
PledgeTermsTrigger | AQB.PledgeTermsTrigger |
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 | Pledge Terms 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__Account__c |
Label | Account |
Type | LOOKUP |
Foreign key | Yes |
Name | AQB__Acknowledgement__c |
Label | Acknowledgement |
Type | LOOKUP |
Foreign key | Yes |
Name | AQB__Anonymous__c |
Label | Anonymous |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | AQB__CampaignAppeal__c |
Label | Campaign Appeal |
Type | LOOKUP |
Foreign key | Yes |
Name | AQB__ChartOfAccounts__c |
Label | Designation |
Type | LOOKUP |
Foreign key | Yes |
Name | AQB__ConditionalPledge__c |
Label | Conditional Pledge |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | AQB__Currency__c |
Label | Donor Currency |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The currency in which the gift has been made. The number entered in the amount field should represent the number of units of this currency that have been given. |
Name | AQB__Description__c |
Label | Description |
Type | TEXT AREA (LONG)(1000) |
Name | AQB__EndDate__c |
Label | and ending by |
Type | DATE |
Help Text | The pledge schedule will be calculated such that all payments will be completed prior to this date. |
Name | AQB__Frequency__c |
Label | will be paid every |
Type | NUMBER(3,0) |
Help Text | Examples: If this field is "1" and the period is "Month(s)", a bill will be generate once each month. If this field is "2" and the period is "Year(s)", a bill is generated every two years. |
Default value | 1 |
Name | AQB__IndividualPaymentOriginalCurrency__c |
Label | An individual payment original currency |
Type | NUMBER(10,2) |
Help Text | Enter the amount that will be paid with each payment in original currency. |
Description | Enter the amount that will be paid with each payment in original currency. |
Name | AQB__IndividualPayment__c |
Label | An individual payment of $ |
Type | CURRENCY(10,2) |
Help Text | Enter the amount that will be paid with each payment. |
Name | AQB__Interval__c |
Label | Interval |
Type | PICKLIST |
Help Text | Payments will be scheduled to occur based upon the period indicated by this field. |
Picklist values | Week(s) |
Name | AQB__Method__c |
Label | Method |
Type | TEXT(10) |
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__PledgeScheduleType__c |
Label | Pledge Schedule Type |
Type | PICKLIST |
Picklist values | Fixed Total Amount, Fixed End Date |
Name | AQB__PledgeStipulation__c |
Label | Pledge Stipulation |
Type | PICKLIST |
Required | Yes |
Help Text | Determines if the pledge is conditional, unconditional or a statement of intent. |
Picklist values | Unconditional |
Description | Determines if the pledge is conditional, unconditional or a statement of intent. |
Name | AQB__SendPledgeReminder__c |
Label | Send Pledge Reminder |
Type | CHECKBOX |
Required | Yes |
Help Text | Indicates that this the Account making this pledge wishes to receive a reminder on the due date. |
Default value | true |
Name | AQB__StartDate__c |
Label | starting on |
Type | DATE |
Help Text | This is the date that the first payment will become due. |
Name | AQB__TotalPledgeOriginalCurrency__c |
Label | The Total Pledge Original Currency |
Type | NUMBER(10,2) |
Help Text | This amount should indicate the total amount (Original Currency)of the pledge after all payments have been made. |
Description | This amount should indicate the total amount (Original Currency)of the pledge after all payments have been made. |
Name | AQB__TotalPledge__c |
Label | The Total Pledge of $ |
Type | CURRENCY(10,2) |
Help Text | This amount should indicate the total amount of the pledge after all payments have been made. |
Name | AQB__numberOfPayments__c |
Label | will be paid in this number of payments |
Type | NUMBER(2,0) |
Help Text | The total number of installment payments that will be made. This number will be used to calculate the date of the last payment. |