| ALLOCATION_DATE |
DateTime |
21 |
|
| CHANGE_TIMESTAMP |
DateTime |
23 |
|
| COST_CENTER_ID |
Integer |
11 |
A foreign key for the organization table identifying the cost center charged in this allocation. |
| IS_APPROVED |
Integer |
1 |
|
| IS_BILLABLE |
Integer |
1 |
The billable status of the allocation for the client. |
| LINE_ITEM_ID |
Integer |
11 |
A foreign key for one of the line item tables (expense_report_line_item, purchase_line_item or travel_item) that identifies the line item containing this allocation. |
| LINE_ITEM_ID_TYPE |
Integer |
9 |
The type of line item pointing to line_item_id. Valid values are 101 (expense_report_line_item), 135100 (purchase_line_item) and 76000 (travel_line_item). |
| PAID_IN_AMOUNT |
Float |
7 |
The amount of the allocation in the currency for which the creator is being reimbursed. |
| PAID_IN_AMOUNT_CURRENCY |
Varchar |
3 |
The three letter ISO code identifying the currency of the paid_in_amount. |
| PERCENT_ALLOTTED |
Float |
3 |
The percent of the line item amount that is allotted to this allocation. Usually 100%, unless there are multiple allocations. |
| PROJECT_NUMBER_ID |
Integer |
11 |
A foreign key for the project_number table identifying the project number being charged in this allocation. |
| TRANSACTION_AMOUNT |
Float |
7 |
The amount spent on the transaction in the currency accepted by the vendor or merchant. |
| TRANSACTION_AMOUNT_CURRENCY |
Varchar |
3 |
The three letter ISO code identifying the currency of the transaction_amount. |
| lastModified |
DateTime |
24 |
|
| VariationID |
Integer |
13 |
|
| ACTIVE_STATUS |
Varchar |
4 |
|