WS_GL_Transaction_OPEN (WS20802)

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_OPEN

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1WS_Job_Number SearchWS Job NumberSTR17_LBAUString17
2BACHNUMB SearchBatch NumberSTR15_LBAUString15
3BCHSOURC SearchBatch SourceSTR15String15
4JRNENTRY SearchJournal EntryLI8_U0Long Integer8
5SQNCLINE SearchSequence LineDLR19_$S2Currency19
6Product_Indicator SearchProduct IndicatorDDL_Product_IndicatorInteger0
7ACTINDX SearchAccount IndexLI_14Long Integer14
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'].ACTINDX
8Service_Call_ID SearchService Call IDSTR17_LBAUString17
9Project_Number SearchWS Project NumberSTR170String17
10Cost_Code_Number_1 SearchCost Code Number:CC_PhaseSTR6_CC_PhaseString6
11Cost_Code_Number_2 SearchCost Code Number:CC_StepSTR6_CC_StepsString6
12Cost_Code_Number_3 SearchCost Code Number:CC_DetailSTR6_CC_DetailString6
13Cost_Code_Number_4 SearchCost Code Number:CC_ComponentSTR6_CC_ComponentString6
14Cost_Code_Description SearchCost Code DescriptionSTR30String30
15Cost_Element SearchCost ElementINT3_RB0_UInteger3
16WS_Cost_Code SearchWS Cost CodeLI8_U0Long Integer8
17WS_Other_Cost_Sub_Code SearchWS Other Cost Sub CodeLI8_U0Long Integer8
18Equipment_ID SearchEquipment IDSTR30String30
19CRDTAMNT SearchCredit AmountDLR19_$S2Currency19
20DEBITAMT SearchDebit AmountDLR19_$S2Currency19
21ORCRDAMT SearchOriginating Credit AmountDLR19_$S2Currency19
22ORDBTAMT SearchOriginating Debit AmountDLR19_$S2Currency19
23DSCRIPTN SearchDescriptionSTR30String30
24Profit_Type_Number SearchProfit Type NumberINT2Integer2
25Profit_Amount SearchProfit AmountDLR14_TSCurrency14
26TRXQTY SearchTRX QTYDLR17_QTY_RBS0_STRCurrency17
27PSTGSTUS SearchPosting StatusINTInteger0
28GLLINMSG SearchGL LINE MessagesML_GL_LINE_MessagesLong Integer0
29GLLINMS2 SearchGL LINE Messages2ML_GL_LINE_Messages2Long Integer0
30GLLINVAL SearchGL Line ValidML_GL_Line_ValidLong Integer0
31ACCTTYPE SearchAccount TypeDDL_Account_TypeInteger0
32FXDORVAR SearchFixed Or VariableLB_Fixed_Or_VariableInteger0
33BALFRCLC SearchBalance For CalculationGBInteger0
34PSTNGTYP SearchPosting TypeGBInteger0
35DECPLACS SearchDecimal PlacesDDL_Decimal_PlacesInteger0
36PORDNMBR SearchPurchase Order NumberPurchase Order NumberString20
37Rate_Per_Unit SearchRate Per UnitDLR14_TSCurrency14
38Billing_Amount SearchBilling AmountDLR14_RBS0_STR$Currency14
39VENDORID SearchVendor IDSTR_15_Vendor_IDString15
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'].VENDORID
40EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
41ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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'].ITEMNMBR
42ITEMDESC SearchItem DescriptionSTR100String100
43USERID SearchUser IDSTR15_User_IDString15
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'].USERID
44WS_Transaction_Date SearchWS Transaction DateDTDate8
45OH_Amount SearchOH AmountDLR14_RBS0_STR$Currency14
46OH_ACTINDX_CR SearchOH Account Index CRLI_14Long Integer14
47OH_ACTINDX_DR SearchOH Account Index DRLI_14Long Integer14
48Divisions SearchDivisionsSTR15_LBAUString15
49TRXHRUNT SearchTRX Hours/UnitsLI6_S2Long Integer6
50Payroll_Pay_Type SearchPayroll Pay TypeINT2_U0Integer2
51PAYRCORD SearchPay RecordSTR6_Payroll_CodeString6
52PAYRATE SearchPay RateDLR11_$S2Currency14
53DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString6
54JOBTITLE SearchJob TitleSTR6_Payroll_CodeString6
55PAYRTAMT SearchPay Rate AmountDLR11_$S2Currency14
56UPRTRXCD SearchUPR TRX CodeSTR6_Payroll_CodeString6
57UOFM SearchU Of MU_Of_MString8
58CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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'].CURNCYID
59CURRNIDX SearchCurrency IndexINT3Integer3
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'].CURRNIDX
60RTCLCMTD SearchRate Calculation MethodGBInteger0
61XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
62DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
63INTERID SearchIntercompany IDSTR5_IC_IDString5
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'].INTERID
64RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
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'].RATETPID
65EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString15
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'].EXGTBLID
66EXCHDATE SearchExchange DateDT_DateDate6
67PONUMBER SearchPO NumberSTR17_POP_NumberString17
68TIME1 SearchTimeTM6Time6
69Labor_Group_Name SearchLabor Group NameSTR15_RM_Customer_NumberString15
70Pricing_Matrix_Name SearchPricing Matrix NameSTR15_RM_Customer_NumberString15
71Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
72Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
73Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
74MODIFDT SearchModified DateDTDate8
75Modified_Time SearchModified TimeTM6Time6
76MDFUSRID SearchModified User IDSTR15String15
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'].USERID
77SV_Language_ID SearchSV Language IDINT2Integer2
78Time_Zone SearchTime ZoneSTR3String3
79User_Define_1 SearchUser Define 1STR30String30
80User_Define_2 SearchUser Define 2STR30String30
81USERDEF1 SearchUser Defined 1STR20String20
82USERDEF2 SearchUser Defined 2STR20String20
83User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer6
84User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer6
85User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer6
86User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer6
87User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency14
88User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency14
89User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency14
90User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency14
91USRDAT01 SearchUser Defined Date 1DTDate8
92USRDAT02 SearchUser Defined Date 2DTDate8
93USRDAT03 SearchUser Defined Date 3DTDate8
94User_Defined_Date2_4 SearchUser Defined Date 4DATEDate6
95User_Defined_CB_1 SearchUser Defined CB 1CBBoolean0
96User_Defined_CB_2 SearchUser Defined CB 2CBBoolean0
97User_Defined_CB_3 SearchUser Defined CB 3CBBoolean0
98User_Defined_CB_4 SearchUser Defined CB 4CBBoolean0
99WSReserved_CB1 SearchWSReserved CB1CBBoolean0
100WSReserved_CB2 SearchWSReserved CB2CBBoolean0
101WSReserved_CB3 SearchWSReserved CB3CBBoolean0
102WSReserved_CB4 SearchWSReserved CB4CBBoolean0
103WSReserved_CB5 SearchWSReserved CB5CBBoolean0
104WSReserved_STR1 SearchWSReserved STR1STR10String10
105WSReserved_STR2 SearchWSReserved STR2STR10String10
106OPENYEAR SearchOpen YearINT4_S0Integer4

Leave a Reply

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