ACINVAUDIT – No description in the Lawson data dictionary

System
AC Billing Revenue (BR)
Prefix
IVA
Primary key
OBJ-ID, LINE-NBR, TRANS-DATE, SEQUENCE-NBR
Fields
13
Updated by
15 programs
Referenced by
1 program

ACINVAUDIT is a Lawson AC Billing Revenue table (prefix IVA); no description in the lawson data dictionary. It is indexed by OBJ-ID, LINE-NBR, TRANS-DATE, SEQUENCE-NBR (IVASET1); alternate indexes: IVASET2. It is related 1:1 to ACHISTHDR and ACPMHSTHDR. It is updated by BR122, BR123, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 and 7 more and referenced by BR220. The table has 13 fields, 2 indexes and 2 documented relations.

About ACINVAUDIT

No description in the Lawson data dictionary.

Fields (13)

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

Field / columnTypeDescription & valuesUpdated by
IVA-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.BR122, BR123, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 +6 more
IVA-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
IVA-TRANS-DATE PK
TRANS_DATE		Numeric 8 (yyyymmdd)The date of the transaction.BR122, BR123, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 +6 more
IVA-TRANS-TIME
TRANS_TIME		Numeric 6 (hhmmss)—BR122, BR123, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 +6 more
IVA-SEQUENCE-NBR PK
SEQUENCE_NBR		Numeric 4The user-assigned sequence number to keep the records unique and to determine order.BR122, BR123, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 +6 more
IVA-OPERATOR
OPERATOR		Alpha 10This field is used to store the login id of the person who entered the record.BR122, BR123, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 +6 more
IVA-FIELD-ID
FIELD_ID		Numeric 3—BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR20.7, BR46.1, BR46.2 +1 more
IVA-RECORD-TYPE
RECORD_TYPE		Alpha 1This field identifies the type of record defined. Valid values are:
  • S Summary
  • D Detail
BR122, BR123, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 +6 more
IVA-ALPHA-IMAGE
ALPHA_IMAGE		Alpha 30—BR122, BR123, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 +6 more
IVA-NUM-IMAGE
NUM_IMAGE		Signed 18.4The amount written to this record is the old value or original value of the invoice line.BR140, BR20.7
IVA-DATE-IMAGE
DATE_IMAGE		Numeric 8 (yyyymmdd)—BR20.7
IVA-CONTRACT
CONTRACT		Alpha 15Activity Management contract.BR122, BR123, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR20.7 +4 more
IVA-REASON-CODE
REASON_CODE		Alpha 4This field contains the reason code, which indicates the cause for credit memos.BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4

Indexes (2)

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

IndexKeysFlagsConditionUsed in
IVASET1OBJ-ID, LINE-NBR, TRANS-DATE*, SEQUENCE-NBR*PrimaryBR122, BR123, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 +7 more
IVASET2CONTRACT, OBJ-ID, LINE-NBR, TRANS-DATE*, SEQUENCE-NBR*KeyChangeBR220

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AchisthdrACHISTHDRRequiredIVA-OBJ-ID → HIH-OBJ-ID
AcpmhsthdrACPMHSTHDRRequiredIVA-OBJ-ID → PMH-OBJ-ID

Programs

Updated by (15)

Referenced by (1)