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

Опубликовано: 16 Октябрь 2024
на канале: Fusion Nexgen Learning

3,257

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

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