Version 10.2.9

New table in Expense Management 10.2.9

CREATE TABLE DELETED_ROWS (
TABLE_NAME	nvarchar(255)	NOT NULL
PK_COLUMNS	nvarchar(255)	NOT NULL
PK_VALUE_1	int
PK_VALUE_2	int
PK_VALUE_3	int
PK_VALUE_4	int
PK_VALUE_5	int
CHANGE_TIMESTAMP datetime )

Modifications in Expense Management 10.2.9

CREATE TABLE USER_AUDIT_LIST (
USER_ID	int	NOT NULL
DOCUMENT_ID	int
AUDIT_NOTES	nvarchar(255)
REASON_FOR_AUDIT	nvarchar(255)
CHANGE_TIMESTAMP	datetime
USER_AUDIT_LIST_ID	int	NOT NULL
CONSTRAINT USER_AUDIT_LIST_PK PRIMARY KEY CLUSTERED ( USER_AUDIT_LIST_ID )

CREATE TABLE EXPENSE_REPORT_OVERAGE_LINE (
OVERAGE_ID	int
LINE_ITEM_ID	int
LINE_ITEM_EXPENSE_TYPE_ID	int
CHANGE_TIMESTAMP	datetime
DOCUMENT_ID	int
OVERAGE_LINE_ID	int	NOT NULL
CONSTRAINT EXPENSE_REPORT_OVERAGE_LINE_PK PRIMARY KEY CLUSTERED ( OVERAGE_LINE_ID )

CREATE TABLE DELINQUENT_TIMESHEET (
DELINQUENT_TS_ID	int	NOT NULL
USER_ID	int	NOT NULL
START_DATE	datetime	NOT NULL
END_DATE	datetime	NOT NULL
END_CALENDAR_DATE	datetime	NOT NULL
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK439_1 PRIMARY KEY CLUSTERED ( DELINQUENT_TS_ID ) )

CREATE TABLE ER_FLEX_FIELD_LABELS (
FF_LABELS_ID	int
STRING_1_LABEL	nvarchar(255)
STRING_2_LABEL	nvarchar(255)
STRING_3_LABEL	nvarchar(255)
STRING_4_LABEL	nvarchar(255)
INTEGER_1_LABEL	nvarchar(255)
INTEGER_2_LABEL	nvarchar(255)
DATE_1_LABEL	nvarchar(255)
DATE_2_LABEL	nvarchar(255)
AMOUNT_1_LABEL	nvarchar(255)
AMOUNT_2_LABEL	nvarchar(255)
LOCATION_1_LABEL	nvarchar(255)
DDLB_1_LABEL	nvarchar(255)
DDLB_2_LABEL	nvarchar(255)
DDLB_3_LABEL	nvarchar(255)
DDLB_4_LABEL	nvarchar(255)
DDLB_5_LABEL	nvarchar(255)
CHANGE_TIMESTAMP	datetime )

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 ERLI_FLEX_FIELD_LABELS (
FF_LABELS_ID	int
STRING_1_LABEL	nvarchar(255)
STRING_2_LABEL	nvarchar(255)
STRING_3_LABEL	nvarchar(255)
STRING_4_LABEL	nvarchar(255)
INTEGER_1_LABEL	nvarchar(255)
INTEGER_2_LABEL	nvarchar(255)
DATE_1_LABEL	nvarchar(255)
DATE_2_LABEL	nvarchar(255)
AMOUNT_1_LABEL	nvarchar(255)
AMOUNT_2_LABEL	nvarchar(255)
LOCATION_1_LABEL	nvarchar(255)
DDLB_1_LABEL	nvarchar(255)
DDLB_2_LABEL	nvarchar(255)
DDLB_3_LABEL	nvarchar(255)
DDLB_4_LABEL	nvarchar(255)
DDLB_5_LABEL	nvarchar(255)
CHANGE_TIMESTAMP	datetime

CREATE TABLE EXPENSE_TYPE_RELATIONSHIP (
RELATIONSHIP_ID	int	NOT NULL
EXPENSE_TYPE_ID	int	NOT NULL
PARENT_EXPENSE_TYPE_ID	int	NOT NULL
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK8_1 PRIMARY KEY CLUSTERED ( RELATIONSHIP_ID ) )