# inv\$1policy **Primary key (PK)** The table below lists the colum names that are uniquely identified in the data entity. | Name | Column | | --- | --- | | inv\$1policy | id, site\$1id, product\$1id, product\$1group\$1id, dest\$1geo\$1id, vendor\$1tpartner\$1id, eff\$1start\$1date, eff\$1end\$1date | The table below lists the column names supported by the data entity: | Column | Data type | Required | Description | | --- | --- | --- | --- | | id | string | Yes | Policy ID. | | site\$1id2 | string | Yes1 | Site ID for the policy being defined. | | product\$1id2 | string | Yes1 | Product ID for the policy being defined. | | company\$1id2 | string | No | Company ID. | | product\$1group\$1id2 | string | Yes1 | Product group ID that the policies are being defined for. Overridden at product level. | | dest\$1geo\$1id2 | string | Yes1 | Sets default values at geo level of the destination. | | vendor\$1tpartner\$1id2 | string | Yes1 | Trading partner ID of the vendor. This field is used when policies vary by vendor. | | status | string | No | Status of the inventory policy record, for example, on-hold, or active. | | ss\$1policy | string | No | Type of safety stock policy. The safety stock policy is associated with corresponding data. **abs\$1level** – Uses units specified in min/max safety stock (SS). Source is customer system or external tool. Ordering is suggested whenever inventory falls below min SS level. **sl** – Targets inventory between min and max service level for in-stock percentages. For example, if min/max service level is 50% and 90%, ordering will be done to maintain inventory between these percentiles of forecast over plan horizon. **DOC\$1dem** – Uses days of cover computed from historical demand as target level of inventory. **DOC\$1fcst** – Uses days of cover computed from forecast as target level of inventory. | | fallback\$1policy\$11 | string | No | Fallback inventory policy. | | repl\$1interval | double | No | Specifies the replenishment interval. | | min\$1safety\$1stock | double | No | For safety stock policy "abs\$1level". This field is absolute value of minimum safety stock level. | | max\$1safety\$1stock | double | No | For safety stock policy "abs\$1level". This is absolute value of maximum safety stock level. | | min\$1inventory\$1qty | double | No | Minimum inventory level quantity threshold. | | max\$1inventory\$1qty | double | No | Maximum inventory level quantity threshold. | | target\$1inventory\$1qty | double | No | Target inventory level quantity. | | woc\$1limit | double | No | Provides the weeks of cover limit. | | max\$1doc\$1limit | double | No | Provides the maximum days of cover value for safety stock policies "DOC\$1dem" and "DOC\$1fcst". | | min\$1doc\$1limit | double | No | Provides the minimum days of cover value for safety stock policies "DOC\$1dem" and "DOC\$1fcst". | | target\$1doc\$1limit | double | No | Provides the target value for safety stock policies "DOC\$1dem" and "DOC\$1fcst". | | permitted\$1var | double | No | Allowed variance used in policies where deviations from min,max, and target is allowed. | | min\$1sl | | No | Provides minimum service level (sl). Used for safety stock policy sl. | | target\$1sl | double | No | Target service level used of policy sl. | | max\$1sl | double | No | Provides maximum service level (sl). Used for safety stock policy. | | qty\$1uom | string | No | Quantity UOM associated with this inventory policy. | | min\$1order\$1qty | double | No | Minimum order quantity. | | max\$1order\$1qty | double | No | Maximum order quantity. | | order\$1qty\$1multiple | double | No | Order quantity computed in multiples of this value. | | holding\$1cost\$1percent | double | No | Annualized holding cost of inventory in percent. | | eff\$1start\$1date | timestamp | Yes1 | Dates from when the record is effective. | | eff\$1end\$1date | timestamp | Yes1 | Dates till when the record is effective. | | salvage\$1value\$1percentage | double | No | Product cost that can be expected to recovered at the end of Long Term Horizon. | | segment\$1id 2 | string | No | ID of segment associated with the inventory policy | | demand\$1planning\$1enabled | string | No | Identifies parts used for demand planning. | | inventory\$1planning\$1enabled | string | No | Identifies parts used for inventory planning. | | mrp\$1enabled | string | No | Identifies parts enabled for planning in MRP. | | purchased\$1item | string | No | Identifies parts that are purchased. | | 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 column names with the associated data entity and category: | Column | Category | FK/Data entity | FK/Column | | --- | --- | --- | --- | | site\$1id | Network | site | id | | segment\$1id | Planning | segmentation | segment\$1id | | company\$1id | Organization | company | id | | dest\$1geo\$1id | Organization | geography | id | | vendor\$1tpartner\$1id | Organization | trading\$1partner | id | | product\$1group\$1id | Product | product\$1hierarchy | id | | product\$1id | Product | product | id |