Version 10.2.21

New table in Expense Management 10.2.21

CREATE TABLE ALLOCATION_ADC (
ALLOCATION_ID	int	NOT NULL
DOCUMENT_ID	int	NOT NULL
ADC_STRING_1	nvarchar(510)
ADC_STRING_2	nvarchar(510)
ADC_STRING_3	nvarchar(510)
ADC_STRING_4	nvarchar(510)
ADC_STRING_5	nvarchar(510)
ADC_STRING_6	nvarchar(510)
ADC_STRING_7	nvarchar(510)
ADC_STRING_8	nvarchar(510)
ADC_STRING_9	nvarchar(510)
ADC_STRING_10	nvarchar(510)
ADC_DATE_1	datetime
ADC_DATE_2	datetime
ADC_DATE_3	datetime
ADC_DATE_4	datetime
ADC_DATE_5	datetime
ADC_INTEGER_1	int
ADC_INTEGER_2	int
ADC_INTEGER_3	int
ADC_AMOUNT_1	numeric(28,10)
ADC_AMOUNT_1_CURRENCY	nchar(3)
ADC_AMOUNT_2	numeric(28,10)
ADC_AMOUNT_2_CURRENCY	nchar(3)
ADC_AMOUNT_3	numeric(28,10)
ADC_AMOUNT_3_CURRENCY	nchar(3)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK_ALLOC_ADC PRIMARY KEY CLUSTERED ( ALLOCATION_ID )
)

Modifications to tables in Expense Management 10.2.21

CREATE TABLE CUMULATIVE_MILES (
CUMULATIVE_MILEAGE_ID	int	NOT NULL
USER_ID	int
PERIOD_START_DATE	datetime
PERIOD_END_DATE	datetime
CUMULATIVE_MILES	numeric(15,5)
CHANGE_TIMESTAMP	datetime
EXPENSE_TYPE_ID	int
CONSTRAINT PK115_1 PRIMARY KEY CLUSTERED ( CUMULATIVE_MILEAGE_ID )
)

CREATE TABLE ORGANIZATION (
COST_CENTER_ID	int	NOT NULL
COMPANY_ID	int
COMPANY_NAME	nvarchar(255)
COMPANY_CODE	nchar( 60 )
DIVISION_ID	int
DIVISION_NAME	nvarchar(255)
DIVISION_CODE	nchar( 60 )
DEPARTMENT_ID	int
DEPARTMENT_NAME	nvarchar(255)
DEPARTMENT_CODE	nchar( 60 )
USER_ID	int
COST_CENTER_NAME	nvarchar(255)
COST_CENTER_CODE	nchar(60)
COST_CENTER_DESCRIPTION	nvarchar(255)
DEFAULT_REVIEWER_ID	int
ALTERNATE_REVIEWER_ID	int
CHANGE_TIMESTAMP	datetime
COST_CENTER_ACTIVE_STATUS	smallint
CONSTRAINT PK10 PRIMARY KEY CLUSTERED ( COST_CENTER_ID )
)