SuiteQL type for Invoices and custom invoices? (like 'SalesOrd' for sales order)

AI generated answer (using internal Slack threads):

The SuiteQL type for Invoices is 'Invc'. However, for custom invoices, there isn't a specific SuiteQL type. Instead, you would need to use the 'Invc' type and then specify the custom form or template ID that you are using for your custom invoices. This can be done by adding a condition in your SuiteQL query to filter by the custom form ID. For example, your SuiteQL query might look something like this:

sql
SELECT * FROM Invc WHERE customform = <your_custom_form_id>

Please replace

<your_custom_form_id>

with the actual ID of your custom form. Remember, this is just a basic example. Depending on your specific needs, you may need to modify this query or join it with other tables to get the desired data. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******