Lawson Insight Technical Documentation |
|
ACINVAUDIT
ACINVAUDIT FILE
REFERENCED BY
BR220
UPDATED BY
BR122 BR123 BR140 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR20.7 BR46.1 BR46.2 BR46.4
BR52.1 BRIP.1 BR300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IVA-OBJ-ID Numeric 12 BR122 BR123
Element: Obj Id This is the object identifier. It is BR140 BR20.1
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 BR52.1 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 BR20.1 BR20.2
Element: Line Nbr This field contains the line number. BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
IVA-TRANS-DATE Numeric 8 (yyyymmdd) BR122 BR123
Element: Trans Date The date of the transaction. BR140 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR20.7 BR46.1
BR46.2 BR46.4
BR52.1 BRIP.1
IVA-TRANS-TIME Numeric 6 (hhmmss) BR122 BR123
Element: Sys Time BR140 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR20.7 BR46.1
BR46.2 BR46.4
BR52.1 BRIP.1
IVA-SEQUENCE-NBR Numeric 4 BR122 BR123
Element: Sequence Nbr The 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
BR52.1 BRIP.1
IVA-OPERATOR Alpha 10 BR122 BR123
Element: Operator 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
BR52.1 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 BR122 BR123
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 BR52.1 BRIP.1
IVA-ALPHA-IMAGE Alpha 30 BR122 BR123
Element: Alpha Image BR140 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR20.7 BR46.1
BR46.2 BR46.4
BR52.1 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 15 BR122 BR123
Element: Contract Activity Management contract. BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR46.1 BR46.2
BR46.4 BRIP.1
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 BR122 BR123
LINE-NBR BR140 BR20.1
TRANS-DATE* BR20.2 BR20.3
SEQUENCE-NBR* BR20.4 BR20.5
BR20.7 BR220
BR300 BR46.1
BR46.2 BR46.4
BR52.1 BRIP.1
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
Acpmhsthdr ACPMHSTHDR Required
IVA-OBJ-ID -> PMH-OBJ-ID
|