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