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.
|
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 tableis updated. If you did not select the Allow Multilple Revisions for Each Item check box on the Configure Product Definition Settings screen, the revision is not checked. |
|
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 tableis updated. If you did not select the Allow Multilple Revisions for Each Item check box on the Configure Product Definition Settings screen, the revision is not checked. |
|
Lead Time Type |
S_LT_TYPE |
Character 3 |
37 - 39 |
Yes |
Must exist in the Lead Time Type (S_LT_TYPE) table (in the Planning Details subtask of the Manage Parts screen). |
|
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 |
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.