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__TransactionLoad__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
OwnerId | Owner ID | LOOKUP |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Transaction Load 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 | This field is only used during data entry and is transferred to the gift level following recording of the transaction. |
AQB__Affinaquest2DialogReference__c | Affinaquest 2Dialog Reference | NUMBER(11,0) |
|
AQB__Amount__c | Amount | CURRENCY(9,2) |
|
AQB__Anonymous__c | Anonymous | CHECKBOX |
|
AQB__Balance__c | Balance | CURRENCY(9,2) |
|
AQB__Batch__c | Batch | LOOKUP |
|
AQB__BypassGiftRecognitionLogic__c | Bypass Gift Recognition Logic | CHECKBOX | If checked, bypass the logic that creates the gift recognition credits based on the defualt percentages specified on the contact. This field should not be shown on user screens, it is used internally. |
AQB__CampaignAppeal__c | Campaign Appeal | LOOKUP |
|
AQB__Card__c | Card | TEXT(30) |
|
AQB__ChartOfAccounts__c | Designation | LOOKUP |
|
AQB__CheckNumber__c | Check Number | NUMBER(18,0) |
|
AQB__ConditionalPledge__c | Conditional Pledge | CHECKBOX |
|
AQB__DailyHigh__c | Daily High | CURRENCY(11,4) |
|
AQB__DailyLow__c | Daily Low | CURRENCY(11,4) |
|
AQB__DateDue__c | Date Due | DATE |
|
AQB__Date__c | Date | DATE |
|
AQB__DateofTransfer__c | Date of Transfer | DATE |
|
AQB__DebitAccount__c | Debit Account | LOOKUP |
|
AQB__Description__c | Description | TEXT AREA (LONG)(2000) |
|
AQB__DonorDate__c | Gift Date | DATE |
|
AQB__ExpirationMonth__c | Expiration Month | TEXT(2) | Two digit month as in "01", "02",..."12" representing the month that the credit card used for this transaction expires (if applicable). |
AQB__ExpirationYear__c | Expiration Year | TEXT(4) |
|
AQB__GiftExternalID__c | Gift External ID | TEXT(40) |
|
AQB__GiftType__c | Gift Type | PICKLIST |
|
AQB__Last4DigitsofCard__c | Last 4 Digits of Card | NUMBER(4,0) |
|
AQB__MatchedGiftExternalID__c | Matched Gift External ID | TEXT(40) |
|
AQB__MatchedGift__c | Deprecated Matched Gift | LOOKUP |
|
AQB__Matched__c | Matched? | CHECKBOX |
|
AQB__Method__c | Method | PICKLIST |
|
AQB__NameonCard__c | Name on Card | TEXT(40) |
|
AQB__NumberofShares__c | Number of Shares | NUMBER(13,4) |
|
AQB__PledgePayment__c | Pledge Payment | CHECKBOX | Indicates whether payment is used to fulfill a pledge. |
AQB__PledgeWriteOffNotation__c | Pledge Write Off Notation | PICKLIST |
|
AQB__Posted__c | Posted | CHECKBOX |
|
AQB__ProcessSoftCredits__c | Process Soft Credits | CHECKBOX | Directs triggers to automatically create transactions and gifts for all accounts that have been flagged to automatically receive a soft credit in a relationship. |
AQB__ProportionalGiftCredit__c | Proportional Gift Recognition Credit | CHECKBOX |
|
AQB__Reference__c | Reference | TEXT(20) |
|
AQB__Restricted__c | Restricted? | CHECKBOX |
|
AQB__SendPledgeReminder__c | Send Pledge Reminder | CHECKBOX |
|
AQB__TickerSymbol__c | Ticker Symbol | TEXT(10) |
|
AQB__TransactionExternalID__c | Transaction External ID | TEXT(40) |
|
AQB__TransactionType__c | Transaction Type | PICKLIST |
|
AQB__VID__c | VID | NUMBER(4,0) |
|
AQB__VoidNote__c | Void Note | TEXT AREA (LONG)(32000) |
|
AQB__Voided__c | Voided? | CHECKBOX |
|
aqcv_conversionid__c | aqcv conversionid | TEXT(255) | Unique id |
Validation rules
Name | Label |
|---|---|
Check_Number | Check_Number |
Date_Required | Date_Required |
Gift_Type_is_Required | Gift_Type_is_Required |
Method_is_Required | Method_is_Required |
Transaction_Type_is_Required | Transaction_Type_is_Required |
Triggers
Name | Label |
|---|---|
TransactionLoadInsertAfter | AQB.TransactionLoadInsertAfter |
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 | Transaction Load 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 |
Required | Yes |
Name | AQB__Acknowledgement__c |
Label | Acknowledgement |
Type | LOOKUP |
Foreign key | Yes |
Description | This field is only used during data entry and is transferred to the gift level following recording of the transaction. |
Name | AQB__Affinaquest2DialogReference__c |
Label | Affinaquest 2Dialog Reference |
Type | NUMBER(11,0) |
Name | AQB__Amount__c |
Label | Amount |
Type | CURRENCY(9,2) |
Required | Yes |
Name | AQB__Anonymous__c |
Label | Anonymous |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | AQB__Balance__c |
Label | Balance |
Type | CURRENCY(9,2) |
Name | AQB__Batch__c |
Label | Batch |
Type | LOOKUP |
Foreign key | Yes |
Name | AQB__BypassGiftRecognitionLogic__c |
Label | Bypass Gift Recognition Logic |
Type | CHECKBOX |
Required | Yes |
Help Text | If checked, bypass the logic that creates the gift recognition credits based on the defualt percentages specified on the contact. This field should not be shown on user screens, it is used internally. |
Default value | false |
Description | If checked, bypass the logic that creates the gift recognition credits based on the defualt percentages specified on the contact. This field should not be shown on user screens, it is used internally. |
Name | AQB__CampaignAppeal__c |
Label | Campaign Appeal |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | AQB__Card__c |
Label | Card |
Type | TEXT(30) |
Name | AQB__ChartOfAccounts__c |
Label | Designation |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | AQB__CheckNumber__c |
Label | Check Number |
Type | NUMBER(18,0) |
Name | AQB__ConditionalPledge__c |
Label | Conditional Pledge |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | AQB__DailyHigh__c |
Label | Daily High |
Type | CURRENCY(11,4) |
Name | AQB__DailyLow__c |
Label | Daily Low |
Type | CURRENCY(11,4) |
Name | AQB__DateDue__c |
Label | Date Due |
Type | DATE |
Name | AQB__Date__c |
Label | Date |
Type | DATE |
Name | AQB__DateofTransfer__c |
Label | Date of Transfer |
Type | DATE |
Name | AQB__DebitAccount__c |
Label | Debit Account |
Type | LOOKUP |
Foreign key | Yes |
Name | AQB__Description__c |
Label | Description |
Type | TEXT AREA (LONG)(2000) |
Name | AQB__DonorDate__c |
Label | Gift Date |
Type | DATE |
Name | AQB__ExpirationMonth__c |
Label | Expiration Month |
Type | TEXT(2) |
Description | Two digit month as in "01", "02",..."12" representing the month that the credit card used for this transaction expires (if applicable). |
Name | AQB__ExpirationYear__c |
Label | Expiration Year |
Type | TEXT(4) |
Name | AQB__GiftExternalID__c |
Label | Gift External ID |
Type | TEXT(40) |
Name | AQB__GiftType__c |
Label | Gift Type |
Type | PICKLIST |
Picklist values | Gift |
Name | AQB__Last4DigitsofCard__c |
Label | Last 4 Digits of Card |
Type | NUMBER(4,0) |
Name | AQB__MatchedGiftExternalID__c |
Label | Matched Gift External ID |
Type | TEXT(40) |
Name | AQB__MatchedGift__c |
Label | Deprecated Matched Gift |
Type | LOOKUP |
Foreign key | Yes |
Name | AQB__Matched__c |
Label | Matched? |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | AQB__Method__c |
Label | Method |
Type | PICKLIST |
Picklist values | Check |
Name | AQB__NameonCard__c |
Label | Name on Card |
Type | TEXT(40) |
Name | AQB__NumberofShares__c |
Label | Number of Shares |
Type | NUMBER(13,4) |
Name | AQB__PledgePayment__c |
Label | Pledge Payment |
Type | CHECKBOX |
Required | Yes |
Help Text | Indicates whether payment is used to fulfill a pledge. |
Default value | false |
Description | Indicates whether payment is used to fulfill a pledge. |
Name | AQB__PledgeWriteOffNotation__c |
Label | Pledge Write Off Notation |
Type | PICKLIST |
Help Text | The reason that this pledge is being written off. |
Picklist values | Donor Canceled Pledge |
Name | AQB__Posted__c |
Label | Posted |
Type | CHECKBOX |
Required | Yes |
Default value | true |
Name | AQB__ProcessSoftCredits__c |
Label | Process Soft Credits |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Description | Directs triggers to automatically create transactions and gifts for all accounts that have been flagged to automatically receive a soft credit in a relationship. |
Name | AQB__ProportionalGiftCredit__c |
Label | Proportional Gift Recognition Credit |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | AQB__Reference__c |
Label | Reference |
Type | TEXT(20) |
Name | AQB__Restricted__c |
Label | Restricted? |
Type | CHECKBOX |
Required | Yes |
Help Text | If checked, this Transaction is designated as a restricted gift. |
Default value | true |
Name | AQB__SendPledgeReminder__c |
Label | Send Pledge Reminder |
Type | CHECKBOX |
Required | Yes |
Help Text | Indicates that the Account making this pledge wishes to receive a reminder on the due date. |
Default value | true |
Name | AQB__TickerSymbol__c |
Label | Ticker Symbol |
Type | TEXT(10) |
Name | AQB__TransactionExternalID__c |
Label | Transaction External ID |
Type | TEXT(40) |
Unique | Yes |
Help Text | An External ID used to uniquely identify a transaction. Used to link a pledge payment to the corresponding pledge debit transaction. |
Name | AQB__TransactionType__c |
Label | Transaction Type |
Type | PICKLIST |
Picklist values | Payment |
Name | AQB__VID__c |
Label | VID |
Type | NUMBER(4,0) |
Name | AQB__VoidNote__c |
Label | Void Note |
Type | TEXT AREA (LONG)(32000) |
Name | AQB__Voided__c |
Label | Voided? |
Type | CHECKBOX |
Required | Yes |
Help Text | If checked, this transaction has been voided. |
Default value | false |
Name | aqcv_conversionid__c |
Label | aqcv conversionid |
Type | TEXT(255) |
Unique | Yes |
Description | Unique id |