JC Payroll Post WORK (JC10703)

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

Product: WennSoft Products (131)
Series: 3rd Party

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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1BACHNUMB SearchBatch NumberSTR15_LBAUString1615
2JRNENTRY SearchJournal EntryLI8_U0Long Integer48
3SQNCLINE SearchSequence LineDLR19_$S2Currency1019
4ACTINDX SearchAccount IndexLI_14Long Integer414
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
5TRXAMNT SearchTRX AmountDLR19_$S2Currency1019
6EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
7DSCRIPTN SearchDescriptionSTR30String3230
8GLLINMSG SearchGL LINE MessagesML_GL_LINE_MessagesLong Integer40
9GLLINMS2 SearchGL LINE Messages2ML_GL_LINE_Messages2Long Integer40
10CURRNIDX SearchCurrency IndexINT3Integer23
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

Leave a Reply

Your email address will not be published. Required fields are marked *