Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
BATCH_ID |
|
VARCHAR(10) |
NO |
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 |
|
VARCHAR(10) |
NO |
Name: Expense Report ID. Description: The unique identifier for the expense report. |
PARENT_EXPENSE_ID |
|
NUMERIC(10, 0) |
NO |
Name: Parent Expense ID. Description: The expense ID of the expense if this expense was generated from it. |
EXPENSE_ID |
|
NUMERIC(10, 0) |
NO |
Name: Expense ID. Description: The unique identifier for the expense. |
ALLOCATION_ID |
|
NUMERIC(10, 0) |
NO |
Name: Allocation ID. Description: Synthetic |
S_TYPE_CD |
|
VARCHAR(1) |
NO |
Name: Batch ID. Description: The type of record. The valid values are E – Expense. A – Advance. C – Credit |
S_CHARGE_TYPE_CD |
|
VARCHAR(2) |
NO |
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 |
|
VARCHAR(20) |
NO |
Name: Vendor ID. Description: The identifying vendor ID for this employee. |
EMPL_ID |
|
VARCHAR(20) |
NO |
Name: Employee ID. Description: The employee whose expense report it is. |
LAST_NAME |
|
VARCHAR(30) |
NO |
Name: Last Name. Description: From the EMPL table. |
FIRST_NAME |
|
VARCHAR(30) |
NO |
Name: First Name. Description: From the EMPL table. |
INITIAL_NAME |
|
VARCHAR(1) |
YES |
Name: Middle Initial. Description: From the EMPL table. |
EXP_RPT_DESC |
|
VARCHAR(30) |
NO |
Name: Expense Report Description. Description: Short description of the expense report. |
INVOICE_DT |
|
DATE |
NO |
Name: Invoice Date. Description: System Assigned Invoice Date. |
EXP_RPT_DT |
|
DATE |
NO |
Name: Expense Report Date. Description: User assigned date for expense report. |
PURPOSE_TEXT |
|
VARCHAR(4000) |
YES |
Name: Purpose. Description: The purpose of the expenses on the report. |
EXP_RPT_TYPE_CD |
|
VARCHAR(10) |
NO |
Name: Expense Report Type. Description: The type of expense report. |
EXP_CLASS_CD |
|
VARCHAR(20) |
NO |
Name: Expense Class. Description: The expense class of the employee at the time of the expense report. |
CP_COMPANY_CD |
|
VARCHAR(10) |
NO |
Name: Costpoint Company. Description: Costpoint Company Code of expense report. (Employee) |
PAY_CURRENCY_CD |
|
VARCHAR(3) |
NO |
Name: Pay Currency. Description: The currency code of that the employee will be reimbursed in. |
BASE_CURRENCY_CD |
|
VARCHAR(3) |
NO |
Name: Base Currency. Description: The base currency code of the system. |
AP_1099_FL |
|
VARCHAR(1) |
NO |
Name: 1099 Flag. Description: Logical as to whether this expense should be recorded as 1099 information |
AP_1099_TYPE_CD |
|
VARCHAR(6) |
YES |
Name: 1099 Type. Description: Type of 1099 expense. |
EXP_CATEGORY_CD |
|
VARCHAR(10) |
NO |
Name: Expense Category. Description: The category of the expense. |
EXP_TYPE_CD |
|
VARCHAR(10) |
NO |
Name: Expense Type. Description: The type of the expense. |
EXPENSE_DT |
|
DATE |
NO |
Name: Expense Date. Description: The date the expense was incurred. |
PROVIDER_CD |
|
VARCHAR(20) |
YES |
Name: Provider. Description: The provider of the service for the expense. |
EXPENSE_TEXT |
|
VARCHAR(120) |
YES |
Name: Expense Description. Description: Description of expense. |
PAY_METHOD_CD |
|
VARCHAR(10) |
NO |
Name: Pay Method. Description: User-specified unique identifier for the pay method |
TRANS_CURRENCY_CD |
|
VARCHAR(3) |
NO |
Name: Transaction Currency. Description: The currency that the transaction was incurred in. |
USER_EXCHANGE_RATE |
|
NUMERIC(20, 10) |
NO |
Name: User Provided Exchange Rate. Description: The exchange rate the user provided. |
TRANS_PAY_EXCHANGE_RATE |
|
NUMERIC(20, 10) |
NO |
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 |
|
NUMERIC(20, 10) |
NO |
Name: Transaction to Base Exchange Rate. Description: The exchange rate provided by the system to take transaction currency to pay currency. |
UDT01_ID |
|
VARCHAR(50) |
YES |
Name: UDT01 ID. Description: The UDT01 identifier for the line. |
UDT02_ID |
|
VARCHAR(50) |
YES |
Name: UDT02 ID. Description: The UDT02 identifier for the line. |
UDT03_ID |
|
VARCHAR(20) |
YES |
Name: UDT03 ID. Description: The UDT03 identifier for the line. |
UDT04_ID |
|
VARCHAR(20) |
YES |
Name: UDT04 ID. Description: The UDT04 identifier for the line. |
UDT05_ID |
|
VARCHAR(20) |
YES |
Name: UDT05 ID. Description: The UDT05 identifier for the line. |
UDT06_ID |
|
VARCHAR(20) |
YES |
Name: UDT06 ID. Description: The UDT06 identifier for the line. |
UDT07_ID |
|
VARCHAR(20) |
YES |
Name: UDT07 ID. Description: The UDT07 identifier for the line. |
UDT08_ID |
|
VARCHAR(20) |
YES |
Name: UDT08 ID. Description: The UDT08 identifier for the line. |
UDT09_ID |
|
VARCHAR(20) |
YES |
Name: UDT09 ID. Description: The UDT09 identifier for the line. |
UDT10_ID |
|
VARCHAR(20) |
YES |
Name: UDT10 ID. Description: The UDT10 identifier for the line. |
UDT06_CP_COMPANY_CD |
|
VARCHAR(10) |
YES |
Name: UDT06 Costpoint Company. Description: Costpoint Company Code for UDT06_ID field. |
UDT07_CP_COMPANY_CD |
|
VARCHAR(10) |
YES |
Name: UDT07 Costpoint Company. Description: Costpoint Company Code for UDT07_ID field. |
EXPENSE_REF_CD |
|
VARCHAR(20) |
YES |
Name: Expense Reference. Description: User defined reference code. |
TRANS_AMT |
|
NUMERIC(15, 5) |
NO |
Name: Transaction Amount. Description: The amount in transaction currency. |
PAY_AMT |
|
NUMERIC(15, 5) |
NO |
Name: Pay Amount. Description: The amount in pay currency |
BASE_AMT |
|
NUMERIC(15, 5) |
NO |
Name: Base Amount. Description: The amount in system base currency. |
PAY_VENDOR_ID |
|
VARCHAR(20) |
YES |
|
UDT01_ABBRV_ID |
|
VARCHAR(20) |
YES |
Name: UDT01 Abbreviation ID. Description: Abbreviation for UDT01. |
UDT02_ABBRV_ID |
|
VARCHAR(20) |
YES |
Name: UDT02 Abbreviation ID. Description: Abbreviation for UDT02. |
UDT09_ABBRV_ID |
|
VARCHAR(20) |
YES |
Name: UDT09 Abbreviation ID. Description: Abbreviation for UDT09. |
CODE1_CD |
|
VARCHAR(20) |
YES |
Name: Expense Type User Defined Code 1. Description: The Code1 user defined field. The values are based on the expense type. |
CODE2_CD |
|
VARCHAR(20) |
YES |
Name: Expense Type User Defined Code 2. Description: The Code2 user defined field. The values are based on the expense type. |
CODE3_CD |
|
VARCHAR(20) |
YES |
Name: Expense Type User Defined Code 3. Description: The Code3 user defined field. The values are based on the expense type. |
COMMENTS_TEXT |
|
VARCHAR(254) |
YES |
Name: Comments. Description: The User Comments about expense. |
TAX_SCHEDULE_CD |
|
VARCHAR(10) |
YES |
Name: Tax Schedule. Description: The tax schedule unique identifier |
TAX_LOCATION_S |
|
VARCHAR(20) |
YES |
Name: Tax Location. Description: The location used in tax schedule. |
TAX_ID_S |
|
VARCHAR(20) |
YES |
Name: Tax ID. Description: The tax id of provider of service or goods. |
TRANS_TAX_AMT |
|
NUMERIC(15, 5) |
NO |
Name: Transaction Tax Amount. Description: The combined total of tax amounts in transaction currency. |
PAY_TAX_AMT |
|
NUMERIC(15, 5) |
NO |
Name: Pay Tax Amount. Description: The combined total of tax amounts in pay currency. |
BASE_TAX_AMT |
|
NUMERIC(15, 5) |
NO |
Name: Base Tax Amount. Description: The combined total of tax amounts in base currency. |
TAX_RECOVERY_RATE1_PCT |
|
NUMERIC(3, 2) |
NO |
Name: Tax Rate 1 Recovery Percentage. Description: The recovery percentage for the rate1 tax. |
TAX_RECOVERY_RATE2_PCT |
|
NUMERIC(3, 2) |
NO |
Name: Tax Rate 2 Recovery Percentage. Description: The recovery percentage for the rate 2 tax. |
TRANS_TAX_RECOVERY_RATE1_AMT |
|
NUMERIC(15, 5) |
NO |
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 |
|
NUMERIC(15, 5) |
NO |
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 |
|
NUMERIC(15, 5) |
NO |
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 |
|
NUMERIC(15, 5) |
NO |
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 |
|
NUMERIC(15, 5) |
NO |
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 |
|
NUMERIC(15, 5) |
NO |
Name: Tax Rate 2 Recovery Base Amount. Description: The amount of rate 2 tax that is recoverable in base currency. |
UDT11_ID |
|
VARCHAR(20) |
YES |
Name: UDT11 ID. Description: The UDT11 identifier for the line. |
UDT12_ID |
|
VARCHAR(20) |
YES |
Name: UDT12 ID. Description: The UDT12 identifier for the line. |
UDT13_ID |
|
VARCHAR(20) |
YES |
Name: UDT13 ID. Description: The UDT13 identifier for the line. |
UDT14_ID |
|
VARCHAR(20) |
YES |
Name: UDT14 ID. Description: The UDT14 identifier for the line. |
UDT15_ID |
|
VARCHAR(20) |
YES |
Name: UDT15 ID. Description: The UDT15 identifier for the line. |
CORRECTION_NO |
|
NUMERIC(10, 0) |
NO |
Name: Correction Number. Description: The current correction number of the expense report. |