WS Sales Transaction History (WSS30200)

azurecurveProductsWennSoft Products (131)3rd PartyWS Sales Transaction History (WSS30200)

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

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

Display Name: WS Sales Transaction History
Physical Name: WSS30200
Technical Name: WS_SOP_HDR_HIST

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 History'].CUSTNMBR AS 'WS Sales Transaction History-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       WSS30200 AS ['WS Sales Transaction History']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['WS Sales Transaction History'].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 History (WSS30200)

Leave a Reply

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