Ansicht
Dokumentation

AD02ACTV - Activity Allocation Conversion

Description

Program to allocate actual activity costs from historical data. The input can be either an EXCEL spreadsheet or a sequential file that resides in the UNIX box. If an EXCEL file is used, the program must be run online. A sequential file can run in batch or online.

Requirements

Input can be from EXCEL spreadsheet using structure AD02ACTREC or from a sequential file using structure AD02SQFILE. The required fields are sending cost center, receiving object, activity type, activity quantity, activity unit, document date.

NOTE: all character fields except for the description must be in upper case.

EXCEL FILE with Tab Delimited type. Most fields should have TEXT as type including date which is DD.MM.YYYY. The controlling area field should include all characters (e.g. '0001' not '1'). The price & quantity fields should be numeric with 2 decimal places.

SEQUENTIAL FILE should have fields which may be numeric or character. Numeric would be right justified and character is left justified. The quantity and price fields have implied 2 decimal places (that means no period for decimal is allowed). The date field is numeric with format YYYYMMDD. If any numeric field is not used (i.e date/price), ALL ZEROS are required. Unlike an EXCEL file where the format is much more user friendly, a sequential file must have all characters accounted for based on AD02SQFILE structure.

Output

An error message report, a sucessful posting report, and a failure posting report are created after the run.

Example