JC Payroll Post WORK (JC10703)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC10703

Display Name: JC Payroll Post WORK
Physical Name: JC10703
Technical Name: JC_Payroll_Post_WORK

Group Display Name: Job Cost
Group Technical Name: Job Cost

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	BACHNUMB	Batch Number	STR15_LBAU	String	15
2	JRNENTRY	Journal Entry	LI8_U0	Long Integer	8
3	SQNCLINE	Sequence Line	DLR19_$S2	Currency	19
4	ACTINDX	Account Index	LI_14	Long Integer	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['JC Payroll Post WORK'].ACTINDX AS 'JC Payroll Post WORK-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM JC10703 AS ['JC Payroll Post WORK'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['JC Payroll Post WORK'].ACTINDX = ['Account Index Master'].ACTINDX
5	TRXAMNT	TRX Amount	DLR19_$S2	Currency	19
6	EMPLOYID	Employee ID	STR15_Employee_ID	String	15
7	DSCRIPTN	Description	STR30	String	30
8	GLLINMSG	GL LINE Messages	ML_GL_LINE_Messages	Long Integer	0
9	GLLINMS2	GL LINE Messages2	ML_GL_LINE_Messages2	Long Integer	0
10	CURRNIDX	Currency Index	INT3	Integer	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['JC Payroll Post WORK'].CURRNIDX AS 'JC Payroll Post WORK-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM JC10703 AS ['JC Payroll Post WORK'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['JC Payroll Post WORK'].CURRNIDX = ['Currency Setup'].CURRNIDX