TRAVEL EXPENSE CONTROL Table
View exposing travel expense batch control totals including Concur batch identifier, batch file date, file record count, total journal amount, and warehouse load date.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BATCH_FILE_DATE |
Date associated with the batch file. |
DATE |
|
CONCUR_BATCH_ID |
Unique identifier for the Concur expense batch. |
VARCHAR2 |
13 |
FILE_RECORD_COUNT |
Number of records included in the batch file. |
NUMBER |
34 |
TOTAL_JOURNAL_AMOUNT |
Total journal amount represented by the batch. |
NUMBER |
34 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |