|
Media & Text Objects - Explanation
JD Edwards OneWorld and EnterpriseOne supports media and text objects.
Unity’s new version 3.0 ODBC drivers for JD Edwards OneWorld and EnterpriseOne now expose E1 media and text objects just like any other table and column.
All Media Objects are held in a repository as Views and each JDE table (F4101 Item Master) has a JDE view (MO_GT4101) in which the objects associated with the item is held if it exists.
The jdeDirect ODBC Driver now makes these views (Virtual Tables) available in a number of formats in different columns so that you can chose how you want to see them.
The table below summarises the multiple type details available.
|
Column
|
Description
|
Primary Keys
|
IMITM 1
|
Key Fields - Key 1
Key 2
Key 3
~~~
|
Application - Crystal
|
IMMORTF 2
|
Rich Text Format
|
|
|
|
- Crystal
|
IMOCRYSTAL 3
|
Crystal Formatted objects (Images)
Documents, PDF, OLE objects
|
|
|
|
- Other
|
IMMOLINK
|
Link, URL, UNC Path
|
|
|
|
|
|
|
Technical 4
|
IMMOBLOB
|
The Data as a Blob
|
|
IMGTMOTYPE
|
JDE Field MO Type
|
|
IMQUNAM
|
Media Queue Name
|
|
IMGTFILENM
|
Name of Actual File
|
|
IMGTITNM
|
Internal File Name
|
|
IMTXTF
|
Binary Contact or Link to file
|
| Note 1. | The Key field/s will vary depending on the object file selected. IMITM relates to the Item Master (F4101) which has only one key field but if the Purchase Order file (F4311) had been used then five (5) key fields would be displayed - PDKCOO, PDDOCO, PDDCTO, PDSFXO, and PDLNID. |
| Note 2. | To correctly display the RTF contents you will need to format this field in Crystal and change its Text Interpretation to RTF from none. |
| Note 3. | You may not want to show the actual Image in your Crystal Report (due to its size) but just show the Link; in which case the IMMOLINK will be selected If the picture and link are required then select IMOCRYATAL and IMMOLINK |
| Note 4. | These six options are available for Users if they require. A brief description of each is shown. |
For details of how to use the Media and Text Objects in Crystal Reports see Use of Media Objects with Crystal.
|