Table Editing

Use this group box to set up table-based cost object types.

Based On Table

Enter the number of a table used in JD Edwards EnterpriseOne Advanced Cost Accounting when adding a driver on the Driver Definition program (P1630). The table forms the basis for driver calculations through JD Edwards EnterpriseOne Advanced Cost Accounting, including determining which fields are available to use when doing driver calculations.

Determines what the automatic driver calculations will be based on.

To enable table options, select Tables by Function from the Form menu.

Data Item

Enter a code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %,&, or +. You create new data items using system codes 55-59. You cannot change the alias.

To select a data item within the based on table, select Data Items by Table from the Form menu.

Relationship

Enter a user defined code (00/VA) that indicates the relationship between the ranges of variances that you display. Values are:

EQ: Equal to.

LT: Less than.

LE: Less than or equal to.

GT: Greater than.

GE: Greater than or equal to.

NE: Not equal to.

NL: Not less than.

NG: Not greater than.

CT: Contains (only allowed in selection for Open Query File function).

CU: Same as CT but converts all input data to uppercase letters.

Item Value

Enter a value that the item in the based on table will be compared with. Complete this field only when using edit rule T.