Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CN00300
Product: Collections Management (1157)
Series: Sales
Display Name: Collections - Notes Text Group Display Name: Collection Notes
Physical Name: CN00300
Technical Name: CN_Notes_Text
Group Technical Name: CollectionNotes
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | NOTEINDX  | Note Index | DLR14 | Currency | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['Collections - Notes Text'].NOTEINDX AS 'Collections - Notes Text-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
CN00300 AS ['Collections - Notes Text']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Collections - Notes Text'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
| 2 | TXTFIELD | Text Field | TX32000 | Text | 32000 | |