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
| 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. |
|||||||||
| 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. |
|||||||||
| 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. |
|
||||||||
| 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. |
|||||||||
| APA-INVOICE Element: Invoice | Alpha 22 The invoice number associated with the invoice audit record. |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| APA-SEQ-NBR Element: Seq Nbr | Numeric 4 The invoice payment sequence number. |
|||||||||
| APA-TRANS-DATE Element: Trans Date | Numeric 8 (yyyymmdd) The date the audit record was created. |
|||||||||
| APA-TRANS-TIME Element: Sys Time | Numeric 6 (hhmmss) The system time the audit record was created. |
|||||||||
| 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. |
|||||||||
| 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. |
|||||||||
| 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. |
|||||||||
| 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. |
|||||||||
| APA-OPERATOR Element: Operator | Alpha 10 The operator associated with the invoice audit record. |
|||||||||
| 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 |
|||||||||
| APA-BEFORE-IMAGE Element: Before Image | Alpha 32 The image of the field before the change. |
|||||||||
| APA-AFTER-IMAGE Element: Before Image | Alpha 32 The image of the field after the change. |
|||||||||
| APA-PRT-STATUS Element: Print Status | Numeric 1 This field is not currently used. |
|
||||||||
| APA-FIELD-DESC Element: Field Desc | Derived |
|
| 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 |
|
|||||||||||||||||||||||||||||||||||||||
| APASET2 |
VENDOR-GROUP VENDOR LOCATION-CODE TRANS-DATE TRANS-TIME SEQ-NBR |
|
| ||||||||||||||||||||||||||||||||||||||
| APASET3 |
COMPANY PROC-LEVEL VENDOR INVOICE SUFFIX CANCEL-SEQ TRANS-DATE TRANS-TIME SEQ-NBR |
|
| ||||||||||||||||||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Apcompany | APCOMPANY |
Required
| |||||||||||||||
| Apdict | APDICT |
Required
| |||||||||||||||
| Approclev | APPROCLEV |
Required
| |||||||||||||||
| Apvenclass | APVENCLASS |
Not Required
| |||||||||||||||
| Apvengroup | APVENGROUP |
Required
| |||||||||||||||
| Apvenloc | APVENLOC |
Required
| |||||||||||||||
| Apvenmast | APVENMAST |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.