ACINVAUDIT

UPDATED BY
BR122 BR123 BR140 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR20.7 BR220 BR300 BR46.1
BR46.2 BR46.4 BR52.1 BRIP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IVA-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object 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.
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
IVA-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
IVA-TRANS-DATE
Element: Trans Date
Numeric 8 (yyyymmdd)
The date of the transaction.
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
IVA-TRANS-TIME
Element: Sys Time
Numeric 6 (hhmmss)
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
IVA-SEQUENCE-NBR
Element: Sequence Nbr
Numeric 4
The user-assigned sequence number to keep the records unique and to determine order.
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
IVA-OPERATOR
Element: Operator
Alpha 10
This field is used to store the login id of the person who entered the record.
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
IVA-FIELD-ID
Element: Field Id
Numeric 3
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR46.1 BR46.2
BR46.4
IVA-RECORD-TYPE
Element: Record Type
Alpha 1
This field identifies the type of record defined. Valid values are: S = Summary D = Detail
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
IVA-ALPHA-IMAGE
Element: Alpha Image
Alpha 30
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
IVA-NUM-IMAGE
Element: Num Image
Signed 18.4
The amount written to this record is the old value or original value of the invoice line.
BR140 BR20.7
IVA-DATE-IMAGE
Element: Date Image
Numeric 8 (yyyymmdd)
BR20.7
IVA-CONTRACT
Element: Contract
Alpha 15
Activity Management contract.
BR122 BR123
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR46.1 BR46.2
BR46.4 BRIP.1
IVA-REASON-CODE
Element: Reason Code
Alpha 4
This field contains the reason code, which indicates the cause for credit memos.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4


ACINVAUDIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IVASET1 OBJ-ID
LINE-NBR
TRANS-DATE*
SEQUENCE-NBR*
BR122 BR123
BR140 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR20.7 BR300
BR46.1 BR46.2
BR46.4 BR52.1
BRIP.1
IVASET2 CONTRACT
OBJ-ID
LINE-NBR
TRANS-DATE*
SEQUENCE-NBR*
KeyChange
BR220


ACINVAUDIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Achisthdr ACHISTHDR Required
IVA-OBJ-ID->HIH-OBJ-ID
Acpmhsthdr ACPMHSTHDR Required
IVA-OBJ-ID->PMH-OBJ-ID


File created: Thu Jun 09 11:10:56 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.