ITEM VENDOR (VND)

Item Vendor Line Layout

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.

Note:  The application will use defaults for INSERTS ONLY if the input file field is not provided (blank).  The exception is MODIFIED_BY, which will be 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 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.