Lawson Insight Technical Documentation |
|
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
|