Sales Picking Instruction Cross Reference (SOP60200)

azurecurve Products Microsoft Dynamics GP (0)SalesSales Picking Instruction Cross Reference (SOP60200)

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

Display Name: Sales Picking Instruction Cross Reference
Physical Name: SOP60200
Technical Name: sopPickingInstructionXref

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	INSTRUCTIONID	Instruction ID	String	STR15_LBU	15
2	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['Sales Picking Instruction Cross Reference'].CUSTNMBR AS 'Sales Picking Instruction Cross Reference-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SOP60200 AS ['Sales Picking Instruction Cross Reference'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['Sales Picking Instruction Cross Reference'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
3	ADRSCODE	Address Code	String	STR15_Address_Code	15
4	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Sales Picking Instruction Cross Reference'].ITEMNMBR AS 'Sales Picking Instruction Cross Reference-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SOP60200 AS ['Sales Picking Instruction Cross Reference'] INNER JOIN IV00101 AS ['Item Master'] ON ['Sales Picking Instruction Cross Reference'].ITEMNMBR = ['Item Master'].ITEMNMBR
5	SEQNUMBR	Sequence Number	Long Integer	LI_Sequence_Number	10

azurecurve Products Microsoft Dynamics GP (0)SalesSales Picking Instruction Cross Reference (SOP60200)