| external_key** |
VARCHAR (255) |
Yes* |
No |
aler_line_allocation. pd_line_data_id |
The external key -- Primary Key |
| parent_ekey |
VARCHAR(255) |
Yes* |
No |
aler_line_allocation. exp_line_item_id |
The external key of the parent line item |
| import_change_timestamp |
DATETIME |
No |
No |
|
|
| percent_allotted |
NUMERIC(26,16) |
No |
No |
aler_line_allocation.percent_allotted |
Percentage of the amount to be allocated |
| base_amount_ekey |
VARCHAR(255) |
No |
No |
aler_line_allocation.base_amount_id |
External key of the currency format. |
| base_amount |
NUMERIC(28,10) |
No |
No |
aler_line_allocation.base_amount |
|
| native_amount_ekey |
VARCHAR(255) |
No |
No |
aler_line_allocation.native_amount_id |
External key of the currency format. |
| native_amount |
NUMERIC(28,10) |
No |
No |
aler_line_allocation.native_amount |
|
| is_approved |
SMALLINT |
No |
No |
aler_line_allocation.is_approved |
0/1 to indicate the allocation is approved |
| cost_center_ekey |
VARCHAR(255) |
No |
No |
aler_line_allocation.cost_center_id |
External key of the cost center |
| project_number_ekey |
VARCHAR(255) |
No |
No |
aler_line_allocation.project_number_id |
External key of the project |
| is_billable |
SMALLINT |
No |
No |
aler_line_allocation.is_billable |
0/1 to indicate whether the line allocation is billable |
| is_base_amount_adjusted |
SMALLINT |
Yes |
No |
aler_line_allocation.is_base_amount_adjusted |
0/1 to indicate whether the base amount is changed. |