APAUDIT

Vendor-Invoice Audit

The Vendor-Invoice Audit file contains audit records for additions, changes, deletions, and cancellations for vendor and invoice records. Changes to vendors are recorded for vendor groups that audit vendor changes. Changes to released invoices are recorded for companies that audit invoice changes.

REFERENCED BY
AP98.1 AP98.2 AP98.3


UPDATED BY
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM22.1 AM500 AM51.1 AM551 AM97.1
AP03.1 AP03.2 AP03.3 AP10.1 AP10.3 AP10.5
AP10.6 AP10.7 AP10.9 AP109 AP11.1 AP110
AP115 AP125 AP126 AP131 AP135 AP14.1
AP14.2 AP14.3 AP14.4 AP141 AP15.1 AP150
AP16.1 AP16.2 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP210 AP220 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP271 AP30.1
AP30.2 AP30.3 AP30.4 AP300 AP305 AP40.1
AP40.2 AP45.1 AP510 AP520 AP90.1 AP91.1
API1.1 API2.1 API3.1 API4.1 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CXCP.1 DR100 IC140 IC142 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC83.1 IC840 MX123
MX500 MA180 MA279 MA41.1 MA41.2 MA41.4
MA41.7 MA42.1 MA42.2 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MA44.1 MA44.2 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA63.1
MA65.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA69.1 MA70.1 MA75.1 MA80.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PD235 PO10.1 PO10.2 PO100 PO101 PO120
PO122 PO131 PO136 PO150 PO190 PO20.1
PO20.6 PO20.9 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.2 PO22.3 PO22.4 PO22.5
PO220 PO223 PO23.1 PO233 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO253 PO254 PO27.2
PO278 PO28.2 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 PO54.1 PO54.2 PO54.3 PO54.4 PO54.5
POCP.1 POI3.1 POID.1 POII.1 POIJ.1 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 PR514
UK47.1 RQ10.1 RQ10.2 RQ10.4 RQ12.1 RQ13.1
RQ13.2 RQ260 RQ35.1 RQ500 RQIF.1 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APA-VENDOR-GROUP
Element: Vendor Group
Alpha 4
If the audit record is for a vendor, this field contains the vendor group assigned to the vendor. Must be a valid record in the Vendor Group file.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.1 AP03.2
AP03.3 AP10.1
AP10.3 AP10.5
AP10.6 AP10.7
AP10.9 AP109
AP11.1 AP110
AP115 AP125
AP126 AP131
AP14.1 AP14.2
AP14.3 AP14.4
AP141 AP15.1
AP150 AP16.1
AP16.2 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP271
AP30.1 AP30.2
APA-COMPANY
Element: Company
Numeric 4
If the audit record is for an invoice, this field contains the company number assigned to the invoice. Must be a valid record in the Accounts Payable Company file.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.1 AP03.2
AP03.3 AP10.1
AP10.3 AP10.5
AP10.6 AP10.7
AP10.9 AP109
AP110 AP115
AP125 AP126
AP131 AP14.1
AP14.2 AP14.3
AP14.4 AP141
AP15.1 AP150
AP16.1 AP16.2
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP271 AP30.1
AP30.2 AP30.3
APA-PROC-LEVEL
Element: Process Level
Alpha 5
The process level associated with the invoice audit record. Must be a valid record in the Accounts Payable Process Level file.
AP141 AP30.1
AP30.2 AP30.3
AP30.4 AP40.1
AP40.2 AP45.1
MA70.1 MA75.1
APA-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor number associated with the audit record. Must be a valid record in the Vendor file.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.1 AP03.2
AP03.3 AP10.1
AP10.3 AP10.5
AP10.6 AP10.7
AP10.9 AP109
AP11.1 AP110
AP115 AP125
AP126 AP131
AP14.1 AP14.2
AP14.3 AP14.4
AP141 AP15.1
AP150 AP16.1
AP16.2 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP271
AP30.1 AP30.2
APA-INVOICE
Element: Invoice
Alpha 22
The invoice number associated with the invoice audit record.
AP141 AP30.1
AP30.2 AP30.3
AP30.4 AP40.1
AP40.2 AP45.1
MA70.1 MA75.1
APA-SUFFIX
Element: Suffix
Numeric 3
The invoice suffix number associated with the invoice audit record. A suffix number is assigned by the system to recurring invoices or system-generated credit memos.
AP141 AP30.1
AP30.2 AP30.3
AP30.4 AP40.1
AP40.2 AP45.1
MA70.1 MA75.1
APA-CANCEL-SEQ
Element: Seq Nbr
Numeric 4
The sequence number assigned upon a cancellation of a distributed invoice. The first sequence assigned is 9999.
AP141 AP30.1
AP30.2 AP30.3
AP30.4 AP40.1
AP40.2 AP45.1
MA70.1 MA75.1
APA-SEQ-NBR
Element: Seq Nbr
Numeric 4
The invoice payment sequence number.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.1 AP03.2
AP03.3 AP10.1
AP10.3 AP10.5
AP10.6 AP10.7
AP10.9 AP109
AP11.1 AP110
AP115 AP125
AP126 AP131
AP14.1 AP14.2
AP14.3 AP14.4
AP141 AP15.1
AP150 AP16.1
AP16.2 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP271
AP30.1 AP30.2
APA-TRANS-DATE
Element: Trans Date
Numeric 8 (yyyymmdd)
The date the audit record was created.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.1 AP03.2
AP03.3 AP10.1
AP10.3 AP10.5
AP10.6 AP10.7
AP10.9 AP109
AP11.1 AP110
AP115 AP125
AP126 AP131
AP14.1 AP14.2
AP14.3 AP14.4
AP141 AP15.1
AP150 AP16.1
AP16.2 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP271
AP30.1 AP30.2
APA-TRANS-TIME
Element: Sys Time
Numeric 6 (hhmmss)
The system time the audit record was created.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.1 AP03.2
AP03.3 AP10.1
AP10.3 AP10.5
AP10.6 AP10.7
AP10.9 AP109
AP11.1 AP110
AP115 AP125
AP126 AP131
AP14.1 AP14.2
AP14.3 AP14.4
AP141 AP15.1
AP150 AP16.1
AP16.2 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP271
AP30.1 AP30.2
APA-REC-TYPE
Element: Record Type
Alpha 1
Indicates the type of audit record. Valid values are: I = Invoice Audit Record. V = Vendor Audit Record.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.1 AP03.2
AP03.3 AP10.1
AP10.3 AP10.5
AP10.6 AP10.7
AP10.9 AP109
AP11.1 AP110
AP115 AP125
AP126 AP131
AP14.1 AP14.2
AP14.3 AP14.4
AP141 AP15.1
AP150 AP16.1
AP16.2 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP271
AP30.1 AP30.2
APA-VENDOR-SNAME
Element: Vendor Name
Alpha 30
The search name defined for the vendor in the Vendor file at the time the audit record was created.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.1 AP03.2
AP03.3 AP10.1
AP10.3 AP10.5
AP10.6 AP10.7
AP10.9 AP109
AP11.1 AP110
AP115 AP125
AP126 AP131
AP14.1 AP14.2
AP14.3 AP14.4
AP141 AP15.1
AP150 AP16.1
AP16.2 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP271
AP30.1 AP30.2
APA-VEN-CLASS
Element: Ven Class
Alpha 3
The vendor class the vendor was assigned to at the time the audit record was created. Must be a valid record in the Vendor Class file.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.1 AP03.2
AP03.3 AP10.1
AP10.3 AP10.5
AP10.6 AP10.7
AP10.9 AP109
AP11.1 AP110
AP115 AP125
AP126 AP131
AP14.1 AP14.2
AP14.3 AP14.4
AP141 AP15.1
AP150 AP16.1
AP16.2 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP271
AP30.1 AP30.2
APA-LOCATION-CODE
Element: Location Code
Alpha 4
The alternate vendor location code associated with the audit record. Must be a valid record in the Vendor Location file.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.1
AP10.5 AP10.6
AP10.7 AP10.9
AP109 AP110
AP115 AP125
AP126 AP131
AP14.1 AP14.2
AP14.3 AP14.4
AP141 AP15.1
AP150 AP16.1
AP16.2 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP271
AP30.1 AP30.2
AP30.3 AP30.4
AP300 AP305
APA-OPERATOR
Element: Operator
Alpha 10
The operator associated with the invoice audit record.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.1 AP03.2
AP03.3 AP10.1
AP10.3 AP10.5
AP10.6 AP10.7
AP10.9 AP109
AP11.1 AP110
AP115 AP125
AP126 AP131
AP14.1 AP14.2
AP14.3 AP14.4
AP141 AP15.1
AP150 AP16.1
AP16.2 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP271
AP30.1 AP30.2
APA-FIELD-ID
Element: Field Id
Numeric 3
The value for this field comes from a table in working storage. Indicates the vendor or invoice field that was changed.
001 = Vendor Class
002 = Vendor Name
003 = Vendor Search Name
004 = Vendor Contact
005 = Address 1
006 = Address 2
007 = Address 3
008 = Address 4
009 = City/Address 5
010 = State/Province
011 = Postal Code
012 = Country
013 = Normal Remit-To Flag
014 = Normal Purchase-From Flag
015 = Pay Vendor
016 = Vendor Status
017 = Vendor Priority
018 = Phone Prefix
019 = Phone Number
020 = Phone Extension
021 = FAX Prefix
022 = FAX Number
023 = FAX Extension
024 = Telex Number
025 = Terms Code
026 = Invoice Currency
027 = Balance Currency
028 = Tax Code
029 = Hold Code
030 = Distribution Code
031 = Accrual Code
032 = Payment Type
033 = Bank Code
034 = Bank Identification Number
035 = Bank Account Number
036 = Bank Account Type
037 = Income Code
038 = Tax Identification Number
039 = Income Withholding Flag
040 = EDI Prefix
041 = EDI Number
042 = Vendor Legal Name
044 = ACH Prenotification Flag
045 = Maximum Invoice Amount
046 = Origin Date
047 = Operator
048 = User Field 1
049 = User Field 2
050 = User Field 3
051 = User Field 4
052 = User Field 5
053 = User Field 6
054 = Currency Recalculation Flag
055 = Region
056 = Country Code
090 = Vendor Added
091 = Vendor Location Added
098 = One-Time Vendor Added
099 = Vendor Location Deleted
100 = Location Type
101 = Normal Remit-To Flag
102 = Normal Purchase-From Flag
103 = Remit-To Code
395 = Print Account Flag
501 = Invoice Canceled
502 = Process Level
503 = Accrual Code
504 = Voucher Number
505 = Pay To Vendor
506 = Purchase Order
507 = Remit To Code
510 = Invoice Description
511 = Invoice Amount
512 = Base Invoice Amount
513 = Discount Amount
514 = Base Discount Amount
515 = Tax Amount
519 = Bank Code
520 = Hold Code
521 = Income Code
522 = Payment Group
523 = Pay Immediately Flag
524 = Separate Payment Flag
525 = Enclosure Flag
526 = Number of Recurring Payments
527 = Recurring Frequency
104 = Diversity Code
057 = Activity
058 = Account Category
059 = Invoice Group
060 = Handling Code
063 = Anticipation Rate
064 = Separate Payment Flag
065 = ERS Capable Flag
066 = ERS Invoice Reference
068 = EDI Invoice Automatic Release
070 = Customer Group
071 = Customer
072 = SWIFT Identification Number
073 = SWIFT Identification Number
074 = Normal or Express Code
075 = Payment Form
076 = Charge Code
077 = Cash Code
078 = Enclosure
079 = Match Ref Processing
080 = Match Table
081 = Terms Calculation
082 = Auto Chargeback Hold
083 = Rule Group
084
085
086
087
088
089
092
093
094
105
106
528
529
530
600
601
602
603
604
605
606
607
608
609
610
611
612
613
621
622
623
624
700
701
702
703
704
705
706
707
708
709
710
711
712
715
716
717
718
719
720
721
722
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.1 AP03.2
AP03.3 AP10.1
AP10.3 AP10.5
AP10.6 AP10.7
AP10.9 AP109
AP11.1 AP110
AP115 AP125
AP126 AP131
AP14.1 AP14.2
AP14.3 AP14.4
AP141 AP15.1
AP150 AP16.1
AP16.2 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP271
AP30.1 AP30.2
APA-BEFORE-IMAGE
Element: Before Image
Alpha 32
The image of the field before the change.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.1 AP03.2
AP03.3 AP10.1
AP10.5 AP10.6
AP10.7 AP10.9
AP109 AP11.1
AP110 AP115
AP125 AP126
AP131 AP14.1
AP14.2 AP14.3
AP14.4 AP141
AP15.1 AP150
AP16.1 AP16.2
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP271 AP30.1
AP30.2 AP30.3
APA-AFTER-IMAGE
Element: Before Image
Alpha 32
The image of the field after the change.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.1 AP03.2
AP03.3 AP10.1
AP10.3 AP10.5
AP10.6 AP10.7
AP10.9 AP109
AP11.1 AP110
AP115 AP125
AP126 AP131
AP14.1 AP14.2
AP14.3 AP14.4
AP141 AP15.1
AP150 AP16.1
AP16.2 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP271
AP30.1 AP30.2
APA-PRT-STATUS
Element: Print Status
Numeric 1
This field is not currently used.
APA-FIELD-DESC
Element: Field Desc
Derived


APAUDIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APASET1 VENDOR-GROUP
COMPANY
PROC-LEVEL
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
TRANS-DATE
TRANS-TIME
LOCATION-CODE
KeyChange
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP135 AP150
AP20.1 AP20.2
AP20.3 AP20.4
APASET2 VENDOR-GROUP
VENDOR
LOCATION-CODE
TRANS-DATE
TRANS-TIME
SEQ-NBR
KeyChange, Subset
WhereREC-TYPE ="V"
AP03.1 AP03.2
AP10.1 AP10.3
AP10.5 AP10.6
AP10.7 AP10.9
AP109 AP11.1
AP115 AP135
AP14.1 AP14.2
AP14.3 AP14.4
AP15.1 AP16.1
AP16.2 AP510
AP520 AP98.1
AP98.2 PO10.1
APASET3 COMPANY
PROC-LEVEL
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
TRANS-DATE
TRANS-TIME
SEQ-NBR
KeyChange, Subset
WhereREC-TYPE ="I"
AP135 AP141
AP30.1 AP30.2
AP30.3 AP30.4
AP40.1 AP45.1
AP98.3 MA70.1
MA75.1


APAUDIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When APA-REC-TYPE ="I"
APA-COMPANY->CPY-COMPANY
Apdict APDICT Required
APA-FIELD-ID->DCT-FLD-NBR
Approclev APPROCLEV Required
When APA-REC-TYPE ="I"
APA-COMPANY->APR-COMPANY
APA-PROC-LEVEL->APR-PROC-LEVEL
Apvenclass APVENCLASS Not Required
APA-VENDOR-GROUP->VCL-VENDOR-GROUP
APA-VEN-CLASS->VCL-VEN-CLASS
Apvengroup APVENGROUP Required
When APA-REC-TYPE ="V"
APA-VENDOR-GROUP->VGP-VENDOR-GROUP
Apvenloc APVENLOC Required
When APA-REC-TYPE ="V"
APA-VENDOR-GROUP->VLO-VENDOR-GROUP
APA-VENDOR->VLO-VENDOR
APA-LOCATION-CODE->VLO-LOCATION-CODE
Apvenmast APVENMAST Required
APA-VENDOR-GROUP->VEN-VENDOR-GROUP
APA-VENDOR->VEN-VENDOR


File created: Thu Jun 09 11:07:13 2016

Home
Contact Us



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