Allocation
Tracks allocation records, including types, descriptions, and statuses for financial distributions.
Table Specific Information
Insert
Insert is only supported when UseLegacy=False.
The following example illustrates how to insert into Allocation table:
INSERT INTO Allocation (Allocationid, Description, Type, Docnumber, Status, ItemAggregate) VALUES('testallocation102', 'aNewDescription', 'Percentage', 'allocation779', 'active','<allocationentry><value>100</value><CUSTOMERID>PLA001</CUSTOMERID><CUSTOMERNAME>Honeywell, Inc</CUSTOMERNAME><DEPARTMENTID>65</DEPARTMENTID><EMPLOYEEDIMKEY>19</EMPLOYEEDIMKEY><EMPLOYEEID>19</EMPLOYEEID><EMPLOYEENAME>John Test2</EMPLOYEENAME><VALUE>100</VALUE><VALUETYPE>Percent</VALUETYPE></allocationentry>');
Note: Inserts are not supported with the Legacy API.
Columns
| Name | Type | ReadOnly | Description |
| Recordno | Int64 | False |
A unique identifier for the allocation record. |
| Allocationid [KEY] | String | False |
The unique identifier for the allocation. |
| Description | String | False |
A description of the allocation. |
| Type | String | False |
The type of allocation (for example, fixed, percentage-based). |
| Docnumber | String | False |
The document number associated with the allocation. |
| Status | String | False |
The current status of the allocation (for example, active, inactive). |
| Whencreated | Datetime | False |
The timestamp indicating when the allocation record was created. |
| Whenmodified | Datetime | False |
The timestamp indicating when the allocation record was last modified. |
| Createdby | Int64 | False |
The identifier of the user or process that created the allocation record. |
| Modifiedby | Int64 | False |
The identifier of the user or process that last modified the allocation record. |
| Megaentitykey | Int64 | False |
The unique key representing the associated mega entity. |
| Megaentityid | String | False |
The identifier for the associated mega entity. |
| Megaentityname | String | False |
The name of the associated mega entity. |
| Record_url | String | False |
The URL linking to the detailed record of the allocation. |