EXP_CONFIG 
Default Table Name  EXP_CONFIG 
Definition 
 Name: Expense Configuration Settings.     Description: This table contains the system’s overall expense settings.
 

EXP_CONFIG Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
COMPANY_ID(PK)(FK)    VARCHAR(10)  NO 
Name: Record Key. Description: The Company ID for this configuration record.
 
S_LINE_APPROVE_CD    VARCHAR(10)  NO 
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    VARCHAR(1)  NO 
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    VARCHAR(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMERIC(10, 0)  NO 
Name: Row Version . Description: The number of times this record has been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time the record was last modified.
 
S_FOREIGN_REIMBURSE_CD    VARCHAR(3)  NO 
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    NUMERIC(10, 0)  NO 
Name: Default Numbr of ER Desktop Display. Description: The default employee preference value when employee records are added.
 
LAST_EXPENSE_REPORT_NO_S    VARCHAR(10)  NO 
Name: Last Expense Report ID. Description: The last expense report number assigned in the system.
 
DFLT_EXP_CLASS_CD(FK)    VARCHAR(20)  NO 
Name: Default Expense Class. Description: Expense Class that will be used as a default when setting up new employees.
 
S_EXP_RPT_UDT_CD    VARCHAR(5)  NO 
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    VARCHAR(6)  NO 
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    NUMERIC(10, 0)  NO 
Name: Aging Column 2 From Days. Description: The starting number of days for the second aging column.
 
AGING_COLUMN2_TO_DAYS_NO    NUMERIC(10, 0)  NO 
Name: Aging Column 2 To Days. Description: The ending number of days for the second aging column.
 
AGING_COLUMN3_FROM_DAYS_NO    NUMERIC(10, 0)  NO 
Name: Aging Column 3 From Days. Description: The starting number of days for the third aging column.
 
AGING_COLUMN3_TO_DAYS_NO    NUMERIC(10, 0)  NO 
Name: Aging Column 3 To Days. Description: The ending number of days for the third aging column.
 
AGING_COLUMN4_FROM_DAYS_NO    NUMERIC(10, 0)  NO 
Name: Aging Column 4 From Days. Description: The starting number of days for the fourth aging column.
 
AGING_COLUMN4_TO_DAYS_NO    NUMERIC(10, 0)  NO 
Name: Aging Column 4 To Days. Description: The ending number of days for the fourth aging column.
 
RECEIPT_STORAGE_LOCATION_S    VARCHAR(254)  YES 
Name: Receipt Image Storage Location. Description: The location for receipt images.
 
S_RECEIPT_IMAGING_CD    VARCHAR(5)  NO 
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    VARCHAR(1)  NO 
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    VARCHAR(1)  NO 
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    VARCHAR(10)  NO 
Name: Last Expense Authorization ID. Description: The last expense authorization number assigned in the system.
 
EXP_AUTH_TOLERANCE_PCT    NUMERIC(3, 2)  NO 
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    NUMERIC(10, 0)  NO 
Name: Default Numbr of EA Desktop Display. Description: The default employee authorization preference value when employee records are added.
 
EXPORT_BASE_CURRENCY_FL    VARCHAR(1)  YES 
Name: Export Base Currency Only Flag. Description: Logical as to whether expense report should only export base currency amounts.
 
S_DFLT_UDT09_CD    VARCHAR(1)  NO 
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    VARCHAR(1)  NO 
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    VARCHAR(1)  NO 
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    VARCHAR(1)  NO 
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    VARCHAR(1)  NO 
Name: Cash Payment Flag. Description: Logical as to whether cash payment for due company is allowed.
 
CHECK_PAYMENT_FL    VARCHAR(1)  NO 
Name: Check Payment Flag. Description: Logical as to whether check payment for due company is allowed.
 
PAYROLL_DED_PAYMENT_FL    VARCHAR(1)  NO 
Name: Payroll Deduction Flag. Description: Logical as to whether check payment for due company is allowed.
 
OTHER_PAYMENT_FL    VARCHAR(1)  NO 
Name: Other Payment Flag. Description: Logical as to whether other form of payment for due company is allowed.
 
PRINT_VOUCHER_DIST_FL    VARCHAR(1)  NO 
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    VARCHAR(20)  NO 
Name: Expense Export Option. Description: Indicates the type of expense export. The valid values areCOSTPOINT5X. GCS. NONE. 
 
EXPORT_TAXES_FL    VARCHAR(1)  NO 
Name: Export Taxes Flag. Description: Logical as to whether taxes are exported.
 
TRAVELER_LOCATION_S    VARCHAR(254)  YES 
Name: Receipt Image Drop Off Location. Description: The location for Receipt Travelers to be processed.
 
TRAVELER_REJECT_LOCATION_S    VARCHAR(254)  YES 
Name: Receipt Image Rejection Location. Description: The location where Receipts Travelers that are rejected will be placed.
 
S_IMAGE_EXAMINE_LEVEL_CD    VARCHAR(1)  NO 
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    VARCHAR(1)  NO 
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    VARCHAR(1)  NO 
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    VARCHAR(1)  NO 
Name: Revision Remove Image Task Flag. Description: Logical as to whether image receipts task shall be removed on revision.
 
S_FILE_DELIMITER_CD    VARCHAR(20)  NO 
Name: File Delimiter. Description: File delimiter type for exporting expense files.
 
S_COMMIT_EXP_AUTH_CD    VARCHAR(1)  NO 
Name: Commit Expense Authorization Code Description: Minimum status for including expense authorizations in commitments.
 
S_COMMIT_EXP_RPT_CD    VARCHAR(1)  NO 
Name: Commit Expense Report Code Description: Minimum status for including expense reports in commitments.
 

EXP_CONFIG Keys 
Key Name  Key Type  Keys 
RI_F00201  Inversion Entry  DFLT_EXP_CLASS_CD 
PI_0163  PrimaryKey  COMPANY_ID 

EXP_CONFIG Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
COMPANY  Identifying  One To Zero or More        COMPANY_ID  NO 
EXP_CLASS  Non-Identifying  One To Zero or More        DFLT_EXP_CLASS_CD  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
EXP_CONFIG_LABELS  Identifying  One To Zero or More          NO 
EXP_CONFIG_UDT  Identifying  One To Zero or More          NO