Extender Journals (EXT41100)

azurecurveProductsExtender (3107)ProjectExtender Journals (EXT41100)

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

Product: Extender (3107)
Series: Project

Display Name: Extender Journals
Physical Name: EXT41100
Technical Name: PT_Extender_Journals

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PT_Journal_ID SearchPT Journal IDSTR15_LBAUString1615
2PT_Journal_Description SearchPT Journal DescriptionSTR64String6664
3Extender_Type SearchExtender TypeINT5Integer24
4Extender_Form_ID SearchExtender Form IDSTR15_LBAUString1615
5PT_Transaction_Type SearchPT Transaction TypePT Transaction TypeInteger20
6SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
Key to the Source Document Master (SY00900).

Click to show/hide

SELECT
       ['Extender Journals'].SOURCDOC AS 'Extender Journals-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       EXT41100 AS ['Extender Journals']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['Extender Journals'].SOURCDOC = ['Source Document Master'].SOURCDOC
7Ext_Inv_Batch_From SearchExt_Inv_Batch_FromExtender Invoice Batch FromInteger20
8Ext_Reference_From SearchExt_Reference_FromExtender Reference FromInteger20
9BACHNUMB SearchBatch NumberSTR15_LBAUString1615
10REFRENCE SearchReferenceSTR30String3230
11Form_Field_Number_1 SearchForm Field Number[1]INT5Integer24
12Form_Field_Number_2 SearchForm Field Number[2]INT5Integer24
13Form_Field_Number_3 SearchForm Field Number[3]INT5Integer24
14Form_Field_Number_4 SearchForm Field Number[4]INT5Integer24
15Form_Field_Number_5 SearchForm Field Number[5]INT5Integer24
16Form_Field_Number_6 SearchForm Field Number[6]INT5Integer24
17Form_Field_Number_7 SearchForm Field Number[7]INT5Integer24
18Form_Field_Number_8 SearchForm Field Number[8]INT5Integer24
19Form_Field_Number_9 SearchForm Field Number[9]INT5Integer24
20Form_Field_Number_10 SearchForm Field Number[10]INT5Integer24
21Form_Field_Number_11 SearchForm Field Number[11]INT5Integer24
22Form_Field_Number_12 SearchForm Field Number[12]INT5Integer24
23Form_Field_Number_13 SearchForm Field Number[13]INT5Integer24
24Form_Field_Number_14 SearchForm Field Number[14]INT5Integer24
25Form_Field_Number_15 SearchForm Field Number[15]INT5Integer24
26Form_Field_Number_16 SearchForm Field Number[16]INT5Integer24
27Form_Field_Number_17 SearchForm Field Number[17]INT5Integer24
28Form_Field_Number_18 SearchForm Field Number[18]INT5Integer24
29Form_Field_Number_19 SearchForm Field Number[19]INT5Integer24
30Form_Field_Number_20 SearchForm Field Number[20]INT5Integer24
31NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Extender Journals'].NOTEINDX AS 'Extender Journals-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       EXT41100 AS ['Extender Journals']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Extender Journals'].NOTEINDX = ['Record Notes Master'].NOTEINDX
32CREATDDT SearchCreated DateDTDate48
33CRUSRID SearchCreated User IDSTR15_User_IDString1615
34MODIFDT SearchModified DateDTDate48
35MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Extender Journals'].MDFUSRID AS 'Extender Journals-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       EXT41100 AS ['Extender Journals']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Extender Journals'].MDFUSRID = ['Users Master'].USERID
36Ext_Date_From SearchExt_Date_FromExtender Date FromInteger20
azurecurveProductsExtender (3107)ProjectExtender Journals (EXT41100)

Leave a Reply

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