Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WS20802
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: WS_GL_Transaction_OPEN
Physical Name: WS20802
Technical Name: WS_GL_Transaction_OPENSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 WS_Job_Number 
WS Job Number STR17_LBAU String 17 2 BACHNUMB Batch Number STR15_LBAU String 15 3 BCHSOURC Batch Source STR15 String 15 4 JRNENTRY Journal Entry LI8_U0 Long Integer 8 5 SQNCLINE Sequence Line DLR19_$S2 Currency 19 6 Product_Indicator Product Indicator DDL_Product_Indicator Integer 0 7 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['WS_GL_Transaction_OPEN'].ACTINDX AS 'WS_GL_Transaction_OPEN-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
WS20802 AS ['WS_GL_Transaction_OPEN']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['WS_GL_Transaction_OPEN'].ACTINDX = ['Account Index Master'].ACTINDX8 Service_Call_ID Service Call ID STR17_LBAU String 17 9 Project_Number WS Project Number STR170 String 17 10 Cost_Code_Number_1 Cost Code Number:CC_Phase STR6_CC_Phase String 6 11 Cost_Code_Number_2 Cost Code Number:CC_Step STR6_CC_Steps String 6 12 Cost_Code_Number_3 Cost Code Number:CC_Detail STR6_CC_Detail String 6 13 Cost_Code_Number_4 Cost Code Number:CC_Component STR6_CC_Component String 6 14 Cost_Code_Description Cost Code Description STR30 String 30 15 Cost_Element Cost Element INT3_RB0_U Integer 3 16 WS_Cost_Code WS Cost Code LI8_U0 Long Integer 8 17 WS_Other_Cost_Sub_Code WS Other Cost Sub Code LI8_U0 Long Integer 8 18 Equipment_ID Equipment ID STR30 String 30 19 CRDTAMNT Credit Amount DLR19_$S2 Currency 19 20 DEBITAMT Debit Amount DLR19_$S2 Currency 19 21 ORCRDAMT Originating Credit Amount DLR19_$S2 Currency 19 22 ORDBTAMT Originating Debit Amount DLR19_$S2 Currency 19 23 DSCRIPTN Description STR30 String 30 24 Profit_Type_Number Profit Type Number INT2 Integer 2 25 Profit_Amount Profit Amount DLR14_TS Currency 14 26 TRXQTY TRX QTY DLR17_QTY_RBS0_STR Currency 17 27 PSTGSTUS Posting Status INT Integer 0 28 GLLINMSG GL LINE Messages ML_GL_LINE_Messages Long Integer 0 29 GLLINMS2 GL LINE Messages2 ML_GL_LINE_Messages2 Long Integer 0 30 GLLINVAL GL Line Valid ML_GL_Line_Valid Long Integer 0 31 ACCTTYPE Account Type DDL_Account_Type Integer 0 32 FXDORVAR Fixed Or Variable LB_Fixed_Or_Variable Integer 0 33 BALFRCLC Balance For Calculation GB Integer 0 34 PSTNGTYP Posting Type GB Integer 0 35 DECPLACS Decimal Places DDL_Decimal_Places Integer 0 36 PORDNMBR Purchase Order Number Purchase Order Number String 20 37 Rate_Per_Unit Rate Per Unit DLR14_TS Currency 14 38 Billing_Amount Billing Amount DLR14_RBS0_STR$ Currency 14 39 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['WS_GL_Transaction_OPEN'].VENDORID AS 'WS_GL_Transaction_OPEN-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
WS20802 AS ['WS_GL_Transaction_OPEN']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['WS_GL_Transaction_OPEN'].VENDORID = ['PM Vendor Master File'].VENDORID40 EMPLOYID Employee ID STR15_Employee_ID String 15 41 ITEMNMBR Item Number STR30_Item_Number String 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['WS_GL_Transaction_OPEN'].ITEMNMBR AS 'WS_GL_Transaction_OPEN-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
WS20802 AS ['WS_GL_Transaction_OPEN']
INNER JOIN
IV00101 AS ['Item Master']
ON
['WS_GL_Transaction_OPEN'].ITEMNMBR = ['Item Master'].ITEMNMBR42 ITEMDESC Item Description STR100 String 100 43 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['WS_GL_Transaction_OPEN'].USERID AS 'WS_GL_Transaction_OPEN-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
WS20802 AS ['WS_GL_Transaction_OPEN']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['WS_GL_Transaction_OPEN'].USERID = ['Users Master'].USERID44 WS_Transaction_Date WS Transaction Date DT Date 8 45 OH_Amount OH Amount DLR14_RBS0_STR$ Currency 14 46 OH_ACTINDX_CR OH Account Index CR LI_14 Long Integer 14 47 OH_ACTINDX_DR OH Account Index DR LI_14 Long Integer 14 48 Divisions Divisions STR15_LBAU String 15 49 TRXHRUNT TRX Hours/Units LI6_S2 Long Integer 6 50 Payroll_Pay_Type Payroll Pay Type INT2_U0 Integer 2 51 PAYRCORD Pay Record STR6_Payroll_Code String 6 52 PAYRATE Pay Rate DLR11_$S2 Currency 14 53 DEPRTMNT Department STR6_Payroll_Code String 6 54 JOBTITLE Job Title STR6_Payroll_Code String 6 55 PAYRTAMT Pay Rate Amount DLR11_$S2 Currency 14 56 UPRTRXCD UPR TRX Code STR6_Payroll_Code String 6 57 UOFM U Of M U_Of_M String 8 58 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['WS_GL_Transaction_OPEN'].CURNCYID AS 'WS_GL_Transaction_OPEN-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
WS20802 AS ['WS_GL_Transaction_OPEN']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['WS_GL_Transaction_OPEN'].CURNCYID = ['Currency Setup'].CURNCYID59 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['WS_GL_Transaction_OPEN'].CURRNIDX AS 'WS_GL_Transaction_OPEN-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
WS20802 AS ['WS_GL_Transaction_OPEN']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['WS_GL_Transaction_OPEN'].CURRNIDX = ['Currency Setup'].CURRNIDX60 RTCLCMTD Rate Calculation Method GB Integer 0 61 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 62 DENXRATE Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 63 INTERID Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['WS_GL_Transaction_OPEN'].INTERID AS 'WS_GL_Transaction_OPEN-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
WS20802 AS ['WS_GL_Transaction_OPEN']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['WS_GL_Transaction_OPEN'].INTERID = ['Company Master'].INTERID64 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['WS_GL_Transaction_OPEN'].RATETPID AS 'WS_GL_Transaction_OPEN-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
WS20802 AS ['WS_GL_Transaction_OPEN']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['WS_GL_Transaction_OPEN'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID65 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['WS_GL_Transaction_OPEN'].EXGTBLID AS 'WS_GL_Transaction_OPEN-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
WS20802 AS ['WS_GL_Transaction_OPEN']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['WS_GL_Transaction_OPEN'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID66 EXCHDATE Exchange Date DT_Date Date 6 67 PONUMBER PO Number STR17_POP_Number String 17 68 TIME1 Time TM6 Time 6 69 Labor_Group_Name Labor Group Name STR15_RM_Customer_Number String 15 70 Pricing_Matrix_Name Pricing Matrix Name STR15_RM_Customer_Number String 15 71 Wennsoft_Affiliate Wennsoft Affiliate STR15_LBAU String 15 72 Wennsoft_Region Wennsoft Region STR15_LBAU String 15 73 Wennsoft_Branch Wennsoft Branch STR15_LBAU String 15 74 MODIFDT Modified Date DT Date 8 75 Modified_Time Modified Time TM6 Time 6 76 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['WS_GL_Transaction_OPEN'].MDFUSRID AS 'WS_GL_Transaction_OPEN-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
WS20802 AS ['WS_GL_Transaction_OPEN']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['WS_GL_Transaction_OPEN'].MDFUSRID = ['Users Master'].USERID77 SV_Language_ID SV Language ID INT2 Integer 2 78 Time_Zone Time Zone STR3 String 3 79 User_Define_1 User Define 1 STR30 String 30 80 User_Define_2 User Define 2 STR30 String 30 81 USERDEF1 User Defined 1 STR20 String 20 82 USERDEF2 User Defined 2 STR20 String 20 83 User_Def_Integer_1 User Defined Integer 1 LI6_S2 Long Integer 6 84 User_Def_Integer_2 User Defined Integer 2 LI6_S2 Long Integer 6 85 User_Defined_Integer_3 User Defined Integer 3 LI6_S2 Long Integer 6 86 User_Defined_Integer_4 User Defined Integer 4 LI6_S2 Long Integer 6 87 User_Defined_Dollar_1 User Defined Dollar 1 DLR14_RBS0_STR$ Currency 14 88 User_Defined_Dollar_2 User Defined Dollar 2 DLR14_RBS0_STR$ Currency 14 89 User_Defined_Dollar_3 User Defined Dollar 3 DLR14_RBS0_STR$ Currency 14 90 User_Defined_Dollar_4 User Defined Dollar 4 DLR14_RBS0_STR$ Currency 14 91 USRDAT01 User Defined Date 1 DT Date 8 92 USRDAT02 User Defined Date 2 DT Date 8 93 USRDAT03 User Defined Date 3 DT Date 8 94 User_Defined_Date2_4 User Defined Date 4 DATE Date 6 95 User_Defined_CB_1 User Defined CB 1 CB Boolean 0 96 User_Defined_CB_2 User Defined CB 2 CB Boolean 0 97 User_Defined_CB_3 User Defined CB 3 CB Boolean 0 98 User_Defined_CB_4 User Defined CB 4 CB Boolean 0 99 WSReserved_CB1 WSReserved CB1 CB Boolean 0 100 WSReserved_CB2 WSReserved CB2 CB Boolean 0 101 WSReserved_CB3 WSReserved CB3 CB Boolean 0 102 WSReserved_CB4 WSReserved CB4 CB Boolean 0 103 WSReserved_CB5 WSReserved CB5 CB Boolean 0 104 WSReserved_STR1 WSReserved STR1 STR10 String 10 105 WSReserved_STR2 WSReserved STR2 STR10 String 10 106 OPENYEAR Open Year INT4_S0 Integer 4