Sales Customer Item Cross Reference (SOP60300)

azurecurveProductsMicrosoft 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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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
2CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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
3CUSTITEMNMBR SearchCustomer Item NumberCustomer_Item_NumberString30
4CUSTITEMDESC SearchCustomer Item DescriptionCustomer_Item_DescriptionString50
5CUSTITEMSHORNAME SearchCustomer Item Short NameSTR15String15
6CUSTITEMGENERICDESC SearchCustomer Item Generic DescriptionSTR10String10
7USERDEF1 SearchUser Defined 1STR20String20
8USERDEF2 SearchUser Defined 2STR20String20
9USRDEF03 SearchUser Defined 3STR20String20
10USRDEF04 SearchUser Defined 4STR20String20
11USRDEF05 SearchUser Defined 5STR20String20
12USERDEFKEY1 SearchUser Defined Key1STR50String50
13USERDEFKEY2 SearchUser Defined Key2STR50String50
14USERDEFKEY3 SearchUser Defined Key3STR50String50
15USERDEFKEY4 SearchUser Defined Key4STR50String50
16NOTEINDX SearchNote IndexDLR14Currency14
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
17DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Customer Item Cross Reference (SOP60300)

Leave a Reply

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