ACGLTOTREV – Activity Total Revenue Amount

System
AC Billing Revenue (BR)
Prefix
GRV
Primary key
ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT
Fields
6
Updated by
4 programs
Referenced by
0 programs

ACGLTOTREV is the Activity Total Revenue Amount table in Lawson AC Billing Revenue (prefix GRV). It is indexed by ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT (GRVSET1). It is related 1:1 to ACACCTCAT, ACACTIVITY, GLNAMES and GLSYSTEM. It is updated by AC300, BR130, BR140 and BR530. The table has 6 fields, 1 index and 4 documented relations.

About ACGLTOTREV

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the GRV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#GRV-ACTIVITY PK
ACTIVITY		Alpha 15Required key. This is the activity for the total revenue and total loss amounts. Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in the Lawson Activity Management system. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. Activities are grouped or organized by activity levels. There are two types of activities: posting allowed and summary only. Use posting level activities to budget and maintain all posted transactions. Summary activities or macro activities combine information and balances from lower level activities for reporting and inquiries.BR130, BR530
#GRV-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5Required key. This is the account category for the total revenue and total loss amounts. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Lawson Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing.BR130, BR530
#GRV-COMPANY PK
COMPANY		Numeric 4Required key. This is the company number the transaction was posted to in the general ledger.BR130, BR530
#GRV-ACCT-UNIT PK
ACCT_UNIT		Alpha 15Required key. This is the accounting unit the transaction was posted to in the general ledger. The accounting unit is a shorthand notation representing a location (variable level) in the company structure. The accounting unit must be defined in the General Ledger Names file as a posting accounting unit.BR130, BR530
#GRV-TOTAL-REVENUE
TOTAL_REVENUE		Signed 18.2This is the life-to-date total revenue amount for this record.BR130, BR530
#GRV-TOTAL-LOSS
TOTAL_LOSS		Signed 18.2This is the life-to-date total loss amount for this record.—

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GRVSET1
  1. ACTIVITY
  2. ACCT-CATEGORY
  3. COMPANY
  4. ACCT-UNIT
PrimaryAC300, BR130, BR140, BR530

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACTIVITYGLNAMESGLSYSTEMACGLTOTREV

One to one (4) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequired
GRV-ACCT-CATEGORY→AAX-ACCT-CATEGORY
AcactivityACACTIVITYNot Required
GRV-ACTIVITY→ACV-ACTIVITY
GlnamesGLNAMESNot Required
GRV-COMPANY→GLN-COMPANY
GRV-ACCT-UNIT→GLN-ACCT-UNIT
GlsystemGLSYSTEMNot Required
GRV-COMPANY→GLS-COMPANY

Programs

Updated by (4)