Sales Customer Item Substitute (SOP00300)

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

Display Name: Sales Customer Item Substitute
Physical Name: SOP00300
Technical Name: sopCustomerItemSubstitute

Group Display Name: Sales Cards
Group Technical Name: Sales Cards

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['Sales Customer Item Substitute'].CUSTNMBR AS 'Sales Customer Item Substitute-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SOP00300 AS ['Sales Customer Item Substitute'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['Sales Customer Item Substitute'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Sales Customer Item Substitute'].ITEMNMBR AS 'Sales Customer Item Substitute-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SOP00300 AS ['Sales Customer Item Substitute'] INNER JOIN IV00101 AS ['Item Master'] ON ['Sales Customer Item Substitute'].ITEMNMBR = ['Item Master'].ITEMNMBR
3	SEQNUMBR	Sequence Number	Long Integer	LI_Sequence_Number	10
4	SUBITEMNMBR	Substitute Item Number	String	STR30_Item_Number	30
5	SUBITEMDESC	Substitute Item Description	String	STR50	50
6	STRTDATE	Start Date	Date	DT	8
7	ENDDATE	End Date	Date	DT	8