Asperato Connector Data Dictionary

AccountPaymentDetails__c

Label: Account Payment Details

Stores details of the relationship between the Account and Payment objects for payments that are associated with multiple documents.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Account__c Account Fall 2021 Lookup to the Account associated with the Account Payment Details record.

Looks up to: Account

Lookup
Document_Currency__c Document Currency Fall 2021 Stores the document currency.

Text(255)
Document_Numbers__c Document Numbers Fall 2021 List of Documents associated with Account Payment Details.

LongTextArea(100000)
Document_Type__c Document Type Fall 2021 Stores the document type.

Picklist:
Billing Document
Sales Invoice
Make_a_Payment__c Make a Payment Spring 2022 Displays the Pay Now button image or alternative text.

Formula:
IF(Payment_Link_URL__c <> $Label.PayNowNotApplicable,HYPERLINK(Payment_Link_URL__c ,IF(ISBLANK($Setup.AsperatoSettingsFF__c.Pay_Now_Button_URL__c),$Label.PayNowTitle,IMAGE($Setup.AsperatoSettingsFF__c.Pay_Now_Button_URL__c,$Label.PayNowTitle))),$Label.PayNowNotApplicable)
Text
Payment_Amount__c Payment Amount Fall 2021 Stores the Payment Amount.

Number(18,2)
Payment_Currency__c Deprecated:Payment Currency Fall 2021 This field has been deprecated

Looks up to: c2g__codaAccountingCurrency__c

Lookup
Payment_Link_URL__c Payment Link URL Fall 2021 Stores the payment URL.

Formula:
IF(AND(NOT(ISBLANK(Payment__c)),ISBLANK(Payment__r.asp04__Authorisation__c)) , IF($Setup.asp04__AsperatoOneSettings__c.asp04__Enable_Pay_auth_URL_Data_Integrity__c, 'https://' & $Setup.asp04__AsperatoOneSettings__c.asp04__Server_URL__c & '/PMWeb1?pmRef=' & Payment__r.asp04__Customer_ID__c & '&pid=' + Payment__c & '&dit=' + Payment__r.asp04__Data_Integrity_Token__c, 'https://' & $Setup.asp04__AsperatoOneSettings__c.asp04__Server_URL__c & '/PMWeb1?pmRef=' & Payment__r.asp04__Customer_ID__c & '&pid=' + Payment__c) ,$Label.PayNowNotApplicable)
Text
Payment_Link__c Payment Link Fall 2021 Stores the payment link to Asperato.

Formula:
IF(AND(NOT(ISBLANK(Payment__c)),ISBLANK(Payment__r.asp04__Authorisation__c)), IF($Setup.asp04__AsperatoOneSettings__c.asp04__Enable_Pay_auth_URL_Data_Integrity__c, HYPERLINK('https://' &$Setup.asp04__AsperatoOneSettings__c.asp04__Server_URL__c & '/PMWeb1?DLcnp=jdi&pid='+ Payment__c &'&pmRef='&Payment__r.asp04__Customer_ID__c & '&dit=' + Payment__r.asp04__Data_Integrity_Token__c ,$Label.PayNowTitle), HYPERLINK('https://' &$Setup.asp04__AsperatoOneSettings__c.asp04__Server_URL__c & '/PMWeb1?DLcnp=jdi&pid='+ Payment__c &'&pmRef='&Payment__r.asp04__Customer_ID__c,$Label.PayNowTitle)),$Label.PayNowNotApplicable)
Text
Payment__c Payment Fall 2021 Lookup to the Asperato Payment associated with the Account Payment Details record.

Looks up to: asp04__Payment__c

Lookup


© Copyright 2009–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.