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.