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 on the Manage 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 an Item ID/Item Revision ID combination exists, the Item Product table is updated. If you did not select the Allow Multiple Revisions for Each Item check box on the Configure Product Definition Settings screen, the revision is not checked. The fixed length file format accepts 30 characters while delimited file format accepts up to 50 characters. |
|
Item Revision ID |
ITEM_ RVSN_ID |
Character 3 |
34 -36 |
No |
If an Item ID/Item Revision ID combination exists, the Item Product table is updated. If you did not select the Allow Multiple Revisions for Each Item check box on the Configure Product Definition Settings screen, the revision is not checked. The default is a space. The fixed length file format accepts 3 characters while delimited file format accepts up to 10 characters. |
|
Certificate of Conformance Flag |
*CERT_OF_ CONF_FL |
Character 1 |
37 |
No |
The value must be Y (Yes) or N (No). The default is N. |
|
Defer Revenue Flag |
*DEFER_ REV_FL |
Character 1 |
38 |
No |
The value must be Y (Yes) or N (No). The default is N. |
|
Dimension Unit of Measure Code |
*DIMEN_ UM_CD |
Character 3 |
39 - 41 |
No |
If provided, a value must exist in the UM table. |
|
Installment Bill Flag |
*INSTALL_ BILL_FL |
Character 1 |
42 |
No |
The value must be Y (Yes) or N (No). The default is N. |
|
Model ID |
*MODEL_ ID |
Character 30 |
43 -72 |
No |
The default is a space. |
|
Item Sales Description |
*SALES_ ITEM_DESC |
Character 60 |
73 -132 |
No |
Default ITEM_DESC from ITEM table or item line. |
|
Item Sales Notes |
*SALES_ ITEM_NT |
Character 254 |
133 - 386 |
No |
The default is a space. Regardless of the file format, save a space if the file is space or blank. |
|
Shipping Quantity |
*SHIPPING_ QTY |
Decimal 14.4 (maximum input file length - 15) |
387 - 401 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
Shipping Depth |
*SHIP_ DPTH_QTY |
Decimal 14.4 (maximum input file length - 15) |
402 - 416 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
Shipping Height |
*SHIP_HGT_ QTY |
Decimal 14.4 (maximum input file length - 15) |
417 - 431 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
Shipping Instructions |
*SHIP_ INSTR_NT |
Character 254 |
432 - 685 |
No |
The default is a space. |
|
Shipping Tolerance Percentage Rate |
*SHIP_TOL_ PCT_RT |
Decimal 10.8 (maximum input file length - 11) |
686 - 696 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
Shipping Width |
*SHIP_ WDTH_QTY |
Decimal 14.4 (maximum input file length - 15) |
697 - 711 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
Shipping Weight |
*SHIP_WGT_ QTY |
Decimal 14.4 (maximum input file length - 15) |
712 - 726 |
No |
The default is 0. The input file format is 999999999999.99 (maximum 15 characters including the decimal point). The maximum value is 999999999999.99. No embedded commas are allowed. |
|
Shipping Weight Unit of Measure Code |
*SHIP_WGT_UM_CD |
Character 3 |
727 - 729 |
No |
If provided, a value must exist in the Units of Measure table. |
|
Source Inspection Flag |
*SRCE_INSP_FL |
Character 1 |
730 |
No |
The value must be Y (Yes) or N (No). The default is N. |
|
Sales Order Line Type Code |
*S_PROD_ LN_TYPE_CD |
Character 6 |
731 - 736 |
No |
The value can be DRP (Drop Shipment), INT (In Transit), INO (Invoice), INV (Inventory), or REC (Recurring). The default is N (None). |
|
User ID last modified by |
*MODIFIED_BY |
Character 18 |
737 - 754 |
No |
The default is UPLOAD. If a value is not provided, the MODIFIED_BY column is updated using the current user ID as the default. |
|
Component Processing |
COMP_PROC_FL |
Character 1 |
755 |
No |
The value must be Y (Yes) or N (No). The default is N. |
|
Issue Component |
ISSUE_COMP_ FL |
Character 1 |
756 |
No |
The value must be Y (Yes) or N (No). The 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 check box on the Configure Product Definition Settings screen, the revision is not checked. The fixed length file format accepts 30 characters while delimited file format accepts up to 50 characters. |
|
MPS Planning Part Rev |
*MPS PART RVSN |
Character 3 |
787 - 789 |
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 check box on the Configure Product Definition Settings screen, the revision is not checked. The fixed length file format accepts 3 characters while delimited file format accepts up to 10 characters. |
* Indicates columns that may be updated when changing an existing record with this preprocessor.