ITEM LEAD TIME (ILT)

Item Lead Time Line Layout

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 (e.g., "PI" (Purchasing Inspection)).  The sum of all lines for the number of days will be updated in the Item table.

You can view or update the information stored in this table in the Part Lead Time subtask of the Planning Part Data screen in Costpoint Product Definition.

The application uses default values for INSERTS ONLY if the input file field value is not provided.  The exception is MODIFIED_BY, which will be 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 Item ID / Item Revision ID / Lead Time Type combination exists, Item Lead Time table will be updated. If you did not select the Allow Multilple Revisions for Each Item checkbox in Product Definition Settings, the revision will not be checked.  

Item Revision ID

ITEM_RVSN_ID

Character 3

34 - 36

No

If Item ID / Item Revision ID / Lead Time Type combination exists, Item Lead Time table will be updated. If you did not select the Allow Multilple Revisions for Each Item checkbox in Product Definition Settings, the revision will not be checked.

Lead Time Type

S_LT_TYPE

Character 3

37 - 39

Yes

Must exist in Lead Time Type (S_LT_TYPE) table (in the Part Lead Time subtask of the Planning Part Data screen).

Lead Time Days

*LT_DAYS_ NO

Integer 2 (maximum input file length - 3)

40 - 42

No

Default is 0. 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 will modify 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.