Version 2025.04

Modified tables

The new columns are highlighted and the deleted columns are marked with the * symbol. The modified columns are marked with the ** symbol.

CREATE TABLE INVOICE_LINE_ITEM (
LINE_ITEM_ID	int	NOT NULL
DOCUMENT_ID	int	NOT NULL
ITEM_NUMBER	nvarchar(255)
ITEM_DESCRIPTION	nvarchar(255)
INVOICED_QUANTITY	numeric(15,5)
UNIT_OF_MEASURE_CODE	nvarchar(255)
UNIT_OF_MEASURE	nvarchar(255)
UNIT_OF_MEASURE_CREATOR_ID	int
UNIT_PRICE	numeric(28,10)
UNIT_PRICE_CURRENCY	nchar(3)
TOTAL_PRICE	numeric(28,10)
TOTAL_PRICE_CURRENCY	nchar(3)
CHECK_REQUEST_TYPE_ID	int
CHANGE_TIMESTAMP	datetime
NUMBER_OF_GUESTS	int
GUEST_NO_SHOW_COUNT	int
INVOICE_DATE	datetime
CREATOR_CLIENT_TYPE	int
EXPORT_STATUS	int
VOID_STATUS	int
REVERSAL_LINE_ITEM_ID	int
FLEX_FIELD_STRING_1	nvarchar(255)
FLEX_FIELD_STRING_2	nvarchar(255)
FLEX_FIELD_STRING_3	nvarchar(255)
FLEX_FIELD_STRING_4	nvarchar(255)
FLEX_FIELD_STRING_5	nvarchar(255)
FLEX_FIELD_DDLB_1_CODE	nvarchar(255)
FLEX_FIELD_DDLB_2_CODE	nvarchar(255)
FLEX_FIELD_DDLB_3_CODE	nvarchar(255)
FLEX_FIELD_DDLB_4_CODE	nvarchar(255)
FLEX_FIELD_DDLB_5_CODE	nvarchar(255)
FLEX_FIELD_DDLB_1_VALUE	nvarchar(255)
FLEX_FIELD_DDLB_2_VALUE	nvarchar(255)
FLEX_FIELD_DDLB_3_VALUE	nvarchar(255)
FLEX_FIELD_DDLB_4_VALUE	nvarchar(255)
FLEX_FIELD_DDLB_5_VALUE	nvarchar(255)
CONSTRAINT PK11 PRIMARY KEY CLUSTERED (LINE_ITEM_ID)
)

CREATE TABLE CURRENT_ACTIVITY_OWNERS (
DOCUMENT_ID	int	NOT NULL
USER_ID	int
GROUP_ID	int
CHANGED_TIMESTAMP	datetime
CURRENT_ACTIVITY_OWNERS_ID	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__CURRENT_ACTIVITY_OWNERS PRIMARY KEY CLUSTERED (CURRENT_ACTIVITY_OWNERS_ID)
)

CREATE TABLE DELETED_DOCUMENTS (
DOCUMENT_ID	int	NOT NULL
DOCUMENT_TYPE	int	NOT NULL
TRACKING_NUMBER	nvarchar(255)	NOT NULL
DOCUMENT_OWNER_ID	int
DELETED_BY_USER_ID	int
DELETED_DATE	datetime
CHANGED_TIMESTAMP	datetime
CONSTRAINT PK__DELETED_DOCUMENTS PRIMARY KEY CLUSTERED (DOCUMENT_ID)
)

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
DELETED_ROWS_ID	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__DELETED_ROWS PRIMARY KEY CLUSTERED (DELETED_ROWS_ID)
)

CREATE TABLE DOCUMENT_HISTORY (
DOCUMENT_ID	int	NOT NULL
DOCUMENT_TYPE	int
FROM_ACTIVITY_ID	int
TO_ACTIVITY_ID	int
ENTERED_FROM_ACTIVITY_DATE	datetime
EXITED_FROM_ACTIVITY_DATE	datetime
TRANSITION_USER_ID	int
PROXY	nvarchar(255)
CHANGE_TIMESTAMP	datetime
TRANSITION_DESCRIPTION	nvarchar(255)
DOCUMENT_HISTORY_ID	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__DOCUMENT_HISTORY PRIMARY KEY CLUSTERED (DOCUMENT_HISTORY_ID)
)

