Travel in Process
Import Specification: Travel In Process
Table Name: TransactionsTravelInProcess
Table Type: Reporting
Current Import Version: 1.0
Data Specification
|
Field Name |
Requires Value? |
Max Length |
Related Table |
Precision |
|
|
TaskCode |
String |
Yes |
50 |
|
|
|
EmployeeCode |
String |
No |
50 |
|
|
|
Purpose |
String |
No |
300 |
|
|
|
DepartureDate |
Date |
No |
- |
|
|
|
ReturnDate |
Date |
No |
- |
|
|
|
Dollars |
Decimal |
Yes |
- |
|
2 |
|
Custom1 |
String |
No |
100 |
|
|
|
Custom2 |
String |
No |
100 |
|
|
|
Custom3 |
String |
No |
100 |
|
|
|
Custom4 |
String |
No |
100 |
|
|
|
Custom5 |
String |
No |
100 |
|
|
|
SourceTransactionID |
String |
No |
100 |
|
|
Available Import Header Commands
- Overwrite
- Append *
- ReplaceByKey
- Available Fields
- TaskCode
* This is the default behavior for file import processing of this table.
Page ID:7426-9353-8910