CLM Issued By Setup (CLM40400)

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

Product: Certification Manager (4933)
Series:

Display Name: CLM Issued By Setup
Physical Name: CLM40400
Technical Name: CLM_IssuedBy_SETP

Group Display Name: Certification Manager
Group Technical Name: CLTM

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CLM_Issued_By SearchCLM Issued ByStringSTR15_Address_Code15
2CLM_Description SearchCLM DescriptionStringSTR5050
3INACTIVE SearchInactiveBooleanCB_Inactive0
4CNTCPRSN SearchContact PersonStringSTR6060
5ADDRESS1 SearchAddress 1StringSTR6060
6ADDRESS2 SearchAddress 2StringSTR6060
7CITY SearchCityStringSTR3535
8STATE SearchStateStringSTR30_State29
9ZIPCODE SearchZip CodeStringSTR1010
10PHONE1 SearchPhone 1StringPhone_Number14
11FAXNUMBR SearchFax NumberStringSTR14_FAX14
12INET1 SearchINet1StringSTR200200
13INET2 SearchINet2StringSTR200200
14CHANGEBY_I SearchChange ByStringSTR15_User_ID15
15CHANGEDATE_I SearchChange DateDateDT8
16NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['CLM Issued By Setup'].NOTEINDX AS 'CLM Issued By Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       CLM40400 AS ['CLM Issued By Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['CLM Issued By Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX

Leave a Reply

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