Share
ReportDoes anyone know what this table, JC92001, is used for?
Categories:
You’re offline. This is a read only version of the page.
70
Does anyone know what this table, JC92001, is used for?
If you send an email to support@Key2Act.com with your company name they should be to provide an answer. We are not a Key2Act reseller but we do have a database here with GP/Key2Act. I could fumble through there and try to find a link.
Hi Richard,
are you familiar with Key2Act? Their forums are dead.
I am trying to get unposted transactions from:
select LTRIM(RTRIM(REPLACE(T1.DOCDESCR,'Job',''))) AS WS_Job_Number
, DOCNUMBR
, CASE WHEN T1.POSTED = 0 THEN 'Not Posted'
ELSE 'Posted'
END AS [Posted Status]
from slbReceivablesTrx t1
where
T1.POSTED = 0
AND (DOCNUMBR LIKE 'JC%' OR DOCNUMBR LIKE 'PB%')
to appear in this query:
select * from [CC]..JC92001 T1 with (nolock)
-- JC Job Master - OPEN
INNER JOIN [CC]..JC00102 T2 with (nolock) on T2.[WS_Job_Number] = T1.[WS_Job_Number]
-- JC Job User-Defined Master - OPEN
INNER JOIN [CC]..JC00107 T3 with (nolock) on T3.[WS_Job_Number] = T2.[WS_Job_Number]
-- UPR Employee Master - Manager
LEFT OUTER JOIN UPR00100 t6 WITH (NOLOCK) ON t6.EMPLOYID = t2.WS_Manager_ID
-- RM Customer Master
LEFT OUTER JOIN RM00101 t7 WITH (NOLOCK) ON t7.CUSTNMBR = t2.CUSTNMBR
But there's no unique identifier in slbReceivablesTrx to associate the job transaction with when the billed_amount is 0.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (