 |
Lawson Insight Technical Documentation |
|
ACINVAUDIT FILE
REFERENCED BY
BR220
UPDATED BY
AC300 AC310 BR02.3 BR120 BR20.1 BR20.2
BR20.3 BR20.4 BR20.5 BR20.7 BR21.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IVA-COMPANY Numeric 4 BR02.3 BR120
Company The company number represents an BR20.1 BR20.2
established company and is entered on BR20.3 BR20.4
all function codes. BR20.5 BR20.7
BR21.1
IVA-CUSTOMER Alpha 9 (Right Justified) BR02.3 BR120
Customer Number This field contains the number that BR20.1 BR20.2
represents a customer. BR20.3 BR20.4
BR20.5 BR20.7
BR21.1
IVA-INVOICE-PREFIX Alpha 2 BR02.3 BR120
Invoice Prefix BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR21.1
IVA-INVOICE-NBR Numeric 8 BR02.3 BR120
Invoice Nbr BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR21.1
IVA-LINE-NBR Numeric 6 BR02.3 BR120
Line Number This field contains the line number. BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
IVA-TRANS-DATE Numeric 8 (yyyymmdd) BR02.3 BR120
Transaction Date The date of the transaction. BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR21.1
IVA-TRANS-TIME Numeric 6 (hhmmss) BR02.3 BR120
Transaction Time BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR21.1
IVA-SEQUENCE-NBR Numeric 4 BR02.3 BR120
Sequence Number The user-assigned sequence number to BR20.1 BR20.2
keep the records unique and to determine BR20.3 BR20.4
order. BR20.5 BR20.7
BR21.1
IVA-OPERATOR Alpha 10 BR02.3 BR120
Operator Code This field is used to store the login BR20.1 BR20.2
id of the person who entered the record. BR20.3 BR20.4
BR20.5 BR20.7
BR21.1
IVA-FIELD-ID Numeric 3 BR02.3 BR20.1
Field ID BR20.2 BR20.3
BR20.4 BR20.5
BR20.7
IVA-RECORD-TYPE Alpha 1 BR02.3 BR120
Record Type This field identifies the type of BR20.1 BR20.2
record defined. BR20.3 BR20.4
BR20.5 BR20.7
Valid values are: BR21.1
S = Summary
D = Detail
IVA-ALPHA-IMAGE Alpha 30 BR02.3 BR120
Alpha Image BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR21.1
IVA-NUM-IMAGE Signed 13.4 BR20.7
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) BR02.3 BR20.7
Date Image
IVA-CONTRACT Alpha 10 BR02.3 BR120
Contract BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR21.1
IVA-AC-CUSTOMER-ID Alpha 5 BR02.3 BR120
Ac Customer Id BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR21.1
IVA-REASON-CODE Alpha 4 BR20.1 BR20.2
Reason Code This field contains the reason code, BR20.3 BR20.4
which indicates the cause for credit BR20.5
memos.
ACINVAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IVASET1 CONTRACT AC300 AC310
COMPANY BR02.3 BR20.1
CUSTOMER BR20.2 BR20.3
AC-CUSTOMER-ID BR20.4 BR20.5
INVOICE-PREFIX BR20.7 BR21.1
INVOICE-NBR BR220
LINE-NBR
TRANS-DATE*
SEQUENCE-NBR*
ACINVAUDIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acinvhdr ACINVHDR Required
IVA-CONTRACT -> IVH-CONTRACT
IVA-COMPANY -> IVH-COMPANY
IVA-CUSTOMER -> IVH-CUSTOMER
IVA-AC-CUSTOMER-ID -> IVH-AC-CUSTOMER-ID
IVA-INVOICE-PREFIX -> IVH-INVOICE-PREFIX
IVA-INVOICE-NBR -> IVH-INVOICE-NBR
|