Version 10.2.20

Modifications to tables in 10.2.20

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)
CONSTRAINT PK9 PRIMARY KEY CLUSTERED ( USER_ID )
)