JC_Vendor_MSTR (JC01501)

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

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

Display Name: JC_Vendor_MSTR
Physical Name: JC01501
Technical Name: JC_Vendor_MSTR

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1WS_Job_Number SearchWS Job NumberSTR17_LBAUString17
2Project_Number SearchWS Project NumberSTR170String17
3VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['JC_Vendor_MSTR'].VENDORID AS 'JC_Vendor_MSTR-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       JC01501 AS ['JC_Vendor_MSTR']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['JC_Vendor_MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID
4VENDNAME SearchVendor NameSTR64_Vendor_NameString64
5LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency19
6ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
7Retention_Pct SearchRetention %DLR14_TSCurrency14
8Mod_Rate SearchMod RateINT3_U2Integer3
9PSTGSTUS SearchPosting StatusINTInteger0
10PORDNMBR SearchPurchase Order NumberPurchase Order NumberString20
11Contract_Date SearchContract DateDTDate8
12Vendor_Contract_Type SearchVendor Contract TypeDDLInteger0
13Ins_Cert_on_File SearchInsurance Certificate on FileCBBoolean0
14Ins_Expiration_Date SearchInsurance Expiration DateDTDate8
15Bonded SearchBondedCBBoolean0
16Retention_Withheld_TTD SearchRetention Withheld TTDDLR19_TSCurrency19
17Apply_Doc_Paid_TTD SearchApply Doc Paid TTDDLR19_TSCurrency19
18Orig_Contract_Amount SearchOriginal Contract AmountDLR19_TSCurrency19
19Change_Orders_TTD SearchChange Orders TTDDLR19_TSCurrency19
20Contract_to_Date SearchContract to DateDLR14_TSCurrency14
21Lien_Waiver_on_File SearchLien Waiver on FileCBBoolean0
22Submittals SearchSubmittalsBooleanBoolean0
23Vendor_Invoices_TTD SearchVendor Invoices TTDDLR19_TSCurrency19
24Actual_Units_TTD SearchActual Units TTDDLR14_TSCurrency14
25Submit_Date SearchSubmit DateDTDate8
26Resubmit_Date SearchResubmit DateDTDate8
27Approved_Date SearchApproved DateDTDate8
28Disapproved_Date SearchDisapproved DateDTDate8
29HOLD SearchHoldCB_HoldBoolean0
30WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString6
31Max_Retention_Percent SearchMaximum Retention PercentDLR5_%2Currency8
32Max_Retention_Withhold SearchMaximum Retention To WithholdDLR19_$S2Currency19
33Maximum_Retention_Type SearchMaximum Retention TypeGBInteger0
34JCCIS_Verification_Numb SearchJCCIS Verification NumberSTR14String14
35JC_CheckBox_1 SearchJC CheckBox 1CBBoolean0
36JC_CheckBox_2 SearchJC CheckBox 2CBBoolean0
37JC_CheckBox_3 SearchJC CheckBox 3CBBoolean0
38JC_CheckBox_4 SearchJC CheckBox 4CBBoolean0
39JC_CheckBox_5 SearchJC CheckBox 5CBBoolean0
40JC_CheckBox_6 SearchJC CheckBox 6CBBoolean0
41JC_CheckBox_7 SearchJC CheckBox 7CBBoolean0
42JC_CheckBox_8 SearchJC CheckBox 8CBBoolean0
43JC_CheckBox_9 SearchJC CheckBox 9CBBoolean0
44JC_CheckBox_10 SearchJC CheckBox 10CBBoolean0
45USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Vendor_MSTR'].USERID AS 'JC_Vendor_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC01501 AS ['JC_Vendor_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Vendor_MSTR'].USERID = ['Users Master'].USERID
46User_Define_1 SearchUser Define 1STR30String30
47User_Define_2 SearchUser Define 2STR30String30
48User_Define_3 SearchUser Define 3STR30String30
49User_Define_4 SearchUser Define 4STR30String30
50User_Define_5 SearchUser Define 5STR30String30
51User_Define_6 SearchUser Define 6STR30String30
52USERDEF1 SearchUser Defined 1STR20String20
53USERDEF2 SearchUser Defined 2STR20String20
54User_Defined_CB_1 SearchUser Defined CB 1CBBoolean0
55User_Defined_CB_2 SearchUser Defined CB 2CBBoolean0
56User_Defined_CB_3 SearchUser Defined CB 3CBBoolean0
57User_Defined_CB_4 SearchUser Defined CB 4CBBoolean0
58USRDAT01 SearchUser Defined Date 1DTDate8
59USRDAT02 SearchUser Defined Date 2DTDate8
60User_Defined_Date_3 SearchWS User Defined Date 3DATEDate6
61User_Defined_Date_4 SearchWS User Defined Date 4DATEDate6
62User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency14
63User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency14
64User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency14
65User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency14
66User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer6
67User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer6
68User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer6
69User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer6
70Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
71Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
72Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
73MODIFDT SearchModified DateDTDate8
74Modified_Time SearchModified TimeTM6Time6
75MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Vendor_MSTR'].MDFUSRID AS 'JC_Vendor_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC01501 AS ['JC_Vendor_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Vendor_MSTR'].MDFUSRID = ['Users Master'].USERID
76WSReserved_CB1 SearchWSReserved CB1CBBoolean0
77WSReserved_CB2 SearchWSReserved CB2CBBoolean0
78WSReserved_CB3 SearchWSReserved CB3CBBoolean0
79WSReserved_CB4 SearchWSReserved CB4CBBoolean0
80WSReserved_CB5 SearchWSReserved CB5CBBoolean0
81WSReserved_STR1 SearchWSReserved STR1STR10String10
82WSReserved_STR2 SearchWSReserved STR2STR10String10

Leave a Reply

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