WS_GL_Transaction_WORK (WS10802)

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

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: WS_GL_Transaction_WORK
Physical Name: WS10802
Technical Name: WS_GL_Transaction_WORK

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
2BACHNUMB SearchBatch NumberSTR15_LBAUString1615
3BCHSOURC SearchBatch SourceSTR15String1615
4JRNENTRY SearchJournal EntryLI8_U0Long Integer48
5SQNCLINE SearchSequence LineDLR19_$S2Currency1019
6Product_Indicator SearchProduct IndicatorDDL_Product_IndicatorInteger20
7ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['WS_GL_Transaction_WORK'].ACTINDX AS 'WS_GL_Transaction_WORK-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       WS10802 AS ['WS_GL_Transaction_WORK']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['WS_GL_Transaction_WORK'].ACTINDX = ['Account Index Master'].ACTINDX
8Service_Call_ID SearchService Call IDSTR17_LBAUString1817
9Project_Number SearchWS Project NumberSTR170String1817
10Cost_Code_Number_1 SearchCost Code Number:CC_PhaseSTR6_CC_PhaseString86
11Cost_Code_Number_2 SearchCost Code Number:CC_StepSTR6_CC_StepsString86
12Cost_Code_Number_3 SearchCost Code Number:CC_DetailSTR6_CC_DetailString86
13Cost_Code_Number_4 SearchCost Code Number:CC_ComponentSTR6_CC_ComponentString86
14Cost_Code_Description SearchCost Code DescriptionSTR30String3230
15Cost_Element SearchCost ElementINT3_RB0_UInteger23
16WS_Cost_Code SearchWS Cost CodeLI8_U0Long Integer48
17WS_Other_Cost_Sub_Code SearchWS Other Cost Sub CodeLI8_U0Long Integer48
18Equipment_ID SearchEquipment IDSTR30String3230
19CRDTAMNT SearchCredit AmountDLR19_$S2Currency1019
20DEBITAMT SearchDebit AmountDLR19_$S2Currency1019
21ORCRDAMT SearchOriginating Credit AmountDLR19_$S2Currency1019
22ORDBTAMT SearchOriginating Debit AmountDLR19_$S2Currency1019
23DSCRIPTN SearchDescriptionSTR30String3230
24Profit_Type_Number SearchProfit Type NumberINT2Integer22
25Profit_Amount SearchProfit AmountDLR14_TSCurrency1014
26TRXQTY SearchTRX QTYDLR17_QTY_RBS0_STRCurrency1017
27PSTGSTUS SearchPosting StatusINTInteger20
28GLLINMSG SearchGL LINE MessagesML_GL_LINE_MessagesLong Integer40
29GLLINMS2 SearchGL LINE Messages2ML_GL_LINE_Messages2Long Integer40
30GLLINVAL SearchGL Line ValidML_GL_Line_ValidLong Integer40
31ACCTTYPE SearchAccount TypeDDL_Account_TypeInteger20
32FXDORVAR SearchFixed Or VariableLB_Fixed_Or_VariableInteger20
33BALFRCLC SearchBalance For CalculationGBInteger20
34PSTNGTYP SearchPosting TypeGBInteger20
35DECPLACS SearchDecimal PlacesDDL_Decimal_PlacesInteger20
36PORDNMBR SearchPurchase Order NumberPurchase Order NumberString2220
37Rate_Per_Unit SearchRate Per UnitDLR14_TSCurrency1014
38Billing_Amount SearchBilling AmountDLR14_RBS0_STR$Currency1014
39VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['WS_GL_Transaction_WORK'].VENDORID AS 'WS_GL_Transaction_WORK-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       WS10802 AS ['WS_GL_Transaction_WORK']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['WS_GL_Transaction_WORK'].VENDORID = ['PM Vendor Master File'].VENDORID
40EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
41ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['WS_GL_Transaction_WORK'].ITEMNMBR AS 'WS_GL_Transaction_WORK-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       WS10802 AS ['WS_GL_Transaction_WORK']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['WS_GL_Transaction_WORK'].ITEMNMBR = ['Item Master'].ITEMNMBR
42ITEMDESC SearchItem DescriptionSTR100String102100
43USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['WS_GL_Transaction_WORK'].USERID AS 'WS_GL_Transaction_WORK-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       WS10802 AS ['WS_GL_Transaction_WORK']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['WS_GL_Transaction_WORK'].USERID = ['Users Master'].USERID
44WS_Transaction_Date SearchWS Transaction DateDTDate48
45OH_Amount SearchOH AmountDLR14_RBS0_STR$Currency1014
46OH_ACTINDX_CR SearchOH Account Index CRLI_14Long Integer414
47OH_ACTINDX_DR SearchOH Account Index DRLI_14Long Integer414
48Divisions SearchDivisionsSTR15_LBAUString1615
49TRXHRUNT SearchTRX Hours/UnitsLI6_S2Long Integer46
50Payroll_Pay_Type SearchPayroll Pay TypeINT2_U0Integer22
51PAYRCORD SearchPay RecordSTR6_Payroll_CodeString86
52PAYRATE SearchPay RateDLR11_$S2Currency1014
53DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString86
54JOBTITLE SearchJob TitleSTR6_Payroll_CodeString86
55PAYRTAMT SearchPay Rate AmountDLR11_$S2Currency1014
56UPRTRXCD SearchUPR TRX CodeSTR6_Payroll_CodeString86
57UOFM SearchU Of MU_Of_MString108
58CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['WS_GL_Transaction_WORK'].CURNCYID AS 'WS_GL_Transaction_WORK-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       WS10802 AS ['WS_GL_Transaction_WORK']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['WS_GL_Transaction_WORK'].CURNCYID = ['Currency Setup'].CURNCYID
59CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['WS_GL_Transaction_WORK'].CURRNIDX AS 'WS_GL_Transaction_WORK-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       WS10802 AS ['WS_GL_Transaction_WORK']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['WS_GL_Transaction_WORK'].CURRNIDX = ['Currency Setup'].CURRNIDX
60RTCLCMTD SearchRate Calculation MethodGBInteger20
61XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
62DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
63INTERID SearchIntercompany IDSTR5_IC_IDString65
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['WS_GL_Transaction_WORK'].INTERID AS 'WS_GL_Transaction_WORK-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       WS10802 AS ['WS_GL_Transaction_WORK']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['WS_GL_Transaction_WORK'].INTERID = ['Company Master'].INTERID
64RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['WS_GL_Transaction_WORK'].RATETPID AS 'WS_GL_Transaction_WORK-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       WS10802 AS ['WS_GL_Transaction_WORK']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['WS_GL_Transaction_WORK'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
65EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['WS_GL_Transaction_WORK'].EXGTBLID AS 'WS_GL_Transaction_WORK-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       WS10802 AS ['WS_GL_Transaction_WORK']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['WS_GL_Transaction_WORK'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
66EXCHDATE SearchExchange DateDT_DateDate46
67PONUMBER SearchPO NumberSTR17_POP_NumberString1817
68TIME1 SearchTimeTM6Time46
69Labor_Group_Name SearchLabor Group NameSTR15_RM_Customer_NumberString1615
70Pricing_Matrix_Name SearchPricing Matrix NameSTR15_RM_Customer_NumberString1615
71Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
72Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
73Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
74MODIFDT SearchModified DateDTDate48
75Modified_Time SearchModified TimeTM6Time46
76MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['WS_GL_Transaction_WORK'].MDFUSRID AS 'WS_GL_Transaction_WORK-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       WS10802 AS ['WS_GL_Transaction_WORK']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['WS_GL_Transaction_WORK'].MDFUSRID = ['Users Master'].USERID
77SV_Language_ID SearchSV Language IDINT2Integer22
78Time_Zone SearchTime ZoneSTR3String43
79User_Define_1 SearchUser Define 1STR30String3230
80User_Define_2 SearchUser Define 2STR30String3230
81USERDEF1 SearchUser Defined 1STR20String2220
82USERDEF2 SearchUser Defined 2STR20String2220
83User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer46
84User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer46
85User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer46
86User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer46
87User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency1014
88User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency1014
89User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency1014
90User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency1014
91USRDAT01 SearchUser Defined Date 1DTDate48
92USRDAT02 SearchUser Defined Date 2DTDate48
93USRDAT03 SearchUser Defined Date 3DTDate48
94User_Defined_Date2_4 SearchUser Defined Date 4DATEDate46
95User_Defined_CB_1 SearchUser Defined CB 1CBBoolean20
96User_Defined_CB_2 SearchUser Defined CB 2CBBoolean20
97User_Defined_CB_3 SearchUser Defined CB 3CBBoolean20
98User_Defined_CB_4 SearchUser Defined CB 4CBBoolean20
99WSReserved_CB1 SearchWSReserved CB1CBBoolean20
100WSReserved_CB2 SearchWSReserved CB2CBBoolean20
101WSReserved_CB3 SearchWSReserved CB3CBBoolean20
102WSReserved_CB4 SearchWSReserved CB4CBBoolean20
103WSReserved_CB5 SearchWSReserved CB5CBBoolean20
104WSReserved_STR1 SearchWSReserved STR1STR10String1210
105WSReserved_STR2 SearchWSReserved STR2STR10String1210

Leave a Reply

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