COMPANY_ID 
ColumnName  COMPANY_ID 
Definition 
Name: Record Key. Description: The Company ID for this configuration record.
 

S_LINE_APPROVE_CD 
ColumnName  S_LINE_APPROVE_CD 
Definition 
Name: Charge Level Approval Option. Description: The type of line level approval configured for the Deltek Time/Deltek Expense system. The valid options are as follows:DISABLED – Disabled. REQUIRED – Required. OPTIONAL – Optional. 
 

S_EXPORT_MODE_CD 
ColumnName  S_EXPORT_MODE_CD 
Definition 
Name: ER Export Mode Option. Description: Determines if expense reports are exported when status changes or via export batch process. The valid values are:T – Transaction. B – Batch. 
 

MODIFIED_BY 
ColumnName  MODIFIED_BY 
Definition 
Name: Modified By. Description: The User ID of the person who last modified this record.
 

ROWVERSION 
ColumnName  ROWVERSION 
Definition 
Name: Row Version . Description: The number of times this record has been updated.
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
Name: Time Stamp. Description: Date and time the record was last modified.
 

S_FOREIGN_REIMBURSE_CD 
ColumnName  S_FOREIGN_REIMBURSE_CD 
Definition 
Name: Foreign Currency Reimbursement Mode. Description: Determines whether converted foreign currency amounts are exactly what the employee will be paid or just an estimate. The valid values are:EST – Estimate. ACT - Actual. 
 

DFLT_EXPENSE_NO 
ColumnName  DFLT_EXPENSE_NO 
Definition 
Name: Default Numbr of ER Desktop Display. Description: The default employee preference value when employee records are added.
 

LAST_EXPENSE_REPORT_NO_S 
ColumnName  LAST_EXPENSE_REPORT_NO_S 
Definition 
Name: Last Expense Report ID. Description: The last expense report number assigned in the system.
 

DFLT_EXP_CLASS_CD 
ColumnName  DFLT_EXP_CLASS_CD 
Definition 
Name: Default Expense Class. Description: Expense Class that will be used as a default when setting up new employees.
 

S_EXP_RPT_UDT_CD 
ColumnName  S_EXP_RPT_UDT_CD 
Definition 
Name: ER Header UDT Option. Description: Identifies the UDT that will show on the header portion of the expense report. Valid options are:NONE. UDT01 to UDT15. 
 

S_INVOICE_DATE_CD 
ColumnName  S_INVOICE_DATE_CD 
Definition 
Name: AP Invoice Date Option. Description: Determines the invoice date that will be supplied on Accounts Payable vouchers when expense reports are exported. Valid values are:EXPORT = Export Date.. SUBMIT = Submit Date.. REPORT = Expense Report Date.. 
 

AGING_COLUMN2_FROM_DAYS_NO 
ColumnName  AGING_COLUMN2_FROM_DAYS_NO 
Definition 
Name: Aging Column 2 From Days. Description: The starting number of days for the second aging column.
 

AGING_COLUMN2_TO_DAYS_NO 
ColumnName  AGING_COLUMN2_TO_DAYS_NO 
Definition 
Name: Aging Column 2 To Days. Description: The ending number of days for the second aging column.
 

AGING_COLUMN3_FROM_DAYS_NO 
ColumnName  AGING_COLUMN3_FROM_DAYS_NO 
Definition 
Name: Aging Column 3 From Days. Description: The starting number of days for the third aging column.
 

AGING_COLUMN3_TO_DAYS_NO 
ColumnName  AGING_COLUMN3_TO_DAYS_NO 
Definition 
Name: Aging Column 3 To Days. Description: The ending number of days for the third aging column.
 

AGING_COLUMN4_FROM_DAYS_NO 
ColumnName  AGING_COLUMN4_FROM_DAYS_NO 
Definition 
Name: Aging Column 4 From Days. Description: The starting number of days for the fourth aging column.
 

AGING_COLUMN4_TO_DAYS_NO 
ColumnName  AGING_COLUMN4_TO_DAYS_NO 
Definition 
Name: Aging Column 4 To Days. Description: The ending number of days for the fourth aging column.
 

RECEIPT_STORAGE_LOCATION_S 
ColumnName  RECEIPT_STORAGE_LOCATION_S 
Definition 
Name: Receipt Image Storage Location. Description: The location for receipt images.
 

S_RECEIPT_IMAGING_CD 
ColumnName  S_RECEIPT_IMAGING_CD 
Definition 
Name: Receipt Image Option. Description: Determines whether or not receipt imaging will be used on expense reports. Valid values are:NONE – None. STD - Standard. 
 

ALLOW_UNAUTH_CHARGE_FL 
ColumnName  ALLOW_UNAUTH_CHARGE_FL 
Definition 
Name: Allow Unauthorized Chages Flag. Description: Logical to indicate whether employees are allowed to charge to unauthorized charges on their expense reports.
 

OVERRIDE_UDT09_FL 
ColumnName  OVERRIDE_UDT09_FL 
Definition 
Name: Override UDT09 ID Flag. Description: Logical as to whether the user can override the provided UDT09 for the entire expense report.
 

LAST_EXP_AUTH_NO_S 
ColumnName  LAST_EXP_AUTH_NO_S 
Definition 
Name: Last Expense Authorization ID. Description: The last expense authorization number assigned in the system.
 

