ACRETNGX – Activity Bill Retention Detail

System: AC Billing Revenue (BR)
Prefix: RGX
Primary key: ACTIVITY, SUM-ACCT-CAT, CTR-CAT-GRP, ACCT-CATEGORY, SEQ-NBR
Fields: 17
Updated by: 20 programs
Referenced by: 1 program

ACRETNGX is the Activity Bill Retention Detail table in Lawson AC Billing Revenue (prefix RGX). It is indexed by ACTIVITY, SUM-ACCT-CAT, CTR-CAT-GRP, ACCT-CATEGORY, SEQ-NBR (RGXSET1). It is related 1:1 to ACACCTCAT, ACACTIVITY and ACGLCODE. It is updated by AC300, BR01.1, BR01.2, BR02.3, BR120, BR121, BR122, BR123 and 12 more and referenced by BR450. The table has 17 fields, 1 index and 5 documented relations.

About ACRETNGX

No description in the Lawson data dictionary.

Fields (17)

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

Field / column	Type	Description & values	Updated by
`RGX-ACTIVITY` PK ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	BR01.1, BR122, BRIP.1
`RGX-SUM-ACCT-CAT` PK SUM_ACCT_CAT	Alpha 5	The name of the summary account category.	BR01.1, BR122, BRIP.1
`RGX-ACCT-CATEGORY` PK ACCT_CATEGORY	Alpha 5	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	BR01.1, BR122, BRIP.1
`RGX-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	BR01.1, BR122, BRIP.1
`RGX-STATUS` STATUS	Numeric 1	This field displays the status of the transaction.	BR01.1, BR02.3, BR120, BR121, BR122, BR123, BR140, BR151 +10 more
`RGX-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	BR01.1, BR122, BRIP.1
`RGX-DATE` DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	BR122, BRIP.1
`RGX-PST-ACTIVITY` PST_ACTIVITY	Alpha 15	—	BR01.1, BR122, BRIP.1
`RGX-PST-ACCT-CAT` PST_ACCT_CAT	Alpha 5	—	BR01.1, BR122, BRIP.1
`RGX-PST-GL-CODE` PST_GL_CODE	Alpha 4	—	BR122, BRIP.1
`RGX-RETAINAGE-AMT` RETAINAGE_AMT	Signed 18.2	—	BR01.1, BR122, BRIP.1
`RGX-RELEASED-AMT` RELEASED_AMT	Signed 18.2	—	BR01.1, BR02.3, BR120, BR121, BR122, BR123, BR140, BR151 +9 more
`RGX-BILL-AMT` BILL_AMT	Signed 18.2	—	BR01.1, BR02.3, BR120, BR121, BR122, BR123, BR140, BR151 +9 more
`RGX-INVOICE-PREFIX` INVOICE_PREFIX	Alpha 2	—	BR01.1, BR122, BRIP.1
`RGX-INVOICE-NBR` INVOICE_NBR	Numeric 8	—	BR01.1, BR122, BRIP.1
`RGX-OBJ-ID` OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	BR122, BRIP.1
`RGX-CTR-CAT-GRP` PK CTR_CAT_GRP	Alpha 5	—	BR01.1, BR122, BRIP.1

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`RGXSET1`	`ACTIVITY`, `SUM-ACCT-CAT`, `CTR-CAT-GRP`, `ACCT-CATEGORY`, `SEQ-NBR`	Primary		AC300, BR01.1, BR01.2, BR02.3, BR120, BR121, BR122, BR123 +13 more

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Field map
Acacctcat	ACACCTCAT	Required	`RGX-ACCT-CATEGORY` → `AAX-ACCT-CATEGORY`
Acactivity	ACACTIVITY	Required	`RGX-ACTIVITY` → `ACV-ACTIVITY`
Pst Acct Cat	ACACCTCAT	Required	`RGX-PST-ACCT-CAT` → `AAX-ACCT-CATEGORY`
Pst Activity	ACACTIVITY	Required	`RGX-PST-ACTIVITY` → `ACV-ACTIVITY`
Pst Gl Code	ACGLCODE	Required	`RGX-PST-GL-CODE` → `AGC-AC-GL-CODE`

Programs

Updated by (20)

AC300 Activity Group Purge
BR01.1 Retention and Unbilled
BR01.2 Bill Retention
BR02.3 Retainer Invoice Entry
BR120 Invoice Calculation
BR121 Invoice Print and Interface
BR122 Online batch invoice process
BR123 Product Invoice Cancel
BR140 Billing and Revenue Backout
BR151 Product Invoicing
BR152 Maintenance Invoicing
BR156 Maintenance Quote
BR20.1 Invoice Edit Contract
BR20.2 Invoice Edit Line
BR20.3 Invoice Edit Activity
BR20.4 Invoice Edit Activity and Account Category
BR20.5 Invoice Edit Transaction
BR420 Billing Invoice Report
BR521 Billing Import
BRIP.1 Invoice Print Program

Referenced by (1)

BR450 Activity Aging