NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for importing a record in Supplier Portal User Import.
|
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
|
A |
1 |
User Name |
150 |
Character |
Yes |
Enter a portal user name for the supplier portal user. You can enter a user name for which a portal user was not previously created. If you do this, you must enter a password for the Password field (position 2) and an email address for the Email Address field (position 3). |
|
B |
2 |
Password |
54 |
Character |
Yes, only if the user name entered for the User Name field (position 1) is not a valid portal user name |
Enter the user’s password if you are creating a new portal user (in addition to a new supplier portal user). |
|
C |
3 |
Email Address |
60 |
Character |
Yes, only if the user name entered for the User Name field (position 1) is not a valid portal user name |
Enter the user’s email address if you are creating a new portal user (in addition to a new supplier portal user). |
|
D |
4 |
Disable Login |
3 |
Yes/No |
No |
Enter Yes if you want to prevent the portal user from logging in. If this field is blank, it defaults to No. |
|
E |
5 |
Site ID |
12 |
Character |
Yes |
Enter a valid supplier portal site ID for the supplier portal user. |
|
F |
6 |
Default Language |
30 |
Character |
Yes |
Enter a valid default language for the supplier portal user. NOTE You can only use languages for which your company has licensed the associated language packs. |
|
G |
7 |
Supplier Code |
12 |
Character |
No |
Enter a valid supplier code for the supplier portal user. |
|
H |
8 |
Shipper ID |
12 |
Character |
No |
Enter a valid shipper ID for the supplier portal user. |
|
I |
9 |
Role |
12 |
Character |
Yes |
Enter a valid supplier portal role for the supplier portal user. For information on setting up supplier portal roles, see Supplier Portal Role Maintenance. |
|
J |
10 |
Time Option |
7 |
Character |
No |
Enter one of the following values to specify whether the user prefers a 12-hour or 24-hour clock for displayed times:
If this field is blank, it defaults to 12 Hour. |
|
K |
11 |
Attachment Group |
12 |
Character |
Yes, only if an attachment type is entered in the Attachment Type field (position 12) |
Enter a valid attachment group for the supplier portal user. For information on setting up attachment groups, see Attachment Group Maintenance. |
|
L |
12 |
Attachment Type |
12 |
Character |
No |
Enter a valid attachment type for the supplier portal user. For information on setting up attachment types, see Attachment Type Maintenance. |
|
M |
13 |
Notes Group |
12 |
Character |
Yes, only if a notes type is entered in the Notes Type field (position 14) |
Enter a valid default notes group for the supplier portal user. For information on setting up notes groups, see Note Group Maintenance. |
|
N |
14 |
Notes Type |
12 |
Character |
No |
Enter a valid default notes type for the supplier portal user. For information on setting up notes types, see Note Type Maintenance. |
|
O |
15 |
Supplier Portal User Disable Login |
3 |
Yes/No |
No |
Enter Yes if you want to prevent the supplier portal user from logging in. If this field is blank, it defaults to No. |
|
P |
16 |
Can View Costs |
3 |
Yes/No |
No |
Enter Yes if the supplier portal user can view costs. If this field is blank, it defaults based on the supplier portal user's role. |
|
Q |
17 |
Can Access All Suppliers |
3 |
Yes/No |
No |
Enter Yes if the supplier portal user can access all suppliers. If this field is blank, it defaults based on the supplier portal user's role. |
|
R |
18 |
Can Access All Shippers |
3 |
Yes/No |
No |
Enter Yes if the supplier portal user can access all shippers. If this field is blank, it defaults based on the supplier portal user's role. |
|
S |
19 |
Can Access Transfer Orders |
3 |
Yes/No |
No |
Enter Yes if the supplier portal user can access transfer orders. If this field is blank, it defaults based on the supplier portal user's role. |
|
T |
20 |
Can Access Transactions with Blank Shipper |
3 |
Yes/No |
No |
Enter Yes if the supplier portal user can access transactions with blank shippers. If this field is blank, it defaults based on the supplier portal user's role. |
|
U |
21 |
Can Access Blanket Purchase Order Detail |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Blanket Purchase Order Detail supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
V |
22 |
Can Access Container Creation |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Container Creation supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
W |
23 |
Can Access Container Detail |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Container Detail supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
X |
24 |
Can Access Container Documents |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Container Documents supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
Y |
25 |
Can Access Container Lot Detail |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Container Lot Detail supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
Z |
26 |
Can Access Container Notes |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Container Notes supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
AA |
27 |
Can Access Import Shipments and Containers |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Import Shipments and Containers supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
AB |
28 |
Can Access Purchase Order Charges |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Purchase Order Charges supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
AC |
29 |
Can Access Purchase Order Detail |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Purchase Order Detail supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
AD |
30 |
Can Access Purchase Order Documents |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Purchase Order Documents supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
AE |
31 |
Can Access Purchase Order Notes |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Purchase Order Notes supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
AF |
32 |
Can Access Shipment and Container Tracking |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Shipment and Container Tracking supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
AG |
33 |
Can Access Shipment Charges |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Shipment Charges supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
AH |
34 |
Can Access Shipment Creation |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Shipment Creation supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
AI |
35 |
Can Access Shipment Detail |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Shipment Detail supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
AJ |
36 |
Can Access Shipment Documents |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Shipment Documents supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
AK |
37 |
Can Access Shipment Notes |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access the Shipment Notes supplier portal page. If this field is blank, it defaults based on the supplier portal user's role. |
|
AL |
38 |
Can Perform Production Monitoring Tasks |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to perform supplier production monitoring tasks. If this field is blank, it defaults based on the supplier portal user's role. |
|
AM |
39 |
Can Perform Product Lifecycle Management Tasks |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to perform product lifecycle management tasks. If this field is blank, it defaults based on the supplier portal user's role. |
|
AN |
40 |
Can Access Production Monitoring Tasks |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access supplier production monitoring tasks. If this field is blank, it defaults based on the supplier portal user's role. |
|
AO |
41 |
Can Access Product Lifecycle Management Tasks |
3 |
Yes/No |
No |
Enter Yes if you want to allow the supplier portal user to access product lifecycle management tasks. If this field is blank, it defaults based on the supplier portal user's role. |
Before using this import, the following must be set up:
supplier portal sites
supplier portal roles
There must be a record of blank space(s) at the end of an import file.