pref_ecm_sys (ECPS0000)

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

Product: Manufacturing (346)
Series:

Display Name: pref_ecm_sys
Physical Name: ECPS0000
Technical Name: pref_ecm_sys

Group Display Name: Manufacturing ECM
Group Technical Name: Manufacturing ECM

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CMPANYID SearchCompany IDIntegerINT54
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['pref_ecm_sys'].CMPANYID AS 'pref_ecm_sys-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       ECPS0000 AS ['pref_ecm_sys']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['pref_ecm_sys'].CMPANYID = ['Company Master'].CMPANYID
2ECNumber SearchECNumberStringSTR1515
3STRTDATE SearchStart DateDateDT8
4cbxECMPrefs SearchcbxECMPrefsCBBoolean0
5cbxECMPrefs_1 SearchcbxECMPrefs[1]BooleanCB0
6cbxECMPrefs_2 SearchcbxECMPrefs[2]BooleanCB0
7cbxECMPrefs_3 SearchcbxECMPrefs[3]BooleanCB0
8cbxECMPrefs_4 SearchcbxECMPrefs[4]BooleanCB0
9cbxECMPrefs_5 SearchcbxECMPrefs[5]BooleanCB0
10cbxECMPrefs_6 SearchcbxECMPrefs[6]BooleanCB0
11cbxECMPrefs_7 SearchcbxECMPrefs[7]BooleanCB0
12cbxECMPrefs_8 SearchcbxECMPrefs[8]BooleanCB0
13cbxECMPrefs_9 SearchcbxECMPrefs[9]BooleanCB0
14cbxECMPrefs_10 SearchcbxECMPrefs[10]BooleanCB0
15cbxECMPrefs_11 SearchcbxECMPrefs[11]BooleanCB0
16cbxECMPrefs_12 SearchcbxECMPrefs[12]BooleanCB0
17cbxECMPrefs_13 SearchcbxECMPrefs[13]BooleanCB0
18cbxECMPrefs_14 SearchcbxECMPrefs[14]BooleanCB0
19cbxECMPrefs_15 SearchcbxECMPrefs[15]BooleanCB0
20cbxECMPrefs_16 SearchcbxECMPrefs[16]BooleanCB0
21cbxECMPrefs_17 SearchcbxECMPrefs[17]BooleanCB0
22cbxECMPrefs_18 SearchcbxECMPrefs[18]BooleanCB0
23cbxECMPrefs_19 SearchcbxECMPrefs[19]BooleanCB0
24cbxECMPrefs_20 SearchcbxECMPrefs[20]BooleanCB0
25DAYS_I SearchDaysIntegerIINT55
26USRDFPR1 SearchUser Defined Prompt 1StringSTR1515
27USRDRPR2 SearchUser Defined Prompt 2StringSTR1515
28USRDRPR3 SearchUser Defined Prompt 3StringSTR1515
29USRDRPR4 SearchUser Defined Prompt 4StringSTR1515
30USRDRPR5 SearchUser Defined Prompt 5StringSTR1515
31USRDRPR6 SearchUser Defined Prompt 6StringSTR1515

Leave a Reply

Your email address will not be published. Required fields are marked *