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