Manufacturing Customer Master (IC090000)

azurecurve Products Manufacturing (346)3rd PartyManufacturing Customer Master (IC090000)

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

Product: Manufacturing (346)
Series:

Display Name: Manufacturing Customer Master
Physical Name: IC090000
Technical Name: IC_RM_Customer_MSTR

Group Display Name: Manufacturing SOP
Group Technical Name: Manufacturing SOP

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 ['Manufacturing Customer Master'].CUSTNMBR AS 'Manufacturing Customer Master-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM IC090000 AS ['Manufacturing Customer Master'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['Manufacturing Customer Master'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	SOPFOB_I	SOP_FOB	String	STR15	15

Seq No

Physical Name

Display Name

Dexterity Data Type

SQL Data Type

Length

CUSTNMBR

Customer Number

String

STR15_RM_Customer_Number

Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Manufacturing Customer Master'].CUSTNMBR AS 'Manufacturing Customer Master-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       IC090000 AS ['Manufacturing Customer Master']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Manufacturing Customer Master'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR

SOPFOB_I

SOP_FOB

String

STR15

azurecurve Products Manufacturing (346)3rd PartyManufacturing Customer Master (IC090000)

Click to show/hide

Leave a Reply Cancel reply