CREATE TABLE DOCUMENT_LINKS (
DOCUMENT_LINKS_ID	int	NOT NULL
DOCUMENT_ID	int	NOT NULL
DOCUMENT_TYPE_ID	int	NOT NULL
LINKED_DOCUMENT_ID	int
LINKED_DOCUMENT_TYPE_ID	int
LINKED_DOCUMENT_CREATE_DATE	datetime
LINKED_DOCUMENT_DESCRIPTION	nvarchar(255)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK__DOCUMENT_LINKS PRIMARY KEY CLUSTERED (DOCUMENT_LINKS_ID)
)

CREATE TABLE ER_FLEX_FIELD_LABELS (
FF_LABELS_ID	int	NOT NULL
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
CONSTRAINT PK__ER_FLEX_FIELD_LABELS PRIMARY KEY CLUSTERED (FF_LABELS_ID)
)

CREATE TABLE ER_LINE_ITEM_ADJUSTMENT (
LINE_ITEM_ID	int
SEQUENCE_NUMBER	int	NOT NULL
CHANGE_DATE	datetime
CHANGE_AMOUNT	numeric(28,10)
CHANGE_AMOUNT_ISO	nchar(3)
NEW_BALANCE_AMOUNT	numeric(28,10)
NEW_BALANCE_AMOUNT_ISO	nchar(3)
ADJUSTER_ID	int
CHANGE_TIMESTAMP	datetime
DOCUMENT_ID	int
ADJUSTMENT_ID	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__ER_LINE_ITEM_ADJUSTMENT PRIMARY KEY CLUSTERED (ADJUSTMENT_ID)
)

CREATE TABLE ERLI_FLEX_FIELD_LABELS (
FF_LABELS_ID	int	NOT NULL
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
DDLB_6_LABEL	nvarchar(255)
DDLB_7_LABEL	nvarchar(255)
DDLB_8_LABEL	nvarchar(255)
DDLB_9_LABEL	nvarchar(255)
DDLB_10_LABEL	nvarchar(255)
CONSTRAINT PK__ERLI_FLEX_FIELD_LABELS PRIMARY KEY CLUSTERED (FF_LABELS_ID)
)

CREATE TABLE ETL_RUN_RESULT (
ETL_RUN_ID	int	NOT NULL
CONVERSION_NAME	nvarchar(255)	NOT NULL
ACTION	nvarchar(255)	NOT NULL
NUM_PROCESSED	int	NOT NULL
CHANGE_TIMESTAMP	datetime
CONSTRAINT ETL_RUN_RESULT_PK PRIMARY KEY CLUSTERED (ETL_RUN_ID)
)

CREATE TABLE EXPENSE_REPORT_DEDUCTION_LINE (
LINE_ITEM_ID	int	NOT NULL
PERDIEM_DEDUCTION	numeric(28,10)
PERDIEM_DEDUCTION_CURRENCY	nchar(3)
DEDUCTION_TYPES	int
PRIVATE_NIGHTSTAY_ADDRESS	nvarchar(255)
START_TIME	datetime
END_TIME	datetime
MEAL_AMOUNT	numeric(28,10)
MEAL_AMOUNT_CURRENCY	nchar(3)
DURATION_OF_STAY	int
CHANGE_TIMESTAMP	datetime
DOCUMENT_ID	int	NOT NULL
EXPENSE_REPORT_DEDUCTION_LINE_ID	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__EXPENSE_REPORT_DEDUCTION_LINE PRIMARY KEY CLUSTERED (EXPENSE_REPORT_DEDUCTION_LINE_ID )
)

CREATE TABLE GROUP_DEFINITION (
GROUP_ID	int	NOT NULL
GROUP_NAME	nvarchar(255)
GROUP_DESCRIPTION	nvarchar(255)
GROUP_TYPE_CODE	nvarchar(255)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK__GROUP_DEFINITION PRIMARY KEY CLUSTERED (GROUP_ID)
)

CREATE TABLE GROUP_HIERARCHY (
PARENT_GROUP_ID	int	NOT NULL
CHILD_GROUP_ID	int	NOT NULL
CHANGE_TIMESTAMP	datetime
GROUP_HIERARCHY_ID	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__GROUP_HIERARCHY PRIMARY KEY CLUSTERED (GROUP_HIERARCHY_ID)
)

CREATE TABLE GROUP_MEMBERSHIP (
MEMBERSHIP_ID	int	NOT NULL
USER_ID	int	NOT NULL
GROUP_ID	int	NOT NULL
CHANGE_TIMESTAMP	datetime
CONSTRAINT GROUP_MEMBERSHIP_PK PRIMARY KEY CLUSTERED (MEMBERSHIP_ID)
)

