Download page Querying Custom Plan and Its Line Items.
Querying Custom Plan and Its Line Items
You can query and retrieve the custom plans along with the line items that were previously created. The search criteria can be the name containing, plan ID, order ID, proposal ID, order line item ID, or line item ID.
You cannot do a blank search. You must provide at least one value from plan ID, name, order ID, proposal ID, order line item ID, or line item ID in the search field.
Enter at least one of the following API input values in the payload. The query treats each parameter with an OR condition and increases the number of search results with an increase in search parameters.
ID: ID of the custom plan.
Name Containing: Name of the custom plan or null.
Order ID: ID of the order under which the custom plan is created or null.
Order Line Item ID: ID of the order line item or null.
Proposal ID: ID of the proposal or null.
Line Item ID (Proposal Cart): ID of the line item or null.
The API queries and retrieves the custom plan and its line items. It shows the following fields on the custom plan header and the line items under the plan. Fields on the custom plan header:
ID: ID of the custom plan.
Name: Name of the custom plan.
Plan Type: Milestone or Term-based custom plan
Periods Needed: True or False.
Number of Installments: The number of installments on the custom plan, is equal to the line numbers on the plan.
Based On: Percentage or Amount
Computation Method: Custom or Even Distribution.
Description: Description of the custom plan.
Order: ID of the order.
Proposal: ID of the proposal.
Fields on the line items under the plan:
ID: ID of the plan line item.
Name: Name of the plan line item.
Period Start Date: Start date of the plan line item.
Period End Date: End date of the plan line item.
Ready for Invoice Date: Ready for invoice date of the plan line item.
Percent:The percentage of the total price to be computed for the installment.
Payment Term:The payment term for the installment.
Milestone Expected Date: The date when the milestone is to be completed.