ACHISTGM – Invoice GM

System
AC Billing Revenue (BR)
Prefix
IHG
Primary key
HIH-OBJ-ID, CONTRACT-ACTVY, RECORD-TYPE, ACTIVITY
Fields
6
Updated by
3 programs
Referenced by
0 programs

ACHISTGM is the Invoice GM table in Lawson AC Billing Revenue (prefix IHG). It is indexed by HIH-OBJ-ID, CONTRACT-ACTVY, RECORD-TYPE, ACTIVITY (IHGSET1). It is related 1:1 to ACACTIVITY and ACHISTHDR. It is updated by BR122, BR300 and BRIP.1. The table has 6 fields, 1 index and 3 documented relations.

About ACHISTGM

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the IHG- 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
#IHG-HIH-OBJ-ID PK
HIH_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.BR122, BRIP.1
#IHG-CONTRACT-ACTVY PK
CONTRACT_ACTVY		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.BR122, BRIP.1
#IHG-RECORD-TYPE PK
RECORD_TYPE		Alpha 1This field identifies the type of record defined. Valid values are:
  • S Summary
  • D Detail
  • C Cost Share
  • P Program Income
BR122, BRIP.1
#IHG-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.BR122, BRIP.1
#IHG-INV-AMOUNT
INV_AMOUNT		Signed 18.2—BRIP.1
#IHG-LTD-AMOUNT
LTD_AMOUNT		Signed 18.2—BRIP.1

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
IHGSET1
  1. HIH-OBJ-ID
  2. CONTRACT-ACTVY
  3. RECORD-TYPE
  4. ACTIVITY
PrimaryBR122, BR300, BRIP.1

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Acactivity CntACACTIVITYRequired
IHG-CONTRACT-ACTVY→ACV-ACTIVITY
Acactivity PstACACTIVITYRequired
IHG-ACTIVITY→ACV-ACTIVITY
AchisthdrACHISTHDRRequired
IHG-HIH-OBJ-ID→HIH-OBJ-ID

Programs

Updated by (3)