Creating the JDE Match Child Object: Explained

Use the following procedure to create the JDE Match child object. Creating a child object is similar to Creating a Custom Object, but you also complete the Child Collection Name field to specify the internal name for the set of child object records.

To create the JDE Match child object do the following:

1. Click Navigator, and select Application Composer.

2. Expand the Standard Objects node, and then select Account.

3. Click the Create Child Object button.

4. In the Create Custom Child Object dialog box, enter the object information listed in the following table, and then click OK.

   Parameter	Value
   Display Label	JDE Match
   Plural Label	JDE Match
   Record Name Label	JDE Match ID
   Record Name Data Type	Select Automatically Generated Sequence from the drop-down list.
   Sequence Format	{000000000000000} (15 zeroes inside braces)
   Object Name	O_INT_JDE_MATCH
   Description	Leave blank.
   Child Collection Name	O_INT_JDE_MatchCollection

Adding Fields to the Child Object

Create the fields for the JDE Match child object using the following procedure:

1. In the Application Composer, expand the Account node from the Standard Objects list.

2. Click JDE Match child object, and, then expand the JDE Match node in the Custom Objects list.

3. Click Fields.

4. On the Fields page, click the Create a custom field icon.

5. In the Select Field Type dialog box, select the appropriate field type, and then click OK.

6. In the Create Object_Type Field window, enter the parameters, and then click OK.

7. Repeat the previous steps for other fields as necessary.

Parameter	Address1 Field	City Field	State Field	Province Field	PostalCode Field	Country Field
Field Type	Text	Text	Text	Text	Text	Check box
Display Label	Address Line 1	City	State	Province	Postal Code	Selected
Name	Address1	City	State	Province	PostalCode	Selected
Display Width	20	20	20	20	8	Not applicable
Display Type	Simple Text Box	Simple Text Box	Simple Text Box	Simple Text Box	Simple Text Box	Not applicable
Constraints	Updatable, Searchable	Updatable, Searchable	Updatable, Searchable	Updatable, Searchable	Updatable, Searchable	Updatable, Searchable
Maximum Length	80	80	80	80	15	Not applicable

The following table lists more fields required to create the JDE Match child object.

Parameter	PartyName Field	PartyID Field	PartyType Field	IndustryClassification Field	PrimaryPhoneAreaCode Field
Field Type	Text	Text	Text	Text	Text
Display Label	City	State	Country	Industry Classification	Primary Phone Area Code
Name	City	State	Country	IndustryClassification	PrimaryPhoneAreaCode
Display Width	20	20	20	10	20
Display Type	Simple Text Box	Simple Text Box	Simple Text Box	Simple Text Box	Simple Text Box
Constraints	Updatable, Searchable	Updatable, Searchable	Updatable, Searchable	Updatable, Searchable	Updatable, Searchable
Maximum Length	80	80	80	80	80

The following table lists more fields required to create the JDE Match child object.

Parameter	PrimaryPhoneNumber Field	PrimaryEmail Field
Field Type	Text	Text
Display Label	Primary Phone Number	Primary Email
Name	PrimaryPhoneNumber	PrimaryEmail
Display Width	20	20
Display Type	Simple Text Box	Simple Text Box
Constraints	Updatable, Searchable	Updatable, Searchable
Maximum Length	80	80

Adding the Constraint Expression for the Selected Check Box

After creating and saving the Selected check box, you edit it to add an expression to the Updatable constraint. To add an expression to the Updatable constraint for the Selected check box do the following:

1. After adding fields to the JDE Match Child object, click the link for the Selected check box on the Fields page.

2. In the Edit Checkbox Field: Selected window, click the Expression Builder icon.

   The Expression Builder appears, with the Functions tab displayed by default.

3. In the expression window, enter the following text:Selected_c == null || Selected_c == 'N'

4. Click OK.

5. In the Edit Checkbox Field: Selected window, click Save and Close.