Salesforce

What are the Payments Insights API Standard Fields?

« Go Back
Information
What are the Payments Insights API Standard Fields?
What-are-the-Payments-Insights-API-Standard-Fields
Details

The Insights API provides access to several system endpoints, each containing a set of standard data fields.

  • In addition to the standard fields listed below, Administrators have the ability to select up to 10 Custom Fields of their choice to be included in the Payments API endpoint.

Insights API Payments Endpoint - Standard Fields

Please see the following table to view the standard fields available for Payments within the Insights API.

Field Name

Field Label

Field Type

Field Description

payee_idPayee IDNumberThe unique CyberGrantsID of the organization to which payment is applicable
payment_idPayment IDNumberThe unique CyberGrants identification number for a particular payment. Each payment in CyberGrants will have a distinct payment ID
check_cashed_dateCheck Cashed DateDateThe date a check was cashed for a payment
check_datePayment DateDateThe date that the check was sent or the payment was processed
due_dateDue DateDateThe date that a payment is due to the nonprofit 
request_check_dateRequested Check DateDateThe date that the payment should be processed or a check should be cut
stop_dateStop DateDateThe date the payment was stopped
transmitted_to_ap_dateTransmitted to AP DateDateThe date the payment was transmitted to accounts payable
void_dateVoid DateDateThe date the payment was voided
check_numberCheck NumberStringThe unique identifier used to track physical payments. This number is generated outside of CyberGrants, typically by an accounts payable system
deductible_amountDeductible AmountNumberThe deductible portion of a payment. For product/service payments, this amount often corresponds to the cost price
payment_numberPayment NumberNumberThe count of the number of payments applicable to the grant (i.e. multiple-payment grants)
payment_statusPayment StatusStringThe status of a particular payment
payment_typePayment TypeStringThe classification of a payment
total_amountTotal AmountSumThe payment's total amount 
proposal_typeProgramStringThe proposal type or program name
budget_idBudget IDNumberThe ID that is assigned to each unique budget line within a client’s budget structure. Each payment within CyberGrants is tied to a budget line ID
budget_yearBudget YearNumberThe year from which a budget line is derived

 

What else do you need help with?

Not what you're looking for? Navigate to Understanding Insights API


Powered by