ACBLRATE FILE

                     Activity Billing Rates Header

This file contains billing rate information from the AC17 forms. It includes
the rate schedule and description, the billing rate attribute, unit type, and
currency code.

REFERENCED BY

AC15.1    AC15.4    AC190     AC217     AC40.1    AC41.1
AC42.1    AC530     AC54.1    AC540     AC70.3

UPDATED BY

AC17.1    AC17.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ALR-RATE-SCHEDULE    Alpha 12                                    AC17.1  AC17.2
Rate Schedule        Required key. This is the name of a
                     billing rate schedule. Each rate
                     schedule is based on one attribute.

ALR-MATRIX-CAT       Alpha 12                                    AC17.1  AC17.2
Attribute            Required. A billing rate attribute can
                     be defined as part of the key for
                     Activity Management billing
                     transactions.

                     The attribute must be assigned to the
                     object type ACTRANS in GL05.1 (Source
                     Code).

ALR-DESCRIPTION      Alpha 30  (Lower Case)                      AC17.1  AC17.2
Rate Schedule        Required. This is the description of
Description          the rate schedule.

ALR-UNIT-TYPE        Alpha 1                                     AC17.1  AC17.2
Unit Type            This field indicates whether the rate
                     schedule is for hours (time and
                     materials) or units (units of
                     production).
                     U = Units
                     H = Hours

ALR-CURRENCY-CODE    Alpha 5                                     AC17.1  AC17.2
Currency Code        This code represents the base currency
                     defined for the company in the General
                     Ledger system.

ALR-UOM              Alpha 4
Unit of Measure      This field contains the valid stock
                     unit of measure for this item.


                         ACBLRATE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ALRSET1   RATE-SCHEDULE                                          AC15.1  AC15.4
                                                                 AC17.1  AC17.2
                                                                 AC190   AC217
                                                                 AC40.1  AC41.1
                                                                 AC42.1  AC530
                                                                 AC54.1  AC540
                                                                 AC70.3

                         ACBLRATE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acblratex      ACBLRATEX

                            ALR-RATE-SCHEDULE    -> ALX-RATE-SCHEDULE
                                                    ALX-MATRIX-CAT
                                                    ALX-MX-VALUE
                                                    ALX-EFFECTIVE-DT