Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Item Vendor Line Layout (VND)

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 on the Assign Vendors to Items screen in Costpoint Product Definition.

Note: The application uses defaults for INSERTS ONLY if the input file field is not provided (blank). The exception is MODIFIED_BY, which is updated using the default if no value is provided.
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 the Item ID, Item Revision ID, and Vendor ID combination exists, the Item Vendor 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 Yes (If revisions are used) If the Item ID, Item Revision ID, and Vendor ID combination exists, the Item Vendor 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 30 characters while delimited file format accepts up to 50 characters.

Vendor ID VEND_ID Character 12 37 - 48 Yes The value must exist in the Vendor table (on the 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 The value must be N (No), P (Preferred), or Y (Yes).  The 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 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.
Accepted Quantity *ACCPT_QTY Decimal 14.4 (maximum input file length - 15) 65 - 79 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.
Average Days Early *AVG_DAYS_ EARLY_NO Integer 2 (maximum input file length - 4) 80 - 83 No The default is 0. The 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 The default is 0. The 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 The default is 0. The 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 The default is 0. The 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 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.
Calculated End Date *CALC_END_ DT Date (maximum input file length - 10) 111 - 120 No The value must be valid date format YYYY-MM-DD. The default is null.
Calculated Start Date *CALC_START_ DT Date (maximum input file length - 10) 121 - 130 No The value must be valid date format YYYY-MM-DD. The default is null.
Number of Early Receipts *EARLY_ RECPTS_NO Integer 4 (maximum input file length - 4) 131 - 134 No The default is 0.The 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 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.
Early Received Quantity *EARLY_RECV_ QTY Decimal 14.4 (maximum input file length - 15) 150 - 164 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.
Last Purchase Order Date *LAST_PO_DT Date (maximum input file length - 10) 165 - 174 No The value must be valid date format YYYY-MM-DD. The default is null.
Last Purchase Order ID *LAST_PO_ID Character 10 175 - 184 No The default is a space.
Last Quote Date *LAST_QT_DT Date (maximum input file length - 10) 185 - 194 No The value must be valid date format YYYY-MM-DD. The default is null.
Last Quote ID *LAST_QT_ID Character 10 195 - 204 No The default is a space.
Number of Late Receipts from Original Date *LATE_RCPTS_ ORIG_NO Integer 4 (maximum input file length - 4) 205 - 208 No The default is 0.The 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 The default is 0.The 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 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.
Late Receipts Original Amount *LATE_RECV_ ORIG_AMT Decimal 14.2 (maximum input file length - 15) 228 - 242 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.
Late Receipts Original Quantity *LATE_RECV_ ORIG_QTY Decimal 14.4 (maximum input file length - 15) 243 - 257 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.
Late Receipts Quantity *LATE_RECV_ QTY Decimal 14.4 (maximum input file length - 15) 258 - 272 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.
Number of Receipt Lines *RECPT_LN_ NO Integer 4 (maximum input file length - 4) 273 - 276 No The default is 0.The 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 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.
Received Quantity *RECV_QTY Decimal 14.4 (maximum input file length - 15) 292 - 306 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.
Rejected Amount *REJ_AMT Decimal 14.2 (Maximum input file length - 15) 307 - 321 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.
Rejected Quantity *REJ_QTY Decimal 14.4 (maximum input file length - 15) 322 - 336 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.
User ID last modified by *MODIFIED_ BY Character 18 337 - 354 No The default is UPLOAD. If not provided, the MODIFIED_BY column is updated using the current user ID as the default.

* Indicates columns that may be updated by this preprocessor.