ColumnName |
Domain |
Datatype |
NULL |
Definition |
BATCH_ID |
|
VARCHAR2(10) |
NO |
Name: Batch id for the export batch Description: Batch id for the export batch. |
EXP_ID |
|
VARCHAR2(10) |
NO |
Name: Expense id Description: Expense id. |
S_EXP_STATUS_CD |
|
VARCHAR2(1) |
NO |
Name: Expense Status code Description: Expense Status code. |
EMPL_ID |
|
VARCHAR2(20) |
NO |
Name: Employee id Description: Employee id. |
EMPL_NAME |
|
VARCHAR2(61) |
NO |
Name: Employee Name Description: Employee Name. |
VEND_ID |
|
VARCHAR2(20) |
YES |
Name: Vendor id Description: Vendor id. |
EXPENSE_ID |
|
NUMBER(10, 0) |
YES |
Name: Expense id Description: Expense id. |
UDT02_ID |
|
VARCHAR2(50) |
YES |
Name: Project id Description: Project id. |
UDT01_ID |
|
VARCHAR2(50) |
YES |
Name: Account id Description: Account id. |
UDT09_ID |
|
VARCHAR2(20) |
YES |
Name: Organization id Description: Organization id. |
UDT04_ID |
|
VARCHAR2(20) |
YES |
Name: Udt04 Description: Udt04. |
UDT05_ID |
|
VARCHAR2(20) |
YES |
Name: Udt05 Description: Udt05. |
BASE_COMMIT_AMT |
|
NUMBER(15, 5) |
NO |
Name: Base commit amount Description: Base commit amount. |
PAY_COMMIT_AMT |
|
NUMBER(15, 5) |
NO |
Name: Pay commit amount Description: Pay commit amount. |
PAY_CURRENCY_CD |
|
VARCHAR2(3) |
NO |
Name: Pay currency code Description: Pay currency code. |
BASE_CURRENCY_CD |
|
VARCHAR2(3) |
NO |
Name: Base currency code Description: Base currency code. |
COMMIT_TYPE |
|
VARCHAR2(2) |
NO |
Name: Commitment type Description: Commitment type. |
EXP_TYPE_CD |
|
VARCHAR2(10) |
NO |
Name: Expense type code Description: Expense type code. |
EXP_RPT_TYPE_CD |
|
VARCHAR2(10) |
NO |
Name: Expense Report Type Code Description: Expense Report Type Code. |
START_DT |
|
DATE |
NO |
Name: Start date Description: Start date. |
END_DT |
|
DATE |
NO |
Name: End date Description: End date. |
CITY_NAME |
|
VARCHAR2(35) |
YES |
Name: City name Description: City name. |
COUNTY_NAME |
|
VARCHAR2(35) |
YES |
Name: County name Description: County name. |
STATE_NAME |
|
VARCHAR2(35) |
YES |
Name: State name Description: State name. |
COUNTRY_NAME |
|
VARCHAR2(45) |
YES |
Name: Country name Description: Country name. |
PAYMENT_TYPE |
|
VARCHAR2(10) |
YES |
Name: Payment Type Description: Payment Type. |
COMMIT_DT |
|
DATE |
NO |
Name: Commitment date Description: Commitment date. |
COMMIT_CALC_DTT |
|
DATE |
NO |
Name: Commitment Calculation date Description: Commitment Calculation date. |
CP_COMPANY_CD |
|
VARCHAR2(10) |
NO |
Name: Costpoint company code Description: Costpoint company code. |