APAUDIT FILE
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.
UPDATED BY
AP10.1 AP10.2 AP10.3 AP10.5 AP10.6 AP135
AP30.1 AP30.2 AP30.3 AP30.4 AP32.2 AP40.1
AP40.2 AP45.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APA-VENDOR-GROUP Alpha 4 AP10.1 AP10.2
Vendor Group If the audit record is for a vendor, AP10.3 AP10.5
this field contains the vendor group AP10.6 AP30.1
assigned to the vendor. Must be a valid AP30.2 AP30.3
record in the Vendor Group file. AP30.4 AP32.2
AP40.1 AP40.2
AP45.1
APA-COMPANY Numeric 4 AP10.1 AP10.2
Company If the audit record is for an invoice, AP10.3 AP10.5
this field contains the company number AP10.6 AP30.1
assigned to the invoice. Must be a valid AP30.2 AP30.3
record in the Accounts Payable Company AP30.4 AP32.2
file. AP40.1 AP40.2
AP45.1
APA-PROC-LEVEL Alpha 5 AP30.1 AP30.2
Process Level The process level associated with the AP30.3 AP30.4
invoice audit record. Must be a valid AP32.2 AP40.1
record in the Accounts Payable Process AP40.2 AP45.1
Level file.
APA-VENDOR Alpha 9 AP10.1 AP10.2
Vendor ID The vendor number associated with the AP10.3 AP10.5
audit record. Must be a valid record in AP10.6 AP30.1
the Vendor file. AP30.2 AP30.3
AP30.4 AP32.2
AP40.1 AP40.2
AP45.1
APA-INVOICE Alpha 22 AP30.1 AP30.2
Invoice Number The invoice number associated with the AP30.3 AP30.4
invoice audit record. AP32.2 AP40.1
AP40.2 AP45.1
APA-SUFFIX Numeric 3 AP30.1 AP30.2
Invoice Suffix The invoice suffix number associated AP30.3 AP30.4
with the invoice audit record. A suffix AP32.2 AP40.1
number is assigned by the system to AP40.2 AP45.1
recurring invoices or system-generated
credit memos.
APA-CANCEL-SEQ Numeric 4 AP30.1 AP30.2
Cancel Sequence The sequence number assigned upon a AP30.3 AP30.4
cancellation of a distributed invoice. AP32.2 AP40.1
The first sequence assigned is 9999. AP40.2 AP45.1
APA-SEQ-NBR Numeric 4 AP10.1 AP10.2
Sequence Number The invoice payment sequence number. AP10.3 AP10.5
AP10.6 AP30.1
AP30.2 AP30.3
AP30.4 AP32.2
AP40.1 AP40.2
AP45.1
APA-TRANS-DATE Numeric 8 (yyyymmdd) AP10.1 AP10.2
Transaction Date The date the audit record was created. AP10.3 AP10.5
AP10.6 AP30.1
AP30.2 AP30.3
AP30.4 AP32.2
AP40.1 AP40.2
AP45.1
APA-TRANS-TIME Numeric 6 (hhmmss) AP10.1 AP10.2
Transaction Time The system time the audit record was AP10.3 AP10.5
created. AP10.6 AP30.1
AP30.2 AP30.3
AP30.4 AP32.2
AP40.1 AP40.2
AP45.1
APA-REC-TYPE Alpha 1 AP10.1 AP10.2
Record Type Indicates the type of audit record. AP10.3 AP10.5
Valid values are: AP10.6 AP30.1
AP30.2 AP30.3
I = Invoice Audit Record. AP30.4 AP32.2
V = Vendor Audit Record. AP40.1 AP40.2
AP45.1
APA-VENDOR-SNAME Alpha 30 AP10.1 AP10.2
Vendor Search Name The search name defined for the vendor AP10.3 AP10.5
in the Vendor file at the time the audit AP10.6 AP30.1
record was created. AP30.2 AP30.3
AP30.4 AP32.2
AP40.1 AP40.2
AP45.1
APA-VEN-CLASS Alpha 3 AP10.1 AP10.2
Vendor Class The vendor class the vendor was AP10.3 AP10.5
assigned to at the time the audit record AP10.6 AP30.1
was created. Must be a valid record in AP30.2 AP30.3
the Vendor Class file. AP30.4 AP32.2
AP40.1 AP40.2
AP45.1
APA-LOCATION-CODE Alpha 4 AP10.1 AP10.2
Location Code The alternate vendor location code AP10.5 AP10.6
associated with the audit record. Must AP30.1 AP30.2
be a valid record in the Vendor Location AP30.3 AP30.4
file. AP32.2 AP40.1
AP40.2 AP45.1
APA-OPERATOR Alpha 10 AP10.1 AP10.2
Operator Code The operator associated with the AP10.3 AP10.5
invoice audit record. AP10.6 AP30.1
AP30.2 AP30.3
AP30.4 AP32.2
AP40.1 AP45.1
APA-FIELD-ID Numeric 3 AP10.1 AP10.2
Field ID The value for this field comes from a AP10.3 AP10.5
table in working storage. Indicates the AP10.6 AP30.1
vendor or invoice field that was AP30.2 AP30.3
changed. AP30.4 AP32.2
001 = Vendor Class AP40.1 AP40.2
002 = Vendor Name AP45.1
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
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
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
501 = Invoice Canceled
502 = Process Level
503 = Accrual Code
504 = Voucher Number
505 = Remit-To Code
506 = Purchase Order
507 = Invoice Date
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
528 = Income Withholding Amount
APA-BEFORE-IMAGE Alpha 32 AP10.1 AP10.2
Before Change Image The image of the field before the AP10.5 AP10.6
change. AP30.1 AP30.2
AP30.3 AP32.2
AP40.1 AP40.2
AP45.1
APA-AFTER-IMAGE Alpha 32 AP10.1 AP10.2
After Change Image The image of the field after the AP10.3 AP10.5
change. AP10.6 AP30.1
AP30.2 AP30.3
AP30.4 AP32.2
AP40.1 AP40.2
AP45.1
APA-PRT-STATUS Numeric 1
Print Status This field is not currently used.
APAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APASET1 VENDOR-GROUP This is a unique index used to access AP135 AP40.2
COMPANY audit file records.
PROC-LEVEL KeyChange
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
TRANS-DATE
TRANS-TIME
APASET2 VENDOR-GROUP This index is used to access vendor AP10.1 AP10.2
VENDOR audit records. AP10.3 AP10.5
LOCATION-CODE KeyChange, Subset AP10.6 AP135
TRANS-DATE Where REC-TYPE = "V"
TRANS-TIME
SEQ-NBR
APASET3 COMPANY This index is used to access invoice AP135 AP30.1
PROC-LEVEL audit records. AP30.2 AP30.3
VENDOR KeyChange, Subset AP30.4 AP32.2
INVOICE Where REC-TYPE = "I" AP40.1 AP45.1
SUFFIX
CANCEL-SEQ
TRANS-DATE
TRANS-TIME
SEQ-NBR
APAUDIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When APA-REC-TYPE = "I"
APA-COMPANY -> CPY-COMPANY
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
|