| Batch |
| ColumnName | Batch |
| Definition | Name of the expense transaction data entry file. |
| MasterPKey |
| ColumnName | MasterPKey |
| Definition | Internal primary key. |
| Employee |
| ColumnName | Employee |
| Definition | Employee number. |
| ReportDate |
| ColumnName | ReportDate |
| Definition | Date of the expense report. |
| ReportName |
| ColumnName | ReportName |
| Definition | Name of the expense report. |
| Posted |
| ColumnName | Posted |
| Definition | Variable indicating whether the data entry file has been posted. |
| Seq |
| ColumnName | Seq |
| Definition | Sequence number for sorting data entry screen and transaction list. |
| AdvanceAmount |
| ColumnName | AdvanceAmount |
| Definition | The advance amount for the file. |
| BarCode |
| ColumnName | BarCode |
| Definition | Not used. |
| DefaultCurrencyCode |
| ColumnName | DefaultCurrencyCode |
| Definition | The default transaction currency code to use in the data entry file. |
| PaymentExchangeOverrideMethod |
| ColumnName | PaymentExchangeOverrideMethod |
| Definition | Variable indicating the transaction and payment currency exchange override. Valid options are N - none; D - date; and R - rate. |
| PaymentExchangeOverrideDate |
| ColumnName | PaymentExchangeOverrideDate |
| Definition | The date to be used when the PaymentExchangeOverrideMethod is Date. |
| PaymentExchangeOverrideRate |
| ColumnName | PaymentExchangeOverrideRate |
| Definition | The rate to be used when the PaymentExchangeOverrideMethod is Rate. |
| CurrencyExchangeOverrideMethod |
| ColumnName | CurrencyExchangeOverrideMethod |
| Definition | For all detail associated with this expense, the exchange override method for converting the transaction currency to the functional currency of the active company. Valid options are N - none (that is, no override - apply the standard currency exchange); D - date; R - rate. |
| CurrencyExchangeOverrideDate |
| ColumnName | CurrencyExchangeOverrideDate |
| Definition | For all detail associated with this expense, the exchange override method for converting the transaction currency to the functional currency of the active company. Valid options are N - none (that is, no override - apply the standard currency exchange); D - date; R - rate. |
| CurrencyExchangeOverrideRate |
| ColumnName | CurrencyExchangeOverrideRate |
| Definition | For all detail associated with this voucher, the exchange rate for converting the transactional currency to the functional currency of the active company, when the exchange override method is Rate. |
| Status |
| ColumnName | Status |
| Definition | The value in the Status field on the transaction entry screen. |
| AuthorizedBy |
| ColumnName | AuthorizedBy |
| Definition | The employee who approved this transaction. |
| RejectReason |
| ColumnName | RejectReason |
| Definition | The rejection reason, if the Status is Rejected. |
| ModUser |
| ColumnName | ModUser |
| Definition | The user who modified this record. |
| ModDate |
| ColumnName | ModDate |
| Definition | The date and time when this record was modified. |