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 TypeLength
1Product_Indicator SearchProduct IndicatorDDL_Product_IndicatorInteger0
2WS_Job_Number SearchWS Job NumberSTR17_LBAUString17
3SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger0
4SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString17
5CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_LBAUString15
7Primary_Invoice SearchPrimary InvoiceBooleanBoolean0
8BACHNUMB SearchBatch NumberSTR15_LBAUString15
9DOCDATE SearchDocument DateDTDate8
10VOIDED SearchVoidedCBBoolean0
11CREATDDT SearchCreated DateDTDate8
12MODIFDT SearchModified DateDTDate8
azurecurveProductsWennSoft Products (131)3rd PartyWS Sales Transaction Work (WSS10100)

Leave a Reply

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