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 ERs 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 EAs 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. |