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_JournalsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PT_Journal_ID 
PT Journal ID STR15_LBAU String 15 2 PT_Journal_Description PT Journal Description STR64 String 64 3 Extender_Type Extender Type INT5 Integer 4 4 Extender_Form_ID Extender Form ID STR15_LBAU String 15 5 PT_Transaction_Type PT Transaction Type PT Transaction Type Integer 0 6 SOURCDOC Source Document STR10_Source_Document String 10 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'].SOURCDOC7 Ext_Inv_Batch_From Ext_Inv_Batch_From Extender Invoice Batch From Integer 0 8 Ext_Reference_From Ext_Reference_From Extender Reference From Integer 0 9 BACHNUMB Batch Number STR15_LBAU String 15 10 REFRENCE Reference STR30 String 30 11 Form_Field_Number_1 Form Field Number[1] INT5 Integer 4 12 Form_Field_Number_2 Form Field Number[2] INT5 Integer 4 13 Form_Field_Number_3 Form Field Number[3] INT5 Integer 4 14 Form_Field_Number_4 Form Field Number[4] INT5 Integer 4 15 Form_Field_Number_5 Form Field Number[5] INT5 Integer 4 16 Form_Field_Number_6 Form Field Number[6] INT5 Integer 4 17 Form_Field_Number_7 Form Field Number[7] INT5 Integer 4 18 Form_Field_Number_8 Form Field Number[8] INT5 Integer 4 19 Form_Field_Number_9 Form Field Number[9] INT5 Integer 4 20 Form_Field_Number_10 Form Field Number[10] INT5 Integer 4 21 Form_Field_Number_11 Form Field Number[11] INT5 Integer 4 22 Form_Field_Number_12 Form Field Number[12] INT5 Integer 4 23 Form_Field_Number_13 Form Field Number[13] INT5 Integer 4 24 Form_Field_Number_14 Form Field Number[14] INT5 Integer 4 25 Form_Field_Number_15 Form Field Number[15] INT5 Integer 4 26 Form_Field_Number_16 Form Field Number[16] INT5 Integer 4 27 Form_Field_Number_17 Form Field Number[17] INT5 Integer 4 28 Form_Field_Number_18 Form Field Number[18] INT5 Integer 4 29 Form_Field_Number_19 Form Field Number[19] INT5 Integer 4 30 Form_Field_Number_20 Form Field Number[20] INT5 Integer 4 31 NOTEINDX Note Index DLR14 Currency 14 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'].NOTEINDX32 CREATDDT Created Date DT Date 8 33 CRUSRID Created User ID STR15_User_ID String 15 34 MODIFDT Modified Date DT Date 8 35 MDFUSRID Modified User ID STR15 String 15 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'].USERID36 Ext_Date_From Ext_Date_From Extender Date From Integer 0