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 |
---|---|---|---|
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_ | 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_ | 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. |