CREATE TABLE HOTEL_FOLIO (
HOTEL_FOLIO_ID	int	NOT NULL
CREDIT_CARD_TRANSACTION_ID	int
CHARGE_DATE	datetime	NOT NULL
NATIVE_AMOUNT	numeric(28	10)
NOT NULL
NATIVE_AMOUNT_CURRENCY	nchar(3)	NOT NULL
EXPENSE_TYPE_ID	int
ITEM_CODE	nvarchar(50)
CARD_TYPE	int
ITEM_CODE_DESCRIPTION	nvarchar(255)
CATEGORY_CODE	nvarchar(32)
CATEGORY_CODE_DESCRIPTION	nvarchar(255)
DESCRIPTION	nvarchar(255)
SEQUENCE_NUMBER	int
LEVEL3_IDENTIFIER	nvarchar(255)
IS_UNATTACHED	smallint	NOT NULL
CHANGE_TIMESTAMP	datetime
WORK_ITEM_ID	int
CONSTRAINT PK__HOTEL_FOLIO PRIMARY KEY CLUSTERED (HOTEL_FOLIO_ID)
)

CREATE TABLE RECEIVED_QUANTITY (
LINE_ITEM_ID	int	NOT NULL
RECEIVED_QUANTITY	int	NOT NULL
RECEIVED_DATE	datetime
RECEIVED_STATUS	nvarchar(255)
IS_ACTUALLY_RECEIVED	smallint
PACKING_SLIP_NUMBER	nvarchar(255)
ACTUAL_RECEIVED_QUANTITY	int
CHANGE_TIMESTAMP	datetime
DOCUMENT_ID	int
RECEIVED_QUANTITY_ID	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__RECEIVED_QUANTITY PRIMARY KEY CLUSTERED (RECEIVED_QUANTITY_ID)
)

CREATE TABLE TIMESHEET_USER_ATTRIBUTES (
USER_ID	int	NOT NULL
LABOR_STATUS	nvarchar(255)
EMPLOYMENT_STATUS	nvarchar(255)
LOCATION_ID	int
JOB_CLASSIFICATION	nvarchar(100)
PROFILE_NAME	nvarchar(100)
REPORT_PERIOD	nvarchar(255)
WORK_SCHEDULE	nvarchar(255)
WORK_SCHEDULE_HOURS	numeric(14,4)
HOLIDAY_SCHEDULE	nvarchar(255)
OVERTIME_CALCULATION	nvarchar(255)
SUBMIT_EVERY_PERIOD	smallint	NOT NULL
CHANGE_TIMESTAMP	datetime
TIMESHEET_USER_ATTRIBUTES_ID	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__TIMESHEET_USER_ATTRIBUTES PRIMARY KEY CLUSTERED (TIMESHEET_USER_ATTRIBUTES_ID)
)

CREATE TABLE USER_BENEFITS (
USER_ID	int
BENEFIT_TYPE	nvarchar(255)
AVAILABLE_DAYS	numeric(7,2)
RECEIVED_YTD_DAYS	numeric(7,2)
TAKEN_YTD_DAYS	numeric(7,2)
EFFECTIVE_DATE	datetime
CHANGE_TIMESTAMP	datetime
USER_BENEFITS_ID	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__USER_BENEFITS PRIMARY KEY CLUSTERED (USER_BENEFITS_ID)
)

CREATE TABLE USER_HIERARCHY (
BOSS_USER_ID	int
USER_ID	int
SUPERVISORY_LEVEL	int
CHANGE_TIMESTAMP	datetime
USER_HIERARCHY_ID	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__USER_HIERARCHY PRIMARY KEY CLUSTERED (USER_HIERARCHY_ID)
)

CREATE TABLE USER_LCF_TOTAL (
LCF_BALANCE	numeric(28,10)
NOT NULL
LCF_BALANCE_CURRENCY	nchar(3)	NOT NULL
USER_ID	int	NOT NULL
CHANGE_TIMESTAMP	datetime
USER_LCF_TOTAL_ID	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__USER_LCF_TOTAL PRIMARY KEY CLUSTERED (USER_LCF_TOTAL_ID)
)

CREATE TABLE USER_ROLES (
USER_ID	int	NOT NULL
ROLE_NAME	nvarchar(255)	NOT NULL
CHANGE_TIMESTAMP	datetime
USER_ROLES_ID	int IDENTITY(1,1)	NOT NULL
CONSTRAINT PK__USER_ROLES PRIMARY KEY CLUSTERED (USER_ROLES_ID)
)