FARL - ROLLOVER
The FAUTZZ01 utility requires this code to roll data or convert Fixed Assets data from a legacy system into BusinessPLUS, or update a specific table. The file holding asset data is loaded from a remote location, and this common code holds generic settings that help the system read the file and insert the records and/or update system data correctly. The essential setting is the 3rd Associated Code stating the file's delimiter type. The process will run without the other settings and use the default date format of DU.
Note: See the Fixed Assets User Guide or the FA Conversion Guide for an overview and mechanics of the FAUTZZ01 conversion process.
Code Category: FARL
Code Value: ROLLOVER
Short Description: Not used.
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: Reserved for future use.
Associated Numeric Values
1-5: Reserved for future use.
Associated Codes
1: Reserved for future use.
2: "ADD X" or "AS IS." For example, "ADD E." This lets the program know which character value to add to the first position in the Asset ID. For example, the FAID value = "100" and "ADD E," the Asset ID would become "E100."
3: TAB or COMMA or PIPE. This is the delimiter type for the data file. "AS IS" tells the program to not do any formatting to the Asset ID.
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.