Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WS20801
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: WS_GL_TRX_Header_OPEN
Physical Name: WS20801
Technical Name: WS_GL_TRX_Header_OPENSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BACHNUMB 
Batch Number STR15_LBAU String 15 2 BCHSOURC Batch Source STR15 String 15 3 JRNENTRY Journal Entry LI8_U0 Long Integer 8 4 RCTRXSEQ Recurring TRX Sequence DLR19_$S2 Currency 19 5 SOURCDOC Source Document STR10_Source_Document String 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['WS_GL_TRX_Header_OPEN'].SOURCDOC AS 'WS_GL_TRX_Header_OPEN-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
WS20801 AS ['WS_GL_TRX_Header_OPEN']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['WS_GL_TRX_Header_OPEN'].SOURCDOC = ['Source Document Master'].SOURCDOC6 REFRENCE Reference STR30 String 30 7 TRXDATE TRX Date DT_Date Date 6 8 RVRSNGDT Reversing Date DT_Date Date 6 9 RCRNGTRX Recurring TRX YN Boolean 0 10 BALFRCLC Balance For Calculation GB Integer 0 11 PSTGSTUS Posting Status INT Integer 0 12 LASTUSER Last User User_ID String 15 13 LSTDTEDT Last Date Edited DT_Date Date 6 14 USWHPSTD User Who Posted User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['WS_GL_TRX_Header_OPEN'].USWHPSTD AS 'WS_GL_TRX_Header_OPEN-User Who Posted'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
WS20801 AS ['WS_GL_TRX_Header_OPEN']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['WS_GL_TRX_Header_OPEN'].USWHPSTD = ['Users Master'].USERID15 TRXTYPE Transaction Type GB Integer 0 16 SQNCLINE Sequence Line DLR19_$S2 Currency 19 17 GLHDRMSG GL HDR Messages ML_GL_HDR_Messages Long Integer 0 18 GLHDRMS2 GL HDR Messages2 ML_GL_HDR_Messages_2 Long Integer 0 19 TRXSORCE TRX Source STR13 String 13 20 SERIES Series DDL_Series Integer 0 21 ORTRXTYP Originating TRX Type INT Integer 0 22 ORCTRNUM Originating Control Number STR20 String 20 23 ORMSTRID Originating Master ID STR30 String 30 24 ORMSTRNM Originating Master Name STR64 String 64 25 ORDOCNUM Originating Document Number STR20 String 20 26 ORPSTDDT Originating Posted Date DT_Date Date 6 27 ORTRXSRC Originating TRX Source STR13 String 13 28 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['WS_GL_TRX_Header_OPEN'].CURNCYID AS 'WS_GL_TRX_Header_OPEN-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
WS20801 AS ['WS_GL_TRX_Header_OPEN']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['WS_GL_TRX_Header_OPEN'].CURNCYID = ['Currency Setup'].CURNCYID29 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['WS_GL_TRX_Header_OPEN'].NOTEINDX AS 'WS_GL_TRX_Header_OPEN-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
WS20801 AS ['WS_GL_TRX_Header_OPEN']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['WS_GL_TRX_Header_OPEN'].NOTEINDX = ['Record Notes Master'].NOTEINDX30 GLHDRVAL GL Header Valid ML_GL_Header_Valid Long Integer 0 31 PERIODID Period ID INT3 Integer 3 32 OPENYEAR Open Year INT4_S0 Integer 4 33 CLOSEDYR Closed Year INT4_S0 Integer 4 34 HISTRX History TRX Boolean Boolean 0 35 REVPRDID Reversing Period ID INT3 Integer 3 36 REVYEAR Reversing Year INT4_S0 Integer 4 37 REVCLYR Reversing Closed Year INT4_S0 Integer 4 38 REVHIST Reversing History TRX Boolean Boolean 0 39 ICTRX IC TRX CB_IC_TRX Boolean 0 Click to show/hide Intercompany flag
0 Not intercompany.
1 Intercompany40 ERRSTATE Error State Long Int Long Integer 8 41 User_Define_1 User Define 1 STR30 String 30 42 User_Define_2 User Define 2 STR30 String 30 43 USERDEF1 User Defined 1 STR20 String 20 44 USERDEF2 User Defined 2 STR20 String 20 45 User_Def_Integer_1 User Defined Integer 1 LI6_S2 Long Integer 6 46 User_Def_Integer_2 User Defined Integer 2 LI6_S2 Long Integer 6 47 User_Defined_Integer_3 User Defined Integer 3 LI6_S2 Long Integer 6 48 User_Defined_Integer_4 User Defined Integer 4 LI6_S2 Long Integer 6 49 User_Defined_Dollar_1 User Defined Dollar 1 DLR14_RBS0_STR$ Currency 14 50 User_Defined_Dollar_2 User Defined Dollar 2 DLR14_RBS0_STR$ Currency 14 51 User_Defined_Dollar_3 User Defined Dollar 3 DLR14_RBS0_STR$ Currency 14 52 User_Defined_Dollar_4 User Defined Dollar 4 DLR14_RBS0_STR$ Currency 14 53 USRDAT01 User Defined Date 1 DT Date 8 54 USRDAT02 User Defined Date 2 DT Date 8 55 USRDAT03 User Defined Date 3 DT Date 8 56 User_Defined_Date2_4 User Defined Date 4 DATE Date 6 57 User_Defined_CB_1 User Defined CB 1 CB Boolean 0 58 User_Defined_CB_2 User Defined CB 2 CB Boolean 0 59 User_Defined_CB_3 User Defined CB 3 CB Boolean 0 60 User_Defined_CB_4 User Defined CB 4 CB Boolean 0 61 WSReserved_CB1 WSReserved CB1 CB Boolean 0 62 WSReserved_CB2 WSReserved CB2 CB Boolean 0 63 WSReserved_CB3 WSReserved CB3 CB Boolean 0 64 WSReserved_CB4 WSReserved CB4 CB Boolean 0 65 WSReserved_CB5 WSReserved CB5 CB Boolean 0