Lawson Insight Technical Documentation |
|
APAUDIT
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
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 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 AP15.1 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 AP30.1 AP30.2 AP30.3 AP30.4 AP305
AP40.1 AP40.2 AP45.1 AP510 AP520 AP90.1
AP91.1 API1.1 API2.1 API3.1 API4.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 MX123
MX500 MA180 MA279 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 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 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO220
PO223 PO23.1 PO233 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO253 PO254 PO27.2 PO278
PO29.1 PO30.1 PO30.2 PO30.3 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 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 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APA-VENDOR-GROUP Alpha 4 AC160 AM115
Element: Vendor Group If the audit record is for a vendor, AM117 AM15.1
this field contains the vendor group AM15.2 AM15.3
assigned to the vendor. Must be a valid AM15.4 AM19.1
record in the Vendor Group file. AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 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 AP15.1
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
AP30.1 AP30.2
AP30.3 AP30.4
AP305 AP40.1
...
APA-COMPANY Numeric 4 AC160 AM115
Element: Company If the audit record is for an invoice, AM117 AM15.1
this field contains the company number AM15.2 AM15.3
assigned to the invoice. Must be a valid AM15.4 AM19.1
record in the Accounts Payable Company AM19.2 AM20.1
file. AM20.3 AM21.1
AM21.3 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
AP15.1 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 AP30.1
AP30.2 AP30.3
AP30.4 AP305
AP40.1 AP40.2
...
APA-PROC-LEVEL Alpha 5 AP30.1 AP30.2
Element: Process Level The process level associated with the AP30.3 AP30.4
invoice audit record. Must be a valid AP40.1 AP40.2
record in the Accounts Payable Process AP45.1 MA70.1
Level file. MA75.1
APA-VENDOR Alpha 9 (Right Justified) AC160 AM115
Element: Vendor The vendor number associated with the AM117 AM15.1
audit record. Must be a valid record in AM15.2 AM15.3
the Vendor file. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 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 AP15.1
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
AP30.1 AP30.2
AP30.3 AP30.4
AP305 AP40.1
...
APA-INVOICE Alpha 22 AP30.1 AP30.2
Element: Invoice The invoice number associated with the AP30.3 AP30.4
invoice audit record. AP40.1 AP40.2
AP45.1 MA70.1
MA75.1
APA-SUFFIX Numeric 3 AP30.1 AP30.2
Element: Suffix The invoice suffix number associated AP30.3 AP30.4
with the invoice audit record. A suffix AP40.1 AP40.2
number is assigned by the system to AP45.1 MA70.1
recurring invoices or system-generated MA75.1
credit memos.
APA-CANCEL-SEQ Numeric 4 AP30.1 AP30.2
Element: Seq Nbr The sequence number assigned upon a AP30.3 AP30.4
cancellation of a distributed invoice. AP40.1 AP40.2
The first sequence assigned is 9999. AP45.1 MA70.1
MA75.1
APA-SEQ-NBR Numeric 4 AC160 AM115
Element: Seq Nbr The invoice payment sequence number. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 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 AP15.1
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
AP30.1 AP30.2
AP30.3 AP30.4
AP305 AP40.1
...
APA-TRANS-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Trans Date The date the audit record was created. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 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 AP15.1
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
AP30.1 AP30.2
AP30.3 AP30.4
AP305 AP40.1
...
APA-TRANS-TIME Numeric 6 (hhmmss) AC160 AM115
Element: Sys Time The system time the audit record was AM117 AM15.1
created. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 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 AP15.1
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
AP30.1 AP30.2
AP30.3 AP30.4
AP305 AP40.1
...
APA-REC-TYPE Alpha 1 AC160 AM115
Element: Record Type Indicates the type of audit record. AM117 AM15.1
Valid values are: AM15.2 AM15.3
AM15.4 AM19.1
I = Invoice Audit Record. AM19.2 AM20.1
V = Vendor Audit Record. AM20.3 AM21.1
AM21.3 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 AP15.1
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
AP30.1 AP30.2
AP30.3 AP30.4
AP305 AP40.1
...
APA-VENDOR-SNAME Alpha 30 AC160 AM115
Element: Vendor Name The search name defined for the vendor AM117 AM15.1
in the Vendor file at the time the audit AM15.2 AM15.3
record was created. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 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 AP15.1
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
AP30.1 AP30.2
AP30.3 AP30.4
AP305 AP40.1
...
APA-VEN-CLASS Alpha 3 AC160 AM115
Element: Ven Class The vendor class the vendor was AM117 AM15.1
assigned to at the time the audit record AM15.2 AM15.3
was created. Must be a valid record in AM15.4 AM19.1
the Vendor Class file. AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 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 AP15.1
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
AP30.1 AP30.2
AP30.3 AP30.4
AP305 AP40.1
...
APA-LOCATION-CODE Alpha 4 AC160 AM115
Element: Location Code The alternate vendor location code AM117 AM15.1
associated with the audit record. Must AM15.2 AM15.3
be a valid record in the Vendor Location AM15.4 AM19.1
file. AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 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 AP15.1
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
AP30.1 AP30.2
AP30.3 AP30.4
AP305 AP40.1
AP40.2 AP45.1
AP510 AP520
...
APA-OPERATOR Alpha 10 AC160 AM115
Element: Operator The operator associated with the AM117 AM15.1
invoice audit record. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 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 AP15.1
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
AP30.1 AP30.2
AP30.3 AP30.4
AP305 AP40.1
...
APA-FIELD-ID Numeric 3 AC160 AM115
Element: Field Id The value for this field comes from a AM117 AM15.1
table in working storage. Indicates the AM15.2 AM15.3
vendor or invoice field that was AM15.4 AM19.1
changed. AM19.2 AM20.1
001 = Vendor Class AM20.3 AM21.1
002 = Vendor Name AM21.3 AM500
003 = Vendor Search Name AM51.1 AM551
004 = Vendor Contact AM97.1 AP03.1
005 = Address 1 AP03.2 AP03.3
006 = Address 2 AP10.1 AP10.3
007 = Address 3 AP10.5 AP10.6
008 = Address 4 AP10.7 AP10.9
009 = City/Address 5 AP109 AP11.1
010 = State/Province AP110 AP115
011 = Postal Code AP125 AP126
012 = Country AP131 AP14.1
013 = Normal Remit-To Flag AP14.2 AP14.3
014 = Normal Purchase-From Flag AP14.4 AP15.1
015 = Pay Vendor AP16.1 AP16.2
016 = Vendor Status AP20.1 AP20.2
017 = Vendor Priority AP20.3 AP20.4
018 = Phone Prefix AP20.5 AP20.7
019 = Phone Number AP21.1 AP210
020 = Phone Extension AP220 AP23.1
021 = FAX Prefix AP25.1 AP25.2
022 = FAX Number AP26.1 AP27.1
023 = FAX Extension AP30.1 AP30.2
024 = Telex Number AP30.3 AP30.4
025 = Terms Code AP305 AP40.1
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 Alpha 32 AC160 AM115
Element: Before Image The image of the field before the AM117 AM15.1
change. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 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
AP15.1 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 AP30.1
AP30.2 AP30.3
AP30.4 AP305
AP40.1 AP40.2
...
APA-AFTER-IMAGE Alpha 32 AC160 AM115
Element: Before Image The image of the field after the change. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 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 AP15.1
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
AP30.1 AP30.2
AP30.3 AP30.4
AP305 AP40.1
...
APA-PRT-STATUS Numeric 1
Element: Print Status This field is not currently used.
APAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APASET1 VENDOR-GROUP KeyChange AP135 AP40.2
COMPANY
PROC-LEVEL
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
TRANS-DATE
TRANS-TIME
APASET2 VENDOR-GROUP KeyChange, Subset AC160 AM115
VENDOR Where REC-TYPE = "V" AM117 AM15.1
LOCATION-CODE AM15.2 AM15.3
TRANS-DATE AM15.4 AM19.1
TRANS-TIME AM19.2 AM20.1
SEQ-NBR AM20.3 AM21.1
AM21.3 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
...
APASET3 COMPANY KeyChange, Subset AP135 AP30.1
PROC-LEVEL Where REC-TYPE = "I" AP30.2 AP30.3
VENDOR AP30.4 AP40.1
INVOICE AP45.1 MA70.1
SUFFIX MA75.1
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
|