BATCH_ID |
ColumnName | BATCH_ID |
Definition | Name: Batch ID. Description: The ID of the batch of which this record is a member. The Batch ID defaults from user screen entry during the export process. |
EXP_RPT_ID |
ColumnName | EXP_RPT_ID |
Definition | Name: Expense Report ID. Description: The unique identifier for the expense report. |
PARENT_EXPENSE_ID |
ColumnName | PARENT_EXPENSE_ID |
Definition | Name: Parent Expense ID. Description: The expense ID of the expense if this expense was generated from it. |
EXPENSE_ID |
ColumnName | EXPENSE_ID |
Definition | Name: Expense ID. Description: The unique identifier for the expense. |
ALLOCATION_ID |
ColumnName | ALLOCATION_ID |
Definition | Name: Allocation ID. Description: Synthetic |
S_TYPE_CD |
ColumnName | S_TYPE_CD |
Definition | Name: Batch ID. Description: The type of record. The valid values are E – Expense. A – Advance. C – Credit |
S_CHARGE_TYPE_CD |
ColumnName | S_CHARGE_TYPE_CD |
Definition | Name: Charge Type. Description: Values are: NA – Not Applicable. UC – Under Ceiling. OC – Over Ceiling. U – Unallowable. T1 – Tax 1. T2 – Tax 2 |
VENDOR_ID |
ColumnName | VENDOR_ID |
Definition | Name: Vendor ID. Description: The identifying vendor ID for this employee. |
EMPL_ID |
ColumnName | EMPL_ID |
Definition | Name: Employee ID. Description: The employee whose expense report it is. |
LAST_NAME |
ColumnName | LAST_NAME |
Definition | Name: Last Name. Description: From the EMPL table. |
FIRST_NAME |
ColumnName | FIRST_NAME |
Definition | Name: First Name. Description: From the EMPL table. |
INITIAL_NAME |
ColumnName | INITIAL_NAME |
Definition | Name: Middle Initial. Description: From the EMPL table. |
EXP_RPT_DESC |
ColumnName | EXP_RPT_DESC |
Definition | Name: Expense Report Description. Description: Short description of the expense report. |
INVOICE_DT |
ColumnName | INVOICE_DT |
Definition | Name: Invoice Date. Description: System Assigned Invoice Date. |
EXP_RPT_DT |
ColumnName | EXP_RPT_DT |
Definition | Name: Expense Report Date. Description: User assigned date for expense report. |
PURPOSE_TEXT |
ColumnName | PURPOSE_TEXT |
Definition | Name: Purpose. Description: The purpose of the expenses on the report. |
EXP_RPT_TYPE_CD |
ColumnName | EXP_RPT_TYPE_CD |
Definition | Name: Expense Report Type. Description: The type of expense report. |
EXP_CLASS_CD |
ColumnName | EXP_CLASS_CD |
Definition | Name: Expense Class. Description: The expense class of the employee at the time of the expense report. |
CP_COMPANY_CD |
ColumnName | CP_COMPANY_CD |
Definition | Name: Costpoint Company. Description: Costpoint Company Code of expense report. (Employee) |
PAY_CURRENCY_CD |
ColumnName | PAY_CURRENCY_CD |
Definition | Name: Pay Currency. Description: The currency code of that the employee will be reimbursed in. |
BASE_CURRENCY_CD |
ColumnName | BASE_CURRENCY_CD |
Definition | Name: Base Currency. Description: The base currency code of the system. |
AP_1099_FL |
ColumnName | AP_1099_FL |
Definition | Name: 1099 Flag. Description: Logical as to whether this expense should be recorded as 1099 information |
AP_1099_TYPE_CD |
ColumnName | AP_1099_TYPE_CD |
Definition | Name: 1099 Type. Description: Type of 1099 expense. |
EXP_CATEGORY_CD |
ColumnName | EXP_CATEGORY_CD |
Definition | Name: Expense Category. Description: The category of the expense. |
EXP_TYPE_CD |
ColumnName | EXP_TYPE_CD |
Definition | Name: Expense Type. Description: The type of the expense. |
EXPENSE_DT |
ColumnName | EXPENSE_DT |
Definition | Name: Expense Date. Description: The date the expense was incurred. |
PROVIDER_CD |
ColumnName | PROVIDER_CD |
Definition | Name: Provider. Description: The provider of the service for the expense. |
EXPENSE_TEXT |
ColumnName | EXPENSE_TEXT |
Definition | Name: Expense Description. Description: Description of expense. |
PAY_METHOD_CD |
ColumnName | PAY_METHOD_CD |
Definition | Name: Pay Method. Description: User-specified unique identifier for the pay method |
TRANS_CURRENCY_CD |
ColumnName | TRANS_CURRENCY_CD |
Definition | Name: Transaction Currency. Description: The currency that the transaction was incurred in. |
USER_EXCHANGE_RATE |
ColumnName | USER_EXCHANGE_RATE |
Definition | Name: User Provided Exchange Rate. Description: The exchange rate the user provided. |
TRANS_PAY_EXCHANGE_RATE |
ColumnName | TRANS_PAY_EXCHANGE_RATE |
Definition | Name: Transaction to Pay Exchange Rate. Description: The exchange rate provided by the system to take transaction currency to pay currency. |
TRANS_BASE_EXCHANGE_RATE |
ColumnName | TRANS_BASE_EXCHANGE_RATE |
Definition | Name: Transaction to Base Exchange Rate. Description: The exchange rate provided by the system to take transaction currency to pay currency. |
UDT01_ID |
ColumnName | UDT01_ID |
Definition | Name: UDT01 ID. Description: The UDT01 identifier for the line. |
UDT02_ID |
ColumnName | UDT02_ID |
Definition | Name: UDT02 ID. Description: The UDT02 identifier for the line. |
UDT03_ID |
ColumnName | UDT03_ID |
Definition | Name: UDT03 ID. Description: The UDT03 identifier for the line. |
UDT04_ID |
ColumnName | UDT04_ID |
Definition | Name: UDT04 ID. Description: The UDT04 identifier for the line. |
UDT05_ID |
ColumnName | UDT05_ID |
Definition | Name: UDT05 ID. Description: The UDT05 identifier for the line. |
UDT06_ID |
ColumnName | UDT06_ID |
Definition | Name: UDT06 ID. Description: The UDT06 identifier for the line. |
UDT07_ID |
ColumnName | UDT07_ID |
Definition | Name: UDT07 ID. Description: The UDT07 identifier for the line. |
UDT08_ID |
ColumnName | UDT08_ID |
Definition | Name: UDT08 ID. Description: The UDT08 identifier for the line. |
UDT09_ID |
ColumnName | UDT09_ID |
Definition | Name: UDT09 ID. Description: The UDT09 identifier for the line. |
UDT10_ID |
ColumnName | UDT10_ID |
Definition | Name: UDT10 ID. Description: The UDT10 identifier for the line. |
UDT06_CP_COMPANY_CD |
ColumnName | UDT06_CP_COMPANY_CD |
Definition | Name: UDT06 Costpoint Company. Description: Costpoint Company Code for UDT06_ID field. |
UDT07_CP_COMPANY_CD |
ColumnName | UDT07_CP_COMPANY_CD |
Definition | Name: UDT07 Costpoint Company. Description: Costpoint Company Code for UDT07_ID field. |
EXPENSE_REF_CD |
ColumnName | EXPENSE_REF_CD |
Definition | Name: Expense Reference. Description: User defined reference code. |
TRANS_AMT |
ColumnName | TRANS_AMT |
Definition | Name: Transaction Amount. Description: The amount in transaction currency. |
PAY_AMT |
ColumnName | PAY_AMT |
Definition | Name: Pay Amount. Description: The amount in pay currency |
BASE_AMT |
ColumnName | BASE_AMT |
Definition | Name: Base Amount. Description: The amount in system base currency. |
PAY_VENDOR_ID |
ColumnName | PAY_VENDOR_ID |
Definition |
UDT01_ABBRV_ID |
ColumnName | UDT01_ABBRV_ID |
Definition | Name: UDT01 Abbreviation ID. Description: Abbreviation for UDT01. |
UDT02_ABBRV_ID |
ColumnName | UDT02_ABBRV_ID |
Definition | Name: UDT02 Abbreviation ID. Description: Abbreviation for UDT02. |
UDT09_ABBRV_ID |
ColumnName | UDT09_ABBRV_ID |
Definition | Name: UDT09 Abbreviation ID. Description: Abbreviation for UDT09. |
CODE1_CD |
ColumnName | CODE1_CD |
Definition | Name: Expense Type User Defined Code 1. Description: The Code1 user defined field. The values are based on the expense type. |
CODE2_CD |
ColumnName | CODE2_CD |
Definition | Name: Expense Type User Defined Code 2. Description: The Code2 user defined field. The values are based on the expense type. |
CODE3_CD |
ColumnName | CODE3_CD |
Definition | Name: Expense Type User Defined Code 3. Description: The Code3 user defined field. The values are based on the expense type. |
COMMENTS_TEXT |
ColumnName | COMMENTS_TEXT |
Definition | Name: Comments. Description: The User Comments about expense. |
TAX_SCHEDULE_CD |
ColumnName | TAX_SCHEDULE_CD |
Definition | Name: Tax Schedule. Description: The tax schedule unique identifier |
TAX_LOCATION_S |
ColumnName | TAX_LOCATION_S |
Definition | Name: Tax Location. Description: The location used in tax schedule. |
TAX_ID_S |
ColumnName | TAX_ID_S |
Definition | Name: Tax ID. Description: The tax id of provider of service or goods. |
TRANS_TAX_AMT |
ColumnName | TRANS_TAX_AMT |
Definition | Name: Transaction Tax Amount. Description: The combined total of tax amounts in transaction currency. |
PAY_TAX_AMT |
ColumnName | PAY_TAX_AMT |
Definition | Name: Pay Tax Amount. Description: The combined total of tax amounts in pay currency. |
BASE_TAX_AMT |
ColumnName | BASE_TAX_AMT |
Definition | Name: Base Tax Amount. Description: The combined total of tax amounts in base currency. |
TAX_RECOVERY_RATE1_PCT |
ColumnName | TAX_RECOVERY_RATE1_PCT |
Definition | Name: Tax Rate 1 Recovery Percentage. Description: The recovery percentage for the rate1 tax. |
TAX_RECOVERY_RATE2_PCT |
ColumnName | TAX_RECOVERY_RATE2_PCT |
Definition | Name: Tax Rate 2 Recovery Percentage. Description: The recovery percentage for the rate 2 tax. |
TRANS_TAX_RECOVERY_RATE1_AMT |
ColumnName | TRANS_TAX_RECOVERY_RATE1_AMT |
Definition | Name: Tax Rate 1 Recovery Transaction Amount. Description: The amount of rate 1 tax that is recoverable in transaction currency. |
TRANS_TAX_RECOVERY_RATE2_AMT |
ColumnName | TRANS_TAX_RECOVERY_RATE2_AMT |
Definition | Name: Tax Rate 2 Recovery Transaction Amount. Description: The amount of rate 2 tax that is recoverable in transaction currency. |
PAY_TAX_RECOVERY_RATE1_AMT |
ColumnName | PAY_TAX_RECOVERY_RATE1_AMT |
Definition | Name: Tax Rate 1 Recovery Pay Amount. Description: The amount of rate 1 tax that is recoverable in pay currency. |
PAY_TAX_RECOVERY_RATE2_AMT |
ColumnName | PAY_TAX_RECOVERY_RATE2_AMT |
Definition | Name: Tax Rate 2 Recovery Pay Amount. Description: The amount of rate 2 tax that is recoverable in pay currency. |
BASE_TAX_RECOVERY_RATE1_AMT |
ColumnName | BASE_TAX_RECOVERY_RATE1_AMT |
Definition | Name: Tax Rate 1 Recovery Base Amount. Description: The amount of rate 1 tax that is recoverable in base currency. |
BASE_TAX_RECOVERY_RATE2_AMT |
ColumnName | BASE_TAX_RECOVERY_RATE2_AMT |
Definition | Name: Tax Rate 2 Recovery Base Amount. Description: The amount of rate 2 tax that is recoverable in base currency. |
UDT11_ID |
ColumnName | UDT11_ID |
Definition | Name: UDT11 ID. Description: The UDT11 identifier for the line. |
UDT12_ID |
ColumnName | UDT12_ID |
Definition | Name: UDT12 ID. Description: The UDT12 identifier for the line. |
UDT13_ID |
ColumnName | UDT13_ID |
Definition | Name: UDT13 ID. Description: The UDT13 identifier for the line. |
UDT14_ID |
ColumnName | UDT14_ID |
Definition | Name: UDT14 ID. Description: The UDT14 identifier for the line. |
UDT15_ID |
ColumnName | UDT15_ID |
Definition | Name: UDT15 ID. Description: The UDT15 identifier for the line. |
CORRECTION_NO |
ColumnName | CORRECTION_NO |
Definition | Name: Correction Number. Description: The current correction number of the expense report. |