Sales Forecast Salespeople (SC020430)

azurecurve Products Manufacturing (346)3rd PartySales Forecast Salespeople (SC020430)

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

Product: Manufacturing (346)
Series:

Display Name: Sales Forecast Salespeople
Physical Name: SC020430
Technical Name: SF_Salespeople

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	SLPRSNID	Salesperson ID	String	STR15_Salesperson_ID	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['Sales Forecast Salespeople'].SLPRSNID AS 'Sales Forecast Salespeople-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM SC020430 AS ['Sales Forecast Salespeople'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['Sales Forecast Salespeople'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID

Seq No

Physical Name

Display Name

Dexterity Data Type

SQL Data Type

Length

PLANNAME_I Search

Plan Name

String

STR15

SLPRSNID

Salesperson ID

String

STR15_Salesperson_ID

Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['Sales Forecast Salespeople'].SLPRSNID AS 'Sales Forecast Salespeople-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SC020430 AS ['Sales Forecast Salespeople']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['Sales Forecast Salespeople'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID

azurecurve Products Manufacturing (346)3rd PartySales Forecast Salespeople (SC020430)

Click to show/hide

Leave a Reply Cancel reply