Version 2024.10

Modified tables

The new columns are highlighted and the deleted columns are marked with the * symbol. The modified columns are marked with the ** symbol.

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)
USER_LOCATION	nvarchar(255)
FX_RATE_SOURCE_NAME	nvarchar(50)
ER_DEFAULT_COST_CENTER_ID	int
CONSTRAINT PK9 PRIMARY KEY CLUSTERED (USER_ID)
)

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	**Changed NOT NULL to NULL
TR_FROM_LOCATION_ID	int
TR_TO_LOCATION_ID	int
TRAVEL_EXPENSE_TYPE_ID	int
TR_VENDOR_NAME	nvarchar(255)
TR_DOCUMENT_ID	int
CONSTRAINT PK597_1 PRIMARY KEY CLUSTERED (LINE_ITEM_ID)
)