PERL - ROLLOVER

This common code is required by the PEUTZZ utility that was created so that new clients can convert their Vendor Data from their legacy system to BusinessPLUS. The complete steps for this utility are detailed in the Person/Entity (PE) user guide.
Code Category: PERL
Code Value: ROLLOVER
Short Description: Reserved for future use.
Medium Description: INSERT ONLY or UPDATE ONLY or blank for both. Insert Only means that if the record is found, the process will not update. Update Only means that if the record is not found, the process will not insert. Blank means both options are available and will both update existing records and insert new records if no record exists.
Long Description: Used to describe the common code.
Associated Numeric Values
1: Reserved for future use.
2: Length of PE IDs. This is where you define the size of the PE ID for all tables. The process will calculate the length of the value you submit in the data file and add leading zeroes to make the correct length. For example, the data file contains the number 102, ID length is specified as 8, so the PE ID will become 00000102.
3-5: Reserved for future use.
Associated Codes
1: Reserved for future use.
2: "ADD " or "AS IS." For example, "ADD E." This tells the program to add a character value to the first position in the PE ID. Taking the example above and adding "ADD E," the PE ID would become E0000102. The length is still 8 a total of 8. Only 1 character is allowed and no special characters. "AS IS" tells the program to not do any formatting to the PE ID.
3: TAB or COMMA or PIPE. This is the delimiter type for the data file.
4: DT or DU or DV or DW or DX or DY or D6 or D8. This is the date format. They are as follows:
DT = MM/DD/YY or MMDDYY
DU = MM/DD/YYYY or MMDDYYYY
DV = DD/MM/YY
DW = DD/MM/YYYY
DX = YY/MM/DD
DY = YYYY/MM/DD
D6 = YYMMDD
D8 = YYYYMMDD
5: Reserved for future use.
Associated Description
1-4: Reserved for future use.
5: "ORACLE," "INFORMIX" or "SQL." This flag will inform the program which system you are working with so that any special handling dealing with datetime fields or reserved words can be done.