Sales Customer Item Cross Reference (SOP60300)

azurecurve Products Microsoft Dynamics GP (0)SalesSales Customer Item Cross Reference (SOP60300)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Sales Customer Item Cross Reference
Physical Name: SOP60300
Technical Name: sopCustomerItemXref

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Sales Customer Item Cross Reference'].ITEMNMBR AS 'Sales Customer Item Cross Reference-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SOP60300 AS ['Sales Customer Item Cross Reference'] INNER JOIN IV00101 AS ['Item Master'] ON ['Sales Customer Item Cross Reference'].ITEMNMBR = ['Item Master'].ITEMNMBR
2	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['Sales Customer Item Cross Reference'].CUSTNMBR AS 'Sales Customer Item Cross Reference-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SOP60300 AS ['Sales Customer Item Cross Reference'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['Sales Customer Item Cross Reference'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
3	CUSTITEMNMBR	Customer Item Number	String	Customer_Item_Number	30
4	CUSTITEMDESC	Customer Item Description	String	Customer_Item_Description	50
5	CUSTITEMSHORNAME	Customer Item Short Name	String	STR15	15
6	CUSTITEMGENERICDESC	Customer Item Generic Description	String	STR10	10
7	USERDEF1	User Defined 1	String	STR20	20
8	USERDEF2	User Defined 2	String	STR20	20
9	USRDEF03	User Defined 3	String	STR20	20
10	USRDEF04	User Defined 4	String	STR20	20
11	USRDEF05	User Defined 5	String	STR20	20
12	USERDEFKEY1	User Defined Key1	String	STR50	50
13	USERDEFKEY2	User Defined Key2	String	STR50	50
14	USERDEFKEY3	User Defined Key3	String	STR50	50
15	USERDEFKEY4	User Defined Key4	String	STR50	50
16	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Sales Customer Item Cross Reference'].NOTEINDX AS 'Sales Customer Item Cross Reference-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM SOP60300 AS ['Sales Customer Item Cross Reference'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Sales Customer Item Cross Reference'].NOTEINDX = ['Record Notes Master'].NOTEINDX

azurecurve Products Microsoft Dynamics GP (0)SalesSales Customer Item Cross Reference (SOP60300)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply