Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WSS10100
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: WS Sales Transaction Work Group Display Name: WS Shared
Physical Name: WSS10100
Technical Name: WS_SOP_HDR_WORK
Group Technical Name: WS Shared
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | Product_Indicator | Product Indicator | DDL_Product_Indicator | Integer | 0 | |
2 | WS_Job_Number | WS Job Number | STR17_LBAU | String | 17 | |
3 | SOPTYPE | SOP Type | DDL_SOP_Type | Integer | 0 | |
4 | SOPNUMBE | SOP Number | STR20_SOP_Number | String | 17 | |
5 | CUSTNMBR | Customer Number | STR15_RM_Customer_Number | String | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['WS Sales Transaction Work'].CUSTNMBR AS 'WS Sales Transaction Work-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
WSS10100 AS ['WS Sales Transaction Work']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['WS Sales Transaction Work'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
6 | DOCID | Document ID | STR15_LBAU | String | 15 | |
7 | Primary_Invoice | Primary Invoice | Boolean | Boolean | 0 | |
8 | BACHNUMB | Batch Number | STR15_LBAU | String | 15 | |
9 | DOCDATE | Document Date | DT | Date | 8 | |
10 | VOIDED | Voided | CB | Boolean | 0 | |
11 | CREATDDT | Created Date | DT | Date | 8 | |
12 | MODIFDT | Modified Date | DT | Date | 8 |