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
TR_ITEM_ID int NOT NULL
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)
IDENTITY2 nvarchar(36)
CONSTRAINT PK9 PRIMARY KEY CLUSTERED ( USER_ID ) )