ACINVORD – No description in the Lawson data dictionary

System
AC Billing Revenue (BR)
Prefix
AIO
Primary key
HIH-OBJ-ID, CONTRACT
Fields
2
Updated by
5 programs
Referenced by
12 programs

ACINVORD is a Lawson AC Billing Revenue table (prefix AIO); no description in the lawson data dictionary. It is indexed by HIH-OBJ-ID, CONTRACT (AIOSET1); alternate indexes: AIOSET2. It is related 1:1 to ACHISTHDR. It is updated by AC300, BR46.1, BR46.2, BR46.4 and BRIP.1 and referenced by BR121, BR131, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 and 4 more. The table has 2 fields, 2 indexes and 1 documented relation.

About ACINVORD

No description in the Lawson data dictionary.

Fields (2)

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

Field / columnTypeDescription & valuesUpdated by
AIO-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.BR46.1, BR46.2, BR46.4, BRIP.1
AIO-CONTRACT PK
CONTRACT
Alpha 15Activity Management contract.BR46.1, BR46.2, BR46.4, BRIP.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
AIOSET1HIH-OBJ-ID, CONTRACTPrimaryBR121, BR131, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR21.1 +7 more
AIOSET2CONTRACT, HIH-OBJ-ID*KeyChangeAC300, BR140, BR21.1

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AchisthdrACHISTHDRRequiredAIO-HIH-OBJ-IDHIH-OBJ-ID

Programs

Updated by (5)

Referenced by (12)