How can I create a suiteql query to pull in the account information for the account chosen on the payment transaction?

AI generated answer (using internal Slack threads):

To create a SuiteQL query to pull in the account information for the account chosen on the payment transaction, you would need to join the transaction table with the account table. The account field in the transaction table should match the internal ID of the account in the account table. Here is a basic example of how you might structure this query:

sql
SELECT T.id, T.type, T.account, A.name
FROM Transaction T
JOIN Account A ON T.account = A.id
WHERE T.type = 'CustPymt'

In this query, 'T' is an alias for the Transaction table, and 'A' is an alias for the Account table. The query selects the transaction ID, transaction type, account ID, and account name for all customer payment transactions. The JOIN clause links the Transaction and Account tables based on the account ID. Please note that this is a simplified example and you may need to adjust the query based on your specific needs and the exact structure of your NetSuite database. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******