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 |