WS_Docs_MSTR (WSDOCS)

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

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

Display Name: WS_Docs_MSTR
Physical Name: WSDOCS
Technical Name: WS_DOCS

Group Display Name: WS Shared
Group Technical Name: WS Shared

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Document_ID SearchWS Document IDLong IntLong Integer48
2Document_Type SearchWS Document TypeWS Document TypeInteger20
3Document_Category SearchWS Document CategoryINT4Integer24
4Document_Priority SearchWS Document PriorityINT4Integer24
5Document_Name SearchWS Document NameSTR255String256255
6Document_Description SearchWS Document DescriptionSTR50String5250
7Document_Extension SearchWS Document ExtensionSTR30_LBAUString3230
8Document_URL SearchWS Document URLSTR255String256255
9Document_Date SearchWS Document DateDATE_LDate40
10Document_Exp_Date SearchWS Document Exp DateDateDate410
11Document_Rev_Number SearchWS Document Rev NumberSTR30String3230
12Document_Author SearchWS Document AuthorSTR30String3230
13Document_Image SearchWS Document ImageSTR255String256255
14CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['WS_Docs_MSTR'].CUSTNMBR AS 'WS_Docs_MSTR-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       WSDOCS AS ['WS_Docs_MSTR']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['WS_Docs_MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
15ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
16Service_Call_ID SearchService Call IDSTR17_LBAUString1817
17Equipment_ID SearchEquipment IDSTR30String3230
18Location_Equipment SearchLocation EquipmentSTR50_LBUString5250
19Equipment_Type SearchEquipment TypeSTR30String3230
20Wennsoft_Model_Number SearchWennsoft Model NumberSTR20String2220
21Contract_Number SearchWS Contract NumberSTR10String1210
22WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
23Quote_Number SearchQuote NumberSTR10String1210
24Quote_Type SearchQuote TypeDDL_Quote_TypeInteger20
25Change_Order_Nbr SearchChange Order #STR14String1614
26Project_Number SearchWS Project NumberSTR170String1817
27VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['WS_Docs_MSTR'].VENDORID AS 'WS_Docs_MSTR-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       WSDOCS AS ['WS_Docs_MSTR']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['WS_Docs_MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID
28Subcontractor_Item SearchSubcontractor ItemSubcontract ItemInteger20
29Cost_Code_Number_1 SearchWS Cost Code Number 1STR7String87
30Cost_Code_Number_2 SearchWS Cost Code Number 2STR7String87
31Cost_Code_Number_3 SearchWS Cost Code Number 3STR7String87
32Cost_Code_Number_4 SearchWS Cost Code Number 4STR7String87
33Cost_Element SearchCost ElementINT3_RB0_UInteger23
34Transaction_Doc_Number SearchTransaction Doc NumberDLR19_RB0Currency1019
35Send_Notification SearchSend NotificationCB_Send_NotificationBoolean20
36CONTNBR SearchContract NumberSTR11String1211
37DLDocumentID SearchDLDocumentIDLong IntLong Integer48

Leave a Reply

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