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