Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             ACREVENUE FILE

                            Activity Revenue

This file contains revenue recognition parameter information from AC14.1
(Activity Revenue).

REFERENCED BY

AC00.1    AC115     AC165     AC170     AC214     AC265
AC65.1    AC65.2    AC800

UPDATED BY

AC10.1    AC110     AC14.1    AC300     AC310     AC701

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ARV-ACTIVITY         Alpha 15                                    AC110   AC14.1
Activity             This is the activity for the revenue
                     recognition parameters.

ARV-MATRIX-LIST      Alpha 12                                    AC110   AC14.1
List                 This is the list of activities for          AC170
                     which you want to define revenue
                     recognition parameters.

ARV-REVENUE-MTHD     Alpha 1                                     AC110   AC14.1
Revenue Method       This is the method for calculating
                     revenue.
                     A = Accrual
                     P = Percent Complete
                     C = Completed Contract
                     9 = User Defined

ARV-CONTRACT-AMT     Signed 15.2                                 AC110   AC14.1
Contract Amount      This is the contract amount.

ARV-GROUP            Alpha 15                                    AC110   AC14.1
Group                If you are using the Percent Complete
                     method of revenue recognition, you can
                     use an account category group to
                     determine the account categories used to
                     calculate total cost-to-date and total
                     budget.

ARV-COMBINE-CONT     Alpha 1                                     AC110   AC14.1
Combine Contracts    This field indicates whether you want
                     to segment or combine (non-segment)
                     contracts.
                     N = Non Segment
                     S = Segment

ARV-PCT-CMPLT-MTHD   Alpha 1                                     AC110   AC14.1
Percent Complete     If the revenue method is Percent
Method               Complete, this field indicates the
                     calculation method you want to use: A
                     (Percent Complete) or B (Gross Margin).
                     A = Alternative A (% Complete)
                     B = Alternative B (Gross Margin)

ARV-BUDGET-TYPE      Alpha 1                                     AC110   AC14.1
Budget Type          This field indicates the budget type:       AC701
                     Amount or Units.
                     A = Amount
                     U = Unit

                         ACREVENUE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARVSET1   ACTIVITY                                               AC00.1  AC10.1
                                                                 AC110   AC115
                                                                 AC14.1  AC165
                                                                 AC170   AC214
                                                                 AC265   AC300
                                                                 AC310   AC65.1
                                                                 AC65.2  AC701
                                                                 AC800

                         ACREVENUE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY   Not Required

                            ARV-ACTIVITY       -> ACV-ACTIVITY

Acrevenuex2    ACREVENUEX   Required

                            ARV-ACTIVITY       -> ARX-ACTIVITY
                            Spaces             -> ARX-ACCT-CATEGORY

Acrptgrp       ACRPTGRP     Not Required

                            ARV-GROUP          -> RGH-GROUP

Mxlisthdr      MXLISTHDR    Not Required

                            "ACTVY"            -> MLH-OBJ-TYPE
                            ARV-MATRIX-LIST    -> MLH-MATRIX-LIST

                         ACREVENUE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acrevenuex     ACREVENUEX
                            Valid When ARV- != ARV-

                            ARV-ACTIVITY       -> ARX-ACTIVITY
                                                  ARX-ACCT-CATEGORY