1. Time and Labor Implementation Guide
  2. Optional Fields

Optional Fields

Many fields in the F06116Z1 table are not required to upload timecard information. However, you might upload values into these fields. You can complete these optional fields in a custom program. If necessary, obtain technical support for additional assistance.

These fields are optional:

Field Name

Field Description

VLANI (Account Number)

A number that identifies an account in the general ledger. You can use one of these formats for account numbers:

  • Structured account (business unit, object, subsidiary)

  • 25-digit unstructured number

  • 8-digit short account ID number

  • Speed code

The first character of the account indicates the format of the account number. You define the account format in the General Accounting Constants program (P0000).

The value is supplied from the master business function based on labor distribution fields.

Use this field or the VLMCU (Business Unit), VLOBJ (Object Account), and VLSUB (Subsidiary) fields.

VLMCU (Business Unit)

A value that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse, location, or job.

VLOBJ (Object Account)

The object account portion of the general ledger account.

VLSUB (Subsidiary)

A subdivision of an object account. Subsidiary accounts include more detailed records of the accounting activity for an object account.

VLGMCU (Recharge Business Unit)

For payroll purposes, a business unit that represents the distribution account where the recharge (billing) amounts are to be posted. The only time that this field is generated is when you enter 2 or 3 in the Record Type field for an employee. In these instances, the derived distribution account, or entered account, equals this business unit.

VLGOBJ (Recharge Object Account)

For payroll purposes, the number of the account to which the recharge (billing) amounts are to be posted.

VLGSUB (Recharge Subsidiary)

For payroll purposes, the number of the subsidiary account to which the recharge (billing) amounts are to be posted.

VLSBL (Subledger)

A code that identifies a detailed auxiliary account within a general ledger account. A subledger can be an equipment number, an address book number, and so forth. If you complete this field, you must also complete the VLSBLT (Subledger Type) field.

VLSBLT (Subledger Type)

A user-defined code (UDC) (00/ST) that is used with the Subledger field to identify the subledger type.

VLWR01 (Phase)

A UDC (00/W1) that indicates the current stage or development of a work order. You can assign a work order to only one phase code at a time.

This UDC is automatically supplied from the work order if the speed coding method for entering a work order is used.

VLMCUO (Chargeout Business Unit)

A business unit that represents the location where the employee worked. You can use this code to indicate that an employee worked at this location but charged the time to another business unit. This field is used for deriving rates from F069126 and is used exclusively by the Certified Payroll Register program (R07371).

VLMAIL (Check Route Code)

A UDC (06/CR) that specifies the check routing or mail stop code. Use this code to sequence the printing of payroll checks to facilitate their handling and delivery.

VLUN (Union Code)

A UDC (06/UN) that represents the union or plan in which the employee or group of employees work or participate.

VLJBCD (Job Type)

A UDC (06/G) that defines the jobs within the organization. You can associate pay and benefit information with a job type and apply that information to the employees who are linked to that job type.

VLJBST (Job Step)

A UDC (06/GS) that designates a specific step, grade, or salary level within a particular job type. The system uses this field in conjunction with job type to determine pay rates by job.

VLSHFT (Shift Codes)

A UDC (06/SH) that identifies daily work shifts. In payroll systems, you can use a shift code to add a percent or amount to the hourly rate on a timecard.

VLSHD (Shift Differential)

An additional rate, expressed in currency or percent, that the system adds to an employee's hourly rate, depending on the shift worked. This rate can be applied in one of two ways as defined by the Shift Differential Calculation Sequence (data item CMTH).

VLDTBT (Date Time Clock Start)

The date and time that the timecard transaction was created.

VLTCDE (Date Time Clock End)

The date and time that the timecard transaction was ended.

VLEQWO (Equipment Worked On)

The ID number for the equipment that an employee maintained or repaired, but did not use. For example, an employee might change the oil in the company dump truck. Use this field to direct labor expenses to the specific piece of equipment.

VLEQCG (Equipment Worked)

The ID number of the equipment that an employee used to perform a job. For example, an employee might drive a company dump truck or operate a printing press. Use this field to distribute the cost of using the equipment to the proper account in the general ledger.

VLQOBJ (Equipment Object Account)

The object account to which you want the system to distribute equipment utilization charges.

VLERC (Equipment Billing Rate Codes)

A UDC (00/RC) that indicates a billing rate, such as DY for daily, MO for monthly, and WK for weekly. You can set up multiple billing rates for a piece of equipment.

VLEQRT (Billing Rate)

The monetary amount for the equipment billing rate. Each equipment item can have numerous billing rates based on the rate code (see Equipment Billing Rate-ERC).

VLEQHR (Equipment Hours)

The number of hours that the equipment was operated. If you leave this field blank, the system uses the hours from employee time entry when you enter an equipment number. If you do not enter employee hours, you must complete this field.

VLEXR (Explanation)

A name or remark that describes a timecard record.

VLP001–VLP004 (Category codes 14)

The JD Edwards EnterpriseOne Payroll system category codes for which you can define the use and description of each to fit the needs of the organization.

VLEPA (Entered Gross Pay)

A lump sum amount, an adjustment amount, or an amount that represents an employee's gross pay. This amount temporarily overrides any pay calculation that the system normally performs.