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
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM20.1 AM20.3 AM21.1 AM21.3 AM500 AM51.1
AM551 AM97.1 AP10.1 AP10.3 AP10.5 AP10.6
AP10.9 AP109 AP11.1 AP115 AP135 AP30.1
AP30.2 AP30.3 AP30.4 AP40.1 AP40.2 AP45.1
AP510 API3.1 API4.1 IC840 MA70.1 MA75.1
PO10.1 PO10.2 PR05.1 PR05.3 PR226 PR247
PR26.1 PR47.1 UK47.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APA-VENDOR-GROUP Alpha 4 AM115 AM117
Element: Vendor Group If the audit record is for a vendor, AM15.1 AM15.2
this field contains the vendor group AM15.3 AM15.4
assigned to the vendor. Must be a valid AM20.1 AM20.3
record in the Vendor Group file. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.3
AP10.5 AP10.6
AP10.9 AP109
AP11.1 AP115
AP30.1 AP30.2
AP30.3 AP30.4
AP40.1 AP40.2
AP45.1 AP510
API3.1 API4.1
IC840 MA70.1
MA75.1 PO10.1
PO10.2 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
APA-COMPANY Numeric 4 AM115 AM117
Element: Company If the audit record is for an invoice, AM15.1 AM15.2
this field contains the company number AM15.3 AM15.4
assigned to the invoice. Must be a valid AM20.1 AM20.3
record in the Accounts Payable Company AM21.1 AM21.3
file. AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.3
AP10.5 AP10.6
AP10.9 AP109
AP115 AP30.1
AP30.2 AP30.3
AP30.4 AP40.1
AP40.2 AP45.1
AP510 API3.1
API4.1 IC840
MA70.1 MA75.1
PO10.1 PO10.2
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
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) AM115 AM117
Element: Vendor ID The vendor number associated with the AM15.1 AM15.2
audit record. Must be a valid record in AM15.3 AM15.4
the Vendor file. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.3
AP10.5 AP10.6
AP10.9 AP109
AP11.1 AP115
AP30.1 AP30.2
AP30.3 AP30.4
AP40.1 AP40.2
AP45.1 AP510
API3.1 API4.1
IC840 MA70.1
MA75.1 PO10.1
PO10.2 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
APA-INVOICE Alpha 22 AP30.1 AP30.2
Element: Invoice NumberThe 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: Invoice SuffixThe 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: Sequence NumbeThe 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 AM115 AM117
Element: Sequence NumbeThe invoice payment sequence number. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.3
AP10.5 AP10.6
AP10.9 AP109
AP11.1 AP115
AP30.1 AP30.2
AP30.3 AP30.4
AP40.1 AP40.2
AP45.1 AP510
API3.1 API4.1
IC840 MA70.1
MA75.1 PO10.1
PO10.2 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
APA-TRANS-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Transaction DaThe date the audit record was created. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.3
AP10.5 AP10.6
AP10.9 AP109
AP11.1 AP115
AP30.1 AP30.2
AP30.3 AP30.4
AP40.1 AP40.2
AP45.1 AP510
API3.1 API4.1
IC840 MA70.1
MA75.1 PO10.1
PO10.2 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
APA-TRANS-TIME Numeric 6 (hhmmss) AM115 AM117
Element: Sys Time The system time the audit record was AM15.1 AM15.2
created. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.3
AP10.5 AP10.6
AP10.9 AP109
AP11.1 AP115
AP30.1 AP30.2
AP30.3 AP30.4
AP40.1 AP40.2
AP45.1 AP510
API3.1 API4.1
IC840 MA70.1
MA75.1 PO10.1
PO10.2 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
APA-REC-TYPE Alpha 1 AM115 AM117
Element: Record Type Indicates the type of audit record. AM15.1 AM15.2
Valid values are: AM15.3 AM15.4
AM20.1 AM20.3
I = Invoice Audit Record. AM21.1 AM21.3
V = Vendor Audit Record. AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.3
AP10.5 AP10.6
AP10.9 AP109
AP11.1 AP115
AP30.1 AP30.2
AP30.3 AP30.4
AP40.1 AP40.2
AP45.1 AP510
API3.1 API4.1
IC840 MA70.1
MA75.1 PO10.1
PO10.2 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
APA-VENDOR-SNAME Alpha 30 AM115 AM117
Element: Vendor Name The search name defined for the vendor AM15.1 AM15.2
in the Vendor file at the time the audit AM15.3 AM15.4
record was created. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.3
AP10.5 AP10.6
AP10.9 AP109
AP11.1 AP115
AP30.1 AP30.2
AP30.3 AP30.4
AP40.1 AP40.2
AP45.1 AP510
API3.1 API4.1
IC840 MA70.1
MA75.1 PO10.1
PO10.2 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
APA-VEN-CLASS Alpha 3 AM115 AM117
Element: Vendor Class The vendor class the vendor was AM15.1 AM15.2
assigned to at the time the audit record AM15.3 AM15.4
was created. Must be a valid record in AM20.1 AM20.3
the Vendor Class file. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.3
AP10.5 AP10.6
AP10.9 AP109
AP11.1 AP115
AP30.1 AP30.2
AP30.3 AP30.4
AP40.1 AP40.2
AP45.1 AP510
API3.1 API4.1
IC840 MA70.1
MA75.1 PO10.1
PO10.2 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
APA-LOCATION-CODE Alpha 4 AM115 AM117
Element: Location Code The alternate vendor location code AM15.1 AM15.2
associated with the audit record. Must AM15.3 AM15.4
be a valid record in the Vendor Location AM20.1 AM20.3
file. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.5
AP10.6 AP10.9
AP109 AP115
AP30.1 AP30.2
AP30.3 AP30.4
AP40.1 AP40.2
AP45.1 AP510
API3.1 API4.1
IC840 MA70.1
MA75.1 PO10.1
PO10.2 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
APA-OPERATOR Alpha 10 AM115 AM117
Element: Operator Code The operator associated with the AM15.1 AM15.2
invoice audit record. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.3
AP10.5 AP10.6
AP10.9 AP109
AP11.1 AP115
AP30.1 AP30.2
AP30.3 AP30.4
AP40.1 AP45.1
AP510 API3.1
API4.1 IC840
MA70.1 MA75.1
PO10.1 PO10.2
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
APA-FIELD-ID Numeric 3 AM115 AM117
Element: Field ID The value for this field comes from a AM15.1 AM15.2
table in working storage. Indicates the AM15.3 AM15.4
vendor or invoice field that was AM20.1 AM20.3
changed. AM21.1 AM21.3
001 = Vendor Class AM500 AM51.1
002 = Vendor Name AM551 AM97.1
003 = Vendor Search Name AP10.1 AP10.3
004 = Vendor Contact AP10.5 AP10.6
005 = Address 1 AP10.9 AP109
006 = Address 2 AP11.1 AP115
007 = Address 3 AP30.1 AP30.2
008 = Address 4 AP30.3 AP30.4
009 = City/Address 5 AP40.1 AP40.2
010 = State/Province AP45.1 AP510
011 = Postal Code API3.1 API4.1
012 = Country IC840 MA70.1
013 = Normal Remit-To Flag MA75.1 PO10.1
014 = Normal Purchase-From Flag PO10.2 PR05.1
015 = Pay Vendor PR05.3 PR226
016 = Vendor Status PR247 PR26.1
017 = Vendor Priority PR47.1 UK47.1
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
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 AM115 AM117
Element: Before Change The image of the field before the AM15.1 AM15.2
change. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.5
AP10.6 AP10.9
AP109 AP11.1
AP115 AP30.1
AP30.2 AP30.3
AP40.1 AP40.2
AP45.1 API3.1
API4.1 IC840
MA70.1 MA75.1
PO10.1 PO10.2
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
APA-AFTER-IMAGE Alpha 32 AM115 AM117
Element: Before Change The image of the field after the change. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.3
AP10.5 AP10.6
AP10.9 AP109
AP11.1 AP115
AP30.1 AP30.2
AP30.3 AP30.4
AP40.1 AP40.2
AP45.1 AP510
API3.1 API4.1
IC840 MA70.1
MA75.1 PO10.1
PO10.2 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.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 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 AM115 AM117
VENDOR audit records. AM15.1 AM15.2
LOCATION-CODE KeyChange, Subset AM15.3 AM15.4
TRANS-DATE Where REC-TYPE = "V" AM20.1 AM20.3
TRANS-TIME AM21.1 AM21.3
SEQ-NBR AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.3
AP10.5 AP10.6
AP10.9 AP109
AP11.1 AP115
AP135 AP510
API3.1 API4.1
IC840 PO10.1
PO10.2 PR05.1
...
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 AP40.1
INVOICE Where REC-TYPE = "I" 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
|