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