Import Equipment Costs from Text File - Field Descriptions

Use this table for reference when completing the fields on this screen.

Fields / Buttons

Descriptions

Transaction date

If a transaction date is specified in the import file, it must be within the current Equipment Control minimum/maximum processing date range, or it will be sent to the error report.

The transaction date must be in the format MM/DD/YY or YYYYMMDD. If this condition is not met it will be sent to the error report.

Batch

Enter the batch code to use if not specified in the import file. The default setting is the Operator's code.

Credit G/L account

Enter the Credit G/L account number to use if not specified in the import file, or press F4 to search for G/L accounts.

Remarks

Enter the remarks to use if not specified in the import file.

Continue button

Once you have selected an import file and specified any needed settings, click this button to start the import.

File Layout button

Click this button to view file layout settings for this update. No changes are allowed.

Variable

Type

Maximum Length

Transaction date

Date

8

Batch code

Alpha-numeric

10

Equipment code

Alpha-numeric

10

Cost category

Alpha-numeric

4

Quantity

Numeric

11

Fuel / oil code

Alpha-numeric

2

Amount

Numeric

11

G/L debit account

Alpha-numeric

12

G/L credit account

Alpha-numeric

12

Remarks

Alpha-numeric

30

Meter 1 reading

Numeric

7

Equipment work order

Alpha-numeric

10

Rate

Numeric

11

Credit cost center

Alpha-numeric

10