# vendor\$1lead\$1time
<a name="vendor-management-lead-time-entity"></a>

**Primary key (PK)**

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


| Name | Column | 
| --- | --- | 
| vendor\$1lead\$1time | vendor\$1tpartner\$1id, product\$1id, product\$1group\$1id, site\$1id, region\$1id, eff\$1start\$1date, eff\$1end\$1date | 

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


| Column | Data type | Required | Description | 
| --- | --- | --- | --- | 
|  company\$1id2  |  string  |  No  |  Company ID.  | 
|  vendor\$1tpartner\$1id2  |  string  |  Yes  |  Trading partner ID of the vendor.  | 
|  product\$1id2  |  string  |  Yes1  |  Product ID.  | 
|  product\$1group\$1id2  |  string  |  Yes1  |   Used if lead time is set at product-group level.  | 
|  site\$1id2  |  string  |  Yes1  |  Site where this product is being supplied.  | 
|  region\$1id2  |  string  |  Yes1  |  Used if lead time is set at geographical region level. Site level values will override this value.  | 
|  planned\$1lead\$1time  |  double  |  No  |  Planned lead time from vendor into company's site.  | 
|  planned\$1lead\$1time\$1dev  |  double  |  No  |  Standard deviation of lead time.  | 
|  actual\$1lead\$1time\$1mean  |  double  |  No  |  Field to store actual lead time computed from transactional data.  | 
|  actual\$1lead\$1time\$1sd  |  double  |  No  |  Standard deviation of actual lead time.  | 
|  actual\$1p50  |  double  |  No  |  50th percentile of actual lead time.  | 
|  actual\$1p90  |  double  |  No  |  90th percentile of actual lead time.  | 
|  shipping\$1cost  |  double  |  No  |  Inbound shipping cost from vendor to company.  | 
|  cost\$1uom  |  string  |  No  |  Unit of measure of shipping cost.  | 
|  we\$1pay  |  string  |  No  |  Yes or No indicator. Yes if company pays for inbound shipping, and No if vendor pays for shipping.  | 
|  eff\$1start\$1date  |  timestamp  |  Yes1  |  Date and time from when this record is effective.  | 
|  eff\$1end\$1date  |  timestamp  |  Yes1  |  Date and time till when this record is effective.  | 
|  sap\$1eina\$1\$1infnr  |  string  |  No  |  Record on number of purchases. Predicate key for SAP mapping. Upsert key for EINE.  | 
|  source\$1site\$1id 2  |  string  |  No  |  Site from where the inbound shipment is originated.  | 
|  trans\$1mode  |  string  |  No  |  Transportation mode. For example, ship, water, truck, or rail.  | 
| source | string | No | Source of data. | 
|  source\$1event\$1id  |  string  |  No  |  ID of the event created in the source system.  | 
|  source\$1update\$1dttm  |  timestamp  |  No  |  Date time stamp of the update made in the source system.  | 

1You must enter a value. When you ingest data from SAP or EDI, the default values for string and timestamp date type values are SCN\$1RESERVED\$1NO\$1VALUE\$1PROVIDED for *string*; and for *timestamp*, 1900-01-01 00:00:00 for start date, and 9999-12-31 23:59:59 for end date.

2Foreign key

**Foreign key (FK)**

The table below lists the columns with the associated foreign key.


| Column | Category | FK/Data entity | FK/Column | 
| --- | --- | --- | --- | 
| site\$1id | Network | site | id | 
| source\$1site\$1id | Network | site | id | 
| company\$1id | Organization | company | id | 
| region\$1id | Organization | geography | id | 
| vendor\$1tpartner\$1id | Organization | trading\$1partner | id | 
| product\$1group\$1id | Product | product\$1hierarchy | id | 
| product\$1id | Product | product\$1id | id |