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 |