Version 10.2.14
New tables in Expense Management 10.2.14
| CREATE TABLE RECEIPTS_LINE_URL ( | ||
|---|---|---|
| RECEIPT_LINE_URL_ID | int | NOT NULL, |
| DOCUMENT_ID | nvarchar(255) | NOT NULL, |
| LINE_ID | int | NOT NULL, |
| RECEIPT_ID | int | NOT NULL |
| URL | nvarchar(510), | |
| FLEX_FIELD_1 | nvarchar(255), | |
| FLEX_FIELD_2 | int, | |
| STATUS | int | NOT NULL, |
| ACTIVE_STATUS | int | NOT NULL, |
| CHANGE_TIMESTAMP | datetime, | |
|
CONSTRAINT PK550_1 PRIMARY KEY CLUSTERED ( RECEIPT_LINE_URL_ID ) ) |
||
Modifications to tables in Expense Management 10.2.14
| CREATE TABLE ER_TR_ITEM_LINK ( | ||
|---|---|---|
| LINE_ITEM_ID | int | NOT NULL |
| TR_TRACKING_NUM | nvarchar(255) | |
| PREAPPROVED_AMT_CURRENCY | nchar(3) | |
| PREAPPROVED_AMT | numeric(28,10) | |
| LINE_ITEM_DATE | datetime | |
| CHANGE_TIMESTAMP | datetime | |
| CONSTRAINT PK597_1 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID ) ) | ||
| CREATE TABLE EXT_USER ( | ||
|---|---|---|
| USER_ID | int | NOT NULL |
| FULL_NAME | nvarchar(255) | NOT NULL |
| FIRST_NAME | nvarchar(255) | |
| MIDDLE_INITIAL | nchar(1) | |
| LAST_NAME | nvarchar(255) | |
| EMPLOYEE_NUMBER | nvarchar(255) | |
| LOGIN | nvarchar(255) | |
| TITLE | nvarchar(255) | |
| IS_ACTIVE | smallint | |
| TAXPAYER_ID | nvarchar(255) | |
| DEFAULT_COST_CENTER_ID | int | |
| LCF_TOTAL_AMT_CUR | nchar(3) | |
| LCF_TOTAL_AMT | numeric(28,10) | |
| COUNTRY_NAME | nvarchar(255) | |
| COUNTRY_ISO_CODE | nchar(2) | |
| BOSS_ID | int | |
| OFFICE_NAME | nvarchar(255) | |
| LOCATION_ID | int | |
| SET_OF_BOOKS_NAME | nvarchar(255) | |
| AUTH_AMT | numeric(28,10) | |
| AUTH_AMT_CUR | nchar(3) | |
| PR_AUTH_AMT | numeric(28,10) | |
| PR_AUTH_AMT_CUR | nchar(3) | |
| SYSTEM_CODE_1 | nvarchar(255) | |
| SYSTEM_CODE_2 | nvarchar(255) | |
| SYSTEM_CODE_3 | nvarchar(255) | |
| SYSTEM_CODE_4 | nvarchar(255) | |
| SYSTEM_CODE_5 | nvarchar(255) | |
| SYSTEM_CODE_6 | nvarchar(255) | |
| SYSTEM_CODE_7 | nvarchar(255) | |
| SYSTEM_CODE_8 | nvarchar(255) | |
| SYSTEM_DATE_1 | datetime | |
| SYSTEM_DATE_2 | datetime | |
| CHANGE_TIMESTAMP | datetime | |
| EMAIL_ADDRESS | nvarchar(255) | |
| DEFAULT_CURRENCY | nchar(3) | |
| CREATION_TIME | datetime | |
| LAST_MODIFIED_TIME | datetime | |
| PAYROLL_SYSTEM_CODE | nvarchar(255) | |
| ER_DEFAULT_PROJECT_ID | int | |
| PROXY_CAN_SUBMIT | smallint | |
| PROXY_REVIEWER_CAN_SUBMIT | smallint | |
| SECOND_CURRENCY | nchar(3) | |
| START_DATE | datetime | |
| END_DATE | datetime | |
| USER_MAILSTOP | nvarchar(255) | |
| CONSTRAINT PK9 PRIMARY KEY CLUSTERED ( USER_ID ) ) | ||