Fields Updated by the System

This table lists the fields that the system updates. You should not complete these fields. If you do, the system overwrites the values entered. The system updates these fields in table F20112 when the credit card transaction is applied to an expense report.

Alias

Field Name

Type

Length

Definition

EXRPTTYP

Expense Report Type

Alpha

1

The expense report type that is assigned when the employee applies the credit card transaction to their expense report.

EXRPTNUM

Expense Report Number

Alpha

10

The number that the system assigns automatically to the expense report for tracking purposes.

The system assigns the number from the Next Numbers - Automatic table (F0002).

DTECRT

Expense Report Date Created

Date

6

The date that the expense report was created.

ENUMBER1

Expense Report Employee ID

Number

8

The employee ID for whom the expense report was created.

ETEXT001

Expense Report Workstation ID

Alpha

10

The ID of the workstation on which the expense report was created.

PID

Program ID

Alpha

10

The program number of the program that updated the record.

USER

User ID

Alpha

10

The ID of the user that updated the record.

JOBN

Work Station ID

Alpha

10

The ID of the computer that was used to update the record.

UPMT

Time - Last Updated

Number

6

The time that the record was updated.

UPMJ

Date - Updated

Date

6

The date that the record was updated.