ACRETAIN – No description in the Lawson data dictionary

System
AC Billing Revenue (BR)
Prefix
RET
Primary key
ACTIVITY, RETAIN-ID
Fields
12
Updated by
9 programs
Referenced by
27 programs

ACRETAIN is a Lawson AC Billing Revenue table (prefix RET); no description in the lawson data dictionary. It is indexed by ACTIVITY, RETAIN-ID (RETSET1). It is related 1:1 to ACACCTCAT, ACACTIVITY, ACBILL and ACGLCODE and 1:M to ACRETAINX. It is updated by AC300, BR00.1, BR02.1, BR02.2, BR02.3, BR10.1, BR122, BR140 and 1 more and referenced by AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 and 19 more. The table has 12 fields, 1 index and 5 documented relations.

About ACRETAIN

No description in the Lawson data dictionary.

Fields (12)

Column = COBOL field name without the RET- 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
#RET-ACTIVITY PK
ACTIVITY		Alpha 15The contract or posting activity associated with the retainer.BR02.1
#RET-RETAIN-ID PK
RETAIN_ID		Numeric 6The Retainer Sequence defined for the activity in BR02. This is a user defined number that is unique by activity.BR02.1
#RET-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.BR02.1
#RET-RETAINER-TYPE
RETAINER_TYPE		Alpha 1The Retainer Type specified on BR02. The values are:
  • F First
  • L Last
  • S Specific
  • F First
  • L Last
  • S Specific
BR02.1
#RET-AMOUNT
AMOUNT		Signed 18.2—BR02.1, BR02.2
#RET-APPLIED-AMT
APPLIED_AMT		Signed 18.2The amount that has been applied to the retainer.AC300, BRIP.1
#RET-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Activity (AC10.1).BR02.1
#RET-STATUS
STATUS		Numeric 1This field displays the status of the transaction.
  • 1 Hold
  • 2 Applied
  • 3 Apply to Next
AC300, BR02.1, BR122, BR140, BRIP.1
#RET-RETAIN-GL-CD
RETAIN_GL_CD		Alpha 4The retainer GL Code specified in the Contract (BR10).—
#RET-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5The retainer account category specified in the Contract (BR10).—
#RET-RETAIN-RULE
RETAIN_RULE		Alpha 1The apply to rule specified in the Retainer (BR02). The values are:
  • 1 Apply to all Activities
  • 2 Apply to Retainer Activity
BR02.1
#RET-HIH-OBJ-ID
HIH_OBJ_ID		Numeric 12The processed invoice object Identification.AC300, BR02.3, BR122

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
RETSET1
  1. ACTIVITY
  2. RETAIN-ID
PrimaryAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATNot Required
RET-ACCT-CATEGORY→AAX-ACCT-CATEGORY
AcactivityACACTIVITYRequired
RET-ACTIVITY→ACV-ACTIVITY
AcbillACBILLRequired
RET-ACTIVITY→ACI-ACTIVITY
AcglcodeACGLCODENot Required
RET-RETAIN-GL-CD→AGC-AC-GL-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
AcretainxACRETAINX
RET-ACTIVITY→REX-ACTIVITY
RET-RETAIN-ID→REX-RETAIN-ID
—→REX-RETAIN-CODE

Programs

Updated by (9)

Referenced by (27)