Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PC40309
Product: Human Resources (414)
Series:
Display Name: PC Position Seat Budget Funds
Physical Name: PC40309
Technical Name: pcPositionSeatsBudgetFundsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PLANCODE Plan String STR15_LBAU 15 2 JOBTITLE Job Title String STR6_Payroll_Code 6 3 TEMPSEAT Temporary Seat Boolean Boolean 0 4 SEAT Seat Long Integer INT6 6 5 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 6 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 7 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['PC Position Seat Budget Funds'].ACTINDX AS 'PC Position Seat Budget Funds-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PC40309 AS ['PC Position Seat Budget Funds']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PC Position Seat Budget Funds'].ACTINDX = ['Account Index Master'].ACTINDX
8 FUNDSOURCE Fund Source String STR30 30 9 PRCNTAGE Percentage Currency DLR5_%2 8