WS Sales Transaction History (WSS30200)

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

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 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/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
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