Equipment Movement Interface: Table Driven Method

Use the Equipment Movement Interface to load equipment transfer data files from external applications.

The Equipment Movement Interface has a Request Type of EQM and an Interface Type of N. Data files you load must have Request Types assigned to the N Interface Type.

Unlike other interfaces, the Equipment Movement Interfaces does not require a Header and Detail record. Instead, just include one detail record per equipment transfer.

Equipment transfer entries post immediately and are not subject to the approval process available through the Equipment Transfer Approval window.

System Option 128 (“Reject Interface File on Error”) affects this interface.

Limitations & Restrictions

If PENTA rejects a record, you cannot resubmit the file because a batch already exists for the file name and file type.

Where to View Loaded Data

You can review and modify interfaced data in the Equipment Transfer History window.

If necessary, you can make an adjusting entry by making a manual movement entry in PENTA or perform another interface process.

Available Tables

Equipment Movement Equipment Transfer Detail Record

The following information relates to the INTR_EQMOVE_DTL table.

Column

Entry

Format

Description

Column

Entry

Format

Description

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within interface request.

D_TRANSFER_DATE

Req

D

The first day the equipment is at the new location.

FA_ID

Req

X

Id of the piece of equipment/fixed asset you are transferring to a new location.

INCL_CHILDREN_CD

Opt

C! 1

Indicates (with a Y for yes or an N for no) whether to transfer all child assets if the asset is a parent asset. If you enter Y, PENTA creates transfer entries for all child assets.

Defaults as N if the Equipment Id is not a parent asset with at least one active child asset.

TO_YARD_NUM

Opt

I 3

Id of the yard where you are transferring equipment.

Either enter this value or a TO_JOB_ID, not both.

TO_JOB_ID

Opt

X

Id of the job where you are transferring equipment.

Either enter this value or a TO_YARD_NUM, not both.

TO_COST_TYPE_CD

Opt

C! 4

Id of the Cost Type where you charge the rental.

Defaults as the asset’s rental default Cost Type as of the Transfer Date if there is a valid To Job Id.

Do not enter a value if a TO_YARD_NUM exists.

Required if there is a TO_JOB_ID; otherwise, do not enter a value.

TO_CC

Opt

X

Id of the Costcode charged with a TO_JOB_ID transfer.

Defaults as the asset’s rental default Costcode, as of the Transfer Date if there is a valid To Job Id.

Do not enter a value if a TO_YARD_NUM exists.

Required if there is a TO_JOB_ID; otherwise, do not enter a value.

TO_EQ_WORK_STAT_
CD

Opt

C! 1

The status of the equipment upon completion of the transfer. Possible values are D (downtime) I (in transit), S (stand by), and W (working).

FA_PIECES

Opt

I 9

The number of pieces you are moving to the new location.

Defaults as 1 if the asset consists of a single unit.

Defaults as the quantity at current location, as of the Transfer Date if the asset is located at a single location and there are no From Location values (Yard, Job, Cost Type, Costcode, Work Status).

FR_YARD_NUM

Opt

I 3

Id of the equipment yard you are transferring the asset from.

Defaults as the current location’s Yard as of the Transfer Date if the asset is located at a single location and there are no From Location values (Yard, Job, Cost Type, Costcode, Work Status).

Required if the asset is multiple units assigned to multiple locations (either the From Yard or From Job).

Optional if the asset is a single unit or consists of multiple units where all units are at the same location.

FR_JOB_ID

Opt

X

Id of the Job from which equipment was transferred.

Defaults as the current location’s Job as of the Transfer Date if the asset is located at a single location and there are no From Location values (Yard, Job, Cost Type, Costcode, Work Status).

Required if the asset is multiple units which are assigned to multiple locations, either the From Yard or From Job.

Optional if the asset is a single unit or consists of multiple units where all units are at the same location.

FR_COST_TYPE_CD

Opt

C! 4

Id of the Cost Type charged with a FR_JOB_ID transfer.

Defaults as the current location’s Cost Type as of the Transfer Date if the asset is located at a single location and there are no From Location values (Yard, Job, Cost Type, Costcode, Work Status).

Required if a FR_JOB_ID exists; otherwise, do not enter a value.

FR_CC

Opt

X

Id of the Costcode charged with a FR_JOB_ID transfer.

Defaults as current location’s costcode as of the Transfer Date if the asset is located at a single location and there are no From Location values (Yard, Job, Cost Type, Costcode, Work Status).

Required if a FR_JOB_ID exists; otherwise, do not enter a value.

FR_EQ_WORK_STAT_
CD

Opt

C! 1

Status of the equipment at the time of transfer. Values are D (downtime) I (in transit), S (stand by), and W (working).

Defaults as the current location’s status as of the Transfer Date if the asset is located at a single location and there are no From Location values (Yard, Job, Cost Type, Costcode, Work Status).

Optional if the asset is a single unit or consists of multiple units where all units are at the same location.

Required if the asset consists of multiple units assigned to multiple locations; otherwise, do not enter a value.

EMP_ID

Opt

X

The employee authorizing the transfer.

Error occurs if the employee is invalid.

COMMENT_1

Opt

C 70

Comments regarding the equipment transfer.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.