DBO.EQ_STD_COMPANY_SEGMENT_CODE_FROM_NAME(Parameter1, Parameter2, Parameter3)
This function will accept the display value of the segment, the segment level, and the company id. It will return the Code as listed on the Segment Lookups detail screen. This may be useful for systems integration.
Parameter(s)
Parameter1: Field for Company Segment Codes e.g. [Assignment: From Segment Level 1 Lookup], [Assignment: To Segment Level 2 Lookup]
Parameter2: Segment number e.g. 1,2,3,4
Parameter3: [Company: Id]
Example(s)
Example 1: Return the code as listed on the Company Segment Lookups screen for Segment 1 (Region) for Company 1
DBO.EQ_STD_COMPANY_SEGMENT_CODE_FROM_NAME([Assignment: From Segment Level 1 Lookup], 1, 1)
Example of field output
Company Segment Lookups by Regions (segment 1) screen
