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