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: Record Type. 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
 

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 
Name: Pay Vendor ID. Description: The identifying vendor ID for this employee.
 

CODE1_CD 
ColumnName  CODE1_CD 
Definition 
Name: 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: 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: 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.