exMaster 
Default Table Name  exMaster 
Definition  
Employee Expenses Table - Data Entry Master
 

exMaster Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Batch(PK)    nvarchar(30)  NO  
Name of the expense transaction data entry file.
 
MasterPKey(PK)    varchar(32)  NO  
Internal primary key.
 
Employee    nvarchar(20)  NO  
Employee number.
 
ReportDate    datetime  YES  
Date of the expense report.
 
ReportName    nvarchar(40)  NO  
Name of the expense report.
 
Posted    varchar(1)  NO  
Variable indicating whether the data entry file has been posted.
 
Seq    int  NO  
Sequence number for sorting data entry screen and transaction list.
 
AdvanceAmount    decimal(19, 4)  NO  
The advance amount for the file.
 
BarCode    nvarchar(20)  YES  
Not used.
 
DefaultCurrencyCode    nvarchar(3)  YES  
The default transaction currency code to use in the data entry file.
 
PaymentExchangeOverrideMethod    varchar(1)  NO  
Variable indicating the transaction and payment currency exchange override. Valid options are N - none; D - date; and R - rate.
 
PaymentExchangeOverrideDate    datetime  YES  
The date to be used when the PaymentExchangeOverrideMethod is Date.
 
PaymentExchangeOverrideRate    decimal(19, 10)  NO  
The rate to be used when the PaymentExchangeOverrideMethod is Rate.
 
CurrencyExchangeOverrideMethod    varchar(1)  NO  
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    datetime  YES  
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    decimal(19, 10)  NO  
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    varchar(1)  NO  
The value in the Status field on the transaction entry screen.
 
AuthorizedBy    nvarchar(20)  YES  
The employee who approved this transaction.
 
RejectReason    nvarchar(500)  YES  
The rejection reason, if the Status is Rejected.
 
ModUser    nvarchar(20)  YES  
The user who modified this record.
 
ModDate    datetime  YES  
The date and time when this record was modified.
 

exMaster Primary and Unique Keys 
Key Name  Key Type  Keys 
exMasterPK  PrimaryKey  Batch, MasterPKey 

exMaster Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication