Concern Import
Concern Import
Header row labels with required fields highlighted in yellow.
Column Header Row Label Field Name Character Limit Comments A acctid Account Id 25 Must match a valid Account Id B controlid Control Id C origname Originator Name Must match an Account Type defined in Setup | Drop Down Lists D origemail Originator Email Entity Name (Accounts that are Personal Names, leave this Name field blank and use the following four Account Fields) E ownerid Concern Owner User Id User Login Id (Must match User Id) F suppid Supplier Id Supplier Account on the Reference Tab G distid Distributor Id Distributor Account on the Reference Tab H daterecvd Date Received MM/DD/YYYY I datedue Date Due MM/DD/YYYY J dateclosed Date Closed MM/DD/YYYY K timerecvd Time Received L timeclosed Time Closed M conctype Concern Type Must match a Concern Type defined in Setup | Classifcations N conccagegory Concern Category Must match a Concern Category defined in Setup | Classifcations O priority Priority P cause Cause Q summary Summary R problem Detail Description S resolution Resolution T reference1 Concern Reference 1 Concern Reference Tab, User Defined Field 1 U reference2 Concern Reference 2 Concern Reference Tab, User Defined Field 2 V reference3 Concern Reference 3 Concern Reference Tab, User Defined Field 3 W reference4 Concern Reference 4 Concern Reference Tab, User Defined Field 4 X reference5 Concern Reference 5 Concern Reference Tab, User Defined Field 5 Y reference6 Concern Reference 6 Concern Reference Tab, User Defined Field 6 Z reference7 Concern Reference 7 Concern Reference Tab, User Defined Field 7 AA reference8 Concern Reference 8 Concern Reference Tab, User Defined Field 8 AB reference9 Concern Reference 9 Concern Reference Tab, User Defined Field 9 AC reference10 Concern Reference 10 Concern Reference Tab, User Defined Field 10 AD productid Product Id Must match a Product Id defined in Setup | Product Information | Products AE serialno AF mfglocation Manufacturing Location Must match a Location defined in Setup | User Information | Locations AG shipqty Shipped Quantity AH defectqty Defective Quantity AI uofm Unit of Measure Must match a Unit of Measure defined in Setup | Product Information | Unit of Measure AJ prodmemo Product Memo AK prodinfo1 Product Field 1 Product Tab, User Defined Field 1 AL prodinfo2 Product Field 2 Product Tab, User Defined Field 2 AM prodinfo3 Product Field 3 Product Tab, User Defined Field 3 AN prodinfo4 Product Field 4 Product Tab, User Defined Field 4 AO prodinfo5 Product Field 5 Product Tab, User Defined Field 5 AP prodinfo6 Product Field 6 Product Tab, User Defined Field 6 AQ prodinfo7 Product Field 7 Product Tab, User Defined Field 7 AR prodinfo8 Product Field 8 Product Tab, User Defined Field 8 AS prodinfo9 Product Field 9 Product Tab, User Defined Field 9 AT prodinfo10 Product Field 10 Product Tab, User Defined Field 10
See also