Equipment Timecard (Usage) Interface: Pipe Delimited Method

Use the Equipment Timecard Interface to load equipment timecard information using data from external applications.

The Equipment Timecard (Usage) Interface has a Request Type of EQT and an Interface Type of Q. Data files you load must have Request Types assigned to the Q Interface Type.

PENTA runs several high-level tests for integrity on the file and records. Only if the following is true will PENTA attempt to process the Detail Records and distribute the batch (Header Record and associated Detail Records):

  • The currency for all distributions within the batch is the same.

  • It affects no more than two balance sheets. If System Option 107 is Y, only one balance sheet can be used. If a batch impacts more than two balance sheets, PENTA does not process it.

If your equipment usage entries inadvertently cross OU structures, the Equipment Timecard Interface rejects your file (rather than producing a system error)—providing you a chance to correct and resubmit it for processing.

After interfacing records, you can review and correct them as needed in the Equipment Usage window.

Available Records

Equipment Timecard Header Detail Record

Unlike other interfaces, the Equipment Usage Interface does NOT require both a Header and Detail record. Instead, just include one record per distinct equipment timecard distribution. You must charge each distribution to one of the following three combinations:

  • Job Id, Cost Type, and Costcode

  • OU Id and general ledger account

  • Fixed Asset Id and expense category

The following fields are part of the Header Detail record.

#

Field

Entry

Format

Description

#

Field

Entry

Format

Description

1

Fixed Asset Id

Req

C 10

Must be a valid Fixed Asset Id with a usage charge rate (unless you entered an override rate or amount).

2

Distribution Date

Req

C 8

Date must fall in a valid accounting period for both the fixed asset’s OU and the OU to which the equipment timecard posts.

The user processing the interface file must have authorization to post entries to restricted or closed accounting periods if this date falls within a restricted or closed accounting period for the fixed asset’s OU or the charged OU Id.

3

Job Id

Opt

C 10

If you include a Job Id, the following are true:

  • Cost Type and Costcode are required.

  • The OU Id defaults from the job and you cannot override it.

  • The account defaults from the Job Type and Cost Type combination and you cannot override it.

  • You cannot include an entry to either the Charge to Fixed Asset or the Asset Expense Category.

4

Cost Type Code

Opt

C 4

This must have a value if a Job Id exists; otherwise, this field must be null.

Must be valid for the Job Type associated with the Job Id.

 

Costcode

Opt

C 15

This must have a value if a Job Id exists; otherwise, this field must be null.

Must be valid for the Job Id and Cost Type Code combination.

6

OU Id

Opt

X

Enter a value only if the Job Id and Charge To Asset Id are null; otherwise, this field must be null (defaults from the other charge destination).

7

Account Number

Opt

I 6

Enter a value only if the Job Id and Charge To Asset Id are null; otherwise, this field must be null (defaults from the other charge destination). If included, must be a valid non-edit rule account number for the OU Id.

8

Charge To Fixed Asset Id

Opt

C 10

Enter a value only if the Job Id and OU Id are null. If you enter a value:

  • The Fixed Asset Id must be valid.

  • The Asset Expense Category is required.

  • The Job Id, Cost Type, Costcode, OU Id, and Account Number all must be null.

  • The OU Id defaults as the OU assigned to the asset.

9

Asset Expense Category

Opt

I 3

You must entry a value if the Charge To Asset Id value is not null; otherwise, this field must be null.

If included, enter a valid expense category for the Charge To Asset’s class. The account defaults from the account associated with this category at the asset class level.

10

Units Worked

Req

F 12.3

Units worked for the Distribution Date.

11

Unit of Measure

Req

C 5

Must be a valid unit of measure with a charge rate for this fixed asset.

12

Charge Code

Req

C! 1

Possible values are:

  • Y – Billable

  • N – Not billable

13

Override Unit Charge Rate

Opt

F 15.4

If included, PENTA uses this rate to calculate the charge amount. Otherwise, PENTA uses the charge rate defined for the asset/UM combination in the Asset Information window.

14

Override Amount

Opt

F 15.2

If included, this is the override charge amount. This value overrides the system-generated charge calculation (Units x Unit Charge Rate).

15

Work Status Code

Req

C! 1

Possible values are:

  • D – Down

  • S – Standby

  • W – Work

16

Change Order Id

Opt

X

A value in this field indicates that this charge relates to a specific change order. Include only if the Job Id is not null.

Values must be valid for the Job.

17

Contract Line Item Number

Opt

I 6

A value in this field indicates that this charge relates to a specific contract line item. Include only if the Job Id is not null.

Values must be valid for the line item Job.

Optional Header Detail Fields (place after Field 17)

Field

Format

Description

Field

Format

Description

LONG_DESCR

C 2000

Note or comment about an equipment timecard record, such as reasons for an override rate, or override cost distribution on the timecard.