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