are Payroll Liability Check transactions accessibl...
# ask-stanley-ai
i
are Payroll Liability Check transactions accessible via SuiteQL or the REST API?
c
AI generated answer (using internal Slack threads):
Based on the conversations provided, it appears that Payroll data, including Payroll Liability Check transactions, can be accessed via SuiteQL. One of the users shared a SuiteQL query that they use to access Payroll data in a custom employee portal. Here is the query:
Copy code
SELECT
    PayCheck.ID,
    PayCheck.TranDate,
    PayCheck.BatchNumber,
    PayCheck.TranID AS CheckNumber,
    Paycheck.Entity,
    PayCheck.ChkAmount,
    PayCheck.Location AS LocationID,
    Location.Name AS LocationName,
    Employee.ID AS EmployeeID,
    Employee.FirstName,
    Employee.LastName,
    Employee.Email,
    BUILTIN.DF( PayCheckSummary.ItemCategory ) AS ItemCategory,
    BUILTIN.DF( PayCheckSummary.PayItem ) AS PayItem,
    BUILTIN.DF( PayCheckSummary.PayItemType ) AS PayItemType,
    PayCheckSummary.Value,
    PayCheckSummary.Amount
FROM
    Paycheck    
    INNER JOIN Employee ON
        ( Employee.ID = Paycheck.Entity )
    INNER JOIN Location ON
        ( Location.ID = PayCheck.Location )    
    INNER JOIN PayCheckSummary ON
        ( PayCheckSummary.Paycheck = Paycheck.ID )        
WHERE
    ( Paycheck.Entity = 9999 )
    -- AND ( PayCheck.TranDate BETWEEN TO_DATE( '2020-01-01', 'YYYY-MM-DD' ) AND TO_DATE( '2020-12-31', 'YYYY-MM-DD' ) )
ORDER BY
    PayCheck.TranDate
However, the conversations do not provide any information about accessing Payroll Liability Check transactions via the REST API. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.830278158
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.814966917
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.814770758
Please provide your feedback on this answer.