ACRETNG – Activity Bill Retention

System
AC Billing Revenue (BR)
Prefix
RTG
Primary key
ACTIVITY, SUM-ACCT-CAT, CTR-CAT-GRP, ACCT-CATEGORY
Fields
13
Updated by
20 programs
Referenced by
3 programs

ACRETNG is the Activity Bill Retention table in Lawson AC Billing Revenue (prefix RTG). It is indexed by ACTIVITY, SUM-ACCT-CAT, CTR-CAT-GRP, ACCT-CATEGORY (RTGSET1). It is related 1:1 to ACACCTCAT, ACACTIVITY and ACGLCODE and 1:M to ACRETNGX. It is updated by AC300, BR01.1, BR01.2, BR02.3, BR120, BR121, BR122, BR123 and 12 more and referenced by AC04.1, BR00.1 and BR18.1. The table has 13 fields, 1 index and 4 documented relations.

About ACRETNG

No description in the Lawson data dictionary.

Fields (13)

Column = COBOL field name without the RTG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
RTG-ACTIVITY PK
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.BR01.2
RTG-SUM-ACCT-CAT PK
SUM_ACCT_CAT		Alpha 5The name of the summary account category.BR01.2
RTG-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5Account 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 thruBR01.2
RTG-PST-ACCT-CAT
PST_ACCT_CAT		Alpha 5—BR01.2
RTG-PST-GL-CODE
PST_GL_CODE		Alpha 4—BR01.2
RTG-PERCENT
PERCENT		Signed 7.3The 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.BR01.2
RTG-BAL-RET-AMT
BAL_RET_AMT		Signed 18.2—AC300, BR140, BRIP.1
RTG-BAL-BILL-AMT
BAL_BILL_AMT		Signed 18.2—AC300, BR02.3, BR120, BR121, BR122, BR123, BR140, BR151 +9 more
RTG-BAL-REL-AMT
BAL_REL_AMT		Signed 18.2—AC300, BR01.1, BR02.3, BR120, BR121, BR122, BR123, BR140 +10 more
RTG-CEILING
CEILING		Signed 18.2—AC300, BR01.2
RTG-SEQ-NBR
SEQ_NBR		Numeric 4An automatically assigned sequence number.BR122, BRIP.1
RTG-UNBILL-RET-BAL
UNBILL_RET_BAL		Signed 18.2—AC300, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +4 more
RTG-CTR-CAT-GRP PK
CTR_CAT_GRP		Alpha 5—BR01.2

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RTGSET1ACTIVITY, SUM-ACCT-CAT, CTR-CAT-GRP, ACCT-CATEGORYPrimaryAC04.1, AC300, BR00.1, BR01.1, BR01.2, BR02.3, BR120, BR121 +15 more

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequiredRTG-ACCT-CATEGORY → AAX-ACCT-CATEGORY
AcactivityACACTIVITYRequiredRTG-ACTIVITY → ACV-ACTIVITY
AcglcodeACGLCODENot RequiredRTG-PST-GL-CODE → AGC-AC-GL-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
AcretngxACRETNGXRTG-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

Programs

Updated by (20)

Referenced by (3)