Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACDEFREV


                             ACDEFREV FILE

The ACDEFREV file stores information about deferred revenue schedules for a
product contract. This field is primarily updated by Product Deferred Revenue
Schedule (BR53.1). The ACDEFREV file has relationships with the ACPRODDTL and
ACTRANS files.

REFERENCED BY

BR51.1    BR51.2    BR253

UPDATED BY

BR153     BR53.1    BR53.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DRD-CONTRACT           Alpha 10                                  BR53.1  BR53.2
Element: Contract

DRD-OBJ-ID             Numeric 12                                BR53.1  BR53.2
Object                 This is the object identifier. It is
Identification         used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

DRD-PRODUCT            Alpha 15                                  BR53.1  BR53.2
Element: Product

DRD-PROD-VERSION       Alpha 10                                  BR53.1  BR53.2
Element: Prod Version

DRD-SEQ-NBR            Numeric 6                                 BR53.1  BR53.2
Element: Sequence      An automatically assigned sequence
                       number.

DRD-DATE               Numeric 8  (yyyymmdd)                     BR53.1  BR53.2
Element: Date          This field displays the system date
                       when this was created.

DRD-AMOUNT             Signed 15.2                               BR53.1  BR53.2
Element: Adj Amt       This is the amounts by period for the
                       specified record.

DRD-PERCENT            Signed 7.3
Element: Percent

DRD-STATUS             Numeric 1                                 BR153   BR53.1
Element: Status        This field displays the status of the     BR53.2
                       transaction.
                       1 = To Process
                       2 = Processed
                       3 = Anticipated Hold
                       4 = Tentative Hold

DRD-ATN-OBJ-ID         Numeric 12                                BR153
Object
Identification

DRD-GLT-OBJ-ID         Numeric 12                                BR153
Object
Identification

                         ACDEFREV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DRDSET1   CONTRACT                                               BR51.1  BR53.1
          OBJ-ID                                                 BR53.2
          SEQ-NBR

DRDSET2   CONTRACT      KeyChange                                BR153   BR253
          PRODUCT                                                BR51.1  BR51.2
          PROD-VERSION                                           BR53.1  BR53.2
          OBJ-ID
          SEQ-NBR

DRDSET3   GLT-OBJ-ID    KeyChange
          ATN-OBJ-ID
          CONTRACT
          PRODUCT
          PROD-VERSION
          OBJ-ID
          SEQ-NBR

                         ACDEFREV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntract      ACCNTRACT    Required

                            DRD-CONTRACT        -> CNT-CONTRACT  (CNTSET1)

Acproddtl      ACPRODDTL    Required

                            DRD-CONTRACT        -> AHD-CONTRACT
                            DRD-PRODUCT         -> AHD-PRODUCT
                            DRD-PROD-VERSION    -> AHD-PROD-VERSION
                            DRD-OBJ-ID          -> AHD-OBJ-ID

Acprodhdr      ACPRODHDR    Required

                            DRD-CONTRACT        -> AHR-CONTRACT

Acprodlstx     ACPRODLSTX   Required

                            AHR-PRODUCT-LIST    -> BRQ-PRODUCT-LIST
                            DRD-PRODUCT         -> BRQ-PRODUCT
                            DRD-PROD-VERSION    -> BRQ-PROD-VERSION

Actrans        ACTRANS      Not Required

                            DRD-ATN-OBJ-ID      -> ATN-OBJ-ID

Gltrans        GLTRANS      Not Required

                            DRD-GLT-OBJ-ID      -> GLT-OBJ-ID