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 ) ) |