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 Group Display Name: WS Shared
Physical Name: WSDOCS
Technical Name: WS_DOCS
Group Technical Name: WS Shared
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | Document_ID  | WS Document ID | Long Int | Long Integer | 8 | |
| 2 | Document_Type | WS Document Type | WS Document Type | Integer | 0 | |
| 3 | Document_Category | WS Document Category | INT4 | Integer | 4 | |
| 4 | Document_Priority | WS Document Priority | INT4 | Integer | 4 | |
| 5 | Document_Name | WS Document Name | STR255 | String | 255 | |
| 6 | Document_Description | WS Document Description | STR50 | String | 50 | |
| 7 | Document_Extension | WS Document Extension | STR30_LBAU | String | 30 | |
| 8 | Document_URL | WS Document URL | STR255 | String | 255 | |
| 9 | Document_Date | WS Document Date | DATE_L | Date | 0 | |
| 10 | Document_Exp_Date | WS Document Exp Date | Date | Date | 10 | |
| 11 | Document_Rev_Number | WS Document Rev Number | STR30 | String | 30 | |
| 12 | Document_Author | WS Document Author | STR30 | String | 30 | |
| 13 | Document_Image | WS Document Image | STR255 | String | 255 | |
| 14 | CUSTNMBR | Customer Number | STR15_RM_Customer_Number | String | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['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 | ||||||
| 15 | ADRSCODE | Address Code | STR15_Address_Code | String | 15 | |
| 16 | Service_Call_ID | Service Call ID | STR17_LBAU | String | 17 | |
| 17 | Equipment_ID | Equipment ID | STR30 | String | 30 | |
| 18 | Location_Equipment | Location Equipment | STR50_LBU | String | 50 | |
| 19 | Equipment_Type | Equipment Type | STR30 | String | 30 | |
| 20 | Wennsoft_Model_Number | Wennsoft Model Number | STR20 | String | 20 | |
| 21 | Contract_Number | WS Contract Number | STR10 | String | 10 | |
| 22 | WS_Job_Number | WS Job Number | STR17_LBAU | String | 17 | |
| 23 | Quote_Number | Quote Number | STR10 | String | 10 | |
| 24 | Quote_Type | Quote Type | DDL_Quote_Type | Integer | 0 | |
| 25 | Change_Order_Nbr | Change Order # | STR14 | String | 14 | |
| 26 | Project_Number | WS Project Number | STR170 | String | 17 | |
| 27 | VENDORID | Vendor ID | STR_15_Vendor_ID | String | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['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 | ||||||
| 28 | Subcontractor_Item | Subcontractor Item | Subcontract Item | Integer | 0 | |
| 29 | Cost_Code_Number_1 | WS Cost Code Number 1 | STR7 | String | 7 | |
| 30 | Cost_Code_Number_2 | WS Cost Code Number 2 | STR7 | String | 7 | |
| 31 | Cost_Code_Number_3 | WS Cost Code Number 3 | STR7 | String | 7 | |
| 32 | Cost_Code_Number_4 | WS Cost Code Number 4 | STR7 | String | 7 | |
| 33 | Cost_Element | Cost Element | INT3_RB0_U | Integer | 3 | |
| 34 | Transaction_Doc_Number | Transaction Doc Number | DLR19_RB0 | Currency | 19 | |
| 35 | Send_Notification | Send Notification | CB_Send_Notification | Boolean | 0 | |
| 36 | CONTNBR | Contract Number | STR11 | String | 11 | |
| 37 | DLDocumentID | DLDocumentID | Long Int | Long Integer | 8 | |