Sales Forecast Customers (SC020330)

azurecurve Products Manufacturing (346)3rd PartySales Forecast Customers (SC020330)

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

Product: Manufacturing (346)
Series:

Display Name: Sales Forecast Customers
Physical Name: SC020330
Technical Name: SF_Customers

Group Display Name: Manufacturing Sales Fcst.
Group Technical Name: Manufacturing SFC

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PLANNAME_I	Plan Name	String	STR15	15
2	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['Sales Forecast Customers'].CUSTNMBR AS 'Sales Forecast Customers-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SC020330 AS ['Sales Forecast Customers'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['Sales Forecast Customers'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR

Seq No

Physical Name

Display Name

Dexterity Data Type

SQL Data Type

Length

PLANNAME_I Search

Plan Name

String

STR15

CUSTNMBR

Customer Number

String

STR15_RM_Customer_Number

Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Sales Forecast Customers'].CUSTNMBR AS 'Sales Forecast Customers-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SC020330 AS ['Sales Forecast Customers']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Sales Forecast Customers'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR

azurecurve Products Manufacturing (346)3rd PartySales Forecast Customers (SC020330)

Click to show/hide

Leave a Reply Cancel reply