XM_ALLOCATION

Entity Name XM_ALLOCATION
Entity Type Independent
Definition Each record in this table represents money that is spent. The record is generally allocated to a cost-center but can also be allocated to a project number. Every line item has one or more allocation records - even if the user does not explicitly do a multiple-allocation or itemization.

Attributes

Attribute Datatype Width Definition
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