WS Sales Transaction Work (WSS10100)

azurecurveProductsWennSoft Products (131)3rd PartyWS Sales Transaction Work (WSS10100)

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
Physical Name: WSS10100
Technical Name: WS_SOP_HDR_WORK

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Product_Indicator SearchProduct IndicatorDDL_Product_IndicatorInteger20
2WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
3SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger20
4SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString2217
5CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['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
6DOCID SearchDocument IDSTR15_LBAUString1615
7Primary_Invoice SearchPrimary InvoiceBooleanBoolean20
8BACHNUMB SearchBatch NumberSTR15_LBAUString1615
9DOCDATE SearchDocument DateDTDate48
10VOIDED SearchVoidedCBBoolean20
11CREATDDT SearchCreated DateDTDate48
12MODIFDT SearchModified DateDTDate48
azurecurveProductsWennSoft Products (131)3rd PartyWS Sales Transaction Work (WSS10100)

Leave a Reply

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