Required Fields

To complete a task you must provide values for fields listed in this table.

Alias

Field Name

Type

Length

Description

CCTN

Credit Card Transaction Number

Alpha

20

A unique identifier for the credit card transaction.

You can use the transaction number assigned by the credit card company, devise your own unique key by concatenating the values of several fields, or use a next numbering routine.

The system uses this field as the primary key for locating and tracking credit card expenses. By assigning a unique value for each credit card expense, you eliminate the possibility of reimbursing the expense more than once.

The value that you specify should not exist in the F09E150 table.

EMPLOYID

Employee ID

Number

8

The address book number of the employee.

This field is required if the Credit Card Number field is blank. The system uses the employee ID in conjunction with the payment method specified to retrieve the credit card number from the Credit Card Information table (F0075).

CRCRDNUM

Credit Card Number

Alpha

25

The number of the employee's credit card.

This field is required if the Employee ID field is blank. The system uses the credit card number in conjunction with the payment method specified to retrieve the employee ID from the Credit Card Information table (F0075).

PMTMETH

Payment Method

Alpha

3

A user-defined code that corresponds to the payment method of the employee.

The value that you enter must exist in UDC 09E/PM.

TRANSTAT

Transaction Status

Alpha

2

A code that specifies that the transaction is available for processing.

Enter 0 (zero) for all transactions.

EXPDATE

Expense Date

Date

6

The date that the expense was incurred.

Enter the date in a format that the database accepts.

EXPAMT

Expense Amount

Number

15

The amount of the expense in the currency in which it was incurred.

Note: If you do not use multicurrency or if the amount is in the domestic currency, the expense amount should be the same as the billed amount.

EXPCRCD

Expense Currency Code

Alpha

3

The currency code of the expense amount.

The value that you specify must exist in the Currency Codes table (F0013).

This field is required only if multicurrency is turned on.

BILLAMT

Billed Amount

Number

15

The billed amount of the expense in the currency of the credit card company.

Note: If you do not use multicurrency or if the amount is in the domestic currency, the billed amount should be the same as the expense amount.

BILLCRCD

Billed Currency Code

Alpha

3

The currency code of the amount billed by the credit card company.

The value that you specify must exist in the Currency Codes table (F0013).

This field is required only if the multicurrency feature is active.