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 ) )