# reservation
<a name="planning-reservation-entity"></a>

**Primary key (PK)**

The table below lists the colum names that are uniquely identified in the data entity.


| Name | Column | 
| --- | --- | 
| reservation | reservation\$1id, reservation\$1detail\$1id | 

The table below lists the column names supported by the *reservation* data entity:


| Column | Data type | Required | Description | 
| --- | --- | --- | --- | 
|  reservation\$1id  |  string  |  Yes  |  Reservation ID.  | 
|  reservation\$1detail\$1id  |  string  |  Yes  |  Reservation detail ID.  | 
|  reservation\$1type  |  string  |  No  |  Type of reservation. For example, procurement or build-to-stock.  | 
|  company\$1id1  |  string  |  No  |  Company ID.  | 
|  status  |  string  |  No  |  Status of the reservation.  | 
|  product\$1id1  |  string  |  No  |  Product ID.  | 
|  site\$1id1  |  string  |  No  |  Site ID.  | 
|  quantity  |  double  |  No  |  Reservation quantity.  | 
|  quantity\$1uom  |  string  |  No  |  Quantity UOM associated with reservation.  | 
|  reservation\$1date  |  timestamp  |  No  |  Date when the reservation is generated.  | 
|  is\$1deleted  |  string  |  No  |  Yes or No indicator to indicate whether the reservation is deleted or not.  | 
|  requisition\$1id1  |  string  |  No  |  Source object identifier reference to inbound order type.  | 
|  requisition\$1line\$1id1  |  string  |  No  |  Source object identifier reference to inbound order line.  | 
|  rfq\$1id1  |  string  |  No  |  Source object identifier reference to inbound order type RFQ.  | 
|  rfq\$1line\$1id1  |  string  |  No  |  Source object identifier reference to inbound order line of type RFQ.  | 
|  order\$1id1  |  string  |  No  |  Source object identifier reference to inbound order.  | 
|  order\$1line\$1id1  |  string  |  No  |  Source object identifier reference to inbound order line.  | 
|  order\$1line\$1schedule\$1id1  |  string  |  No  |  Source object identifier reference to inbound order line schedule.  | 
|  stock\$1transfer\$11\$1order\$1id  |  string  |  No  |  Stock transfer order ID.  | 
|  stock\$1transfer\$11\$1order\$1line\$1id  |  string  |  No  |  Stock transfer order line ID.  | 
|  stock\$1transfer\$12\$1order\$1id  |  string  |  No  |  Stock transfer order ID.  | 
|  stock\$1transfer\$12\$1order\$1line\$1id  |  string  |  No  |  Stock transfer order line ID.  | 
|  source\$1update\$1dttm  |  timestamp  |  No  |  Date time stamp of the update made in the source system.  | 
|  source\$1event\$1id  |  string  |  No  |  ID of the event created in the source system.  | 
|  source  |  string  |  No  |  Source of data.  | 
|  flex\$11  |  string  |  No  |  Reservation flexible field 1  | 
|  flex\$12  |  string  |  No  |  Reservation flexible field 2  | 
|  flex\$13  |  string  |  No  |  Reservation flexible field 3  | 
|  flex\$14  |  string  |  No  |  Reservation flexible field 4  | 
|  flex\$15  |  string  |  No  |  Reservation flexible field 5  | 

1Foreign key

**Foreign key (FK)**

The table below lists the column names with the associated data entity and category:


| Column | Category | FK/Data entity | FK/Column | 
| --- | --- | --- | --- | 
| site\$1id | Network | site | id | 
| company\$1id | Organization | company | id | 
| product\$1id | Product | product | id | 
| requisition\$1id, rfq\$1id | Inbound | inbound\$1order\$1line | order\$1id | 
| requisition\$1line\$1id, rfq\$1line\$1id | Inbound | inbound\$1order\$1line | id | 
| order\$1line\$1schedule\$1id | Inbound | inbound\$1order\$1line\$1schedule | id |