External Field References

You can reference fields that are external to the JD Edwards EnterpriseOne Configurator system to use in derived calculations.

Using the External Files Reference program, you select a field from these tables:

Table	Description
F0101	Address Book Master
F03012	Customer Master by Line of Business
F41002	Item Units of Measure Conversion Factors
F4101	Item Master
F4102	Item Branch
F41021	Item Location
F4105	Item Cost
F4106	Item Base Price

After you reference a field value, the information appears in the Derived Calculation field, preceded by an ampersand (&). The ampersand is then followed by the table identifier and then the field alias. You can use the field independently or within a complex expression.

You can also include field values through External Files Reference. For example, a pricing assembly inclusion rule for item 6000 (forklift) uses a field reference to retrieve a base price from the F4106 table. The formula & BPUPRC appears in the Derived Calculation field, where BP is the table identifier for the F4106 table and UPRC is the alias for price.

The system uses the component item number and branch from the rule to retrieve the appropriate tables. It also uses the Address Book number to retrieve data from the address book or billing instructions tables.

To reference a supplemental database field, you must also specify the data type. Enter the data type after the field, in this way:

Data Type	Description
&T2AMTU(WD)	Indicates an amount field on the Item Supplemental Database table and the WD data type.

When you reference the unit of measure in table F41002, you must specify the unit of measure in the same manner.