SIRL - ROLLOVER

Code Category: SIRL
Code Value: ROLLOVER
Short Description: Reserved for future use.
Medium Description: Reserved for future use.
Long Description: Reserved for future use.
Associated Numeric Values
1: Reserved for future use.
2: Length of Vendor ID. This is where you define the size of the Vendor 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 vendor ID will become 00000102. This is ignored if the "AS IS" option is specified.
3-5: Reserved for future use.
Associated Codes
1: Reserved for future use.
2: "ADD" or "AS IS." An example of the "ADD" option would be "ADD V." This tells the program to add a character value to the first position in the Vendor ID. Taking the example above and adding "ADD V," the vendor id would become V0000102. The length is still a total of 8. Only 1 character is allowed and no special characters. An example of the "AS IS" option would be "AS IS." This tells the program to do no manipulation to the SIR-PE-ID field.
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: Reserved for future use.
2: Set ID. This is the default Set ID that can be used instead of specifying an SIR-BATCH-ID in the input file. When used, all records in the file are for that one Set.
3-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.