The Item Product (ITEM_PRODUCT) table stores information for selling items including the sales and shipping information that accompanies a billed item.
The application cannot process Item Product Line Types unless the Item exists.
You can view or update the information stored in this table in the Set Up Item Billings 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 |
"PRD" is used to indicate Item Product information. |
|
Item ID |
ITEM_ID |
Character 30 |
4 -33 |
Yes |
If Item ID / Item Revision ID combination exists, Item Product table will be updated. If you did not select the Allow Multiple Revisions for Each Item checkbox in Produce 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 combination exists, Item Product table will be updated. If you did not select the Allow Multiple Revisions for Each Item checkbox in Produce Definition Settings, the revision will not be checked. |
|
Certificate of Conformance Flag |
*CERT_OF_ CONF_FL |
Character 1 |
37 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Defer Revenue Flag |
*DEFER_ REV_FL |
Character 1 |
38 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Dimension Unit of Measure Code |
*DIMEN_ UM_CD |
Character 3 |
39 - 41 |
No |
If provided, value must exist in the UM table. |
|
Installment Bill Flag |
*INSTALL_ BILL_FL |
Character 1 |
42 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Model ID |
*MODEL_ ID |
Character 30 |
43 -72 |
No |
Default space. |
|
Item Sales Description |
*SALES_ ITEM_DESC |
Character 60 |
73 -132 |
No |
Default space. |
|
Item Sales Notes |
*SALES_ ITEM_NT |
Character 254 |
133 - 386 |
No |
Default Item Description from the Item table or Item Line.
|
|
Shipping Quantity |
*SHIPPING_ QTY |
Decimal 14.4 (maximum input file length - 15) |
387 - 401 |
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. |
|
Shipping Depth |
*SHIP_ DPTH_QTY |
Decimal 14.4 (maximum input file length - 15) |
402 - 416 |
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. |
|
Shipping Height |
*SHIP_HGT_ QTY |
Decimal 14.4 (maximum input file length - 15) |
417 - 431 |
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. |
|
Shipping Instructions |
*SHIP_ INSTR_NT |
Character 254 |
432 - 685 |
No |
Default is space. |
|
Shipping Tolerance Percentage Rate |
*SHIP_TOL_ PCT_RT |
Decimal 10.8 (maximum input file length - 11) |
686 - 696 |
No |
Default is 0. Input file format is 99.99999999 (maximum 11 characters including the decimal point). Maximum value is 99.99999999. No embedded commas are allowed. |
|
Shipping Width |
*SHIP_ WDTH_QTY |
Decimal 14.4 (maximum input file length - 15) |
697 - 711 |
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. |
|
Shipping Weight |
*SHIP_WGT_ QTY |
Decimal 14.4 (maximum input file length - 15) |
712 - 726 |
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. |
|
Shipping Weight Unit of Measure Code |
*SHIP_WGT_UM_CD |
Character 3 |
727 - 729 |
No |
If provided, value must exist in the Units of Measure table (in the Product Definition Controls menu). |
|
Source Inspection Flag |
*SRCE_INSP_FL |
Character 1 |
730 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Sales Order Line Type Code |
*S_PROD_ LN_TYPE_CD |
Character 6 |
731 - 736 |
No |
Value can be "DRP" (Drop Shipment), "INT" (In Transit), "INO" (Invoice), "INV" (Inventory), or "REC" (Recurring). Default is "N" (None). |
|
User ID last modified by |
*MODIFIED_BY |
Character 18 |
737 - 754 |
No |
If value is not provided, MODIFIED_BY column will be updated using the current user ID as the default. |
|
Component Processing |
COMP_PROC_FL |
Character 1 |
755 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
Issue Component |
ISSUE_COMP_ FL |
Character 1 |
756 |
No |
Value must be "Y" (Yes) or "N" (No). Default is "N." |
|
MPS Planning Part |
*MPS Part ID |
Character 30 |
757 - 786 |
No |
Defaults to Item ID value if not applied. Must be a valid part/rev if not null. If you did not select the Allow Multiple Revisions for Each Item checkbox in Product Definition Settings, the revision will not be checked. |
|
MPS Planning Part Rev |
*MPS PART RVSN |
Character 3 |
787 - 789 |
No |
Defaults to Item Revision ID value if not applied. Must be a valid part/rev if not null. If you did not select the Allow Multiple Revisions for Each Item checkbox in Product Definition Settings, the revision will not be checked. |
* Indicates columns that may be updated when changing an existing record with this preprocessor.