JC_Job_Transaction_Entry_POST (JC20401)

azurecurveProductsWennSoft Products (131)3rd PartyJC_Job_Transaction_Entry_POST (JC20401)

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

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

Display Name: JC_Job_Transaction_Entry_POST
Physical Name: JC20401
Technical Name: JC_Job_Transaction_Entry_POST

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Job_Transaction_Entry_POST'].USERID AS 'JC_Job_Transaction_Entry_POST-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC20401 AS ['JC_Job_Transaction_Entry_POST']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Job_Transaction_Entry_POST'].USERID = ['Users Master'].USERID
2BCHSOURC SearchBatch SourceSTR15String1615
3BACHNUMB SearchBatch NumberSTR15_LBAUString1615
4JRNENTRY SearchJournal EntryLI8_U0Long Integer48
5SQNCLINE SearchSequence LineDLR19_$S2Currency1019
6WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
7WS_Job_Name SearchWS Job NameSTR30String3230
8Cost_Code_Number_1 SearchCost Code Number:CC_PhaseSTR6_CC_PhaseString86
9Cost_Code_Number_2 SearchCost Code Number:CC_StepSTR6_CC_StepsString86
10Cost_Code_Number_3 SearchCost Code Number:CC_DetailSTR6_CC_DetailString86
11Cost_Code_Number_4 SearchCost Code Number:CC_ComponentSTR6_CC_ComponentString86
12Cost_Element SearchCost ElementINT3_RB0_UInteger23
13Cost_Code_Description SearchCost Code DescriptionSTR30String3230
14ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['JC_Job_Transaction_Entry_POST'].ACTINDX AS 'JC_Job_Transaction_Entry_POST-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       JC20401 AS ['JC_Job_Transaction_Entry_POST']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['JC_Job_Transaction_Entry_POST'].ACTINDX = ['Account Index Master'].ACTINDX
15OFFINDX SearchOffset Account IndexLI_14Long Integer414
16TRXAMNT SearchTRX AmountDLR19_$S2Currency1019
17TRXQTY SearchTRX QTYDLR17_QTY_RBS0_STRCurrency1017
18GLLINMSG SearchGL LINE MessagesML_GL_LINE_MessagesLong Integer40
19TRXDATE SearchTRX DateDT_DateDate46
20ACCTTYPE SearchAccount TypeDDL_Account_TypeInteger20
21DSCRIPTN SearchDescriptionSTR30String3230
22PSTGSTUS SearchPosting StatusINTInteger20
23WSReserved_CB1 SearchWSReserved CB1CBBoolean20
24WSReserved_CB2 SearchWSReserved CB2CBBoolean20
25WSReserved_CB3 SearchWSReserved CB3CBBoolean20
26WSReserved_CB4 SearchWSReserved CB4CBBoolean20
27WSReserved_CB5 SearchWSReserved CB5CBBoolean20
28WSReserved_STR1 SearchWSReserved STR1STR10String1210
29WSReserved_STR2 SearchWSReserved STR2STR10String1210
azurecurveProductsWennSoft Products (131)3rd PartyJC_Job_Transaction_Entry_POST (JC20401)

Leave a Reply

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