Version 2023.05

These staging tables are added.

CREATE TABLE alex_import_line_allocation (
external_key nvarchar(255) NOT NULL
parent_ekey nvarchar(255) NOT NULL
import_change_timestamp datetime
percent_allotted numeric(26,16)
base_amount_ekey nvarchar(255)
base_amount numeric(28,10)
native_amount_ekey nvarchar(255)
native_amount numeric(28,10)
is_approved smallint
cost_center_ekey nvarchar(255)
project_number_ekey nvarchar(255)
is_billable smallint
is_base_amount_adjusted smallint DEFAULT 0 NOT NULL
CONSTRAINT PK140 PRIMARY KEY CLUSTERED ( external_key )
)
go