JC_Master_Subcontractor_MSTR (JC01511)

azurecurveProductsWennSoft Products (131)3rd PartyJC_Master_Subcontractor_MSTR (JC01511)

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

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

Display Name: JC_Master_Subcontractor_MSTR
Physical Name: JC01511
Technical Name: JC_Master_Subcontractor_MSTR

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
2Project_Number SearchWS Project NumberSTR170String1817
3VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['JC_Master_Subcontractor_MSTR'].VENDORID AS 'JC_Master_Subcontractor_MSTR-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       JC01511 AS ['JC_Master_Subcontractor_MSTR']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['JC_Master_Subcontractor_MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID
4VENDNAME SearchVendor NameSTR64_Vendor_NameString6664
5LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency1019
6ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
7Retention_Pct SearchRetention %DLR14_TSCurrency1014
8Mod_Rate SearchMod RateINT3_U2Integer23
9PSTGSTUS SearchPosting StatusINTInteger20
10PORDNMBR SearchPurchase Order NumberPurchase Order NumberString2220
11Contract_Date SearchContract DateDTDate48
12Vendor_Contract_Type SearchVendor Contract TypeDDLInteger20
13Ins_Cert_on_File SearchInsurance Certificate on FileCBBoolean20
14Ins_Expiration_Date SearchInsurance Expiration DateDTDate48
15Bonded SearchBondedCBBoolean20
16Retention_Withheld_TTD SearchRetention Withheld TTDDLR19_TSCurrency1019
17Apply_Doc_Paid_TTD SearchApply Doc Paid TTDDLR19_TSCurrency1019
18Orig_Contract_Amount SearchOriginal Contract AmountDLR19_TSCurrency1019
19Change_Orders_TTD SearchChange Orders TTDDLR19_TSCurrency1019
20Contract_to_Date SearchContract to DateDLR14_TSCurrency1014
21Lien_Waiver_on_File SearchLien Waiver on FileCBBoolean20
22Submittals SearchSubmittalsBooleanBoolean20
23Vendor_Invoices_TTD SearchVendor Invoices TTDDLR19_TSCurrency1019
24Actual_Units_TTD SearchActual Units TTDDLR14_TSCurrency1014
25Submit_Date SearchSubmit DateDTDate48
26Resubmit_Date SearchResubmit DateDTDate48
27Approved_Date SearchApproved DateDTDate48
28Disapproved_Date SearchDisapproved DateDTDate48
29HOLD SearchHoldCB_HoldBoolean20
30WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString86
31Max_Retention_Percent SearchMaximum Retention PercentDLR5_%2Currency108
32Max_Retention_Withhold SearchMaximum Retention To WithholdDLR19_$S2Currency1019
33Maximum_Retention_Type SearchMaximum Retention TypeGBInteger20
34JCCIS_Verification_Numb SearchJCCIS Verification NumberSTR14String1614
35JC_CheckBox_1 SearchJC CheckBox 1CBBoolean20
36JC_CheckBox_2 SearchJC CheckBox 2CBBoolean20
37JC_CheckBox_3 SearchJC CheckBox 3CBBoolean20
38JC_CheckBox_4 SearchJC CheckBox 4CBBoolean20
39JC_CheckBox_5 SearchJC CheckBox 5CBBoolean20
40JC_CheckBox_6 SearchJC CheckBox 6CBBoolean20
41JC_CheckBox_7 SearchJC CheckBox 7CBBoolean20
42JC_CheckBox_8 SearchJC CheckBox 8CBBoolean20
43JC_CheckBox_9 SearchJC CheckBox 9CBBoolean20
44JC_CheckBox_10 SearchJC CheckBox 10CBBoolean20
45USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Master_Subcontractor_MSTR'].USERID AS 'JC_Master_Subcontractor_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC01511 AS ['JC_Master_Subcontractor_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Master_Subcontractor_MSTR'].USERID = ['Users Master'].USERID
46User_Define_1 SearchUser Define 1STR30String3230
47User_Define_2 SearchUser Define 2STR30String3230
48User_Define_3 SearchUser Define 3STR30String3230
49User_Define_4 SearchUser Define 4STR30String3230
50User_Define_5 SearchUser Define 5STR30String3230
51User_Define_6 SearchUser Define 6STR30String3230
52USERDEF1 SearchUser Defined 1STR20String2220
53USERDEF2 SearchUser Defined 2STR20String2220
54User_Defined_CB_1 SearchUser Defined CB 1CBBoolean20
55User_Defined_CB_2 SearchUser Defined CB 2CBBoolean20
56User_Defined_CB_3 SearchUser Defined CB 3CBBoolean20
57User_Defined_CB_4 SearchUser Defined CB 4CBBoolean20
58USRDAT01 SearchUser Defined Date 1DTDate48
59USRDAT02 SearchUser Defined Date 2DTDate48
60User_Defined_Date_3 SearchWS User Defined Date 3DATEDate46
61User_Defined_Date_4 SearchWS User Defined Date 4DATEDate46
62User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency1014
63User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency1014
64User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency1014
65User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency1014
66User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer46
67User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer46
68User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer46
69User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer46
70Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
71Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
72Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
73MODIFDT SearchModified DateDTDate48
74Modified_Time SearchModified TimeTM6Time46
75MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Master_Subcontractor_MSTR'].MDFUSRID AS 'JC_Master_Subcontractor_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC01511 AS ['JC_Master_Subcontractor_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Master_Subcontractor_MSTR'].MDFUSRID = ['Users Master'].USERID
76WSReserved_CB1 SearchWSReserved CB1CBBoolean20
77WSReserved_CB2 SearchWSReserved CB2CBBoolean20
78WSReserved_CB3 SearchWSReserved CB3CBBoolean20
79WSReserved_CB4 SearchWSReserved CB4CBBoolean20
80WSReserved_CB5 SearchWSReserved CB5CBBoolean20
81WSReserved_STR1 SearchWSReserved STR1STR10String1210
82WSReserved_STR2 SearchWSReserved STR2STR10String1210
azurecurveProductsWennSoft Products (131)3rd PartyJC_Master_Subcontractor_MSTR (JC01511)

Leave a Reply

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