Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACINVAUDIT


                            ACINVAUDIT FILE

REFERENCED BY

BR220

UPDATED BY

BR02.3    BR122     BR140     BR20.1    BR20.2    BR20.3
BR20.4    BR20.5    BR20.7    BR46.1    BR46.2    BR46.4
BRIP.1    BR300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IVA-OBJ-ID             Numeric 12                                BR02.3  BR122
Object                 This is the object identifier. It is      BR140   BR20.1
Identification         used to relate commitments or posted      BR20.2  BR20.3
                       transactions back to the originating      BR20.4  BR20.5
                       subsystems. Each subsystem record that    BR20.7  BR46.1
                       is updated as a commitment or posted      BR46.2  BR46.4
                       transaction is assigned an object         BRIP.1
                       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.

IVA-LINE-NBR           Numeric 6                                 BR02.3  BR20.1
Element: Line Number   This field contains the line number.      BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR46.1  BR46.2
                                                                 BR46.4  BRIP.1

IVA-TRANS-DATE         Numeric 8  (yyyymmdd)                     BR02.3  BR122
Element: Transaction DaThe date of the transaction.              BR140   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR20.7  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

IVA-TRANS-TIME         Numeric 6  (hhmmss)                       BR02.3  BR122
Element: Sys Time                                                BR140   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR20.7  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

IVA-SEQUENCE-NBR       Numeric 4                                 BR02.3  BR122
Element: Sequence NumbeThe user-assigned sequence number to      BR140   BR20.1
                       keep the records unique and to determine  BR20.2  BR20.3
                       order.                                    BR20.4  BR20.5
                                                                 BR20.7  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

IVA-OPERATOR           Alpha 10                                  BR02.3  BR122
Element: Operator Code This field is used to store the login     BR140   BR20.1
                       id of the person who entered the record.  BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR20.7  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

IVA-FIELD-ID           Numeric 3                                 BR20.1  BR20.2
Element: Field ID                                                BR20.3  BR20.4
                                                                 BR20.5  BR20.7
                                                                 BR46.1  BR46.2
                                                                 BR46.4

IVA-RECORD-TYPE        Alpha 1                                   BR02.3  BR122
Element: Record Type   This field identifies the type of         BR140   BR20.1
                       record defined.                           BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                       Valid values are:                         BR20.7  BR46.1
                       S = Summary                               BR46.2  BR46.4
                       D = Detail                                BRIP.1

IVA-ALPHA-IMAGE        Alpha 30                                  BR02.3  BR122
Element: Alpha Image                                             BR140   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR20.7  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

IVA-NUM-IMAGE          Signed 18.4                               BR140   BR20.7
Element: Num Image     The amount written to this record is the
                       old value or original value of the
                       invoice line.

IVA-DATE-IMAGE         Numeric 8  (yyyymmdd)                     BR20.7
Element: Date Image

IVA-CONTRACT           Alpha 10                                  BR02.3  BR20.1
Element: Contract      Activity Management contract.             BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR20.7  BR46.1
                                                                 BR46.2  BR46.4

IVA-REASON-CODE        Alpha 4                                   BR20.1  BR20.2
Element: Reason Code   This field contains the reason code,      BR20.3  BR20.4
                       which indicates the cause for credit      BR20.5  BR46.1
                       memos.                                    BR46.2  BR46.4

                         ACINVAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IVASET1   OBJ-ID                                                 BR02.3  BR122
          LINE-NBR                                               BR140   BR20.1
          TRANS-DATE*                                            BR20.2  BR20.3
          SEQUENCE-NBR*                                          BR20.4  BR20.5
                                                                 BR20.7  BR300
                                                                 BR46.1  BR46.2
                                                                 BR46.4

IVASET2   CONTRACT      KeyChange                                BR220
          OBJ-ID
          LINE-NBR
          TRANS-DATE*
          SEQUENCE-NBR*

                         ACINVAUDIT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Achisthdr      ACHISTHDR    Required

                            IVA-OBJ-ID    -> HIH-OBJ-ID