Lawson Insight Technical Documentation |
|
ACRETNG
ACRETNG FILE
REFERENCED BY
AC04.1 BR00.1 BR18.1
UPDATED BY
AC300 AC310 BR01.1 BR01.2 BR02.3 BR120
BR121 BR122 BR123 BR140 BR151 BR152
BR156 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
BR420 BR521 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTG-ACTIVITY Alpha 15 BR01.2
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
RTG-SUM-ACCT-CAT Alpha 5 BR01.2
Element: Sum Acct Cat The name of the summary account
category.
RTG-ACCT-CATEGORY Alpha 5 BR01.2
Element: Acct Category Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the 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.
Valid account category types are:
cost
revenue
accrual
pass thru
RTG-PST-ACCT-CAT Alpha 5 BR01.2
Element: Pst Acct Cat
RTG-PST-GL-CODE Alpha 4 BR01.2
Element: Pst Gl Code
RTG-PERCENT Signed 7.3 BR01.2
Element: Percent The percentage determines how much
retention is held. It can either be a
percentage of each invoice, or it can be
a percentage of a total.
RTG-BAL-RET-AMT Signed 18.2 AC300 BR140
Element: Intl Amt BRIP.1
RTG-BAL-BILL-AMT Signed 18.2 AC300 BR02.3
Element: Intl Amt BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521
RTG-BAL-REL-AMT Signed 18.2 AC300 BR01.1
Element: Intl Amt BR02.3 BR120
BR121 BR122
BR123 BR140
BR151 BR152
BR156 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR521
RTG-CEILING Signed 18.2 AC300 BR01.2
Element: Intl Amt
RTG-SEQ-NBR Numeric 4 BR122 BRIP.1
Element: Seq Nbr An automatically assigned sequence
number.
RTG-UNBILL-RET-BAL Signed 18.2 AC300 BR120
Element: Intl Amt BR121 BR122
BR123 BR140
BR151 BR152
BR156 BR420
BR521 BRIP.1
RTG-CTR-CAT-GRP Alpha 5 BR01.2
Element: Ctr Cat Grp
ACRETNG FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTGSET1 ACTIVITY AC04.1 AC300
SUM-ACCT-CAT AC310 BR00.1
CTR-CAT-GRP BR01.1 BR01.2
ACCT-CATEGORY BR02.3 BR120
BR121 BR122
BR123 BR140
BR151 BR152
BR156 BR18.1
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521 BRIP.1
ACRETNG FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
RTG-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acactivity ACACTIVITY Required
RTG-ACTIVITY -> ACV-ACTIVITY
Acglcode ACGLCODE Not Required
RTG-PST-GL-CODE -> AGC-AC-GL-CODE
ACRETNG FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acretngx ACRETNGX
RTG-ACTIVITY -> RGX-ACTIVITY
RTG-SUM-ACCT-CAT -> RGX-SUM-ACCT-CAT
RTG-CTR-CAT-GRP -> RGX-CTR-CAT-GRP
RTG-ACCT-CATEGORY -> RGX-ACCT-CATEGORY
RGX-SEQ-NBR
|