Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Item Lead Time Line Layout (ILT)

The Item Lead Time (ITEM_LT) table stores the number of days required to perform a process or series of operations in order to have the item available.

The application cannot process Item Lead Time Line Types unless the Item exists. There can be one Item Lead Time entry for each Lead Time Type (for example, PI (Purchasing Inspection)).  The sum of all lines for the number of days is updated in the Item table.

You can view or update the information stored in this table on the Planning Details subtask of the Manage Parts screen in Costpoint Product Definition.

Note: The application uses default values for INSERTS ONLY if the input file field value is not provided. The exception is MODIFIED_BY, which is updated using the default value if no value is provided.
Input File Field Costpoint Column Column Type and Max Length Starting/Ending Position Required Values, Defaults, and Notes
Line Type Character 3 1 - 3 Yes ILT is used to indicate Item Lead Time information.
Item ID ITEM_ID Character 30 4 - 33 Yes If the Item ID / Item Revision ID / Lead Time Type combination exists, the Item Lead Time table is updated. If you did not select the Allow Multiple Revisions for Each Item check box on the Configure Product Definition Settings screen, the revision is not checked.

The fixed length file format accepts 30 characters while delimited file format accepts up to 50 characters.

Item Revision ID ITEM_RVSN_ID Character 3 34 - 36 No If the Item ID / Item Revision ID / Lead Time Type combination exists, the Item Lead Time table is updated. If you did not select the Allow Multiple Revisions for Each Item check box on the Configure Product Definition Settings screen, the revision is not checked. The default is a space.

The fixed length file format accepts 30 characters while delimited file format accepts up to 50 characters.

Lead Time Type S_LT_TYPE Character 3 37 - 39 Yes Must exist in the Lead Time Type (S_LT_TYPE) table.  Valid values are MM (Manufacturing), MP (Manufacturing Pick), MS (Manufacturing Stocking), PA (Purchasing Planning), PB (Putrchasing Buyer), PI (Purchasing Inspection), PR (Purchasing Receiving),  PV (Purchasing Vendor), MA (Manufacturing Planning), MI (Manufacturing Inspection).
Lead Time Days *LT_DAYS_ NO Integer 2 (maximum input file length - 3) 40 - 42 No The default is 0. The maximum value is 999. No embedded decimals or commas are allowed.
User ID last modified by *MODIFIED_BY Character 18 43 - 60 No The default is UPLOAD. If a value is not provided, the program modifies the MODIFIED_BY column using the current user ID as the default.

* Indicates columns that may be updated when changing an existing record with this preprocessor.