The Part table stores additional information that is necessary for maintaining Part ("P") Item Types. The Item Type for each new ITEM line in the (ITM) record must be "P" (Part) in order to process new Part (PRT) line records, or a matching Part that exists in Costpoint. The data from the PRT file updates the PART table in Costpoint. The Part (PRT) layout is not required and is not compatible with Item Types that are Services (S) or Goods (G).
The information stored for each field can be viewed/updated in the Maintain Parts and Basic Part Data screens 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 |
"PRT" is used to indicate PART information. |
|
Part ID |
PART_ID |
Character 30 |
4 - 33 |
Yes |
If Part ID/Part Revision ID exists, PART table will be updated. If you did not select the Allow Multiple Revisions for Each Item checkbox in Product Definition settings, only the Part ID will be checked to see if it exists. |
|
Part Revision ID |
PART_RVSN_ ID |
Character 3 |
34 - 36 |
No |
If Part ID/Part Revision ID exists, PART table will be updated. If you did not select the Allow Multiple Revisions for Each Item checkbox in Product Definition settings, only the Part ID will be checked to see if it exists. The default value is space. |
|
ABC Classification Code |
*ABC_ CLASSIF_CD |
Character 1 |
37 |
No |
If a value is provided, it must exist in ABC Classification table. The default value is null. If the Separate Items by Company checkbox is selected in the Product Definition Corporate Settings subtask of the Product Definition Settings screen, this field's value must exist for your company ID. |
|
Always Quote Flag |
*ALWAYS_QT_ FL |
Character 1 |
38 |
No |
Value must be "Y" (Yes) or "N" (No). The default value is "N." |
|
BOM Assembly Last Changed User ID |
*ASY_CHNG_ USER_ID |
Character 12 |
39 - 50 |
No |
The default value is null. Always ignore this field on input file. If new part, set to null; otherwise, do not modify column. |
|
BOM Assembly Added Timestamp |
*ASY_ENTR_ DTT |
Timestamp (maximum input file length - 19) |
51 - 69 |
No |
Default is null. Input file format is "YYYY-MM-DD-hh.mm.ss" (year-month-day-hour.minute.second (maximum 19 characters, including separators)). Always ignore this field on input file. If new part, set to null; otherwise, do not modify column. |
|
BOM Assembly Added User ID |
*ASY_ENTR_ USER_ID |
Character 12 |
70 - 81 |
No |
Default is null. Always ignore this field on input file. If new part, set to null; otherwise, do not modify column. |
|
BOM Assembly Last Changed Timestamp |
*ASY_LAST_ CHNG_DTT |
Timestamp (maximum input file length - 19) |
82 - 100 |
No |
Default is null. Input file format is YYYY-MM-DD-hh.mm.ss (year-month-day-hour.minute.second (maximum 19 characters, including separators)). Always ignore this field on input file. If new part, set to null; otherwise, do not modify column. |
|
BOM Assembly Low Level Code Update Flag |
*ASY_LLCD_ UPDATE_FL |
Character 1 |
101 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." Always ignore this field on input file. If new part, set to "N;" otherwise, do not modify column. |
|
Assembly Notes |
*ASY_NOTES |
Character 254 |
102 - 355 |
No |
Default is space. Always ignore this field on input file. If new part, set to space; otherwise, do not modify column. |
|
As Required Flag |
*AS_REQD_ FL |
Character 1 |
356 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Backflush Flag |
*BKFLSH_FL |
Character 1 |
357 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
BOM Exists Flag |
*BOM_EXIST_ FL |
Character 1 |
358 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." Always ignore this field on input file. If new part, set to "N;" otherwise, do not modify column. |
|
Commercial and Government Entity ID |
*CAGE_ID_ FLD |
Character 6 |
359 - 364 |
No |
Default retrieved from the Company CAGE ID field in the Product Definition Settings screen (ITEM_SETTINGS table) if the Make/Buy Code input file field is "M." Otherwise, use a space. |
|
Certificate of Conformance Flag |
*CERT_OF_ CNFRM_FL |
Character 1 |
365 |
No |
Value must be "Y" (Yes) or "N" (No). Default retrieved from the Cert Conf Reqd checkbox in the Product Definition Settings screen (ITEM_SETTINGS table). |
|
Common Stock Flag |
*COMMON_ STK_FL |
Character 1 |
366 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Count Frequency |
*COUNT_ FREQ_NO |
Integer (maximum input file length - 3) |
367 - 369 |
No |
Default is "0." Maximum value is "999." No decimals allowed. |
|
Count Tolerance Percentage Rate |
*COUNT_TOL_ PCT_RT |
Decimal 10.8 (maximum input file length - 4) |
370 - 373 |
No |
Default is "0." Input file format is "9.99" (maximum four characters including the decimal point). Maximum value is "1.00," which indicates 100%. |
|
Default Comp Lead Time Offset Days |
*DFLT_LT_ OFFSET_NO |
Integer (maximum input file length - 4) |
374 - 377 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. |
|
Default Warehouse ID |
*DFLT_WHSE_ ID |
Character 8 |
378 - 385 |
No |
If a value is provided, value must exist in the Warehouses table, and Default Inventory Location must be provided. Both warehouses and inventory locations are maintained in the Inventory Controls menu. Default is null. If the Separate Items by Company checkbox is selected in the Product Definition Corporate Settings subtask of the Product Definition Settings screen, this field's value must exist for your company ID. |
|
Default Inventory Location |
*DFLT_INVT_ LOC_ID |
Character 15 |
386 - 400 |
No |
If Default Inventory Location is provided, Default Warehouse ID must be provided. Default Inventory Locations are assigned to warehouse IDs in the Locations screen in the Inventory Controls menu. Default is null. |
|
Floor Stock Flag |
*FLOOR_ STOCK_FL |
Character 1 |
401 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Inventory Flag |
*INVT_FL |
Character 1 |
402 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "Y." |
|
Last Alternate Part Sequence |
*LAST_ALT_ SEQ_NO |
Integer 2 (maximum input file length - 4) |
403 - 406 |
No |
Default is "0." Maximum value is 9999. No embedded decimals or commas are allowed. Always ignore this field on input file. If new part, set to "0;" otherwise, do not modify column. |
|
Last Assigned Lot ID |
*LAST_LOT_ ID |
Character 20 |
407 - 426 |
No |
Default is null. |
|
Last Serial ID |
*LAST_ SERIAL_ID |
Character 20 |
427 - 446 |
No |
Default is null. |
|
Lot Required Flag |
*LOT_REQD_ FL |
Character 1 |
447 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
BOM Low Level Code |
*LOW_LVL_ CD_NO |
Integer (Maximum input file length - 4) |
448 - 451 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. Always ignore this field on input file. If new part, set to "0;" otherwise, do not modify column. |
|
Military Specification ID |
*MIL_SPEC_ ID |
Character 20 |
452 - 471 |
No |
Default is space. |
|
Minimum Lot Size Quantity |
*MIN_LOT_ SIZE_QTY |
Decimal 14.4 (Maximum input file length - 11) |
472 - 482 |
No. Required if Order Policy Type is "R." If Order Policy Type is "M," you must supply either the Minimum Lot Size Quantity or the Multiple Lot Size Quantity.
|
Default is "0" if Order Policy Type is "P" (Period). Value must be greater than zero if Order Policy Type is "R" (Reorder Point) or "M" (Min/Mult Lot Size). If "M," either Minimum Lot Size Quantity or Multiple Lot Size Quantity must be greater than zero. Input file format is "999999.9999" (maximum 11 characters including decimal point). No embedded commas are allowed. Value cannot be greater than zero if Order Policy Type is "D" (Discrete Lot Size), "P" (Period), or "O" (Order to Point). |
|
Multiple Lot Size Quantity |
*MULT_LOT_ SIZE_QTY |
Decimal 14.4 (Maximum input file length - 11) |
483 - 493 |
No. If Order Policy Type is "M," you must supply either Minimum Lot Size Quantity or Multiple Lot Size Quantity. |
Default is "0" if Order Policy Type is "P" (Period). Value must be greater than zero if Order Policy Type is "M" (Min/Mult Lot Size). If Order Policy Type is "M," either Minimum Lot Size Quantity or Multiple Lot Size Quantity must be greater than zero. Input file format is "999999.9999" (maximum 11 characters including the decimal point). No embedded commas are allowed. Value cannot be greater than zero if Order Policy Type is "R" (Reorder Point), "P" (Period), "D" (Discrete Lot Size), or "O" (Order to Point). |
|
National Stock Number |
*NSN_ID |
Character 20 |
494 - 513 |
No |
Default space. |
|
Period Order Days |
*PD_ORD_ DAYS_NO |
Integer (maximum input file length - 4) |
514 - 517 |
No. Required if Order Policy Type is "P." |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. Value can be greater than zero only if Order Policy Type is "P" (Period). |
|
Planner ID |
*PLANNER_ ID |
Character 12 |
518 - 529 |
No |
Default space. Must exist for the user's company ID. |
|
Quality Control Required Flag |
*QC_REQD_ FL |
Character 1 |
530 |
No |
Value must be "Y" (Yes) or "N" (No). Default retrieved from the QC Insp Reqd checkbox in the Product Definition Settings screen (ITEM_SETTINGS table). |
|
Scrap Factor Percentage Rate |
*SCRAP_ FACT_PCT_ RT |
Decimal 10.8 (maximum input file length - 4) |
531 - 534 |
No |
Default is "0." Input file format is "9.99" (maximum 4 characters including the decimal point). Maximum value is "1.00," which indicates 100%. |
|
Serial Number Required Flag |
*SERIAL_ REQD_FL |
Character 1 |
535 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Shelf Life in Days |
*SHELF_LIFE_ DAYS_NO |
Integer (maximum input file length - 4)
|
536 - 539 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. |
|
Source Inspection Flag |
*SRCE_INSP_ FL |
Character 1 |
540 |
No |
Value must be "Y" (Yes) or "N" (No). Default retrieved from the Source Insp Reqd checkbox in the Product Definition Settings screen (ITEM_SETTINGS table). |
|
Status Change Date |
*STATUS_ CHNG_DT |
Date (maximum input file length - 10) |
541 - 550 |
No |
Value must be valid date format ("YYYY-MM-DD"). Default is system date. |
|
Assembly Release Status |
*S_ASY_REL_ CD |
Character 1 |
551 |
No |
Value must be "R" (Released), "P" (Partially Released), "U" (Unreleased), or "N" (Not Applicable). Default is "N." Always ignore this field on input file. If new part, set to "N;" otherwise, do not modify column. |
|
BOM Change Code |
*S_BOM_ CHNG_CD |
Character 1 |
552 |
No |
Value must be "M" (Manual), "E" (ECN), "S" (Mass Change), "C" (Copy BOM), or "N" (No Change). Default is "N." Always ignore this field on input file. If new part, set to "N;" otherwise, do not modify column. |
|
Effectivity Type |
*S_EFFECT_ TYPE |
Character 1 |
553 |
No |
Value must be space (none), "D" (Date), or "S" (Serial). Default is space. |
|
Make or Buy Code |
*S_MAKE_ BUY_CD |
Character 1 |
554 |
No |
Value must be "B" (Buy) or "M" (Make). Default is "B." |
|
Order Policy Type |
*S_ORD_ POLICY_ TYPE |
Character 1 |
555 |
No |
Value must be "D" (Discrete Lot Size), "M" (Min/Mult Lot Size), "O" (Order To Point), "P" (Period), or "R" (Reorder Point). Default is "D," or Default Order Policy Type from Product Definition Settings (ITEM_SETTINGS. S_ORD_POLICY_ TYPE). |
|
Part Type |
*S_PART_ TYPE |
Character 1 |
556 |
No |
Value must be "B" (Buy With Components), "P" (Phantom), "R" (Reference), "S" (Standard), "T" (Tool), or "L" - MPS Planning Only. Default is "S." |
|
Planning Type |
*S_PLAN_ TYPE |
Character 1 |
557 |
No |
Value must be "N" (None), "P" (MRP), "R" (Reorder), or "S" (MPS). Default is "P." |
|
Status Type |
*S_STATUS_ TYPE |
Character 1 |
558 |
No |
Value must be "E" (Estimating), "O" (Obsolete), "P" (Pre-Release), "R" (Release), or "S" (Phase-Out). Default is "R." |
|
Weight |
*WEIGHT_NO |
Decimal (14,4) |
559 - 573 |
No |
Default is "0." Maximum value is "9999999999.9999." Embedded commas are not allowed. |
|
Manufacturing BOM Yield Percentage Rate |
*YIELD_PCT_ RT |
Decimal 10.8 (maximum input file length - 4) |
574 - 579 |
No |
Default "1" to indicate 100%. Input file format is "9.99" (maximum four characters including the decimal point). Maximum value is "1.00," which indicates 100%. |
|
User ID last modified by |
*MODIFIED_ BY |
Character 18 |
580 - 597 |
No |
If this value is not provided, MODIFIED_BY column will be updated using the current user ID as the default. |
|
Maximum Lot Size Quantity |
*MAX_LOT_ SIZE_QTY |
Decimal 14.4 (Maximum input file length - 11) |
598 - 608 |
No |
Default is "0." Must not be less than zero. If not, set to "0." |
|
Sales Order Configuration Lot Required |
*SO_CFG_LOT_ REQD_FL |
Character 1 |
609 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Sales Order Configuration Serial Required |
*SO_CFG_SER_ REQD_FL |
Character 1 |
610 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Common Stock Inventory Abbreviation |
*CS_INVT_ ABBRV_CD |
Character 6 |
611 - 616 |
No |
If Input File's Common Stock Flag is "Y," set to value in Default Common Stock Inv Abbrev field in the Production Control Settings screen. Must be a valid Inventory Abbreviation code (in Inventory Projects screen in the Inventory Controls menu). |
|
Last Change Notice |
*LST_CHNG_ NOTICE_ID |
Character 15 |
617 - 631 |
No |
|
|
MPS Time Fence - Days |
*MPS_FENCE_NO |
Integer (maximum input file length - 4) |
632 - 635 |
No |
Defaults to zero. |
|
Sales Order Time Fence - Days |
*SO_FENCE_NO |
Integer (maximum input file length - 4) |
636 - 639 |
No |
Defaults to zero. |
|
Cumulative Lead Time Days |
*CUM_LT_DAYS_NO |
Integer (maximum input file length - 4) |
640 - 643 |
No |
Defaults to zero. |
* Indicates columns that may be updated when changing an existing record with this preprocessor.
The table below lists the actions, values and field requirements for each Order Policy Type. The fields in the Order Policy group box in the Planning Part Data screen (and/or the Planning Part Data subtask in the Maintain Parts screen) in Costpoint Product Definition will be active and will display all applicable Order Policy data for the part based on the Order Policy Type.
The Costpoint column names for the fields listed in the table are as follows (for Parts only):
"Max" - Maximum Lot Size Quantity (MAX_LOT_ SIZE_ QTY)
"Minimum" - Minimum Lot Size Quantity (MIN_LOT_ SIZE_ QTY).
"Multiple" - Multiple Lot Size Quantity (MULT_LOT_ SIZE_ QTY)
"Period Order Days" (PD_ORD_ DAYS_ NO)
|
Order Policy Type |
Active Field(s) |
Must be greater than zero (0) |
Cannot be greater than zero (0) |
|
Discrete Lot Size (D) |
Max |
(Max must be greater than or equal to zero) |
Period Order Days |
|
|
|
|
Minimum |
|
|
|
|
Multiple |
|
Min/Mult Lot Size (M) |
Minimum |
Minimum or Multiple |
Period Order Days |
|
|
Multiple |
|
|
|
|
Max |
(Max must be greater than or equal to zero) |
|
|
|
|
|
|
|
Order To Point (O) |
Max |
(Max must be greater than or equal to zero) |
Period Order Days |
|
|
|
The Order To Quantity (ORDER_TO_QTY in the PPJ record) must be greater than zero. |
Minimum |
|
|
|
|
Multiple |
|
Period (P) |
Max |
(Max must be greater than or equal to zero) |
Minimum** |
|
|
Period Order Days |
Period Order Days |
Multiple** |
|
Reorder Point (R) |
Max |
(Max must be greater than or equal to zero) |
Multiple |
|
|
Minimum* |
Minimum* |
Period Order Days |
* The Minimum field displays as "Reorder" (i.e., the Reorder Point Quantity) in the Planning Part Data screen. The Reorder Point Quantity (REORD_PT_QTY in the PPJ file) must be greater than zero if the Order Policy Type is "R."
** Default is zero (0).