Lawson Insight Technical Documentation |
|
ACINVAUDIT
ACINVAUDIT FILE
REFERENCED BY
BR220
UPDATED BY
AC300 AC310 BR02.3 BR120 BR122 BR123
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR20.7
BR901
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IVA-COMPANY Numeric 4 BR02.3 BR120
Element: Company The company number represents an BR122 BR123
established company and is entered on BR20.1 BR20.2
all function codes. BR20.3 BR20.4
BR20.5 BR20.7
BR901
IVA-CUSTOMER Alpha 9 (Right Justified) BR02.3 BR120
Element: Customer NumbeThis field contains the number that BR122 BR123
represents a customer. BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR901
IVA-INVOICE-PREFIX Alpha 2 BR02.3 BR120
Element: Invoice Prefix BR122 BR123
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR901
IVA-INVOICE-NBR Numeric 8 BR02.3 BR120
Element: Invoice Nbr BR122 BR123
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR901
IVA-LINE-NBR Numeric 6 BR02.3 BR120
Element: 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
Element: Date BR122 BR123
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR901
IVA-TRANS-TIME Numeric 6 (hhmmss) BR02.3 BR120
Element: Sys Time BR122 BR123
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR901
IVA-SEQUENCE-NBR Numeric 4 BR02.3 BR120
Element: Number of Items BR122 BR123
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR901
IVA-OPERATOR Alpha 10 BR02.3 BR120
Element: Operator Code This field is used to store the login BR122 BR123
id of the person who entered the record. BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR901
IVA-FIELD-ID Numeric 3 BR02.3 BR20.1
Element: Field ID BR20.2 BR20.3
BR20.4 BR20.5
BR20.7
IVA-RECORD-TYPE Alpha 1 BR02.3 BR120
Element: Record Type This field identifies the type of BR122 BR123
record defined. BR20.1 BR20.2
BR20.3 BR20.4
Valid values are: BR20.5 BR20.7
S = Summary BR901
D = Detail
IVA-ALPHA-IMAGE Alpha 30 BR02.3 BR120
Element: Alpha Image BR122 BR123
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR901
IVA-NUM-IMAGE Signed 13.4 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) BR02.3 BR20.7
Element: Date Image
IVA-CONTRACT Alpha 10 BR02.3 BR120
Element: Bid Name BR122 BR123
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR901
IVA-AC-CUSTOMER-ID Alpha 5 BR02.3 BR120
Element: Ac Customer Id BR122 BR123
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR901
IVA-REASON-CODE Alpha 4 BR20.1 BR20.2
Accounts Receivable This field contains the reason code, BR20.3 BR20.4
Code 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 BR122
CUSTOMER BR123 BR20.1
AC-CUSTOMER-ID BR20.2 BR20.3
INVOICE-PREFIX BR20.4 BR20.5
INVOICE-NBR BR20.7 BR220
LINE-NBR BR901
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
|