The Part and Item tables in Costpoint store basic information for parts. Use the "PT2" input file to upload data to the ITEM, PART, and ITEM_UM tables. You can view or update the information stored for each field in the Maintain Parts screen in Costpoint Product Definition.
|
Input File Field |
Costpoint Column |
Column Type & Max Length |
Starting/Ending Position No. |
Required |
Values/Defaults/ Notes |
|
Line Type |
|
Character 3 |
1 - 3 |
Yes |
"PT2" is used to indicate PART 2 information. |
|
Part ID |
ITEM_ID, PART_ID |
Character 30 |
4 - 33 |
Yes |
If Part ID/Part Revision ID exists, ITEM, PART, and ITEM_UM tables will be updated. |
|
Part Revision ID |
ITEM_RVSN_ ID, PART_RVSN_ ID |
Character 3 |
34 - 36 |
Yes (if revisions are used) |
If Item ID/Item Revision ID exists, ITEM table will be updated. If you did not select the Allow Multiple Revisions for Each Item checkbox in Product Definition Settings, only the Item ID will be checked to see if it exists. Item Revision ID defaults with a space, and will always load a space if the Allow Multiple Revisions for Each Item checkbox is not selected. Load the item's revision in the Last Revision field. |
|
Item Description |
*ITEM. ITEM_DESC |
Character 60 |
37 - 96 |
Yes (NOT required for an update) |
|
|
Default Unit of Measure Code |
*ITEM. DFLT_UM_CD |
Character 3 |
97 - 99 |
No |
Default is "EA" (Each) Also used as Inventory U/M in ITEM_UM table. If ITEM_DFLT_UM_ CD is provided, U/M must exist in Units of Measure table (under Product Definition Controls). |
|
Commodity Code |
* ITEM. COMM_CD |
Character 8 |
100 - 107 |
No |
If a value is provided, must exist in Commodity Codes table (in the Product Definition Controls menu). 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. |
|
Make or Buy Code |
* PART. S_MAKE_BUY_CD |
Character 1 |
108 |
No |
Value must be "B" (Buy) or "M" (Make). Default is "B." |
|
Status Type |
* PART. S_STATUS_TYPE |
Character 1 |
109 |
No |
Value must be "E" (Estimating), "O" (Obsolete), "P" (Pre-Release), "R" (Release), or "S" (Phase-Out). Default is "R." |
|
Part Type |
* PART. S_PART_TYPE |
Character 1 |
110 |
No |
Value must be "B" (Buy With Components), "P" (Phantom), "R" (Reference), "S" (Standard), or "T" (Tool). Default is "S." |
|
As Required Flag |
* PART. AS_REQD_FL |
Character 1 |
111 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Planning Type |
* PART. S_PLAN_TYPE |
Character 1 |
112 |
No |
Value must be "N" (None), "P" (MRP), "R" (Reorder), or "S" (MPS). Default is "P." |
|
Buyer ID |
* ITEM. BUYER_ID |
Character 12 |
113 - 124 |
No |
Default is null. If Commodity Code is provided, Buyer ID will default if selected in Commodity Codes table (in the Product Definition Controls menu). If ITEM.BUYER_ID is provided, Buyer ID must exist in Buyers table (in the Purchasing Controls menu). 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. |
|
Planner ID |
* PART. PLANNER_ID |
Character 12 |
125 - 136 |
No |
Default is space. 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. |
|
Product Classification Code |
*PROD_CLASSIF_ CD |
Character 6 |
137 - 142 |
No |
Default is null. If a value is provided, must exist in Product Classifications table (under the Product Definition Controls menu). |
|
Hazardous Material Flag |
* ITEM. HAZMAT_FL |
Character 1 |
143 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Allow Overshipment Flag |
* ITEM. OVRSHP_ ALLOW_FL |
Character 1 |
144 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Receipt Tolerance Percentage Rate |
* ITEM.RECPT_ TOL_ PCT_RT |
Decimal 10.8 (maximum input file length - 4) |
145 - 148 |
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%. |
|
Commercial and Government Entity ID |
* PART. CAGE_ID_FLD |
Character 6 |
149 - 154 |
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. |
|
Military Specification ID |
* PART. MIL_SPEC_ID |
Character 20 |
155 - 174 |
No |
Default is space. |
|
National Stock Number |
* PART. NSN_ID |
Character 20 |
175 - 194 |
No |
Default is space. |
|
Quality Control Required Flag |
* PART. QC_REQD_FL |
Character 1 |
195 |
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). |
|
Certificate of Conformance Flag |
* PART. CERT_ OF_CNFRM_FL |
Character 1 |
196 |
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). |
|
Source Inspection Flag |
* PART. SRCE_INSP_FL |
Character 1 |
197 |
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). |
|
Lot Required Flag |
* PART. LOT_REQD_FL |
Character 1 |
198 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Serial Number Required Flag |
* PART. SERIAL_REQD_FL |
Character 1 |
199 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Last Assigned Lot ID |
* PART. LAST_LOT_ID |
Character 20 |
200 - 219 |
No |
Default is NULL. |
|
Last Serial ID |
* PART. LAST_SERIAL_ID |
Character 20 |
220 - 239 |
No |
Default is NULL. |
|
Shelf Life in Days |
* PART.SHELF_ LIFE_ DAYS_NO |
Integer (maximum input file length - 4) |
240 - 243 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. |
|
Sales Order Configuration Lot Required |
* PART.SO_CFG_ LOT_ REQD_FL |
Character 1 |
244 |
No |
Default is "N." Must be "Y" or "N." |
|
Sales Order Configuration Serial Required |
* PART.SO_CFG_ SER_ REQD_FL |
Character 1 |
245 |
No |
Default is "N." Must be "Y" or "N." |
|
Weight |
* PART. WEIGHT_NO |
Integer 2 (maximum input file length - 4) |
246 - 249 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. |
|
Order Policy Type |
* PART.S_ORD_ POLICY_ TYPE |
Character 1 |
250 |
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_ |
|
Period Order Days |
*PART.PD_ORD_ DAYS_ NO |
Integer (maximum input file length - 4) |
251 - 254 |
No. Required if Order Policy Type is "P."
|
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. Value must be greater than zero only if Order Policy Type is "P" (Period). |
|
Minimum Lot Size Quantity |
*PART.MIN_LOT_ SIZE_ QTY |
Decimal 14.4 (Maximum input file length - 11) |
255 - 265 |
No. Required if Order Policy Type is "R." 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 "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 |
*PART.MULT_LOT_ |
Decimal 14.4 (Maximum input file length - 11) |
266 - 276 |
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). |
|
Maximum Lot Size Quantity |
*PART.MAX_LOT_ SIZE_ QTY |
Decimal 14.4 (Maximum input file length - 11) |
277 - 287 |
No |
Default is "0." Must not be less than zero. If not, set to "0." |
|
Order Unit of Measure |
*ITEM_UM. UM_CD |
Character 3 |
288 - 290 |
No |
Will be added to ITEM_UM table with a U/M Type (S_UM_TYPE) of "O" (Order). If a value is not supplied, Default U/M is used. |
|
Sales Unit Of Measure |
*ITEM_UM. UM_CD |
Character 3 |
291 - 293 |
No |
Will be added to ITEM_UM table with a U/M Type (S_UM_TYPE) of "S" (Sales). If a value is not supplied, Default U/M is used. |
|
Inventory Flag |
* PART. INVT_FL |
Character 1 |
294 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "Y." |
|
Default Warehouse ID |
* PART. DFLT_WHSE_ID |
Character 8 |
295 - 302 |
No |
If provided, value must exist in the Warehouses table, and you must provide a Default Inventory Location. 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 |
* PART. DFLT_INVT_LOC_ ID |
Character 15 |
303 - 317 |
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 |
* PART.FLOOR_ STOCK_ FL |
Character 1 |
318 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Common Stock Flag |
* PART.COMMON_ STK_ FL |
Character 1 |
319 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Backflush Flag |
* PART. BKFLSH_FL |
Character 1 |
320 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Default Comp Lead Time Offset Days |
*DFLT_LT_ OFFSET_NO |
Integer (maximum input file length - 4) |
321 - 324 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. |
|
Scrap Factor Percentage Rate |
* PART.SCRAP_ FACT_ PCT_RT |
Decimal 10.8 (maximum input file length - 4) |
325 - 328 |
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%. |
|
Manufacturing BOM Yield Percentage Rate |
* PART. YIELD_PCT_RT |
Decimal 10.8 (maximum input file length - 4) |
329 - 332 |
No |
Default is "1," which indicates 100%. Input file format is "9.99" (maximum 4 characters including the decimal point). Maximum value is "1.00," which indicates 100%. |
|
ABC Classification Code |
*PART. ABC_CLASSIF_CD |
Character 1 |
333 |
No |
If a value is provided, must exist in ABC Classification table (code is system defined; assigned to the part in the Planning Part Data screen in Product Definition). 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. |
|
Count Frequency |
* PART.COUNT_ FREQ_NO |
Integer (maximum input file length - 3) |
334 - 336 |
No |
Default is "0." Maximum value is "999." No decimals allowed. |
|
Count Tolerance Percentage Rate |
* PART.COUNT_ TOL_ PCT_RT |
Decimal 10.8 (maximum input file length - 4) |
337 - 340 |
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%. |
|
Item Note |
* ITEM. ITEM_NT |
Character 254 |
341 - 594 |
No |
Default is space. |
|
Always Quote Flag |
* PART. ALWAYS_QT_FL |
Character 1 |
595 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Active Flag |
*ITEM. ACTIVE_FL |
Character 1 |
596 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "Y." |
|
Inspection Type |
*INSP_TYPE |
Character 1 |
597 |
No |
Default is space. |
|
Item Added Date |
*ITEM_ADDED_DT |
Date (maximum input file length - 10) |
598 - 607 |
No |
Value must be valid date format "YYYY-MM-DD." Default is system date. |
|
Last Order Date |
* ITEM. LAST_ORD_DATE |
Date (maximum input file length - 10) |
608 - 617 |
No |
Value must be valid date format "YYYY-MM-DD." System date defaults if Item Type is "S" (Service) or "G" (Good); defaults as null if Item Type is "P" (Part). |
|
Last Order ID |
* ITEM. LAST_ORD_ID |
Character 10 |
618 - 627 |
No |
Default is space. |
|
Status Change Date |
* PART.STATUS_ CHNG_ DT |
Date (maximum input file length - 10) |
628 - 637 |
No |
Value must be valid date format "YYYY-MM-DD." Default is System Date. |
|
Effectivity Type |
*PART. S_EFFECT_TYPE |
Character 1 |
638 |
No |
Value must be space (none), "D" (Date), or "S" (Serial). Default space. |
|
User ID last modified by |
*ITEM, PART, ITEM_ UM.MODIFIED_BY |
Character 18 |
639 - 656 |
No |
If a value is not provided, MODIFIED_BY column will be updated using the current user ID as the default. |
|
Common Stock Inventory Abbreviation |
* PART.CS_INVT_ ABBRV_CD |
Character 6 |
657 - 662 |
No |
Default 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 |
* PART.LST_ CHNG_ NOTICE_ID |
Character 15 |
663 - 677 |
No |
|
|
UPS Time Fence Days |
* PART.MPS_ |
Integer (maximum input file length) |
678 - 681 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. |
|
SO Time Fence Days |
* PART.SO_ |
Integer |
682 - 685 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. |
|
Cumulative Lead Time Days |
* PART. CUM_LT_DAYS_NO |
Integer |
686-689 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. |
|
Weight – Long |
* PART. WEIGHT_NO |
Decimal |
690 - 704 |
No |
Default is zero, |
|
Industry Class Code |
* ITEM_IND |
Character 8 |
705 - 712 |
No |
Default from Commodity Codes (COMM table). If not null, must exist in Industry Class table. |
|
UPC Code |
*ITEM.UPC_CD |
Character 14 |
713 - 726 |
No |
Default as Null. |
* Indicates columns that may be 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 of 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 |
|
|
|
|
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.
** Default is zero (0).