Setting Up Specification Data

Access the Specification Cross Reference Revisions form.

Category Code (variable name)

Enter a value that corresponds to the equipment class for which you are setting up specification data.

This field is located in the upper left corner of the form. The name of this field corresponds to the value that you enter in the Supplemental Category Code field on the Fixed Asset Constants form. In the example, this field is Category Code 15.

Sequence Number

Enter a number that is used to sequence specification data. For any item of specification data, enter the sequence number to specify the order in which you want it to appear on the Specification Data Revisions form.

Note: After you define a specification data item, you cannot change its sequence number. If you need to revise the sequence in which a data item appears, you must type over existing data item information at the desired sequence number.
Field Number

Enter a number that defines which field in the Specification Data table you are setting up.

For this field number, you can define a description, the sequence in which it displays, and any editing rules that you want to apply to the data.

Field Type

Enter a value from user-defined code (UDC) table 12/FT (Field Type) that indicates the type of data to enter in the field on the Specification Data Entry form. Values are:

Blank: The system enters a default value of A.

A: Alpha Numeric.

N: Numeric.

D: Date.

T: Time.

Item Size

Enter the field size of the data item.

Note: All amount fields should be entered as 15 bytes, 0 decimals, and the data item type should be P (packed).
Product Code

Enter a value from UDC 98/SY (System Code) that identifies a system. Values include:

01: JD Edwards EnterpriseOne Foundation - Address Book

03B: JD Edwards EnterpriseOne Accounts Receivable

04: JD Edwards EnterpriseOne Accounts Payable

09: JD Edwards EnterpriseOne General Ledger

11: JD Edwards EnterpriseOne Multicurrency Processing

User-Defined Codes

Enter a code that identifies the table that contains UDCs.

The table is also referred to as a user-defined code type.

Data Dictionary Item

Enter a code that identifies and defines a unit of information.

It is an alphanumeric code up to eight characters long that does not allow blanks or special characters such as %, , or +. You create new data items using system codes 55 through 59. You cannot change the alias.

Use this field to populate these fields on the form based on the data dictionary definition:

  • Description

  • Item Size

  • Justify (R or L)

  • Field Type

  • Display Decimals

This field is informational only and is not stored in the database.

File ID

Enter a file ID.

Valid files are Work Order Master (F4801), Asset Master (F1201), Address Book Master (F0101), and Item Master (F4101).

Display Decimals

Enter a value that designates the number of decimals in the currency, amount, or quantity fields the system displays.

For example, U.S. dollars (USD) would be 2 decimals, Japanese yen (JPY) would be no decimals, and Cameroon francs would be 3 decimals.

Required Field (Y/N)

Enter a code that specifies whether a value is required. Values are:

Y: This value is required to be valid.

1: This value is required to be valid.

N: This value is not required. This is the default.

0: This value is not required. This is the default.

Page No

Enter a number that specifies on which page the asset number or category code should appear on the specification sheets.

The F1216 table contains only 32 fields per page. If a particular class of equipment requires more than 32 fields to store static data, you must create a new page number.

If the equipment class for which you are setting up specification data requires more than 16 specification data types, complete this field to create a new page.

Note:

To edit specification data against a UDC, complete the Product Code and User-Defined Code fields.

The value that you entered in the Item Size field must match the value of the UDC.

Complete the Data Dictionary Item and File ID fields to edit specification data against information in a specific table, complete these optional fields.