Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PC40307
Product: Human Resources (414)
Series:
Display Name: PC Position Setup Budget Funds
Physical Name: PC40307
Technical Name: pcSetupPositionBudgetFundsSeq 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 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 4 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 5 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['PC Position Setup Budget Funds'].ACTINDX AS 'PC Position Setup Budget Funds-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PC40307 AS ['PC Position Setup Budget Funds']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PC Position Setup Budget Funds'].ACTINDX = ['Account Index Master'].ACTINDX
6 FUNDSOURCE Fund Source String STR30 30 7 PRCNTAGE Percentage Currency DLR5_%2 8