JC Vendor TRX OPEN (JC20004)

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

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

Display Name: JC Vendor TRX OPEN
Physical Name: JC20004
Technical Name: JC_Vendor_TRX_OPEN

Group Display Name: Job Cost
Group Technical Name: Job Cost

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['JC Vendor TRX OPEN'].VENDORID AS 'JC Vendor TRX OPEN-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       JC20004 AS ['JC Vendor TRX OPEN']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['JC Vendor TRX OPEN'].VENDORID = ['PM Vendor Master File'].VENDORID
2WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
3Job_TRX_Number SearchJob TRX NumberSTR20String2220
4LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency1019
5CNTRLTYP SearchControl TypeINT1Integer21
6BACHNUMB SearchBatch NumberSTR15_LBAUString1615
7BCHSOURC SearchBatch SourceSTR15String1615
8PORDNMBR SearchPurchase Order NumberPurchase Order NumberString2220
9DOCDATE SearchDocument DateDTDate48
10PSTGDATE SearchPosting DateDTDate48
11DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
12CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['JC Vendor TRX OPEN'].CURNCYID AS 'JC Vendor TRX OPEN-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       JC20004 AS ['JC Vendor TRX OPEN']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['JC Vendor TRX OPEN'].CURNCYID = ['Currency Setup'].CURNCYID
13CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['JC Vendor TRX OPEN'].CURRNIDX AS 'JC Vendor TRX OPEN-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       JC20004 AS ['JC Vendor TRX OPEN']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['JC Vendor TRX OPEN'].CURRNIDX = ['Currency Setup'].CURRNIDX
14HOLD SearchHoldCB_HoldBoolean20
15VOIDED SearchVoidedCBBoolean20
16Voucher_Created SearchVoucher CreatedBooleanBoolean20
17Original_Document_Amount SearchOriginal Document AmountDLR19_TSCurrency1019
18DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency1019
19Retention_Withheld SearchRetention WithheldDLR14_TSCurrency1014
20Apply_Doc_Paid_Amount SearchApply Doc Paid AmountDLR19_TSCurrency1019
21Retention_Apply SearchRetention ApplyDLR19_TSCurrency1019
22Retention_Invoiced SearchRetention InvoicedDLR19_TSCurrency1019
23Retention_Pct SearchRetention %DLR14_TSCurrency1014
24TRXQTY SearchTRX QTYDLR17_QTY_RBS0_STRCurrency1017
25Document_Source SearchDocument SourceSTR3String43
26Date_Paid SearchDate PaidDTDate48
27Remaining_Amount SearchRemaining AmountDLR19_TSCurrency1019
28PMNTNMBR SearchPayment NumberSTR20_LBAUString2220
29TRXSORCE SearchTRX SourceSTR13String1413
30OrgOrgnlDocAmt SearchOriginating Original Document AmountDLR17_RBS0_STR$Currency1017
31ORDOCAMT SearchOriginating Document AmountDLR17_RBS0_STR$Currency1017
32Org_Retention_Withheld SearchOriginating Retention WithheldDLR19_TSCurrency1019
33Org_Retention_Apply SearchOriginating Retention ApplyDLR19_TSCurrency1019
34Org_Retention_Invoiced SearchOriginating Retention InvoicedDLR19_TSCurrency1019
35USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC Vendor TRX OPEN'].USERID AS 'JC Vendor TRX OPEN-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC20004 AS ['JC Vendor TRX OPEN']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC Vendor TRX OPEN'].USERID = ['Users Master'].USERID
36User_Define_1 SearchUser Define 1STR30String3230
37User_Define_2 SearchUser Define 2STR30String3230
38USERDEF1 SearchUser Defined 1STR20String2220
39USERDEF2 SearchUser Defined 2STR20String2220
40User_Defined_CB_1 SearchUser Defined CB 1CBBoolean20
41User_Defined_CB_2 SearchUser Defined CB 2CBBoolean20
42User_Defined_CB_3 SearchUser Defined CB 3CBBoolean20
43User_Defined_CB_4 SearchUser Defined CB 4CBBoolean20
44USRDAT01 SearchUser Defined Date 1DTDate48
45USRDAT02 SearchUser Defined Date 2DTDate48
46User_Defined_Date_3 SearchWS User Defined Date 3DATEDate46
47User_Defined_Date_4 SearchWS User Defined Date 4DATEDate46
48User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency1014
49User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency1014
50User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency1014
51User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency1014
52User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer46
53User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer46
54User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer46
55User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer46
56MODIFDT SearchModified DateDTDate48
57Modified_Time SearchModified TimeTM6Time46
58MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC Vendor TRX OPEN'].MDFUSRID AS 'JC Vendor TRX OPEN-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC20004 AS ['JC Vendor TRX OPEN']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC Vendor TRX OPEN'].MDFUSRID = ['Users Master'].USERID
59SV_Language_ID SearchSV Language IDINT2Integer22
60Time_Zone SearchTime ZoneSTR3String43
61Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
62Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
63Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
64WSReserved_CB1 SearchWSReserved CB1CBBoolean20
65WSReserved_CB2 SearchWSReserved CB2CBBoolean20
66WSReserved_CB3 SearchWSReserved CB3CBBoolean20
67WSReserved_CB4 SearchWSReserved CB4CBBoolean20
68WSReserved_CB5 SearchWSReserved CB5CBBoolean20
69WSReserved_STR1 SearchWSReserved STR1STR10String1210
70WSReserved_STR2 SearchWSReserved STR2STR10String1210

Leave a Reply

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