The Item Vendor (ITEM_VEND) table stores vendor information for the item being processed, including vendors from which the item can be obtained, as well as the preferred vendor.
The application cannot process Item Vendor Line Types unless the Item exists. You can process multiple lines per item, and the Item ID, Item Revision ID, and Vendor ID combination must be unique.
You can view or update the information stored in this table in the Assign Vendors 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 |
"VND" is used to indicate Item Vendor information. |
Item ID |
ITEM_ID |
Character 30 |
4 - 33 |
Yes |
If Item ID, Item Revision ID, and Vendor ID combination exists, the Item Vendor 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, Vendor ID combination exists, the Item Vendor 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. |
Vendor ID |
VEND_ID |
Character 12 |
37 - 48 |
Yes |
Value must exist in the Vendor table (in Maintain Vendors screen in Costpoint Accounts Payable, Purchasing and/or Procurement Planning). Must exist for the user's Company ID. |
Preferred Vendor Flag |
*PREF_VEND_ CD |
Character 1 |
49 |
No |
Value must be "N" (No), "P" (Preferred), or "Y" (Yes). Default is "Y." Only one vendor per item can be "P" (Preferred). |
Accepted Amount |
*ACCPT_AMT |
Decimal 14.2 (maximum input file length - 15) |
50 - 64 |
No |
Default is "0." Input file format is "999999999999.99" (maximum 15 characters including the decimal point). Maximum value is "999999999999.99." No embedded commas are allowed. |
Accepted Quantity |
*ACCPT_QTY |
Decimal 14.4 (maximum input file length - 15) |
65 - 79 |
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. |
Average Days Early |
*AVG_DAYS_ EARLY_NO |
Integer 2 (maximum input file length - 4) |
80 - 83 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. |
Average Days Late |
*AVG_DAYS_ LATE_NO |
Integer 2 (maximum input file length - 4) |
84 - 87 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. |
Average Days Late From Original Due Date |
*AVG_DAYS_ ORIG_NO |
Integer 2 (maximum input file length - 4) |
88 - 91 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. |
Average Delivery Days |
*AVG_DEL_ DAYS_NO |
Integer 4 (maximum input file length - 4) |
92 - 95 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. |
Average PO Unit Cost |
*AVG_PO_ UNT_CST_ AMT |
Decimal 14.4 (maximum input file length - 15) |
96 - 110 |
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. |
Calculated End Date |
*CALC_END_ DT |
Date (maximum input file length - 10) |
111 - 120 |
No |
Value must be valid date format "YYYY-MM-DD." Default is null. |
Calculated Start Date |
*CALC_START_ DT |
Date (maximum input file length - 10) |
121 - 130 |
No |
Value must be valid date format "YYYY-MM-DD." Default is null. |
Number of Early Receipts |
*EARLY_ RECPTS_NO |
Integer 4 (maximum input file length - 4) |
131 - 134 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. |
Early Received Amount |
*EARLY_ RECV_ AMT |
Decimal 14.2 (maximum input file length - 15) |
135 - 149 |
No |
Default is "0." Input file format is "999999999999.99" (maximum 15 characters including the decimal point). Maximum value is "999999999999.99." No embedded commas are allowed. |
Early Received Quantity |
*EARLY_RECV_ QTY |
Decimal 14.4 (maximum input file length - 15) |
150 - 164 |
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. |
Last Purchase Order Date |
*LAST_PO_DT |
Date (maximum input file length - 10) |
165 - 174 |
No |
Value must be valid date format "YYYY-MM-DD." Default is null. |
Last Purchase Order ID |
*LAST_PO_ID |
Character 10 |
175 - 184 |
No |
Default is space. |
Last Quote Date |
*LAST_QT_DT |
Date (maximum input file length - 10) |
185 - 194 |
No |
Value must be valid date format "YYYY-MM-DD." Default is null. |
Last Quote ID |
*LAST_QT_ID |
Character 10 |
195 - 204 |
No |
Default is space. |
Number of Late Receipts from Original Date |
*LATE_RCPTS_ ORIG_NO |
Integer 4 (maximum input file length - 4) |
205 - 208 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. |
Number of Late Receipts |
*LATE_ RECPTS_ NO |
Integer 4 (maximum input file length - 4) |
209 - 212 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. |
Late Receipts Amount |
*LATE_RECV_ AMT |
Decimal 14.2 (maximum input file length - 15) |
213 - 227 |
No |
Default is "0." Input file format is "999999999999.99" (maximum 15 characters including the decimal point). Maximum value is "999999999999.99." Embedded commas are not allowed. |
Late Receipts Original Amount |
*LATE_RECV_ ORIG_AMT |
Decimal 14.2 (maximum input file length - 15) |
228 - 242 |
No |
Default is "0." Input file format is "999999999999.99" (maximum 15 characters including the decimal point). Maximum value is "999999999999.99." Embedded commas are not allowed. |
Late Receipts Original Quantity |
*LATE_RECV_ ORIG_QTY |
Decimal 14.4 (maximum input file length - 15) |
243 - 257 |
No |
Default is "0." Input file format is "9999999999.9999" (maximum 15 characters including the decimal point). Maximum value is "9999999999.9999." Embedded commas are not allowed. |
Late Receipts Quantity |
*LATE_RECV_ QTY |
Decimal 14.4 (maximum input file length - 15) |
258 - 272 |
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. |
Number of Receipt Lines |
*RECPT_LN_ NO |
Integer 4 (maximum input file length - 4) |
273 - 276 |
No |
Default is "0." Maximum value is "9999." No embedded decimals or commas are allowed. |
Received Amount |
*RECV_AMT |
Decimal 14.2 (maximum input file length - 15) |
277 - 291 |
No |
Default is "0." Input file format is "999999999999.99" (maximum 15 characters including the decimal point). Maximum value is "999999999999.99." No embedded commas are allowed. |
Received Quantity |
*RECV_QTY |
Decimal 14.4 (maximum input file length - 15) |
292 - 306 |
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. |
Rejected Amount |
*REJ_AMT |
Decimal 14.2 (Maximum input file length - 15) |
307 - 321 |
No |
Default is "0." Input file format is "999999999999.99" (maximum 15 characters including the decimal point). Maximum value is "999999999999.99." No embedded commas are allowed. |
Rejected Quantity |
*REJ_QTY |
Decimal 14.4 (maximum input file length - 15) |
322 - 336 |
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. |
User ID last modified by |
*MODIFIED_ BY |
Character 18 |
337 - 354 |
No |
If not provided, MODIFIED_BY column will be updated using the current user ID as the default. |
* Indicates columns that may be updated by this preprocessor.