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.