How to bulk import Lookup Types and Lookup Codes using File Based Loader

This video will provides steps to bulk import Lookup Types and Lookup Codes using File Based Loader.


Lookup Header Fields and Description
Header Field--- Mandatory/O - Optional--- Data Type Size Description
LookupType--- -M--- String- 30--- -Lookup Type
LookupCode M String 30
DisplaySequence O Long
EnabledFlag M String 1 Value Y/N
StartDateActive O Date Format to use is
dd/M/yyyy
Example 22/5/2015
EndDateActive O Date
Meaning M String 80
Description O String 240
Tag O String 150

-------------------------------------------------------------------------------------------------------------
SAMPLE LOOKUP CODE FILE

LookupType|LookupCode|DisplaySequence|EnabledFlag|StartDateActive|EndDateActive|Meaning|Description|Tag

------------------------------------------------------------------------------------------------------------------------------------------
SAMPLE LOOKUP TYPE FILE

LookupType|Meaning|Description|ModuleType|ModuleKey|ReferenceGroupName
--------------------------------------------------------------------------------------------------------------------------------------------

To find the ModuleType and ModuleKey for standard lookup types:

For Query Put a comment will share on the comment section

----------------------------------------------------------------------------------------------------------------------