|
Column Name |
Costpoint Table/Column |
Character Type |
Starting Position |
Ending Position |
Required/ |
Notes |
|
Line Type |
|
VARCHAR, 1 |
1 |
1 |
Required |
Must be "H" (Header). |
|
Quote |
QUOTE_ID |
VARCHAR, 10 |
2 |
11 |
Optional |
Required if you selected the Use Input File Values radio button. |
|
Vendor |
VEND_ID |
VARCHAR, 12 |
12 |
23 |
Required |
Must exist in Maintain Vendors screen. Vendor Status cannot be On Hold. |
|
Quote Type |
QT_TYPE_CD |
VARCHAR, 1 |
24 |
24 |
Optional |
Must exist in the Quote Types screen in Costpoint Procurement Planning. Otherwise, the default is null. |
|
Buyer |
BUYER_ID |
VARCHAR, 12 |
25 |
36 |
Optional |
Must exist in the Buyers screen in Costpoint Purchasing. Otherwise, the default is null. |
|
Expiration Date |
EXPIR_DT |
DATE, 10 |
37 |
46 |
Optional |
Must be in "YYYY-MM-DD" format. Otherwise, the default is null. See Processing Details.. |
|
Expiration Days |
EXPIR_DAYS_NO |
INTEGER, 4 |
47 |
50 |
Optional |
Default is zero. |
|
Quote Date |
QT_DT |
DATE, 10 |
51 |
60 |
Optional |
Must be in "YYYY-MM-DD" format. Otherwise, defaults to system date. |
|
RFQ |
ORIG_RFQ_ID |
VARCHAR, 10 |
61 |
70 |
Optional |
Default is space. |
|
Requisition |
ORIG_RQ_ID |
VARCHAR, 10 |
71 |
80 |
Optional |
Default is null. |
|
Contact's First Name |
CNTACT_FIRST_NAME |
VARCHAR, 20 |
81 |
100 |
Optional |
Default is space. |
|
Contact's Last Name |
CNTACT_LAST_NAME |
VARCHAR, 25 |
101 |
125 |
Optional |
Default is space. |
|
Phone |
PHONE_ID |
VARCHAR, 15 |
126 |
140 |
Optional |
Default is space. |
|
Fax |
FAX_ID |
VARCHAR, 15 |
141 |
155 |
Optional |
Default is space. |
|
FOB |
FOB_FLD |
VARCHAR, 16 |
156 |
171 |
Optional |
Default from Vendor. |
|
Terms |
TERMS_DC |
VARCHAR, 15 |
172 |
186 |
Optional |
Default from Vendor. |
|
Ship Via |
SHIP_VIA_FLD |
VARCHAR, 15 |
187 |
201 |
Optional |
Default from Vendor. |
|
Employee |
PURCH_EMPL_ID |
VARCHAR, 12 |
202 |
213 |
Optional |
Default is null. |
|
Header Notes |
QT_HDR_ NOTES |
VARCHAR, 254 |
214 |
467 |
Optional |
Default is space. |
|
Rate Group |
RATE_GRP_ID |
VARCHAR, 6 |
468 |
473 |
Optional |
|
|
Transaction Currency |
TRN_CRNCY_CD |
VARCHAR, 3 |
474 |
476 |
Optional |
|
|
Transaction Currency Date |
TRN_CRNCY_DT |
DATE |
477 |
486 |
Optional |
Must be in YYYY-MM-DD format. Default is system date. |
One QT_LN will be written per vendor quote line input record. Depending on the contents of the input record, up to five Vendor Quote Line Break (QT_LN_BRK) rows and up to three Vendor Quote Line Charge (QT_LN_CHG) rows may also be written.
|
Column Name |
Costpoint Table/Column |
Character Type |
Starting Position |
Ending Position |
Required/ |
Notes |
|
Line Type |
|
VARCHAR, 1 |
1 |
1 |
Required |
Must be "L" (Line). |
|
Quote |
|
VARCHAR, 10 |
2 |
11 |
Optional |
Required if you selected the Use Input File Values option. |
|
Vendor |
|
VARCHAR, 12 |
12 |
23 |
Required |
Required if you selected the Auto-Assign option. |
|
Item |
QT_LN.ITEM_ID |
VARCHAR, 30 |
24 |
53 |
Optional |
Default is space. |
|
Item Revision |
QT_LN.ITEM_RVSN_ID |
VARCHAR, 3 |
54 |
56 |
Optional |
Default is space. |
|
Misc Line Type |
QT_LN.MISC_LN_CHG_TYPE |
VARCHAR, 6 |
57 |
62 |
Optional |
Line charge type code must exist in the PO Line Charge Types screen in Costpoint Purchasing. Default is null. |
|
Unit of Measure |
QT_LN.QT_UM_CD |
VARCHAR, 3 |
63 |
65 |
Optional |
Defaults to the Item's default unit of measure code, or "EA" (Each) for miscellaneous line charge types. |
|
Unit Cost |
QT_LN.TRN_DFLT_GR_UN_AMT and QT_LN.TRN_DFLT_NT_UN_AMT |
Number 15 (Decimal 14,4) |
66 |
80 |
Required |
|
|
Minimum Quantity |
QT_LN.MIN_ QTY and QT_LN_BRK. MIN_QTY (first break point) |
Number 15 (Decimal 14,4) |
81 |
95 |
Optional |
Default is one. |
|
Break Quantity 1 Lead Time |
QT_LN_BRK.LT_ DAYS_NO |
INTEGER, 4 |
96 |
99 |
Optional |
Default is zero. |
|
Break Quantity 2 Cost |
QT_LN_BRK.TRN_NT_UN_CST_AMT and QT_LN_BRK.TRN_GR_UN_CST_AMT |
Number 15 (Decimal 14) |
100 |
113 |
Optional |
|
|
Break Quantity 2 |
QT_LN_BRK.MIN_ QTY |
Number 15 (Decimal 14) |
114 |
127 |
Optional |
Required if Break Qty 2 Cost is loaded. |
|
Break Quantity 2 Lead Time |
QT_LN_BRK.LT_ DAYS_NO |
INTEGER, 4 |
128 |
131 |
Optional |
Default is zero. |
|
Break Quantity 3 Cost |
QT_LN_BRK.TRN_NT_UN_CST_AMT and QT_LN_BRK.TRN_GR_UN_CST_AMT |
Number 15 (Decimal 14) |
132 |
145 |
Optional |
|
|
Break Quantity 3 |
QT_LN_BRK.MIN_ QTY |
Number 15 (Decimal 14) |
146 |
159 |
Optional |
Required if Break Qty 3 Cost is loaded. |
|
Break Quantity 3 Lead Time |
QT_LN_BRK.LT_ DAYS_NO |
INTEGER, 4 |
160 |
163 |
Optional |
Default is zero. |
|
Break Quantity 4 Cost |
QT_LN_BRK.TRN_NT_UN_CST_AMT and QT_LN_BRK.TRN_GR_UN_CST_AMT |
Number 15 (Decimal 14) |
164 |
177 |
Optional |
|
|
Break Quantity 4 |
QT_LN_BRK.MIN_ QTY |
Number 15 (Decimal 14) |
178 |
191 |
Optional |
Required if Break Qty 4 Cost is loaded. |
|
Break Quantity 4 Lead Time |
QT_LN_BRK.LT_ DAYS_NO |
INTEGER, 4 |
192 |
195 |
Optional |
Default is zero. |
|
Break Quantity 5 Cost |
QT_LN_BRK.TRN_NT_UN_CST_AMT and QT_LN_BRK.TRN_GR_UN_CST_AMT |
Number 15 (Decimal 14) |
196 |
209 |
Optional |
|
|
Break Quantity 5 |
QT_LN_BRK.MIN_ QTY |
Number 15 (Decimal 14) |
210 |
223 |
Optional |
Required if Break Qty 5 Cost is loaded. |
|
Break Quantity 5 Lead Time |
QT_LN_BRK.LT_ DAYS_NO |
INTEGER, 4 |
224 |
227 |
Optional |
Default is zero. |
|
Line Charge 1 Type |
QT_LN_CHG.LN_CHG_TYPE |
VARCHAR, 6 |
228 |
233 |
Optional |
Required if Line Charge 1 Cost is entered. |
|
Line Charge 1 Cost |
QT_LN_CHG.TRN_QT_LN_CHG_AMT |
Number 15 (Decimal 14,4) |
234 |
247 |
Optional |
Required if Line Charge 1 Type is entered. |
|
Line Charge 2 Type |
QT_LN_CHG.LN_CHG_TYPE |
VARCHAR, 6 |
248 |
253 |
Optional |
Required if Line Charge 2 Cost is entered. |
|
Line Charge 2 Cost |
QT_LN_CHG.TRN_QT_LN_CHG_AMT |
Number 15 (Decimal 14,4) |
254 |
267 |
Optional |
Required if Line Charge 2 Type is entered. |
|
Line Charge 3 Type |
QT_LN_CHG.LN_CHG_TYPE |
VARCHAR, 6 |
268 |
273 |
Optional |
Required if Line Charge 3 Cost is entered. |
|
Line Charge 3 Cost |
QT_LN_CHG.TRN_QT_LN_CHG_AMT |
Number 15 (Decimal 14,4) |
274 |
287 |
Optional |
Required if Line Charge 3 Type is entered. |
|
Ship ID |
QT_LN.SHIP_ID |
VARCHAR, 20 |
288 |
307 |
Optional |
Defaults to the default Ship ID in the Configure Purchasing Settings screen in Costpoint Purchasing. |
|
Manufacturer |
QT_LN.MANUF_ID |
VARCHAR, 10 |
308 |
317 |
Optional |
Defaults from Alternate Part for Item and Vendor ID. Required if Manufacturer Part is entered. |
|
Manufacturer Part |
QT_LN.MANUF_PART_ ID |
VARCHAR, 30 |
318 |
347 |
Optional |
Defaults from Alternate Part for Item and Vendor ID. Required if Manufacturer is entered. |
|
Manufacturer Part Rev |
QT_LN.MANUF_PART_RVSN_FLD |
VARCHAR, 3 |
348 |
350 |
Optional |
Defaults from Alternate Part for Item and Vendor ID. |
|
Vendor Part |
QT_LN.VEND_PART_ID |
VARCHAR, 30 |
351 |
380 |
Optional |
Defaults from Alternate Part for Item and Vendor ID. |
|
Vendor Part Rev |
QT_LN.VEND_PART_RVSN_FLD |
VARCHAR, 3 |
381 |
383 |
Optional |
Defaults from Alternate Part for Item and Vendor ID. |
|
Add Alternate Part |
|
VARCHAR, 1 |
384 |
384 |
Optional |
Default is "N." |
|
Commodity |
QT_LN.COMM_CD |
VARCHAR, 8 |
385 |
392 |
Optional |
Defaults from Item's Commodity Code. |
|
Project |
QT_LN.PROJ_ID |
VARCHAR, 30 |
393 |
422 |
Optional |
Default is null. |
|
Line Notes |
QT_LN.QT_LN_NOTES |
VARCHAR, 254 |
423 |
676 |
Optional |
Default is space. |