AA999RIWAR – Owner/Sales update from MUNIS
Program to update OWNDAT and insert new Sales from the MUNIS system. This program runs from the Win2000 Server. It requires the SQLLDR utility, which used the EX902RIWAR.CTL to load a temp table called TEMP_EX902RIWAR.
NOTE: The specific fields
with permissible entries to be filled in or left blank are listed below.
Ignore fields that are not in the list next to the screens.
|
|
1. Job: Report name should always appear
here. For example, AA999RIWAR. 2. Server Name: Keep the server name
that first appears. 3.
Printer_Name: Select a
valid printer or keep the displayed printer if one is present. 4. Jurisdiction: Enter your jurisdiction. 5. Tax Year: Enter the current Tax Year. 6. Spool File Name: Enter AA999RIWAR.LIS
to create the file in text format. 13.
FCU: Formatting
code. Keep the default printer setting that is present when the screen
appears. If blank, enter NONE. 17. PARAM1 DATAFILE: Path and name of file from the
MUNIS system that will be loaded into ias4 for the MISMATCH. 18. PARAM2
MIN SALEDT: All sales must be greater than this sale date. 19. PARAM3
MIN |
|
|
Figure 1. SY41 (TOP) |
|
|
|
|
||
|
Figure 2. SY 41
(BOTTOM) |
|
Press
[Submit Job]. The system will notify you when the report is finished
Updated 7/21/2006