The material text file contains the material texts of the components.
-
The value for each material text is enclosed within NEW and END text.
-
The attribute XTEXT, YTEXT and ZTEXT are added before the respective values.
-
The values for CATA and SECT are defined based on the customer settings. This could
have the same values as defined in the detail text file.
-
The SMTE should be defined as per the value in the SPECON file for MATTEXT. A possible
value for setting the SMTE could be /Ident-M as set in spec file.
-
The below is sample data for each of the material description of this file:
The format in which details are extracted to the files when you transfer an ident
depends on values defined in the Level column. For PDMS_M.DAT file, by default, CATA
is set at level 1, SECT at 2, CATE at 3, and rest of the attributes at level 4 as
shown in the following screenshot.
You can customize the Levels.
An attribute is always represented with a modifier as <OLD> or <NEW>. <OLD> indicates
that the data is already available in Destinations and <NEW> indicates new data. In
the following screenshot, CATA, SECT, and CATE have the modifier as <OLD> indicating
that the data is already available in Destinations and XTEXT, YTEXT and ZTEXT have
the modifier as <NEW> indicating that the data is new.
The following table provides details for the attributes such as retrieval source available
in PDMS_M.DAT file.
Attribute Name
|
Details
|
CATA
|
-
Definition: The name for the Catalogue world. CATA is the highest-level element of the Catalogue
hierarchy. All elements referred to in a specification must exist within a CATA hierarchy,
although elements may exist within a CATA, which are not referred to by a specification.
-
Retrieval Source: m_pck_pdms_lookup.Get_PDMS_CATA('I',i.ident)
-
Retrieval Method: BASE_COLUMN
|
SECT
|
-
Definition: The section under the CATA. Sections and Categories are administrative elements,
which let you segregate particular types of catalogue data into logical parts of the
hierarchy. Sections, which subdivide an overall CATA, are obligatory while Categories,
which subdivide Sections, are optional.
-
Retrieval Source: m_pck_pdms_lookup.Get_PDMS_SECT(cc.commodity_id)
-
Retrieval Method: BASE_COLUMN
|
CATE
|
-
Definition: The category of the components under sections. Categories, which subdivide Sections,
are optional but is a recommended practice.
-
Retrieval Source: Get_CATE
-
Retrieval Method: ATTR_STND_METHOD
|
SMTE
|
-
Definition: Refers to the short material description texts. This should have reference with
the MATTEXT attribute in SPECON file.
-
Retrieval Source: '/'||m_pck_pdms_lookup.Get_PDMS_MATTXT_XTEXT(i.ident,cc.commodity_id,'CODE')||'-M'
-
Retrieval Method: BASE_COLUMN
|
XTEXT
|
-
Definition: They are fetched based on the NLS defined (NLS_RTEXT_XTEXT) in General Configuration
for the transfer job. The values should be enclosed within single quotes. The max
size is 256 characters.
-
Retrieval Source: m_pck_pdms_lookup.Get_PDMS_MATTXT_XTEXT(i.ident,cc.commodity_id,'DESC')
-
Retrieval Method: BASE_COLUMN
|
YTEXT
|
-
Definition: They are fetched based on the NLS defined (NLS_STEXT_YTEXT) in General Configuration
for the transfer job. The values should be enclosed within single quotes. The max
size is 256 characters.
-
Retrieval Source: m_pck_pdms_lookup.Get_PDMS_MATTXT_XTEXT(i.ident,cc.commodity_id,'DESC')
-
Retrieval Method: BASE_COLUMN
|
ZTEXT
|
-
Definition: They are fetched based on the NLS defined (NLS_TTEXT_ZTEXT) in General Configuration
for the transfer job. The values should be enclosed within single quotes. The max
size is 256 characters.
-
Retrieval Source: m_pck_pdms_lookup.Get_PDMS_MATTXT_XTEXT(i.ident,cc.commodity_id,'DESC')
-
Retrieval Method: BASE_COLUMN
|