|
|
ACGLTOTREV FILE
AC GL Acct Unit Total Revenue
This file maintains total revenue and total loss amounts by activity, account
category, company, and accounting unit. It is updated by AC170 (Revenue
Calculation).
UPDATED BY
AC300 AC310 BR130 BR140 BR530
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GRV-ACTIVITY Alpha 15 BR130 BR530
Element: Activity Required 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.
GRV-ACCT-CATEGORY Alpha 5 BR130 BR530
Element: Account CategoRequired 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.
GRV-COMPANY Numeric 4 BR130 BR530
Element: Company Required key. This is the company
number the transaction was posted to in
the general ledger.
GRV-ACCT-UNIT Alpha 15 BR130 BR530
Element: Accounting UniRequired 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.
GRV-TOTAL-REVENUE Signed 18.2 BR130 BR530
Element: Total Revenue This is the life-to-date total revenue
amount for this record.
GRV-TOTAL-LOSS Signed 18.2
Element: Total Loss This is the life-to-date total loss
amount for this record.
ACGLTOTREV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GRVSET1 ACTIVITY AC300 AC310
ACCT-CATEGORY BR130 BR140
COMPANY BR530
ACCT-UNIT
ACGLTOTREV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
GRV-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acactivity ACACTIVITY Not Required
GRV-ACTIVITY -> ACV-ACTIVITY
Glnames GLNAMES Not Required
GRV-COMPANY -> GLN-COMPANY
GRV-ACCT-UNIT -> GLN-ACCT-UNIT
Glsystem GLSYSTEM Not Required
GRV-COMPANY -> GLS-COMPANY
|
