ALEX_IMPORT_EXTENSION (Staging Table)
Your Concept
| Column name | Data type | Required | Default updateable | Data target | Comments |
|---|---|---|---|---|---|
| external_key** | VARCHAR (255) | Yes* | No | almt_extension.extension_id | The external key -- Primary Key |
| import_change_timestamp | DATETIME | No | No | ||
| name | VARCHAR(255) | Yes | No | almt_extension.name | The extension name same as the outputelementname for the ADC |
| value_int | INTEGER | No | No | almt_extension.value_int | To store the data of ADC of control type integer |
| value_float | FLOAT | No | No | almt_extension.value_float | To store the data of ADC of control type float |
| value_date | DATETIME | No | No | almt_extension.value_date | To store the data of ADC of control type date/Date no Timezone |
| value_string | VARCHAR(510) | No | No | almt_extension.value_string | To store the data of ADC of control type String |
| value_hours | NUMERIC(14,4) | No | No | almt_extension.value_hours | To store the data of ADC of control type hours |
| value_currency_ekey | VARCHAR(255) | No | No | almt_extension.value_currency_id | To store the external key of the currency |
| value_currency | NUMERIC(28,10) | No | No | almt_extension.value_currency | To store the data of ADC of control type currency |
| value_bobref_type | VARCHAR(255) | No | No | almt_extension.value_bobref_type | To store the Bob name of ADC of control type autocomplete, dropdown, chooser |
| value_bobref_ekey | VARCHAR(255) | No | No | almt_extension.value_bobref | To store the data of ADC of control type autocomplete, dropdown, chooser |
| parent_ekey | VARCHAR(255) | Yes | No | almt_extension.parent_id | The foreign key of document/Line Item |