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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
IHGSET1HIH-OBJ-ID, CONTRACT-ACTVY, RECORD-TYPE, ACTIVITYPrimaryBR122, BR300, BRIP.1

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Acactivity CntACACTIVITYRequiredIHG-CONTRACT-ACTVY → ACV-ACTIVITY
Acactivity PstACACTIVITYRequiredIHG-ACTIVITY → ACV-ACTIVITY
AchisthdrACHISTHDRRequiredIHG-HIH-OBJ-ID → HIH-OBJ-ID

Programs

Updated by (3)