Lookup Mass Addition Information

Lookup Mass Addition Template

Position Header Name Can Import Empty Suggested Values Notes
0 InsertOrUpdate No Insert or Update Use Insert to create a new record. Use Update to update an existing record. Header Row must begin with an asterisk (*).
1 LookupCode No   Must Be 40 Characters or less. Must be a unique value.
2 LookupDesc Yes   Must be 256 Characters or less.
3 ActiveFlag No Yes or No Must be 128 Characters or less. Validated against the ZZ_YESNO lookup values.
4 StartDate Yes   Must be a valid date. Assumed to be 1/1/1753 if left empty.
5 EndDate Yes   Must be a valid date. Assume to be 12/31/9999 if left empty.
6 NewLookupCode Conditional   Only use on an update when the LookupCode is being changed.
7 Attribute1 Yes   Must be 128 characters or less.
8 Attribute2 Yes   Must be 128 characters or less.
9 Attribute3 Yes   Must be 128 characters or less.
10 Attribute4 Yes   Must be 128 characters or less.
11 Attribute5 Yes   Must be 128 characters or less.
12 Attribute6 Yes   Must be 128 characters or less.
13 Attribute7 Yes   Must be 128 characters or less.
14 Attribute8 Yes   Must be 128 characters or less.
15 Attribute9 Yes   Must be 128 characters or less.
16 Attribute10 Yes   Must be 128 characters or less.


Lookup Value Mass Addition Template

Position Header Name Can Import Empty Suggested Values Notes
0 InsertOrUpdate No Insert or Update Use Insert to create a new record. Use Update to update an existing record. Header Row must begin with an asterisk (*).
1 LookupCode No   Must be 40 Characters or less. Must be a Unique Value.
2 LookupValueCode No   Must be 40 Characters or less. Must be a Unique Value withing the Lookup
3 LookupValueDesc No   Must be 256 Characters or less.
4 Attribute1 Yes   Must be 128 Characters or less.
5 Attribute2 Yes   Must be 128 Characters or less.
6 Attribute3 Yes   Must be 128 Characters or less.
7 Attribute4 Yes   Must be 128 Characters or less.
8 Attribute5 Yes   Must be 128 Characters or less.
9 Attribute6 Yes   Must be 128 Characters or less.
10 Attribute7 Yes   Must be 128 Characters or less.
11 Attribute8 Yes   Must be 128 Characters or less.
12 Attribute9 Yes   Must be 128 Characters or less.
13 Attribute10 Yes   Must be 128 Characters or less.
14 ActiveFlag No   Validated against the ZZ_YESNO lookup value. Must be 128 Characters or less.
15 StartDate Yes   Must be a valid date. Assumed to be 1/1/1753 if left empty.
16 EndDate Yes   Must be a valid date. Assume to be 12/31/9999 if left empty.
17 NewLookupValueCode Conditional   Only used during an update if the LookupValueCode is being changed.
Related Topics
Lookup and Lookup Value Information