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