ACDEFREV – Activity Deferred Revenue

System
AC Billing Revenue (BR)
Prefix
DRD
Primary key
CONTRACT, OBJ-ID, SEQ-NBR
Fields
11
Updated by
4 programs
Referenced by
1 program

ACDEFREV is the Activity Deferred Revenue table in Lawson AC Billing Revenue (prefix DRD). It is indexed by CONTRACT, OBJ-ID, SEQ-NBR (DRDSET1); alternate indexes: DRDSET2 and DRDSET3. It is related 1:1 to ACCNTRACT, ACPRODDTL, ACPRODHDR, ACPRODLSTX, ACTRANS and GLTRANS. It is updated by BR153, BR51.2, BR53.1 and BR53.2 and referenced by BR253. The table has 11 fields, 3 indexes and 6 documented relations.

About ACDEFREV

No description in the Lawson data dictionary.

Fields (11)

Column = COBOL field name without the DRD- 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
#DRD-CONTRACT PK
CONTRACT		Alpha 15Activity Management contract.BR53.1, BR53.2
#DRD-OBJ-ID PK
OBJ_ID		Numeric 12This 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.BR53.1, BR53.2
#DRD-PRODUCT SET2 SET3
PRODUCT		Alpha 15—BR53.1, BR53.2
#DRD-PROD-VERSION SET2 SET3
PROD_VERSION		Alpha 10—BR53.1, BR53.2
#DRD-SEQ-NBR PK
SEQ_NBR		Numeric 6The Sequence field show the sequence of a member as it is entered in either the Budget Member Names or Fiscal Year Variances subforms in AC87.1 (Financial OLAP Dimensions).BR53.1, BR53.2
#DRD-DATE
DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.BR53.1, BR53.2
#DRD-AMOUNT
AMOUNT		Signed 18.2—BR53.1, BR53.2
#DRD-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.—
#DRD-STATUS
STATUS		Numeric 1This field displays the status of the transaction.
  • 1 To Process
  • 2 Processed
  • 3 Anticipated Hold
  • 4 Tentative Hold
BR153, BR53.1, BR53.2
#DRD-ATN-OBJ-ID SET3
ATN_OBJ_ID		Numeric 12This 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.BR153
#DRD-GLT-OBJ-ID SET3
GLT_OBJ_ID		Numeric 12This 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.BR153

Indexes (3)

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
DRDSET1
  1. CONTRACT
  2. OBJ-ID
  3. SEQ-NBR
PrimaryBR51.1, BR53.1, BR53.2
DRDSET2
  1. CONTRACT
  2. PRODUCT
  3. PROD-VERSION
  4. OBJ-ID
  5. SEQ-NBR
KeyChangeBR153, BR253, BR51.1, BR51.2, BR53.1, BR53.2
DRDSET3
  1. GLT-OBJ-ID
  2. ATN-OBJ-ID
  3. CONTRACT
  4. PRODUCT
  5. PROD-VERSION
  6. OBJ-ID
  7. SEQ-NBR
KeyChange—

Relations

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

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AccntractACCNTRACTRequired
DRD-CONTRACT→CNT-CONTRACT (CNTSET1)
AcproddtlACPRODDTLRequired
DRD-CONTRACT→AHD-CONTRACT
DRD-PRODUCT→AHD-PRODUCT
DRD-PROD-VERSION→AHD-PROD-VERSION
DRD-OBJ-ID→AHD-OBJ-ID
AcprodhdrACPRODHDRRequired
DRD-CONTRACT→AHR-CONTRACT
AcprodlstxACPRODLSTXRequired
AHR-PRODUCT-LIST→BRQ-PRODUCT-LIST
DRD-PRODUCT→BRQ-PRODUCT
DRD-PROD-VERSION→BRQ-PROD-VERSION
ActransACTRANSNot Required
DRD-ATN-OBJ-ID→ATN-OBJ-ID
GltransGLTRANSNot Required
DRD-GLT-OBJ-ID→GLT-OBJ-ID

Programs

Updated by (4)

Referenced by (1)