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