You can use the Part Project (PART_PROJ) table to assign a project to a part and to enter information to override the standard part information.
The application cannot process Part Project Line Types unless the Item exists, and only Part item types will be processed. This Line Type will not be processed if the item is a Service or Good.
You can view or update the information stored in this table in the Part Project Data screen in Costpoint Product Definition. You must establish project IDs in the Maintain Project Master screen in Costpoint Project Setup before you can assign one to a part.
|
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 |
"PPJ" is used to indicate PART_PROJ information. |
|
Item ID |
ITEM_ID |
Character 30 |
4 -33 |
Yes |
If Item ID / Item Revision ID / Project ID combination exists, Part Project 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 / Project ID combination exists, Part Project 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. |
|
Project ID |
PROJ_ID |
Character 30 |
37 - 66 |
Yes |
Project ID must exist in Project (PROJ) table (established in the Maintain Project Master screen in Costpoint Project Setup). Must exist for user's company ID. |
|
Certificate of Conformance Flag |
*CERT_OF_ CNFRM_FL |
Character 1 |
67 |
No |
Value must be "Y" (Yes) or "N" (No). Default retrieved from PART table. |
|
Lot Required Flag |
*LOT_REQD_FL |
Character 1 |
68 |
No |
Value must be "Y" (Yes) or "N" (No). Default retrieved from the PART table. |
|
Order To Quantity |
*ORDER_TO_QTY |
Decimal 14.4 (maximum input file length - 15) |
69 - 83 |
No |
Default is "0." Input file format is "9999999999.9999" (maximum 15 characters including the decimal point). Maximum value is "9999999999.9999." No embedded commas are allowed. The Order To Quantity can be greater than zero if the Order Policy Type (in the Part table) is "O" (Order To Point). |
|
Preferred Warehouse ID |
*PREF_WHSE_ID |
Character 8 |
84 - 91 |
No. Required if Preferred Inventory Location ID is provided (insert only) |
If value is provided, value must exist in the Warehouses table (in the Inventory Controls menu). If value is provided, Preferred Inventory Location must be provided (insert record). Default is null. Must exist for user's company ID. |
|
Preferred Inventory Location ID |
*PREF_INVT_LOC_ ID |
Character 15 |
92 - 106 |
No. Required if Preferred Warehouse ID is provided (insert only) |
If value is provided, Preferred Warehouse ID must be provided (insert record). Default is null. |
|
Quality Control Required Flag |
*QC_REQD_ FL |
Character 1 |
107 |
No |
Value must be "Y" (Yes) or "N" (No). Default retrieved from Part table. |
|
Reorder Point Quantity |
*REORD_PT_QTY |
Decimal 14.4 (maximum input file length - 15) |
108 - 122 |
No |
Default is "0." Input file format is "9999999999.9999" (maximum 15 characters including the decimal point). Maximum value is "9999999999.9999." No embedded commas are allowed. The Reorder Point Quantity can be greater than zero only if the Order Policy Type (in the Part table) is "R" (Reorder Point). |
|
Safety Stock Quantity |
*SAFETY_ STK_ QTY |
Decimal 14.4 (maximum input file length - 15) |
123 - 137 |
No |
Default is "0." Input file format is "9999999999.9999" (maximum 15 characters including the decimal point). Maximum value is "9999999999.9999." No embedded commas are allowed. |
|
Serial Number Required Flag |
*SERIAL_ REQD_FL |
Character 1 |
138 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Source Inspection Flag |
*SRCE_INSP_FL |
Character 1 |
139 |
No |
Value must be "Y" (Yes) or "N" (No). Default retrieved from Part table. |
|
User ID last modified by |
*MODIFIED_BY |
Character 18 |
140 - 157 |
No |
If value is not provided, the system will update the MODIFIED_BY column using the current user ID as the default. |
|
MILSTRIP ID |
*MILSTRIP_ ID |
Character 30 |
158 - 187 |
No |
Default is space. |
|
Substitute Flag |
*SUBST_FL |
Character 1 |
188 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "Y." |
* Indicates columns that may be updated when changing an existing record with this preprocessor.