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 TypeLength
1VENDORID SearchVendor IDSTR_15_Vendor_IDString15
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_LBAUString17
3Job_TRX_Number SearchJob TRX NumberSTR20String20
4LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency19
5CNTRLTYP SearchControl TypeINT1Integer1
6BACHNUMB SearchBatch NumberSTR15_LBAUString15
7BCHSOURC SearchBatch SourceSTR15String15
8PORDNMBR SearchPurchase Order NumberPurchase Order NumberString20
9DOCDATE SearchDocument DateDTDate8
10PSTGDATE SearchPosting DateDTDate8
11DOCNUMBR SearchDocument NumberSTR20_Document_NumberString20
12CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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 IndexINT3Integer3
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_HoldBoolean0
15VOIDED SearchVoidedCBBoolean0
16Voucher_Created SearchVoucher CreatedBooleanBoolean0
17Original_Document_Amount SearchOriginal Document AmountDLR19_TSCurrency19
18DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency19
19Retention_Withheld SearchRetention WithheldDLR14_TSCurrency14
20Apply_Doc_Paid_Amount SearchApply Doc Paid AmountDLR19_TSCurrency19
21Retention_Apply SearchRetention ApplyDLR19_TSCurrency19
22Retention_Invoiced SearchRetention InvoicedDLR19_TSCurrency19
23Retention_Pct SearchRetention %DLR14_TSCurrency14
24TRXQTY SearchTRX QTYDLR17_QTY_RBS0_STRCurrency17
25Document_Source SearchDocument SourceSTR3String3
26Date_Paid SearchDate PaidDTDate8
27Remaining_Amount SearchRemaining AmountDLR19_TSCurrency19
28PMNTNMBR SearchPayment NumberSTR20_LBAUString20
29TRXSORCE SearchTRX SourceSTR13String13
30OrgOrgnlDocAmt SearchOriginating Original Document AmountDLR17_RBS0_STR$Currency17
31ORDOCAMT SearchOriginating Document AmountDLR17_RBS0_STR$Currency17
32Org_Retention_Withheld SearchOriginating Retention WithheldDLR19_TSCurrency19
33Org_Retention_Apply SearchOriginating Retention ApplyDLR19_TSCurrency19
34Org_Retention_Invoiced SearchOriginating Retention InvoicedDLR19_TSCurrency19
35USERID SearchUser IDSTR15_User_IDString15
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 1STR30String30
37User_Define_2 SearchUser Define 2STR30String30
38USERDEF1 SearchUser Defined 1STR20String20
39USERDEF2 SearchUser Defined 2STR20String20
40User_Defined_CB_1 SearchUser Defined CB 1CBBoolean0
41User_Defined_CB_2 SearchUser Defined CB 2CBBoolean0
42User_Defined_CB_3 SearchUser Defined CB 3CBBoolean0
43User_Defined_CB_4 SearchUser Defined CB 4CBBoolean0
44USRDAT01 SearchUser Defined Date 1DTDate8
45USRDAT02 SearchUser Defined Date 2DTDate8
46User_Defined_Date_3 SearchWS User Defined Date 3DATEDate6
47User_Defined_Date_4 SearchWS User Defined Date 4DATEDate6
48User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency14
49User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency14
50User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency14
51User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency14
52User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer6
53User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer6
54User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer6
55User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer6
56MODIFDT SearchModified DateDTDate8
57Modified_Time SearchModified TimeTM6Time6
58MDFUSRID SearchModified User IDSTR15String15
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 IDINT2Integer2
60Time_Zone SearchTime ZoneSTR3String3
61Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
62Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
63Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
64WSReserved_CB1 SearchWSReserved CB1CBBoolean0
65WSReserved_CB2 SearchWSReserved CB2CBBoolean0
66WSReserved_CB3 SearchWSReserved CB3CBBoolean0
67WSReserved_CB4 SearchWSReserved CB4CBBoolean0
68WSReserved_CB5 SearchWSReserved CB5CBBoolean0
69WSReserved_STR1 SearchWSReserved STR1STR10String10
70WSReserved_STR2 SearchWSReserved STR2STR10String10

Leave a Reply

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