EXP_AUTH_TOLERANCE_PCT 
ColumnName  EXP_AUTH_TOLERANCE_PCT 
Definition 
Name: Expense Authorization Tolerance Percentage. Description: Amount an expense report can exceed the expense authorization by without requiring approvals to be done again.
 

DFLT_AUTH_NO 
ColumnName  DFLT_AUTH_NO 
Definition 
Name: Default Numbr of EA Desktop Display. Description: The default employee authorization preference value when employee records are added.
 

EXPORT_BASE_CURRENCY_FL 
ColumnName  EXPORT_BASE_CURRENCY_FL 
Definition 
Name: Export Base Currency Only Flag. Description: Logical as to whether expense report should only export base currency amounts.
 

S_DFLT_UDT09_CD 
ColumnName  S_DFLT_UDT09_CD 
Definition 
Name: Default UDT09 ID Option. Description: Indicates how UDT09 should be defaulted for charge allocation page in general wizard. The valid values are:E – Employee. 1 – UDT02 User Define #1. 2 – UDT02 User Define #2. 3 – UDT02 User Define #3. N - None. 
 

OVERRIDE_DFLT_UDT09_FL 
ColumnName  OVERRIDE_DFLT_UDT09_FL 
Definition 
Name: Override Default UDT09 ID Flag. Description: Logical as to whether user can override the default UDT09 calculated in charge allocation page within expense wizard.
 

GATHER_RECEIPT_INFO_FL 
ColumnName  GATHER_RECEIPT_INFO_FL 
Definition 
Name: Gather Receipt Info on Sign Flag. Description: Logical as to whether employee is asked about receipts when ER is signed.
 

S_DUE_COMPANY_CD 
ColumnName  S_DUE_COMPANY_CD 
Definition 
Name: Company Due Option. Description: Indicates how net due company expense reports are handled. The valid values are as follows:N – Negative Voucher. R – Receivable. P – Gather Payment Info. 
 

CASH_PAYMENT_FL 
ColumnName  CASH_PAYMENT_FL 
Definition 
Name: Cash Payment Flag. Description: Logical as to whether cash payment for due company is allowed.
 

CHECK_PAYMENT_FL 
ColumnName  CHECK_PAYMENT_FL 
Definition 
Name: Check Payment Flag. Description: Logical as to whether check payment for due company is allowed.
 

PAYROLL_DED_PAYMENT_FL 
ColumnName  PAYROLL_DED_PAYMENT_FL 
Definition 
Name: Payroll Deduction Flag. Description: Logical as to whether check payment for due company is allowed.
 

OTHER_PAYMENT_FL 
ColumnName  OTHER_PAYMENT_FL 
Definition 
Name: Other Payment Flag. Description: Logical as to whether other form of payment for due company is allowed.
 

PRINT_VOUCHER_DIST_FL 
ColumnName  PRINT_VOUCHER_DIST_FL 
Definition 
Name: Print Voucher Distribution Flag. Description: Logical as to whether voucher distribution should be printed as part of ER summary page.
 

S_EXPENSE_EXPORT_CD 
ColumnName  S_EXPENSE_EXPORT_CD 
Definition 
Name: Expense Export Option. Description: Indicates the type of expense export. The valid values areCOSTPOINT5X. GCS. NONE. 
 

EXPORT_TAXES_FL 
ColumnName  EXPORT_TAXES_FL 
Definition 
Name: Export Taxes Flag. Description: Logical as to whether taxes are exported.
 

TRAVELER_LOCATION_S 
ColumnName  TRAVELER_LOCATION_S 
Definition 
Name: Receipt Image Drop Off Location. Description: The location for Receipt Travelers to be processed.
 

TRAVELER_REJECT_LOCATION_S 
ColumnName  TRAVELER_REJECT_LOCATION_S 
Definition 
Name: Receipt Image Rejection Location. Description: The location where Receipts Travelers that are rejected will be placed.
 

S_IMAGE_EXAMINE_LEVEL_CD 
ColumnName  S_IMAGE_EXAMINE_LEVEL_CD 
Definition 
Name: Receipt Image Barcode Examination Level. Description: The level of examination the system will do for receipt image PDFs. The valid values are 1 to 5 with one being the lowest level of examination.
 

HIDE_VOIDED_ER_FL 
ColumnName  HIDE_VOIDED_ER_FL 
Definition 
Name: Hide Voided Expense Reports Flag. Description: Logical as to whether voided ER’s should be visible on the application desktop.
 

HIDE_VOIDED_EA_FL 
ColumnName  HIDE_VOIDED_EA_FL 
Definition 
Name: Hide Voided Expense Authorizations Flag. Description: Logical as to whether voided EA’s should be visible on the application desktop.
 

REMOVE_IMAGE_TASK_FL 
ColumnName  REMOVE_IMAGE_TASK_FL 
Definition 
Name: Revision Remove Image Task Flag. Description: Logical as to whether image receipts task shall be removed on revision.
 

S_FILE_DELIMITER_CD 
ColumnName  S_FILE_DELIMITER_CD 
Definition 
Name: File Delimiter. Description: File delimiter type for exporting expense files.
 

S_COMMIT_EXP_AUTH_CD 
ColumnName  S_COMMIT_EXP_AUTH_CD 
Definition 
Name: Commit Expense Authorization Code Description: Minimum status for including expense authorizations in commitments.
 

S_COMMIT_EXP_RPT_CD 
ColumnName  S_COMMIT_EXP_RPT_CD 
Definition 
Name: Commit Expense Report Code Description: Minimum status for including expense reports in commitments.